1 / 26

Enhancing Data Management with Efficient DBMS Technology

Explore the world of Data Processing Technology, Database Management Systems (DBMS), and Data Access Methods. Learn about the components of DBMS, taxonomy, processing methods, and future trends in database management. Discover the benefits and challenges of DBMS and delve into the Client/Server architecture, improving data management efficiency and security. Stay ahead in the realm of data processing with this comprehensive guide.

machiko-rin
Télécharger la présentation

Enhancing Data Management with Efficient DBMS Technology

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. Data Processing Technology

  2. Contents • Data Process • Database Management System (DBMS) • Client/Server DBMS

  3. Data Hierarchy • Bit:0,1 • Byte: • 英文 (1 byte) • 中文 (2 bytes) • 整數 (4 bytes) • Field • Record • File • Database • Data warehouse

  4. Types of files • Master file • Transaction file • Index file • Report file • Multimedia file • Others

  5. Data Access Method • Sequential access • Random access • Complete Balanced tree (B-tree) • Hashing

  6. B-tree index

  7. B-tree • 優點:快 • 缺點:增減需重建

  8. Hash Function • 最快 • 刪除後之空間無法用

  9. Data Processing Method • Batch • The processing of data or the accomplishment of jobs accumulated in advance in such a manner that the user cannot further influence the processing. • On-line • Pertaining to the operation of a functional unit when under the direct control of a computer.

  10. Batch Process

  11. On-line pocessing(線上) • CPU 直接控制週邊設備

  12. On-line Process

  13. Real time(即時) • 即時作業:指令送達CPU , 則立刻處理 • Ex. 工廠控制系統，ATM，訂票系統, etc..

  14. Real tine process

  15. Database Management System(DBMS) • Problems with Flat files • Data redundancy • Data integrity • Data dependancy • flexiblity

  16. Taxonomy of DBMS • Hierarchy structure • Network structure • Relational structure

  17. Tree structure

  18. Network structure

  19. Relation structure

  20. Components of DBMS • DDL(Data Definition Language) • A language used to define the physical characteristics of each record:the fields within the record, and each field’s logical name, data type and length. • DML(Data Manipulation Language) • A language used to define operations on a database such as retrieval, storing, sorting, and updating of records.

  21. DML功能 • 操作DB之基本指令 • 與HLL 配合 • 免除實體程式寫作 • Report support

  22. DBMS Structure

  23. DBMS • 優點: • 避免資料重覆 • 程式, 資料分離 • 資料安全性增加 • 改善UI • 彈性報表製作 • 缺點 • 速度降 • HW要求較高 • 各品牌 DBMS 語法有異

  24. Future Trend of DBMS • Object-oriented DBMS • Data Warehouse

  25. Section 3. Client/Server DBMS • Components • Client Computer • Server • Network

  26. Server DBMS • OS compatibility • Communication Channel • Lock • Security • Open System • Graphics Interface • Format Transformation

More Related