Database record data query system based on record logical representation

Abstract

The invention relates to a database record data query system based on record logical representation. The database record data query system comprises a logical record definition and mapping component, a named relation and limited class defining component, a logical record query component, a record relation expansion sub-process and a record database. Several thoughts and methods of logical representation are used for data query of a common database without using the complicated implementation technology of the logical representation. A user of data can define logical records aiming at the data in the database according to self needs, and converts record logical representation record query conditions or commands into database query SQL (structured query language) statements by corresponding relations between logical records and database records; and the user can self-define record named relations and record limited classes by recording named relation definition rules, and uses record naming and the record limited classes in record query condition expressions or commands to enable the expressions of the record query conditions to be simpler.

Description

technical field [0001] The invention belongs to the technical field of electronic records and databases, in particular, to a database record data query system based on record logic representation. Background technique [0002] Relational databases are widely used to store various application data. A relational database consists of one or more database tables, in which the database table is composed of rows (array), and the rows are composed of multiple fields (fields) or columns (columns), and the application data is finally saved In the corresponding fields of the corresponding row(s) of the database table(s). Data stored in database tables is also known as records. Data records stored in different database tables can be associated in a certain way to form a larger data record, or a record with a certain relationship. The former corresponds to the situation where a record is stored in multiple different tables, and then Corresponding to the situation where there is an as...

AI Technical Summary

Problems solved by technology

[0006] 2) Through the man-machine interface, only fixed record data content can be queried, which lacks flexibility

[0007] Because SQL is not suitable for ordinary users, ordinary users can only query the fixed record data content in a given way through the special human-computer interaction interface provided by the data application system, and cannot customize query objects according to their own needs. Inquiry method, lack of flexibility

[0008] 3) Interrelated records cannot be queried through named relations

[0012] 2) The relationship between specific instances of different knowledge objects is not stored in the database as knowledge;

Images