A question asked about data contained in two or more tables in a relational database. The relational query must specify the tables required and what the condition is that links them; for example, ...

Ryan Betts is CTO at VoltDB. Recently Max Schireson, CEO of MongoDB, shared his thoughts on relational databases. His statements deserve a direct and frank opposing response. Let’s walk through the ...

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 ...

If your business uses relational databases to store data, it helps to use the SQL SELECT command with the INTO clause to create new tables from query results. This method isn't ANSI-standard SQL, but ...

Indexing is a critical part of database optimization. Indexing can dramatically increase query speed. However, DBAs still struggle with finding optimal indexes or optimal SQL plans. DBTA held a ...

SQL remains the backbone of enterprise data access. Despite the rise of dashboards, semantic layers, and AI-driven analytics, ...

The articles on NoSQL databases in Reuven M. Lerner's At the Forge column appearing in recent issues of LJ have been enjoyable. Because this is the Enterprise issue, I think it would be helpful to ...

The Internet of Things is creating serious new security risks. We examine the possibilities and the dangers. Read now Fifty years ago, relational databases were neither ubiquitous nor standardized.

SQL has dominated data querying for decades. Newer query languages offer more elegance, simplicity, and flexibility for modern use cases. For the last three decades, databases and Structured Query ...