CS-GY 6083: Principles of Database Systems
1.0.0
1.0.0
  • 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
  • 1950s and early 1960s
  • Late 1960s and 1970s
  • 1980s
  • 1990s
  • Early 2000s
  • Late 2000s

Was this helpful?

DBMS History

1950s and early 1960s

  • Data processing was using magnetic tapes for storage. However, tapes provide only sequential access

  • Punched cards were used for input

Late 1960s and 1970s

  • Hard disks started being used and they allowed direct access to data

  • Network and hierarchical data models were in widespread use

  • Edward Codd defined the relational data model and later won the ACM Turing Award for this work

  • IBM Research begun the System R prototype and UC Berkeley begun Ingres prototype

  • High-performance transaction processing was introduced

1980s

  • Research relational prototypes evolved into commercial systems

  • SQL became industrial standard

  • Parallel and distributed database systems were used

  • Object-oriented database systems were introduced

1990s

  • Large decision support and data-mining applications were developed along with large multi-terabyte data warehouses

  • The emergence of web commerce and web search engines led to the development of data storage structures and database systems to support web search data

Early 2000s

  • XML and XQuery became standards

  • Automated database administration was introduced

Late 2000s

  • Giant data storage systems were introduced, such as BigTable (Google), Hbase (Apache), PNuts (Yahoo!), Dynamo (Amazon), Cassandra (Facebook), Voldemort (LinkedIn)

  • Distributed processing frameworks like MapReduce (Hadoop), Pig (Yahoo!), Dryad (MSFT), etc were introduced

PreviousDatabase ArchitectureNextSome Popular Database Systems

Last updated 5 years ago

Was this helpful?