CN111291038B - Data query method and device - Google Patents
Data query method and device Download PDFInfo
- Publication number
- CN111291038B CN111291038B CN201811485958.9A CN201811485958A CN111291038B CN 111291038 B CN111291038 B CN 111291038B CN 201811485958 A CN201811485958 A CN 201811485958A CN 111291038 B CN111291038 B CN 111291038B
- Authority
- CN
- China
- Prior art keywords
- data
- downstream
- identification
- data processing
- stage
- 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 33
- 238000012545 processing Methods 0.000 claims abstract description 111
- 238000004590 computer program Methods 0.000 claims description 9
- 238000011161 development Methods 0.000 abstract description 6
- 238000010586 diagram Methods 0.000 description 13
- 238000004891 communication Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 5
- 230000008569 process Effects 0.000 description 5
- 230000003287 optical effect Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 239000000835 fiber Substances 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 239000004065 semiconductor Substances 0.000 description 2
- 230000008859 change Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 239000013307 optical fiber Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Classifications
-
- Y—GENERAL 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
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE 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/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Abstract
The invention discloses a data query method and a data query device, and relates to the technical field of computers. One embodiment of the method comprises the following steps: adding an identifier of downstream data to middle layer data in multi-stage data processing, wherein each stage of data processing uses at least one dimension to generate one layer of data, the middle layer data is data generated by all stages of data processing except the last stage of data processing, and the identifier is determined according to the dimension used by each stage of data processing when the downstream data is generated; and querying data used for generating the downstream data according to the identification. According to the embodiment, data write-back is not needed, the performance of data processing and query can be improved, the development cost is saved, the timeliness is enhanced, and the expenditure of data query is reduced.
Description
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a data query method and apparatus.
Background
In a large number of data query scenes, data write-back needs to be performed first, so that corresponding data is queried according to the written-back data in subsequent query. For example, in a settlement business scenario, when the business system interacts with the settlement system, the logic for data processing includes: the service system generates service data, generates charging details for charging the service data, generates settlement details through summarizing the charging details, generates a settlement bill through summarizing the settlement details, pushes the settlement bill to the settlement system, generates a settlement bill number after the settlement system receives the settlement bill, and then sends back the settlement bill number to the service system, and the service system backfills the received settlement bill number to the charging details, the settlement details and the settlement bill. And in the subsequent inquiry, inquiring corresponding data such as charging details, settlement details and the like according to the settlement bill number.
At present, with the increase of data volume, the write-back statement number has become extremely high performance cost, even in extreme cases, the write-back data can affect the financial accounting period, and when the charging details need to be queried from the statement, the cost of data query is increased by the query of the statement details.
In the process of implementing the present invention, the inventor finds that at least the following problems exist in the prior art:
the existing scheme greatly influences the performance of data processing and query, has high development cost and low timeliness, and increases the cost of data query.
Disclosure of Invention
In view of the above, the embodiments of the present invention provide a data query method and apparatus, which do not need to write back data, and can improve the performance of data processing and query, save development cost, enhance timeliness, and reduce the overhead of data query.
To achieve the above object, according to an aspect of an embodiment of the present invention, there is provided a data query method.
A data query method, comprising: adding an identifier of downstream data to middle layer data in multi-stage data processing, wherein each stage of data processing uses at least one dimension to generate one layer of data, the middle layer data is data generated by all stages of data processing except the last stage of data processing, and the identifier is determined according to the dimension used by each stage of data processing when the downstream data is generated; and querying data used for generating the downstream data according to the identification.
Optionally, the downstream data of each middle layer data includes a final result of the multi-stage data processing, the final result is data generated by the final stage data processing, and the step of querying, according to the identification, the data used to generate the downstream data includes: and querying one or more layers of designated data used for generating the final result according to the identification of the final result.
Optionally, the downstream data of each intermediate layer data includes downstream intermediate layer data of the layer, and the step of querying data used for generating the downstream data according to the identification includes: querying the specified one or more layers of data used to generate the downstream middle layer data based on the identification of one of the downstream middle layer data.
Optionally, the step of adding an identification of downstream data to the intermediate layer data in the multi-level data processing includes: splicing fields related to dimensions used by each stage of data processing when the downstream data are generated so as to determine the identification of the downstream data; and adding the determined identification of the downstream data to the corresponding intermediate layer data.
According to another aspect of the embodiment of the invention, a data query device is provided.
A data query device, comprising: the device comprises an identification adding module, a data processing module and a data processing module, wherein the identification adding module is used for adding an identification of downstream data to middle layer data in multi-stage data processing, each layer of data processing uses at least one dimension to generate one layer of data, the middle layer data is data generated by all levels of data processing except the last level of data processing, and the identification is determined according to the dimension used by all levels of data processing when the downstream data is generated; and the data query module is used for querying the data used for generating the downstream data according to the identification.
Optionally, the downstream data of each middle layer data includes a final result of the multi-stage data processing, the final result being data generated by the last stage data processing, and the data query module is further configured to: and querying one or more layers of designated data used for generating the final result according to the identification of the final result.
Optionally, the downstream data of each middle layer data includes downstream middle layer data of the layer, and the data query module is further configured to: querying the specified one or more layers of data used to generate the downstream middle layer data based on the identification of one of the downstream middle layer data.
Optionally, the identification adding module is further configured to: splicing fields related to dimensions used by each stage of data processing when the downstream data are generated so as to determine the identification of the downstream data; and adding the determined identification of the downstream data to the corresponding intermediate layer data.
According to yet another aspect of an embodiment of the present invention, an electronic device is provided.
An electronic device, comprising: one or more processors; and the memory is used for storing one or more programs, and when the one or more programs are executed by the one or more processors, the one or more processors are enabled to realize the data query method provided by the invention.
According to yet another aspect of an embodiment of the present invention, a computer-readable medium is provided.
A computer readable medium having stored thereon a computer program which when executed by a processor implements the data query method provided by the present invention.
One embodiment of the above invention has the following advantages or benefits: adding an identifier of downstream data to middle layer data in multi-stage data processing, wherein each stage of data processing uses at least one dimension to generate one layer of data, the middle layer data is data generated by all stages of data processing except the last stage of data processing, and the identifier is determined according to the dimension used by each stage of data processing when the downstream data is generated; and querying data used for generating downstream data according to the identification. The invention does not need to write back data, can improve the performance of data processing and inquiry, saves development cost, enhances timeliness and reduces the expenditure of data inquiry.
Further effects of the above-described non-conventional alternatives are described below in connection with the embodiments.
Drawings
The drawings are included to provide a better understanding of the invention and are not to be construed as unduly limiting the invention. Wherein:
FIG. 1 is a schematic diagram of main steps of a data query method according to an embodiment of the present invention;
FIG. 2 is a flow diagram of a data query method according to one embodiment of the invention;
FIG. 3 is a data query schematic of a settlement business scenario according to one embodiment of the invention;
FIG. 4 is a schematic diagram of the main modules of a data query device according to an embodiment of the present invention;
FIG. 5 is an exemplary system architecture diagram in which embodiments of the present invention may be applied;
FIG. 6 is a schematic diagram of a computer system suitable for use with a server implementing an embodiment of the invention.
Detailed Description
Exemplary embodiments of the present invention will now be described with reference to the accompanying drawings, in which various details of the embodiments of the present invention are included to facilitate understanding, and are to be considered merely exemplary. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.
Fig. 1 is a schematic diagram of main steps of a data query method according to an embodiment of the present invention.
As shown in fig. 1, the data query method in the embodiment of the present invention mainly includes the following steps S101 to S102.
Step S101: an identification of downstream data is added to intermediate layer data in the multi-level data processing.
Each link in the business flow generates data through data processing, the business flow comprises multi-stage data processing, each stage of data processing generates one layer of data by using at least one dimension, and middle layer data is data generated through all stages of data processing except the last stage of data processing. That is, the data processing result of each link in the business flow is referred to as one layer of data, and the data processing result of each link other than the last link is referred to as middle layer data.
The identification of the added downstream data is determined according to the dimensions used by the various stages of data processing in generating the downstream data.
It should be noted that, when the downstream data is generated, the identifier is also added to the downstream data.
Specifically, step S101 may include: splicing fields related to dimensionalities used for processing all levels of data when generating downstream data so as to determine the identification of the downstream data; the identification of the determined downstream data is added to the corresponding intermediate layer data.
The downstream data of a certain intermediate layer data may be data generated by a subsequent data processing link of the layer data. The final result of the multi-stage data processing, i.e., the data generated by the last stage of data processing, may be included. Intermediate layer data downstream of the layer may also be included.
Step S102: and inquiring the data used for generating certain downstream data according to the identification added by each layer of data.
In particular, a specified layer or layers of data to generate a final result of the added multi-level data processing may be queried based on an identification of the final result.
The specified layer or layers of data used to generate the downstream middle layer data may also be queried based on the identity of the added downstream middle layer data.
The data query method of the embodiment of the invention is described below by taking a settlement business scene as an example. It should be noted that the present invention is not limited to data query in a settlement business scenario, but may be used for data query in other scenarios.
In a settlement business scenario, the business process comprises a plurality of stages of data processing such as charging and generating a charging detail for business data, summarizing the charging detail and generating a settlement detail, summarizing the settlement detail and generating a settlement bill. The charging detail and the settlement detail are middle layer data of multi-stage data processing, wherein the settlement detail is downstream middle layer data of the charging detail, and the settlement bill is the final result of the multi-stage data processing, namely data generated by the last stage of data processing, and is the basis of settlement between two main bodies.
The business after generating the bill comprises payment, invoicing and the like, and when a certain bill finishes the payment, invoicing and the like, the state of the bill is changed (for example, the original unpaid non-invoicing is changed into the paid invoiced).
When the state change of the statement is completed, the statement of the latest state and the corresponding billing details and statement of account are pushed to the downstream system, which may be all systems that need to acquire statement-related data (statement of account, billing details and statement of account), such as an EBS (electronic commerce suite) system for generating a report, a system for auditing payment services, etc. Before the related data of the statement of account is sent to a downstream system, the data of the statement of account, such as charging details, statement of account, and the like, corresponding to the statement of account, namely the data of the charging details, the statement of account, and the like, used when the statement of account is generated by inquiring and summarizing, are required to be inquired.
If the downstream system only needs the charging detail data under a certain settlement detail, only the charging detail corresponding to the certain settlement detail can be queried, namely only the data of the charging detail used when the settlement detail is generated by summarizing is queried.
Fig. 2 is a flow chart of a data query method according to an embodiment of the invention. Including steps S201 to S204.
Step S201: when a charging detail is generated according to service data charging, a settlement detail identifier and a settlement list identifier are added to the charging detail.
The settlement details identifier, that is, settlement details uuid (universal unique identification code), is determined from the dimension used when the settlement details are generated by summarizing (which may be referred to as summary dimension). Specifically, fields related to a summary dimension when the settlement details are generated can be spliced to obtain the settlement details identifier. For example, if a certain settlement detail is formed by grouping and summarizing fields a and B in the charging detail, the settlement detail identifier is a Key spliced by the values of a and B, and the settlement detail identifier can be represented by a "detailKey".
And determining a statement identifier, namely a statement uuid according to dimensions used by summarizing all levels of data when the statement is generated. Specifically, for example, based on the settlement details of the previous example, the settlement list is generated according to the summary of the dimension X, and then the settlement list identification is that the value of A and the value of B are spliced, and then the settlement list identification is spliced with the value of X, and the settlement list identification can be identified by using the main Key.
Upon generation of the statement of account and the statement of account, the statement of account identification and the statement of account identification are also added to the generated statement of account and the statement of account, respectively (see step S202 and step S203, in particular).
In this embodiment, the settlement details and the statement may be referred to as downstream data of the charging details, the statement is downstream data of the settlement details, the charging details and the settlement details belong to intermediate layer data of multi-level data processing, where the settlement details are also downstream intermediate layer data of the charging details. The statement is the final result of the multi-stage data processing, namely the data generated by the last stage of data processing.
Step S202: when a settlement list is generated according to the summary of the charging list, a settlement list identifier and a settlement list identifier are added to the settlement list.
Step S203: when the statement of account is generated according to the statement of account summary, the statement of account identification is added to the statement of account.
Step S204: inquiring corresponding settlement details and/or charging details under a certain settlement list according to the settlement list identification; or inquiring the corresponding charging detail under a certain settlement detail according to the settlement detail identification.
The method can query a bill with a bill identifier according to the requirement of a downstream system and can query all the bill details and charging details with the bill identifier or only query one data of the bill details and charging details. And inquiring the settlement details with the settlement detail mark and all the charging details with the settlement detail mark according to a settlement detail mark deltailKey.
Referring to the above flow, a schematic diagram of data query of a settlement business scenario is shown in fig. 3. In fig. 3, the basic service data is the service data, and the charging result is the charging detail, and fig. 3 shows an embodiment of querying all the settlement details under a certain statement according to a statement identifier main key, and querying all the charging details under a certain statement according to a statement identifier detailKey, wherein the settlement details are generated by summarizing (merging) the charging result according to dimensions of A, B, C, and the statement is generated by summarizing (merging) the statement details according to dimensions of A, B, C, D, and the like.
In another embodiment, if the service scenario only needs to query the corresponding layers of data for the final result of the multi-stage data processing, the identification of adding the downstream data to the middle layer data in the multi-stage data processing may only include the identification of the final result of the multi-stage data processing.
In yet another embodiment, if the service scenario only needs to query the middle layer data for the corresponding layers of data, the identification of adding the downstream data to the middle layer data in the multi-level data processing may only include the identification of the downstream middle layer data of the layer.
When the charging details are generated, the embodiment of the invention can generate the settlement details identification and the settlement list identification, thereby eliminating the logic of the write-back settlement list number in the prior art, reducing the system performance cost, ensuring the financial account period, saving the development cost, improving the timeliness, optimizing the data query, and directly inquiring the required charging details according to the identification added on the charging details without inquiring the settlement details when inquiring the charging details under the settlement list because the settlement list identification is directly coupled in the charging details, and reducing the redundant inquiry of the middle layer.
Fig. 4 is a schematic diagram of main modules of a data query device according to an embodiment of the present invention.
The data query device 400 in the embodiment of the present invention mainly includes: an identification adding module 401 and a data query module 402.
The identifier adding module 401 is configured to add an identifier of downstream data to middle layer data in multiple stages of data processing, where each stage of data processing uses at least one dimension to generate a layer of data, and the middle layer data is data generated by each stage of data processing except for the last stage of data processing, where the identifier is determined according to the dimension used by each stage of data processing when generating the downstream data.
Each link in the business flow generates data through data processing, the whole business flow comprises multi-stage data processing, each stage of data processing generates one layer of data by using at least one dimension, and middle layer data is data generated through all stages of data processing except the last stage of data processing. That is, the data processing result of each link in the business flow is referred to as one layer of data, and the data processing result of each link other than the last link is referred to as middle layer data.
The downstream data of a certain intermediate layer data may be data generated by a subsequent data processing link of the layer data. The final result of the multi-stage data processing, i.e., the data generated by the last stage of data processing, may be included. Intermediate layer data downstream of the layer may also be included.
The identifier adding module 401 may specifically be used to: splicing fields related to dimensionalities used for processing all levels of data when generating downstream data so as to determine the identification of the downstream data; the identification of the determined downstream data is added to the corresponding intermediate layer data.
A data query module 402, configured to query data used to generate the downstream data according to the added identifier.
The data query module 402 may be specifically configured to: and querying one or more layers of data designated for generating the final result of the multi-level data processing according to the identification of the final result.
The data query module 402 may also be specifically configured to: based on the identification of one downstream middle tier data, the specified one or more tiers of data used to generate the downstream middle tier data are queried.
In addition, the specific implementation of the data query device in the embodiment of the present invention has been described in detail in the above data query method, so the description thereof will not be repeated here.
Fig. 5 illustrates an exemplary system architecture 500 to which the data query method or data query apparatus of embodiments of the present invention may be applied.
As shown in fig. 5, the system architecture 500 may include terminal devices 501, 502, 503, a network 504, and a server 505. The network 504 is used as a medium to provide communication links between the terminal devices 501, 502, 503 and the server 505. The network 504 may include various connection types, such as wired, wireless communication links, or fiber optic cables, among others.
A user may interact with the server 505 via the network 504 using the terminal devices 501, 502, 503 to receive or send messages or the like. Various communication client applications may be installed on the terminal devices 501, 502, 503, such as shopping class applications, web browser applications, search class applications, instant messaging tools, mailbox clients, social platform software, etc. (by way of example only).
The terminal devices 501, 502, 503 may be a variety of electronic devices having a display screen and supporting web browsing, including but not limited to smartphones, tablets, laptop and desktop computers, and the like.
The server 505 may be a server providing various services, such as a background management server (by way of example only) providing support for shopping-type websites browsed by users using the terminal devices 501, 502, 503. The background management server may analyze and process the received data such as the product information query request, and feedback the processing result (e.g., the target push information, the product information—only an example) to the terminal device.
It should be noted that, the data query method provided in the embodiment of the present invention is generally executed by the server 505, and accordingly, the data query device is generally disposed in the server 505.
It should be understood that the number of terminal devices, networks and servers in fig. 5 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.
Referring now to FIG. 6, there is illustrated a schematic diagram of a computer system 600 suitable for use in implementing a server of an embodiment of the present application. The server illustrated in fig. 6 is merely an example, and should not be construed as limiting the functionality and scope of use of the embodiments herein.
As shown in fig. 6, the computer system 600 includes a Central Processing Unit (CPU) 601, which can perform various appropriate actions and processes according to a program stored in a Read Only Memory (ROM) 602 or a program loaded from a storage section 608 into a Random Access Memory (RAM) 603. In the RAM 603, various programs and data required for the operation of the system 600 are also stored. The CPU 601, ROM 602, and RAM 603 are connected to each other through a bus 604. An input/output (I/O) interface 605 is also connected to bus 604.
The following components are connected to the I/O interface 605: an input portion 606 including a keyboard, mouse, etc.; an output portion 607 including a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, a speaker, and the like; a storage section 608 including a hard disk and the like; and a communication section 609 including a network interface card such as a LAN card, a modem, or the like. The communication section 609 performs communication processing via a network such as the internet. The drive 610 is also connected to the I/O interface 605 as needed. Removable media 611 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is installed as needed on drive 610 so that a computer program read therefrom is installed as needed into storage section 608.
In particular, according to embodiments of the present disclosure, the processes described above with reference to flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method shown in the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network through the communication portion 609, and/or installed from the removable medium 611. The above-described functions defined in the system of the present application are performed when the computer program is executed by a Central Processing Unit (CPU) 601.
The computer readable medium shown in the present invention may be a computer readable signal medium or a computer readable storage medium, or any combination of the two. The computer readable storage medium can be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or a combination of any of the foregoing. More specific examples of the computer-readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the context of this document, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present application, however, a computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, with computer-readable program code embodied therein. Such a propagated data signal may take any of a variety of forms, including, but not limited to, electro-magnetic, optical, or any suitable combination of the foregoing. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.
The flowcharts and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present application. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The modules involved in the embodiments of the present invention may be implemented in software or in hardware. The described modules may also be provided in a processor, for example, as: a processor includes an identification adding module, a data query module. The names of these modules do not constitute a limitation on the module itself in some cases, and for example, the identification adding module may also be described as "a module for adding an identification of downstream data to middle layer data in multi-level data processing".
As another aspect, the present invention also provides a computer-readable medium that may be contained in the apparatus described in the above embodiments; or may be present alone without being fitted into the device. The computer readable medium carries one or more programs which, when executed by a device, cause the device to include: adding an identifier of downstream data to middle layer data in multi-stage data processing, wherein each stage of data processing uses at least one dimension to generate one layer of data, the middle layer data is data generated by all stages of data processing except the last stage of data processing, and the identifier is determined according to the dimension used by each stage of data processing when the downstream data is generated; and querying data used for generating the downstream data according to the identification.
According to the technical scheme of the embodiment of the invention, the identification of the downstream data is added to the middle layer data in the multi-stage data processing, at least one dimension is used for generating one layer of data in each stage of data processing, the middle layer data is the data generated by each stage of data processing except the last stage of data processing, and the identification is determined according to the dimension used by each stage of data processing when the downstream data is generated; and querying data used for generating downstream data according to the identification. The data is not required to be written back, the performance of data processing and query can be improved, the development cost is saved, the timeliness is enhanced, and the expenditure of data query is reduced.
The above embodiments do not limit the scope of the present invention. It will be apparent to those skilled in the art that various modifications, combinations, sub-combinations and alternatives can occur depending upon design requirements and other factors. Any modifications, equivalent substitutions and improvements made within the spirit and principles of the present invention should be included in the scope of the present invention.
Claims (10)
1. A method of querying data, comprising:
adding an identifier of downstream data to middle layer data in multi-stage data processing, wherein each stage of data processing uses at least one dimension to generate one layer of data, the middle layer data is data generated by all stages of data processing except the last stage of data processing, and the identifier is determined according to the dimension used by each stage of data processing when the downstream data is generated;
and querying data used for generating the downstream data according to the identification.
2. The method of claim 1, wherein the downstream data of each intermediate layer data comprises a final result of the multi-stage data processing, the final result being data generated by the last stage data processing,
based on the identification, querying the data used to generate the downstream data comprises:
and querying one or more layers of designated data used for generating the final result according to the identification of the final result.
3. The method of claim 1, wherein the downstream data of each intermediate layer data comprises downstream intermediate layer data of the layer,
based on the identification, querying the data used to generate the downstream data comprises:
querying the specified one or more layers of data used to generate the downstream middle layer data based on the identification of one of the downstream middle layer data.
4. The method of claim 1, wherein the step of adding an identification of downstream data to intermediate layer data in the multi-level data processing comprises:
splicing fields related to dimensions used by each stage of data processing when the downstream data are generated so as to determine the identification of the downstream data;
and adding the determined identification of the downstream data to the corresponding intermediate layer data.
5. A data query device, comprising:
the device comprises an identification adding module, a data processing module and a data processing module, wherein the identification adding module is used for adding an identification of downstream data to middle layer data in multi-stage data processing, each layer of data processing uses at least one dimension to generate one layer of data, the middle layer data is data generated by all levels of data processing except the last level of data processing, and the identification is determined according to the dimension used by all levels of data processing when the downstream data is generated;
and the data query module is used for querying the data used for generating the downstream data according to the identification.
6. The apparatus of claim 5 wherein the downstream data of each intermediate layer data comprises a final result of the multi-stage data processing, the final result being data generated by the last stage data processing,
the data query module is further configured to:
and querying one or more layers of designated data used for generating the final result according to the identification of the final result.
7. The apparatus of claim 5, wherein the downstream data of each intermediate layer data comprises intermediate layer data downstream of the layer,
the data query module is further configured to:
querying the specified one or more layers of data used to generate the downstream middle layer data based on the identification of one of the downstream middle layer data.
8. The apparatus of claim 5, wherein the identity adding module is further configured to:
splicing fields related to dimensions used by each stage of data processing when the downstream data are generated so as to determine the identification of the downstream data;
and adding the determined identification of the downstream data to the corresponding intermediate layer data.
9. An electronic device, comprising:
one or more processors;
a memory for storing one or more programs,
the one or more programs, when executed by the one or more processors, cause the one or more processors to implement the method of any of claims 1-4.
10. A computer readable medium, on which a computer program is stored, characterized in that the program, when being executed by a processor, implements the method according to any of claims 1-4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811485958.9A CN111291038B (en) | 2018-12-06 | 2018-12-06 | Data query method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811485958.9A CN111291038B (en) | 2018-12-06 | 2018-12-06 | Data query method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111291038A CN111291038A (en) | 2020-06-16 |
| CN111291038B true CN111291038B (en) | 2024-01-12 |
Family
ID=71016795
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811485958.9A Active CN111291038B (en) | 2018-12-06 | 2018-12-06 | Data query method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111291038B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101894149A (en) * | 2010-06-23 | 2010-11-24 | 畅捷通软件有限公司 | Method and device for tracking and inquiring document |
| CN103116832A (en) * | 2011-11-16 | 2013-05-22 | 航天信息软件技术有限公司 | Method and device for grouping collecting and generating business documents |
| CN107861825A (en) * | 2017-10-16 | 2018-03-30 | 北京京东尚科信息技术有限公司 | Request processing/conditional code querying method and device, lower/upper trip node, medium |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7991800B2 (en) * | 2006-07-28 | 2011-08-02 | Aprimo Incorporated | Object oriented system and method for optimizing the execution of marketing segmentations |
-
2018
- 2018-12-06 CN CN201811485958.9A patent/CN111291038B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101894149A (en) * | 2010-06-23 | 2010-11-24 | 畅捷通软件有限公司 | Method and device for tracking and inquiring document |
| CN103116832A (en) * | 2011-11-16 | 2013-05-22 | 航天信息软件技术有限公司 | Method and device for grouping collecting and generating business documents |
| CN107861825A (en) * | 2017-10-16 | 2018-03-30 | 北京京东尚科信息技术有限公司 | Request processing/conditional code querying method and device, lower/upper trip node, medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111291038A (en) | 2020-06-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111127181B (en) | Voucher accounting method and device | |
| CN111460129A (en) | Method and device for generating identification, electronic equipment and storage medium | |
| CN110706093A (en) | Accounting processing method and device | |
| CN112884405A (en) | Inquiry system and scheduling method thereof | |
| CN112835904A (en) | Data processing method and data processing device | |
| CN111857888A (en) | Transaction processing method and device | |
| CN110909022A (en) | Data query method and device | |
| CN111881329A (en) | Account balance management method and system | |
| CN113282589A (en) | Data acquisition method and device | |
| CN110865797A (en) | Method and device for processing dynamic attributes of services | |
| CN112884181A (en) | Quota information processing method and device | |
| CN113742389A (en) | Service processing method and device | |
| CN113761565A (en) | Data desensitization method and apparatus | |
| CN111291038B (en) | Data query method and device | |
| CN112948138A (en) | Method and device for processing message | |
| CN116069725A (en) | File migration method, device, apparatus, medium and program product | |
| CN110866001A (en) | Method and device for determining order to be processed | |
| CN110851343A (en) | Test method and device based on decision tree | |
| CN113704222A (en) | Method and device for processing service request | |
| CN109213815B (en) | Method, device, server terminal and readable medium for controlling execution times | |
| CN113760929A (en) | Data synchronization method and device, electronic equipment and computer readable medium | |
| CN110019671B (en) | Method and system for processing real-time message | |
| CN113127416A (en) | Data query method and device | |
| CN110888939A (en) | Data management method and device | |
| CN113138988A (en) | Product code generation method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |