CN110598107A

CN110598107A - Management method of query system and computer storage medium

Info

Publication number: CN110598107A
Application number: CN201910857543.8A
Authority: CN
Inventors: 朱炜峰
Original assignee: Enyike (beijing) Data Technology Co Ltd
Current assignee: Enyike (beijing) Data Technology Co Ltd
Priority date: 2019-09-09
Filing date: 2019-09-09
Publication date: 2019-12-20

Abstract

The embodiment of the application discloses a management method of a query system and a computer storage medium. The method comprises the following steps: acquiring a configuration file of a query page in a query system, wherein the configuration file comprises at least two pieces of query condition information and a value range of a corresponding query condition of each query condition; sending the configuration file; acquiring a selection result of the tenant of the query system on the information required to be used in the configuration file, wherein the selection result comprises the selected query condition and/or a value range corresponding to the selected query condition; generating a query system matched with the selection according to the selection result, wherein the query system comprises a query page and a used database; deploying the query system in a network used by the tenant.

Description

Management method of query system and computer storage medium

Technical Field

The present application relates to the field of information processing, and more particularly, to a method for managing a query system and a computer storage medium.

Background

Conditional queries are one of the most common usage scenarios in computer user interfaces. The condition of a general query interface is a fixed format. And presetting a fixed query condition to allow a user to input a selection. The method is suitable for general application scenes. But for more complex systems of data processing analysis. There are many query interfaces and query conditions. Fixed format conditional query interfaces are often not flexible enough. The condition query interface in some occasions has personalized requirements, and different users need different query conditions for the same query function. For a cloud application platform, different tenants and different industries have different formats of conditional queries for the same function.

In the related art, for more complex conditional queries, all query conditions are listed on the interface. The user uses the concerned query condition and ignores other query conditions. Because all the query conditions are listed in the query interface, a user can be interfered by irrelevant query conditions on the query interface, and inconvenience is brought to operation and use; in addition, the data dictionary used by the query condition cannot be personalized, and all users use the same data dictionary, so that the response speed of the query operation is influenced.

Disclosure of Invention

In order to solve any one of the above technical problems, the present application provides a method for managing a query system and a computer storage medium.

In order to achieve the object of the present application, the present application provides a method for managing an inquiry system, including:

acquiring a configuration file of a query page in a query system, wherein the configuration file comprises query condition information and a value range of a corresponding query condition of each query condition;

sending the configuration file;

acquiring a selection result of the tenant of the query system on the information required to be used in the configuration file, wherein the selection result comprises the selected query condition and/or a value range corresponding to the selected query condition;

generating a query system matched with the selection according to the selection result, wherein the query system comprises a query page and a used database;

deploying the query system in a network used by the tenant.

In an exemplary embodiment, the generating a query system matching the selection according to the selection result includes:

when each query page in the query pages is configured with display attribute information, setting display attributes for the selected query conditions to be displayed on the query pages according to the selection results, and setting the display for the unselected query conditions to be not displayed on the query pages; and/or the presence of a gas in the gas,

and determining target information matched with the value range from a preset database according to the value range corresponding to the selected query condition, and taking the target information as the database used by the query page.

setting a value verification strategy of the corresponding query condition according to the value range corresponding to the selected query condition, wherein:

and the value taking verification strategy is used for judging whether the value filled by the user accords with the value taking verification strategy or not by utilizing the value taking verification strategy after detecting that the corresponding value taking information exists in the query condition in the query page.

In an exemplary embodiment, after the query system is deployed in a network used by a tenant, the method further comprises:

after receiving an update request of a tenant for a configuration file of a query system, acquiring a selection result of the tenant for the configuration file of the query system;

and adjusting the query system of the tenant according to the selection result and the updating request.

In an exemplary embodiment, the adjusting the query system of the tenant according to the selection result and the update request includes:

when the update request only comprises the changed configuration item, acquiring the query condition and/or the value range of the query condition, which is required to be adjusted by the tenant to the query system, according to the selection result and the changed configuration item;

generating binding data required by the tenant for adjusting the query system according to the query condition required to be adjusted and/or the value range of the query condition;

and controlling the query system corresponding to the tenant to adjust the query system by using the binding data.

A computer storage medium comprising a processor and a memory, wherein the memory stores a computer program, the processor invoking the computer program in the memory to implement operations comprising:

sending the configuration file;

deploying the query system in a network used by the tenant.

In an exemplary embodiment, the processor invokes a computer program in the memory to perform operations for generating a query system matching the selection based on the selection result, including:

In one exemplary embodiment, after the processor invokes the computer program in memory to implement the operation of deploying the query system in the network used by the tenant, the processor invokes the computer program in memory to further implement the operations of:

In an exemplary embodiment, the processor calls a computer program in the memory to implement the operation of adjusting the query system of the tenant according to the selection result and the update request, including:

and controlling the query system corresponding to the tenant to adjust the query system by using the binding data. According to the embodiment provided by the application, the configuration file of the query page in the query system is acquired, the configuration file is sent, the selection result of the tenant of the query system on the required use information in the configuration file is acquired, the query system matched with the selection is generated according to the selection result, the query system is deployed in the network used by the tenant, the user-defined setting of the query page is achieved, the use requirements of different tenants are met, the modification on the query system is reduced, and the working efficiency is improved.

Additional features and advantages of the application will be set forth in the description which follows, and in part will be obvious from the description, or may be learned by the practice of the application. The objectives and other advantages of the application may be realized and attained by the structure particularly pointed out in the written description and claims hereof as well as the appended drawings.

Drawings

The accompanying drawings are included to provide a further understanding of the claimed subject matter and are incorporated in and constitute a part of this specification, illustrate embodiments of the subject matter and together with the description serve to explain the principles of the subject matter and not to limit the subject matter.

Fig. 1 is a flowchart of a management method of a query system according to an embodiment of the present application;

fig. 2 is a schematic diagram of a management method of a query system according to an embodiment of the present application.

Detailed Description

To make the objects, technical solutions and advantages of the present application more apparent, embodiments of the present application will be described in detail below with reference to the accompanying drawings. It should be noted that the embodiments and features of the embodiments in the present application may be arbitrarily combined with each other without conflict.

Fig. 1 is a flowchart of a management method of a query system according to an embodiment of the present application. The method shown in fig. 1 comprises:

step 101, obtaining a configuration file of a query page in a query system, wherein the configuration file comprises query condition information and a value range of a query condition corresponding to each query condition;

in an exemplary embodiment, the query page may include one or at least two query conditions, taking a ticketing query page for travel as an example, the page includes query conditions such as a starting place, a destination, a travel tool, time, price, and the like, each query condition has a different value range, the value ranges of the starting place and the destination are place name information, and the travel tool is a travel tool.

Step 102, sending the configuration file;

in one exemplary embodiment, the configuration file may be sent to an administrator of a different tenant; for example, a ticket booking website for travel ticket business, and a ticket booking website for travel in different enterprises.

103, obtaining a selection result of the tenant of the query system on the information required to be used in the configuration file, wherein the selection result includes the selected query condition and/or a value range corresponding to the selected query condition;

in an exemplary embodiment, the selected query condition may be all or part of the query conditions in the configuration file; for example, selecting a partial query term from a configuration file of a ticketing query page for travel, including a starting location, a destination, a time, and travel tools; the value range corresponding to the selected query condition, such as the starting place and the destination, can configure that the address information must be an address in china or at least two preset addresses.

104, generating a query system matched with the selection according to the selection result, wherein the query system comprises a query page and a used database;

