Method, system, device and medium for performing extended query on basic query object

Abstract

The present invention relates to the field of computer technology, and discloses a method, system, device and medium for performing extended query on a basic query object. The method comprises: obtaining the query dimension and query content for performing extended query on the basic query object according to the target query entity; establishing a mapping relationship between the query dimension and the data source dimension in the target service unit; obtaining the corresponding data source according to the mapping relationship and the dimension value transmitted for performing extended query on the basic query object; establishing the extended attribute of the basic query object according to the query content; determining the template corresponding to it according to the dimension value; establishing a customized model according to the extended attribute, the data source and the template corresponding to it; in response to performing extended query on the basic query object, parsing the customized model, and injecting the parsing result into the basic query entity for logical query to obtain the result of the extended query. The method disclosed in the present invention supports real-time expansion, has good flexibility and reusability, and has low maintenance cost.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a method, system, device and medium for performing extended query on a basic query object. Background Art

[0002] To solve the hierarchical expansion problem of complex query business logic at different levels such as standard products, industry products, and projects: for example, industry products are expanded based on standard product functions, and special requirements of different projects (customers) are expanded based on industry products or standard products; different product levels are developed and maintained by different departments (products, industry divisions, delivery). How to achieve the best satisfaction in terms of reuse, flexibility, performance, etc., and how to reduce customer development, debugging, and maintenance costs are the problems that industry queries need to solve at present.

[0003] Currently, there are several main problems with industry inquiries: no support for customized functions, special needs cannot be expanded on standard products, development is difficult and maintenance costs are high; complex needs need to be modified during design and cannot take effect in real time, which increases the cost of deployment and debugging. Summary of the invention

[0004] In view of this, the present invention proposes a method, system, device and medium for performing extended query on basic query objects. Among them, the method for performing extended query on basic query objects proposed by the present invention can be expanded and customized according to actual business needs, and supports extended query at the time of query based on the basic query object. The method for performing extended query on basic query objects proposed by the present invention provides a hierarchical query expansion method, which is convenient for users to use based on basic query objects; and it takes effect in real time when the query is running, and has good reusability and flexibility.

[0005] Based on the above purposes, an embodiment of the present invention provides a method for performing an extended query on a basic query object, comprising the following steps: obtaining query dimensions and query content for performing an extended query on a basic query object according to a target query entity; establishing a mapping relationship between the query dimension and the data source dimension in a target service unit; obtaining a corresponding data source according to the mapping relationship and the dimension value passed for performing an extended query on the basic query object; establishing an extended attribute of the basic query object according to the query content; determining a template corresponding to the dimension value according to the dimension value; establishing a customized model according to the extended attribute, the data source and the template corresponding to the dimension value; in response to performing an extended query on the basic query object, parsing the customized model, and injecting the parsing result into the basic query entity corresponding to the basic query object for performing a logical query to obtain a result of performing an extended query on the query object.

[0006] In some embodiments, in response to performing an extended query on the basic query object, parsing the custom model, and injecting the parsed result into the basic query entity corresponding to the basic query object for a logical query to obtain a result of the extended query on the query object includes: parsing the custom model and constructing an extension package consistent with the structure of the basic query entity; distributing the extension package to the target service unit, and combining the corresponding data source and query logic in the target service unit to obtain an extension package with the extended query; in response to the extension package with the extended query being recognized by the basic query entity, injecting the extension package with the extended query into the basic query entity for an extended query to obtain a query result.

[0007] In some embodiments, obtaining the query dimensions and query content for an extended query on a basic query object based on a target query entity includes: determining the scope of the parameter dimensions and variable dimensions of the query dimensions based on the parameters and variables of the basic query object; and determining the scope of the query content based on the content in the target query entity that requires user customization.

[0008] In some embodiments, obtaining the corresponding data source according to the mapping relationship and the dimension value passed by the extended query on the basic query object includes: obtaining the data source dimension corresponding to the basic query object according to the query dimension of the extended query on the basic query object; obtaining the corresponding data source according to the data source dimension and the passed dimension value.

