Nadkarni P M, Cheung K H
Center for Medical Informatics, Yale University School of Medicine, New Haven, Connecticut 06510, USA.
Comput Biomed Res. 1995 Dec;28(6):479-99.
SQLGEN is a framework for rapid client-server relational database application development. It relies on an active data dictionary on the client machine that stores metadata on one or more database servers to which the client may be connected. The dictionary generates dynamic Structured Query Language (SQL) to perform common database operations; it also stores information about the access rights of the user at log-in time, which is used to partially self-configure the behavior of the client to disable inappropriate user actions. SQLGEN uses a microcomputer database as the client to store metadata in relational form, to transiently capture server data in tables, and to allow rapid application prototyping followed by porting to client-server mode with modest effort. SQLGEN is currently used in several production biomedical databases.
SQLGEN是一个用于快速开发客户端-服务器关系数据库应用程序的框架。它依赖于客户端机器上的一个活动数据字典，该字典存储客户端可能连接的一个或多个数据库服务器的元数据。该字典生成动态结构化查询语言（SQL）以执行常见的数据库操作；它还在登录时存储有关用户访问权限的信息，用于部分自我配置客户端行为，以禁用不适当的用户操作。SQLGEN使用微型计算机数据库作为客户端，以关系形式存储元数据，在表中临时捕获服务器数据，并允许快速进行应用程序原型设计，随后只需稍加努力即可移植到客户端-服务器模式。SQLGEN目前用于多个生产生物医学数据库。
