Five Database Technology 'Faceoffs' Explained

1 | 2 | 3 | 4 | 5 | 6 | 7
Next Five Database Technology 'Faceoffs' Explained-2 Next

While technology has rapidly evolved over the past 40 years, the database systems that store and analyze our data are based off of algorithms that are decades old. SQL (Structure Query Language) is a special-purpose programming language meant for managing data held in relational database management systems (RDMBS). SQL was one of the first commercial languages created for RDMBS and has become the most used language, beginning in the late 1980s, through modern day. SQL works on a relational model, which separates data into interrelated tables of rows and columns. When data need to be retrieved from a relational database, they must be collected from multiple tables that are organized in a defined schema.

NoSQL, on the other hand, is a query language that became popular in the late 2000s, and is a model that aggregates data based on a defined key or value formula. NoSQL does not use a schema, making the data easier to retrieve. Just because NoSQL is different, however, does not necessarily mean it is better: since it does not use a schema, NoSQL cannot handle highly complex data sets as easily as SQL.

What more and more companies are realizing is that there is often a need for both technologies. Organizations are increasingly looking for solutions that can handle both relational and non-relational models.

Database technologies are rapidly evolving to a degree where it can be difficult to keep up with the newest solutions and buzzwords, let alone distinguish one from another. Looking for the right solution can be especially challenging when IT vernacular is constantly putting terms at odds. There are countless “this-or-that” conversations in database technology. In this slideshow, Kurt Dobbins, CEO of Deep Information Sciences, takes a look at a few of the most common faceoffs.  


Related Topics : IBM Looks to Redefine Industry Standard Servers, APC, Brocade, Citrix Systems, Data Center

More Slideshows

HCI 10 Reasons Why the Enterprise Is Turning to Hyperconverged Infrastructure

While HCI is certainly innovative in design, its true measure lies in the practical benefits it brings to data center management and operations. ...  More >>

DataM63-290x195 Data Storage Today: Key Takeaways from VMworld 2016

Survey findings include pain points for secondary storage, average restore times, the growth of hyperconvergence and rate of cloud adoption in enterprises.  ...  More >>

cloud51-190x128 5 Best Practices for Managing Zombie Cloud Infrastructure

IT administrators need to identify zombie assets, verify idle status and shut off anything that is unused. Here's how to get your dormant infrastructure back in shape. ...  More >>

Subscribe Daily Edge Newsletters

Sign up now and get the best business technology insights direct to your inbox.