Home >

Database Management

2011/3/14 16:54:00 87

Database Management Technology Management Database Reorganization

  

Database management

(Database Manager) is the technology to establish, store, modify and access information in the database. It means that the personnel concerned must carry out the database system's normal operation and service quality.

Technical management work

Individuals or groups who are responsible for these technical management work are called database administrators (DBA).

The main contents of database management are: database tuning,

Database reorganization

Database reconstruction, database security control, reporting and analysis of problems, summary and processing, database data backup.


Database establishment: database design only provides data description, such as data type, logical structure, connection, constraint and storage structure.

These descriptions are called data patterns.

To build a viable database, we need to do the following work:


(1) select various parameters of the database, such as the largest data storage space, the number of buffer blocks, concurrency and so on.

These parameters can be set by the user or by the default value of the system.


(2) define a database and define the database name, data schema, index, etc. by using the data definition language and command provided by the database management system (DBMS).


(3) to prepare and load data, to define the database, only to establish a database framework, to build a database must also load a large amount of data, which is a great work.

In the process of data preparation and entry, measures must be taken in technology and system to ensure the correctness of loading data.

The data accumulated in the computer system should be fully utilized and converted to database data as much as possible.

  • Related reading

Computerization Strategy For Document Management

Document management
|
2011/3/4 10:31:00
93

Document Management Model

Document management
|
2011/1/14 17:49:00
89

Management Of Audio-Visual Archives

Document management
|
2011/1/14 17:48:00
90

声像档案的开发利用

Document management
|
2010/12/27 18:35:00
100

Nominatures, Signature And Letter Of Credit

Document management
|
2010/12/25 16:19:00
121
Read the next article

The International Cotton Market Is At A Steady Pace.

In March 11th, the price of China's main port of import cotton continued to decline, and the varieties fell by 3.5 cents. With the downward trend of long-term quotations, textile enterprises' demand for new flowers increased in 2011.