in an exemplary embodiment, when each query page in the query pages is configured with display attribute information, according to the selection result, setting display attributes for the selected query conditions to be displayed on the query page, and setting display for the query conditions which are not selected to be not displayed on the query page; selecting a part of query items from a configuration file of a ticket query page of a trip, wherein the query items comprise a starting place, a destination, time and a trip tool, setting display attributes of the starting place, the destination, the time and the trip tool on the query page as display, and setting display attributes of price information on the query page as non-display;

the display of the query page is managed by using the display attribute, so that the maintenance of the display content in the query page can be reduced, the change of codes is reduced, and the same query page can meet the display requirements of different query condition combinations;

when the selection result does not comprise the value range corresponding to the selected query condition, directly using a preset database; when the selection result comprises a value range corresponding to the selected query condition, determining target information matched with the value range from a preset database according to the value range corresponding to the selected query condition, and taking the target information as the database used by the query page; if the starting place and the destination are Chinese domestic addresses as an example in the selection result of the travel ticket inquiry page, the used data only comprises data information of domestic travel tools and does not comprise data information of foreign travel tools;

according to the value range corresponding to the selected query condition, the database used by the query operation is simplified, so that the query range of the query operation can be effectively reduced, and the response speed of the query operation is improved on the premise of ensuring that the required data can be queried;

in an exemplary embodiment, while generating a corresponding query page, a value taking verification policy of the corresponding query condition may be set according to a value taking range corresponding to the selected query condition, where the value taking verification policy is used to determine whether a value filled by a user meets the value taking verification policy by using the value taking verification policy after detecting that the query condition in the query page has corresponding value taking information; the query operation can be verified by using the value verification strategy, so that the success rate of the query operation is improved;

step 105, deploying the query system in a network used by the tenant.

In an exemplary embodiment, data used by the query system can be directly deployed in an intranet used by a corresponding platform system and a tenant, and the security and privacy of independent use of the platform system and the tenant are guaranteed.

According to the method, the configuration file of the query page in the query system is obtained, the configuration file is sent, the selection result of the tenant of the query system on the required use information in the configuration file is obtained, the query system matched with the selection is generated according to the selection result, the query system is deployed in the network used by the tenant, the user-defined setting of the query page is achieved, the use requirements of different tenants are met, the modification on the query system is reduced, and the working efficiency is improved.

The method provided by the embodiments of the present application is explained as follows:

in one exemplary embodiment of the present invention,

In an exemplary embodiment, the query system can be used by different tenants, the requirements of the tenants can change in the using process, and after the selection results of the tenants are obtained, the corresponding relationship between the tenants and the selection results is recorded, so that the later maintenance of the requirement change is facilitated; and after receiving the updating request, obtaining the last selection result of the tenant on the query page by using the identity information of the tenant initiating the updating request, and adjusting the query system by using the updating request and the last selection result. For example, the query system provides the use of the tenant A and the tenant B, and locally records the corresponding relation between the identity information of the tenant A and the identity information of the tenant B and the respective selection results. After the tenant A initiates an update request, the selection result of the tenant A is searched from the selection results of the local records, and the query system of the tenant A is adjusted based on the selection result and the update request.

In an exemplary embodiment, if the changed configuration item is an add/delete operation on the query condition, the display attribute of the query condition needs to be adjusted; and/or if the configuration item is changed to adjust the value range of the query condition, the data of the database needs to be adjusted;

and generating corresponding binding data based on the information to be adjusted, and informing the query system to download the binding data for upgrading operation so as to complete the adjustment of the query system.

The method provided by the embodiment of the application is explained by using an application example as follows:

in order to solve the problem, different tenants are enabled to have independent configuration files through the configuration files, and query conditions are rendered according to the configuration files, so that different users in the same query interface have different query conditions. In addition, because the query condition is not fixed, the submitted data format is different, and an authentication mechanism is needed to ensure the format specification of the submitted data.

The data structure of the query condition is used for explanation:

each attribute represents a condition, key is a condition id, value is a condition value, and value may be in array form, indicating that multiple items are selected. The data structure is used for showing the client side and submitting the client side to the server side for query use.

