CN111090672B - Data optimization method and device - Google Patents

Data optimization method and device Download PDF

Info

Publication number
CN111090672B
CN111090672B CN201911316079.8A CN201911316079A CN111090672B CN 111090672 B CN111090672 B CN 111090672B CN 201911316079 A CN201911316079 A CN 201911316079A CN 111090672 B CN111090672 B CN 111090672B
Authority
CN
China
Prior art keywords
data
condition information
server
query
memory
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
Application number
CN201911316079.8A
Other languages
Chinese (zh)
Other versions
CN111090672A (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.)
Beijing Yunji Technology Co Ltd
Original Assignee
Beijing Yunji 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 Beijing Yunji Technology Co Ltd filed Critical Beijing Yunji Technology Co Ltd
Priority to CN201911316079.8A priority Critical patent/CN111090672B/en
Publication of CN111090672A publication Critical patent/CN111090672A/en
Application granted granted Critical
Publication of CN111090672B publication Critical patent/CN111090672B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2453Query optimisation
    • G06F16/24534Query rewriting; Transformation
    • G06F16/24549Run-time optimisation
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2471Distributed queries
    • 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

Abstract

The embodiment of the application provides a data optimization method and device, and relates to the technical field of servers. The method comprises the following steps: receiving a query instruction of a user; analyzing the query instruction to obtain query condition information, and calling queried data in a database server according to the query condition information; sending the query condition information and the queried data to a memory space to compare and query in the memory space; and receiving service data which is fed back by the memory space and is matched with the query condition information, and returning the service data to the client. According to the method, the data interaction is performed by setting the memory space, so that the connection times of the server and the database are reduced, and the problems of program deadlock and slow user request response caused by frequent interaction of the server and the database in the existing method are solved.

Description

