Whether you pronounce it "S-Q-L" or "sequel," we interact with SQL, NoSQL, or NewSQL in one way or another everyday, but what exactly is the difference between them? The fact of the matter is that, although they're all types of databases, each one is very different...
Showcasing popular databases in the Database 101 series was meant to provide an introduction to database information and also XTIVIA's exceptional database services. With the introductions out of the way, we'd like to share a little bit about our company and what we...
MongoDB is a document-oriented NoSQL database that uses the Binary Serialization Object Notation (BSON) file format — similar to JavaScript Object Notation (JSON) — for versatile structuring and easy database storage. MongoDB has been popularly used by companies...
Commonly referred to as "Postgres," PostgreSQL is a free open source object-relational database management system (ORDBMS) with an interface for creating fail-safe environments and committed to preserving data integrity. Since its initial release in 1996, Postgres has...
IBM's Db2 (previously DB2 up until 2017) is a popular Relational Database Management System used by businesses of all sizes in the computer software and IT service industries. Originally developed for the relational model, IBM has extended Db2's support to...
Informix is an RDBMS, coincidentally started its life from a company by the name of Relational Database Systems or RDS. The database product was acquired by IBM in 2001 and is now fondly referred to as IBM Informix. Informix is ideal for situations where minimal...
For more than two decades, MySQL has been a staple of the open-source database community. As a brainchild of the database greats, David Axmark, and Michael Widenius, MySQL has been a prominent database choice for millions of users since the mid-90s. MySQL is a free...
Oracle is another popular database the Virtual-DBA team supports. With more than 310,000 businesses in 175 different countries using Oracle Database — many of them on the Fortune 100 list — it's one of the most widely used databases in the world. Oracle Database...
In case you missed the first post with the Database Glossary of Terms, you can see it here. Here are some popular databases that the Virtual-DBA team supports along with some feature or terminology highlights (usually relative to the most recent version of said...
This series is designed to be a database reference guide, covering databases from the very beginning. We're calling it Database 101. There will be eight sections in this series. Part 1: Database Glossary of Terms Let's start with some background for people who know...