[0009] In some embodiments, establishing the extended attributes of the basic query object according to the query content includes: establishing the extended attributes of the basic query object including associated entities, display fields, filter fields, data permissions and joint queries according to the query content.

[0010] In some embodiments, determining the template corresponding to the dimension value based on the dimension value includes: establishing a template including a system format, a public format and a user format; determining the template corresponding to the dimension value based on the dimension value, and being able to customize the corresponding template according to business needs and display it in a tree structure.

[0011] In some embodiments, determining the template corresponding to the dimension value according to the dimension value further includes: providing a dimension filtering mechanism to filter out templates using the dimension value according to the dimension value.

[0012] According to another aspect of an embodiment of the present invention, a system for performing an extended query on a basic query object is provided, comprising the following modules: a first module, configured to obtain a query dimension and a query content for performing an extended query on a basic query object according to a target query entity; a second module, configured to establish a mapping relationship between a query dimension and a data source dimension in a target service unit; a third module, configured to obtain a corresponding data source according to the mapping relationship and the dimension value passed for performing an extended query on the basic query object; a fourth module, configured to establish an extended attribute of the basic query object according to the query content; a fifth module, configured to determine a template corresponding to the dimension value according to the dimension value; a sixth module, configured to establish a customized model according to the extended attribute, the data source and the template corresponding to the dimension value; and a seventh module, configured to parse the customized model in response to performing an extended query on the basic query object, and inject the parsed result into the basic query entity corresponding to the basic query object for a logical query to obtain a result of performing an extended query on the query object.

[0013] Another aspect of an embodiment of the present invention provides a computer device, comprising at least one processor; and a memory, wherein the memory stores computer instructions executable on the processor, and the instructions implement the steps of any of the above methods when executed by the processor.

[0014] According to another aspect of an embodiment of the present invention, a computer-readable storage medium is provided, which stores a computer program that implements any of the above method steps when executed by a processor.

[0015] The present invention has at least the following beneficial effects: the present invention proposes a method, system, device and medium for performing extended query on basic query objects, wherein the present invention provides a method for performing extended query on basic query objects, and provides a real-time modeling and hierarchical extension method based on basic query objects for the runtime environment, which is convenient for users to use based on basic query objects and supports real-time customization functions. Special business needs can be expanded on the basis of basic query objects, with low development difficulty and low maintenance cost. In addition, queries can be extended in real time for complex needs without the need to re-modify the design, with good reusability and flexibility, while avoiding increased deployment and debugging costs. BRIEF DESCRIPTION OF THE DRAWINGS

[0016] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings in the following description are only some embodiments of the present invention. For ordinary technicians in this field, other embodiments can be obtained based on these drawings without paying creative work.

[0017] Figure 1 A schematic diagram of an embodiment of a method for performing an extended query on a basic query object provided by the present invention;

[0018] Figure 2 Another schematic diagram of an embodiment of a method for performing an extended query on a basic query object provided by the present invention;

[0019] Figure 3 A schematic diagram of an embodiment of a system for performing an extended query on a basic query object provided by the present invention;

[0020] Figure 4 A schematic diagram of an embodiment of a computer device provided by the present invention;

[0021] Figure 5 A schematic diagram of an embodiment of a computer-readable storage medium provided by the present invention. DETAILED DESCRIPTION

[0022] The following describes embodiments of the present invention. However, it should be understood that the disclosed embodiments are merely examples and other embodiments can take various alternative forms.

[0023] In addition, it should be noted that all expressions using "first" and "second" in the embodiments of the present invention are intended to distinguish two entities with the same name but not the same or non-identical parameters. It can be seen that "first" and "second" are only for the convenience of expression and should not be understood as limitations on the embodiments of the present invention. The subsequent embodiments will not explain this one by one. The terms "include", "comprise" or any other variation thereof are intended to cover non-exclusive inclusions, so that a process, method, article or device that includes a series of elements includes not only those elements, but also elements that are not explicitly listed or inherent to these processes, methods, articles or devices.

[0024] One or more embodiments of the present application will be described below with reference to the accompanying drawings.

