Design and implementation of universal dynamic query system based on system table
Sun Ren-peng
Abstract
Sun Ren-peng
Abstract
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 ofpractice 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.
OpenAlex reports 1 citations for this work. Citation counts describe recorded attention and do not establish research quality.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
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 ofpractice 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.
Key concepts: Computer science, SQL, View, Query by Example, Database, Query optimization, Query language, Software system