1、Access2000 关系型数据库 原文： Access2000 Relational Database Members of the Office family, the people of Access2000 understanding, often limited in its interface, for the database management function is still at the establishment table, data entry, Use Form guide Reporting Wizard, Data Access2000Page Wizard
2、 and other simple applications. In fact, the functions of the Access2000 is a powerful and beyond your imagination. It is released from Microsoft Access2000functions since most comprehensive, Windows and the Internet more closely with the database software, is a very powerful, and simple, easy-to-us
3、e database management system (DBMS) that the database storage, processing and management system. Access2000 relational database management system is Microsoft Office Public automation software as an integral part. It can effectively organize, manage and share the information in the database, and dat
4、abase information with the Web together. Through the Internet to share database information with the basic platform. With the development of information technology. Information technology platform is often the choice of establishing or re-establishing applications of the key issues, the database is
5、part of the need to make a choice as a key platform. Access2000 as a relational database management system small and medium- sized information management system ideal development environment, the current database in the field, there are more and more people use. It is a powerful database management
6、system MIS development tools. The database is stored together a collection of relevant data, the data is structured. The database is a data storage and data operation of the tool. The role of the database is to organize and present information, in short, the database is a collection of information.
7、Computer database can be divided into two categories: non-relational database (flat-) and relational database (relational). Relational database contains a number of data tables, databases containing various parts of the terminology, like records. Relational database management system has the technol
8、ogical dominance of the mainstream, but this traditional database management systems by using two-dimensional data model, and there are inherent limitations and restrictions. It difficult to adapt to todays rapidly changing business needs, and the development of new technologies. With the rapid IT d
9、evelopment, data processing, not only in quantity increasingly demanding, but also the quality of increasingly high demand, database management data has been a fundamental change. This change to the database technology has brought tremendous challenges, Object database management is no longer limite
10、d to text data and other simple data types. And the description and the need to preserve a lot of complex unstructured multimedia data, and the relationship between the data. Furthermore, in the wake of popular websites surge in the number of visits to its own database storage mechanism, a large num
11、ber of concurrent users to the demand, storage efficiency in the use of space, and data integrity and security, and other aspects of higher demand. These are not traditional relational database, the use of a simple two-dimensional table structure of the meet. Access2000 is the relational database de
12、velopment tools, database pooling information for the inquiry, Storage and retrieval. Access2000 the advantage lies in its ability to use data map or custom windows to collect information. Data provides a map similar to the Excel spreadsheet, database transparent. In addition, the Access2000 allows
13、creation of custom statements to print or export the information in the database. Access2000 also provides a data repository. Can use desktop database file to extend the database file at the network file server and other network users to share databases? Access2000 is a relational database tools, da
14、tabase development, is the most common databases. As noted above, as an Access2000 database development possesses many advantages, in a data packet available at the same time facilitate the desktop database and a powerful relational database functions. In Access2000, with the user database access pe
15、rmissions are two types: Explicit and implicit powers authority. Explicit authority is granted a direct user account competence, which is the exclusive use of user accounts, has nothing to do with other users. Implicit authority is delegated the authority group account, the user added to the group w
16、as given by the groups mandate. If a user with the same time these two powers, the right set of user security database for a visit, then He had such authority is the intersection of the two powers. The Access20002000database, the group of users access to the database and the authority set up work, c
17、ompleted only through the administrator. Set up the authority include: Open/Run, read design, design modifications, management, read data, update data insertion and deletion of data. Relational database management system inherent limitations in the following three aspects: Relational database used i
18、n the two-dimensional table data model, can not effectively handle the majority of business applications, Typical of multidimensional data. Its inevitable result is that in complex ways, the interaction of the dramatic increase in the number of tables, not very good but also to provide realistic sim
19、ulation of the data model. Relational database as they use more data model, which might lead to a massive storage space and wasting a lot of increase, and cause the system to respond to the declining performance. Furthermore, the data in reality, there are many types of relational database is not we
20、ll addressed. Static applications such as report generation, and the design of the relational database management system after no response and efficient business processing for the optimization process. The result is often some relational database products, in the GUI and Web Services processing, no
21、t achieved the desired results. Unless additional hardware investment, but it does not resolve the fundamental problem. Relations with the two-dimensional database table data model can deal with the majority of business application of a typical multi- dimensional data, but the results are often the
22、establishment and use of a large amount of data forms, it is difficult to establish a simulation of real-world data model. And the need for data output statements when they, in turn, would have dispersed the large number of two-dimensional data tables. Reuse indexing technology linking the table in order to find all the necessary data, this, in turn, is bound to