[0025] Based on the above objectives, a first aspect of an embodiment of the present invention provides an embodiment of a method for performing an extended query on a basic query object. Figure 1 FIG. 2 is a schematic diagram of an embodiment of a method for performing an extended query on a basic query object provided by the present invention. Figure 1 As shown, a method for performing an extended query on a basic query object according to an embodiment of the present invention includes the following steps:

[0026] S1. Obtaining query dimensions and query contents for extended query of basic query objects according to target query entities;

[0027] S2. Establishing a mapping relationship between the query dimension and the data source dimension in the target service unit;

[0028] S3, obtaining a corresponding data source according to the mapping relationship and the dimension value transmitted by performing an extended query on the basic query object;

[0029] S4, establishing the extended attributes of the basic query object according to the query content;

[0030] S5. Determine a template corresponding to the dimension value according to the dimension value;

[0031] S6. Establishing a customized model according to the extended attribute, the data source, and a template corresponding to the dimension value;

[0032] S7. In response to performing an extended query on the basic query object, the customized model is parsed, and the parsing result is injected into a basic query entity corresponding to the basic query object for performing a logical query to obtain a result of performing an extended query on the query object.

[0033] Figure 2 FIG. 2 is another schematic diagram of an embodiment of a method for performing an extended query on a basic query object provided by the present invention. Figure 2 As shown, in an actual operating environment, a method for extending a basic query object according to a target query entity is described.

[0034] Provide preconditions for extended query based on the target query entity on the basis of the basic query object, which is used to undertake assembly execution including query dimension definition, data source dimension, and customized content, so as to provide preconditions for extended query runtime. The query dimension definition includes parameter dimension and variable dimension. Parameters or variables can only be selected on the basic query object, and the input type supports enumeration and help. It is understandable that the definition of query dimension does not exceed two dimensions at present. The data source can extend multiple extended entities under different dimension values, so if you want to determine the only data source, you need to set the mapping relationship between the query dimension and the data source dimension in the target service unit, that is, determine the corresponding data source when the extended query is running. Customized content is used to set the customized content range when the extended query is running, only display the content that the user needs to customize, and hide other redundant content to simplify the development process. In actual applications, it is understandable that the dimension definition, mapping relationship of data source dimension and customized content that provide preconditions for extended query runtime can be concentrated under the query extension function for users to specify.

[0035] Customization is performed when the extended query is running according to the preconditions, the actual customization content is assumed and displayed in a template tree structure, the corresponding data source in the target query unit is obtained according to the mapping relationship and the passed dimension value, the extended attributes of the basic query object are obtained based on the basic query object according to the query content, and a customized model is established according to the template corresponding to the data source, the extended attributes and the dimension value.

[0036] The extended attributes of the basic query object include associated entities, display fields, filter fields, data permissions, and joint queries. In practical applications, it is understandable that the extended attributes of the basic query object can be concentrated under the function of the custom template configurator for users to use. Associated entities are used to customize the relationship between the current business entity and other entities. Display fields are used to customize additional fields displayed in the query. Fields are customized based on the display fields of the basic query object, and fields on the associated entity can be selected. Filter fields are used to customize additional filter fields for queries and embed filter fields in the query form. Data permissions are used to customize query data access rights. Customized data at query runtime often has data permission control requirements, which constrains the data displayed for queries under different user conditions. Joint queries are used to display joint query information on customized fields.

[0037] One or a group of dimension values ​​corresponds to a template. In actual applications, in order to facilitate user development and use, templates are divided into three formats: system format, public format and user format. The system format is the basic query object format and is the root node of the template display tree. It cannot be edited or deleted. The public format is a format extended from a dimension value and can be edited, deleted and extended. The user format is a format extended from a group of dimension values. A group of dimension values ​​determines a unique template, so the user format is a leaf node of the template display tree and cannot be extended. The specific attributes of the template format are shown in Table 1.

[0038] Template Name Allowed attributes Prohibited attributes System Format Extensions Edit, Delete Public formats Edit, Delete, Expand none User Format Edit, Delete Extensions

[0039] Table 1

