Database Systems We Considered

Although you saw in the my previous article that there are standards for SQL, that is not to say that all DBMSs are the same. The Web site DB-Engines collects and presents information on DBMSs and provides a monthly listing of them, ranked by their current popularity, at this link.

For many months now, their rankings have presented six DBMSs as consistently the most popular, listed in alphabetical order here (the versions that we used for our testing are in parentheses):

  1. IBM DB2 (DB2 for Linux, UNIX, and Windows v10.5.700.368)
  2. Microsoft Access (Microsoft Access 2007—also compatible with versions 2010, 2013, 2016, and later)
  3. Microsoft SQL Server (Microsoft SQL Server 2012—11.0.5343.0 or 2017)
  4. MySQL or MariaDb (MySQL Community Server 5.7.11 or 10)
  5. Oracle Database (Oracle Database 11g Express Edition Release or 12c)
  6. PostgreSQL (PostgreSQL 9.5.2)

That does not mean that the material presented in this blog will not work on a DBMS not in that list of six. It simply means that we have not tested the material on other DBMSs or for different versions of the DBMSs listed. As you read my blog, you will see that we have included advice (as Notes) when it is necessary to make changes. Those Notes apply only to the six DBMSs listed here. If you are using a different DBMS, check your documentation for compliance if you run into issues with any of our samples. Reead this blog to choosing database for your project.


Вас заинтересует / Intresting for you:

Introduction to NoSQL Database...
Introduction to NoSQL Database... 1916 views sepia Tue, 12 Jun 2018, 18:51:49
The Evolution of Digital Media...
The Evolution of Digital Media... 1608 views Akmaral Sat, 03 Feb 2018, 16:47:36
Services Applicable to DBaaS
Services Applicable to DBaaS 1862 views Akmaral Wed, 09 May 2018, 08:14:34
NoSQL case studies: overview o...
NoSQL case studies: overview o... 4904 views Светлана Комарова Sat, 13 Mar 2021, 09:42:48