摘要
介绍了开发C/S模式下的基于系统表的数据库信息通用动态查询系统的设计思路和实现。在深入研究系统表和SQL语法的基础上,将查询需求与查询软件相分离,使软件相对通用,与具体应用无关,与库结构变更无关。软件使用方便,查询需求变化无需修改软件,只需在数据库服务器端编写相关视图,节省了大部分情况下查询需求的开发成本和后续的维护成本。
How to design and implement a database information universal dynamic query system based on system tables in C/S mode is introduced. On the foundation of deep research system tables and SQL syntax, makes query requirement and software apart, so that software is relatively universal, is independent of practice application, is independent of database schema alteration. Software use is convenient, query requirement changing does not require to modify it, only requires to modify or write related view in database serve, so it can reduces the costs of exploration and maintenance in most condition.
出处
《计算机工程与设计》
CSCD
北大核心
2007年第23期5819-5821,共3页
Computer Engineering and Design
