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

JSON has stolen some of XML's thunder with features such as human and machine readability, a lightweight, compact text structure and support for many software and hardware platforms. JSON (JavaScript ...

Every day, businesses depend on data to operate. Customer orders, quotes for new business, conversations around products, campaigns for marketing—pretty much every business process today is based on ...

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 remains the backbone of enterprise data access. Despite the rise of dashboards, semantic layers, and AI-driven analytics, ...

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