On-premise and cloud computing are two different ways of storing data and running services. On-premise solutions are hosted in-house by your company, while cloud solutions are hosted by another company.
- On-premise solutions give you more control and customization, but require more maintenance and support.
- Cloud solutions offer more scalability and cost-effectiveness, but depend on internet access and service provider’s servers.
| According to a report, the results for the leading vendors continue to demonstrate the enormous forces wrought by the transition to cloud-based systems. Cloud platform providers lead the way, and continue to make gains based on their performance there. |
|
| Database Management System Products by Vendor | |||||
|---|---|---|---|---|---|
| Vendor | Products | ||||
| RDBMS (relational) |
ORDBMS (object-relational) |
OODBMS (object-oriented) |
NoSQL | Comments | |
| Oracle | Oracle 7.x | Oracle 8i – 23ai | Oracle NoSQL Database | i: Internet; g: grid; c: cloud | |
| PostgreSQL | PostgreSQL | NoSQL-like capabilities | Open source; the original version developed at the University of California at Berkeley | ||
| MySQL AB | MySQL | MySQL Document Store and MySQL NDB Cluster | Open source; over 100 million downloads; owned by Oracle now | ||
| Microsoft | Access SQL Server |
Azure Cosmos DB | |||
| SAP (Sybase) | Adaptive Server Enterprise (ASE) | SAP HANA | SAP SQL Anywhere (mobile db) | ||
| Informix | Dynamic Server | Universal Server (Illustra) (dropped) |
Informix Standard Edition (embedded db). Informix is a division of IBM now. |
||
| IBM | DB2 | DB2 (previously known as Universal Database) |
NoSQL capabilities | DB2 Everywhere (embedded db) | |
| Firebase; Cloud Datastore; Bigtable | |||||
| MongoDB | MongoDB | ||||
| Apache CouchDB | CouchDB | developed by the Apache Software Foundation | |||
| UniSQL | UniSQL6 | Acquired by a Korean company | |||
| Unisys | OSMOS (dropped) | ||||
| Computer Associates | IDMS | Jasmine (dropped) | |||
| GemTalk Systems | GemStone/S | Based on Smalltalk | |||
| O2 | O2 | Out of business | |||
| There are some things you learn best in calm, and some in storm. |