User-oriented database management system

Abstract

The invention discloses a user-oriented database management system, comprising backstage databases, a management platform and a client, wherein the management platform is provided with a data management module, a configuration information module, a query condition management module and a query sentence edit module; the client is provided with query interfaces, and the management platform can login through any query interface; the data management module is connected with the backstage databases, and one or more database applications are set in the backstage databases; and the configuration information module sets configuration data for each backstage database, outputs a conditional variable set to the query condition management module and outputs a primary query sentence set and data connection parameters to the query sentence edit module. As the conditional variables in the conditional variable set correspond to the query conditions displayed on the query interfaces one by one, the query conditions are transferred to parameter sequences to replace the variable names of the conditional variables in the primary query sentences, therefore, the query conditions are selected by a user and then are dynamically combined with the conditional variables and the primary query sentences, query systems can be dynamically managed, and the query functions of the original system can be expanded.

Description

technical field [0001] The invention relates to a database management system, in particular to a user-oriented database management system. Background technique [0002] At present, the common database systems used to store, manage and analyze data include Access, dbase, Oracle, SQL Server, Visual Foxpro and MySQL. This type of software is powerful, but due to its versatility, it has a programming language that is difficult to master and has an unfriendly interface. The shortcoming is that users are required to have a certain foundation in SQL language and programming, so it cannot meet the requirements of ordinary enterprise users for the ease of use of the software. However, industry-specific database management software is usually only designed for a specific field, which is highly specific and has a narrow range of database applications. The requirements of the software change, and the user cannot conveniently modify or supplement the functions of the software according ...

AI Technical Summary

Problems solved by technology

[0002] At present, the common database systems used to store, manage and analyze data include Access, dbase, Oracle, SQL Server, Visual Foxpro and MySQL. This kind of software has powerful functions, but due to its strong versatility, the programming language is difficult to master and the interface is not friendly. The shortcoming of the system requires users to have a certain foundation in SQL language and programming, so it cannot meet the requirements of ordinary enterprise users for the ease of use of the software

However, industry-specific database management software is usually only designed for a specific field, which is highly specific and has a narrow range of database applications. The requirements of the software change, and the user cannot conveniently modify or supplement the functions of the software according to the new requirements, and can only re-modify the program code, which has poor versatility

[0003] Glass fiber production enterprises have many production processes and many product testing and inspection items. Therefore, the production data and quality inspection data generated in the production process need to be analyzed and managed in a timely and effective manner, especially in the field of spun yarn and ultra-fine yarn production. At the same time, the demand for data management and analysis changes very quickly. It is difficult for ordinary database systems to meet the changing needs of glass fiber production enterprises due to their difficulty in operation and poor versatility.

Images