CS-GY 6083: Principles of Database Systems
main
main
  • Introduction
  • DBMS Basics
    • Introduction to DBMS
    • Why use a DBMS instead of a File System?
    • Levels of Abstraction
    • Instances and Schemas
  • Data Models
    • Introduction to Data Models
    • Database Languages
    • Database Design
  • DBMS Internals
    • Introduction to DBMS Internals
    • Storage Manager
    • Query Processor
    • Transaction Management
    • Database Users
    • Database Architecture
  • DBMS History
  • Some Popular Database Systems
  • OLTP, OLAP, and Data Mining
  • Databases vs. Information Retrieval
  • The Entity-Relationship Model - Details
    • Introduction
    • Cardinality Constraints
    • ER Diagram Components
    • ER Diagram to Relational Schema
    • Design Issues
  • The Relational Model - Details
    • Relations
    • Keys
    • Relational Query Languages
      • Relational Algebra
      • Relational Calculus
      • Relative Expressive Power
    • Relational Operators
  • SQL
    • Introduction to SQL
    • Domain Types in SQL
    • DDL Commands
      • Creating a Table
      • Alter and Drop
    • DML Commands
      • Basic Query Structure
      • Select
      • From
      • Where
      • Joins
      • Rename
      • String Operations
      • Ordering
      • Set Operations
      • Group By and Having
      • Nested Subqueries
      • Test for Empty Relations
      • Test for Duplicate Tuples
      • Derived Relations
      • With
      • Database Modification
    • Intermediate SQL
      • Joins Revisited
      • Views
      • Transactions
      • Integrity Constraints
      • More SQL Data Types and Schemas
        • Other Features
      • Authorization
    • Advanced SQL
      • Accessing SQL From a Programming Language
        • ODBC and JDBC
        • Embedded SQL
        • PHP
        • Some Security Issues
      • Accessing Metadata
      • Text Operations
        • Like
        • Contains
      • Cursors
      • Functions and Procedures
        • Procedural Constructs
        • External Language Routines
      • Triggers
      • Ranking
      • Windowing
      • OLAP
Powered by GitBook
On this page

Was this helpful?

Some Popular Database Systems

There are some big, expensive, enterprise database systems like Oracle, IBM DB2 Universal Database, Sybase etc.

They have lots of features, work on multiple platforms and can scale to multiple machines.

There are other database systems like MySQL Server that have lots of features and decent performance, but are relatively cheaper. However, MySQL Server only runs on Windows platform.

On the other hand, there are systems like MS Access that are cheap, easy to use but have limited functionality.

The following are some open-source database systems:

  • MySQL

    • Limited SQL, not good for OLAP

    • Limited transaction support but fast lookups

    • Extremely widely used, e.g., web servers (Linux Apache MySQL PHP - LAMP)

  • PostgreSQL

    • Rich SQL features, decent query optimizer

    • Not as widely used but popular in academia

  • SQLite

    • SQL transactional DB

    • server-less

    • self-contained

    • zero-configuration

  • Berkeley DB

    • No SQL support

    • Embedded database, a few hundred KB size

    • Basically a library of disk-based data structures with support for transactions

  • MapReduce, BigTable, PNuts, Dynamo, and others

    • No SQL support

    • Used for data and text analysis (search engines etc) or to keep live data

PreviousDBMS HistoryNextOLTP, OLAP, and Data Mining

Last updated 4 years ago

Was this helpful?