CN109446253B - Data query control method, device, computer equipment and storage medium - Google Patents
Data query control method, device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN109446253B CN109446253B CN201811119999.6A CN201811119999A CN109446253B CN 109446253 B CN109446253 B CN 109446253B CN 201811119999 A CN201811119999 A CN 201811119999A CN 109446253 B CN109446253 B CN 109446253B
- Authority
- CN
- China
- Prior art keywords
- data
- query
- rule
- user
- management system
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 55
- 238000012545 processing Methods 0.000 claims abstract description 6
- 230000010354 integration Effects 0.000 claims description 11
- 238000012544 monitoring process Methods 0.000 claims description 8
- 238000013507 mapping Methods 0.000 claims description 6
- 230000008859 change Effects 0.000 description 6
- 230000006854 communication Effects 0.000 description 6
- 238000004891 communication Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 3
- 230000006978 adaptation Effects 0.000 description 2
- 230000007175 bidirectional communication Effects 0.000 description 2
- 230000001413 cellular effect Effects 0.000 description 2
- 238000013480 data collection Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000003993 interaction Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000006399 behavior Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000012512 characterization method Methods 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 238000012790 confirmation Methods 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 238000004080 punching Methods 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a data query control method, a device, computer equipment and a storage medium, belonging to the technical field of big data processing and analysis, comprising the following steps: acquiring a user query instruction, wherein the user query instruction is an input query condition; recall search data meeting the query conditions in a preset target database according to a query instruction of a user, wherein the target database is a collection library integrating databases in a plurality of management systems; and typesetting the recalled search data and then sending the recalled search data to the client for display. According to the application, the data in the plurality of management systems are stored in the target database and are automatically integrated, the user directly obtains the data which accords with the query condition in the target database, and the integrated data does not need to be manually counted and integrated, so that the labor force is greatly saved, and the labor cost is saved.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a data query control method, a data query control device, a computer device, and a storage medium.
Background
Along with the development of information technology, more and more information is gradually converted into electronic information, and the electronic information is used by various information systems, so that the working efficiency is improved, and the life of people is facilitated. However, due to the limitation of the network and computer level, different information is managed by different systems, and each system cannot be compatible, along with development of technology and the desire of people for convenient life, convenient office and convenient information management, a comprehensive management platform is needed, which can dock data of each different system and perform data query and management through the platform.
Disclosure of Invention
The invention aims to at least solve one of the technical defects, in particular to a data query control method and a data query control device which can timely acquire updated data from a plurality of management systems to be integrated.
The invention discloses a data query control method, which comprises the following steps:
Acquiring a user query instruction, wherein the user query instruction is an input query condition;
Recall search data conforming to the query conditions in a preset target database according to a query instruction of a user, wherein the target database is a collection library integrating databases in a plurality of management systems;
And typesetting the recalled search data and then sending the recalled search data to the client for display.
Preferably, the method for constructing the target database includes:
data interfaces respectively connected with the plurality of management systems;
sequentially acquiring update data in databases of all management systems according to a preset first rule;
and classifying, integrating and storing the acquired updated data in the target database according to a preset second rule.
Preferably, the first rule is: polling is carried out according to a preset sequence of the management system; the preset sequence is one or a combination of a plurality of sequences of the serial numbers of the management systems, the set data reading time intervals of the management systems or the priority sequences of the management systems.
Preferably, the first rule is: and timely acquiring data in a management system with data updating by monitoring the data updating state of each data interface.
Preferably, the second rule is to combine and classify the update data according to the target information; the target information is the type of the monitored data in the management system, and the method for classifying and integrating the acquired data according to the second rule comprises the following steps:
Reading target information of the updated data in each database;
And merging and classifying the updated data by taking the target information as a classification limiting condition.
Preferably, the user query instruction includes an output type, and the method for typesetting and sending the recalled search data to the client for display includes:
identifying the output type of a user query instruction;
Calling a display template with a mapping relation with the output type;
And carrying the search data into the display template to generate statistical information, and sending the statistical information to a client for display.
Preferably, when there are multiple pieces of search data recalled according to the query instruction, the distinguishing features between each piece of search data are obtained by matching, and the distinguishing feature with the highest priority level is presented together with the search data according to the priority level of the preset distinguishing features, so as to be distinguished and selected by a user.
The application also discloses a data query control device, which comprises:
A first acquisition unit: the method comprises the steps of executing and acquiring a user query instruction, wherein the user query instruction is an input query condition;
And a processing unit: the method comprises the steps of executing retrieval data meeting query conditions in a preset target database according to a query instruction of a user, wherein the target database is a database integrated with a plurality of management systems;
a first execution unit: and the method is used for typesetting the recalled search data and then sending the recalled search data to the client for display.
Preferably, the method further comprises:
A connection unit: a data interface for respectively connecting the plurality of management systems;
a second acquisition unit: the method comprises the steps of sequentially obtaining update data in databases of all management systems according to a preset first rule;
an integration unit: and the method is used for executing classification and integration of the acquired update data according to a preset second rule and storing the update data in the target database.
Preferably, the first rule is: polling is carried out according to a preset sequence of the management system; the preset sequence is one or a combination of a plurality of sequences of the serial numbers of the management systems, the set data reading time intervals of the management systems or the priority sequences of the management systems.
Preferably, the first rule is: and timely acquiring data in a management system with data updating by monitoring the data updating state of each data interface.
Preferably, the second rule is to combine and classify the update data according to the target information; the target information is the type of the monitored data in the management system, and the method further comprises the following steps:
A reading unit: target information for reading the updated data in each database;
Classification unit: and the updating data is used for merging and classifying the updating data by taking the target information as a classification limiting condition.
Preferably, the user query instruction includes an output type, and further includes:
An identification unit: the output type is used for identifying the user query instruction;
calling unit: the display template is used for calling the display template with the mapping relation with the output type;
A second execution unit: and the search data is used for being brought into the display template to generate statistical information, and the statistical information is sent to a client for display.
Preferably, when there are multiple pieces of search data recalled according to the query instruction, the distinguishing features between each piece of search data are obtained by matching, and the distinguishing feature with the highest priority level is presented together with the search data according to the priority level of the preset distinguishing features, so as to be distinguished and selected by a user.
The application also discloses a computer device, which comprises a memory and a processor, wherein the memory stores computer readable instructions, and the computer readable instructions, when executed by the processor, cause the processor to execute the steps of the data query control method.
The present application discloses a storage medium storing computer readable instructions that, when executed by one or more processors, cause the one or more processors to perform the steps of the data query control method described above.
The beneficial effects of the application are as follows: according to the application, the data in the plurality of management systems are acquired simultaneously, the data in the plurality of management systems are stored in the target database, and are automatically integrated, and the user query instruction directly acquires the data meeting the query condition in the target database, so that the data in the plurality of management systems can be acquired quickly. The data in a plurality of systems are automatically acquired and are integrated, manual statistics integration is not needed, labor force is greatly saved, and labor cost is saved.
Additional aspects and advantages of the invention will be set forth in part in the description which follows, and in part will be obvious from the description, or may be learned by practice of the invention.
Drawings
The foregoing and/or additional aspects and advantages of the invention will become apparent and readily appreciated from the following description of the embodiments, taken in conjunction with the accompanying drawings, in which:
FIG. 1 is a flow chart of a data query control method of the present invention;
FIG. 2 is a flow chart of a method for constructing a target database according to the present invention;
FIG. 3 is a flow chart of a method for data classification and integration according to the present invention;
FIG. 4 is a flow chart of a method of retrieving data layout display in accordance with the present invention;
FIG. 5 is a block diagram of a data query controller according to the present invention;
Fig. 6 is a basic structural block diagram of the computer device of the present invention.
Detailed Description
Embodiments of the present invention are described in detail below, examples of which are illustrated in the accompanying drawings, wherein like or similar reference numerals refer to like or similar elements or elements having like or similar functions throughout. The embodiments described below by referring to the drawings are illustrative only and are not to be construed as limiting the invention.
As used herein, the singular forms "a", "an", "the" and "the" are intended to include the plural forms as well, unless expressly stated otherwise, as understood by those skilled in the art. It will be further understood that the terms "comprises" and/or "comprising," when used in this specification, specify the presence of stated features, integers, steps, operations, elements, and/or components, but do not preclude the presence or addition of one or more other features, integers, steps, operations, elements, components, and/or groups thereof. It will be understood that when an element is referred to as being "connected" or "coupled" to another element, it can be directly connected or coupled to the other element or intervening elements may also be present. Further, "connected" or "coupled" as used herein may include wirelessly connected or wirelessly coupled. The term "and/or" as used herein includes all or any element and all combination of one or more of the associated listed items.
It will be understood by those skilled in the art that all terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs unless defined otherwise. It will be further understood that terms, such as those defined in commonly used dictionaries, should be interpreted as having a meaning that is consistent with their meaning in the context of the prior art and will not be interpreted in an idealized or overly formal sense unless expressly so defined herein.
As used herein, a "terminal" includes both a device of a wireless signal receiver having no transmitting capability and a device of receiving and transmitting hardware having receiving and transmitting hardware capable of performing bi-directional communications over a bi-directional communication link, as will be appreciated by those skilled in the art. Such a device may include: a cellular or other communication device having a single-line display or a multi-line display or a cellular or other communication device without a multi-line display; PCS (Personal Communications Service, personal communications System) that may combine voice, data processing, facsimile and/or data communications capabilities; PDA (Personal DIGITAL ASSISTANT ) that may include a radio frequency receiver, pager, internet/intranet access, web browser, notepad, calendar and/or GPS (Global Positioning System ) receiver; a conventional laptop and/or palmtop computer or other appliance that has and/or includes a radio frequency receiver. As used herein, "terminal," "terminal device" may be portable, transportable, installed in a vehicle (aeronautical, maritime, and/or land-based), or adapted and/or configured to operate locally and/or in a distributed fashion, to operate at any other location(s) on earth and/or in space. The "terminal" and "terminal device" used herein may also be a communication terminal, a network access terminal, and a music/video playing terminal, for example, may be a PDA, a MID (Mobile INTERNET DEVICE ) and/or a Mobile phone with a music/video playing function, and may also be a smart tv, a set top box, and other devices.
The application discloses a data query control method, which is mainly used for counting and querying data in a plurality of different management systems on a client in real time, referring to fig. 1, and comprises the following steps:
s100, acquiring a user query instruction, wherein the user query instruction is an input query condition;
The user query instruction is a query condition input by a user on the client, the client reads the input content and sends the input content to the server, and the server identifies the query condition to execute the query operation. The query is generally performed by inputting a query condition, and various input methods can be performed by selecting a fixed subject, or by inputting the query content in a designated input box.
In one embodiment, if the query is performed through a fixed subject selection, the mapped content of the subject can be obtained only by reading the content of the subject. If the query content is input in the appointed input box, the query condition is obtained by identifying the keyword.
S200, recall search data meeting the query conditions in a preset target database according to a query instruction of a user, wherein the target database is a database integrated with a plurality of management systems;
In one embodiment, the target database is a collection of databases of a plurality of management systems. The type of the management system can be various, such as an attendance management system, a performance management system, a sales management system and the like, and in the application, the data interfaces of a plurality of different attendance management systems are simultaneously connected so as to acquire data in real time.
S300, typesetting the recalled search data and then sending the recalled search data to the client for display.
And typesetting the recalled search data according to the query condition of the user query instruction, and sending the recalled search data to the client for display. The query conditions include subjects to be queried and specific contents, and further, the types of data display can be further included, such as the data display is displayed in a list mode, and the DOC format, the PDF format or the EXCEL table format are exported.
According to the application, the data in the plurality of management systems are acquired simultaneously, the data in the plurality of management systems are stored in the target database, and are automatically integrated, and the user query instruction directly acquires the data meeting the query condition in the target database, so that the data in the plurality of management systems can be acquired quickly. The data in a plurality of systems are automatically acquired and are integrated, manual statistics integration is not needed, labor force is greatly saved, and labor cost is saved.
In the present application, there are various ways of acquiring data, in one embodiment, data of a plurality of management systems acquired in real time are stored in a target database, and a method for constructing the target database is shown in fig. 2, and mainly includes:
S210, respectively connecting data interfaces of the plurality of management systems;
The data interfaces are connected with all the data interfaces of the management system which need to collect data, the data interfaces are channels for the management system to exchange data with the outside, and real-time data of the management system can be collected by setting data collection rules through the connection of the data interfaces.
When multiple data interfaces are connected, in order to distinguish the data interfaces, a name may be defined for each data interface of the management system, such as distinguishing by one or more letters or character strings, or distinguishing by numerical numbers, so as to facilitate information collection.
S220, sequentially acquiring update data in databases of all management systems according to a preset first rule;
Because the data in the management system can change continuously, if the data is not updated in time, the data in the target database may be inaccurate, so that the final query result is inaccurate, and in a feasible embodiment, the updated data in the databases of all the management systems can be acquired sequentially through the first rule.
In an embodiment, the first rule may be that polling is performed according to a preset sequence of the management system, and since each data interface is already numbered or distinguished by a character when the data interfaces of each management system are connected, polling is performed according to a corresponding data interface in a preset sequence to acquire related data. The preset sequence can be presented in a list form, data is obtained according to the serial number or the sequence of characters representing the data interfaces in the list, and the current obtained latest data covers the data obtained in the previous time period to ensure that the current data is the updated latest data.
In another embodiment, the preset sequence may be a predetermined data reading time interval for managing the chest, in addition to the numbering sequence of the management system. In the above-described attendance management system, performance management system and sales management system, for example, the attendance management system is generally used for checking attendance conditions of staff or related personnel, and the complete attendance is usually in units of days, so that a certain time point of day, such as the early morning or the early 5 days, of the data acquisition time of the attendance management system can be set, and the internal performance management system and the sales management system may change in real time, so that the time of data update can be shortened, and one data acquisition update can be performed every 3 minutes or 15 minutes to obtain the latest dynamics. When the data acquisition time of each management system is set, the data interaction is carried out on the relevant interfaces on time according to the set time, and the latest data are acquired.
In another embodiment, when a plurality of management systems are provided and there may be a certain dependency relationship among the plurality of management systems, and when the number of the plurality of management systems is large, if the data interfaces of each management system are polled, the data interfaces may be set with a priority level at this time, and polling and data acquisition are performed on the data interfaces according to the priority level, for example, the data interface of the first management system is a level, the data interface of the second management system is B, the data interface of the third management system is a level, the data interface of the fourth management system is C, and then the polling sequence of the data interfaces is the first management system, the third management system and the second management system, and finally the fourth management system.
In another embodiment, the first rule may also be to timely acquire the data in the management system where the data update exists by monitoring the data update status of each data interface. In one possible embodiment, the version number of the data interface can be monitored by a data interface polling mode, the version number of the data interface is associated with internal data, the subject content of a management system to be monitored is appointed, when the appointed subject content changes, the version number is changed according to an appointed rule, for example, every time the appointed subject content changes, the version number is increased by 1, whether the version number of the data interface changes with a prestored version number stored in the last polling mode or not is detected in polling, if the version number of the data interface does not change, no data update is currently indicated, and if the version number does not change, the existence of the data update is indicated, so that the management system can be communicated with the data interface immediately, and the latest data is acquired. The latest state of data update is obtained in this way, and the data in the current management system can be covered with the data in the polling state of the previous state, or the current changed data can be directly replaced or updated, and the rest unchanged data are not replaced, so that the data update amount is reduced, and the update speed is improved. And when the data updating is completed, the current version number is saved so as to be convenient for comparison in the next polling.
S230, classifying and integrating the acquired updated data according to a preset second rule, and storing the classified and integrated updated data in the target database.
And acquiring the update data of the database in the management system according to the first rule, classifying and integrating the acquired update data according to a preset second rule in the next step, and storing the update data in the target database so as to generate a search result after receiving a user query instruction and outputting the search result.
The second rule is to combine and classify the updated data according to the target information; the target information is the type of the monitored data in the management system, referring to fig. 3, and the method for classifying and integrating the acquired data according to the second rule includes:
s231, reading target information of the updated data in each database;
Each management system corresponds to a database, the content in the database is read through a data interface to perform data interaction, after the updated data in the database is obtained, the target information in the updated data can be obtained, the target information is the type of the monitored data in the management system, for example, in the attendance management system, the target information is the number, the name and the card punching type of the characterization attendance staff. In the sales management system, the target information is content such as names, numbers, purchaser information, sales staff numbers, names, and the like, which characterize products that can be sold.
S232, merging and classifying the updated data by taking the target information as a classification limiting condition.
Because the target information is of the data type, the acquired data can be combined and classified according to the target information as a classification limiting condition, for example, if the numbers and names of attendance staff in the attendance management system and the sales system are the same as the numbers and names of sales staff, the related data in the two systems can be combined. In order to more clearly describe the relationship between the two, the present application is further described in the form of a table: table 1 is a record in the attendance management system:
TABLE 1
Table 2 is data in the sales management system:
TABLE 2
The above-mentioned data acquired in 2 different management systems, the target information in the two data tables includes "name", "gender", "attendance days", "variety", "amount", "agent salesman", and the like, the system merges the same content according to the type of the above-mentioned target information, but it should be noted that the same target information in different management systems may be distinguished by a manual setting manner, for example, "name" in the above-mentioned table 1 represents an employee name, while "name" in the table 2 represents a name of a purchasing customer, and "name" in the table 2 is the same as "name" in the table 1, so that the "name" in the table 1 and the "agent salesman" in the table 2 may be manually set together to define the same category of target information, and by matching the same target information in the table 1 and the table 2, the two tables may be integrated to acquire all data located in different management systems under the same target information. For example, if the user inquires that the instruction is "check-in and sales conditions of Zhang three", the related data can be output according to the inquiry condition, and if the designated output type is a table, the typesetting mode can be displayed as shown in the table 3:
TABLE 3 Table 3
By the above mode, the integrated data in a plurality of management systems can be automatically obtained.
In another embodiment, referring to fig. 4, the method for typesetting and sending the recalled search data to the client for display includes:
S310, identifying the output type of a user query instruction;
The query condition may further include the range of the query, such as the time period of the query, the department of the query, the age stage, and the like, in addition to the subjects and the specific contents of the query disclosed above. Further, the method further comprises an output type, which is different from the output format, and the output type can be in a presentation form, such as a form of a table, a form of a pie chart, or a form of a bar chart or a graph, and specific data is obtained by combining the disclosed data acquisition method and the disclosed integration method through identifying query conditions.
S320, calling a display template with a mapping relation with the output type;
The target database can further store a display template with a mapping relation with the output type, if the display template is in a form of a form output form, the display template is in a form of a pie chart, and if the display template is in a form of a pie chart, the display template is formed by dividing data into a plurality of block structures and finally combining the block structures into a pie shape; if the data is in a curve form, the search data is distributed in a coordinate form according to the type of the target information to form a discrete data structure, and each discrete point is directly combined to show the change trend along the coordinate distribution direction.
S330, carrying the data statistics result into the display template to generate statistics information, and sending the statistics information to a client for display.
Further, the display template comprises a matching rule in which the acquired search data is matched into the display template, the system automatically acquires the recalled search data obtained in the step S200 according to the matching rule, processes the search data according to the matching rule, and brings the search data into the display template in the step S320 to form statistical information to be sent to the client for display, so that a user can know the data condition more simply and clearly, and follow-up management is facilitated.
In another embodiment, when the retrieved data recalled according to the query instruction is too many or the query range existing in the query instruction is too large, matching the distinguishing feature of each piece of the retrieved data, and presenting the distinguishing feature and the retrieved data together according to the priority level of the distinguishing feature for the user to distinguish or for the user to select and confirm to narrow the query range; the priority level of the distinguishing features is preset target information capable of being automatically presented. When the user performs fuzzy query, such as when the keyword information range is too large or more information can be repeated, the search data can be displayed at the same time for the user to select. For example, after the user queries the keyword "Liqu, performance" and because there is no restriction of ID number, there may be a case of the same name, so that multiple structures may appear, and in order to facilitate the user to distinguish, different contents in each search data may be automatically searched, and distinguishing features may be presented together according to the priority level to facilitate the user to distinguish, so as to further select and narrow the scope.
The priority level of the distinguishing features is preset target information which can be automatically presented, and the priority level can be divided according to the importance degree because the target information is of the data type. For example, the ID number is the target information that can most distinguish the identity information of different people, so the priority level of the ID number can be preset to be the highest level, when the search result has the data of a plurality of people with the same name, the ID number can be automatically embedded to distinguish, and thus, no manual work is needed to input the query instruction after the best information can not be queried. The data query and display modes are more intelligent, and the query efficiency is higher.
Specifically, explanation will be given by taking the table of fig. 4 as an example:
TABLE 4 Table 4
When the 'Li four' is adopted as the query condition for searching, the corresponding ID number is automatically displayed at the designated position, so that the user can conveniently and quickly acquire the distinguishing information and find the searching result which the user wants. Further, the user can select confirmation to narrow the query range.
The application also discloses a data query control device, referring to fig. 4, the structure of the control device comprises:
The first acquisition unit 100: the method comprises the steps of executing and acquiring a user query instruction, wherein the user query instruction is an input query condition; the user query instruction is a query condition input by a user on the client, the client reads the input content and sends the input content to the server, and the server identifies the query condition to execute the query operation. The query is generally performed by inputting a query condition, and various input methods can be performed by selecting a fixed subject, or by inputting the query content in a designated input box.
In one embodiment, if the query is performed through a fixed subject selection, the mapped content of the subject can be obtained only by reading the content of the subject. If the query content is input in the appointed input box, the query condition is obtained by identifying the keyword.
Processing unit 200: the method comprises the steps of executing retrieval data meeting query conditions in a preset target database according to a query instruction of a user, wherein the target database is a database integrated with a plurality of management systems;
In one embodiment, the target database is a collection of databases of a plurality of management systems. The type of the management system can be various, such as an attendance management system, a performance management system, a sales management system and the like, and in the application, the data interfaces of a plurality of different attendance management systems are simultaneously connected so as to acquire data in real time.
The first execution unit 300: and the method is used for typesetting the recalled search data and then sending the recalled search data to the client for display.
And typesetting the recalled search data according to the query condition of the user query instruction, and sending the recalled search data to the client for display. The query conditions include subjects to be queried and specific contents, and further, the types of data display can be further included, such as the data display is displayed in a list mode, and the DOC format, the PDF format or the EXCEL table format are exported.
According to the application, the data in the plurality of management systems are acquired simultaneously, the data in the plurality of management systems are stored in the target database, and are automatically integrated, and the user query instruction directly acquires the data meeting the query condition in the target database, so that the data in the plurality of management systems can be acquired quickly. The data in a plurality of systems are automatically acquired and are integrated, manual statistics integration is not needed, labor force is greatly saved, and labor cost is saved.
In one embodiment, the present application further comprises:
A connection unit: a data interface for respectively connecting the plurality of management systems;
The data interfaces are connected with all the data interfaces of the management system which need to collect data, the data interfaces are channels for the management system to exchange data with the outside, and real-time data of the management system can be collected by setting data collection rules through the connection of the data interfaces.
When multiple data interfaces are connected, in order to distinguish the data interfaces, a name may be defined for each data interface of the management system, such as distinguishing by one or more letters or character strings, or distinguishing by numerical numbers, so as to facilitate information collection.
A second acquisition unit: the method comprises the steps of sequentially obtaining update data in databases of all management systems according to a preset first rule;
Because the data in the management system can change continuously, if the data is not updated in time, the data in the target database may be inaccurate, so that the final query result is inaccurate, and in a feasible embodiment, the updated data in the databases of all the management systems can be acquired sequentially through the first rule.
The first rule is: polling is carried out according to a preset sequence of the management system; the preset sequence is one or a combination of a plurality of sequences of the serial numbers of the management systems, the set data reading time intervals of the management systems or the priority sequences of the management systems.
In another embodiment, the first rule may further be: and timely acquiring data in a management system with data updating by monitoring the data updating state of each data interface.
An integration unit: and the method is used for executing classification and integration of the acquired update data according to a preset second rule and storing the update data in the target database.
And acquiring the update data of the database in the management system according to the first rule, classifying and integrating the acquired update data according to a preset second rule in the next step, and storing the update data in the target database so as to generate a search result after receiving a user query instruction and outputting the search result.
The second rule is to combine and classify the updated data according to the target information; the target information is the type of the monitored data in the management system, and the method further comprises the following steps:
A reading unit: target information for reading the updated data in each database;
Classification unit: and the updating data is used for merging and classifying the updating data by taking the target information as a classification limiting condition.
In another embodiment, the method further comprises:
An identification unit: the output type is used for identifying the user query instruction;
calling unit: the display template is used for calling the display template with the mapping relation with the output type;
A second execution unit: and the search data is used for being brought into the display template to generate statistical information, and the statistical information is sent to a client for display.
In another embodiment, when there are multiple pieces of search data recalled according to the query instruction, the distinguishing features between each piece of search data are obtained by matching, and according to the priority level of the preset distinguishing features, the distinguishing feature with the highest priority level is presented together with the search data for user to distinguish and select.
The embodiment of the invention provides a basic structure block diagram of computer equipment and please refer to fig. 6.
The computer device includes a processor, a non-volatile storage medium, a memory, and a network interface connected by a system bus. The nonvolatile storage medium of the computer device stores an operating system, a database and computer readable instructions, the database can store a control information sequence, and the computer readable instructions can enable the processor to realize a data query control method when the computer readable instructions are executed by the processor. The processor of the computer device is used to provide computing and control capabilities, supporting the operation of the entire computer device. The memory of the computer device may have stored therein computer readable instructions that, when executed by the processor, cause the processor to perform a data query control method. The network interface of the computer device is for communicating with a terminal connection. It will be appreciated by those skilled in the art that the structure shown in FIG. 6 is merely a block diagram of some of the structures associated with the present inventive arrangements and is not limiting of the computer device to which the present inventive arrangements may be applied, and that a particular computer device may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.
The computer equipment receives the state information of the prompt behavior sent by the associated client, namely whether the associated terminal starts the prompt and whether the user closes the prompt task. By verifying whether the task conditions are met or not, a corresponding preset instruction is further sent to the associated terminal, so that the associated terminal can execute corresponding operation according to the preset instruction, and effective supervision of the associated terminal is achieved. Meanwhile, when the prompt information state is different from a preset state instruction, the server side controls the associated terminal to continuously ring so as to prevent the problem that the prompt task of the associated terminal is automatically terminated after being executed for a period of time.
The invention also provides a storage medium storing computer readable instructions that, when executed by one or more processors, cause the one or more processors to perform the data query control method of any of the embodiments described above.
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 in 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 nonvolatile storage medium such as a magnetic disk, an optical disk, a Read-Only Memory (ROM), or a random access Memory (Random Access Memory, RAM).
It should be understood that, although the steps in the flowcharts of the figures are shown in order as indicated by the arrows, these steps are not necessarily performed in order as indicated by the arrows. The steps are not strictly limited in order and may be performed in other orders, unless explicitly stated herein. Moreover, at least some of the steps in the flowcharts of the figures may include a plurality of sub-steps or stages that are not necessarily performed at the same time, but may be performed at different times, the order of their execution not necessarily being sequential, but may be performed in turn or alternately with other steps or at least a portion of the other steps or stages.
The foregoing is only a partial embodiment of the present invention, and it should be noted that it will be apparent to those skilled in the art that modifications and adaptations can be made without departing from the principles of the present invention, and such modifications and adaptations are intended to be comprehended within the scope of the present invention.
Claims (6)
1. A data query control method, comprising:
Acquiring a user query instruction, wherein the user query instruction is an input query condition;
Recall search data conforming to the query conditions in a preset target database according to a query instruction of a user, wherein the target database is a collection library integrating databases in a plurality of management systems;
Typesetting the recalled search data and then sending the recalled search data to a client for display;
When a plurality of search data are recalled according to the query instruction, matching to obtain distinguishing features among each search data, and displaying the distinguishing features with the highest priority level with the search data according to the priority level of the preset distinguishing features for distinguishing and selecting by a user;
the distinguishing features are different contents among the pieces of retrieval data; the priority level of the distinguishing features is determined according to the importance degree of the data type;
the method for constructing the target database comprises the following steps:
data interfaces respectively connected with the plurality of management systems;
sequentially acquiring update data in databases of all management systems according to a preset first rule;
Classifying, integrating and storing the acquired update data in the target database according to a preset second rule;
the first rule is: the data in the management system with data updating is timely obtained by monitoring the data updating state of each data interface;
the step of sequentially obtaining the update data in the database of each management system according to the preset first rule comprises the following steps:
Monitoring the version number of the data interface in a data interface polling mode, associating the version number of the data interface with internal data, determining subject content of a management system to be monitored, changing the version number according to a specified rule when the specified subject content changes, detecting whether the version number of the data interface changes with a prestored version number stored in the last polling mode during polling, if not, indicating that no data update exists currently, and if so, indicating that data update exists so as to be convenient to immediately communicate with the data interface and acquire updated data.
2. The data query control method of claim 1, wherein the second rule is to merge and classify the update data according to target information; the target information is the type of the monitored data in the management system, and the method for classifying and integrating the acquired data according to the second rule comprises the following steps:
Reading target information of the updated data in each database;
And merging and classifying the updated data by taking the target information as a classification limiting condition.
3. The data query control method according to claim 2, wherein the user query instruction includes an output type, and the method for typesetting and sending the recalled search data to the client for display includes:
identifying the output type of a user query instruction;
calling a display template with a mapping relation with the output type;
And carrying the search data into the display template to generate statistical information, and sending the statistical information to a client for display.
4. A data query control apparatus, comprising:
A first acquisition unit: the method comprises the steps of executing and acquiring a user query instruction, wherein the user query instruction is an input query condition;
And a processing unit: the method comprises the steps of executing retrieval data meeting query conditions in a preset target database according to a query instruction of a user, wherein the target database is a database integrated with a plurality of management systems;
A first execution unit: the method comprises the steps of typesetting recall search data, and then sending the recall search data to a client for display;
The first execution unit is further configured to:
When a plurality of search data are recalled according to the query instruction, matching to obtain distinguishing features among each search data, and displaying the distinguishing features with the highest priority level with the search data according to the priority level of the preset distinguishing features for distinguishing and selecting by a user;
the distinguishing features are different contents among the pieces of retrieval data; the priority level of the distinguishing features is determined according to the importance degree of the data type;
The connection unit is used for respectively connecting the data interfaces of the plurality of management systems;
The second acquisition unit is used for sequentially acquiring the update data in the database of each management system according to a preset first rule;
The integration unit is used for performing classification integration on the acquired update data according to a preset second rule and storing the update data in the target database;
the first rule is: the data in the management system with data updating is timely obtained by monitoring the data updating state of each data interface;
the second obtaining unit is specifically configured to:
Monitoring the version number of the data interface in a data interface polling mode, associating the version number of the data interface with internal data, determining subject content of a management system to be monitored, changing the version number according to a specified rule when the specified subject content changes, detecting whether the version number of the data interface changes with a prestored version number stored in the last polling mode during polling, if not, indicating that no data update exists currently, and if so, indicating that data update exists so as to be convenient to immediately communicate with the data interface and acquire updated data.
5. A computer device comprising a memory and a processor, the memory having stored therein computer readable instructions which, when executed by the processor, cause the processor to perform the steps of the data query control method of any of claims 1 to 3.
6. A storage medium storing computer readable instructions which, when executed by one or more processors, cause the one or more processors to perform the steps of the data query control method of any of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811119999.6A CN109446253B (en) | 2018-09-25 | 2018-09-25 | Data query control method, device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811119999.6A CN109446253B (en) | 2018-09-25 | 2018-09-25 | Data query control method, device, computer equipment and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109446253A CN109446253A (en) | 2019-03-08 |
| CN109446253B true CN109446253B (en) | 2024-05-07 |
Family
ID=65544302
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811119999.6A Active CN109446253B (en) | 2018-09-25 | 2018-09-25 | Data query control method, device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109446253B (en) |
Families Citing this family (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110456993B (en) * | 2019-07-11 | 2023-01-17 | 创新先进技术有限公司 | Card number display method and system based on preset rules |
| CN110688395A (en) * | 2019-10-18 | 2020-01-14 | 政采云有限公司 | Information query method, device, information statistical method and related equipment |
| CN112835991B (en) * | 2019-11-25 | 2023-11-21 | 北京达佳互联信息技术有限公司 | System, method, device and storage medium for monitoring data |
| CN112231541A (en) * | 2020-09-22 | 2021-01-15 | 苏州艾特律宝智能科技有限公司 | Data retrieval method, system, computer device and storage medium |
| CN113517047A (en) * | 2021-06-08 | 2021-10-19 | 联仁健康医疗大数据科技股份有限公司 | Medical data acquisition method and device, electronic equipment and storage medium |
| CN114997828A (en) * | 2021-11-02 | 2022-09-02 | 杭州以诺行汽车科技股份有限公司 | Formula management system for ERP in automobile maintenance industry and control method thereof |
| CN114218259B (en) * | 2022-02-21 | 2022-05-24 | 深圳市云初信息科技有限公司 | Multi-dimensional scientific information search method and system based on big data SaaS |
| CN115905315A (en) * | 2022-11-08 | 2023-04-04 | 北京德塔精要信息技术有限公司 | Multi-type data fusion processing method and system |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101676917A (en) * | 2008-09-18 | 2010-03-24 | 英赛特半导体有限公司 | Method and system for populating a database with bibliographic data from multiple sources |
| KR20140021431A (en) * | 2012-08-10 | 2014-02-20 | 연세대학교 산학협력단 | Method and apparatus for searching information in electronic meical record system |
| CN105554114A (en) * | 2015-12-17 | 2016-05-04 | 深圳市从晶科技有限公司 | Data synchronization method and data synchronization firmware platform |
| CN107301250A (en) * | 2017-07-27 | 2017-10-27 | 南京南瑞集团公司 | A kind of Various database cooperates with backup method |
| CN107818127A (en) * | 2017-09-09 | 2018-03-20 | 国网浙江省电力公司 | A kind of querying method and system for multi-source data |
| CN108009236A (en) * | 2017-11-29 | 2018-05-08 | 北京锐安科技有限公司 | A kind of big data querying method, system, computer and storage medium |
| CN108170731A (en) * | 2017-12-13 | 2018-06-15 | 腾讯科技（深圳）有限公司 | Data processing method, device, computer storage media and server |
| CN108197297A (en) * | 2018-01-23 | 2018-06-22 | 正方软件股份有限公司 | Method for exhibiting data and system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US10467227B2 (en) * | 2015-10-20 | 2019-11-05 | International Business Machines Corporation | Domain centric natural language query answering |
-
2018
- 2018-09-25 CN CN201811119999.6A patent/CN109446253B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101676917A (en) * | 2008-09-18 | 2010-03-24 | 英赛特半导体有限公司 | Method and system for populating a database with bibliographic data from multiple sources |
| KR20140021431A (en) * | 2012-08-10 | 2014-02-20 | 연세대학교 산학협력단 | Method and apparatus for searching information in electronic meical record system |
| CN105554114A (en) * | 2015-12-17 | 2016-05-04 | 深圳市从晶科技有限公司 | Data synchronization method and data synchronization firmware platform |
| CN107301250A (en) * | 2017-07-27 | 2017-10-27 | 南京南瑞集团公司 | A kind of Various database cooperates with backup method |
| CN107818127A (en) * | 2017-09-09 | 2018-03-20 | 国网浙江省电力公司 | A kind of querying method and system for multi-source data |
| CN108009236A (en) * | 2017-11-29 | 2018-05-08 | 北京锐安科技有限公司 | A kind of big data querying method, system, computer and storage medium |
| CN108170731A (en) * | 2017-12-13 | 2018-06-15 | 腾讯科技（深圳）有限公司 | Data processing method, device, computer storage media and server |
| CN108197297A (en) * | 2018-01-23 | 2018-06-22 | 正方软件股份有限公司 | Method for exhibiting data and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109446253A (en) | 2019-03-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109446253B (en) | Data query control method, device, computer equipment and storage medium | |
| US8446261B2 (en) | Wireless ID management apparatus, wireless ID management method, and wireless ID recorder | |
| EP2249299A1 (en) | Contextualizing business intelligence reports based on context driven information | |
| US9390301B2 (en) | User grouping apparatus and methods based on collected wireless IDs in association with location and time | |
| CN103733194A (en) | Dynamically organizing cloud computing resources to facilitate discovery | |
| JP5142509B2 (en) | Document creation support apparatus and document creation support system | |
| CN104081380A (en) | Identifying and ranking solutions from multiple data sources | |
| CN103177066A (en) | Analyzing and representing interpersonal relations | |
| CN111913954A (en) | Intelligent data standard catalog generation method and device | |
| CN110502692A (en) | Information retrieval method, device, equipment and storage medium based on search engine | |
| US20020103620A1 (en) | Apparatus management method, apparatus management system, and apparatus management program product | |
| US11769160B2 (en) | Consumer goods procurement assisting system | |
| CN109727056B (en) | Financial institution recommendation method, device, storage medium and device | |
| CN111427972A (en) | Method and device for searching service data, service searching system and storage medium | |
| US10394826B1 (en) | System and methods for searching query data | |
| JPH08305724A (en) | Device for managing design supporting information document | |
| KR20010091506A (en) | Method for constructing search engine of website in internet | |
| CN111914154B (en) | Intelligent search guiding system and method | |
| EP4002151A1 (en) | Data tagging and synchronisation system | |
| CN114648010A (en) | Data table standardization method, device, equipment and computer storage medium | |
| CN113343046A (en) | Intelligent search sequencing system | |
| US7433865B2 (en) | Information collection retrieval system | |
| CN103098046A (en) | Formatting system monitoring information | |
| CN115510021B (en) | Method and system for constructing data warehouse standard layer | |
| JP2012221292A (en) | Information management device, control method of information management device, and control program of information management device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |