A database that maintains a set of separate, related files (tables), but combines data elements from the files for queries and reports when required. The concept was developed in 1970 by Edgar Codd, ...

The relational database so dominates the thinking of information technology and business professionals that its presumed suitability for essentially all data management tasks is rarely questioned. But ...

Have you noticed that relational "technology" seems to be taking a beating these days? With new “data models” and types of database systems purported to be better than relational, it seems that the ...

The market is abuzz with terms like NoSQL, Big Data, NewSQL, Database Appliance, etc. Often, IT decision makers can get very confused with all the noise. They do not understand why they should ...

In this module we will take a deeper look into the internals of DBMS software to better understand how it works. We will examine the role of the DBA (Database Administrator), the Data Scientist, the ...

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

Visual DB today announced a new partnership with SQLite, the embedded relational database engine used in billions of devices ...

The data explosion demands new solutions, yet the hoary old RDBMS still rules. Here's where you really shouldn't use it I am a NoSQLer and a big data guy. That’s a nice coincidence, because as you may ...

One of the trickiest aspects of relational database management can be dealing with missing information. The standard method of representing missing information is to set the “value” to null. A null ...

This post is one of a series that introduces the fundamentals of NOSQL databases, and their role in Big Data Analytics. What are wide column stores? Wide column stores are database management systems ...