Welcome to my “What are the main function of database management system.”
"Introduction to Database System" is an important basic course for major in computer science and technology, software engineering, information system and information management.
This course system tells the basic theory of database system, basic technology, and basic method.
The content of this course is rich and comprehensive, divided into basic and advanced 2 parts to explain, as 2 courses assessment and scoring.
Through the course of this course study, students can systematically master the basic principles of database systems, be proficient in using SQL language in a database management system for database retrieval and operation, to master the basic concepts and basic methods of database security and integrity. And be able to experiment with a database management system.
Through the advanced course of this course, students can systematically master the methods and steps of database normalization theory and database design and have the basic ability to design and developing database application system. They master the basic techniques of database transaction processing and concurrency control and recovery, Database query processing and optimization concepts. And to a certain database management system for experimental verification.
The content and technical methods of this course are an important and necessary basis for those engaged in the application, development, and research of modern data management technologies.
The characteristics of this course are that theory is linked to reality. We not only hope that students will master the contents of this course through reading and writing exercises but also require students to complete the experimental project. To this end, we set the corresponding knowledge for the course of the experiment, training students practical ability to inspire students to think and understand the theoretical knowledge, to achieve the teaching theory with practice.
Certificate requirements
The qualifications of this course to obtain a certificate are determined by the following factors:
After class exercises, scoring 20% of the total score. The course contains a total of five chapters, each chapter more than half of the course and at the end of each chapter will arrange a unit test, the specific time will remind everyone in the course announcements;
Complete the required experimental questions, scoring 20% of the total score. The experimental platform running experimental platform will inform everyone in the bulletin board;
Completed midterm exam of 120 minutes, score 30% of the total score;
Complete the 120-minute final exam, score 30% of the total score;
Description:
The midterm and final exam consists of two parts, (1) subjective and objective questions (60 minutes and 15%) of the MOOC platform, and (2) SQL statement programming questions (60 minutes and 15%) in the experimental platform.
Students who meet the criteria 1 and 2 and who have achieved an overall grade of 60 or above will receive a certificate of eligibility for this course.
Preparation knowledge
Some kind of computer programming method and language data structure discrete
mathematics
operating system
Teaching outline
Chapter 1 Introduction, a total of eight videos.
Content overview
Explain the basic concepts of database, introduce the progress of data management technology, the background of the emergence and development of database technology, the basic concepts, components and main data model of the data model, briefly introduce the concept model, the three-level schema structure of the database system and the database The composition of the system.
The goal of this chapter
This chapter explains the basic concepts and basic knowledge of the database is to learn the basis of the subsequent chapters. The purpose of studying this chapter is to understand the basic knowledge, master the basic concepts and lay a solid foundation for future study.
Chapter 2 relational database, a total of seven videos.
Content overview
Systematically explain the important concepts of relational database, and focus on the relational model to explain. The relational model includes three parts: relational data structure, relational operation set, and relational integrity constraint. Explain relational algebra, tuple relational calculus and domain relational calculus. From concrete to abstract, first explain the actual language ALPHA (tuple relational calculus language) and then explain the abstract tuple relational calculus, and finally introduce QBE (domain relational calculus language).
The goal of this chapter
Grasp the three components of the relationship model and the main contents of each part; firmly grasp the relational data structure and its definition; and the concept of the three types of integrity constraints. To lay the foundation for learning the back of the relational database system.
Chapter 3 relational database standard language SQL, a total of 12 videos.
Content overview
Describe the relational database language SQL in detail. SQL is a standard language for relational databases that is very rich in content and very powerful. Because the main function of the relational database system is achieved through SQL, so to explain SQL at the same time further on the basic concepts of relational databases.
The goal of this chapter
Firmly grasp the SQL, to master one by one to master the SQL function. At the same time, through the exercises and onboard experiments, understand the process-oriented language and SQL differences and advantages. Experience relational database system for the development of database applications to provide a good environment, reduce user burden, improve user productivity reasons.
Chapter 4 database security, a total of 4 videos.
Content overview
Describes advances in computer and information security technology standards. Explain the database security issues in detail and the realization of technology. There are many kinds of technologies and methods to realize the security of database system in RDBMS. This chapter explains user identity authentication, autonomous access control and enforcement access control technology, view technology and audit technology, data encryption storage and encrypted transmission. Explain the access control mechanism of user authority authorization and recovery, legal authority checks, the concept and definition of database roles.
The goal of this chapter
Grasp what is the database security issues, firmly grasp the database management system to achieve common database security control methods and techniques.
Chapter 5 Database Integrity, a total of five videos.
Content overview
Explain the concept of database integrity in detail. Including what is the integrity of the database, the integrity of the concept of the database, the concept of database integrity and security differences and contact. RDBMS database integrity implementation mechanism, including entity integrity, referential integrity and user-defined definition of integrity constraints mechanism, integrity check mechanism and breach of integrity constraints RDBMS taken precautionary measures. Trigger concept, and its application in database integrity check.
The goal of this chapter
Grasp what is the integrity of the database, master the integrity constraints of the relational schema defined in SQL language, and learn to use the assertions and triggers to achieve more complex integrity constraints.
Reference material
Wang Shan, Sa Shi "Database System Introduction (fifth edition)", Higher Education Press, 2014.9
Wang Shan, Zhang Jun. "Introduction to Database System (5th Edition) Problem Analysis and Experimental Guide", Higher Education Press, 2015.7
Software on board: GoldenBaseES database
The basic functions are as follows:
(1) Using complex data model to represent the data structure, data redundancy is small, easy to expand, and data sharing is achieved.
(2) has a high degree of data and program independence, the independence of the database has a physical independence and logical independence.
(3) database system provides users with a convenient user interface.
(4) The database system provides four aspects of data control functions, namely concurrency control, recovery, integrity, and security.
The data used by each application in the database is defined uniformly by the database system, which is organized and established according to a certain data model and controlled centrally by the system.
(5) Increased system flexibility.
The basic functions of a database management system (DBMS) are as follows:
(1) data definition function. DBMS provides the corresponding data language to define (DDL) database structure, they are portrayed database framework and is stored in the data dictionary.
(2) data access function. DBMS provides data manipulation language (DML), to achieve the basic access to the database data: retrieve, insert, modify and delete.
(3) database operation and management functions. DBMS provides data control functions, that is, data security, integrity, and concurrency control database operations to effectively control and manage to ensure that the data is correct and effective.
(4) database establishment and maintenance functions. Including the initial database loading, database dump, recovery, reorganization, system performance monitoring, analysis and other functions.
(5) database transmission. DBMS provides the processing of data transmission, to achieve communication between the user program and the DBMS, usually in coordination with the operating system
The symbolic record describing something is called data. The types of data are numbers, text, graphics, images,
Voice, text and so on. The data is inseparable from its semantics. The concept of data resolution in modern computer systems is generalized. early
Period of the computer system is mainly used for scientific computing, processing data is the integer, real, floating-point data and other traditional mathematics.
Modern computers can store and process a wide range of objects, said the data of these objects is also more and more complex. Data and its language
Meaning is inseparable. 500 This figure can be said that the price of an item is 500 Yuan, can also represent an academic society The number of participants is 500 People, but also that a bag of milk weight 500G
The database is long-term storage in the computer, organized, co-can Enjoy the data collection. Database data by a certain data model organization, description, and storage, with less redundancy, more High data independence and scalability, and for a variety of users to share.
Database system refers to the computer system cited
After entering the database system structure, generally by the database, database management system (and its development tools), application systems, data Librarian composition. Parsing the database system and database are two concepts. The database system is a person-machine system, data The library is an integral part of the database system. However, people often refer to the database system as a database in their daily work.
I hope readers can distinguish "database system" and "database" from the context of people's speech or article, and do not cause Confused.
The benefits of using a database system are dictated by the features or benefits of a database management system. The benefits of using a database system is
For example, you can greatly improve the efficiency of application development, user-friendly, reduce the database system administrator dimension
The burden of care, and so on. The use of database systems can greatly improve the efficiency of application development. Because of the application in the database system
The program does not have to consider the definition of data, storage and data access to the specific path, Database Management System Is a layer of data management software located between users and the operating system to scientifically organize and store data and efficiently retrieve And maintain data. DBMS The main functions include data definition function, data manipulation function, database operation management function. Database establishment and maintenance functions. Analysis DBMS Is a large, complex software system that is the foundation of a computer
software. At present, specially developed DBMS Manufacturers and their development DBMS Many products. Famous are the United States IBM public Secretary's
DBZ Relational database management system and
IMS Hierarchical database management system, the United States Oracle company's orange Relational database management system,
No comments:
Post a Comment