1 / 22

CPSC-608 Database Systems

CPSC-608 Database Systems. Fall 2010. Instructor: Jianer Chen Office: HRBB 315C Phone: 845-4259 Email: chen@cse.tamu.edu. Notes 1. large volume of data. users. database system. where do we store them?. large volume of data. users. database system. in secondary storage.

marty
Download Presentation

CPSC-608 Database Systems

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CPSC-608 Database Systems Fall 2010 Instructor: Jianer Chen Office: HRBB 315C Phone: 845-4259 Email: chen@cse.tamu.edu Notes 1

  2. large volume of data users database system

  3. where do we store them? large volume of data users database system

  4. in secondary storage users database system secondary storage (disks)

  5. how are the data organized? users database system secondary storage (disks)

  6. in tables (relations) users database system secondary storage (disks)

  7. how do we define relations? in tables (relations) users database system secondary storage (disks)

  8. in tables (relations) users database system database administrator DDL language secondary storage (disks)

  9. how do we manipulate relations? in tables (relations) users database system database administrator DDL language secondary storage (disks)

  10. in tables (relations) database system database administrator DDL language database programmer DML (query) language secondary storage (disks)

  11. in tables (relations) database management system database administrator DDL language database programmer DML (query) language simply translate database programs into machine programs secondary storage (disks)

  12. in tables (relations) database management system database administrator DDL language database programmer DML (query) language simply translate database programs into machine programs secondary storage (disks) then what is the difference between DBMS and a programming language compiler?

  13. 1. it has to deal with data stored in hierarchical memory structures in tables (relations) database administrator DDL language file manager database programmer buffer manager DML (query) language main memory buffers secondary storage (disks) DBMS then what is the difference between DBMS and a programming language compiler?

  14. 2. it has to support efficient manipulations of data in hierarchical memory structures in tables (relations) database administrator DDL language file manager database programmer index/file manager buffer manager DML (query) language main memory buffers secondary storage (disks) DBMS then what is the difference between DBMS and a programming language compiler?

  15. 3. it needs to translate the input database program into an internal representation in tables (relations) database administrator DDL complier DDL language file manager database programmer index/file manager buffer manager DML (query) language DML complier main memory buffers secondary storage (disks) DBMS then what is the difference between DBMS and a programming language compiler?

  16. 4. it needs to produce efficient internal codes dealing with data in hierarchical memory structure in tables (relations) database administrator DDL complier DDL language file manager database programmer index/file manager buffer manager DML (query) language query execution engine DML complier main memory buffers secondary storage (disks) DBMS then what is the difference between DBMS and a programming language compiler?

  17. in tables (relations) 5. it needs to be consistent database administrator lock table DDL complier DDL language file manager concurrency control transaction manager database programmer index/file manager buffer manager DML (query) language query execution engine DML complier main memory buffers secondary storage (disks) DBMS then what is the difference between DBMS and a programming language compiler?

  18. in tables (relations) 6. it needs to be reliable database administrator lock table DDL complier DDL language file manager logging & recovery concurrency control transaction manager database programmer index/file manager buffer manager DML (query) language query execution engine DML complier main memory buffers secondary storage (disks) DBMS then what is the difference between DBMS and a programming language compiler?

  19. in tables (relations) database administrator lock table DDL complier DDL language file manager logging & recovery concurrency control transaction manager database programmer index/file manager buffer manager DML (query) language query execution engine DML complier main memory buffers secondary storage (disks) DBMS

  20. in tables (relations) database administrator lock table DDL complier DDL language file manager logging & recovery concurrency control transaction manager database programmer index/file manager buffer manager DML (query) language query execution engine DML complier main memory buffers secondary storage (disks) DBMS undergraduate database

  21. in tables (relations) database administrator lock table DDL complier DDL language file manager logging & recovery concurrency control transaction manager database programmer index/file manager buffer manager DML (query) language query execution engine DML complier main memory buffers secondary storage (disks) DBMS graduate database

  22. in tables (relations) database administrator lock table DDL complier DDL language file manager logging & recovery concurrency control transaction manager database programmer index/file manager buffer manager DML (query) language query execution engine DML complier main memory buffers secondary storage (disks) DBMS graduate database

More Related