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

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Relational database management systems (RDBMS) rely on an optimizer (or relational optimizer) that transforms SQL statements into executable code. Before any SQL statement can be run by the RDBMS, the ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Vivek Yadav, an engineering manager from ...

Relational databases store information in strictly regulated tables and columns. MongoDB is a document store, which stores information in collections and documents. The primary difference here is that ...

Learn the key differences between relational and NoSQL databases with this in-depth comparison. There’s nothing wrong with the traditional relational database management system. In fact, many NoSQL ...

With the proliferation of XML as a new common data format, the problem of managing XML documents has become more critical. New technologies are now available that allow organizations to better manage ...

Even with all the hype around NoSQL, traditional relational databases still make sense for enterprise applications. Here are four reasons why. Dave Rosenberg Co-founder, MuleSource Dave Rosenberg has ...

Are vendor claims that big data, IoT and NoSQL killed RDBMS credible? Nothing is that simple in the enterprise data center. I recently received a promotional message from a PR representative of a ...