A relational database is a type of database that organizes data points with defined relationships for easy access. In the relational database model, the data structures-- data tables, indexes and ...

Spread the loveWhen you hear the word “database,” what comes to mind? For many, it’s a labyrinth of SQL queries, complex ...

Airtable is an online platform for creating, using, and sharing small relational databases. It’s not ready for enterprise users yet (that’s coming), but right now, if you want help managing data for ...

Designing an appropriate set of indexes can be one of the more troubling aspects of developing efficient relational database applications. Perhaps, the most important thing you can do to assure ...

Excel used to be the poor schmuck’s database, with spreadsheets that just sort of sat there. You could create something more sophisticated with LOOKUP functions, but they were a huge hassle to set up.

For the most part, you're probably accustomed to using Microsoft Excel for tasks such as preparing reports, forecasts, and budgets. However, Excel is much more powerful than that. It can be used to ...

Jeff Carpenter is a technical evangelist at DataStax. The past 10 years have seen the explosive growth of large-scale distributed systems. This trend has produced a whirlwind of creativity in the ...

SQL Server's OpenJson function will let you dismantle JSON structures into relational tables, including tables with foreign/primary key relationships. As I noted in an earlier column, JSON is great ...

While relational databases rely on rigid structures, document databases are much more natural to work with and can be used for a variety of use cases across industries. A document database (also known ...

Companies across every industry increasingly understand that making data-driven decisions is a necessity to compete now, in the next five years, in the next 20 and beyond. Data growth — unstructured ...