Thoughts about Database System (1)

1. Computer system?

Computer system refers to computer hardware resources and basic software resources used for database management. Hardware resources include CPU, large-capacity memory (used to host operating systems, database management systems, applications, databases, etc.), and external storage devices (hard disks) for direct access. Software resources include operating systems and applications.

 

2. What is a database ?

The database is the base for supplying data. It can save data and allow users to access useful data from it.

The business data in the database is a whole of related data stored together in a certain organization method. The data stored in the database is coherent data, which is an absolutely stable intermediate data. In order to facilitate the management and processing of these data, the data must have a certain data structure and file organization form (sequential file, index file) when stored in the database.

    

  3. What is a database management system?    

DBMS is the abbreviation of Data Base Management System. It includes user-oriented interface functions and system-oriented maintenance functions. The former provides users with the necessary wrists to access the database, including processing power. The latter provides database maintenance tools for database administrators. Details for database definition, data loading, database operation, control, monitoring, maintenance, recovery, communication, etc. The DBMS usually consists of three parts: database description language (DLL), data manipulation (DML) or query program, and database management routine.

 

4. Applications and users

Database administrator (DBA): is a system staff responsible for maintaining the entire database system.

    

Application programmer: is a professional background user who performs operations such as searching, inserting, deleting, or updating the database.

Non-programmer: It is an end user who searches, inserts, deletes or updates the database through an online terminal device and an interrogation language composed of basic commands.For example, operators, administrators, quality inspectors.

    

In short, the collection of information is a database, and theDBMS software can be used to complete the storage and retrieval of information.


评论

热度(7)