[0040] In the actual operation environment, when the structure of the template display tree is too complex, the templates using a certain dimension value can be filtered out by providing a dimension filter, which is convenient for users to use. The dimension filter supports enumeration and helps selection. In actual applications, it is understandable that the custom template configurator function, the template display tree, and the dimension filter can be integrated into the query runtime customization function, and when the query is run, it is constructed as a custom model for use.

[0041] When an extended query is performed on a basic query object, the custom model is parsed, and the parsing result is injected into a basic query entity corresponding to the basic query object for a logical query, and finally a result of the extended query on the query object is obtained.

[0042] In the actual running environment, the custom model built at query runtime is parsed by the extractor according to its function, that is, the custom model is disassembled, extracted, and an extension package (class object) is constructed that is consistent with the basic query entity structure. The extractor needs to organize its context, including the custom model built at query runtime, business entity information, grouping information, etc. In the actual running environment, the interface and implementation class of the extractor can be implemented in the following ways:

[0043]

[0044]

[0045]

[0046] It can be understood that the above is one way to implement the extractor interface and implementation class, but it is not limited to the only way.

[0047] The extension package is the core carrier for extending the query of the basic query object. Since the structure of the extension package is consistent with that of the basic query entity, it is convenient for the basic query entity to identify it and inject the extension package into it for logical query. In the actual operation environment, the query runtime customization function is configured in the system service unit, and the data source and execution logic rules for the extended query are in the target service unit. Therefore, the extension package needs to be distributed to the target service unit through the routing device, combined with the data source and query logic in the target service unit, and then injected into the basic query entity through the injector for corresponding logical query. In the actual operation environment, the extension package implementation class can be implemented in the following way:

[0048]

[0049] The extension package is injected into the basic query entity through the syringe. In the actual running environment, the extension package implementation class can be implemented in the following way:

[0050]

[0051]

[0052] Based on the above objectives, a second aspect of an embodiment of the present invention provides a system for performing extended query on a basic query object. Figure 3 FIG. 1 is a schematic diagram of an embodiment of a system for performing an extended query on a basic query object provided by the present invention. Figure 3As shown, an embodiment of a system for performing extended query on a basic query object of the present invention includes the following modules: a first module 011, configured to obtain a query dimension and a query content for performing extended query on a basic query object according to a target query entity; a second module 012, configured to establish a mapping relationship between a query dimension and a data source dimension in a target service unit; a third module 013, configured to obtain a corresponding data source according to the mapping relationship and the dimension value passed for performing extended query on the basic query object; a fourth module 014, configured to establish an extended attribute of the basic query object according to the query content; a fifth module 015, configured to determine a template corresponding to the dimension value according to the dimension value; a sixth module 016, configured to establish a customized model according to the extended attribute, the data source and the template corresponding to the dimension value; and a seventh module 017, configured to parse the customized model in response to performing extended query on the basic query object, and inject the parsing result into the basic query entity corresponding to the basic query object for logical query, so as to obtain the result of performing extended query on the query object.

[0053] Based on the above objectives, a third aspect of an embodiment of the present invention provides a computer device. Figure 4 FIG. 2 is a schematic diagram of an embodiment of a computer device provided by the present invention. Figure 4 As shown, an embodiment of a computer device provided by the present invention includes the following modules: at least one processor 021; and a memory 022, wherein the memory 022 stores computer instructions 023 that can be executed on the processor 021, and the computer instructions 023 implement the steps of any of the above methods when executed by the processor 021.

[0054] The present invention also provides a computer-readable storage medium. Figure 5 FIG. 2 is a schematic diagram of an embodiment of a computer-readable storage medium provided by the present invention. Figure 5 As shown, the computer-readable storage medium 031 stores a computer program 032 that performs the above method when executed by a processor.

[0055] Finally, it should be noted that a person of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiments can be implemented by instructing the relevant hardware through a computer program, and the program of the method for setting system parameters can be stored in a computer-readable storage medium, and when the program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, the storage medium of the program can be a disk, an optical disk, a read-only storage memory (ROM) or a random access memory (RAM), etc. The above-mentioned computer program embodiments can achieve the same or similar effects as the corresponding above-mentioned arbitrary method embodiments.