Data optimization method and device
Technical Field
The application relates to the technical field of servers, in particular to a data optimization method and device.
Background
Under the condition that a user frequently accesses, as data is sourced from a plurality of data sources, integration screening is needed for the data, multiple request interactions are needed to be generated between a server and a database, and a batch of corresponding temporary data responses are generated and are sent to the user.
Every time the user accesses all data of a parent-child node, the matching screening is carried out, when the previous request is not processed, the next request of the user comes in again, so that the server (computer) resources are continuously distributed and cannot be released, the deadlock of the program is caused, the system operation is always in a peak value, no data is returned to the user or the user needs to wait until the resources are released, and the request of the user can be processed; databases typically use desktop databases, and no resources can be used that would cause data deadlocks, even server crashes.
Disclosure of Invention
The embodiment of the application aims to provide a data optimization method and device, and the method and device are used for reducing the connection times of a server and a database by setting a memory space to perform data interaction, so that the problems of program deadlock and slow response of a user request caused by frequent interaction of the server and the database in the existing method are solved.
The embodiment of the application provides a data optimization method which is applied to an application server and comprises the following steps:
receiving a query instruction of a user;
analyzing the query instruction to obtain query condition information, and calling queried data in a database server according to the query condition information;
sending the query condition information and the queried data to a memory space to compare and query in the memory space;
and receiving service data which is fed back by the memory space and is matched with the query condition information, and returning the service data to the client.
In the implementation process, the repeated data acquisition and comparison process is carried out in the memory space, so that the connection times of the application server and the database server are greatly reduced, the resource consumption of a CPU (central processing unit) is reduced, and the problem of system breakdown caused by continuous contention for resources is avoided; the query condition information and the queried data are compared and queried in the memory space, the service data required by the user is obtained and returned to the user, and the user requirement can be responded quickly, so that the problems of program deadlock and slow user request response caused by frequent interaction between the server and the database in the existing method are solved.
Further, the memory space is a temporary storage space set in the application server, and the sending the query condition information and the queried data to the memory space to perform comparison and query in the memory space includes:
allocating a temporary storage space as a memory space;
storing the query condition information and the queried data into a temporary storage space;
and searching the service data matched with the query condition information in the queried data.
In the implementation process, the memory space can be a temporary storage space inside the application server, data interaction is performed in the temporary storage space, the original data is compared and the disc needs to be read for many times and is changed into the memory space, and the queried data is acquired into the memory space at one time, so that the connection times of the application server and the database server are reduced, and the data interaction efficiency is improved.
Further, the memory space is a memory server, and the memory server is in communication connection with the application server; the sending the query condition information and the queried data to a memory space to compare and query in the memory space includes:
storing the query condition information and the queried data into a memory server;
and receiving service data matched with the query condition information and returned by the memory server.
In the implementation process, the memory space can be an independent memory server, and the memory server is in communication connection with the application server, for example, data transmission is realized through a local area network, and comparison and search of data are changed from original data in a disk of the database server to data in the memory server, so that the request response time and response speed of a user can be greatly improved.
Further, the method further comprises:
receiving new data information;
analyzing the data information;
pushing the data information to corresponding users, and storing the data information in a memory space and a database server so as to update service data in the memory space and the database server.
In the implementation process, when new data information is generated, the new data information can be added into a storage space and a database server, so that the accuracy and timeliness of the data in the memory space are ensured; the new data information is pushed to the corresponding user, and the latest information is timely received even if the user does not refresh the page, so that the connection times of the client and the application server are reduced, and the pressure of the application server and the database server is relieved.
Further, the method further comprises:
and sending the query condition information and the queried data to a client to compare and query at the client and acquire service data matched with the query condition information.
In the implementation process, the data is compared at the client, so that the burden of a system is reduced, the time consumption and the resource consumption of an application server and a database server are reduced, and the response speed is improved.
The embodiment of the application also provides a data optimization device which is applied to the application server and comprises:
the instruction receiving module is used for receiving a query instruction of a user;
the instruction analysis module is used for analyzing the query instruction, obtaining query condition information and calling queried data in the database server according to the query condition information;
the data query module is used for sending the query condition information and the queried data to a memory space so as to compare and query in the memory space;
and the data receiving module is used for receiving the service data matched with the query condition information and returning the service data to the client.
In the implementation process, related queried data in a database server are acquired according to the query condition information of a user, the comparison and query between the query condition information and the queried data are performed in a memory space, and compared with the prior process in a disk in the database server, the server node with a shortage of resources is transferred to a node with a relatively loose resource for processing, so that the connection times between an application server and the database server are reduced, the purpose of quickly responding to the user is achieved, and the problems of program deadlock and slow user request response caused by frequent interaction between the server and the database in the prior method are solved.
Further, the memory space is a temporary storage space set in the application server, and the data query module includes:
the storage space allocation module is used for allocating the temporary storage space as a memory space;
the data storage module is used for storing the query condition information and the queried data into a temporary storage space;
and the data searching module is used for searching the service data matched with the query condition information in the queried data.
In the implementation process, the memory space can be a temporary storage space allocated by the application server, and the query condition information and the queried data are allocated to the temporary storage space for comparison and query, so that the connection times of the application server and the database server are reduced, and the response speed of a user is improved.
Further, the memory space is a memory server; the data query module comprises:
the data sending module is used for storing the query condition information and the queried data into a memory server;
and the service data receiving module is used for receiving the service data which is returned by the memory server and is matched with the query condition information.
In the implementation process, the memory space can be a memory server with low configuration, and the memory server is in communication connection with the application server, so that data transmission and interaction are realized, the comparison of the query condition information and the queried data is performed in the memory server, and the request response time and response speed of a user can be greatly improved.
The embodiment of the application also provides electronic equipment, which comprises a memory and a processor, wherein the memory is used for storing a computer program, and the processor runs the computer program to enable the computer equipment to execute the data optimization method.
The embodiment of the application also provides a readable storage medium, wherein the readable storage medium stores computer program instructions, and when the computer program instructions are read and run by a processor, the data optimization method of any one of the above is executed.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present application, the drawings that are needed in the embodiments of the present application will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present application and should not be considered as limiting the scope, and other related drawings can be obtained according to these drawings without inventive effort for a person skilled in the art.
FIG. 1 is a flow chart of a data optimization method according to an embodiment of the present application;
FIG. 2 is a flowchart of the temporary storage space comparison and query provided in an embodiment of the present application;
FIG. 3 is a block diagram of data transmission relationships among a user, an application server, a memory server, and a database server according to an embodiment of the present application;
FIG. 4 is a flow chart of query and comparison of a memory server according to an embodiment of the present application;
FIG. 5 is a flow chart of a process for receiving new data information according to an embodiment of the present application;
FIG. 6 is a block diagram of a data optimizing apparatus according to an embodiment of the present application;
fig. 7 is a block diagram of one of the data query modules 300 according to an embodiment of the present application;
FIG. 8 is a block diagram illustrating another exemplary data query module 300 according to an embodiment of the present application;
FIG. 9 is a block diagram of a specific structure of a data optimization device according to an embodiment of the present application;
fig. 10 is a block diagram of another data optimization processing device according to an embodiment of the present application.
Icon:
100-an instruction receiving module; 200-an instruction parsing module; 300-a data query module; 311-a storage space allocation module; 312-a data storage module; 313-a data lookup module; 321-a data transmission module; 322-a service data receiving module; 400-a data receiving module; 501-a data information receiving module; 502-a data parsing module; 503-a data update module; 601-comparison data transmission module.
Detailed Description
The technical solutions in the embodiments of the present application will be described below with reference to the accompanying drawings in the embodiments of the present application.
It should be noted that: like reference numerals and letters denote like items in the following figures, and thus once an item is defined in one figure, no further definition or explanation thereof is necessary in the following figures. Meanwhile, in the description of the present application, the terms "first", "second", and the like are used only to distinguish the description, and are not to be construed as indicating or implying relative importance.
Example 1
Referring to fig. 1, fig. 1 is a flowchart of a data optimization method according to an embodiment of the application. When the user frequently accesses, the application server needs to frequently access the database server to integrate and filter the data, namely, the data of each child node based on the same father node is acquired one by one and compared one by one, and temporary data response corresponding to the user request is generated for the user. In the process, the current user request is not processed, and the next user request comes in again, so that data deadlock and server breakdown are easy to cause. In view of the above, the present application provides a data optimization method to solve the problems of program deadlock and slow response of user requests caused by frequent interaction between a server and a database, and the method is applied to an application server.
The method specifically comprises the following steps:
step S100: receiving a query instruction of a user;
step S200: analyzing the query instruction to obtain query condition information, and calling queried data in a database server according to the query condition information;
in the implementation process, the application server calls the queried data related to the query condition information of the user, instead of directly reading the disk of the database server for many times and frequently according to the query condition information in the existing method, so that the connection times of the application server and the database disk are reduced.
Step S300: sending the query condition information and the queried data to the memory space to compare and query in the memory space;
as one embodiment, the memory space may be a temporary storage space provided in the application server, as shown in fig. 2, which is a comparison and query flow chart of the temporary storage space. The method specifically comprises the following steps:
step S311: allocating a temporary storage space as a memory space;
step S312: storing the query condition information and the queried data into a temporary storage space;
step S313: and searching the service data matched with the query condition information in the queried data.
The temporary storage space is directly distributed in the application server to serve as the memory space, query condition information and queried data are stored in the temporary storage space, comparison and search of the query condition information and the queried data are carried out in the temporary storage space, when original data are compared, a disc of the database server is required to be read for many times and is replaced by the read memory space, the queried data are acquired into the memory space at one time, the connection times of the application server and the database server are reduced, the resource consumption of a CPU (Central Processing Unit, a central processing unit) is reduced, and the request response time and the response speed of a user can be greatly improved.
As another embodiment, the memory space may be an additionally provided memory server, where the memory server is communicatively connected to the application server, for example, through a lan, and the memory server is communicatively connected to the database server, for example, through a lan, so as to implement data transmission, and the queried data that needs to be compared with the query condition information of the user may be transmitted to the memory server. As shown in fig. 3, a block diagram of the data transmission relationship among the user, the application server, the memory server, and the database server is shown.
As shown in fig. 4, a flow chart of the query and comparison of the memory server is shown. The method specifically comprises the following steps:
step S321: storing the query condition information and the queried data into a memory server;
step S322: and receiving service data matched with the query condition information and returned by the memory server.
In the implementation process, the application server takes the data related to the query condition information in the calling database server as the queried data, and transmits the queried data to the memory server for storage; in the memory server, the query condition is used as a comparison and is compared with the queried data; the comparison and the search of the data are changed from the original process of changing the data in the disk of the database server into the process of changing the data in the memory server, so that the request response time and the response speed of a user can be greatly improved, the connection times of the application server and the database server are reduced, and the data interaction efficiency is improved.
Step S400: and receiving the service data which is fed back by the memory space and matches with the query condition information, and returning the service data to the client.
And returning the comparison and matching result obtained in the memory space, namely the service data matched with the query condition information, to the client corresponding to the user, and completing the response to the user.
According to the method, the memory space is arranged, the repeated data acquisition and comparison process is carried out in the memory space, so that the connection times of the application server and the database server are greatly reduced, the resource consumption of a CPU is reduced, and the problem of system breakdown caused by continuous resource contention is avoided; the query condition information and the queried data are compared and queried in the memory space, the service data required by the user is obtained and returned to the user, and the user requirement can be responded quickly, so that the problems of program deadlock and slow user request response caused by frequent interaction between the server and the database in the existing method are solved.
For example, as shown in fig. 5, a process flow diagram is provided for receiving new data information. The method may further comprise:
step S501: receiving new data information;
step S502: analyzing the data information;
step S503: pushing the data information to the corresponding users, and storing the data information in the memory space and the database server so as to update the business data in the memory space and the database server.
As shown in fig. 3, the robot sends new data information to be notified to the system to the application server in the form of a message, the application server receives and parses the new data information, if the new data information is related to the currently online user, the new data information can be directly pushed to the corresponding user in a Socket protocol mode, even if the user does not refresh a page, the new data information can be received by the user, accuracy and timeliness of the data information received by the user are ensured, the connection times of the client and the application server are reduced, and the pressure of the application server and the database server is relieved.
In addition, the data information is synchronously stored in the memory space and the database server, so that the accuracy and timeliness of the data in the memory space are ensured.
For example, after the steps of parsing the query instruction, obtaining query condition information, and calling the queried data in the database server according to the query condition information, the method may further include:
and sending the query condition information and the queried data to the client so as to compare and query at the client and acquire service data matched with the query condition information.
In the implementation process, the application server sends the query condition information and the queried data to the client, the comparison and query operation of the query condition information and the queried data are carried out at the client, and the service data matched with the query condition information is obtained and then is directly displayed at the client of the user.
Example 2
The embodiment of the application also provides a data optimizing device, which is applied to the application server of the data optimizing method in the embodiment 1, and is shown in fig. 6 as a structural block diagram of the data optimizing device. The apparatus may specifically include, but is not limited to:
the instruction receiving module 100 is configured to receive a query instruction of a user;
the instruction analysis module 200 is used for analyzing the query instruction, obtaining query condition information, and calling queried data in the database server according to the query condition information;
the data query module 300 is configured to send the query condition information and the queried data to a memory space, so as to perform comparison and query in the memory space;
the data receiving module 400 is configured to receive service data matched with the query condition information, and return the service data to the client.
In the implementation process, related queried data in a database server are acquired according to the query condition information of a user, the comparison and query between the query condition information and the queried data are performed in a memory space, and compared with the prior process in a disk in the database server, the server node with a shortage of resources is transferred to a node with a relatively loose resource for processing, so that the connection times between an application server and the database server are reduced, the purpose of quickly responding to the user is achieved, and the problems of program deadlock and slow user request response caused by frequent interaction between the server and the database in the prior method are solved.
For example, as one embodiment, the memory space may be a temporary storage space provided in the application server, as shown in fig. 7, which is a block diagram of one of the data query modules 300. The data query module 300 includes:
a storage space allocation module 311, configured to allocate a temporary storage space as a memory space;
a data storage module 312, configured to store the query condition information and the queried data into a temporary storage space;
and the data searching module 313 is used for searching the service data matched with the query condition information in the queried data.
In the implementation process, the memory space can be a temporary storage space allocated by the application server, and the query condition information and the queried data are allocated to the temporary storage space for comparison and query, so that the connection times of the application server and the database server are reduced, and the response speed of a user is improved.
By way of example, as another embodiment, as shown in fig. 8, there is a block diagram of another data query module 300. The memory space can also be a memory server; the data query module 300 includes:
a data sending module 321, configured to store the query condition information and the queried data into a memory server;
and the service data receiving module 322 is configured to receive service data that is returned by the memory server and matches with the query condition information.
In the implementation process, the memory space can be a memory server with low configuration, and the memory server is in communication connection with the application server, so that data transmission and interaction are realized, the comparison of the query condition information and the queried data is performed in the memory server, and the request response time and response speed of a user can be greatly improved.
Further, as shown in fig. 9, a specific block diagram of a data optimization device according to an embodiment of the present application is illustrated. The apparatus may further include:
a data information receiving module 501, configured to receive new data information;
a data parsing module 502, configured to parse the data information;
and the data updating module 503 is configured to push data information to a corresponding user, and store the data information in a memory space and a database server, so as to update service data in the memory space and the database server.
In the implementation process, if the robot wants to notify the data information of the system, the data information can be acquired and analyzed in a message form and stored in the memory space and the database server, so that the accuracy and timeliness of the data in the memory space are ensured.
As an example, as shown in fig. 10, another block diagram of a data optimization processing device is provided for an embodiment of the present application. The device may further include, in addition to the instruction receiving module 100 and the instruction analyzing module 200:
and the comparison data transmission module 601 is configured to send the query condition information and the queried data to a client, so as to compare and query the client and obtain service data matched with the query condition information.
In the implementation process, the query condition information and the queried data are sent to the client of the corresponding user, the data are compared and queried at the client of the user, the comparison result is directly displayed at the client of the user, and the pressure of the application server and the database server is shared in the mode, so that the response speed to the user is improved.
Example 3
The embodiment of the application also provides an electronic device, which comprises a memory and a processor, wherein the memory is used for storing a computer program, and the processor runs the computer program to enable the computer device to execute the data optimization method in any one of the embodiment 1.
The embodiment of the present application also provides a readable storage medium having stored therein computer program instructions which, when read and executed by a processor, perform the data optimization method of any of embodiment 1.
In the several embodiments provided in the present application, it should be understood that the disclosed apparatus and method may be implemented in other manners. The apparatus embodiments described above are merely illustrative, for example, of the flowcharts and block diagrams in the figures that illustrate the architecture, functionality, and operation of possible implementations of apparatus, 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 and/or flowchart illustration, and combinations of blocks in the block diagrams and/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.
In addition, functional modules in the embodiments of the present application may be integrated together to form a single part, or each module may exist alone, or two or more modules may be integrated to form a single part.
The functions, if implemented in the form of software functional modules and sold or used as a stand-alone product, may be stored in a computer-readable storage medium. Based on this understanding, the technical solution of the present application may be embodied essentially or in a part contributing to the prior art or in a part of the technical solution, in the form of a software product stored in a storage medium, comprising several instructions for causing a computer device (which may be a personal computer, a server, 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 (RAM, random Access Memory), a magnetic disk, or an optical disk, or other various media capable of storing program codes.
The above description is only an example of the present application and is not intended to limit the scope of the present application, and various modifications and variations will be apparent to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the protection scope of the present application. It should be noted that: like reference numerals and letters denote like items in the following figures, and thus once an item is defined in one figure, no further definition or explanation thereof is necessary in the following figures.
The foregoing is merely illustrative of the present application, and the present application is not limited thereto, and any person skilled in the art will readily recognize that variations or substitutions are within the scope of the present application. Therefore, the protection scope of the present application shall be subject to the protection scope of the claims.
It is noted that relational terms such as first and second, and the like are used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Moreover, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.

Claims (6)

1. A method of data optimization, applied to an application server, the method comprising:
receiving a query instruction of a user;
analyzing the query instruction to obtain query condition information, and calling queried data in a database server according to the query condition information;
the query condition information and the queried data are sent to a memory space to be compared and queried in the memory space, wherein the memory space is a temporary storage space arranged in the application server, or the memory space is a memory server, and the memory server is in communication connection with the application server:
if the memory space is a temporary storage space arranged in the application server, the temporary storage space is allocated as the memory space;
storing the query condition information and the queried data into a temporary storage space;
searching business data matched with the query condition information in the queried data;
if the memory space is a memory server, the query condition information and the queried data are stored in the memory server;
receiving service data matched with the query condition information returned by the memory server;
and receiving service data which is fed back by the memory space and is matched with the query condition information, and returning the service data to the client.
2. The method of data optimization of claim 1, wherein the method further comprises:
receiving new data information;
analyzing the data information;
pushing the data information to corresponding users, and storing the data information in a memory space and a database server so as to update service data in the memory space and the database server.
3. The method of data optimization of claim 1, wherein the method further comprises:
and sending the query condition information and the queried data to a client to compare and query at the client and acquire service data matched with the query condition information.
4. A data optimization apparatus for application to an application server, the apparatus comprising:
the instruction receiving module is used for receiving a query instruction of a user;
the instruction analysis module is used for analyzing the query instruction, obtaining query condition information and calling queried data in the database server according to the query condition information;
the data query module is configured to send the query condition information and the queried data to a memory space to perform comparison and query in the memory space, where the memory space is a temporary storage space set in the application server, or the memory space is a memory server, and the memory server is in communication connection with the application server:
if the memory space is a temporary storage space set in the application server, the data query module includes:
the storage space allocation module is used for allocating the temporary storage space as a memory space;
the data storage module is used for storing the query condition information and the queried data into a temporary storage space;
the data searching module is used for searching the service data matched with the query condition information in the queried data;
if the memory space is a memory server, the data query module includes:
the data sending module is used for storing the query condition information and the queried data into a memory server;
the service data receiving module is used for receiving service data which is returned by the memory server and is matched with the query condition information;
and the data receiving module is used for receiving the service data matched with the query condition information and returning the service data to the client.
5. An electronic device comprising a memory for storing a computer program and a processor that runs the computer program to cause the computer device to perform the data optimization method according to any one of claims 1 to 3.
6. A readable storage medium, characterized in that the readable storage medium has stored therein computer program instructions, which when read and executed by a processor, perform the data optimization method of any one of claims 1 to 3.
CN201911316079.8A 2019-12-18 2019-12-18 Data optimization method and device Active CN111090672B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201911316079.8A CN111090672B (en) 2019-12-18 2019-12-18 Data optimization method and device

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201911316079.8A CN111090672B (en) 2019-12-18 2019-12-18 Data optimization method and device

Publications (2)

Publication Number Publication Date
CN111090672A CN111090672A (en) 2020-05-01
CN111090672B true CN111090672B (en) 2023-08-22

Family

ID=70395855

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201911316079.8A Active CN111090672B (en) 2019-12-18 2019-12-18 Data optimization method and device

Country Status (1)

Country Link
CN (1) CN111090672B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20230409575A1 (en) * 2022-06-16 2023-12-21 International Business Machines Corporation Database query processing with database clients

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107239479A (en) * 2017-03-28 2017-10-10 阿里巴巴集团控股有限公司 A kind of method and device of data storage and inquiry based on block chain
CN109145020A (en) * 2018-07-23 2019-01-04 程之琴 Information query method, from server, client and computer readable storage medium
CN109783512A (en) * 2018-12-13 2019-05-21 平安科技(深圳)有限公司 Data processing method, device, computer equipment and storage medium
CN110309334A (en) * 2018-04-20 2019-10-08 腾讯科技(深圳)有限公司 Querying method, system, computer equipment and the readable storage medium storing program for executing of chart database

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US10042885B2 (en) * 2015-10-29 2018-08-07 International Business Machines Corporation Index table based routing for query resource optimization

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107239479A (en) * 2017-03-28 2017-10-10 阿里巴巴集团控股有限公司 A kind of method and device of data storage and inquiry based on block chain
CN110309334A (en) * 2018-04-20 2019-10-08 腾讯科技(深圳)有限公司 Querying method, system, computer equipment and the readable storage medium storing program for executing of chart database
CN109145020A (en) * 2018-07-23 2019-01-04 程之琴 Information query method, from server, client and computer readable storage medium
CN109783512A (en) * 2018-12-13 2019-05-21 平安科技(深圳)有限公司 Data processing method, device, computer equipment and storage medium

Also Published As

Publication number Publication date
CN111090672A (en) 2020-05-01

Similar Documents

Publication Publication Date Title
CN110609844B (en) Data updating method, device and system
EP2304609B1 (en) Paging hierarchical data
KR20170010844A (en) Processing mutations for a remote database
CN111666326B (en) ETL scheduling method and device
US20190213275A1 (en) Scalable synchronization with cache and index management
CN109933585B (en) Data query method and data query system
CN111859132A (en) Data processing method and device, intelligent equipment and storage medium
CN107506356B (en) Data processing method and its system
CN111723161A (en) Data processing method, device and equipment
CN111858760A (en) Data processing method and device for heterogeneous database
CN111339171A (en) Data query method, device and equipment
CN112182014A (en) Database query method, device, equipment and storage medium
CN111090672B (en) Data optimization method and device
US9934068B2 (en) Data analysis system
CN110928900B (en) Multi-table data query method, device, terminal and computer storage medium
CN113377817A (en) Data processing method, system, device and storage medium
US10033737B2 (en) System and method for cross-cloud identity matching
CN111400301A (en) Data query method, device and equipment
CN110909072B (en) Data table establishment method, device and equipment
CN110765158A (en) Paging query method, system and device
KR101720316B1 (en) Method and apparatus for providing information for sensor network
CN107193891B (en) Content recommendation method and device
CN107070987B (en) Data acquisition method and system for distributed object storage system
CN112035559B (en) Thermodynamic diagram display method, server and system
CN115329005A (en) Multi-cluster cooperation method, system, device and computer readable storage medium

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
CB02 Change of applicant information

Address after: Room 201, building 4, courtyard 8, Dongbeiwang West Road, Haidian District, Beijing

Applicant after: Beijing Yunji Technology Co.,Ltd.

Address before: Room 201, building 4, courtyard 8, Dongbeiwang West Road, Haidian District, Beijing

Applicant before: BEIJING YUNJI TECHNOLOGY Co.,Ltd.

CB02 Change of applicant information
GR01 Patent grant
GR01 Patent grant