Easy to understand the basic features of business-oriented database

1. Business-oriented topics (not for document reporting). The subject database is a business-oriented data organization store, for example, the typical thematic databases that need to be established in an enterprise are: products, customers, components, suppliers, orders, employees, documentation, engineering specifications, etc. Among them, products, customers, components, such as the structure of the database, the relevant documents, reports of data items for analysis and collation design, not according to the document, the report of the original establishment. These theme databases are associated with the main issues to be addressed in enterprise management, not with the usual computer application projects.

2. Information sharing (not information private or departmental all). Subject database is a total negation of the "self-built" database of each application system, and emphasizes the establishment of the shared database of "building and sharing" of each application system. Different application systems of computer programs call these subject databases, for example, inventory management calls products, parts, ordering databases, procurement call parts, suppliers, engineering specifications database, and so on.

3. One input system at a time (not multiple input systems at multiple times). The subject database requires the investigation and analysis of the data sources at the management level of the enterprise, emphasizing on-site data collection, on-site processing, use and storage, as well as the necessary transmission, summary and centralized storage. The same data must be entered into the system one at a time, to ensure its accuracy, timeliness and integrity, through the network-computer-database system, can be used several times, many places.

4. Consists of a base table. The scientific data structure of a subject database consists of several data entities that reach the basic table specification, which has the following characteristics:

Atomicity-The data items in the basic table are data

Elements (that is, the smallest, no further decomposition of the information Unit);

Deductive-can be generated from the data in the base table

All output data (that is, these basic tables are concise, calculated processing can produce all the data required for enterprise management);

Normative--the data satisfies three normal forms in the basic table

(3-NF) requirements, this is scientific, to meet the deductive requirements, and to ensure fast access to the data structure in the design, the key is to do a good job of data dictionary maintenance, so that you know your own database. With Oracle, you can also compile your own data dictionary management software to facilitate later programming and maintenance work.