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

CategoryExamplesTypical Use
RDBMSSQL Server, Oracle, Db2, Teradata, Sybase, Informix, AccessTransactional systems, analytics, enterprise apps
Cloud/AnalyticsAzure, APSCloud-native databases, big data, warehousing
ConnectivityOLE DB, ODBCMiddleware to connect applications to databases


Comments

S/W H/W Electrical Engineering

RANADHEER IN MEDICAL

Ranadheer Engineering Technology

JNTUH

Languages uses

Agenitc AI-AI Tools