The json object is used for representing the query condition selected or input by the current interface user, and the query condition specifically comprises the following steps:

{

city:‘sh’,

str_2:[‘a’,‘b’],

age:20

}

the database used by the query system is managed in a data dictionary form; a data dictionary is a collection of all values that a certain attribute or field in the system can assign. The general attribute stores different values than the text displayed on the interface. The dictionary needs to contain the correspondence of attribute values and display text. The dictionary acquisition mode in the system has two types, namely, a local dictionary is stored in the local of the system and is loaded into a memory before being used. And secondly, the dictionary service api acquires dictionary data through a network. The data dictionary is used in conditional queries to provide options for certain conditional attributes.

The configuration file of the query interface in the query system is a group number in a json format, and each item in the group number represents a query condition rendered by the front-end interface. For example:

the attribute information in the configuration file is shown in the following table:

TABLE 1

Fig. 2 is a schematic diagram of a management method of a query system according to an embodiment of the present application. In the flow shown in fig. 2, the front-end query renderer is used for displaying and interacting with the query in the front-end interface. The following figures take the query interfaces of two controls as examples:

reading a configuration file, wherein the configuration file is an array, and each item represents a control. Rendering each conditional query control in sequence;

each configuration item has one or at least two attributes, and the attributes can be classified into the following attributes according to categories, including:

style class attributes such as label, width, and the appearance of the rendering control.

Checking class attributes such as minLength, maxLength and the like determines the constraint of the control input data.

Behavior class attributes such as multi, searchable, etc. determine the functional behavior of the control.

A data class attribute, such as dit, indicates that the control uses a dictionary as a data item.

When the user selects or inputs an operation on the query interface, the data of the operation is saved in the query condition object. For example, if the user enters 19 in the age input box, the object of the page query condition will have the term age: 19.

When the query condition object changes, namely the input changes. The renderer will in turn check if the current input value has an effect on other controls of the interface. The following two cases can be classified:

1) if the query condition object contains the value of age 19. The city control disable attribute is configured with { age:19}, which indicates that when the age control enters 19, the value is set. The city control is disabled.

2) If the city control selects Shanghai, the query condition object has the item of city: 'shanghai'. And the dictFilterId attribute of the distribution control is set to [ 'city', 'area' ], the data dictionary representing the distribution will read the city value or the area value input by the current query condition object as the filter condition, and the data structure of the distribution data dictionary can be set as shown in table 2:

id	label	city	area
				1	area of the iris	shanghai	East China
2	Towards the sun district	beijing	North China

TABLE 2

When the city control inputs 'shanghai', the data item of the discrete control only displays the data item of Shanghai, and filters out the data item of non-Shanghai.

After the user performs an input operation of a value of a query condition on a query page, the renderer checks whether a current input value satisfies a data constraint condition. For example, the pattern of the mobile control configures a regular expression to check whether the mobile control is a legal mobile phone number. And if the input information does not accord with the data constraint condition, indicating that the input value is wrong, and outputting prompt information. In addition, a data validation function may be preset for checking whether all input values satisfy a validation condition before submitting data.

In summary, the embodiments of the present application provide a lightweight solution, which automatically generates a query interface through configuration, does not need encoding, and is quickly generated; the adopted configuration file is in a json format, is not limited by a platform and is easy to integrate with a development platform; interaction among the control pieces is inquired, a data dictionary is supported, the dictionary can be filtered according to selected conditions, and real-time interaction of a plurality of condition item dictionaries is realized; in addition, a constraint condition for data is set, and the verification of a data format is realized; the method realizes the definition specification of the configuration of the query interface and the automatic generation of the front-end interface, provides a verification scheme for solving the interaction effect among common components of the query interface and submitting data, is suitable for various occasions, does not limit a development platform, and has better universality.

