DATABASE DESIGN
Overview of DB Processing
Outline

DATABASE DESIGN
Overview of DB Processing
"Why Database ?"

DATABASE DESIGN
Overview of DB Processing
File Processing Systems

Accounting Information Systems

DATABASE DESIGN
Overview of DB Processing
File Processing Systems

Production Information Systems

DATABASE DESIGN
Overview of DB Processing
Database Processing Systems

Business Functional Area Systems

DATABASE DESIGN
Overview of DB Processing
ERP Systems

Enterprise Resource Planning Systems

DATABASE DESIGN
Overview of DB Processing
Information Mgmt. Systems

DATABASE DESIGN
Overview of DB Processing
Database Definitions

Bit

Byte = Character

Field

Record

File

Database

A DBMS is a complex computer program that acts as a data librarian, supervising the transfer of data between the end user and the database.

DATABASE DESIGN
Overview of DB Processing
Sources of DBMS Development

DATABASE DESIGN
Overview of DB Processing
Sources of DBMS Development

DATABASE DESIGN
Overview of DB Processing
Brief History of DBMS

1964: NASA's Apollo moon project led to the development of GUAM (Generalized Update Access Method) by IBM

1966: IBM released the first commercially avail-able DBMS - IMS (Information Management System) based on the hierarchical data model

1967: GE developed IDS (Integrated Data System) based on the network data model; later, Honeywell produced IDS-2

1969: CODASYL Database Task Group Report set standards for network database products

1970: Dr. E. F. Codd, IBM researcher, proposed the relational data model in theoretical paper

DATABASE DESIGN
Overview of DB Processing
Brief History of DBMS

1970s: Proliferation of hierarchical and network model products and installations

1976: IBM (San Jose Research Lab) developed a relational model prototype - System R

1977: Larry Ellison founded Oracle Corp.

1981: IBM released first commercially available DB product based on the relational model - SQL/DS (Structured Query Language / Data System) for its mainframes (interactive OS)

1981: IBM brought PCs to market

1981: Ashton-Tate released dBase II for micros

DATABASE DESIGN
Overview of DB Processing
Brief History of DBMS

1982: IBM produced DB2 (SQL-based) for its mainframes with batch operating system

1983: Microrim created R:BASE based on NASA's mainframe product RIM using SQL

1985: ANSI adopted SQL as the query language standard

1987: Borland produced Paradox

1991: Borland bought Ashton-Tate (dBase)

1992: Microsoft bought Fox Pro Software

1993: Microsoft released Access

1994: SAP R/3 for client/server environment

1996: Chico State becomes SAP's first university partner

DATABASE DESIGN
Overview of DB Processing
Advantages

DATABASE DESIGN
Overview of DB Processing
Advantages

DATABASE DESIGN
Overview of DB Processing
Disadvantages

DATABASE DESIGN
Overview of DB Processing
Disadvantages

DATABASE DESIGN
Overview of DB Processing
Major Functions of a DBMS