260 likes | 342 Views
Data Processing Technology. Contents. Data Process Database Management System (DBMS) Client/Server DBMS. Data Hierarchy. Bit:0,1 Byte: 英文 (1 byte) 中文 (2 bytes) 整數 (4 bytes) Field Record File Database Data warehouse. Types of files. Master file Transaction file Index file
E N D
Contents • Data Process • Database Management System (DBMS) • Client/Server DBMS
Data Hierarchy • Bit:0,1 • Byte: • 英文 (1 byte) • 中文 (2 bytes) • 整數 (4 bytes) • Field • Record • File • Database • Data warehouse
Types of files • Master file • Transaction file • Index file • Report file • Multimedia file • Others
Data Access Method • Sequential access • Random access • Complete Balanced tree (B-tree) • Hashing
B-tree • 優點:快 • 缺點:增減需重建
Hash Function • 最快 • 刪除後之空間無法用
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.
On-line pocessing(線上) • CPU 直接控制週邊設備
Real time(即時) • 即時作業:指令送達CPU , 則立刻處理 • Ex. 工廠控制系統,ATM,訂票系統, etc..
Database Management System(DBMS) • Problems with Flat files • Data redundancy • Data integrity • Data dependancy • flexiblity
Taxonomy of DBMS • Hierarchy structure • Network structure • Relational structure
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.
DML功能 • 操作DB之基本指令 • 與HLL 配合 • 免除實體程式寫作 • Report support
DBMS • 優點: • 避免資料重覆 • 程式, 資料分離 • 資料安全性增加 • 改善UI • 彈性報表製作 • 缺點 • 速度降 • HW要求較高 • 各品牌 DBMS 語法有異
Future Trend of DBMS • Object-oriented DBMS • Data Warehouse
Section 3. Client/Server DBMS • Components • Client Computer • Server • Network
Server DBMS • OS compatibility • Communication Channel • Lock • Security • Open System • Graphics Interface • Format Transformation