CN109446253A - 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
- CN109446253A CN109446253A CN201811119999.6A CN201811119999A CN109446253A CN 109446253 A CN109446253 A CN 109446253A CN 201811119999 A CN201811119999 A CN 201811119999A CN 109446253 A CN109446253 A CN 109446253A
- Authority
- CN
- China
- Prior art keywords
- data
- management system
- instruction
- database
- control method
- 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.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 41
- 230000010354 integration Effects 0.000 claims abstract description 17
- 238000012545 processing Methods 0.000 claims abstract description 7
- 238000012544 monitoring process Methods 0.000 claims description 7
- 238000013507 mapping Methods 0.000 claims description 6
- 238000012797 qualification Methods 0.000 claims description 6
- 238000010276 construction Methods 0.000 claims description 4
- 230000006854 communication Effects 0.000 description 10
- 238000004891 communication Methods 0.000 description 10
- 238000010586 diagram Methods 0.000 description 6
- 230000008859 change Effects 0.000 description 5
- 238000005516 engineering process Methods 0.000 description 3
- 238000012163 sequencing technique Methods 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 238000012512 characterization method Methods 0.000 description 2
- 238000012790 confirmation Methods 0.000 description 2
- 230000008878 coupling Effects 0.000 description 2
- 238000010168 coupling process Methods 0.000 description 2
- 238000005859 coupling reaction Methods 0.000 description 2
- 238000011161 development Methods 0.000 description 2
- 230000018109 developmental process Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 238000007689 inspection Methods 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
- 230000008569 process Effects 0.000 description 2
- 230000006399 behavior Effects 0.000 description 1
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000007175 bidirectional communication Effects 0.000 description 1
- 230000005540 biological transmission Effects 0.000 description 1
- 238000004590 computer program Methods 0.000 description 1
- 235000019788 craving Nutrition 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000001514 detection method Methods 0.000 description 1
- 230000004069 differentiation Effects 0.000 description 1
- 230000011218 segmentation Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
This application discloses a kind of data query control method, device, computer equipment and storage mediums, belong to big data processing analysis technical field, comprising: obtain user query instruction, user query instruction is the querying condition of input；The retrieval data for meeting querying condition are recalled in preset target database according to the inquiry instruction of user, wherein target database is to incorporate the set library of the database in multiple management systems；It is shown being sent in client after the retrieval data typesetting recalled.Data in multiple management systems are stored in target database by the application, and are integrated automatically, and user directly acquires in target database meets querying condition, and the data integrated, without manually carrying out statistics integration, labour is greatly saved, has saved human cost.
Description
Technical field
The present invention relates to technical field of data processing, specifically, the present invention relates to a kind of data query control methods, dress
It sets, computer equipment and storage medium.
Background technique
With the development of information technology, more and more information are gradually converted into electronic information, are made by various information system
With improving work efficiency, facilitate people's lives.It is different but due to the limitation of network and computer level before
Information is managed by different systems, and each system cannot be compatible with, with the development of science and technology, and people to convenient life,
Convenient office, convenient information management craving, need a kind of comprehensive management platform, can dock the data of each not homologous ray, and
Data query and management are carried out by the platform.
Summary of the invention
The purpose of the present invention is intended at least can solve above-mentioned one of technological deficiency, especially can be from multiple management systems
In obtain data query control method and device that more new data integrate processing in time.
The invention discloses a kind of data query control methods, comprising:
User query instruction is obtained, the user query instruction is the querying condition of input；
The retrieval data for meeting the querying condition are recalled in preset target database according to the inquiry instruction of user,
Wherein, the target database is to incorporate the set library of the database in multiple management systems；
It is shown being sent in client after the retrieval data typesetting recalled.
Preferably, the construction method of the target database includes:
It is separately connected the data-interface of the multiple management system；
The more new data in the database of each management system is successively obtained according to preset first rule；
The more new data that will acquire carries out sorting out integration and is stored in the target database according to preset Second Rule
In.
Preferably, first rule are as follows: be polled according to the preset order of management system；The preset order be by
The sequence at the data read time interval of the number order of management system, set management system or according to management system
Priority level sequence one of or a variety of combinations.
Preferably, first rule are as follows: by monitoring the data more new state of each data-interface, obtain exist in time
The data in management system that data update.
Preferably, the Second Rule is to merge classification to the more new data according to target information；The target
Information is the type for the data being monitored in management system, and the data that will acquire carry out the method for sorting out integration according to Second Rule
Include:
Read the target information of more new data in each database；
It is that classification qualifications merge classification to the more new data with the target information.
Preferably, the user query instruction includes output type, is sent to after the retrieval data typesetting that will be recalled
The method shown in client includes:
Identify the output type of user query instruction；
Call and be set forth in the displaying template that the output type has mapping relations；
The retrieval data are brought into the displaying template and generate statistical information, and the statistical information is sent to
It is shown in client.
Preferably, when the retrieval data recalled according to inquiry instruction have a plurality of, matching is obtained between every retrieval data
Distinguishing characteristics, according to the priority level of preset distinguishing characteristics, by the highest distinguishing characteristics of priority level and above-mentioned inspection
Rope data are presented together, for user area component selections.
A kind of data query control device is also disclosed in the application, comprising:
First acquisition unit: user query instruction, the inquiry item that the user query instruct as input are obtained for executing
Part；
Processing unit: meet described look into for executing to recall in preset target database according to the inquiry instruction of user
The retrieval data of inquiry condition, wherein the target database is to incorporate the set library of the database in multiple management systems；
First execution unit: it is shown for executing to be sent in client after the retrieval data typesetting that will be recalled.
Preferably, further includes:
Connection unit: for being separately connected the data-interface of the multiple management system；
Second acquisition unit: for successively being obtained in the database of each management system more according to preset first rule
New data；
Integral unit: it carries out sorting out integration and save according to preset Second Rule for executing the more new data that will acquire
In the target database.
Preferably, first rule are as follows: be polled according to the preset order of management system；The preset order be by
The sequence at the data read time interval of the number order of management system, set management system or according to management system
Priority level sequence one of or a variety of combinations.
Preferably, first rule are as follows: by monitoring the data more new state of each data-interface, obtain exist in time
The data in management system that data update.
Preferably, the Second Rule is to merge classification to the more new data according to target information；The target
Information is the type for the data being monitored in management system, further includes:
Reading unit: for reading the target information of more new data in each database；
Sort out unit: for being that classification qualifications merge classification to the more new data with the target information.
Preferably, the user query instruction includes output type, further includes:
Recognition unit: the output type of user query instruction for identification；
Call unit: for calling and being set forth in the output type displaying template with mapping relations；
Second execution unit: generating statistical information for the retrieval data to be brought into the displaying template, and will
The statistical information, which is sent in client, to be shown.
Preferably, when the retrieval data recalled according to inquiry instruction have a plurality of, matching is obtained between every retrieval data
Distinguishing characteristics, according to the priority level of preset distinguishing characteristics, by the highest distinguishing characteristics of priority level and above-mentioned inspection
Rope data are presented together, for user area component selections.
A kind of computer equipment, including memory and processor is also disclosed in the application, is stored with calculating in the memory
Machine readable instruction, when the computer-readable instruction is executed by the processor so that the processor execute it is described above
The step of data query control method.
A kind of storage medium being stored with computer-readable instruction disclosed herein, the computer-readable instruction is by one
When a or multiple processors execute, so that one or more processors execute the step of data query control method described above
Suddenly.
The beneficial effects of the present invention are: in the application, by obtaining the data in multiple management systems simultaneously, and will be multiple
Data in management system are stored in target database, and are integrated automatically, and user query are instructed in the target data
The data for meeting querying condition are directly acquired in library, in order to the data in the multiple management systems of quick obtaining.Automatic acquisition is more
Data in a system simultaneously carry out entire, and without manually carrying out statistics integration, labour is greatly saved, saved manpower at
This.
The additional aspect of the present invention and advantage will be set forth in part in the description, these will become from the following description
Obviously, or practice through the invention is recognized.
Detailed description of the invention
Above-mentioned and/or additional aspect and advantage of the invention will become from the following description of the accompanying drawings of embodiments
Obviously and it is readily appreciated that, in which:
Fig. 1 is data query control method flow chart of the present invention；
Fig. 2 is the construction method flow chart of target database of the present invention；
Fig. 3 is the method flow diagram that data of the present invention sort out integration；
Fig. 4 is the method flow diagram that present invention retrieval data typesetting is shown；
Fig. 5 is data query control device structural block diagram of the present invention；
Fig. 6 is computer equipment basic structure block diagram of the present invention.
Specific embodiment
The embodiment of the present invention is described below in detail, examples of the embodiments are shown in the accompanying drawings, wherein from beginning to end
Same or similar label indicates same or similar element or element with the same or similar functions.Below with reference to attached
The embodiment of figure description is exemplary, and for explaining only the invention, and is not construed as limiting the claims.
Those skilled in the art of the present technique are appreciated that unless expressly stated, singular " one " used herein, " one
It is a ", " described " and "the" may also comprise plural form.It is to be further understood that being arranged used in specification of the invention
Diction " comprising " refer to that there are the feature, integer, step, operation, element and/or component, but it is not excluded that in the presence of or addition
Other one or more features, integer, step, operation, element, component and/or their group.It should be understood that when we claim member
Part is " connected " or when " coupled " to another element, it can be directly connected or coupled to other elements, or there may also be
Intermediary element.In addition, " connection " used herein or " coupling " may include being wirelessly connected or wirelessly coupling.It is used herein to arrange
Diction "and/or" includes one or more associated wholes for listing item or any cell and all combinations.
Those skilled in the art of the present technique are appreciated that unless otherwise defined, all terms used herein (including technology art
Language and scientific term), there is meaning identical with the general understanding of those of ordinary skill in fields of the present invention.Should also
Understand, those terms such as defined in the general dictionary, it should be understood that have in the context of the prior art
The consistent meaning of meaning, and unless idealization or meaning too formal otherwise will not be used by specific definitions as here
To explain.
Those skilled in the art of the present technique are appreciated that " terminal " used herein above, " terminal device " both include wireless communication
The equipment of number receiver, only has the equipment of the wireless signal receiver of non-emissive ability, and including receiving and emitting hardware
Equipment, have on bidirectional communication link, can execute two-way communication reception and emit hardware equipment.This equipment
It may include: honeycomb or other communication equipments, shown with single line display or multi-line display or without multi-line
The honeycomb of device or other communication equipments；PCS (Personal Communications Service, PCS Personal Communications System), can
With combine voice, data processing, fax and/or communication ability；PDA (Personal Digital Assistant, it is personal
Digital assistants), it may include radio frequency receiver, pager, the Internet/intranet access, web browser, notepad, day
It goes through and/or GPS (Global Positioning System, global positioning system) receiver；Conventional laptop and/or palm
Type computer or other equipment, have and/or the conventional laptop including radio frequency receiver and/or palmtop computer or its
His equipment." terminal " used herein above, " terminal device " can be it is portable, can transport, be mounted on the vehicles (aviation,
Sea-freight and/or land) in, or be suitable for and/or be configured in local runtime, and/or with distribution form, operate in the earth
And/or any other position operation in space." terminal " used herein above, " terminal device " can also be communication terminal, on
Network termination, music/video playback terminal, such as can be PDA, MID (Mobile Internet Device, mobile Internet
Equipment) and/or mobile phone with music/video playing function, it is also possible to the equipment such as smart television, set-top box.
A kind of data query control method disclosed in the present application is mainly used for real-time statistics on the client and inquires multiple
Data in different management systems, referring to Fig. 1, its control method includes:
S100, user query instruction is obtained, the user query instruction is the querying condition of input；
User query instruction is the querying condition that user inputs on the client, and client reads the content of input and transmission
To server end, by server end identification querying condition to execute inquiry operation.Generally by way of input inquiry condition into
Row inquiry, there are many modes of input, can be through fixed subject selection and is inquired, is also possible to by specified
Input frame in input inquiry content to be inquired.
In one embodiment, if being inquired by fixed subject selection, it is only necessary to read the subject content i.e.
The subject mapped content can be obtained.If by the input inquiry content in specified input frame, then crucial by identification
The mode of word obtains querying condition.
S200, the retrieval for meeting the querying condition is recalled in preset target database according to the inquiry instruction of user
Data, wherein the target database is to incorporate the set library of the database in multiple management systems；
In one embodiment, target database is the set of the database of multiple management systems.The type of management system can
There are many, such as Work attendance management system, performance management system, sale management system etc., in the application, while connecting multiple
The data-interface of different Work attendance management systems, in order to obtain data in real time.
S300, it will be sent in client and show after the retrieval data typesetting recalled.
The retrieval data recalled carry out typesetting according to the querying condition of user query instruction, and are sent in client and carry out
Display.The querying condition includes that the subject to be inquired and specific content can also include further what data were shown
Type, for example shown with list mode, export DOC format, PDF format or Microsoft Excel format etc..
In the application, by obtaining the data in multiple management systems simultaneously, and the data in multiple management systems are deposited
Storage is integrated in target database, and automatically, and user query instruction, which directly acquires to meet in the target database, looks into
The data of inquiry condition, in order to the data in the multiple management systems of quick obtaining.Automatically the data obtained in multiple systems are gone forward side by side
Row is entire, without manually carrying out statistics integration, labour is greatly saved, has saved human cost.
In the application, there are many modes that obtain data, in one embodiment, in the multiple management systems obtained in real time
The data of system are stored in target database, and the construction method of target database is as shown in Fig. 2, specifically include that
S210, the data-interface for being separately connected the multiple management system；
Connection institute it is in need carry out data acquisition management system data-interface, data-interface be management system with the external world
The channel for carrying out data exchange, by connecting the data-interface, the rule of setting data acquisition can then acquire the management system
Real time data.
When being connected with multiple data-interfaces, in order to distinguish the data-interface, the data of each management system can be given
Interface defines a title, for example distinguished with one or more letters or character strings, or is carried out with digital number
It distinguishes, in order to the acquisition of information.
S220, the more new data in the database of each management system is successively obtained according to preset first rule；
Since the data in management system can constantly change, may cause in target database if updating not in time
Data inaccuracy, so as to cause final query result inaccuracy, in a kind of feasible embodiment, can by the first rule according to
More new data in the secondary database for obtaining each management system.
In one embodiment, the first rule can be to be polled, due to connecting according to the preset order of management system
Number has been carried out to each data-interface when the data-interface of each management system or has been distinguished with character, therefore can have been pressed
Acquisition is polled to obtain related data to corresponding data-interface according to preset sequence.Above-mentioned preset order is can be with column
The form of table is presented, and is obtained data according to the sequencing for the number or character for characterizing above-mentioned data-interface in list, is currently obtained
The data that the latest data covering previous time period taken obtains are to ensure current data for updated latest data.
In another embodiment, preset order can also be scheduled management chest in addition to the number order of management system
Data read time interval.Different management systems, the speed that data update is different, with above-mentioned disclosed attendance management
For system, performance management system, sale management system, Work attendance management system is usually for checking employee or related personnel
Attendance, complete attendance is usually as unit of day, therefore when the settable data acquisition for Work attendance management system
Between be some daily time point, such as 5 points of daily morning or morning etc., and internal performance management system and sale
Management system may change in real time, therefore the time that data can be updated shortens, one number of progress in every 3 minutes or 15 minutes
It is updated according to obtaining, to obtain latest tendency.When the data obtaining time for setting each management system, then according to the time of setting
Data interaction is carried out to relevant interface on time, obtains latest data.
In another embodiment, when being provided with multiple management systems, and there may be certain subordinate passes for multiple management systems
When being, and when quantity is larger, if the data-interface of each management system is polled, to will lead to data acquisition slower, this
When data-interface can be given to set a priority level, data-interface is polled according to priority level and data acquisition,
Such as first the data-interface of management system be A grade, the data-interface of the second management system is B, the data of third management system
Interface is A, and the data-interface of the 4th management system is C, then the sequence of data-interface poll be can the first management system, third pipe
Reason system, the second management system, are finally only the 4th management system, when there are multiple corresponding data-interfaces for each priority level
When, then in combination with the mode of the data polling in above two embodiment, according to the sequencing of the number of each data-interface
And the sequencing of the time of the acquisition data update of setting is polled.
In another embodiment, the first rule can also be the data more new state by monitoring each data-interface,
The data in the management system updated there are data are obtained in time.There are many ways to monitoring data interface data updates, one
In kind feasible embodiment, can by way of data-interface poll monitoring data interface version number, by the version of data-interface
This number is associated with internal data, the subject content of the specified management system for needing to monitor, when in specified subject
When change, version number changes appearance according to specified rule, for example every variation is primary, and version number increases by 1, and when poll passes through
Whether the version number of detection data interface changes with the version number stored when the last poll prestored, if not becoming
Change, then it represents that updated currently without data, if being changed, then it represents that there are data updates, in order to connect immediately with data
Port communications obtain newest data.The last state of data update is obtained in this way, it can be by by current management systems
In data cover previous state polling status under data, can also directly replace or update the data currently changed, remaining
Unchanged data are not replaced, and are reduced data renewal amount with this, are improved renewal speed.It is completed when data update, then saves and work as
Preceding version number, in order to be compared when next poll.
S230, the more new data that will acquire carry out sorting out integration and are stored in the number of targets according to preset Second Rule
According in library.
According to the more new data of the database in above-mentioned first Rule management system, will then obtain in the next step
The more new data taken is carried out sorting out integration and is stored in the target database in order to receiving according to preset Second Rule
Search result output is generated after to user query instruction.
The Second Rule is to merge classification to the more new data according to target information；The target information is pipe
The type for the data being monitored in reason system, referring to Fig. 3, the data that will acquire carry out the side for sorting out integration according to Second Rule
Method includes:
S231, the target information for reading more new data in each database；
Each management system corresponds to a database, by the content in data-interface reading database to be counted
According to interaction, after obtaining the more new data in database, then the target information in updated data, target information can be obtained
Type for the data being monitored in management system, for example in Work attendance management system, target information is characterization attendance employee
Number, name and Punch Type.In sale management system, target information is name of product, the number that characterization can be sold
The contents such as amount, buyer's information, sales clerk number and name.
It S232, is that classification qualifications merge classification to the more new data with the target information.
It due to the type that above-mentioned target information is data, therefore can be classification qualifications according to target information, to acquisition
Data merge number, name and the sale of the attendance employee in classification, such as above-mentioned Work attendance management system and marketing system
There may be something in common for employee number and name, then can merge the related data in two systems.In order to become apparent from
The relationship of the two is introduced on ground, is further detailed in table form in the application: table 1 is the note in Work attendance management system
Record situation:
Table 1
Table 2 is the data in sale management system:
Table 2
The above-mentioned data to obtain in wherein 2 different management systems, the target information in two tables of data includes " surname
The contents such as name ", " gender ", " number of days of turning out for work ", " kind ", " amount of money ", " agent service person ", system is according to above-mentioned target information
Type merges identical content, but it should be noted that can will be in different management systems by way of manual setting
Identical target information distinguish, for example " name " in above-mentioned table 1 indicates employee name, and " name " in table 2 is
Indicate the name of purchase client, the name of " agent service person " and " name " in table 1 are the same, therefore can be with manual setting table
" name " in 1 is defined as same category of target information together with " agent service person " two category associations in table 2,
By the identical target information in matching Tables 1 and 2, two tables be located under the same target information of Integration obtaining
All data in different management systems.For example user query instruction is " attendance and sales situation of Zhang San ", then it can be according to this
One querying condition, related data is exported, if specified output type is table, can be carried out such as 3 mode type-setting mode of table
Display:
Table 3
In the above manner, the integral data in multiple management systems can be automatically derived.
In another embodiment, it is carried out referring to Fig. 4, being sent in client after the retrieval data typesetting that will be recalled
The method of display includes:
The output type that S310, identification user query instruct；
Querying condition can further include inquiry other than the subject of inquiry disclosed above and specific content
The information such as range, such as department, the age level of period, inquiry inquired.Further, further include output type, be different from
Above-mentioned output format, output type can also be appearance form, for example be the form of table or the format of cake chart, also
The either form of histogram or curve graph, by identifying querying condition, in conjunction with data acquisition disclosed above method with
And the method for integration, obtain specific data.
S320, calling be set forth in the output type with mapping relations displaying template；
It can also be further stored in target database in the displaying template with output type with mapping relations, if
It for Output of for ms form, shows that template is then table, if the form of cake chart, shows that template is to claim multiple pieces for data segmentation
Shape structure, and finally it is combined into pie shape；If curve form, then data will be retrieved according to the type of target information, to sit
Formal distribution is marked, discrete data structure is formed, and with directly the point of various discrete combines, is distributed with showing along coordinate
The variation tendency in direction.
S330, it the result of the data statistics is brought into the displaying template generates statistical information, and by the system
Meter information, which is sent in client, to be shown.
Further, show that template includes being built-in with the retrieval Data Matching that will acquire to enter the matching rule shown in template
Then, system obtains the retrieval data recalled obtained in step s 200 according to this matching rule automatically, and to retrieval data
It is handled according to matching rule, statistical information is formed in the displaying template being brought into above-mentioned steps S320, to be sent to visitor
Family shown in end, allow user can it is more succinct, legibly understand data cases, be convenient for follow-up management.
In another embodiment, when the retrieval overabundance of data recalled according to inquiry instruction or it is present in inquiry instruction
When query context is excessive, match the distinguishing characteristics of every retrieval data, according to the priority level of distinguishing characteristics, by distinguishing characteristics with
Above-mentioned retrieval data are presented together, for user's differentiation, or for user's selection confirmation to reduce query context；The difference is special
The priority level of sign is the preset target information that can be presented automatically.When user carries out fuzzy query, such as keyword
Range of information is excessive, or can duplicate message it is more when, can show retrieval data simultaneously, for user select.Such as when with
After " Li Si, achievement situation " this keyword is inquired at family, limited due to not numbered with ID, it is understood that there may be the feelings having the same given name and family name
Condition, will appear multiple structures in this way, and user distinguishes for convenience, content that can be different in each retrieval data of automatically retrieval,
Distinguishing characteristics is presented together to facilitate user to distinguish according to priority level, to further be selected, reduces model
It encloses.
The priority level of distinguishing characteristics is the preset target information that can be presented automatically, due to the class that target information is data
Type, therefore the division of priority level can be carried out according to significance level.For example ID number is most to distinguish different personnel's identity informations
Target information, therefore the priority level that can preset ID number is highest level, when there are multiple same names in search result
When the data of people, can automatically insert ID number to distinguish, in this way be not necessarily to manually after it can not inquire best information again into
The input of row inquiry instruction.Keep data query and display mode more intelligent, search efficiency is higher.
Specifically, being explained by taking Fig. 4 table as an example:
Table 4
After using " Li Si " to retrieve for querying condition, corresponding ID number can be shown in designated position automatically, with
Facilitate user's quick obtaining distinctive information, finds oneself desired search result.Further, also for user select confirmation with
Reduce query context.
A kind of data query control device is also disclosed in the application, referring to Fig. 4, the structure of control device includes:
First acquisition unit 100: user query instruction, the inquiry that the user query instruct as input are obtained for executing
Condition；User query instruction is the querying condition that user inputs on the client, and client reads the content of input and is sent to
Server end, by server end identification querying condition to execute inquiry operation.Generally carried out by way of input inquiry condition
Inquiry, there are many modes of input, can be through fixed subject selection and is inquired, is also possible to by specified
Input inquiry content is in input frame to be inquired.
In one embodiment, if being inquired by fixed subject selection, it is only necessary to read the subject content i.e.
The subject mapped content can be obtained.If by the input inquiry content in specified input frame, then crucial by identification
The mode of word obtains querying condition.
Processing unit 200: the inquiry instruction for executing according to user is recalled in preset target database meets institute
State the retrieval data of querying condition, wherein the target database is to incorporate the set of the database in multiple management systems
Library；
In one embodiment, target database is the set of the database of multiple management systems.The type of management system can
There are many, such as Work attendance management system, performance management system, sale management system etc., in the application, while connecting multiple
The data-interface of different Work attendance management systems, in order to obtain data in real time.
First execution unit 300: it is shown for executing to be sent in client after the retrieval data typesetting that will be recalled.
The retrieval data recalled carry out typesetting according to the querying condition of user query instruction, and are sent in client and carry out
Display.The querying condition includes that the subject to be inquired and specific content can also include further what data were shown
Type, for example shown with list mode, export DOC format, PDF format or Microsoft Excel format etc..
In the application, by obtaining the data in multiple management systems simultaneously, and the data in multiple management systems are deposited
Storage is integrated in target database, and automatically, and user query instruction, which directly acquires to meet in the target database, looks into
The data of inquiry condition, in order to the data in the multiple management systems of quick obtaining.Automatically the data obtained in multiple systems are gone forward side by side
Row is entire, without manually carrying out statistics integration, labour is greatly saved, has saved human cost.
In one embodiment, the application further include:
Connection unit: for being separately connected the data-interface of the multiple management system；
Connection institute it is in need carry out data acquisition management system data-interface, data-interface be management system with the external world
The channel for carrying out data exchange, by connecting the data-interface, the rule of setting data acquisition can then acquire the management system
Real time data.
When being connected with multiple data-interfaces, in order to distinguish the data-interface, the data of each management system can be given
Interface defines a title, for example distinguished with one or more letters or character strings, or is carried out with digital number
It distinguishes, in order to the acquisition of information.
Second acquisition unit: for successively being obtained in the database of each management system more according to preset first rule
New data；
Since the data in management system can constantly change, may cause in target database if updating not in time
Data inaccuracy, so as to cause final query result inaccuracy, in a kind of feasible embodiment, can by the first rule according to
More new data in the secondary database for obtaining each management system.
First rule are as follows: be polled according to the preset order of management system；The preset order is according to management
The sequence at the data read time interval of the number order of system, set management system or according to the preferential of management system
One of level order or a variety of combinations.
In another embodiment, first rule can be with are as follows: the data for passing through each data-interface of monitoring update shape
State obtains the data in the management system updated there are data in time.
Integral unit: it carries out sorting out integration and save according to preset Second Rule for executing the more new data that will acquire
In the target database.
According to the more new data of the database in above-mentioned first Rule management system, will then obtain in the next step
The more new data taken is carried out sorting out integration and is stored in the target database in order to receiving according to preset Second Rule
Search result output is generated after to user query instruction.
The Second Rule is to merge classification to the more new data according to target information；The target information is pipe
The type for the data being monitored in reason system, further includes:
Reading unit: for reading the target information of more new data in each database；
Sort out unit: for being that classification qualifications merge classification to the more new data with the target information.
In another embodiment, further includes:
Recognition unit: the output type of user query instruction for identification；
Call unit: for calling and being set forth in the output type displaying template with mapping relations；
Second execution unit: generating statistical information for the retrieval data to be brought into the displaying template, and will
The statistical information, which is sent in client, to be shown.
In another embodiment, when the retrieval data recalled according to inquiry instruction have a plurality of, matching obtains every retrieval
Distinguishing characteristics between data, according to the priority level of preset distinguishing characteristics, by the highest distinguishing characteristics of priority level
It is presented together with above-mentioned retrieval data, for user area component selections.
The embodiment of the present invention provides computer equipment basic structure block diagram and please refers to Fig. 6.
The computer equipment includes processor, non-volatile memory medium, memory and the net connected by system bus
Network interface.Wherein, the non-volatile memory medium of the computer equipment is stored with operating system, database and computer-readable finger
It enables, control information sequence can be stored in database, when which is executed by processor, may make that processor is real
A kind of existing data query control method.The processor of the computer equipment supports entire meter for providing calculating and control ability
Calculate the operation of machine equipment.Computer-readable instruction can be stored in the memory of the computer equipment, the computer-readable instruction
When being executed by processor, processor may make to execute a kind of data query control method.The network interface of the computer equipment is used
In with terminal connection communication.It will be understood by those skilled in the art that structure shown in Fig. 6, only with application scheme phase
The block diagram of the part-structure of pass does not constitute the restriction for the computer equipment being applied thereon to application scheme, specifically
Computer equipment may include perhaps combining certain components or with different than more or fewer components as shown in the figure
Component layout.
The status information for prompting behavior that computer equipment is sent by receiving associated client, i.e., whether associated terminal
It opens prompt and whether user closes the prompt task.By verifying whether above-mentioned task condition is reached, and then eventually to association
End sends corresponding preset instructions, so that associated terminal can execute corresponding operation according to the preset instructions, to realize
Effective supervision to associated terminal.Meanwhile when prompt information state and preset status command be not identical, server end control
Associated terminal persistently carries out jingle bell, the problem of to prevent the prompt task of associated terminal from terminating automatically after executing a period of time.
The present invention also provides a kind of storage mediums for being stored with computer-readable instruction, and the computer-readable instruction is by one
When a or multiple processors execute, so that one or more processors execute data query controlling party described in any of the above-described embodiment
Method.
Those of ordinary skill in the art will appreciate that realizing all or part of the process in above-described embodiment method, being can be with
Relevant hardware is instructed to complete by computer program, which can be stored in a computer-readable storage and be situated between
In matter, the program is when being executed, it may include such as the process of the embodiment of above-mentioned each method.Wherein, storage medium above-mentioned can be
The non-volatile memory mediums such as magnetic disk, CD, read-only memory (Read-Only Memory, ROM) or random storage note
Recall body (Random Access Memory, RAM) etc..
It should be understood that although each step in the flow chart of attached drawing is successively shown according to the instruction of arrow,
These steps are not that the inevitable sequence according to arrow instruction successively executes.Unless expressly stating otherwise herein, these steps
Execution there is no stringent sequences to limit, can execute in the other order.Moreover, at least one in the flow chart of attached drawing
Part steps may include that perhaps these sub-steps of multiple stages or stage are not necessarily in synchronization to multiple sub-steps
Completion is executed, but can be executed at different times, execution sequence, which is also not necessarily, successively to be carried out, but can be with other
At least part of the sub-step or stage of step or other steps executes in turn or alternately.
The above is only some embodiments of the invention, it is noted that for the ordinary skill people of the art
For member, various improvements and modifications may be made without departing from the principle of the present invention, these improvements and modifications are also answered
It is considered as protection scope of the present invention.
Claims (10)
1. a kind of data query control method characterized by comprising
User query instruction is obtained, the user query instruction is the querying condition of input；
The retrieval data for meeting the querying condition are recalled in preset target database according to the inquiry instruction of user,
In, the target database is to incorporate the set library of the database in multiple management systems；
It is shown being sent in client after the retrieval data typesetting recalled.
2. data query control method according to claim 1, which is characterized in that the construction method of the target database
Include:
It is separately connected the data-interface of the multiple management system；
The more new data in the database of each management system is successively obtained according to preset first rule；
The more new data that will acquire is carried out sorting out integration and is stored in the target database according to preset Second Rule.
3. data query control method according to claim 2, which is characterized in that first rule are as follows: according to management
The preset order of system is polled；The preset order is number order, the set management system according to management system
Data read time interval sequence or according to management system priority level sequence one of or a variety of combinations.
4. data query control method according to claim 2, which is characterized in that first rule are as follows: pass through monitoring
The data of each data-interface more new state obtains the data in the management system updated there are data in time.
5. data query control method according to claim 2, which is characterized in that the Second Rule is to be believed according to target
Breath merges classification to the more new data；The target information is the type for the data being monitored in management system, will be obtained
The data taken according to Second Rule carry out sort out integration method include:
Read the target information of more new data in each database；
It is that classification qualifications merge classification to the more new data with the target information.
6. data query control method according to claim 5, which is characterized in that the user query instruction includes output
Type, being sent to the method shown in client after the retrieval data typesetting that will be recalled includes:
Identify the output type of user query instruction；
Call and be set forth in the displaying template that the output type has mapping relations；
The retrieval data are brought into the displaying template and generate statistical information, and the statistical information is sent to client
It is shown in end.
7. data query control method according to claim 1, which is characterized in that when the retrieval recalled according to inquiry instruction
When data have a plurality of, matching obtains the distinguishing characteristics between every retrieval data, according to the priority level of preset distinguishing characteristics,
The highest distinguishing characteristics of priority level is presented together with above-mentioned retrieval data, for user area component selections.
8. a kind of data query control device characterized by comprising
First acquisition unit: user query instruction, the querying condition that the user query instruct as input are obtained for executing；
Processing unit: meet the inquiry item for executing to recall in preset target database according to the inquiry instruction of user
The retrieval data of part, wherein the target database is to incorporate the set library of the database in multiple management systems；
First execution unit: it is shown for executing to be sent in client after the retrieval data typesetting that will be recalled.
9. a kind of computer equipment, which is characterized in that including memory and processor, being stored with computer in the memory can
Reading instruction, when the computer-readable instruction is executed by the processor, so that the processor executes such as claim 1 to 7
Any one of data query control method described in claim the step of.
10. a kind of storage medium for being stored with computer-readable instruction, which is characterized in that the computer-readable instruction is by one
Or multiple processors are when executing, so that one or more processors are executed as described in any one of claims 1 to 7 claim
Data query control method the step of.
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 true CN109446253A (en) | 2019-03-08 |
| CN109446253B 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) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110456993A (en) * | 2019-07-11 | 2019-11-15 | 阿里巴巴集团控股有限公司 | The method and system that card number based on preset rules is shown |
| CN110688395A (en) * | 2019-10-18 | 2020-01-14 | 政采云有限公司 | Information query method, device, information statistical method and related equipment |
| CN112231541A (en) * | 2020-09-22 | 2021-01-15 | 苏州艾特律宝智能科技有限公司 | Data retrieval method, system, computer device and storage medium |
| CN112835991A (en) * | 2019-11-25 | 2021-05-25 | 北京达佳互联信息技术有限公司 | System, method, device and storage medium for monitoring data |
| CN113517047A (en) * | 2021-06-08 | 2021-10-19 | 联仁健康医疗大数据科技股份有限公司 | Medical data acquisition method and device, electronic equipment and storage medium |
| CN113919820A (en) * | 2021-11-02 | 2022-01-11 | 杭州以诺行汽车科技股份有限公司 | Formula management system based on ERP system and control method |
| CN114218259A (en) * | 2022-02-21 | 2022-03-22 | 深圳市云初信息科技有限公司 | 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 (9)
| 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 |
| US20170109401A1 (en) * | 2015-10-20 | 2017-04-20 | International Business Machines Corporation | Domain centric natural language query answering |
| 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 |
-
2018
- 2018-09-25 CN CN201811119999.6A patent/CN109446253B/en active Active
Patent Citations (9)
| 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 |
| US20170109401A1 (en) * | 2015-10-20 | 2017-04-20 | International Business Machines Corporation | Domain centric natural language query answering |
| 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 |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110456993A (en) * | 2019-07-11 | 2019-11-15 | 阿里巴巴集团控股有限公司 | The method and system that card number based on preset rules is shown |
| 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 |
| CN112835991A (en) * | 2019-11-25 | 2021-05-25 | 北京达佳互联信息技术有限公司 | System, method, device and storage medium for monitoring data |
| 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 |
| CN113919820A (en) * | 2021-11-02 | 2022-01-11 | 杭州以诺行汽车科技股份有限公司 | Formula management system based on ERP system and control method |
| CN114218259A (en) * | 2022-02-21 | 2022-03-22 | 深圳市云初信息科技有限公司 | 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 |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109446253B (en) | 2024-05-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109446253A (en) | Data query control method, device, computer equipment and storage medium | |
| CN110109922B (en) | Performance data acquisition method, device, computer equipment and storage medium | |
| CN108549683A (en) | data query method and system | |
| US11544307B2 (en) | Personnel selecting device, personnel selecting system, personnel selecting method, and recording medium | |
| AU2011247915B2 (en) | Enhancing an inquiry for a search of a database | |
| CN104346431B (en) | Information processing unit, information processing method and program | |
| JP7228699B2 (en) | Schedule management service system and method | |
| CN111191111A (en) | Content recommendation method, device and storage medium | |
| CN112215448A (en) | Method and device for distributing customer service | |
| CN110442791A (en) | Data push method and system | |
| CN109447674A (en) | Electronic device, insurance agent target service area determine method and storage medium | |
| CN109242544A (en) | Processing method, device, computer equipment and the storage medium of product information push | |
| CN112330394A (en) | Merchant information display method, processing method, device, equipment and storage medium | |
| CN115018593A (en) | Independent site commodity recommendation method and device, equipment, medium and product thereof | |
| US7251622B2 (en) | System and method for searching for information on inventory with virtual warehouses | |
| CN109815266A (en) | Express delivery batch query method and apparatus based on big data platform | |
| KR20010070557A (en) | A research system using mobile terminals and the method thereof | |
| US20240013244A1 (en) | Live Local Services Results | |
| CN109903006A (en) | Reporting method, device, equipment and the computer readable storage medium of building | |
| CN109391679A (en) | Method, apparatus, computer equipment and the storage medium that information and welfare are sent | |
| CN117151358A (en) | Work order distribution method, apparatus, electronic device, storage medium and program product | |
| JP6918161B1 (en) | Analytical equipment and analytical method | |
| CN114428919A (en) | Method, device, equipment and medium for searching places | |
| JP6518023B1 (en) | Information setting device and computer program | |
| JP6581263B1 (en) | Information processing apparatus, information processing method, and program |
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 |