TAILIEUCHUNG - Database System: Chapter 1 - Introduction

Database System: Chapter 1 - Introduction presents about File based approach, Database approach, Basic definitions, Database systems concepts (Data model, Three schema architecture – Data independence, DBMS languages, Classification of DBMS, Database users). | Chapter 1 Introduction Outline Introduction File based approach Database approach Basic definitions Database systems concepts Data model Three schema architecture – Data independence Database schema – state – instance DBMS languages Classification of DBMS Database users Slide 1- File-based Approach Data is stored in one or more separate computer files Data is then processed by computer programs - applications Slide 1- File-based Approach Slide 1- File-based Approach Problems/Limitations Data Redundancy Data Inconsistency More details: see [2] Slide 1- File-based Approach Shared File Approach Data (files) is shared between different applications Data redundancy problem is alleviated Data inconsistency problem across different versions of the same file is solved Other problems: Rigid data structure: If applications have to share files, the file structure that suits one application might not suit another Physical data dependency: If the structure of the data file needs to

• Cơ sở dữ liệu
• Database System
• File based approach
• Database approach
• Basic definitions
• Database systems concepts
• Data model
• Database system concepts
• Lecture Database system concepts
• Database systems
• Database languages
• Database design
• Database system architectures
• Relational database design
• Lecture Database System
• Database system architecture
• Data management systems framework
• Recovery system
• Lecture Database systems
• Database architecture
• Relational databases
• Database design process
• Query optimization
• Transaction state
• Concurrency control
• Data analysis
• Information retrieval
• Parallel databases
• Distributed databases
• Advanced application development
• Advanced data types
• Advanced transaction processing
• Relational model
• Basic query structure
• Dynamic SQL
• Tuple relational calculus
• Entity relationship model
• Application design
• Object­ based databases