An embodiment of the present application provides a computer storage medium, including a processor and a memory, where the memory stores a computer program, and the processor calls the computer program in the memory to implement the following operations, including:

acquiring a configuration file of a query page in a query system, wherein the configuration file comprises at least two pieces of query condition information and a value range of a corresponding query condition of each query condition;

sending the configuration file;

deploying the query system in a network used by the tenant.

In an exemplary embodiment, after the processor calls the computer program in the memory to implement the operation of obtaining the selection result of the tenant of the query system on the required usage information in the configuration file, the processor calls the computer program in the memory to further implement the following operations:

recording the corresponding relation between the identity information of the tenant and the selection result;

after the processor invokes the computer program in memory to implement the operation of deploying the query system in the network used by the tenant, the processor invokes the computer program in memory to further implement the operations of:

after receiving an update request of a tenant for a configuration file of a query system, acquiring identity information of the tenant;

determining a selection result corresponding to the identity information according to the identity information;

The computer storage medium provided by the embodiment of the application acquires the configuration file of the query page in the query system, sends the configuration file, acquires the selection result of the tenant of the query system on the required use information in the configuration file, generates the query system matched with the selection according to the selection result, deploys the query system in the network used by the tenant, realizes the custom setting of the query page, meets the use requirements of different tenants, reduces the modification on the query system, and improves the working efficiency.

It will be understood by those of ordinary skill in the art that all or some of the steps of the methods, systems, functional modules/units in the devices disclosed above may be implemented as software, firmware, hardware, and suitable combinations thereof. In a hardware implementation, the division between functional modules/units mentioned in the above description does not necessarily correspond to the division of physical components; for example, one physical component may have multiple functions, or one function or step may be performed by several physical components in cooperation. Some or all of the components may be implemented as software executed by a processor, such as a digital signal processor or microprocessor, or as hardware, or as an integrated circuit, such as an application specific integrated circuit. Such software may be distributed on computer readable media, which may include computer storage media (or non-transitory media) and communication media (or transitory media). The term computer storage media includes volatile and nonvolatile, removable and non-removable media implemented in any method or technology for storage of information such as computer readable instructions, data structures, program modules or other data, as is well known to those of ordinary skill in the art. Computer storage media includes, but is not limited to, RAM, ROM, EEPROM, flash memory or other memory technology, CD-ROM, Digital Versatile Disks (DVD) or other optical disk storage, magnetic cassettes, magnetic tape, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired information and which can accessed by a computer. In addition, communication media typically embodies computer readable instructions, data structures, program modules or other data in a modulated data signal such as a carrier wave or other transport mechanism and includes any information delivery media as known to those skilled in the art.

Claims

1. A method for managing a query system, comprising:

sending the configuration file;

deploying the query system in a network used by the tenant.

2. The method of claim 1, wherein generating a query system matching the selection based on the selection result comprises:

3. The method of claim 1, wherein generating a query system matching the selection based on the selection result comprises:

4. The method according to any one of claims 1 to 3, wherein after deploying the query system in a network used by the tenant, the method further comprises:

5. The method according to claim 4, wherein the adjusting the query system of the tenant according to the selection result and the update request comprises:

6. A computer storage medium comprising a processor and a memory, wherein the memory stores a computer program, and wherein the processor invokes the computer program in the memory to perform operations comprising:

sending the configuration file;

deploying the query system in a network used by the tenant.

7. The computer storage medium of claim 6, wherein the processor invokes a computer program in the memory to perform operations for generating a query system matching the selection based on the selection result, comprising:

8. The computer storage medium of claim 6, wherein the processor invokes a computer program in the memory to perform operations for generating a query system matching the selection based on the selection result, comprising:

9. The computer storage medium of any of claims 6 to 8, wherein:

10. The computer storage medium of claim 9, wherein the processor invokes a computer program in the memory to implement the operations of adjusting the query system of the tenant based on the selection result and an update request, comprising: