CN116992095A - Query method and device for data model, storage medium and terminal equipment - Google Patents

Abstract

The embodiment of the application discloses a query method and device of a data model, a storage medium and terminal equipment, and relates to the field of data query. According to the application, based on a low-code platform, a developer configures association types, query items, query conditions and query orders for the items of one or more models according to application scenes, the items are stored as query topics, the development of the query topics of the multiple models can be completed without writing codes, a user establishes a query scheme based on the query topics, and data query is performed on the data models.

Description

Query method and device for data model, storage medium and terminal equipment

Technical Field

The present application relates to the field of data query, and in particular, to a method and apparatus for querying a data model, a storage medium, and a terminal device.

Background

In the related art, the application systems have the requirement of comprehensively inquiring in one or more data models, most of the application systems write codes to determine the inquiring scheme of the data models, the method is not flexible enough to write the codes fixedly, and if the inquiring scheme needs to be changed, the codes need to be modified, namely, a set of codes need to be written again for inquiring among different data models, so that the stability of the application systems is not facilitated, and the development workload is large, so that the development efficiency is low.

Disclosure of Invention

The embodiment of the application provides a query method, a query device, a storage medium and terminal equipment for a data model, which can solve the problems of large development workload and low development efficiency in the prior art for carrying out the data model in the data model. The technical scheme is as follows:

in a first aspect, an embodiment of the present application provides a method for querying a data model, where the method includes:

displaying a query subject configuration interface;

setting query topic information based on the query topic configuration interface; wherein the query topic information includes: query models, query terms, query associations, query conditions, query ordering, and query groupings;

storing the configured query topic information into a topic database;

selecting one query subject information from the subject database based on the displayed new query scheme interface;

generating query plan information by using the selected query topic information and the configured query format based on the displayed query plan configuration interface;

and obtaining a query result according to the query scheme information and displaying the query result in a query interface.

In a second aspect, an embodiment of the present application provides a query apparatus for a data model, where the apparatus includes:

the display unit is used for displaying a query theme configuration interface;

the setting unit is used for setting query topic information based on the query topic configuration interface; wherein the query topic information includes: query models, query terms, query associations, query conditions, query ordering, and query groupings;

the writing unit is used for storing the configured inquiry theme information into a theme database;

the selecting unit is used for selecting one query topic information from the topic database based on the displayed query scheme newly-added interface;

the generating unit is used for generating query scheme information by using the selected query subject information and the configured query format based on the displayed query scheme configuration interface;

and the query unit is used for obtaining the query result according to the query scheme information and displaying the query result in a query interface.

In a third aspect, embodiments of the present application provide a computer storage medium storing a plurality of instructions adapted to be loaded by a processor and to perform the above-described method steps.

In a fourth aspect, an embodiment of the present application provides a terminal device, which may include: a processor and a memory; wherein the memory stores a computer program adapted to be loaded by the processor and to perform the above-mentioned method steps.

The technical scheme provided by the embodiments of the application has the beneficial effects that at least:

in a general service application system, comprehensive query of association data among a plurality of models exists, and different query results are obtained according to different application scenes and different association types, query items, query conditions, query orders and query groups among the models. The multi-model entity comprehensive query method of the scheme can be completed without writing codes by a developer.

Drawings

In order to more clearly illustrate the embodiments of the application or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the application, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.

Fig. 1 is a schematic diagram of a network architecture according to an embodiment of the present application;

FIGS. 2-7 are various schematic diagrams of a query topic configuration interface provided in an embodiment of the present application;

FIG. 8 is a schematic diagram of a new interface of a query scheme provided by an embodiment of the present application;

FIG. 9 is a schematic diagram of a query plan configuration interface provided by an embodiment of the present application;

FIG. 10 is a schematic diagram of a query interface provided by an embodiment of the present application;

FIG. 11 is a schematic diagram of a query device for a data model according to the present application;

fig. 12 is a schematic structural diagram of a terminal device provided by the present application.

Detailed Description

In order to make the objects, technical solutions and advantages of the present application more apparent, the following detailed description of the embodiments of the present application will be given with reference to the accompanying drawings.

It should be noted that, the query method of the data model provided by the application is generally executed by the terminal device, and the corresponding query device of the data model is generally arranged in the terminal device.

Fig. 1 shows an exemplary system architecture of a query method of a data model or a query apparatus of a data model, which can be applied to the present application.

As shown in fig. 1, the system architecture may include: a terminal device 101 and a server 102. The communication between the terminal device 101 and the server 102 may be performed through a network for the medium providing the communication link between the above-mentioned respective units. The network may include various types of wired or wireless communication links, such as: the wired communication link includes an optical fiber, a twisted pair wire, a coaxial cable, or the like, and the WIreless communication link includes a bluetooth communication link, a WIreless-FIdelity (Wi-Fi) communication link, a microwave communication link, or the like.

Wherein, a database of one or more data models is deployed in the server 102, and the terminal device 101 performs data query in one or more data modules.

All models to be queried need to have corresponding metadata description files, like the hbm file of hibernate, so that all models can be managed uniformly.

Wherein the developer creates a query topic model, which is a meta-model describing the relationship of other models, and comprises one or more target models to be queried, association relations among the models, query result items, query condition items, query ordering items and query grouping items. The association relations among the models such as left association, right association, internal association and full association are used for inquiring the result items, namely inquiring item information to be displayed; the query condition is to select items serving as conditions in the model, configure comparison operators and the range of condition data, and different item data types match corresponding comparison operators; querying the ordering items, and selecting the items of the model as ordering items; the grouping items are queried and the items of the model are selected as grouping items.

A query scheme model is created, the model is a user-oriented model, the model is a meta-model describing the whole query, the query scheme is created on the basis of a query theme and contains all information of the theme, the query scheme can know the association relation only by introducing the query theme, a client only cares about items to be displayed by the query, the condition required by the query, and the query result items, the query conditions, the query ordering, the query grouping and the like can be added according to the scene requirement on the basis of the original query theme.

The query subject and the query proposal are displayed in an interface mode, the relationship among multiple models and the result required by the query are described through manual configuration on an interface, finally, the query is carried out by assembling SQL according to SQL specifications during operation, the result is displayed to a terminal, the development and the intervention are not needed, and the user can realize diversified comprehensive query through flexible configuration.

The terminal device 101 and the server 102 may be hardware or software. When the terminal apparatus 101 and the server 102 are hardware, they may be realized as a distributed server cluster composed of a plurality of servers, or as a single server. When the terminal device 101 and the server 102 are software, they may be implemented as a plurality of software or software modules (for example, to provide distributed services), or may be implemented as a single software or software module, which is not particularly limited herein.

Various communication client applications can be installed on the terminal device of the present application, for example: video recording applications, video playing applications, voice interaction applications, search class applications, instant messaging tools, mailbox clients, social platform software, and the like.

The terminal device may be hardware or software. When the terminal device is hardware, it may be various terminal devices with a display screen including, but not limited to, smartphones, tablet computers, laptop and desktop computers, and the like. When the terminal device is software, the terminal device may be installed in the above-listed terminal device. Which may be implemented as multiple software or software modules (e.g., to provide distributed services), or as a single software or software module, without limitation.

When the terminal equipment is hardware, a display device and a camera can be arranged on the terminal equipment, the display device can be various equipment capable of realizing the display function, and the camera is used for collecting video streams; for example: the display device may be a cathode ray tube display (cathode ray tube display, CR), a light-emitting diode display (light-emitting diode display, LED), an electronic ink screen, a liquid crystal display (liquid crystal display, LCD), a plasma display panel (plasma displaypanel, PDP), or the like. The user can view the displayed text, picture, video and other information by using the display device on the terminal device.

It should be understood that the number of terminal devices, networks and servers in fig. 1 is merely illustrative. Any number of terminal devices, networks, and servers may be used as desired for implementation.

The following describes in detail a query method of a data model according to an embodiment of the present application with reference to fig. 2. The query device of the data model in the embodiment of the present application may be a terminal device shown in fig. 1.

Referring to fig. 2, a flow chart of a query method of a data model is provided in an embodiment of the present application. As shown in fig. 2, the method according to the embodiment of the present application may include the following steps:

s201, displaying a query theme configuration interface.

The query topic configuration interface is a graphical interface used for configuring query topic information by a developer, the developer triggers and generates a query topic new instruction based on an input device of the terminal equipment, the query topic new instruction is used for creating a new query topic, and the terminal equipment responds to the query topic new instruction and displays the query topic configuration interface through a display unit of the terminal equipment.

S202, newly creating query topic information based on a query topic configuration interface.

The method comprises the steps that a plurality of UI controls are arranged on a query topic interface, a developer performs interactive operation through the UI controls in advance of an input device to realize new construction of query topic information, and the query topic information comprises: query models, query terms, query associations, query conditions, query rankings, and query groupings. The query model represents the selected one or more data models, the data models being a data table built using data modeling; the query items represent items that need to be queried in the data model, i.e., fields that are presented in the query results; the query association represents a type of association between a plurality of data models, including but not limited to, in the case that the selected data model is a plurality of data models: left association, right association, inner association, or full association; the query condition represents fields as conditions in the selected data module, comparison operators can be configured among the fields, and the query condition can also represent the data query range, namely, the range is designated in the selected data model for query; query ranking indicates the manner in which field values in the query result are ranked, for example: ascending or descending order, and the like. The query packet indicates a field in the query result that is grouped.

For example, referring to the schematic diagram of the query topic configuration interface shown in fig. 3, the query topic configuration interface includes a basic information area and a detailed information area disposed above, and a developer inputs a field value of a query topic name, a field value of a query topic description, a field value of a directory, and a logic value of an initialization execution query in an input box of the basic information area through an input device; to represent the mandatory fields, the mandatory fields are labeled and are shown in fig. 3: the top left corner of the name and directory is marked with a x number.

The developer sets a query model, query items, query association, query conditions, query ordering and query grouping in a detailed information area through an input device, a tab control corresponding to each piece of information is arranged above the detailed information area, each tab control is provided with a page signature scale, each tab control corresponds to a sub-interface of information of a certain dimension set by a user, when a certain tab control is selected, terminal equipment can switch and display the corresponding sub-interface in the detailed information area, and the selected tab control is highlighted. For example: in fig. 3, when the 1 st tab control is selected, a sub-interface for configuring the query model is displayed in the detailed information area, where a new control, a delete control, a copy control, an up control and a down control are disposed above the sub-interface, and an attribute table of the selected data model is disposed below the sub-interface, where attribute fields and field values of the selected data model are stored, for example: the attribute fields are sequence number, model class and model type. The new control is used for adding a data model, the deletion control is used for deleting the existing data model, the duplication control is used for copying data in the unit cells of the attribute table, the up-shift control is used for moving the rows in the attribute table upwards by one row, and the next control is used for moving the rows in the attribute table downwards by one row.

Further, in fig. 4, when the 2 nd tab control is selected, a sub-interface for configuring the query item is displayed in the detailed information area, a new control, a delete control, a copy control, an up control and a down control are arranged above the sub-interface, an attribute table of the query item is arranged below the sub-interface, and a sequence number, a name of the query item, an expression, a display name and field values of the above fields are stored in the attribute table. The new control is used for adding a query field, the deletion control is used for deleting the existing query field, the duplication control is used for copying data in the unit cells of the attribute table, the up-shift control is used for moving the rows in the attribute table upwards by one row, and the next control is used for moving the rows in the attribute table downwards by one row.

Further, in fig. 5, when the 3 rd tab control is selected, a sub-interface for configuring query association is displayed in the detailed information area, a new control, a delete control, a copy control, an up control and a down control are arranged above the sub-interface, an attribute table of association type is arranged below the sub-interface, and the attribute table stores a sequence number, association type, left item, right item and field values of the above fields. The new control is used for adding an association relation, the deletion control is used for deleting the existing association relation, the duplication control is used for copying data in the unit cells of the attribute table, the up-shift control is used for moving the rows in the attribute table upwards by one row, and the next control is used for moving the rows in the attribute table downwards by one row.

Further, in fig. 6, when the 4 th tab control is selected, a sub-interface for configuring the query condition is displayed in the detailed information area, a new control, a delete control, a copy control, an up control and a down control are disposed above the sub-interface, and an attribute table of an associated type is disposed below the sub-interface, where a sequence number, a condition item, an expression, a display name, a comparison operator, a query start value, a query end value, a variable condition, a condition state and field values of the respective fields are stored in the attribute table. The new control is used for adding a query condition, the deletion control is used for deleting the existing query condition, the duplication control is used for copying data in the unit cells of the attribute table, the up-shift control is used for moving the rows in the attribute table upwards by one row, and the next control is used for moving the rows in the attribute table downwards by one row.

Further, in fig. 7, when the 5 th tab control is selected, a sub-interface for configuring the sorting mode is displayed in the detailed information area, a new control, a delete control, a copy control, an up control and a down control are arranged above the sub-interface, an attribute table of an associated type is arranged below the sub-interface, and a sequence number, a sorting item, a sorting type and field values of the fields are stored in the attribute table. The new control is used for adding a sorting mode, the deletion control is used for deleting the existing sorting mode, the duplication control is used for copying data in the unit cells of the attribute table, the up-shift control is used for moving the rows in the attribute table upwards by one row, and the next control is used for moving the rows in the attribute table downwards by one row.

S203, storing the configured query topic information into a topic database.

The terminal equipment stores the configured inquiry topic information in a topic database, and a plurality of inquiry topic information configured by a developer is stored in the topic database.

S204, selecting one query topic information in the topic database based on the displayed query scheme newly-added interface.

The terminal equipment displays a new query scheme interface, and a user realizes the operations of selecting query subject information, inputting field values representing the attribute of the query scheme and the like by interacting on the new query scheme interface.

For example, referring to the query scheme new interface shown in fig. 8, a name input control, a query topic selection control and a description input control are provided on the query scheme new interface, and a user inputs the name of the query scheme in the name input control through an input device. When a user triggers a query topic selection control through an input device, a plurality of candidate query topic information is displayed after a query topic database is queried, and then the user selects one piece of required query topic information from the plurality of query topic information; the user inputs descriptive information of the query plan through the descriptive input control. And after the setting is completed, triggering a determination control to store the information.

S205, based on the displayed query scheme configuration interface, generating query scheme information by using the selected query subject information and the configured query format.

After the user completes relevant configuration based on the new query scheme interface, the terminal equipment displays a query scheme configuration interface, and the selected query scheme information is loaded in the query scheme configuration interface: query models, query terms, query associations, query conditions, query rankings, and query groupings. In addition, a control for configuring a query format is set in the query scheme configuration interface, and the query format represents screening conditions in the query result.

For example, referring to the query plan configuration interface shown in fig. 9, the query plan configuration interface is provided with a basic information area and a detailed information area, and basic information of the query plan is displayed in the basic information area and can be modified. The upper part of the detailed information area is provided with 6 page controls, the front 5 page controls are the same as the page configuration interface corresponding to the query subject in fig. 3, the data of the sub-interfaces corresponding to the 5 page controls are obtained according to the selected query subject information during initialization, the information of the 4 page controls except the query model page of the 5 page controls can be added but not deleted, the query related page of the query subject is not displayed in the query scheme, the built-in association relationship is developed, and the user does not need to display. The 6 th tab control is a sub-interface corresponding to the query format, when the 6 th tab control is selected, a sub-interface for configuring the query format is displayed in the detailed information area, a new control, a deletion control, a copy control, an up-shift control and a down-shift control are arranged above the sub-interface, an attribute table of the query format is arranged below the sub-interface, and a sequence number, a format name, a default format, an explanation and field values of the fields are stored in the attribute table. The new control is used for adding a query format, the deletion control is used for deleting the existing query format, the duplication control is used for copying data in the unit cells of the attribute table, the up-shift control is used for moving the rows in the attribute table upwards by one row, and the next control is used for moving the rows in the attribute table downwards by one row.

S206, obtaining the query result according to the query scheme information and displaying the query result in the query interface.

The terminal device generates a query instruction according to the query scheme information, and sends the query instruction to a database where the selected one or more data models are located, for example: the query instruction is an SQL instruction, and the SQL instruction can be obtained by packaging by using a hibernate related tool class. And then the terminal equipment receives the returned query result and displays the query result on a query interface, wherein the query interface is provided with a screening condition area and a result display area.

For example, referring to the schematic diagram of the query interface shown in fig. 10, a filtering condition area is disposed above the query interface, a result display area is disposed below the query interface, the filtering condition area is used for filtering query results in the result display area, an input box of a filtering field is disposed in the filtering condition area, the filtering field includes a reimburser, reimbursement time, reimbursement department, payer, total amount, payment time, reimbursement bill operator, a user inputs a field value in the input box, and the filtering condition area is further provided with a query control and a reset control for performing a query operation based on the input field value and a reset operation on the input field value. The result display area is provided with a data table, and the fields in the data table comprise: serial number, sales person, time of reimbursement, reimbursement department, payer, total amount, payment amount, time of payment. Further, the filtering condition area is further provided with an export control, and when the user triggers the export control through the input device, the data table in the result display area is exported in a specified format, for example: the data table is exported to a preset directory in xml, wps or pdf format. According to the embodiment, the query structure can be further screened by setting the screening condition area, so that the accuracy of data query is enhanced.

When the embodiment of the application performs data query in the data model, a query theme is established on the interface, the query model is directly selected, the query items are configured, the association types and the association relations of the items are set, the query conditions are configured, and the ordering items are configured, so that the comprehensive query requirement can be rapidly realized without writing codes. Different comprehensive query scenes can be established to finish different query topics, zero code development is realized, the effect of quick response can be achieved, rich query scenes are met, and the stability of a program can be ensured.

The following are examples of the apparatus of the present application that may be used to perform the method embodiments of the present application. For details not disclosed in the embodiments of the apparatus of the present application, please refer to the embodiments of the method of the present application.

Referring to fig. 11, a schematic structural diagram of a query device for a data model according to an exemplary embodiment of the present application is shown, which is hereinafter referred to as device 11. The apparatus 11 may be implemented as all or part of a terminal device by software, hardware or a combination of both. The apparatus 11 comprises: a display unit 1101, a setting unit 1102, a writing unit 1103, a selecting unit 1104, a generating unit 1105, and a querying unit 1106.

A display unit 1101 for displaying a query topic configuration interface;

a setting unit 1102, configured to set query topic information based on the query topic configuration interface; wherein the query topic information includes: query models, query terms, query associations, query conditions, query ordering, and query groupings;

a writing unit 1103, configured to store the configured query topic information into a topic database;

a selecting unit 1104, configured to select one query topic information in the topic database based on the displayed query scheme new interface;

a generating unit 1105, configured to generate query plan information using the selected query topic information and the configured query format based on the displayed query plan configuration interface;

and the query unit 1106 is configured to obtain a query result according to the query scheme information and display the query result in a query interface.

In one or more possible embodiments, the query topic configuration page includes a basic information area and a detailed information area, the basic information area is used for inputting a field value of a query topic, the detailed information area is provided with a plurality of tab controls, the tab controls are used for switching display sub-interfaces, and the sub-interfaces are provided with a new control, a delete control, an up control and an attribute table.

In one or more possible embodiments, the selecting, based on the displayed query plan addition interface, one query topic information in the topic database includes:

displaying a new interface of the query scheme through a display unit; the new query scheme interface comprises an attribute input control and a query theme selection control;

acquiring a field value which is input by a user and represents the attribute of the query scheme through the attribute input control;

based on triggering operation of the theme selection control by a user, displaying a plurality of candidate inquiry theme information stored in the theme database;

one of the plurality of candidate query topic information is selected based on a user selection operation.

In one or more possible embodiments, the query plan configuration interface, based on the displayed query plan configuration interface, generates query plan information using the selected query topic information and the configured query format, includes:

after detecting the confirmation operation of the user to the newly added interface of the query scheme, displaying a configuration interface of the query scheme through a display unit;

loading selected query subject information on the query scheme configuration interface and acquiring a query format based on configuration operation of a user;

and generating query scheme information according to the selected query subject information and the query format.

In one or more possible embodiments, the obtaining the query result according to the query scheme information includes:

generating an SQL instruction by utilizing a hibernate tool according to the query scheme information, and sending the SQL instruction to a data model corresponding to the selected query subject information;

and receiving a query result returned by the data model in response to the SQL instruction.

In one or more possible embodiments, the query interface includes a filtering condition area including input boxes corresponding to a plurality of filtering fields, and a result display area including a data table.

In one or more possible embodiments, the query interface is further provided with an export control; further comprises:

and the export unit is used for detecting the triggering operation of the user based on the export control and exporting the data table in the result display area to a specified directory in a specified format.

It should be noted that, when the apparatus 4 provided in the foregoing embodiment performs the query method of the data model, only the division of the foregoing functional modules is used as an example, and in practical application, the foregoing functional allocation may be performed by different functional modules according to needs, that is, the internal structure of the device is divided into different functional modules to complete all or part of the foregoing functions. In addition, the query device of the data model provided in the above embodiment belongs to the same concept as the query method embodiment of the data model, which embodies the detailed implementation process and is not described herein.

The foregoing embodiment numbers of the present application are merely for the purpose of description, and do not represent the advantages or disadvantages of the embodiments.

The embodiment of the present application further provides a computer storage medium, where the computer storage medium may store a plurality of instructions, where the instructions are adapted to be loaded by a processor and execute the steps of the method shown in the embodiment of fig. 2, and the specific execution process may refer to the specific description of the embodiment shown in fig. 2, which is not repeated herein.

The present application also provides a computer program product storing at least one instruction that is loaded and executed by the processor to implement the method of querying a data model as described in the various embodiments above.

Referring to fig. 12, a schematic structural diagram of a terminal device is provided in an embodiment of the present application. As shown in fig. 12, the terminal device 1200 may include: at least one processor 1201, at least one network interface 1204, a user interface 1203, a memory 1205, at least one communication bus 1202.

Wherein the communication bus 1202 is used to enable connected communications between the controls.

The user interface 1203 may include a Display screen (Display) and a Camera (Camera), and the optional user interface 1203 may further include a standard wired interface and a standard wireless interface.

The network interface 1204 may optionally include a standard wired interface, a wireless interface (e.g., WI-FI interface), among others.

Wherein the processor 1201 may include one or more processing cores. The processor 1201 connects various parts within the overall terminal apparatus 1200 using various interfaces and lines, performs various functions of the terminal 1200 and processes data by executing or executing instructions, programs, code sets, or instruction sets stored in the memory 1205, and invoking data stored in the memory 1205. Alternatively, the processor 1201 may be implemented in at least one hardware form of digital signal processing (Digital Signal Processing, DSP), field-Programmable gate array (FPGA), programmable logic array (Programmable Logic Array, PLA). The processor 1201 may integrate one or a combination of several of a central processing unit (Central Processing Unit, CPU), an image processor (Graphics Processing Unit, GPU), and a modem, etc. The CPU mainly processes an operating system, a user interface, an application program and the like; the GPU is used for rendering and drawing the content required to be displayed by the display screen; the modem is used to handle wireless communications. It will be appreciated that the modem may not be integrated into the processor 1201 and may be implemented by a single chip.

The Memory 1205 may include a random access Memory (RandomAccess Memory, RAM) or a Read-Only Memory (Read-Only Memory). Optionally, the memory 1205 includes a non-transitory computer readable medium (non-transitory computer-readable storage medium). The memory 1205 may be used to store instructions, programs, code sets, or instruction sets. The memory 1205 may include a stored program area and a stored data area, wherein the stored program area may store instructions for implementing an operating system, instructions for at least one function (such as a touch function, a sound playing function, an image playing function, etc.), instructions for implementing the above-described various method embodiments, etc.; the storage data area may store data or the like referred to in the above respective method embodiments. The memory 1205 may also optionally be at least one storage device located remotely from the processor 1201. As shown in fig. 12, an operating system, network communication modules, user interface modules, and application programs may be included in the memory 1205 as one type of computer storage medium.

