Level 4 Database Engineer Knowledge Overview
1. Basic Knowledge
1. Database Technology Basic Concepts
- Definition: Database technology focuses on the efficient storage, management, processing, and retrieval of data.
- Development History: Database technology originated in the 1960s and gradually became a core component of modern information systems as computer technology advanced.
2. Information and Data
- Information: Information reflects the state and changes of objects in the world, describing the relationships and interactions between them.
- Data: Data is a collection of symbols used to record information, serving as the carrier of information.
- Data Processing and Data Management
- Data Processing: Involves operations such as classifying, collecting, organizing, and storing data.
- Data Management: Refers to the classification, collection, organization, encoding, storage, retrieval, and maintenance of data.
3. Database System
- Database: A structured, shared collection of data stored on a computer for long-term use.
- Database Management System (DBMS): A software system that manages data between the user and the operating system.
- Database System (DBS): The entire system that includes hardware, software, and users.
2. Database Application System Analysis and Planning
1. Software Engineering and Software Lifecycle
- Software Lifecycle: Includes stages such as requirement analysis, design, implementation, testing, operation, and maintenance.
- Database System Lifecycle: Includes requirement analysis, conceptual design, logical design, physical design, implementation & deployment, and operation & maintenance.
2. Database Development Methods and Tools
- Development Methods: Such as the Waterfall Model, Spiral Model, etc.
- Development Tools: Tools for database design, management, etc.
3. Database Application Architecture
- Client/Server (C/S) Structure: The client handles the user interface, while the server processes the data.
- Browser/Server (B/S) Structure: The browser acts as the client, and the server handles data processing.
3. Database Design and Implementation
1. Conceptual Design
- Use methods like the ER model for conceptual design.
- Entities, attributes, and relationships in the ER model.
- Represented using Entity-Relationship diagrams (ERD).
2. Logical Design
- Transform the conceptual design into a specific data model supported by a DBMS.
- Choice between relational models, network models, and hierarchical models.
3. Physical Design
- Based on logical design, focus on the physical storage and access methods.
- Design of storage structures, indexing strategies, etc.
4. Database Object Implementation and Operations
- Creation and use of database objects such as tables, views, stored procedures.
- Application of SQL language.