一种通过程序自动实现数据库初始化的方法研究

A Method to Initiate Database Automatically in Run Time Environ ment

在构建一个管理信息系统时,数据库的初始化工作是必不可少的,而通常数据库的初始化工作一般由开发人员手工完成,包括数据库的安装配置、数据库创建、数据表、视图、存储过程、触发器的创建,通用数据的初始化等工作,这些工作对于普通的用户很难完成,而且,通过手工建立数据库步骤繁琐,容易导致操作出错。论文针对这种情况,提出了一种全新的方法,利用标准的SQL语句通过程序自动实现数据库的初始化,从而大大减少系统实施过程的工作量,提高程序的质量,并结合一个实例,分析了其具体的实现过程。

It is necessary to initiate the database in the beginning of establishing a management information system.The work,including installation and configuration of database management platform,creation of database,tables,viewers,store procedures and triggers and initiation of current data,is usually finished by programmer step by step.Yet the work above is difficult to common users.Moreover,the complicated steps often lead to errors.This paper raises a new method to solve these problems.By this method,the initiation of database will be carried out automatically by running Standard Query Language,and then there will be less workload and higher quality of the whole system.