[0056] In addition, the method disclosed in the embodiment of the present invention can also be implemented as a computer program executed by a processor, and the computer program can be stored in a computer-readable storage medium. When the computer program is executed by the processor, the above functions defined in the method disclosed in the embodiment of the present invention are performed.

[0057] In addition, the above method steps and system units may also be implemented using a controller and a computer-readable storage medium for storing a computer program that enables the controller to implement the above steps or unit functions.

[0058] It will also be appreciated by those skilled in the art that various exemplary logic blocks, modules, circuits and algorithm steps described in conjunction with the disclosure herein can be implemented as electronic hardware, computer software or a combination of the two. In order to clearly illustrate this interchangeability of hardware and software, a general description has been given to the functions of various schematic components, blocks, modules, circuits and steps. Whether this function is implemented as software or hardware depends on specific applications and the design constraints imposed on the entire system. Those skilled in the art can implement the function in various ways for each specific application, but this implementation decision should not be interpreted as causing a departure from the disclosed scope of the embodiments of the present invention.

[0059] In one or more exemplary designs, the function can be implemented in hardware, software, firmware or any combination thereof. If implemented in software, the function can be stored on a computer-readable medium or transmitted by a computer-readable medium as one or more instructions or codes. Computer-readable media include computer storage media and communication media, and the communication media include any media that helps to transmit a computer program from one location to another. The storage medium can be any available medium that can be accessed by a general or special computer. As an example and not limiting, the computer-readable medium may include RAM, ROM, EEPROM, CD-ROM or other optical disk storage devices, magnetic disk storage devices or other magnetic storage devices, or any other medium that can be used to carry or store the required program code in the form of an instruction or data structure and can be accessed by a general or special computer or a general or special processor. In addition, any connection can be appropriately referred to as a computer-readable medium. For example, if a coaxial cable, optical fiber cable, twisted pair, digital subscriber line (D0L) or wireless technologies such as infrared, radio and microwaves are used to send software from a website, server or other remote source, the above-mentioned coaxial cable, optical fiber cable, twisted pair, D0L or wireless technologies such as infrared, radio and microwaves are all included in the definition of the medium. As used herein, disk and disc include compact disc (CD), laser disc, optical disc, digital versatile disc (DVD), floppy disk, Blu-ray disc, wherein disks usually reproduce data magnetically, while optical discs reproduce data optically with lasers. Combinations of the above should also be included within the scope of computer-readable media.

[0060] The above are exemplary embodiments disclosed in the present invention, but it should be noted that various changes and modifications may be made without departing from the scope disclosed in the embodiments of the present invention as defined in the claims. The functions, steps and / or actions of the method claims according to the disclosed embodiments described herein do not need to be performed in any particular order. In addition, although the elements disclosed in the embodiments of the present invention may be described or required in individual form, they may also be understood as multiple unless explicitly limited to the singular.

[0061] It should be understood that, as used herein, the singular forms "a", "an" are intended to include the plural forms as well, unless the context clearly supports an exception. It should also be understood that, as used herein, "and / or" refers to any and all possible combinations including one or more of the associated listed items.

[0062] The serial numbers of the embodiments disclosed in the above embodiments of the present invention are only for description and do not represent the advantages or disadvantages of the embodiments.

[0063] A person skilled in the art will understand that all or part of the steps to implement the above embodiments may be accomplished by hardware or by instructing related hardware through a program, and the program may be stored in a computer-readable storage medium, and the above-mentioned storage medium may be a read-only memory, a disk or an optical disk, etc.

[0064] A person skilled in the art should understand that the discussion of any of the above embodiments is only exemplary and is not intended to imply that the scope of the disclosure of the embodiments of the present invention (including the claims) is limited to these examples; under the concept of the embodiments of the present invention, the technical features in the above embodiments or different embodiments can also be combined, and there are many other changes in different aspects of the embodiments of the present invention as above, which are not provided in detail for the sake of simplicity. Therefore, any omissions, modifications, equivalent substitutions, improvements, etc. made within the spirit and principles of the embodiments of the present invention should be included in the protection scope of the embodiments of the present invention.

