International Software design Document--Database design Manual

1 Introduction 1.1 Purpose of writing

Explain the purpose of compiling this database design manual and indicate the intended audience.

1.2 Background

Description

A Describe the name of the database to be developed and the name of the software system using the database;

b Lists the task-seekers, users, and computing stations (centers) that will install the software and the database for the software system development project.

1.3 Definitions

The definition of the terminology used in this document and the original phrase of the foreign language first letter group are listed.

1.4 References

List the relevant references:

A The approved Plan task book or contract and the approval of the superior authority of the project;

b Other published documents belonging to the project;

C Documents referenced throughout this document, including the software development standards to be used.

The title, document number, date of publication and publication Unit of these documents are listed, indicating the source of the documents to be obtained.

2 external Design 2.1 identifiers and states

For contact purposes, specify the code, name, or identifier used to uniquely identify the database, and additional descriptive information is also given. If the database belongs to an experiment, is still under test, or is temporarily used, it is to explain this feature and its effective time range.

2.2 Programs that use it

Lists all the applications that will use or access this database, given its name and version number for each of these applications.

2.3 Conventions

State the conventions that a programmer or a system analyst needs to know in order to be able to use this database, such as conventions for identifying different versions of a database, and for identifying individual volumes within a library, records, naming conventions for data items, and so on.

2.4 Special Instructions

Provide specific guidance to the generation, testing, and maintenance personnel who are preparing to engage in this database, such as the format and standard of data to be fed into the database, the procedures and procedures for sending it into the database, and instructions for generating, modifying, updating or using these data volumes. If the content of these guidelines is lengthy, a list of the names and chapters of the documents to be read is provided.

2.5 Support Software

Brief introduction of supporting software directly related to this database, such as database management system, storage locator and program for loading, building, modifying and updating database. Describes the name, version number, and key features of the software, such as the type of data model used, the allowable data capacity, and so on. Lists the title, number, and source of the technical documentation for these support software.

3 Structural Design 3.1 conceptual structure design

This database will reflect the real-world entities, attributes and relationships between the original data form, including the data items, records, lines, text volume identifiers, definitions, types, units of measure and range, to establish the database of each user view.

3.2 Logical Structure Design

The paper describes the global logical structure of the database which is decomposed and merged, including the key words and attributes, the re-determined record structure and the structure of the document, the relationship between each document volume, and the database administrator view of the database.

3.3 Physical Structure Design

Build a view of the system programmer, including:

A The arrangement of data in memory, including the design of index area and buffer;

b The external memory equipment used and the organization of external memory space, including index area, data block organization and division;

C Ways to access data.

4 Using Design 4.1 data dictionary design

In the database design involves the various items, such as the data item, the record, the system, the text volume, the pattern, the sub-pattern and so on generally must establish the data dictionary, explains their identifier, the synonym name and the related information. The basic considerations for this data dictionary design are described in this section.

4.2 Secure and confidential design

In the design of the database, how to design the database security by distinguishing different visitors, different types of access and different data objects.

International Software design Document--Database design Manual