We look at how to gain structure from unstructured data, via AI/ML analytics to create new records, selecting object data via SQL and storing unstructured files in NoSQL formats.

The SQL/NoSQL debate is principally focused on whether it is better to continue adherence to the SQL database structure, with which manufacturers are most familiar, or hitch our wagons to the NoSQL ...

Interestingly, representation features that aid in communicating the contents of a database appear to hinder the learning of the SQL query language. We conclude that database representation is an ...

We look at alternatives to relational databases that have emerged to help bring some structure to unstructured data and gain valuable insight by making it semi-structured.

SQL has dominated data querying for decades. Newer query languages offer more elegance, simplicity, and flexibility for modern use cases.

As promised in part one, I developed a Visual Basic program to generate a SQL script that clears all the data from a SQL Server database (See Code Download for full source code and executable). The ...