CN110874370A - Data query method and device, computer equipment and readable storage medium - Google Patents

Data query method and device, computer equipment and readable storage medium Download PDF

Info

Publication number
CN110874370A
CN110874370A CN201810907350.4A CN201810907350A CN110874370A CN 110874370 A CN110874370 A CN 110874370A CN 201810907350 A CN201810907350 A CN 201810907350A CN 110874370 A CN110874370 A CN 110874370A
Authority
CN
China
Prior art keywords
target
data
identification information
acquiring
operation data
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
Application number
CN201810907350.4A
Other languages
Chinese (zh)
Other versions
CN110874370B (en
Inventor
曾雄伟
方榆
胡文峰
刘登智
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Guangzhou Hong Du Information Technology Co Ltd
Original Assignee
Guangzhou Hong Du Information Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Guangzhou Hong Du Information Technology Co Ltd filed Critical Guangzhou Hong Du Information Technology Co Ltd
Priority to CN201810907350.4A priority Critical patent/CN110874370B/en
Publication of CN110874370A publication Critical patent/CN110874370A/en
Application granted granted Critical
Publication of CN110874370B publication Critical patent/CN110874370B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y02TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
    • Y02DCLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
    • Y02D10/00Energy efficient computing, e.g. low power processors, power management or thermal management

Landscapes

  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention relates to a data query method, which comprises the following steps: acquiring target identification information of target equipment, and acquiring target basic data of the target equipment from a first database according to the target identification information; acquiring a target service type to be inquired of target equipment, and acquiring target service data to be inquired of the target equipment from a second database according to the target service type; acquiring target operation data of the target equipment from the target service data according to the target identification information; and combining the target basic data and the target operation data to obtain target data of the target equipment. The scheme of the invention can effectively improve the data query efficiency.

Description

Data query method and device, computer equipment and readable storage medium
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a data query method, an apparatus, a computer device, and a readable storage medium.
Background
In order to facilitate a user to query data, data query systems are developed, different query mechanisms are generally established for different data query systems, and the user can select a proper data query system according to factors such as a data type and/or a data amount to be queried so as to meet query requirements.
The traditional technology adopts a MySql (relational database management system) or Oracle (relational database management system) query mode, one class of services is classified into a service model, and then a table is correspondingly created in a database.
However, the data structure of the Mysql database bottom layer uses BTree (multi-way search tree, a common data structure), when data needs to be updated once, it may need to go through multiple disk traversals, and when the data volume exceeds a certain volume level, the time spent by data query is longer and longer, and the query efficiency is relatively reduced.
Disclosure of Invention
The invention aims to provide a data query method, a device computer equipment and a readable storage medium, which can effectively improve the data query efficiency when the data volume is huge.
The purpose of the invention is realized by the following technical scheme:
a method of data query, the method comprising:
acquiring target identification information of target equipment, and acquiring target basic data of the target equipment from a first database according to the target identification information;
acquiring a target service type to be inquired of target equipment, and acquiring target service data to be inquired of the target equipment from a second database according to the target service type;
acquiring target operation data of the target equipment from the target service data according to the target identification information;
and combining the target basic data and the target operation data to obtain target data of the target equipment.
In one embodiment, the first database stores identification information of a plurality of devices and basic data of the devices corresponding to the identification information of the plurality of devices respectively;
the second database stores a plurality of service types of the plurality of devices and service data corresponding to each service type.
In one embodiment, each of the service data respectively includes identification information of a plurality of devices and operation data of a device corresponding to the identification information of the plurality of devices.
In one embodiment, the obtaining target basic data of the target device from the first database according to the target identification information includes:
inquiring identification information which is the same as the target identification information in the first database;
and acquiring basic data corresponding to the inquired identification information, wherein the acquired basic data is target basic data.
In one embodiment, the obtaining target service data of the target device from a second database according to the target service type includes:
inquiring the service type which is the same as the target service type in the second database;
and acquiring service data corresponding to the inquired service type, wherein the acquired service data is target service data.
In one embodiment, the obtaining target operation data of the target device from the target service data according to the target identification information includes:
inquiring identification information which is the same as the target identification information in the target service data;
and acquiring the operation data corresponding to the inquired identification information, wherein the acquired operation data is target operation data.
In one embodiment, the obtaining target operation data of the target device from the target service data according to the target identification information includes:
inquiring identification information which is the same as the target identification information in the target service data;
acquiring operation data corresponding to the inquired identification information, and comparing the operation data acquired this time with the operation data acquired last time;
and acquiring the updated operation data of the current operation data relative to the last operation data, wherein the acquired updated operation data is the target operation data.
A data query device, the device comprising:
the basic data acquisition module is used for acquiring target identification information of target equipment and acquiring target basic data of the target equipment from a first database according to the target identification information;
the service data acquisition module is used for acquiring a target service type to be inquired by target equipment and acquiring target service data to be inquired by the target equipment from a second database according to the target service type;
the operation data acquisition module is used for acquiring target operation data of the target equipment from the target service data according to the target identification information;
and the target data acquisition module is used for acquiring the target data of the target equipment by combining the target basic data and the target operation data.
A computer device comprising a memory and a processor, the memory storing a computer program, the processor implementing the following steps when executing the computer program: acquiring target identification information of target equipment, and acquiring target basic data of the target equipment from a first database according to the target identification information;
acquiring a target service type to be inquired of target equipment, and acquiring target service data to be inquired of the target equipment from a second database according to the target service type;
acquiring target operation data of the target equipment from the target service data according to the target identification information;
and combining the target basic data and the target operation data to obtain target data of the target equipment.
A computer-readable storage medium, on which a computer program is stored which, when executed by a processor, carries out the steps of:
acquiring target identification information of target equipment, and acquiring target basic data of the target equipment from a first database according to the target identification information;
acquiring a target service type to be inquired of target equipment, and acquiring target service data to be inquired of the target equipment from a second database according to the target service type;
acquiring target operation data of the target equipment from the target service data according to the target identification information;
and combining the target basic data and the target operation data to obtain target data of the target equipment.
According to the scheme of the invention, the target identification information of the target equipment is obtained, the target basic data of the target equipment is obtained from the first database according to the target identification information, the target service type to be inquired of the target equipment is obtained at the same time, and the target service data to be inquired of the target equipment is obtained from the second database according to the target service type; firstly, data in a second database is primarily screened to obtain target service data of target equipment, then target operation data of the target equipment is obtained from the target service data according to the target identification information, secondary screening is carried out to obtain target operation data, finally the target data of the target equipment is obtained by combining the target basic data and the target operation data, and grading screening is carried out.
Drawings
FIG. 1 is a diagram of an application environment of a data query method in one embodiment;
FIG. 2 is a flow diagram that illustrates a methodology for querying data in one embodiment;
FIG. 3 is a flow diagram that illustrates a methodology for querying data in one embodiment;
FIG. 4 is a flow chart illustrating a data query method according to another embodiment;
FIG. 5 is a block diagram showing the structure of a data query apparatus according to an embodiment;
FIG. 6 is a block diagram showing the structure of a data query apparatus according to an embodiment;
FIG. 7 is a block diagram showing the construction of a data search apparatus according to another embodiment;
FIG. 8 is a diagram illustrating an internal structure of a computer device in one embodiment;
fig. 9 is an internal structural view of a computer device in another embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is further described in detail below with reference to the accompanying drawings and embodiments. It should be understood that the detailed description and specific examples, while indicating the scope of the invention, are intended for purposes of illustration only and are not intended to limit the scope of the invention.
The data query method provided by the application can be applied to the application environment shown in fig. 1. The method comprises the steps that a server obtains target identification information of target equipment, and target basic data of the target equipment are obtained from a first database according to the target identification information; the server acquires a target service type to be inquired of target equipment, and acquires target service data to be inquired of the target equipment from a second database according to the target service type; the server acquires target operation data of the target equipment from the target service data according to the target identification information; and the server acquires the target data of the target equipment by combining the target basic data and the target operation data. Those skilled in the art will appreciate that the data query method provided in the present application can be applied not only to the application environment shown in fig. 1, but also to various computers or servers. The server may be implemented by an independent server or a server cluster composed of a plurality of servers.
In one embodiment, as shown in fig. 2, a data query method is provided, which is described by taking the method as an example applied to the server in fig. 1, and includes the following steps:
step S101, acquiring target identification information of target equipment, and acquiring target basic data of the target equipment from a first database according to the target identification information;
specifically, the first database stores identification information of a plurality of devices and basic data of the devices corresponding to the identification information of the plurality of devices, and the basic data includes identification feature information such as models and memories of the devices.
Step S102, acquiring a target service type to be inquired of a target device, and acquiring target service data to be inquired of the target device from a second database according to the target service type;
specifically, the second database stores multiple service types of the multiple devices and service data corresponding to each of the service types, where each of the service data includes identification information of the multiple devices and operation data of the devices corresponding to the identification information of the multiple devices.
Step S103, acquiring target operation data of the target equipment from the target service data according to the target identification information;
specifically, the operation data includes data such as the speed, the data amount, and the failure information processed by the device at different periods.
And step S104, combining the target basic data and the target operation data to obtain target data of the target equipment.
Specifically, target basic data and the target operation data are directly integrated, and the finally obtained target data comprises the basic data and the operation data corresponding to the target identification information of the target equipment.
In the data query method, target identification information of target equipment is obtained, target basic data of the target equipment is obtained from a first database according to the target identification information, a target service type to be queried of the target equipment is obtained simultaneously, and target service data to be queried of the target equipment is obtained from a second database according to the target service type; firstly, data in a second database is primarily screened to obtain target service data of target equipment, then target operation data of the target equipment is obtained from the target service data according to the target identification information, secondary screening is carried out to obtain target operation data, finally the target data of the target equipment is obtained by combining the target basic data and the target operation data, and grading screening is carried out.
In one embodiment, as shown in fig. 3, the obtaining target basic data of the target device from the first database according to the target identification information includes:
step S1011, inquiring identification information which is the same as the target identification information in the first database;
step S1012 acquires the basic data corresponding to the inquired identification information, and the acquired basic data is the target basic data.
For example, the ID (Identity) of the device is used to query the device feature information corresponding to the target ID in the first database, where the first database includes databases of MySql, Oracle, and the like.
In one embodiment, as shown in fig. 3, the obtaining target service data of the target device from the second database according to the target service type includes:
step S1021, inquiring the service type which is the same as the target service type in the second database;
step S1022, the service data corresponding to the queried service type is acquired, and the acquired service data is the target service data.
Specifically, due to the change of time, the device operation data is continuously increased, so that the second database is continuously updated along with the time lapse, and the capacity of the second database is large, so that firstly, a primary screening needs to be performed, data of the service type to be queried of the target device is screened out according to the service type, and the primary screening can be performed on the second database by adopting an ElasticSearch search method to obtain target pre-query data, so as to improve the query efficiency. Wherein, the definition of ElasticSearch is as follows: a search server provides a distributed multi-user full-text search engine, which is a popular enterprise-level search engine at present.
In one embodiment, as shown in fig. 3, the acquiring, from the target service data according to the target identification information, target operation data of the target device includes:
step S1031, inquiring identification information in the target service data, which is the same as the target identification information;
step S1032 acquires the operation data corresponding to the queried identification information, where the acquired operation data is target operation data.
Specifically, the query range of the target service data is greatly reduced relative to the second database, and then the target service data is finely searched in combination with the target identification information, so that the query efficiency can be improved, and the query accuracy can be improved.
In one embodiment, as shown in fig. 4, the acquiring target operation data of the target device from the target service data according to the target identification information includes:
step S1031, inquiring identification information in the target service data, which is the same as the target identification information;
step S1032, acquiring operation data corresponding to the inquired identification information, and comparing the operation data acquired this time with the operation data acquired last time;
step S1033, acquiring operation data in which the current operation data is updated with respect to the previous operation data, where the acquired updated operation data is the target operation data.
Specifically, the query range of the target service data is greatly reduced relative to the second database, and then the target service data is finely searched in combination with the target identification information to obtain the operation data of the current operation data relative to the last operation data, so that the operation data update condition of the target device can be obtained, and the query efficiency is high.
In one embodiment, as shown in fig. 5, there is provided a data query apparatus, including:
a basic data obtaining module 101, configured to obtain target identification information of a target device, and obtain target basic data of the target device from a first database according to the target identification information;
a service data obtaining module 102, configured to obtain a target service type to be queried by a target device, and obtain target service data to be queried by the target device from a second database according to the target service type;
an operation data obtaining module 103, configured to obtain target operation data of the target device from the target service data according to the target identification information;
and a target data obtaining module 104, configured to obtain target data of the target device by combining the target basic data and the target operation data.
In one embodiment, the first database stores identification information of a plurality of devices and basic data of the devices corresponding to the identification information of the plurality of devices, respectively.
In one embodiment, the second database stores a plurality of service types of the plurality of devices, and service data corresponding to each of the service types.
In one embodiment, each of the service data respectively includes identification information of a plurality of devices and operation data of a device corresponding to the identification information of the plurality of devices.
In one embodiment, as shown in fig. 6, the basic data acquiring module 101 includes:
a first query unit 1011 configured to query the first database for identification information that is the same as the target identification information;
the first obtaining unit 1012 obtains basic data corresponding to the inquired identification information, and the obtained basic data is target basic data.
In one embodiment, as shown in fig. 6, the service data acquiring module 102 includes:
a second query unit 1021, configured to query a service type in the second database, where the service type is the same as the target service type;
a second obtaining unit 1022, configured to obtain service data corresponding to the queried service type, where the obtained service data is target service data.
In one embodiment, as shown in fig. 6, the operation data obtaining module 103 includes:
a third querying unit 1031, configured to query the identification information in the target service data that is the same as the target identification information;
a third obtaining unit 1032, configured to obtain the operation data corresponding to the queried identification information, where the obtained operation data is target operation data.
In one embodiment, as shown in fig. 7, the operation data obtaining module 103 includes:
a fourth querying unit 1031, configured to query identification information in the target service data that is the same as the target identification information;
a comparison unit 1032, configured to obtain operation data corresponding to the queried identification information, and compare the operation data obtained this time with the operation data obtained last time;
a fourth obtaining unit 1033, configured to obtain operation data in which the current operation data is updated with respect to the previous operation data, where the obtained updated operation data is the target operation data.
In one embodiment, a computer device is provided, which may be a server, and its internal structure diagram may be as shown in fig. 8. The computer apparatus includes a processor, a memory, a network interface, and a database connected by a device bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The nonvolatile storage medium stores an operating device, a computer program, and a database. The internal memory provides an environment for the operation device in the nonvolatile storage medium and the execution of the computer program. The database of the computer device is used for storing data related to the data query. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a data query method.
In one embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be as shown in fig. 9. The computer device includes a processor, a memory, a network interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program is executed by a processor to implement a data query method. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.
Those skilled in the art will appreciate that the configurations illustrated in fig. 8-9 are merely block diagrams of portions of configurations related to aspects of the present application, and do not constitute limitations on the computing devices to which aspects of the present application may be applied, as particular computing devices may include more or less components than those illustrated, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided, comprising a memory and a processor, the memory having a computer program stored therein, the processor implementing the following steps when executing the computer program: acquiring target identification information of target equipment, and acquiring target basic data of the target equipment from a first database according to the target identification information; acquiring a target service type to be inquired of target equipment, and acquiring target service data to be inquired of the target equipment from a second database according to the target service type; acquiring target operation data of the target equipment from the target service data according to the target identification information; and combining the target basic data and the target operation data to obtain target data of the target equipment.
In one embodiment, when the processor executes the computer program, the first database stores identification information of a plurality of devices and basic data of the devices corresponding to the identification information of the plurality of devices respectively; the second database stores a plurality of service types of the plurality of devices and service data corresponding to each service type.
In one embodiment, each of the service data includes identification information of a plurality of devices and operation data of a device corresponding to the identification information of the plurality of devices, respectively, when the processor executes the computer program.
In one embodiment, the obtaining, by the processor, the target basic data of the target device from the first database according to the target identification information when the computer program is executed includes: inquiring identification information which is the same as the target identification information in the first database; and acquiring basic data corresponding to the inquired identification information, wherein the acquired basic data is target basic data.
In one embodiment, the obtaining target service data of the target device from the second database according to the target service type when the processor executes the computer program includes: inquiring the service type which is the same as the target service type in the second database; and acquiring service data corresponding to the inquired service type, wherein the acquired service data is target service data.
In one embodiment, the obtaining target operation data of the target device from the target service data according to the target identification information when the processor executes the computer program includes: inquiring identification information which is the same as the target identification information in the target service data; and acquiring the operation data corresponding to the inquired identification information, wherein the acquired operation data is target operation data.
In one embodiment, the obtaining target operation data of the target device from the target service data according to the target identification information when the processor executes the computer program includes: inquiring identification information which is the same as the target identification information in the target service data; acquiring operation data corresponding to the inquired identification information, and comparing the operation data acquired this time with the operation data acquired last time; and acquiring the updated operation data of the current operation data relative to the last operation data, wherein the acquired updated operation data is the target operation data.
In one embodiment, a computer-readable storage medium is provided, having a computer program stored thereon, which when executed by a processor, performs the steps of: acquiring target identification information of target equipment, and acquiring target basic data of the target equipment from a first database according to the target identification information; acquiring a target service type to be inquired of target equipment, and acquiring target service data to be inquired of the target equipment from a second database according to the target service type; acquiring target operation data of the target equipment from the target service data according to the target identification information; and combining the target basic data and the target operation data to obtain target data of the target equipment.
In one embodiment, when executed by a processor, a computer program stores identification information of a plurality of devices and basic data of the devices corresponding to the identification information of the plurality of devices in the first database; the second database stores a plurality of service types of the plurality of devices and service data corresponding to each service type.
In one embodiment, each of the service data includes identification information of a plurality of devices and operation data of a device corresponding to the identification information of the plurality of devices, respectively, when the computer program is executed by the processor.
In one embodiment, the computer program, when executed by the processor, obtaining target base data for the target device from the first database based on the target identification information comprises: inquiring identification information which is the same as the target identification information in the first database; and acquiring basic data corresponding to the inquired identification information, wherein the acquired basic data is target basic data.
In one embodiment, the computer program, when executed by a processor, is configured to obtain target service data of the target device from a second database according to the target service type, including: inquiring the service type which is the same as the target service type in the second database; and acquiring service data corresponding to the inquired service type, wherein the acquired service data is target service data.
In one embodiment, the computer program, when executed by a processor, for obtaining target operation data of the target device from the target service data according to the target identification information includes: inquiring identification information which is the same as the target identification information in the target service data; and acquiring the operation data corresponding to the inquired identification information, wherein the acquired operation data is target operation data.
In one embodiment, the computer program, when executed by a processor, for obtaining target operation data of the target device from the target service data according to the target identification information includes: inquiring identification information which is the same as the target identification information in the target service data; acquiring operation data corresponding to the inquired identification information, and comparing the operation data acquired this time with the operation data acquired last time; and acquiring the updated operation data of the current operation data relative to the last operation data, wherein the acquired updated operation data is the target operation data.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in the embodiments provided herein may include non-volatile and/or volatile memory, among others. Non-volatile memory can include read-only memory (ROM), Programmable ROM (PROM), Electrically Programmable ROM (EPROM), Electrically Erasable Programmable ROM (EEPROM), or flash memory. Volatile memory can include Random Access Memory (RAM) or external cache memory. By way of illustration and not limitation, RAM is available in a variety of forms such as Static RAM (SRAM), Dynamic RAM (DRAM), Synchronous DRAM (SDRAM), Double Data Rate SDRAM (DDRSDRAM), Enhanced SDRAM (ESDRAM), Synchronous Link DRAM (SLDRAM), Rambus Direct RAM (RDRAM), direct bus dynamic RAM (DRDRAM), and memory bus dynamic RAM (RDRAM).
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present invention, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the inventive concept, which falls within the scope of the present invention. Therefore, the protection scope of the present patent shall be subject to the appended claims.

Claims (10)

1. A method for data query, the method comprising:
acquiring target identification information of target equipment, and acquiring target basic data of the target equipment from a first database according to the target identification information;
acquiring a target service type to be inquired of target equipment, and acquiring target service data to be inquired of the target equipment from a second database according to the target service type;
acquiring target operation data of the target equipment from the target service data according to the target identification information;
and combining the target basic data and the target operation data to obtain target data of the target equipment.
2. The data query method according to claim 1, wherein the first database stores identification information of a plurality of devices and basic data of the devices respectively corresponding to the identification information of the plurality of devices;
the second database stores a plurality of service types of the plurality of devices and service data corresponding to each service type.
3. The data query method according to claim 2, wherein each of the service data respectively includes identification information of a plurality of devices and operation data of a device corresponding to the identification information of the plurality of devices.
4. The data query method of claim 2, wherein the obtaining of the target basic data of the target device from the first database according to the target identification information comprises:
inquiring identification information which is the same as the target identification information in the first database;
and acquiring basic data corresponding to the inquired identification information, wherein the acquired basic data is target basic data.
5. The data query method of claim 2, wherein the obtaining the target service data of the target device from the second database according to the target service type comprises:
inquiring the service type which is the same as the target service type in the second database;
and acquiring service data corresponding to the inquired service type, wherein the acquired service data is target service data.
6. The data query method according to claim 3, wherein the obtaining target operation data of the target device from the target service data according to the target identification information includes:
inquiring identification information which is the same as the target identification information in the target service data;
and acquiring the operation data corresponding to the inquired identification information, wherein the acquired operation data is target operation data.
7. The data query method according to claim 3, wherein the obtaining target operation data of the target device from the target service data according to the target identification information includes:
inquiring identification information which is the same as the target identification information in the target service data;
acquiring operation data corresponding to the inquired identification information, and comparing the operation data acquired this time with the operation data acquired last time;
and acquiring the updated operation data of the current operation data relative to the last operation data, wherein the acquired updated operation data is the target operation data.
8. A data query apparatus, characterized in that the apparatus comprises:
the basic data acquisition module is used for acquiring target identification information of target equipment and acquiring target basic data of the target equipment from a first database according to the target identification information;
the service data acquisition module is used for acquiring a target service type to be inquired by target equipment and acquiring target service data to be inquired by the target equipment from a second database according to the target service type;
the operation data acquisition module is used for acquiring target operation data of the target equipment from the target service data according to the target identification information;
and the target data acquisition module is used for acquiring the target data of the target equipment by combining the target basic data and the target operation data.
9. A computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor implements the steps of the method of any one of claims 1 to 7 when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
CN201810907350.4A 2018-08-10 2018-08-10 Data query method and device, computer equipment and readable storage medium Active CN110874370B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810907350.4A CN110874370B (en) 2018-08-10 2018-08-10 Data query method and device, computer equipment and readable storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810907350.4A CN110874370B (en) 2018-08-10 2018-08-10 Data query method and device, computer equipment and readable storage medium

Publications (2)

Publication Number Publication Date
CN110874370A true CN110874370A (en) 2020-03-10
CN110874370B CN110874370B (en) 2022-09-09

Family

ID=69714166

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810907350.4A Active CN110874370B (en) 2018-08-10 2018-08-10 Data query method and device, computer equipment and readable storage medium

Country Status (1)

Country Link
CN (1) CN110874370B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112559506A (en) * 2020-12-22 2021-03-26 卫宁健康科技集团股份有限公司 Health data processing method and device, processing equipment and storage medium

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1901477A (en) * 2006-07-12 2007-01-24 华为技术有限公司 Searching method and its system for equipment traffic data
CN103559273A (en) * 2013-11-05 2014-02-05 北京深思数盾科技有限公司 Hardware equipment information processing method and inquiry method
CN106407244A (en) * 2016-06-21 2017-02-15 平安科技(深圳)有限公司 Multi-database-based data query method, system and apparatus
WO2018010527A1 (en) * 2016-07-13 2018-01-18 腾讯科技(深圳)有限公司 Data processing method, apparatus and system, and storage medium
CN107622079A (en) * 2017-07-28 2018-01-23 阿里巴巴集团控股有限公司 Data storage, querying method and device
CN107766574A (en) * 2017-11-13 2018-03-06 天津开心生活科技有限公司 Data query method and device, date storage method and device

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1901477A (en) * 2006-07-12 2007-01-24 华为技术有限公司 Searching method and its system for equipment traffic data
CN103559273A (en) * 2013-11-05 2014-02-05 北京深思数盾科技有限公司 Hardware equipment information processing method and inquiry method
CN106407244A (en) * 2016-06-21 2017-02-15 平安科技(深圳)有限公司 Multi-database-based data query method, system and apparatus
WO2018010527A1 (en) * 2016-07-13 2018-01-18 腾讯科技(深圳)有限公司 Data processing method, apparatus and system, and storage medium
CN107622079A (en) * 2017-07-28 2018-01-23 阿里巴巴集团控股有限公司 Data storage, querying method and device
CN107766574A (en) * 2017-11-13 2018-03-06 天津开心生活科技有限公司 Data query method and device, date storage method and device

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112559506A (en) * 2020-12-22 2021-03-26 卫宁健康科技集团股份有限公司 Health data processing method and device, processing equipment and storage medium

Also Published As

Publication number Publication date
CN110874370B (en) 2022-09-09

Similar Documents

Publication Publication Date Title
CN109558404B (en) Data storage method, device, computer equipment and storage medium
CN109189799B (en) Service data query method, device, computer equipment and storage medium
CN107807967B (en) Real-time recommendation method, electronic device and computer-readable storage medium
US8639698B1 (en) Multi-language document clustering
CN105431844A (en) Third party search applications for a search system
CN108536745B (en) Shell-based data table extraction method, terminal, equipment and storage medium
US9235613B2 (en) Flexible partitioning of data
CN111209061B (en) User information filling method, device, computer equipment and storage medium
CN108509628B (en) Database configuration method and device, computer equipment and storage medium
CN110874370B (en) Data query method and device, computer equipment and readable storage medium
CN112835921A (en) Slow query processing method and device, electronic equipment and storage medium
CN107430633B (en) System and method for data storage and computer readable medium
CN109408532B (en) Data acquisition method, device, computer equipment and storage medium
US10719538B2 (en) Methods and systems for identifying local search queries
CN109840250B (en) Method, device, equipment and storage medium for managing access authority of intermediate field
CN111339170A (en) Data processing method and device, computer equipment and storage medium
CN112783866A (en) Data reading method and device, computer equipment and storage medium
CN109462543B (en) Mail downloading method, device, computer equipment and storage medium
US9483560B2 (en) Data analysis control
CN112835886A (en) Data table field adding method and device
CN114661249B (en) Data storage method and device, computer equipment and storage medium
CN113867975B (en) Quick response method and device for command line and computer equipment
US20230186174A1 (en) System and method of segmenting data and forecasting by a combination of models trained on segmented data
CN111339133B (en) Data segmentation method and device, computer equipment and storage medium
CN110019289B (en) Data query method and device and electronic equipment

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