CN109241084B - Data query method, terminal equipment and medium - Google Patents
Data query method, terminal equipment and medium Download PDFInfo
- Publication number
- CN109241084B CN109241084B CN201811080892.5A CN201811080892A CN109241084B CN 109241084 B CN109241084 B CN 109241084B CN 201811080892 A CN201811080892 A CN 201811080892A CN 109241084 B CN109241084 B CN 109241084B
- Authority
- CN
- China
- Prior art keywords
- promotion data
- data
- information base
- promotion
- information
- 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 41
- 238000001514 detection method Methods 0.000 claims abstract description 44
- 238000012545 processing Methods 0.000 claims abstract description 28
- 230000005540 biological transmission Effects 0.000 claims description 20
- 238000004590 computer program Methods 0.000 claims description 14
- 230000008569 process Effects 0.000 claims description 13
- 238000004364 calculation method Methods 0.000 abstract description 3
- 230000000694 effects Effects 0.000 abstract description 3
- 238000010586 diagram Methods 0.000 description 4
- 230000006870 function Effects 0.000 description 4
- 238000004458 analytical method Methods 0.000 description 3
- 230000001360 synchronised effect Effects 0.000 description 3
- 238000004422 calculation algorithm Methods 0.000 description 2
- 238000003032 molecular docking Methods 0.000 description 2
- 230000004044 response Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000006872 improvement Effects 0.000 description 1
- 230000002452 interceptive effect Effects 0.000 description 1
- 238000011835 investigation Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000012797 qualification Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/105—Human resources
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Entrepreneurship & Innovation (AREA)
- Operations Research (AREA)
- Economics (AREA)
- Marketing (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Information Transfer Between Computers (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention is applicable to the technical field of data processing, and provides a data query method, terminal equipment and a medium, wherein the method comprises the following steps: acquiring characteristic data of each object to be audited; in a preset time period, analyzing and processing the characteristic data to obtain promotion data of each to-be-checked image in each detection item, and storing the promotion data into a first information base; the total number of the received promotion data inquiry requests in the preset time period is smaller than a preset threshold value; acquiring a promotion data query request input by a user, wherein the promotion data query request carries an identifier for uniquely identifying the to-be-checked image; and inquiring promotion data corresponding to the identifier in the first information base, and returning the obtained promotion data. The invention does not need to calculate the promotion data required to be checked by the user in real time, thus achieving the effects of asynchronous processing and peak-shifting calculation of the promotion data, reducing the frequency of data processing and improving the acquisition efficiency and the query efficiency of the promotion data.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a data query method, a terminal device, and a computer readable storage medium.
Background
In order to ensure that all works can be executed orderly, the enterprise is generally divided into different levels of positions, so that all employees can take their roles in each position, and the management is convenient. With the continuous improvement of staff capacity, staff can be lifted from lower-level positions to higher-level positions, and the process is promoted. In the promotion process, each item of work index data of staff needs to be checked, so that in order to improve the checking efficiency, currently, each large enterprise starts to enter the staff promotion system. The staff promotion system is used for receiving various index data and then allowing an auditor to examine and check, so that when a data query request is received, promotion data which are needed to be checked by the auditor can be generated in real time based on the index data received in advance, and the staff promotion system can more intuitively know the exhibition results of all staff in the department and the subordinate department, and further can evaluate whether the staff has promotion qualification.
However, when the number of staff in the enterprise is too large, the amount of data stored in the database of the promotion system will be quite large, so that the searching speed of the index data is slow. Because auditors can only search matched index data in real time from a huge database when inquiring promotion data of staff, promotion data can be further calculated, and therefore the existing data inquiring method also reduces the inquiring efficiency of promotion data.
Disclosure of Invention
In view of the above, embodiments of the present invention provide a data query method, a terminal device, and a computer readable storage medium, so as to solve the problem in the prior art that when an auditor queries promotion data of an employee, the data query efficiency is low.
A first aspect of an embodiment of the present invention provides a data query method, including:
acquiring characteristic data of each object to be audited;
In a preset time period, analyzing and processing the characteristic data to obtain promotion data of each object to be audited in each detection item, and storing the promotion data into a first information base; the promotion data are reference data which are required to be checked in the process of auditing users, and the total number of the received promotion data inquiry requests in the preset time period is smaller than a first preset threshold;
acquiring a promotion data query request input by a user, wherein the promotion data query request carries an identifier for uniquely identifying the to-be-checked image;
And inquiring the promotion data corresponding to the identifier in the first information base, and returning the obtained promotion data.
A second aspect of an embodiment of the present invention provides a terminal device, including a memory and a processor, the memory storing a computer program executable on the processor, the processor implementing the following steps when executing the computer program:
acquiring characteristic data of each object to be audited;
In a preset time period, analyzing and processing the characteristic data to obtain promotion data of each object to be audited in each detection item, and storing the promotion data into a first information base; the promotion data are reference data which are required to be checked in the process of auditing users, and the total number of the received promotion data inquiry requests in the preset time period is smaller than a first preset threshold;
acquiring a promotion data query request input by a user, wherein the promotion data query request carries an identifier for uniquely identifying the to-be-checked image;
And inquiring the promotion data corresponding to the identifier in the first information base, and returning the obtained promotion data.
A third aspect of the embodiments of the present invention provides a computer readable storage medium storing a computer program which when executed by a processor performs the steps of:
acquiring characteristic data of each object to be audited;
In a preset time period, analyzing and processing the characteristic data to obtain promotion data of each object to be audited in each detection item, and storing the promotion data into a first information base; the promotion data are reference data which are required to be checked in the process of auditing users, and the total number of the received promotion data inquiry requests in the preset time period is smaller than a first preset threshold;
acquiring a promotion data query request input by a user, wherein the promotion data query request carries an identifier for uniquely identifying the to-be-checked image;
And inquiring the promotion data corresponding to the identifier in the first information base, and returning the obtained promotion data.
In the embodiment of the invention, the total number of the received promotion data query requests is less in the preset time period, so that the time period is a low peak period of data access. By analyzing and processing various characteristic data of the to-be-inspected object in advance in a low peak period of data access and storing the obtained promotion data into an information base, the promotion system can be ensured to rapidly screen from a target result set with smaller data quantity when a promotion data inquiry request is received, and the promotion data meeting the conditions is returned to a requesting user, so that promotion data which are required to be inspected by the user are prevented from being calculated in real time according to the original characteristic data of the to-be-inspected object every time, the effects of asynchronous processing and peak-staggering promotion data calculation are achieved, the frequency of data processing is reduced, and the acquisition efficiency and inquiry efficiency of the promotion data are improved.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings that are needed in the embodiments or the description of the prior art will be briefly described below, it being obvious that the drawings in the following description are only some embodiments of the present invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flowchart of an implementation of a data query method provided by an embodiment of the present invention;
Fig. 2 is a flowchart of a specific implementation of a data query method S102 provided in an embodiment of the present invention;
fig. 3 is a flowchart of a specific implementation of a data query method S103 provided in an embodiment of the present invention;
FIG. 4 is a flowchart of a specific implementation of a data query method S1034 provided by an embodiment of the invention;
FIG. 5 is a flowchart of another embodiment of a method S103 for querying data according to an embodiment of the present invention;
FIG. 6 is a block diagram of a data query device according to an embodiment of the present invention;
fig. 7 is a schematic diagram of a terminal device according to an embodiment of the present invention.
Detailed Description
In the following description, for purposes of explanation and not limitation, specific details are set forth such as the particular system architecture, techniques, etc., in order to provide a thorough understanding of the embodiments of the present invention. It will be apparent, however, to one skilled in the art that the present invention may be practiced in other embodiments that depart from these specific details. In other instances, detailed descriptions of well-known systems, devices, circuits, and methods are omitted so as not to obscure the description of the present invention with unnecessary detail.
In order to illustrate the technical scheme of the invention, the following description is made by specific examples.
Fig. 1 shows an implementation flow of a data query method provided by an embodiment of the present invention, where the method flow includes steps S101 to S104. The specific implementation principle of each step is as follows:
s101: and acquiring characteristic data of each object to be audited.
In the embodiment of the invention, the object to be audited is each employee object to be subjected to promotion assessment in the enterprise, and the auditor is the employee object for assessing and evaluating the image to be audited. The characteristic data represents index data associated with the object to be audited, including, but not limited to, individual display projects associated with the object to be audited, target completion values, actual completion values, individual attribute information, and the like. Each item of characteristic data is pre-entered by a system manager or uploaded by a respective business system in pre-docking.
S102: and in a preset time period, analyzing and processing the characteristic data to obtain promotion data of each object to be audited in each detection item, and storing the promotion data into a first information base. The promotion data are reference data to be checked in the process of auditing users, and the total number of the received promotion data query requests in the preset time period is smaller than a first preset threshold.
Because auditing personnel only need to check the attribute values corresponding to the object to be audited in each appointed detection item when the object to be audited carries out promotion and examination, so as to judge whether the object to be audited accords with promotion conditions according to the attribute values. The promotion data are all attribute values required to be checked by auditors. And storing the obtained promotion data into a first information base which is established in advance.
For example, a target completion coefficient of the object to be audited may be calculated according to the actual completion value of the object to be audited in the specified item and the feature data such as the target completion value, and the target completion coefficient may be stored in the first information base.
In the embodiment of the invention, the data processing event related to the characteristic data is triggered only when the current system time is within the preset time period.
Optionally, the preset time period is determined according to a setting instruction input by a system manager in a user-defined manner.
Optionally, the preset time period is divided into a plurality of time periods, a time period with the minimum history number is determined according to the history number of the received promotion data inquiry requests in each time period, and the time period is determined as the preset time period required to trigger the data processing event.
Optionally, the preset time period is divided into a plurality of time periods, a time period with the history number less than a preset threshold value is determined according to the history number of the received promotion data inquiry requests in each time period, and the time period is determined as the preset time period required to trigger the data processing event.
S103: and acquiring a promotion data query request input by a user, wherein the promotion data query request carries an identifier for uniquely identifying the to-be-checked image.
In the embodiment of the invention, the promotion data query request sent by the user is received through a remote docking service system or a local preset interactive interface. The promotion data inquiry request is used for requesting to acquire promotion data of the to-be-checked image required to be checked by the user, and the promotion data inquiry request carries an identifier for uniquely identifying the to-be-checked image. The identifier may be, for example, a user name and employee number of the object to be audited.
S104: and inquiring the promotion data corresponding to the identifier in the first information base, and returning the obtained promotion data.
In the embodiment of the invention, the identifier carried by the promotion data query request is extracted, and the data record corresponding to the identifier is found out in the first information base. By reading the promotion data contained in the data record, the promotion data is output as a query result corresponding to the promotion data query request, and the query result is returned to the user, so that the user is ensured to be able to check various index data associated with the to-be-checked image.
In the embodiment of the invention, the total number of the received promotion data query requests is less in the preset time period, so that the time period is a low peak period of data access. By analyzing and processing various characteristic data of the to-be-inspected object in advance in a low peak period of data access and storing the obtained promotion data into an information base, the promotion system can be ensured to rapidly screen from a target result set with smaller data quantity when a promotion data inquiry request is received, and the promotion data meeting the conditions is returned to a requesting user, so that promotion data which are required to be inspected by the user are prevented from being calculated in real time according to the original characteristic data of the to-be-inspected object every time, the effects of asynchronous processing and peak-staggering promotion data calculation are achieved, the frequency of data processing is reduced, and the acquisition efficiency and inquiry efficiency of the promotion data are improved.
As an embodiment of the present invention, fig. 2 shows a specific implementation flow of the data query method S102 provided by the embodiment of the present invention, which is described in detail below:
S1021: and acquiring attribute information of each to-be-examined object, wherein the attribute information comprises department information and region information.
The object to be audited has corresponding department information and region information. The regional information represents a jurisdiction to which the object to be audited belongs. For example, if the department to which the object a to be audited belongs is the financial department under the armed forces branch office, the regional information is the armed forces region. The department information and the region information are collectively called attribute information of an object to be audited.
The attribute information of each object to be audited is pre-recorded by a manager. Preferably, after receiving department information of the object to be audited entered by the manager, the regional information of the object to be audited can be automatically determined according to the preset corresponding relationship between the departments and the regions.
S1022: and storing the promotion data associated with the object to be audited into a first information base matched with the attribute information of the promotion data.
In the embodiment of the invention, an information base is respectively created for each department of each region. After determining the department information and the region information of the object to be audited through the step S1021, an information base matched with the region information and the department information is obtained. And storing all promotion data associated with the object to be audited in the information base.
In the embodiment of the invention, as departments to which different staff belong are different and each department possibly belongs to molecular companies in different areas, in most cases, the promotion and examination process of the staff at the department is responsible for investigation by the area to which the staff belongs and the lead of the department to which the staff belongs, so that promotion data of each staff in each detection item are calculated and stored in an information base corresponding to the department in the area, thereby ensuring that the query result can be rapidly read from the local information base when a promotion data query request is received, reducing the remote transmission data quantity of the promotion data and improving the query efficiency of the promotion data.
As an embodiment of the present invention, fig. 3 shows a specific implementation flow of the data query method S103 provided by the embodiment of the present invention, which is described in detail below:
s1031: and judging whether the promotion data corresponding to the identifier exists in a second information base corresponding to the login account information of the user.
In the embodiment of the invention, each user can send the promotion data query request only after logging in the system based on the login account. For each piece of login account information, determining an information base matched with a department and a region to which a user belongs according to the department and the region to which the user belongs, and storing the corresponding relation between the information base and the login account information. For convenience of distinction and convenience of reference, the information base that matches the attribute information of the to-be-checked image is referred to as a first information base, and the information base that corresponds to the account information of the requesting user is referred to as a second information base. When a user sending a promotion data query request and a to-be-checked image to be queried by the user belong to the same department and the same region, the first information base and the second information base are the same information base; when the user sending the promotion data inquiry request and the to-be-checked object to be inquired by the user belong to different departments or different areas, the first information base and the second information base are different information bases, and at the moment, the second information base is a local information base of the area to which the user belongs.
According to the embodiment of the invention, according to the current received promotion data inquiry request, the login account information matched with the promotion data inquiry request is analyzed, and a second information base corresponding to the login account information is determined. In the second information base, judging whether promotion data corresponding to the identifier carried by the promotion data inquiry request exists or not. If yes, returning the promotion data to the requesting user; if the determination result is no, step S1032 is performed.
S1032: and if the promotion data corresponding to the identifier does not exist, acquiring a detection item associated with the promotion data query request.
If the second information base does not contain the promotion data corresponding to the identifier, further analyzing the detection item associated with the promotion data query request. Specifically, the information value of a preset flag bit in a promotion data query request is obtained by reading the flag bit. According to the preset information value and the comparison relation table of the detection items, the detection items associated with the promotion data inquiry request can be determined.
S1033: and acquiring the data magnitude of promotion data about the detection item.
In the embodiment of the invention, a first information base matched with the object to be audited is determined according to the object to be audited uniquely identified by the identifier. And searching each piece of promotion data about the determined detection items in the first information base. And counting the data total amount of the promotion data obtained by searching, and determining the data magnitude of the data total amount.
For example, if the total data amount of the promotion data obtained by searching is 50 megabits, the increment of the data level of each level is 1 megabit, and the lowest data level is 0, the data level corresponding to the promotion data may be determined to be 50.
S1034: and if the data magnitude is smaller than a second preset threshold value, synchronizing promotion data about the detection item in the first information base to the second information base.
If the detected data magnitude is smaller than the second preset threshold, the data magnitude indicates that the total data amount of promotion data associated with the detected item requested to be queried by the user is smaller in the first information base, so that after communication connection between the first information base and the second information base is established, all promotion data related to the detected item can be synchronized to the second information base, and a copy of promotion data stored in the second information base is obtained.
The second preset threshold may be determined according to a setting instruction sent by a user, or may be determined according to a remaining storage capacity of the second information base.
Preferably, the data synchronization task is created when it is detected that the data magnitude is smaller than a second preset threshold. The data synchronization task is performed only when the system time falls within a predetermined period of time to synchronize promotion data pertaining to the detected items to the second information base. The historical number of the received promotion data inquiry requests in the preset time period is smaller than a third preset threshold value.
S1035: and inquiring the promotion data corresponding to the identifier in the second information base, and returning the obtained promotion data.
And inquiring the promotion data corresponding to the identifier carried by the promotion data inquiry request in the second information base after the promotion data synchronization is completed, and returning the promotion data as response information to the requesting user.
In the embodiment of the invention, when the promotion data query request is received, whether the promotion data acquired by the user request exists in the local information base of the source user is judged, so that the locally stored data can be preferentially returned without loading from the remote information base of other areas under the condition that the promotion data exists, and the information quantity of data transmission is reduced; under the condition that the promotion data does not exist, the promotion data is synchronized to a local information base by determining the data magnitude of the promotion data related to the remote, and when the data magnitude is smaller than a preset threshold value, the system is ensured not to spend longer synchronization time or larger bandwidth transmission resources; meanwhile, the method also ensures that the promotion data can be quickly returned from the local information base when the promotion data query request about the same detection item is received next time, thereby improving the query efficiency of the promotion data.
Fig. 4 shows a specific implementation flow of the data query method S1034 provided by the embodiment of the present invention, which is described in detail below:
S10341: and determining the first information base corresponding to the attribute information of the to-be-checked image according to the to-be-checked image associated with the promotion data inquiry request.
In the embodiment of the invention, for the data query request received at the current moment, the object to be audited corresponding to the identifier is determined according to the identifier carried by the data query request. After the attribute information of the object to be audited is read, a first information base corresponding to the attribute information is determined.
S10342: and determining a routing interface between the first information base and the second information base according to the routing table stored in the second information base, and calculating information transmission consumption values related to the first information base and the second information base based on the interface bandwidth of the routing interface.
In the second information base corresponding to the login account information of the requesting user, if the promotion data corresponding to the identifier does not exist, the promotion data required by the user is indicated to exist in the first information base outside, so that the remote promotion data needs to be acquired based on the internet. In the embodiment of the invention, the routing information (the routing information comprises the subnet address, the routing interface information and the like of the information base) between the second information base and the rest of the information bases is loaded according to the routing table stored in the second information base, and the routing information connected with the sub-gateway of the second information base is screened out. And determining a routing interface between the first information base and the second information base according to the screened routing information.
In the embodiment of the invention, since the interface bandwidth of each routing interface can be detected by the preset program code, and the higher the interface bandwidth is, the faster the data transmission speed is, the interface bandwidth is calculated based on the preset algorithm, so as to calculate and obtain the information transmission consumption value related to the routing interface. The information transmission consumption value is used for measuring the system resource size required to be consumed in the data transmission process of each bit.
Illustratively, the preset algorithm may include: cost=10 8/BandWith. Wherein Cost is the information transmission Cost value, bandWith is the interface bandwidth of the routing interface.
S10343: and acquiring a first preset weighting value corresponding to the information transmission consumption value and a second preset weighting value corresponding to the detection item.
In the embodiment of the invention, the information transmission consumption values with different numerical values correspond to different preset weighting values, and different detection items are also provided with different preset weighting values. Therefore, according to the calculated information transmission consumption value, determining a corresponding first preset weighting value; and determining a second preset weighting value corresponding to the detection item according to the detection item associated with the current promotion data inquiry request.
S10344: and if the first preset weighting value is smaller than the second preset weighting value and the data magnitude is smaller than a second preset threshold value, synchronizing promotion data related to the detection item in the first information base to the second information base.
If the first preset weighting value obtained in step S10343 is smaller than the second preset weighting value and the data magnitude of the promotion data about the detection item is smaller than the second preset threshold value, triggering a synchronization event of the promotion data. In the embodiment of the present invention, the synchronization implementation principle of promotion data is the same as that in the above embodiment, so that a detailed description is omitted.
Preferably, if the first preset weighted value is greater than or equal to the second preset weighted value, the feature data of the object to be audited is obtained, and the feature data is analyzed and processed, so that the promotion data generated in real time is returned to the requesting user.
In the embodiment of the invention, when the information transmission consumption value is smaller, the corresponding first preset weight is relatively smaller, so that the promotion data stored in the second information base is selected to be directly synchronized only when the first preset weight is smaller than the second preset weight and the data magnitude of the promotion data is smaller, thereby avoiding that the synchronization operation of the data occupies larger bandwidth transmission resources; by calculating and returning the promotion data in real time when the first preset weight is greater than or equal to the second preset weight, the information amount of data synchronization is reduced, so that the flexibility of data inquiry is improved.
As an embodiment of the present invention, fig. 5 shows another specific implementation flow of the data query method S103 provided by the embodiment of the present invention, which is described in detail below:
S10346: and judging whether a historical query task corresponding to the to-be-checked image exists in the latest preset time.
In the embodiment of the invention, when a promotion data query request sent by a user is received, an identifier carried by the promotion data query request is analyzed, and whether a history query task matched with the identifier exists in the latest preset time length is judged. For example, if the received promotion data query request is for requesting to acquire promotion data of the object a in the detection item of the task completion rate, it is determined whether there is a history query task about the task completion rate of the object a in the last 5 minutes.
And if the historical query task corresponding to the to-be-checked image is detected within the latest preset time, reading the task execution state of the historical query task. If the task execution status is incomplete, executing step S10347; if the task execution status is the completion status, step S10348 is executed.
S10347: and if the historical query task corresponding to the to-be-examined object exists and the task execution state of the historical query task is an unfinished state, feeding back the real-time processing progress to the user.
S10348: and if the historical query task corresponding to the to-be-examined object exists and the execution state of the historical query task is a completion state, outputting the execution result of the historical query task as the promotion data requested by the user.
In the embodiment of the invention, the execution result of each historical query task is recorded and stored. Therefore, if the history inquiry task corresponding to the to-be-checked object is detected and the execution state of the history inquiry task is the completion state, the execution result of the history inquiry task is read and returned to the requesting user.
S10349: if the historical query task corresponding to the to-be-checked image does not exist, a task execution thread is created to query the promotion data corresponding to the identifier in the first information base through the task execution thread, and the obtained promotion data is returned.
In the embodiment of the invention, after receiving the promotion data query request, whether the history query task established in the latest preset time length exists in the task status bar is checked, if so, the system is started to acquire the promotion data required by the user, and the task is not required to be repeatedly established, so that the resource utilization efficiency of the system is improved. In the big data scene, it takes longer time to finish a promotion data inquiry generally, and in the data inquiry process, in the time period between the request and the response, the system is generally without any feedback.
It should be understood that the sequence number of each step in the foregoing embodiment does not mean that the execution sequence of each process should be determined by the function and the internal logic, and should not limit the implementation process of the embodiment of the present invention.
Corresponding to the data query method described in the above embodiments, fig. 6 shows a block diagram of a data query device according to an embodiment of the present invention. For convenience of explanation, only portions relevant to the embodiments of the present invention are shown.
Referring to fig. 6, the apparatus includes:
A first obtaining unit 61, configured to obtain feature data of each object to be audited.
The analysis unit 62 is configured to perform analysis processing on the feature data in a preset time period, obtain promotion data of each object to be audited in each detection item, and store the promotion data in a first information base; the promotion data are reference data to be checked in the process of auditing users, and the total number of the received promotion data query requests in the preset time period is smaller than a first preset threshold.
The second obtaining unit 63 is configured to obtain a promotion data query request input by a user, where the promotion data query request carries an identifier for uniquely identifying the to-be-checked image.
And a return unit 64, configured to query the first information base for the promotion data corresponding to the identifier, and return the obtained promotion data.
Optionally, the analysis unit 62 includes:
And the first acquisition subunit is used for acquiring attribute information of each to-be-checked image, wherein the attribute information comprises department information and region information.
And the storage subunit is used for storing the promotion data associated with the object to be audited into a first information base matched with the attribute information of the promotion data.
Optionally, the return unit 64 includes:
and the first judging subunit is used for judging whether the promotion data corresponding to the identifier exists in a second information base corresponding to the login account information of the user.
And the second acquisition subunit is used for acquiring the detection item associated with the promotion data query request if the promotion data corresponding to the identifier does not exist.
And the third acquisition subunit is used for acquiring the data magnitude of the promotion data about the detection item.
And the synchronization subunit is used for synchronizing promotion data related to the detection item in the first information base to the second information base if the data magnitude is smaller than a second preset threshold value.
And the inquiring subunit is used for inquiring the promotion data corresponding to the identifier in the second information base and returning the obtained promotion data.
Optionally, the synchronization subunit is specifically configured to:
determining the first information base corresponding to the attribute information of the to-be-checked image according to the to-be-checked image associated with the promotion data query request;
Determining a routing interface between the first information base and the second information base according to the routing table stored in the second information base, and calculating information transmission consumption values related to the first information base and the second information base based on the interface bandwidth of the routing interface;
Acquiring a first preset weighting value corresponding to the information transmission consumption value and a second preset weighting value corresponding to the detection item;
And if the first preset weighting value is smaller than the second preset weighting value and the data magnitude is smaller than a second preset threshold value, synchronizing promotion data related to the detection item in the first information base to the second information base.
Optionally, the return unit 64 includes:
And the second judging subunit is used for judging whether a history inquiry task corresponding to the to-be-checked object exists or not in the latest preset time.
And the feedback subunit is used for feeding back the real-time processing progress to the user if the historical query task corresponding to the to-be-checked image exists and the task execution state of the historical query task is an unfinished state.
And the output subunit is used for outputting the execution result of the history inquiry task as the promotion data requested by the user if the history inquiry task corresponding to the to-be-checked image exists and the execution state of the history inquiry task is a completion state.
And the creation subunit is used for creating a task execution thread if the history inquiry task corresponding to the to-be-checked image does not exist, inquiring the promotion data corresponding to the identifier in the first information base through the task execution thread, and returning the obtained promotion data.
Fig. 7 is a schematic diagram of a terminal device according to an embodiment of the present invention. As shown in fig. 7, the terminal device 7 of this embodiment includes: a processor 70, a memory 71 and a computer program 72, such as a query program for data, stored in the memory 71 and executable on the processor 70. The processor 70, when executing the computer program 72, implements the steps of the query method embodiment for each data described above, such as steps 101 to 104 shown in fig. 1. Or the processor 70, when executing the computer program 72, performs the functions of the modules/units of the apparatus embodiments described above, e.g. the functions of the units 61 to 64 shown in fig. 6.
By way of example, the computer program 72 may be partitioned into one or more modules/units that are stored in the memory 71 and executed by the processor 70 to complete the present invention. The one or more modules/units may be a series of computer program instruction segments capable of performing specific functions for describing the execution of the computer program 72 in the terminal device 7.
The terminal device 7 may be a computing device such as a desktop computer, a notebook computer, a palm computer, a cloud server, etc. The terminal device may include, but is not limited to, a processor 70, a memory 71. It will be appreciated by those skilled in the art that fig. 7 is merely an example of the terminal device 7 and does not constitute a limitation of the terminal device 7, and may include more or less components than illustrated, or may combine certain components, or different components, e.g., the terminal device may further include an input-output device, a network access device, a bus, etc.
The Processor 70 may be a central processing unit (Central Processing Unit, CPU), or may be another general purpose Processor, a digital signal Processor (DIGITAL SIGNAL Processor, DSP), an Application SPECIFIC INTEGRATED Circuit (ASIC), an off-the-shelf Programmable gate array (Field-Programmable GATE ARRAY, FPGA) or other Programmable logic device, discrete gate or transistor logic device, discrete hardware components, or the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The memory 71 may be an internal storage unit of the terminal device 7, such as a hard disk or a memory of the terminal device 7. The memory 71 may be an external storage device of the terminal device 7, such as a plug-in hard disk, a smart memory card (SMART MEDIA CARD, SMC), a Secure Digital (SD) card, a flash memory card (FLASH CARD) or the like, which are provided on the terminal device 7. Further, the memory 71 may also include both an internal storage unit and an external storage device of the terminal device 7. The memory 71 is used for storing the computer program as well as other programs and data required by the terminal device. The memory 71 may also be used for temporarily storing data that has been output or is to be output.
In addition, each functional unit in the embodiments of the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be embodied essentially or in part or all of the technical solution or in part in the form of a software product stored in a storage medium, including instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method according to the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a random access Memory (Random Access Memory, RAM), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The above embodiments are only for illustrating the technical solution of the present application, and not for limiting the same; although the application has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical scheme described in the foregoing embodiments can be modified or some technical features thereof can be replaced by equivalents; such modifications and substitutions do not depart from the spirit and scope of the technical solutions of the embodiments of the present application.
Claims (5)
1. A method for querying data, comprising:
acquiring characteristic data of each object to be audited;
In a preset time period, analyzing and processing the characteristic data to obtain promotion data of each object to be audited in each detection item, and storing the promotion data into a first information base; the promotion data are reference data which are required to be checked in the process of auditing users, and the total number of the received promotion data inquiry requests in the preset time period is smaller than a first preset threshold;
acquiring a promotion data query request input by a user, wherein the promotion data query request carries an identifier for uniquely identifying the to-be-checked image;
inquiring the promotion data corresponding to the identifier in the first information base, and returning the obtained promotion data;
The step of inquiring the promotion data corresponding to the identifier in the first information base and returning the obtained promotion data comprises the following steps:
Judging whether the promotion data corresponding to the identifier exists in a second information base corresponding to the login account information of the user;
if the promotion data corresponding to the identifier does not exist, acquiring a detection item associated with the promotion data query request;
acquiring the data magnitude of promotion data about the detection item;
if the data magnitude is smaller than a second preset threshold value, synchronizing promotion data about the detection item in the first information base to the second information base;
Inquiring the promotion data corresponding to the identifier in the second information base, and returning the obtained promotion data;
And if the data magnitude is smaller than a second preset threshold, synchronizing promotion data related to the detection item in the first information base to the second information base, including:
Determining the first information base corresponding to the attribute information of the object to be audited according to the object to be audited associated with the promotion data inquiry request;
Determining a routing interface between the first information base and the second information base according to the routing table stored in the second information base, and calculating information transmission consumption values related to the first information base and the second information base based on the interface bandwidth of the routing interface;
Acquiring a first preset weighting value corresponding to the information transmission consumption value and a second preset weighting value corresponding to the detection item;
If the first preset weighting value is smaller than the second preset weighting value and the data magnitude is smaller than a second preset threshold value, synchronizing promotion data related to the detection item in the first information base to the second information base;
or, in the first information base, inquiring the promotion data corresponding to the identifier, and returning the obtained promotion data, including:
Judging whether a history inquiry task corresponding to the to-be-checked image exists or not within the latest preset time length;
If a historical query task corresponding to the to-be-examined object exists and the task execution state of the historical query task is an unfinished state, feeding back a real-time processing progress to the user;
If a history inquiry task corresponding to the to-be-checked image exists and the execution state of the history inquiry task is a completion state, outputting an execution result of the history inquiry task as the promotion data requested by the user;
If the historical query task corresponding to the to-be-checked image does not exist, a task execution thread is created to query the promotion data corresponding to the identifier in the first information base through the task execution thread, and the obtained promotion data is returned.
2. The method for querying data according to claim 1, wherein the analyzing the feature data in a preset time period to obtain promotion data of each object to be audited in each detection item, and storing the promotion data in a first information base includes:
Acquiring attribute information of each to-be-examined object, wherein the attribute information comprises department information and region information;
And storing the promotion data associated with the object to be audited into a first information base matched with the attribute information of the promotion data.
3. A terminal device comprising a memory and a processor, said memory storing a computer program executable on said processor, characterized in that said processor when executing said computer program performs the steps of:
acquiring characteristic data of each object to be audited;
In a preset time period, analyzing and processing the characteristic data to obtain promotion data of each object to be audited in each detection item, and storing the promotion data into a first information base; the promotion data are reference data which are required to be checked in the process of auditing users, and the total number of the received promotion data inquiry requests in the preset time period is smaller than a first preset threshold;
acquiring a promotion data query request input by a user, wherein the promotion data query request carries an identifier for uniquely identifying the to-be-checked image;
inquiring the promotion data corresponding to the identifier in the first information base, and returning the obtained promotion data;
The step of inquiring the promotion data corresponding to the identifier in the first information base and returning the obtained promotion data comprises the following steps:
Judging whether the promotion data corresponding to the identifier exists in a second information base corresponding to the login account information of the user;
if the promotion data corresponding to the identifier does not exist, acquiring a detection item associated with the promotion data query request;
acquiring the data magnitude of promotion data about the detection item;
if the data magnitude is smaller than a second preset threshold value, synchronizing promotion data about the detection item in the first information base to the second information base;
Inquiring the promotion data corresponding to the identifier in the second information base, and returning the obtained promotion data;
And if the data magnitude is smaller than a second preset threshold, synchronizing promotion data related to the detection item in the first information base to the second information base, including:
Determining the first information base corresponding to the attribute information of the object to be audited according to the object to be audited associated with the promotion data inquiry request;
Determining a routing interface between the first information base and the second information base according to the routing table stored in the second information base, and calculating information transmission consumption values related to the first information base and the second information base based on the interface bandwidth of the routing interface;
Acquiring a first preset weighting value corresponding to the information transmission consumption value and a second preset weighting value corresponding to the detection item;
If the first preset weighting value is smaller than the second preset weighting value and the data magnitude is smaller than a second preset threshold value, synchronizing promotion data related to the detection item in the first information base to the second information base;
or, in the first information base, inquiring the promotion data corresponding to the identifier, and returning the obtained promotion data, including:
Judging whether a history inquiry task corresponding to the to-be-checked image exists or not within the latest preset time length;
If a historical query task corresponding to the to-be-examined object exists and the task execution state of the historical query task is an unfinished state, feeding back a real-time processing progress to the user;
If a history inquiry task corresponding to the to-be-checked image exists and the execution state of the history inquiry task is a completion state, outputting an execution result of the history inquiry task as the promotion data requested by the user;
If the historical query task corresponding to the to-be-checked image does not exist, a task execution thread is created to query the promotion data corresponding to the identifier in the first information base through the task execution thread, and the obtained promotion data is returned.
4. The terminal device of claim 3, wherein the analyzing the feature data in a preset time period to obtain promotion data of each object to be audited in each detection item, and storing the promotion data in a first information base includes:
Acquiring attribute information of each to-be-examined object, wherein the attribute information comprises department information and region information;
And storing the promotion data associated with the object to be audited into a first information base matched with the attribute information of the promotion data.
5. A computer readable storage medium storing a computer program, characterized in that the computer program when executed by a processor realizes the steps of the method according to claim 1 or 2.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811080892.5A CN109241084B (en) | 2018-09-17 | 2018-09-17 | Data query method, terminal equipment and medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811080892.5A CN109241084B (en) | 2018-09-17 | 2018-09-17 | Data query method, terminal equipment and medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109241084A CN109241084A (en) | 2019-01-18 |
| CN109241084B true CN109241084B (en) | 2024-05-07 |
Family
ID=65059553
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811080892.5A Active CN109241084B (en) | 2018-09-17 | 2018-09-17 | Data query method, terminal equipment and medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109241084B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110213357B (en) * | 2019-05-22 | 2022-04-22 | 深圳壹账通智能科技有限公司 | Service data rollback method, device, computer equipment and storage medium |
| CN112860771A (en) * | 2019-11-28 | 2021-05-28 | 泰康保险集团股份有限公司 | Architecture difference acquisition method and system |
| CN113553372A (en) * | 2020-04-26 | 2021-10-26 | 北京沃东天骏信息技术有限公司 | Writing method and device for database, computing equipment and medium |
| CN111554367B (en) * | 2020-04-26 | 2023-05-30 | 贵州精准健康数据有限公司 | Data processing method, device and computer readable medium |
| CN112015674B (en) * | 2020-08-27 | 2023-05-30 | 平安科技（深圳）有限公司 | Multi-level-based cache resource access method and device and computer equipment |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104516920A (en) * | 2013-10-08 | 2015-04-15 | 北大方正集团有限公司 | Data inquiry method and data inquiry system |
| CN108335078A (en) * | 2017-08-03 | 2018-07-27 | 平安普惠企业管理有限公司 | Referrer promotes control method, device, equipment and storage medium |
| CN108491450A (en) * | 2018-02-26 | 2018-09-04 | 平安普惠企业管理有限公司 | Data cache method, device, server and storage medium |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20180121292A1 (en) * | 2016-11-02 | 2018-05-03 | Mastercard International Incorporated | Systems and methods for database management |
-
2018
- 2018-09-17 CN CN201811080892.5A patent/CN109241084B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104516920A (en) * | 2013-10-08 | 2015-04-15 | 北大方正集团有限公司 | Data inquiry method and data inquiry system |
| CN108335078A (en) * | 2017-08-03 | 2018-07-27 | 平安普惠企业管理有限公司 | Referrer promotes control method, device, equipment and storage medium |
| CN108491450A (en) * | 2018-02-26 | 2018-09-04 | 平安普惠企业管理有限公司 | Data cache method, device, server and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 基于决策树C5.0算法的员工职称晋级评估研究;涂波;张炜;胡文;张健伟;冯媛媛;;中国管理信息化(第08期);第65-66页 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109241084A (en) | 2019-01-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109241084B (en) | Data query method, terminal equipment and medium | |
| CN109409043B (en) | Login method of application system, terminal equipment and medium | |
| CN110569298B (en) | Data docking and visualization method and system | |
| CN104978324B (en) | Data processing method and device | |
| CN109740129B (en) | Report generation method, device and equipment based on blockchain and readable storage medium | |
| CN112527843B (en) | Data query method, device, terminal equipment and storage medium | |
| CN110737726B (en) | Method and device for determining test data of interface to be tested | |
| CN110147470B (en) | Cross-machine-room data comparison system and method | |
| CN110956269A (en) | Data model generation method, device, equipment and computer storage medium | |
| CN111400288A (en) | Data quality inspection method and system | |
| CN110201393A (en) | Configuration data storage method and device and electronic equipment | |
| CN111338888B (en) | Data statistics method and device, electronic equipment and storage medium | |
| CN113469857A (en) | Data processing method and device, electronic equipment and storage medium | |
| CN111414410A (en) | Data processing method, device, equipment and storage medium | |
| CN109710827B (en) | Picture attribute management method and device, picture server and business processing terminal | |
| CN110708361B (en) | System, method and device for determining grade of digital content publishing user and server | |
| CN110084476B (en) | Case adjustment method, device, computer equipment and storage medium | |
| CN116303320A (en) | Real-time task management method, device, equipment and medium based on log file | |
| CN113672497B (en) | Method, device and equipment for generating non-buried point event and storage medium | |
| CN111291127B (en) | Data synchronization method, device, server and storage medium | |
| CN115168509A (en) | Processing method and device of wind control data, storage medium and computer equipment | |
| CN115269519A (en) | Log detection method and device and electronic equipment | |
| CN114039878A (en) | Network request processing method and device, electronic equipment and storage medium | |
| WO2019019387A1 (en) | Information push suggestion generation method and apparatus, computer device and storage medium | |
| CN110222084B (en) | Method and device for reporting monitoring information of hotspot equipment, storage medium and terminal |
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 |