Databases
Microsoft SQL server
Microsoft Azure
Microsoft Analytics platform system
Microsoft Access
Oracle
Teradata
Sybase
Informix
IBM DB2
OLEDB/ODBC
THE ABOVE DATABASES ARE EXPLAINED AS FOLLOWS
🗄️ Relational Database Management Systems (RDBMS)
These are traditional databases designed for structured data and SQL queries.
Microsoft SQL Server – Enterprise-grade RDBMS from Microsoft, widely used for transactional systems and analytics.
Oracle Database – One of the most powerful and feature-rich RDBMS, often used in mission-critical enterprise applications.
IBM Db2 – IBM’s relational database, strong in enterprise workloads and analytics.
Teradata – Specialized in large-scale data warehousing and analytics.
Sybase (SAP ASE) – Once popular for financial services, now maintained by SAP.
Informix – IBM-owned database, known for OLTP and embedded database solutions.
Microsoft Access – Lightweight desktop database, good for small-scale applications but not enterprise-level.
☁️ Cloud & Analytics Platforms
These extend beyond traditional databases into cloud and big data.
Microsoft Azure – Cloud platform offering multiple database services (Azure SQL Database, Cosmos DB, Synapse Analytics, etc.).
Microsoft Analytics Platform System (APS) – A data warehouse appliance (formerly Parallel Data Warehouse) for large-scale analytics.
🔌 Connectivity Standards
These are not databases themselves but interfaces to connect applications with databases.
OLE DB (Object Linking and Embedding, Database) – Microsoft API for accessing data from different sources.
ODBC (Open Database Connectivity) – Standard API for database access, widely supported across platforms.
📊 Quick Comparison Table
| Category | Examples | Typical Use |
|---|---|---|
| RDBMS | SQL Server, Oracle, Db2, Teradata, Sybase, Informix, Access | Transactional systems, analytics, enterprise apps |
| Cloud/Analytics | Azure, APS | Cloud-native databases, big data, warehousing |
| Connectivity | OLE DB, ODBC | Middleware to connect applications to databases |
Comments
Post a Comment