1, the definition of database system
● Database system is a practical software system for storing, maintaining and applying data, and it is a collection of storage media, processing objects and management systems. It usually consists of software, database and data administrator. Its software mainly includes operating system, various host languages, utilities and database management system. The database is managed by the database management system, and the insertion, modification and retrieval of data should be carried out through the database management system. The data administrator is responsible for creating, monitoring and maintaining the entire database so that anyone who has access to the data can use the data effectively. Database administrators are generally people with higher professional level and deeper qualifications.
The individual meaning of database system refers to a specific database management system software and the database established with it; Its subject meaning refers to the discipline composed of theories, methods and technologies involved in the research, development, establishment, maintenance and application of database systems. In this sense, database system is an important branch of software research field, which is usually called database field.
● Database research spans three fields: computer application, system software and theory. Among them, application promotes the research and development of new systems, and new systems bring new theoretical research, while theoretical research plays a guiding role in the first two fields. The appearance of database system is a milestone in computer application, which makes computer application change from scientific calculation to data processing, thus making computers widely used in all walks of life and even families.
2, the characteristics of the database system are roughly:
Data structure, good data enjoyment, good data independence, small data storage granularity and data management system provide users with a friendly interface.
3, the core and foundation of the database system:
The core and foundation of database system is data model, and all existing database systems are based on some data model.
4. The core of database system is database management system. Generally, a database system consists of a database, a database management system (DBMS), an application system, a database administrator and a user. DBMS is the foundation and core of database system. [Page]
Second, the application technology of database in logistics
In the logistics management information system, the information is absolutely huge and widely distributed, and many of them are transitive and require consistency. In the functional module of the logistics center information system, the subsystems such as purchasing and delivery management, sales and delivery management, warehouse storage management, financial accounting management and operation performance management all contain information uploading and publishing, and the information management of the logistics system should be completed through the database and * * * shared information. Therefore, the logistics system database plays an important role in logistics management. 1, the design of logistics system database includes the following steps: establishing logistics system information model (conceptual design)-designing data structure of logistics system database (logical design)-designing physical structure of logistics system database (physical design)-realizing logistics system database. 2. Management of logistics database The management of logistics system database includes security management, disk space management, database maintenance, database system startup, integrity and consistency realization, operation monitoring and performance adjustment.
Third, the application of logistics database is the core technology of logistics information system, because the database is the root of logistics information system and the most concerned resource for users.
The basic application program of logistics database can be summarized into six aspects: data collection, data storage, data transmission, data processing, information interpretation and information output. 1, data collection-According to the different data and information sources, the collection of logistics information can be divided into two types: original information and secondary information collection.
2. Data storage-this function is to ensure that the obtained logistics information is not lost, deformed, leaked, properly organized and available at any time.
3, data transmission, namely data communication, information from one subsystem to another subsystem, or from one department to another department.
4, data processing-some processing has been collected logistics information, in order to make some more meet the needs or better reflect the essence of logistics information, or make logistics information more suitable for managers at all levels, this is information processing.
5, information interpretation-the service object of logistics information system is logistics managers, therefore, it must have the means or mechanism to provide information to logistics managers, otherwise it will not be able to realize its own value. The explained logistics information is output in different formats according to different needs.
6. Information output-information output after information interpretation, some are directly provided to people, and some are provided to computers for further processing. The means of information output is the interface between logistics information system and logistics managers, and its situation depends on the situation of both parties, that is, the information to be provided to users and the situation of users themselves.