In the terminal device 1200 shown in fig. 12, the user interface 1203 is mainly used as an interface for providing input for a user, and acquires data input by the user; the processor 1201 may be configured to invoke an application program stored in the memory 1205, and specifically perform the method shown in fig. 2, and the specific process may be shown with reference to fig. 2, which is not repeated herein.

Those skilled in the art will appreciate that implementing all or part of the above-described methods in accordance with the embodiments may be accomplished by way of a computer program stored on a computer readable storage medium, which when executed may comprise the steps of the embodiments of the methods described above. The storage medium may be a magnetic disk, an optical disk, a read-only memory, a random access memory, or the like.

The foregoing disclosure is illustrative of the present application and is not to be construed as limiting the scope of the application, which is defined by the appended claims.

Claims (10)

1. A method for querying a data model, comprising:

displaying a query subject configuration interface;

setting query topic information based on the query topic configuration interface; wherein the query topic information includes: query models, query terms, query associations, query conditions, query ordering, and query groupings;

storing the configured query topic information into a topic database;

selecting one query subject information from the subject database based on the displayed new query scheme interface;

generating query plan information by using the selected query topic information and the configured query format based on the displayed query plan configuration interface;

and obtaining a query result according to the query scheme information and displaying the query result in a query interface.

2. The method of claim 1, wherein the query topic configuration page includes a basic information area and a detailed information area, the basic information area is used for inputting field values of a query topic, the detailed information area is provided with a plurality of tab controls, the tab controls are used for switching display sub-interfaces, and the sub-interfaces are provided with a new control, a delete control, an up control and an attribute table.

3. The method according to claim 1 or 2, wherein the selecting one query topic information in the topic database based on the displayed query plan add-on interface comprises:

displaying a new interface of the query scheme through a display unit; the new query scheme interface comprises an attribute input control and a query theme selection control;

acquiring a field value which is input by a user and represents the attribute of the query scheme through the attribute input control;

based on triggering operation of the theme selection control by a user, displaying a plurality of candidate inquiry theme information stored in the theme database;

one of the plurality of candidate query topic information is selected based on a user selection operation.

4. The method of claim 3, wherein the generating query plan information using the selected query topic information and the configured query format based on the displayed query plan configuration interface comprises:

after detecting the confirmation operation of the user to the newly added interface of the query scheme, displaying a configuration interface of the query scheme through a display unit;

loading selected query subject information on the query scheme configuration interface and acquiring a query format based on configuration operation of a user;

and generating query scheme information according to the selected query subject information and the query format.

5. The method according to claim 1, 2 or 4, wherein obtaining the query result according to the query scheme information comprises:

generating an SQL instruction by utilizing a hibernate tool according to the query scheme information, and sending the SQL instruction to a data model corresponding to the selected query subject information;

and receiving a query result returned by the data model in response to the SQL instruction.

6. The method of claim 5, wherein the query interface comprises a screening criteria field comprising a plurality of input boxes corresponding to screening fields and a results display field comprising a data table.

7. The method of claim 6, wherein the query interface is further provided with an export control;

the method further comprises the steps of:

and detecting that the user exports the data table in the result display area to a specified directory in a specified format based on the triggering operation of the export control.

8. A data model query device, comprising:

the display unit is used for displaying a query theme configuration interface;

the setting unit is used for setting query topic information based on the query topic configuration interface; wherein the query topic information includes: query models, query terms, query associations, query conditions, query ordering, and query groupings;

the writing unit is used for storing the configured inquiry theme information into a theme database;

the selecting unit is used for selecting one query topic information from the topic database based on the displayed query scheme newly-added interface;

the generating unit is used for generating query scheme information by using the selected query subject information and the configured query format based on the displayed query scheme configuration interface;

and the query unit is used for obtaining the query result according to the query scheme information and displaying the query result in a query interface.

9. A computer storage medium storing a plurality of instructions adapted to be loaded by a processor and to perform the method steps of any one of claims 1 to 7.

10. A terminal device, comprising: a processor and a memory; wherein the memory stores a computer program adapted to be loaded by the processor and to perform the method steps of any of claims 1-7.