CN110888939A - A data management method and device - Google Patents
A data management method and device Download PDFInfo
- Publication number
- CN110888939A CN110888939A CN201811036754.7A CN201811036754A CN110888939A CN 110888939 A CN110888939 A CN 110888939A CN 201811036754 A CN201811036754 A CN 201811036754A CN 110888939 A CN110888939 A CN 110888939A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- memory
- query
- query request
- 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.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 55
- 238000013523 data management Methods 0.000 title claims abstract description 47
- 238000004458 analytical method Methods 0.000 claims abstract description 12
- 238000004590 computer program Methods 0.000 claims description 10
- 238000006243 chemical reaction Methods 0.000 claims description 9
- 238000012545 processing Methods 0.000 abstract description 10
- 238000000605 extraction Methods 0.000 abstract description 3
- 238000010586 diagram Methods 0.000 description 17
- 230000008569 process Effects 0.000 description 11
- 238000004891 communication Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 7
- 230000009471 action Effects 0.000 description 4
- 230000003287 optical effect Effects 0.000 description 4
- 238000012986 modification Methods 0.000 description 3
- 230000004048 modification Effects 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 239000000835 fiber Substances 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 230000007246 mechanism Effects 0.000 description 2
- 230000000644 propagated effect Effects 0.000 description 2
- 239000004065 semiconductor Substances 0.000 description 2
- 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
- 229940004975 interceptor Drugs 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
本发明公开了一种数据管理方法和装置,涉及计算机技术领域。该方法的一具体实施方式包括:对数据库中目标数据表进行全字段解析,确定该目标数据表的表头字段;根据该表头字段在内存中创建实体对象,并在该目标数据表中进行全量数据查询以得到全量数据;将该全量数据存储至该实体对象中,以实现将数据库中的数据提取至内存中。该实施方式将数据库中的数据提取到内存后,能够提高内存的利用率;此外,由于内存中的数据是透明的,不需要额外加工处理数据库查询请求即可获取到内存中的数据,且只需要一次查询,近乎应用闭环,因此能够进一步提高查询效率。
The invention discloses a data management method and device, and relates to the technical field of computers. A specific implementation of the method includes: performing full field analysis on the target data table in the database, and determining the header field of the target data table; creating an entity object in the memory according to the header field, and performing the analysis in the target data table. The full amount of data is queried to obtain the full amount of data; the full amount of data is stored in the entity object, so as to realize the extraction of the data in the database into the memory. After the data in the database is extracted into the memory in this implementation manner, the utilization rate of the memory can be improved; in addition, since the data in the memory is transparent, the data in the memory can be obtained without additional processing of database query requests, and only the data in the memory can be obtained. A query is required, which is close to a closed loop, so the query efficiency can be further improved.
Description
技术领域technical field
本发明涉及计算机技术领域,尤其涉及一种数据管理方法和装置。The present invention relates to the field of computer technology, and in particular, to a data management method and device.
背景技术Background technique
当前针对关系型数据表中数据的读取方案有很多,比如:1、直接查询;2、查询后进行缓存及多级缓存等等。At present, there are many reading schemes for data in relational data tables, such as: 1. Direct query; 2. Cache and multi-level cache after query.
在实现本发明过程中,发明人发现现有技术中至少存在如下问题:In the process of realizing the present invention, the inventor found that there are at least the following problems in the prior art:
1、直接查询:没有用内存来大量的存储关系型数据,内存的利用率低;当待查询的数据量较大时,需要多次查询数据库,查询效率低;1. Direct query: no memory is used to store a large amount of relational data, and the utilization rate of memory is low; when the amount of data to be queried is large, the database needs to be queried many times, and the query efficiency is low;
2、查询后进行缓存及多级缓存:从缓存中查询数据在一定程度上能够提高查询效率,但是查询数据时需要根据不同的业务需求对关系型数据进行加工,再定制化的编码查询语句来完成对缓存中关系型数据的查询,查询效率依然不高。2. Cache and multi-level cache after query: Querying data from the cache can improve query efficiency to a certain extent, but when querying data, it is necessary to process relational data according to different business requirements, and then customize the encoded query statement to After completing the query of relational data in the cache, the query efficiency is still not high.
发明内容SUMMARY OF THE INVENTION
有鉴于此,本发明实施例提供一种数据管理方法和装置,将数据库中的数据提取到内存后,能够提高内存的利用率;此外,由于内存中的数据是透明的,不需要额外加工处理数据库查询请求即可获取到内存中的数据,且只需要一次查询,近乎应用闭环,因此能够进一步提高查询效率。In view of this, the embodiments of the present invention provide a data management method and device, which can improve the utilization rate of the memory after the data in the database is extracted into the memory; in addition, since the data in the memory is transparent, no additional processing is required The data in the memory can be obtained by the database query request, and only one query is required, which is close to the application closed loop, so the query efficiency can be further improved.
为实现上述目的的一个或多个,根据本发明实施例的一个方面,提供了一种数据管理方法。To achieve one or more of the above objects, according to an aspect of the embodiments of the present invention, a data management method is provided.
根据本发明实施例的数据管理方法包括:The data management method according to the embodiment of the present invention includes:
对数据库中目标数据表进行全字段解析,确定该目标数据表的表头字段;Perform full field analysis on the target data table in the database to determine the header field of the target data table;
根据该表头字段在内存中创建实体对象,并在该目标数据表中进行全量数据查询以得到全量数据;Create an entity object in memory according to the header field, and perform full data query in the target data table to obtain full data;
将该全量数据存储至该实体对象中,以实现将数据库中的数据提取至内存中。The full amount of data is stored in the entity object, so as to extract the data in the database into the memory.
可选地,在应用程序初始化时获取用户配置信息,根据该用户配置信息确定目标数据表;其中,该用户配置信息包括:数据库域名或IP地址,数据库名,表名。Optionally, user configuration information is obtained when the application is initialized, and the target data table is determined according to the user configuration information; wherein, the user configuration information includes: database domain name or IP address, database name, and table name.
可选地,本发明实施例的数据管理方法还包括:按照如下步骤查询内存中的数据:Optionally, the data management method according to the embodiment of the present invention further includes: querying data in the memory according to the following steps:
拦截针对数据库中目标数据表进行查询的数据库查询请求;Intercept database query requests for querying target data tables in the database;
从该数据库查询请求中解析查询条件,根据该查询条件将该数据库查询请求转换成对应内存的内存查询请求;Parse the query condition from the database query request, and convert the database query request into a memory query request corresponding to the memory according to the query condition;
根据该内存查询请求在内存中进行数据查询。Data query is performed in memory according to the memory query request.
可选地,本发明实施例的数据管理方法还包括:预设每个目标数据表的关键字段;当查询请求中含有该关键字段时,判定该查询请求是针对该目标表的数据库查询请求。Optionally, the data management method of the embodiment of the present invention further includes: presetting a key field of each target data table; when the query request contains the key field, determining that the query request is a database query for the target table ask.
根据本发明实施例的再一个方面,提供了一种数据管理装置。According to yet another aspect of the embodiments of the present invention, a data management apparatus is provided.
根据本发明实施例的数据管理装置包括:A data management apparatus according to an embodiment of the present invention includes:
解析模块,对数据库中目标数据表进行全字段解析,确定该目标数据表的表头字段;根据该表头字段在所述目标数据表中进行全量数据查询以得到全量数据;The parsing module performs full field analysis on the target data table in the database, and determines the header field of the target data table; performs full data query in the target data table according to the header field to obtain full data;
创建模块,根据该表头字段在内存中创建实体对象;Create a module and create an entity object in memory based on the header field;
存储模块,将该全量数据存储至该实体对象中,以实现将数据库中的数据提取至内存中。The storage module stores the full amount of data in the entity object, so as to extract the data in the database into the memory.
可选地,解析模块还用于:在应用程序初始化时获取用户配置信息,根据该用户配置信息确定所述目标数据表;其中,该用户配置信息包括:数据库域名或IP地址,数据库名,表名。Optionally, the parsing module is also used to: obtain user configuration information when the application is initialized, and determine the target data table according to the user configuration information; wherein, the user configuration information includes: database domain name or IP address, database name, table name.
可选地,本发明实施例的数据管理装置还包括:Optionally, the data management apparatus in the embodiment of the present invention further includes:
拦截模块,拦截针对数据库中目标数据表进行查询的数据库查询请求;The interception module intercepts the database query request for querying the target data table in the database;
转换模块,从该数据库查询请求中解析查询条件,根据该查询条件将该数据库查询请求转换成对应内存的内存查询请求;The conversion module parses the query condition from the database query request, and converts the database query request into a memory query request corresponding to the memory according to the query condition;
查询模块,根据该内存查询请求在内存中进行数据查询。The query module performs data query in the memory according to the memory query request.
可选地,拦截模块还用于:预设每个目标数据表的关键字段;当查询请求中含有该关键字段时,判定该查询请求是针对该目标表的数据库查询请求。Optionally, the interception module is further configured to: preset a key field of each target data table; when the query request contains the key field, determine that the query request is a database query request for the target table.
根据本发明实施例的另一个方面,提供了一种数据管理电子设备。According to another aspect of the embodiments of the present invention, a data management electronic device is provided.
根据本发明实施例的数据管理电子设备包括:The data management electronic device according to the embodiment of the present invention includes:
一个或多个处理器;one or more processors;
存储装置,用于存储一个或多个程序,storage means for storing one or more programs,
当该一个或多个程序被该一个或多个处理器执行,使得该一个或多个处理器实现本发明实施例第一方面提供的数据管理方法。When the one or more programs are executed by the one or more processors, the one or more processors implement the data management method provided by the first aspect of the embodiments of the present invention.
根据本发明实施例的另一个方面,提供了一种计算机可读介质。According to another aspect of the embodiments of the present invention, a computer-readable medium is provided.
根据本发明实施例的计算机可读介质,其上存储有计算机程序,该程序被处理器执行时实现本发明实施例第一方面提供的数据管理方法。A computer-readable medium according to an embodiment of the present invention stores a computer program thereon, and when the program is executed by a processor, implements the data management method provided by the first aspect of the embodiment of the present invention.
上述发明中的一个实施例具有如下优点或有益效果:根据数据库中目标数据表的表头字段在内存中创建实体对象,然后将目标数据表的全量数据存储至实体对象中,能够实现数据库中的数据提取至内存中,提高了内存的利用率。由于内存中存储了目标数据表中的全量数据,无需从数据库查询数据,因此能够大大提高查询效率。拦截针对数据库中目标数据表进行查询的数据库查询请求,根据解析出的查询条件将数据库查询请求转换成对应内存的内存查询请求,使得内存中的数据是透明的,不需要额外加工处理数据库查询请求即可获取到内存中的数据,且只需要一次查询,近乎应用闭环,因此能够进一步提高查询效率。An embodiment of the above invention has the following advantages or beneficial effects: creating an entity object in the memory according to the header field of the target data table in the database, and then storing the full data of the target data table in the entity object, which can realize the The data is extracted to the memory, which improves the utilization of the memory. Since the full amount of data in the target data table is stored in the memory, there is no need to query the data from the database, so the query efficiency can be greatly improved. Intercept the database query request for querying the target data table in the database, and convert the database query request into a memory query request corresponding to the memory according to the parsed query conditions, so that the data in the memory is transparent, and no additional processing of the database query request is required. The data in the memory can be obtained, and only one query is required, which is close to the application closed loop, so the query efficiency can be further improved.
上述的非惯用的可选方式所具有的进一步效果将在下文中结合具体实施方式加以说明。Further effects of the above non-conventional alternatives will be described below in conjunction with specific embodiments.
附图说明Description of drawings
附图用于更好地理解本发明,不构成对本发明的不当限定。其中:The accompanying drawings are used for better understanding of the present invention and do not constitute an improper limitation of the present invention. in:
图1是根据本发明实施例的数据管理方法的主要流程的示意图;1 is a schematic diagram of the main flow of a data management method according to an embodiment of the present invention;
图2是根据本发明一些实施例的数据管理方法的主要流程的示意图;2 is a schematic diagram of the main flow of a data management method according to some embodiments of the present invention;
图3是根据本发明再一些实施例的数据管理方法的主要流程的示意图;3 is a schematic diagram of a main flow of a data management method according to further embodiments of the present invention;
图4是根据本发明还一些实施例的数据管理方法的主要流程的示意图;4 is a schematic diagram of the main flow of a data management method according to still some embodiments of the present invention;
图5是根据本发明实施例的数据管理装置的主要模块的示意图;5 is a schematic diagram of main modules of a data management apparatus according to an embodiment of the present invention;
图6是本发明实施例可以应用于其中的示例性系统架构图;FIG. 6 is an exemplary system architecture diagram to which an embodiment of the present invention may be applied;
图7是适于用来实现本发明实施例的终端设备或服务器的计算机系统的结构示意图。FIG. 7 is a schematic structural diagram of a computer system suitable for implementing a terminal device or a server according to an embodiment of the present invention.
具体实施方式Detailed ways
以下结合附图对本发明的示范性实施例做出说明,其中包括本发明实施例的各种细节以助于理解,应当将它们认为仅仅是示范性的。因此,本领域普通技术人员应当认识到,可以对这里描述的实施例做出各种改变和修改,而不会背离本发明的范围和精神。同样,为了清楚和简明,以下的描述中省略了对公知功能和结构的描述。Exemplary embodiments of the present invention are described below with reference to the accompanying drawings, which include various details of the embodiments of the present invention to facilitate understanding and should be considered as exemplary only. 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 from the following description for clarity and conciseness.
以下对本发明中提及的部分技术名词进行解释:Some technical terms mentioned in the present invention are explained below:
关系型数据:是建立在关系模型基础上的数据库,借助于集合代数等数学概念和方法来处理数据库中的数据。Relational data: It is a database based on the relational model, and the data in the database is processed by means of mathematical concepts and methods such as set algebra.
只读:只有查询操作,而没有更新或删除操作。Read-only: only query operations, not update or delete operations.
内存:内存是计算机中重要的部件之一,它是与CPU进行沟通的桥梁。Memory: Memory is one of the important components in the computer, it is the bridge to communicate with the CPU.
拦截器:提供了一种机制可以使开发者可以定义在一个操作(action)执行的前后执行的代码,也可以在一个action执行前阻止其执行,同时也提供了一种可以提取action中可重用部分的方式。在AOP(Aspect-Oriented Programming)中拦截器用于在某个方法或字段被访问之前,进行拦截然后在之前或之后加入某些操作。Interceptor: Provides a mechanism that allows developers to define code that is executed before and after an action is executed, and can also prevent an action from executing before it is executed. It also provides a mechanism that can be reused in extraction actions part of the way. In AOP (Aspect-Oriented Programming), interceptors are used to intercept a method or field before it is accessed, and then add certain operations before or after it.
根据本发明实施例的一个方面,提供了一种数据管理方法。According to an aspect of the embodiments of the present invention, a data management method is provided.
图1是根据本发明实施例的数据管理方法的主要流程的示意图,如图1所示,根据本发明实施例的数据管理方法包括:步骤S101、步骤S102和步骤S103。FIG. 1 is a schematic diagram of a main flow of a data management method according to an embodiment of the present invention. As shown in FIG. 1 , the data management method according to an embodiment of the present invention includes step S101 , step S102 and step S103 .
步骤S101、对数据库中目标数据表进行全字段解析,确定该目标数据表的表头字段。Step S101 , perform full field analysis on the target data table in the database, and determine the header field of the target data table.
实际应用过程中,采用本发明实施例的数据管理方法的工具可以对接入本工具的用户提供自定义配置服务,用户可以通过该服务完成各个目标数据表的指定。接入本工具的应用程序可以在其初始化时触发本工具的全字段解析服务,通过读取用户自定义配置中的数据确认需要解析哪些目标数据表。In the actual application process, the tool using the data management method of the embodiment of the present invention can provide a user-defined configuration service to the user accessing the tool, and the user can complete the designation of each target data table through the service. The application program connected to this tool can trigger the full field parsing service of this tool when it is initialized, and confirm which target data tables need to be parsed by reading the data in the user-defined configuration.
可选地,在应用程序初始化时获取用户配置信息,根据该用户配置信息确定目标数据表;其中,该用户配置信息包括:数据库域名或IP地址,数据库名,表名。Optionally, user configuration information is obtained when the application is initialized, and the target data table is determined according to the user configuration information; wherein, the user configuration information includes: database domain name or IP address, database name, and table name.
假设有如下只读关系型报价数据表,所在数据库域名为:mysql.storage.com,数据库名为:quote_db,表名为:storage_quote。用户自定义配置中需要指定表的具体信息,则配置信息应为:mysql,storage,com/quote_db?table_name=storage_quote。如此便指定数据表storage_quote为目标数据表。Suppose there is the following read-only relational quotation data table, where the database domain name is: mysql.storage.com, the database name is: quote_db, and the table name is: storage_quote. User-defined configuration needs to specify the specific information of the table, the configuration information should be: mysql,storage,com/quote_db? table_name=storage_quote. In this way, the data table storage_quote is specified as the target data table.
表1只读关系型报价数据表Table 1 Read-only relational quotation data table
对表1中的目标数据表进行全字段解析,解析目标数据表的结构,即读取目标数据表的表头信息得到以下各个字段:id,quote_code,quote_name,service_code,service_name。Perform full field analysis on the target data table in Table 1, and analyze the structure of the target data table, that is, read the header information of the target data table to obtain the following fields: id, quote_code, quote_name, service_code, service_name.
步骤S102、根据该表头字段在内存中创建实体对象,并在该目标数据表中进行全量数据查询以得到全量数据。Step S102 , creating an entity object in the memory according to the header field, and querying the full amount of data in the target data table to obtain the full amount of data.
以表1对应的实施例为例,则可以以目标数据表名storage_quote作为实体对象的名称,在内存中创建实体:storage_quote。其次进行全量数据查询。全量数据是指目标数据表中的所有数据。Taking the embodiment corresponding to Table 1 as an example, the name of the target data table storage_quote may be used as the name of the entity object, and an entity: storage_quote may be created in the memory. Next, perform full data query. Full data refers to all data in the target data table.
步骤S103、将该全量数据存储至该实体对象中,以实现将数据库中的数据提取至内存中。Step S103: Store the full amount of data in the entity object, so as to extract the data in the database into the memory.
以表1对应的实施例为例,内存中存储的具体信息如下:Taking the embodiment corresponding to Table 1 as an example, the specific information stored in the memory is as follows:
现有技术中当需要关系型数据时,需要编码查询关系型数据库以便获取到关系型数据,这种获取关系型数据主要的方案还是实时在关系型数据库中获取,没有用内存来大量的存储关系型数据,内存的利用率低。In the prior art, when relational data is required, it is necessary to code and query the relational database in order to obtain the relational data. The main solution for obtaining relational data is to obtain it in the relational database in real time, instead of using memory to store a large number of relationships. type data, the utilization of memory is low.
本发明根据数据库中目标数据表的表头字段在内存中创建实体对象,然后将目标数据表的全量数据存储至实体对象中,能够实现数据库中的数据提取至内存中,提高了内存的利用率。由于内存中存储了目标数据表中的全量数据,无需从数据库查询数据,因此能够大大提高查询效率。此外,由于是对目标数据表进行全量读取,所以理论上不存在回源(即,在内存中没有获取到数据,那么再继续去数据库中查询、提取)的情况。The invention creates an entity object in the memory according to the header field of the target data table in the database, and then stores the full data of the target data table in the entity object, so that the data in the database can be extracted into the memory, and the utilization rate of the memory is improved. . Since the full amount of data in the target data table is stored in the memory, there is no need to query the data from the database, so the query efficiency can be greatly improved. In addition, since the target data table is read in full, theoretically, there is no return to the source (that is, if no data is obtained in the memory, then continue to query and extract from the database).
需要说明的是,本发明实施例的方法适用于各种类型的数据,例如关系型数据或者菲关系型数据,再例如只读型数据或者其他非只读型数据。It should be noted that the method in the embodiment of the present invention is applicable to various types of data, such as relational data or relational data, and read-only data or other non-read-only data.
图2是根据本发明一些实施例的数据管理方法的主要流程的示意图。如图2所示,数据管理方法的主要流程包括:FIG. 2 is a schematic diagram of the main flow of a data management method according to some embodiments of the present invention. As shown in Figure 2, the main flow of the data management method includes:
首先对接入本工具的用户提供自定义配置服务,用户可以通过该服务完成需要目标数据表的指定;First, provide a custom configuration service for users who access this tool, and users can complete the designation of the required target data table through this service;
接入本工具的应用系统初始化时,读取自定义配置服务中的数据,以确认哪些是需要解析的目标数据表;When the application system connected to this tool is initialized, read the data in the custom configuration service to confirm which target data tables need to be parsed;
若自定义配置服务中不存在配置,则表明没有需要解析的目标数据表,流程结束;If there is no configuration in the custom configuration service, it means that there is no target data table to be parsed, and the process ends;
否则,初始化关系型数据全字段解析服务;根据用户自定义配置对目标表进行解析,生成内存数据结构,并查询目标数据表中全量数据;触发内存读取/存储服务,将全量数据存储到内存中;至此,应用系统初始化完成,流程结束。Otherwise, initialize the relational data full field parsing service; parse the target table according to the user-defined configuration, generate an in-memory data structure, and query the full amount of data in the target data table; trigger the memory read/storage service to store the full amount of data in memory ; at this point, the initialization of the application system is completed, and the process ends.
可选地,本发明实施例的数据管理方法还包括:按照如下步骤查询内存中的数据:拦截针对数据库中目标数据表进行查询的数据库查询请求;从该数据库查询请求中解析查询条件,根据该查询条件将该数据库查询请求转换成对应内存的内存查询请求;根据该内存查询请求在内存中进行数据查询。Optionally, the data management method according to the embodiment of the present invention further includes: querying data in memory according to the following steps: intercepting a database query request for querying a target data table in a database; parsing query conditions from the database query request, according to the The query condition converts the database query request into a memory query request corresponding to the memory; and performs data query in the memory according to the memory query request.
现有技术中将关系型数据存储到内存中后,需要根据不同的业务需求对关系型数据进行加工,再定制化的编码,以完成对内存中关系型数据的查询,查询效率低。After the relational data is stored in the memory in the prior art, the relational data needs to be processed according to different business requirements, and then customized coding is required to complete the query of the relational data in the memory, and the query efficiency is low.
本发明拦截针对数据库中目标数据表进行查询的数据库查询请求,根据解析出的查询条件将数据库查询请求转换成对应内存的内存查询请求,使得内存中的数据是透明的,不需要额外加工处理数据库查询请求即可获取到内存中的数据,且只需要一次查询,近乎应用闭环,因此能够进一步提高查询效率。The invention intercepts the database query request for querying the target data table in the database, and converts the database query request into a memory query request corresponding to the memory according to the parsed query conditions, so that the data in the memory is transparent, and no additional processing of the database is required. The data in memory can be obtained by query request, and only one query is required, which is close to the application closed loop, so the query efficiency can be further improved.
可选地,本发明实施例的数据管理方法还包括:预设每个目标数据表的关键字段;当查询请求中含有该关键字段时,判定该查询请求是针对该目标表的数据库查询请求。Optionally, the data management method of the embodiment of the present invention further includes: presetting a key field of each target data table; when the query request contains the key field, determining that the query request is a database query for the target table ask.
以表1示出的实施例为例,当拦截到关键字select&&storage_quote(select&&storage_quote是预设的关键字,表明针对目标数据表的查询操作)时,即查询请求中含有关键字select&&storage_quote,判定当前的查询请求时针对目标数据表的数据库查询请求。根据该查询条件执行将该数据库查询请求转换成对应内存的内存查询请求的命令转换操作时,具体转换操作如下:Taking the embodiment shown in Table 1 as an example, when the keyword select&&storage_quote is intercepted (select&&storage_quote is a preset keyword, indicating a query operation for the target data table), that is, the query request contains the keyword select&&storage_quote, and the current query is determined. The database query request against the target data table when requested. When executing the command conversion operation of converting the database query request into a memory query request corresponding to the memory according to the query condition, the specific conversion operation is as follows:
例1:用户期望执行命令(即数据库查询请求):select*fro mstorage_quotewhere id=1;Example 1: The user expects to execute the command (ie database query request): select*from mstorage_quotewhere id=1;
则转换为:storage_quote_set.foreach(if(storage_quote::getId()==1)return storage_quote;));即在仓储报价集合中匹配id等于1的数据。Then it is converted to: storage_quote_set.foreach(if(storage_quote::getId()==1)return storage_quote;)); that is, match the data whose id is equal to 1 in the storage quotation set.
例2:用户期望执行命令:select*from storage_quote where quote_code=’GLOABL001’and service_code=’storage01’;Example 2: The user expects to execute the command: select*from storage_quote where quote_code='GLOABL001'and service_code='storage01';
则转换为:storage_quote_set.foreach(storage_quote::getQuote_code().equals(“GLOABL001”)&&getService_code.equals(“storage01”)){return storage_quote;});即在仓储报价集合中匹配quote_code等于“GLOABL001”并且service_code等于“storage01”的数据。Then it is converted to: storage_quote_set.foreach(storage_quote::getQuote_code().equals("GLOABL001")&&getService_code.equals("storage01")){return storage_quote;}); that is, match quote_code equal to "GLOABL001" in the storage quote set and service_code is equal to the data of "storage01".
图3是根据本发明再一些实施例的数据管理方法的主要流程的示意图。如图3所示,数据管理方法的主要流程包括:FIG. 3 is a schematic diagram of a main flow of a data management method according to further embodiments of the present invention. As shown in Figure 3, the main flow of the data management method includes:
首先采用本发明实施例的方法将数据库中目标数据表中的全量数据提取至内存中,具体的提取方法参见图2所示的实施例或者步骤S101至步骤S103,此处不再赘述;First, the method in the embodiment of the present invention is used to extract the full amount of data in the target data table in the database into the memory. For the specific extraction method, refer to the embodiment shown in FIG. 2 or steps S101 to S103, which will not be repeated here;
接收到查询命令(即查询请求);Receive a query command (ie, query request);
查询命令拦截器(拦截器用于拦截针对数据库中目标数据表进行查询的数据库查询请求)进行拦截;Query command interceptor (the interceptor is used to intercept the database query request for querying the target data table in the database) to intercept;
读取自定义配置服务中的数据;Read the data in the custom configuration service;
若当前的查询命令不需要拦截,即当前的查询命令不是针对数据库中目标数据表进行查询的,则流程结束;If the current query command does not need to be intercepted, that is, the current query command does not query the target data table in the database, the process ends;
否则,调用查询命令转换服务将该数据库查询请求转换成对应内存的内存查询请求;查询命令转换服务将转换结果(即内存查询请求)传递到内存数据读取/存储服务;内存数据读取/存储服务执行内存数据读取命令(即内存查询请求)并返回结果,至此,流程结束。Otherwise, call the query command conversion service to convert the database query request into a memory query request corresponding to the memory; the query command conversion service transmits the conversion result (that is, the memory query request) to the memory data read/storage service; memory data read/storage The service executes the memory data read command (that is, the memory query request) and returns the result. At this point, the process ends.
图4是根据本发明还一些实施例的数据管理方法的主要流程的示意图。如图4所示,数据管理方法的主要流程包括:FIG. 4 is a schematic diagram of a main flow of a data management method according to further embodiments of the present invention. As shown in Figure 4, the main flow of the data management method includes:
首先对接入本工具的用户提供自定义配置服务,用户可以通过该服务完成需要目标数据表的指定;First, provide a custom configuration service for users who access this tool, and users can complete the designation of the required target data table through this service;
接入本工具的应用系统初始化时,读取自定义配置服务中的数据,以确认哪些是需要解析的目标数据表;When the application system connected to this tool is initialized, read the data in the custom configuration service to confirm which target data tables need to be parsed;
应用系统初始化时,调用关系型数据表全字段解析服务将目标数据表中的全量数据提取至内存中,具体步骤可以参见图2所示实施例的流程,此处不再赘述;When the application system is initialized, the full field analysis service of the relational data table is invoked to extract the full amount of data in the target data table into the memory. For specific steps, refer to the flow of the embodiment shown in FIG. 2 , which will not be repeated here;
接收到查询命令(即查询请求)时,调用命令拦截器(拦截器用于拦截针对数据库中目标数据表进行查询的数据库查询请求)进行拦截;若当前的查询命令需要拦截,即当前的查询命令是针对数据库中目标数据表进行查询的,则调用查询命令转换服务将该数据库查询请求转换成对应内存的内存查询请求;然后调用内存数据读取/存储服务执行内存数据读取命令(即内存查询请求)并返回结果,至此,流程结束。When a query command (ie, query request) is received, the command interceptor (the interceptor is used to intercept the database query request for querying the target data table in the database) is called to intercept; if the current query command needs to be intercepted, that is, the current query command is For querying the target data table in the database, the query command conversion service is called to convert the database query request into a memory query request corresponding to the memory; then the memory data read/storage service is called to execute the memory data read command (that is, the memory query request). ) and return the result, at this point, the process ends.
根据本发明实施例的再一个方面,提供了一种数据管理装置。According to yet another aspect of the embodiments of the present invention, a data management apparatus is provided.
图5是根据本发明实施例的数据管理装置的主要模块的示意图,如图5所示,根据本发明实施例的数据管理装置500包括:FIG. 5 is a schematic diagram of main modules of a data management apparatus according to an embodiment of the present invention. As shown in FIG. 5 , a
解析模块501,对数据库中目标数据表进行全字段解析,确定该目标数据表的表头字段;根据该表头字段在所述目标数据表中进行全量数据查询以得到全量数据;The
创建模块502,根据该表头字段在内存中创建实体对象;The creating
存储模块503,将该全量数据存储至该实体对象中,以实现将数据库中的数据提取至内存中。The
可选地,解析模块还用于:在应用程序初始化时获取用户配置信息,根据该用户配置信息确定所述目标数据表;其中,该用户配置信息包括:数据库域名或IP地址,数据库名,表名。Optionally, the parsing module is also used to: obtain user configuration information when the application is initialized, and determine the target data table according to the user configuration information; wherein, the user configuration information includes: database domain name or IP address, database name, table name.
可选地,本发明实施例的数据管理装置还包括:Optionally, the data management apparatus in the embodiment of the present invention further includes:
拦截模块(图中未示出),拦截针对数据库中目标数据表进行查询的数据库查询请求;The interception module (not shown in the figure) intercepts the database query request for querying the target data table in the database;
转换模块(图中未示出),从该数据库查询请求中解析查询条件,根据该查询条件将该数据库查询请求转换成对应内存的内存查询请求;a conversion module (not shown in the figure), which parses the query condition from the database query request, and converts the database query request into a memory query request corresponding to the memory according to the query condition;
查询模块(图中未示出),根据该内存查询请求在内存中进行数据查询。The query module (not shown in the figure) performs data query in the memory according to the memory query request.
可选地,拦截模块还用于:预设每个目标数据表的关键字段;当查询请求中含有该关键字段时,判定该查询请求是针对该目标表的数据库查询请求。Optionally, the interception module is further configured to: preset a key field of each target data table; when the query request contains the key field, determine that the query request is a database query request for the target table.
根据本发明实施例的另一个方面,提供了一种数据管理电子设备。According to another aspect of the embodiments of the present invention, a data management electronic device is provided.
根据本发明实施例的数据管理电子设备包括:The data management electronic device according to the embodiment of the present invention includes:
一个或多个处理器;one or more processors;
存储装置,用于存储一个或多个程序,storage means for storing one or more programs,
当该一个或多个程序被该一个或多个处理器执行,使得该一个或多个处理器实现本发明实施例第一方面提供的数据管理方法。When the one or more programs are executed by the one or more processors, the one or more processors implement the data management method provided by the first aspect of the embodiments of the present invention.
根据本发明实施例的另一个方面,提供了一种计算机可读介质。According to another aspect of the embodiments of the present invention, a computer-readable medium is provided.
根据本发明实施例的计算机可读介质,其上存储有计算机程序,该程序被处理器执行时实现本发明实施例第一方面提供的数据管理方法。A computer-readable medium according to an embodiment of the present invention stores a computer program thereon, and when the program is executed by a processor, implements the data management method provided by the first aspect of the embodiment of the present invention.
上述发明中的一个实施例具有如下优点或有益效果:根据数据库中目标数据表的表头字段在内存中创建实体对象,然后将目标数据表的全量数据存储至实体对象中,能够实现数据库中的数据提取至内存中,提高了内存的利用率。由于内存中存储了目标数据表中的全量数据,无需从数据库查询数据,因此能够大大提高查询效率。拦截针对数据库中目标数据表进行查询的数据库查询请求,根据解析出的查询条件将数据库查询请求转换成对应内存的内存查询请求,使得内存中的数据是透明的,不需要额外加工处理数据库查询请求即可获取到内存中的数据,且只需要一次查询,近乎应用闭环,因此能够进一步提高查询效率。An embodiment of the above invention has the following advantages or beneficial effects: creating an entity object in the memory according to the header field of the target data table in the database, and then storing the full data of the target data table in the entity object, which can realize the The data is extracted to the memory, which improves the utilization of the memory. Since the full amount of data in the target data table is stored in the memory, there is no need to query the data from the database, so the query efficiency can be greatly improved. Intercept the database query request for querying the target data table in the database, and convert the database query request into a memory query request corresponding to the memory according to the parsed query conditions, so that the data in the memory is transparent, and no additional processing of the database query request is required. The data in the memory can be obtained, and only one query is required, which is close to the application closed loop, so the query efficiency can be further improved.
图6示出了可以应用本发明实施例的数据管理方法或数据管理装置的示例性系统架构600。FIG. 6 shows an
如图6所示,系统架构600可以包括终端设备601、602、603,网络604和服务器605。网络604用以在终端设备601、602、603和服务器605之间提供通信链路的介质。网络604可以包括各种连接类型,例如有线、无线通信链路或者光纤电缆等等。As shown in FIG. 6 , the
用户可以使用终端设备601、602、603通过网络604与服务器605交互,以接收或发送消息等。终端设备601、602、603上可以安装有各种通讯客户端应用,例如购物类应用、网页浏览器应用、搜索类应用、即时通信工具、邮箱客户端、社交平台软件等(仅为示例)。The user can use the
终端设备601、602、603可以是具有显示屏并且支持网页浏览的各种电子设备,包括但不限于智能手机、平板电脑、膝上型便携计算机和台式计算机等等。The
服务器605可以是提供各种服务的服务器,例如对用户利用终端设备601、602、603所浏览的购物类网站提供支持的后台管理服务器(仅为示例)。后台管理服务器可以对接收到的产品信息查询请求等数据进行分析等处理,并将处理结果(例如目标推送信息、产品信息--仅为示例)反馈给终端设备。The
需要说明的是,本发明实施例所提供的数据管理方法一般由服务器605执行,相应地,数据管理装置一般设置于服务器605中。It should be noted that the data management method provided by the embodiment of the present invention is generally executed by the
应该理解,图6中的终端设备、网络和服务器的数目仅仅是示意性的。根据实现需要,可以具有任意数目的终端设备、网络和服务器。It should be understood that the numbers of terminal devices, networks and servers in FIG. 6 are merely illustrative. There can be any number of terminal devices, networks and servers according to implementation needs.
下面参考图7,其示出了适于用来实现本发明实施例的终端设备的计算机系统700的结构示意图。图7示出的终端设备仅仅是一个示例,不应对本发明实施例的功能和使用范围带来任何限制。Referring next to FIG. 7 , it shows a schematic structural diagram of a
如图7所示,计算机系统700包括中央处理单元(CPU)701,其可以根据存储在只读存储器(ROM)702中的程序或者从存储部分708加载到随机访问存储器(RAM)703中的程序而执行各种适当的动作和处理。在RAM 703中,还存储有系统700操作所需的各种程序和数据。CPU 701、ROM 702以及RAM 703通过总线704彼此相连。输入/输出(I/O)接口705也连接至总线704。As shown in FIG. 7, a
以下部件连接至I/O接口705:包括键盘、鼠标等的输入部分706;包括诸如阴极射线管(CRT)、液晶显示器(LCD)等以及扬声器等的输出部分707;包括硬盘等的存储部分708;以及包括诸如LAN卡、调制解调器等的网络接口卡的通信部分709。通信部分709经由诸如因特网的网络执行通信处理。驱动器710也根据需要连接至I/O接口705。可拆卸介质711,诸如磁盘、光盘、磁光盘、半导体存储器等等,根据需要安装在驱动器710上,以便于从其上读出的计算机程序根据需要被安装入存储部分708。The following components are connected to the I/O interface 705: an
特别地,根据本发明公开的实施例,上文参考流程图描述的过程可以被实现为计算机软件程序。例如,本发明公开的实施例包括一种计算机程序产品,其包括承载在计算机可读介质上的计算机程序,该计算机程序包含用于执行流程图所示的方法的程序代码。在这样的实施例中,该计算机程序可以通过通信部分709从网络上被下载和安装,和/或从可拆卸介质711被安装。在该计算机程序被中央处理单元(CPU)701执行时,执行本发明的系统中限定的上述功能。In particular, the processes described above with reference to the flowcharts may be implemented as computer software programs in accordance with the disclosed embodiments of the present invention. For example, embodiments disclosed herein include a computer program product comprising a computer program carried on a computer-readable medium, the computer program containing program code for performing the method illustrated in the flowchart. In such an embodiment, the computer program may be downloaded and installed from the network via the communication portion 709 and/or installed from the
需要说明的是,本发明所示的计算机可读介质可以是计算机可读信号介质或者计算机可读存储介质或者是上述两者的任意组合。计算机可读存储介质例如可以是——但不限于——电、磁、光、电磁、红外线、或半导体的系统、装置或器件,或者任意以上的组合。计算机可读存储介质的更具体的例子可以包括但不限于:具有一个或多个导线的电连接、便携式计算机磁盘、硬盘、随机访问存储器(RAM)、只读存储器(ROM)、可擦式可编程只读存储器(EPROM或闪存)、光纤、便携式紧凑磁盘只读存储器(CD-ROM)、光存储器件、磁存储器件、或者上述的任意合适的组合。在本发明中,计算机可读存储介质可以是任何包含或存储程序的有形介质,该程序可以被指令执行系统、装置或者器件使用或者与其结合使用。而在本发明中,计算机可读的信号介质可以包括在基带中或者作为载波一部分传播的数据信号,其中承载了计算机可读的程序代码。这种传播的数据信号可以采用多种形式,包括但不限于电磁信号、光信号或上述的任意合适的组合。计算机可读的信号介质还可以是计算机可读存储介质以外的任何计算机可读介质,该计算机可读介质可以发送、传播或者传输用于由指令执行系统、装置或者器件使用或者与其结合使用的程序。计算机可读介质上包含的程序代码可以用任何适当的介质传输,包括但不限于:无线、电线、光缆、RF等等,或者上述的任意合适的组合。It should be noted that 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 above two. The computer-readable storage medium can be, for example, but not limited to, an electrical, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus or device, or a combination of any of the above. More specific examples of computer readable storage media may include, but are not limited to, electrical connections with one or more wires, portable computer disks, hard disks, random access memory (RAM), read only memory (ROM), erasable Programmable read only memory (EPROM or flash memory), fiber optics, portable compact disk read only memory (CD-ROM), optical storage devices, magnetic storage devices, or any suitable combination of the foregoing. In the present invention, a computer-readable storage medium may be any tangible medium that contains or stores a program that can be used by or in conjunction with an instruction execution system, apparatus, or device. In the present invention, however, a computer-readable signal medium may include a data signal propagated in baseband or as part of a carrier wave, carrying computer-readable program code therein. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the foregoing. A computer-readable signal medium can also be any computer-readable medium other than a computer-readable storage medium that can transmit, propagate, or transport the program for use by or in connection with the instruction execution system, apparatus, or device . Program code embodied on a computer readable medium may be transmitted using any suitable medium including, but not limited to, wireless, wireline, optical fiber cable, RF, etc., or any suitable combination of the foregoing.
附图中的流程图和框图,图示了按照本发明各种实施例的系统、方法和计算机程序产品的可能实现的体系架构、功能和操作。在这点上,流程图或框图中的每个方框可以代表一个模块、程序段、或代码的一部分,上述模块、程序段、或代码的一部分包含一个或多个用于实现规定的逻辑功能的可执行指令。也应当注意,在有些作为替换的实现中,方框中所标注的功能也可以以不同于附图中所标注的顺序发生。例如,两个接连地表示的方框实际上可以基本并行地执行,它们有时也可以按相反的顺序执行,这依所涉及的功能而定。也要注意的是,框图或流程图中的每个方框、以及框图或流程图中的方框的组合,可以用执行规定的功能或操作的专用的基于硬件的系统来实现,或者可以用专用硬件与计算机指令的组合来实现。The flowchart 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 invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code that contains one or more logical functions for implementing the specified functions executable instructions. It should also be noted that, in some alternative implementations, the functions noted in the blocks 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 is also noted that each block of the block diagrams or flowchart illustrations, and combinations of blocks in the block diagrams or flowchart illustrations, can be implemented in special purpose hardware-based systems that perform the specified functions or operations, or can be implemented using A combination of dedicated hardware and computer instructions is implemented.
描述于本发明实施例中所涉及到的模块可以通过软件的方式实现,也可以通过硬件的方式来实现。所描述的模块也可以设置在处理器中,例如,可以描述为:一种处理器包括:解析模块,对数据库中目标数据表进行全字段解析,确定该目标数据表的表头字段;根据该表头字段在所述目标数据表中进行全量数据查询以得到全量数据;创建模块,根据该表头字段在内存中创建实体对象;存储模块,将该全量数据存储至该实体对象中,以实现将数据库中的数据提取至内存中。其中,这些模块的名称在某种情况下并不构成对该模块本身的限定,例如,解析模块还可以被描述为“根据该表头字段在内存中创建实体对象的模块”。The modules involved in the embodiments of the present invention may be implemented in a software manner, and may also be implemented in a hardware manner. The described module can also be set in the processor, for example, it can be described as: a processor includes: a parsing module, which performs full field analysis on the target data table in the database, and determines the header field of the target data table; The header field performs full data query in the target data table to obtain full data; the creation module creates an entity object in the memory according to the header field; the storage module stores the full data in the entity object to realize Fetch data from the database into memory. Among them, the names of these modules do not constitute a limitation of the module itself under certain circumstances. For example, the parsing module can also be described as "a module that creates an entity object in memory according to the header field".
作为另一方面,本发明还提供了一种计算机可读介质,该计算机可读介质可以是上述实施例中描述的设备中所包含的;也可以是单独存在,而未装配入该设备中。上述计算机可读介质承载有一个或者多个程序,当上述一个或者多个程序被一个该设备执行时,使得该设备包括:对数据库中目标数据表进行全字段解析,确定该目标数据表的表头字段;根据该表头字段在内存中创建实体对象,并在该目标数据表中进行全量数据查询以得到全量数据;将该全量数据存储至该实体对象中,以实现将数据库中的数据提取至内存中。As another aspect, the present invention also provides a computer-readable medium, which may be included in the device described in the above embodiments; or may exist alone without being assembled into the device. The above-mentioned computer-readable medium carries one or more programs, and when the above-mentioned one or more programs are executed by a device, the device includes: performing full field analysis on the target data table in the database, and determining the table of the target data table. Header field; create an entity object in memory according to the header field, and perform full data query in the target data table to obtain full data; store the full data in the entity object to extract data from the database into memory.
根据本发明实施例的技术方案,根据数据库中目标数据表的表头字段在内存中创建实体对象,然后将目标数据表的全量数据存储至实体对象中,能够实现数据库中的数据提取至内存中,提高了内存的利用率。由于内存中存储了目标数据表中的全量数据,无需从数据库查询数据,因此能够大大提高查询效率。拦截针对数据库中目标数据表进行查询的数据库查询请求,根据解析出的查询条件将数据库查询请求转换成对应内存的内存查询请求,使得内存中的数据是透明的,不需要额外加工处理数据库查询请求即可获取到内存中的数据,且只需要一次查询,近乎应用闭环,因此能够进一步提高查询效率。According to the technical solution of the embodiment of the present invention, an entity object is created in the memory according to the header field of the target data table in the database, and then the full data of the target data table is stored in the entity object, so that the data in the database can be extracted into the memory. , which improves memory utilization. Since the full amount of data in the target data table is stored in the memory, there is no need to query the data from the database, so the query efficiency can be greatly improved. Intercept the database query request for querying the target data table in the database, and convert the database query request into a memory query request corresponding to the memory according to the parsed query conditions, so that the data in the memory is transparent, and no additional processing of the database query request is required. The data in the memory can be obtained, and only one query is required, which is close to the application closed loop, so the query efficiency can be further improved.
上述具体实施方式,并不构成对本发明保护范围的限制。本领域技术人员应该明白的是,取决于设计要求和其他因素,可以发生各种各样的修改、组合、子组合和替代。任何在本发明的精神和原则之内所作的修改、等同替换和改进等,均应包含在本发明保护范围之内。The above-mentioned specific embodiments do not constitute a limitation on the protection scope of the present invention. It should be understood by those skilled in the art that various modifications, combinations, sub-combinations and substitutions may occur depending on design requirements and other factors. Any modifications, equivalent replacements and improvements made within the spirit and principle of the present invention shall be included within the protection scope of the present invention.
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811036754.7A CN110888939A (en) | 2018-09-06 | 2018-09-06 | A data management method and device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201811036754.7A CN110888939A (en) | 2018-09-06 | 2018-09-06 | A data management method and device |
Publications (1)
Publication Number | Publication Date |
---|---|
CN110888939A true CN110888939A (en) | 2020-03-17 |
Family
ID=69744309
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201811036754.7A Pending CN110888939A (en) | 2018-09-06 | 2018-09-06 | A data management method and device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110888939A (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113094401A (en) * | 2021-05-07 | 2021-07-09 | 北京京东振世信息技术有限公司 | Target source data generation method, device, equipment and storage medium |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1740978A (en) * | 2004-08-23 | 2006-03-01 | 华为技术有限公司 | Method for realizing shared memory database and memory database system |
CN103761248A (en) * | 2013-12-23 | 2014-04-30 | 远光软件股份有限公司 | Method and system for querying data through main memory database |
CN105868411A (en) * | 2016-04-27 | 2016-08-17 | 国网上海市电力公司 | Non-relation type database and relation type database integrated data query method and system |
CN107844488A (en) * | 2016-09-18 | 2018-03-27 | 北京京东尚科信息技术有限公司 | Data query method and apparatus |
US20180129746A1 (en) * | 2016-11-04 | 2018-05-10 | Schneider Electric Software, Llc | Adapting database queries for data virtualization over combined database stores |
-
2018
- 2018-09-06 CN CN201811036754.7A patent/CN110888939A/en active Pending
Patent Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN1740978A (en) * | 2004-08-23 | 2006-03-01 | 华为技术有限公司 | Method for realizing shared memory database and memory database system |
CN103761248A (en) * | 2013-12-23 | 2014-04-30 | 远光软件股份有限公司 | Method and system for querying data through main memory database |
CN105868411A (en) * | 2016-04-27 | 2016-08-17 | 国网上海市电力公司 | Non-relation type database and relation type database integrated data query method and system |
CN107844488A (en) * | 2016-09-18 | 2018-03-27 | 北京京东尚科信息技术有限公司 | Data query method and apparatus |
US20180129746A1 (en) * | 2016-11-04 | 2018-05-10 | Schneider Electric Software, Llc | Adapting database queries for data virtualization over combined database stores |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN113094401A (en) * | 2021-05-07 | 2021-07-09 | 北京京东振世信息技术有限公司 | Target source data generation method, device, equipment and storage medium |
CN113094401B (en) * | 2021-05-07 | 2023-08-08 | 北京京东振世信息技术有限公司 | Target source data generation method, device, equipment and storage medium |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110019350B (en) | Data query method and device based on configuration information | |
CN110472207A (en) | List generation method and device | |
CN113760948A (en) | Method and device for querying data | |
CN110209677A (en) | The method and apparatus of more new data | |
WO2021023149A1 (en) | Method and apparatus for dynamically returning message | |
US11200231B2 (en) | Remote query optimization in multi data sources | |
CN110909022B (en) | A data query method and device | |
CN113010405B (en) | A method and device for testing an application program | |
CN110795315A (en) | Method and apparatus for monitoring services | |
CN110704200A (en) | Methods and devices for converting invocation interfaces | |
CN112948138A (en) | Method and device for processing message | |
CN110737676A (en) | Data query method and device | |
CN113760240A (en) | Method and device for generating data model | |
CN110764796A (en) | Method and device for updating cache | |
WO2023056946A1 (en) | Data caching method and apparatus, and electronic device | |
CN113760276A (en) | Method and device for generating page code | |
CN114297278A (en) | Batch data fast writing method, system and device | |
CN113704222A (en) | Method and device for processing service request | |
CN110865797A (en) | Method and apparatus for processing business dynamic attributes | |
CN116561013B (en) | Test methods, devices, electronic equipment and media based on the target service framework | |
CN110888939A (en) | A data management method and device | |
CN112148762A (en) | Statistical method and device for real-time data flow | |
CN113760949B (en) | Data query method and device | |
CN114896244A (en) | Method, apparatus, apparatus, and computer-readable medium for configuring database tables | |
CN113110898A (en) | Transaction task execution 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 | ||
RJ01 | Rejection of invention patent application after publication | ||
RJ01 | Rejection of invention patent application after publication |
Application publication date: 20200317 |