Claims

1. A method for performing an extended query on a basic query object, characterized in that: include: Obtain the query dimension and query content for performing an extended query on the basic query object according to the target query entity; Establishing a mapping relationship between the query dimension and the data source dimension in the target service unit; Obtain a corresponding data source according to the mapping relationship and the dimension value of the extended query transmission of the basic query object, wherein the data source is the only data source determined; Establishing the extended attribute of the basic query object according to the query content; Determine a template corresponding to the dimension value according to the dimension value; Establishing a customized model according to the extended attribute, the data source and a template corresponding to the dimension value; In response to performing an extended query on the basic query object, the custom model is parsed, and the parsed result is injected into a basic query entity corresponding to the basic query object for logical query to obtain a result of performing an extended query on the query object.

2. A method for performing an extended query on a basic query object according to claim 1, characterized in that: In response to performing an extended query on the basic query object, parsing the custom model, and injecting the parsing result into the basic query entity corresponding to the basic query object for logical query to obtain the result of performing the extended query on the query object includes: Parsing the custom model and constructing an extension package consistent with the basic query entity structure; Distributing the extension package to the target service unit, and combining the corresponding data source and query logic in the target service unit to obtain an extension package with an extended query; In response to the extension package with the extended query being identified by the basic query entity, the extension package with the extended query is injected into the basic query entity to perform the extended query, so as to obtain a query result.

3. A method for performing an extended query on a basic query object according to claim 1, characterized in that: The step of obtaining the query dimension and query content for performing an extended query on the basic query object according to the target query entity includes: Determine the range of the parameter dimension and the variable dimension of the query dimension according to the parameters and variables of the basic query object; The scope of the query content is determined according to the content in the target query entity that needs to be customized by the user.

4. A method for performing an extended query on a basic query object according to claim 1, characterized in that: The step of performing an extended query on the basic query object according to the mapping relationship and the dimension value transmitted to obtain the corresponding data source includes: Obtaining a data source dimension corresponding to the basic query object according to a query dimension of an extended query performed on the basic query object; A corresponding data source is obtained according to the data source dimension and the transferred dimension value.

5. The method for performing an extended query on a basic query object according to claim 1, characterized in that: The step of establishing the extended attributes of the basic query object according to the query content includes: establishing the extended attributes of the basic query object including associated entities, display fields, filter fields, data permissions, and joint queries according to the query content.

6. A method for performing an extended query on a basic query object according to claim 1, characterized in that: Determining a template corresponding to the dimension value according to the dimension value includes: Create templates including system formats, public formats and user formats; A template corresponding to the dimension value is determined according to the dimension value, and the corresponding template can be customized according to business requirements and displayed in a tree structure.

7. A method for performing an extended query on a basic query object according to claim 6, characterized in that: Determining the template corresponding to the dimension value according to the dimension value also includes: providing a dimension filtering mechanism to filter out templates that use the dimension value according to the dimension value.

8. A system for performing extended query on a basic query object, characterized in that: include: The first module is configured to obtain the query dimension and query content for performing an extended query on the basic query object according to the target query entity; A second module is configured to establish a mapping relationship between a query dimension and a data source dimension in a target service unit; A third module is configured to obtain a corresponding data source according to the mapping relationship and the dimension value transmitted by the extended query on the basic query object, wherein the data source is a unique data source determined; A fourth module is configured to establish an extended attribute of the basic query object according to the query content; A fifth module is configured to determine a template corresponding to the dimension value according to the dimension value; A sixth module is configured to establish a customized model according to the extended attribute, the data source and a template corresponding to the dimension value; as well as The seventh module is configured to parse the custom model in response to an extended query on the basic query object, and inject the parsing result into the basic query entity corresponding to the basic query object for logical query to obtain the result of the extended query on the query object.

9. A computer device, characterized in that: include: at least one processor; as well as A memory storing computer instructions executable on the processor, wherein the instructions, when executed by the processor, implement the steps of the method according to any one of claims 1 to 7.

10. A computer-readable storage medium storing a computer program, characterized in that: When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 7 are implemented.

Images