Talking about the word database, I don't want to feel unfamiliar whenever the rookie is still a master. With the arrival of the information age, the database has been widely used in various computer networks and management systems. If there is no database, today's Internet will not "gorge", and the enterprise management system we have seen will only be a computer ornament. I have a lot of friends, although they have their own opinions on the database, but there is a point to reach a consensus: "The database is the soul of IT."
Oh, I have said that MS SQL Server2000 is only the database management system software in a forum, and the database is different from the real database! ! ! It is very confusing that there is a confusion that there is a need to clarify this concept again here!
1. Data: It is a symbolic record that describes things;
2. Database (DB): means that there is an organization, and shared data collection for long-term storage;
3. Database Management System (DBMS): Solve system software for how scientific organization and storage data, how to efficiently obtain and maintain data; [Note: Mainstream relational database products IBM DB2 / DB2 Universal Database, Sybase / Sybase ASE, Informix / InformixIDS2000, MS / SQL Server 2000, Oracle / Oracle];
4. Database development: Decisive factors are the development of data models; from a mesh model, hierarchy model, relational model to future object-oriented models, correspondingly slave network database, hierarchical database, relational database library to object-oriented database;
5.sql language: Structured query language; its advantages are close to natural language, powerful, and its development directly promotes the development of relational databases;
6. Relational database: Naturally, the relationship model is used as a database of organizational mode, and the physical relationship is indicated by the form;
7. The function dependent and normalization of the relational database: The relational mode has its own shortcomings, so the relational database can exhibit higher performance without the paradigm;