CN115455149B - Database construction method based on coding query mode and application thereof - Google Patents
Database construction method based on coding query mode and application thereofDownload PDFInfo
- Publication number
- CN115455149B CN115455149BCN202211141746.5ACN202211141746ACN115455149BCN 115455149 BCN115455149 BCN 115455149BCN 202211141746 ACN202211141746 ACN 202211141746ACN 115455149 BCN115455149 BCN 115455149B
- Authority
- CN
- China
- Prior art keywords
- database
- dimension
- data
- keywords
- query
- 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.)
- Expired - Fee Related
Links
Images
Classifications
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/33—Querying
- G06F16/3331—Query processing
- G06F16/334—Query execution
- G06F16/3344—Query execution using natural language analysis
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/31—Indexing; Data structures therefor; Storage structures
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/12—Use of codes for handling textual entities
- G06F40/126—Character encoding
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/20—Natural language analysis
- G06F40/205—Parsing
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/20—Natural language analysis
- G06F40/279—Recognition of textual entities
- G06F40/289—Phrasal analysis, e.g. finite state techniques or chunking
- G—PHYSICS
- G06—COMPUTING OR CALCULATING; COUNTING
- G06N—COMPUTING ARRANGEMENTS BASED ON SPECIFIC COMPUTATIONAL MODELS
- G06N20/00—Machine learning
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Artificial Intelligence (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Health & Medical Sciences (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Data Mining & Analysis (AREA)
- Software Systems (AREA)
- Databases & Information Systems (AREA)
- Computer Vision & Pattern Recognition (AREA)
- Evolutionary Computation (AREA)
- Medical Informatics (AREA)
- Computing Systems (AREA)
- Mathematical Physics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Translated fromChinese技术领域technical field
本申请涉及数据库技术领域，特别是一种涉及基于编码查询方式的数据库构建方法及其应用。This application relates to the technical field of databases, in particular to a database construction method and its application based on coded query mode.
背景技术Background technique
随着现代社会的不断发展，网络的应用越来越广泛，相应的通过网络传输的数据也越来越多。为了对这些数据进行处理、加以利用，通常会将数据保存在数据库中，为了分析用户行为、为了网络的测量和优化、为了进行审计都可能会将网络数据保存在数据库中。尤其是在涉及城市大脑和城市治理技术领域中，数据量将更为庞大，往往会涉及一个城市内多个维度的数据，且多个数据之间往往会存在关联关系，这会导致数据库中存储大量数据，在数据检索或查询时，往往会浪费掉很多的算力，且查询与检索速率慢，导致用户等待时长增加。With the continuous development of modern society, the application of the network is becoming more and more extensive, and correspondingly more and more data are transmitted through the network. In order to process and utilize these data, the data is usually stored in a database, and network data may be stored in a database for analyzing user behavior, for network measurement and optimization, and for auditing. Especially in the field of urban brain and urban governance technology, the amount of data will be even larger, often involving multiple dimensions of data in a city, and there are often correlations between multiple data, which will lead to storage in the database. A large amount of data often wastes a lot of computing power during data retrieval or query, and the query and retrieval speed is slow, resulting in increased waiting time for users.
然而传统技术中，在数据库进行检索与查询时，往往是输入关键词，然后基于关键词对数据进行提取或排序，在关键词横跨多个维度时，会进一步增加相应时长，以查询城市维度工资收入数据库为例检索目标为“男浙江人收入”该检索关键词包括了男、浙江人和收入三个维度的数据，在检索过程中，需要逐一历遍数据库内所有的数据，然后对包含有上述三个维度的数据进行提取，获取初步的查询的数据库，进一步再分析初步的查询数据库才能够获得查询结果，导致查询时间长，算力消耗大。However, in the traditional technology, when searching and querying the database, keywords are often input, and then the data is extracted or sorted based on the keywords. When the keywords span multiple dimensions, the corresponding time will be further increased to query the city dimension. Take the wages and income database as an example. The search target is "income of men from Zhejiang". The above three dimensions of data are extracted to obtain a preliminary query database, and further analysis of the preliminary query database can obtain the query results, resulting in long query time and high computing power consumption.
由此可见，由于网络数据的数据量大，并且变化可能也较多，因此需要一个大容量易扩展的数据库进行存储。同时，对于各种需要对数据库进行查询的应用而言，对于大容量数据库的快速查询也是非常重要的。为此亟待基于编码查询方式的数据库构建方法及其应用以解决上述问题。It can be seen that, due to the large amount of network data and the possibility of many changes, a large-capacity and easily expandable database is required for storage. At the same time, for various applications that need to query the database, it is also very important to quickly query the large-capacity database. Therefore, there is an urgent need for a database construction method and its application based on coded query methods to solve the above problems.
发明内容Contents of the invention
本申请实施例提供了基于编码查询方式的数据库构建方法及其应用，针对目前技术存在的计算资源消耗大以及数据量大等问题。The embodiment of the present application provides a method for constructing a database based on a coded query method and its application, aiming at problems such as large consumption of computing resources and large amount of data existing in the current technology.
本发明核心技术主要是包括三个方向：1数据库的建立；2数据库的扩容；3数据库的查询。The core technology of the present invention mainly includes three directions: 1. the establishment of the database; 2. the expansion of the database; 3. the query of the database.
第一方面，本申请提供了基于编码查询方式的数据库构建方法，所述方法包括以下步骤：In a first aspect, the present application provides a database construction method based on a coded query method, the method comprising the following steps:
S00、遍历原始数据并进行解析，以获取原始数据中每个数据的维度关键词；S00, traversing the original data and performing analysis, so as to obtain the dimension keywords of each data in the original data;
S01、对每个维度关键词进行编码，以使得编码与维度关键词一一对应关联；S01. Encoding each dimension keyword, so that the encoding is associated with the dimension keyword in one-to-one correspondence;
S02、以维度关键词之间的映射关系，构建数据库的映射网格关系；S02. Construct a mapping grid relationship of the database based on the mapping relationship between dimension keywords;
S03、以编码与维度关键词之间的对应关系，修正数据库的映射网格关系并确定数据库的数据集存储方式；S03. Correct the mapping grid relationship of the database and determine the data set storage mode of the database based on the corresponding relationship between the code and the dimension keyword;
S04、基于数据库的数据集存储方式的结构构建查询密钥；S04, constructing a query key based on the structure of the data set storage mode of the database;
其中查询密钥由每个维度关键词对应的编码组成；The query key consists of the code corresponding to each dimension keyword;
S05、将原始数据以确定的数据集存储方式存储于数据库中。S05. Store the original data in the database in a certain data set storage manner.
进一步地，还包括用于对数据库扩容的步骤，具体包括以下步骤：Further, steps for expanding the capacity of the database are also included, specifically including the following steps:
S10、接收并解析数据库需要存储的扩容数据，以获得扩容数据的扩容维度关键词；S10. Receive and analyze the expansion data that needs to be stored in the database, so as to obtain the expansion dimension keywords of the expansion data;
S11、将扩容维度关键词与数据库中原有的维度关键词进行比对，以获得两者之间的差异；S11. Comparing the expanded dimension keyword with the original dimension keyword in the database to obtain the difference between the two;
S12、判断两者之间的差异大小；S12, judging the size of the difference between the two;
S13、若差异大于阈值，则将扩容维度关键词进行编码，以构建新的编码，并以新的编码与扩容维度关键词之间的对应关系并更新数据库的数据集存储方式，同时更新查询密钥，使扩容数据以更新后的数据集存储方式存入数据库中，完成扩容；若差异小于等于阈值，则将扩容维度关键词整合入原有的维度关键词中，使扩容数据以原有的数据集存储放入存入数据库中，完成扩容。S13. If the difference is greater than the threshold, encode the expansion dimension keyword to construct a new code, and update the data set storage method of the database based on the correspondence between the new encoding and the expansion dimension keyword, and update the query password at the same time. Key, so that the expansion data is stored in the database in the updated data set storage mode, and the expansion is completed; if the difference is less than or equal to the threshold, the expansion dimension keywords are integrated into the original dimension keywords, so that the expansion data is stored in the original The data set is stored in the database to complete the expansion.
进一步地，还包括用于对数据库查询的步骤，具体包括以下步骤：Further, steps for querying the database are also included, specifically including the following steps:
S20、接收并解析输入的查询密钥，以获取查询密钥中包含的维度关键词；S20. Receive and parse the input query key to obtain dimension keywords contained in the query key;
S21、基于获取到的维度关键词确认对应的查询编码；S21. Confirm the corresponding query code based on the acquired dimension keywords;
其中查询编码为查询用的编码；The query code is the code used for query;
S22、根据查询编码提取数据库中与查询编码相关的数据。S22. Extract data related to the query code in the database according to the query code.
进一步地，步骤S00中，每个维度关键词均输出，以供用户预览审阅，并接受用户的修改或删除或新增。Further, in step S00 , each dimension keyword is output for preview and review by the user, and user's modification, deletion or addition is accepted.
进一步地，还包括步骤S06、基于机器学习提取维度关键词。Further, step S06 is also included, extracting dimension keywords based on machine learning.
进一步地，步骤S01中，以数字形式对每个维度关键词进行编码。Further, in step S01, each dimension keyword is encoded in digital form.
进一步地，步骤S02中，对能够上位概括的维度关键词进行上位，以得到上位维度关键词，以使得下位的维度关键词与上位维度关键词之间形成映射关系。Further, in step S02 , the dimension keywords capable of superordinate generalization are superordinated to obtain the superordinate dimension keywords, so that a mapping relationship is formed between the subordinate dimension keywords and the superordinate dimension keywords.
第二方面，本申请提供了一种基于编码查询方式的数据库查询扩容装置，包括：In a second aspect, the present application provides a database query expansion device based on a coding query method, including:
建立模块，用于遍历原始数据并进行解析，以获取原始数据中每个数据的维度关键词；对每个维度关键词进行编码，以使得编码与维度关键词一一对应关联；以维度关键词之间的映射关系，构建数据库的映射网格关系；以编码与维度关键词之间的对应关系，修正数据库的映射网格关系并确定数据库的数据集存储方式；基于数据库的数据集存储方式的结构构建查询密钥；将原始数据以确定的数据集存储方式存储于数据库中；Build a module for traversing the original data and analyzing it to obtain the dimension keywords of each data in the original data; encode each dimension keyword so that the encoding is associated with the dimension keywords one by one; use the dimension keywords The mapping relationship between databases is used to construct the mapping grid relationship of the database; the mapping grid relationship of the database is corrected and the data set storage mode of the database is determined based on the corresponding relationship between codes and dimension keywords; the data set storage mode based on the database The structure constructs the query key; the original data is stored in the database in a definite data set storage method;
扩容模块，用于接收并解析数据库需要存储的扩容数据，以获得扩容数据的扩容维度关键词；将扩容维度关键词与数据库中原有的维度关键词进行比对，以获得两者之间的差异；判断两者之间的差异大小；若差异大于阈值，则将扩容维度关键词进行编码，以构建新的编码，并以新的编码与扩容维度关键词之间的对应关系并更新数据库的数据集存储方式，同时更新查询密钥，使扩容数据以更新后的数据集存储方式存入数据库中，完成扩容；若差异小于等于阈值，则将扩容维度关键词整合入原有的维度关键词中，使扩容数据以原有的数据集存储放入存入数据库中，完成扩容；The expansion module is used to receive and analyze the expansion data to be stored in the database to obtain the expansion dimension keywords of the expansion data; compare the expansion dimension keywords with the original dimension keywords in the database to obtain the difference between the two ;Judging the difference between the two; if the difference is greater than the threshold, encode the keywords of the expansion dimension to construct a new code, and update the data in the database with the corresponding relationship between the new code and the keywords of the expansion dimension Set the storage method, and update the query key at the same time, so that the expansion data is stored in the database with the updated data set storage method, and the expansion is completed; if the difference is less than or equal to the threshold, the expansion dimension keywords are integrated into the original dimension keywords , so that the expansion data is stored in the original data set and stored in the database to complete the expansion;
查询模块，用于接收并解析输入的查询密钥，以获取查询密钥中包含的维度关键词；基于获取到的维度关键词确认对应的查询编码；The query module is configured to receive and parse the input query key to obtain the dimension keyword contained in the query key; confirm the corresponding query code based on the obtained dimension keyword;
输出模块，用于输出查询的数据。The output module is used to output the queried data.
第三方面，本申请提供了一种电子装置，包括存储器和处理器，存储器中存储有计算机程序，处理器被设置为运行计算机程序以执行上述的基于编码查询方式的数据库构建方法。In a third aspect, the present application provides an electronic device, including a memory and a processor, wherein a computer program is stored in the memory, and the processor is configured to run the computer program to execute the above-mentioned database construction method based on coded query.
第四方面，本申请提供了一种可读存储介质，可读存储介质中存储有计算机程序，计算机程序包括用于控制过程以执行过程的程序代码，过程包括根据上述的基于编码查询方式的数据库构建方法。In a fourth aspect, the present application provides a readable storage medium, in which a computer program is stored, the computer program includes program codes for controlling the process to execute the process, and the process includes the database based on the above-mentioned coding query method build method.
本发明的主要贡献和创新点如下：1、与现有技术相比，本申请在数据库构建过程中，通过对原始数据进行分析，构建基于编码建立的数据集存储方式和查询密钥，使得数据的录入具备一定的关联关系，便于数据的有序化存储，替代传统技术中的数据堆叠存储，存储更加科学，特别是在数据量庞大时，数据的存储有序，便于数据库的快速构建；The main contributions and innovations of the present invention are as follows: 1. Compared with the prior art, in the process of database construction, this application analyzes the original data to construct a data set storage method and query key based on coding, so that the data The data entry has a certain relationship, which facilitates the orderly storage of data, replaces the data stacked storage in traditional technology, and makes the storage more scientific, especially when the amount of data is huge, the data is stored in an orderly manner, which facilitates the rapid construction of the database;
2、与现有技术相比，本申请在数据库的扩容过程中，考虑到了随着数据库的使用时间的增长，数据的关键词可能会发生变化，原始数据库未必能够涵盖再后的维度关键词，因此在扩容过程中，可以识别新的数据的扩容维度关键词，并对扩容维度关键词进行编码，将新的编码加入到数据集存储方式中，可以更新数据的存储方式；2. Compared with the existing technology, during the expansion process of the database, this application takes into account that the key words of the data may change with the increase of the use time of the database, and the original database may not be able to cover the later dimension key words. Therefore, during the expansion process, the expansion dimension keyword of the new data can be identified, and the expansion dimension keyword can be encoded, and the new encoding can be added to the data set storage method, and the data storage method can be updated;
3、与现有技术相比，本申请在数据的查询过程中，可以基于查询关键词获取查询关键词的维度信息，基于维度信息可以获取到与维度信息对应的编码，通过编码在数据库内可以快速提取数据，同时可以提取不同数据之间的关联关系，能够提高数据查询的响应效率。3. Compared with the prior art, in the data query process of this application, the dimension information of the query keywords can be obtained based on the query keywords, and the code corresponding to the dimension information can be obtained based on the dimension information, and the code can be stored in the database. Quickly extract data, and at the same time extract the association relationship between different data, which can improve the response efficiency of data query.
本申请的一个或多个实施例的细节在以下附图和描述中提出，以使本申请的其他特征、目的和优点更加简明易懂。The details of one or more embodiments of the application are set forth in the accompanying drawings and the description below, so as to make other features, objects, and advantages of the application more comprehensible.
附图说明Description of drawings
此处所说明的附图用来提供对本申请的进一步理解，构成本申请的一部分，本申请的示意性实施例及其说明用于解释本申请，并不构成对本申请的不当限定。在附图中：The drawings described here are used to provide a further understanding of the application and constitute a part of the application. The schematic embodiments and descriptions of the application are used to explain the application and do not constitute an improper limitation to the application. In the attached picture:
图1是根据本申请实施例的基于编码查询方式的数据库构建方法的流程图；Fig. 1 is the flow chart of the database construction method based on coding query mode according to the embodiment of the application;
图2是数据库扩容的流程图；Figure 2 is a flowchart of database expansion;
图3是数据库查询的流程图；Fig. 3 is the flowchart of database query;
图4是根据本申请实施例的电子装置的硬件结构示意图。FIG. 4 is a schematic diagram of a hardware structure of an electronic device according to an embodiment of the present application.
具体实施方式Detailed ways
这里将详细地对示例性实施例进行说明，其示例表示在附图中。下面的描述涉及附图时，除非另有表示，不同附图中的相同数字表示相同或相似的要素。以下示例性实施例中所描述的实施方式并不代表与本说明书一个或多个实施例相一致的所有实施方式。相反，它们仅是与如所附权利要求书中所详述的、本说明书一个或多个实施例的一些方面相一致的装置和方法的例子。Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numerals in different drawings refer to the same or similar elements unless otherwise indicated. Implementations described in the following exemplary embodiments do not represent all implementations consistent with one or more embodiments of this specification. Rather, they are merely examples of apparatuses and methods consistent with aspects of one or more embodiments of the present specification as recited in the appended claims.
需要说明的是：在其他实施例中并不一定按照本说明书示出和描述的顺序来执行相应方法的步骤。在一些其他实施例中，其方法所包括的步骤可以比本说明书所描述的更多或更少。此外，本说明书中所描述的单个步骤，在其他实施例中可能被分解为多个步骤进行描述；而本说明书中所描述的多个步骤，在其他实施例中也可能被合并为单个步骤进行描述。It should be noted that in other embodiments, the steps of the corresponding methods are not necessarily performed in the order shown and described in this specification. In some other embodiments, the method may include more or less steps than those described in this specification. In addition, a single step described in this specification may be decomposed into multiple steps for description in other embodiments; multiple steps described in this specification may also be combined into a single step in other embodiments describe.
由于网络数据的数据量大，并且变化可能也较多，因此需要一个大容量易扩展的数据库进行存储。同时，对于各种需要对数据库进行查询的应用而言，对于大容量数据库的快速查询也是非常重要的。Due to the large amount of network data and the possibility of many changes, a large-capacity and easily expandable database is required for storage. At the same time, for various applications that need to query the database, it is also very important to quickly query the large-capacity database.
基于此，本发明基于关键词建立数据库来解决现有技术存在的问题。Based on this, the present invention establishes a database based on keywords to solve the problems existing in the prior art.
实施例一Embodiment one
具体地，本申请实施例提供了基于编码查询方式的数据库构建方法，具体地，参考图1，所述方法包括：Specifically, the embodiment of the present application provides a method for building a database based on a coded query method. Specifically, referring to FIG. 1, the method includes:
S00、遍历原始数据并进行解析，以获取原始数据中每个数据的维度关键词；S00, traversing the original data and performing analysis, so as to obtain the dimension keywords of each data in the original data;
在本实施例中，原始数据为已知数据，在对原始数据进行解析过程中，按照语言类型对所述查询字段所包含的内容进行片断拆分，得到多个维度关键词，该语言类型包括了断句顺序，和同一数据中字间关联度。In this embodiment, the original data is known data. During the parsing process of the original data, the content contained in the query field is segmented according to the language type to obtain multiple dimension keywords. The language type includes The order of sentence segmentation and the degree of correlation between words in the same data are determined.
优选地，在生成了维度关键词之后，可以具备预览功能，即将所有的维度关键词进行预览以供用户审阅，用户可以基于审阅结果接入到维度关键词的修订中，如可以删除维度关键词或补入维度关键词会修改维度关键词。Preferably, after the dimension keywords are generated, a preview function can be provided, that is, to preview all the dimension keywords for users to review, and the user can access the revision of the dimension keywords based on the review results, such as deleting the dimension keywords Or adding dimension keywords will modify the dimension keywords.
优选地，可以将原始数据库的构建与深度学习技术相结合，实现维度关键词的自动化提取，随着数据量的增加，维度关键词的提取将更为准确。Preferably, the construction of the original database can be combined with deep learning technology to realize the automatic extraction of dimension keywords. As the amount of data increases, the extraction of dimension keywords will be more accurate.
S01、对每个维度关键词进行编码，以使得编码与维度关键词一一对应关联；S01. Encoding each dimension keyword, so that the encoding is associated with the dimension keyword in one-to-one correspondence;
优选地，可以以数字的方式对每个维度关键词进行编码，以进一步简化编码的构建，便于数据集存储方式和查询密钥的建立。Preferably, each dimension keyword can be coded in a digital manner, so as to further simplify the construction of the code, and facilitate the establishment of the data set storage method and the query key.
如英文字母与数字的对应关系为例：A（1）、B（2）、C（3）、D（4）、E（5）、F（6）、G（7）、H（8）、I（9）、J（210）、K（211）、L（212）、M（213）、N（214）、O（215）、P（216）、Q（217）、R（218）、S（219）、T（220）、U（221）、V（222）、W（223）、X（224）、Y（225）、Z（226）。For example, the corresponding relationship between English letters and numbers: A (1), B (2), C (3), D (4), E (5), F (6), G (7), H (8) , I (9), J (210), K (211), L (212), M (213), N (214), O (215), P (216), Q (217), R (218) , S (219), T (220), U (221), V (222), W (223), X (224), Y (225), Z (226).
S02、以维度关键词之间的映射关系，构建数据库的映射网格关系；S02. Construct a mapping grid relationship of the database based on the mapping relationship between dimension keywords;
在本实施例中，如以“男浙江人收入”为例，原始数据库中还可以包括“女浙江人收入”，即男、女、浙江人及收入为四个维度关键词，该四个维度关键词之间为平行映射的关系，还可以对男和女进行上位，以获取上位维度关键词，上位维度关键词可以为性别，性别与浙江人和收入即为交叉映射的关系，男、女与性别即为从属映射的关系。In this embodiment, taking "male income from Zhejiang" as an example, the original database may also include "female income from Zhejiang", that is, male, female, Zhejiang and income are four dimension keywords, and the four dimensions There is a parallel mapping relationship between keywords, and male and female can also be superordinated to obtain superordinate dimension keywords. The superordinate dimension keyword can be gender, and gender and Zhejiang people and income are cross-mapping relationships. Male and female The relationship with gender is the subordination map.
S03、以编码与维度关键词之间的对应关系，修正数据库的映射网格关系并确定数据库的数据集存储方式；S03. Correct the mapping grid relationship of the database and determine the data set storage mode of the database based on the corresponding relationship between the code and the dimension keyword;
在本实施例中，将映射网格关系中的维度关键词替换为编码，即可构建数据集存储方式和查询密钥，构建数据集存储方式和查询密钥为网格化的数据化的。In this embodiment, by replacing the dimension keywords in the mapping grid relationship with codes, the data set storage method and query key can be constructed, and the data set storage method and query key are constructed to be grid-based and digital.
S04、基于数据库的数据集存储方式的结构构建查询密钥；S04, constructing a query key based on the structure of the data set storage mode of the database;
其中查询密钥由每个维度关键词对应的编码组成；The query key consists of the code corresponding to each dimension keyword;
S05、将原始数据以确定的数据集存储方式存储于数据库中。S05. Store the original data in the database in a certain data set storage manner.
在本实施例中，如基于英文字母表，构建加密数字库，每个英文字母对应有一个加密数字，在基于维度关键词来确定编码的过程中，提取每个关键词的首个字符和末尾字符的拼音的首字母，基于关键词的首个字符和末尾字符首字母和加密数字来确定编码，如关键词为男性，n对应的数字为214，x对应的数字为224，那么男性这一关键词对应的编码即为214224。进一步地，在确定关键词对应的编码之后，可以对已经确认的编码进行存储，构建编码映射关系，在确定下一个关键词对应的编码时，需要将新的编码与编码映射关系进行比对，确定新的编码与编码映射关系是否存在重复，如果重复这再取关键词的首字符的第二个拼音字母对关键词进行加密，如此循环直到新的编码与编码映射关系之间不重复，基于此即可完成关键词的编码化。In this embodiment, if an encrypted number library is constructed based on the English alphabet, each English letter corresponds to an encrypted number, and in the process of determining the encoding based on the dimension keywords, the first character and the end of each keyword are extracted The first letter of the pinyin of the character is determined based on the first letter and the last letter of the keyword and the encrypted number. For example, if the keyword is male, the number corresponding to n is 214, and the number corresponding to x is 224, then the number corresponding to male is 214. The code corresponding to the keyword is 214224. Further, after the code corresponding to the keyword is determined, the confirmed code can be stored to construct a code mapping relationship. When determining the code corresponding to the next keyword, it is necessary to compare the new code with the code mapping relationship. Determine whether there is any repetition in the new coding and coding mapping relationship, if repeated, then take the second pinyin letter of the first character of the keyword to encrypt the keyword, and so on until there is no repetition between the new coding and coding mapping relationship, based on This completes the encoding of keywords.
可以理解的是，如此设置便于关键词的编码化，同时也实现了对关键词的加密，也便于破译编码的编写。It can be understood that such setting is convenient for coding keywords, and at the same time realizes the encryption of keywords, and facilitates the writing of deciphering codes.
其中，如图2所示，扩容步骤包括：Wherein, as shown in Figure 2, the expansion steps include:
S10、接收并解析数据库需要存储的扩容数据，以获得扩容数据的扩容维度关键词；S10. Receive and analyze the expansion data that needs to be stored in the database, so as to obtain the expansion dimension keywords of the expansion data;
在本实施例中，随着数据库的使用时间的增长，数据的关键词可能会发生变化，原始数据库未必能够涵盖再后的维度关键词，同样以“男浙江人收入”为例，后续数据的录入过程中出现了大量的“男浙江人工资收入”、“男浙江人理财工资收入”，这种情况下，如若强行将新的数据按照以前的数据集存储方式存储在数据库中，将会导致数据录入的不准确，数据存储不清晰，因此确定扩容数据的扩容维度关键词。In this embodiment, as the usage time of the database increases, the key words of the data may change, and the original database may not be able to cover the later dimension key words. Also taking "the income of men from Zhejiang" as an example, the subsequent data During the entry process, a large number of "wage income of men from Zhejiang" and "financial income of men from Zhejiang" appeared. In this case, if the new data is forcibly stored in the database according to the previous data set storage method, it will lead to The data entry is inaccurate and the data storage is not clear, so determine the expansion dimension keywords for the expansion data.
S11、将扩容维度关键词与数据库中原有的维度关键词进行比对，以获得两者之间的差异；S11. Comparing the expanded dimension keyword with the original dimension keyword in the database to obtain the difference between the two;
S12、判断两者之间的差异大小；S12, judging the size of the difference between the two;
优选地，这里可以采用相似度算法来判断或者说计算差异大小，或者其他机器学习模型来计算相似度或差异大小。Preferably, a similarity algorithm can be used here to judge or calculate the difference, or other machine learning models can be used to calculate the similarity or difference.
S13、若差异大于阈值，则将扩容维度关键词进行编码，以构建新的编码，并以新的编码与扩容维度关键词之间的对应关系并更新数据库的数据集存储方式，同时更新查询密钥，使扩容数据以更新后的数据集存储方式存入数据库中，完成扩容；若差异小于等于阈值，则将扩容维度关键词整合入原有的维度关键词中，使扩容数据以原有的数据集存储放入存入数据库中，完成扩容。S13. If the difference is greater than the threshold, encode the expansion dimension keyword to construct a new code, and update the data set storage method of the database based on the correspondence between the new encoding and the expansion dimension keyword, and update the query password at the same time. Key, so that the expansion data is stored in the database in the updated data set storage mode, and the expansion is completed; if the difference is less than or equal to the threshold, the expansion dimension keywords are integrated into the original dimension keywords, so that the expansion data is stored in the original The data set is stored in the database to complete the expansion.
在本实施例中，可以理解的是，在比对扩容维度关键词与数据量中的维度关键词进行比对的过程中，还可以基于扩容维度关键词与维度关键词的差异数量、重合数量的角度确定比对结果，如对在重合数量极少的情况下，该新的扩容数据不易存储在该数据库中，应当建议建立新的数据库；如若重合度大于第一阈值（如取值大于30%），且差异数量大于2个，这种情况下可以认为二者之间差异较大，如若重合度大于第一阈值（如取值大于30%），且差异数量小于或等于2个，则可以认为二者之间差异较小。In this embodiment, it can be understood that, in the process of comparing the expanded dimension keywords with the dimension keywords in the data volume, it can also be based on the number of differences and overlaps between the expanded dimension keywords and the dimension keywords To determine the comparison result, if the new expansion data is not easy to store in the database when the number of coincidences is very small, it should be suggested to establish a new database; if the coincidence degree is greater than the first threshold (for example, the value is greater than 30 %), and the number of differences is greater than 2. In this case, it can be considered that there is a large difference between the two. If the coincidence degree is greater than the first threshold (such as the value is greater than 30%), and the number of differences is less than or equal to 2, then The difference between the two can be considered small.
其中，如图3所示，查询步骤（适用于未扩容的数据库和已扩容的数据库）包括：Among them, as shown in Figure 3, the query steps (applicable to the non-expanded database and the expanded database) include:
S20、接收并解析输入的查询密钥，以获取查询密钥中包含的维度关键词；S20. Receive and parse the input query key to obtain dimension keywords contained in the query key;
S21、基于获取到的维度关键词确认对应的查询编码；S21. Confirm the corresponding query code based on the acquired dimension keywords;
其中查询编码为查询用的编码；The query code is the code used for query;
S22、根据查询编码提取数据库中与查询编码相关的数据。S22. Extract data related to the query code in the database according to the query code.
在本实施例中，以“男浙江人收入”为例，在数据库的构建过程中男对应有编码001，浙江对有关有编码002，收入对应有编码003，在查询过程中，可以直接基于001002003提取数据库中的数据，同时提取数据库中的查询密钥，并通过映射网格的方式展现提取出的数据，可以进行数据的快速查询，同时利于精准分析。In this embodiment, taking "income of men from Zhejiang" as an example, during the construction of the database, there is code 001 for male, code 002 for Zhejiang, and code 003 for income. In the query process, it can be directly based on 001002003 Extract the data in the database, extract the query key in the database at the same time, and display the extracted data by mapping the grid, which can quickly query the data and facilitate accurate analysis.
优选地，在编码过程中，可以通过escape(string)函数、ncodeURI(URIstring)函数进行编码，可以通过encodeURIComponent(URIstring)解析查询密钥，对数据进行快速提取。Preferably, during the encoding process, the encoding can be performed through the escape(string) function and the ncodeURI(URIstring) function, and the query key can be parsed through encodeURIComponent(URIstring) to quickly extract the data.
优选地，本申请还适用于对城市维度的大数据进行处理，可以用户财务信息和交通数据的存储，在对财务信息进行存储时，财务信息包括：性别、年龄、公司性质等；在涉及交通信息的存储时，信息可以包括流速、车辆数量和车速。如可以服务于需要打车出行的乘客端、司机端和政府的交通管制部门。Preferably, this application is also suitable for processing big data in the city dimension, and can store user financial information and traffic data. When storing financial information, financial information includes: gender, age, company nature, etc.; When the information is stored, the information can include flow rate, vehicle number and vehicle speed. For example, it can serve the passenger terminal, driver terminal and government traffic control department that need to take a taxi.
其中，以应用在乘客端为例，数据库可以对乘客的目的地、始发地和时间段作为关键词进行统计，而目的地和始发地之下可以再包括多个关键词，如关键词可以涉及购物地、交通枢纽地和公益服务地（如学校），基于此即可构建目的地、始发地和时间段相关的数据库；Among them, taking the application on the passenger terminal as an example, the database can count the passenger’s destination, origin and time period as keywords, and multiple keywords can be included under the destination and origin, such as keyword It can involve shopping locations, transportation hubs, and public service locations (such as schools), based on which a database related to destinations, origins, and time periods can be constructed;
以该数据库应用到司机端为例，司机可以通过查询该数据库，快速获知到不同时段的客户往来方向，基于此该数据库可以促进司机的等客位置适配于客户发出起始地，能够提高乘客搭乘汽车的效率，也能够提高司机端的运客效率。Taking the application of this database to the driver terminal as an example, the driver can quickly know the direction of customers at different times by querying the database. The efficiency of taking a car can also improve the efficiency of passenger transport at the driver's end.
同样的该数据库也可以服务于政府机构，政府机构可以获知到乘客、司机的位置信息，而这种情况下司机可以包括出租车司机和私家车司机，通过快速高效地对数据进行存储和查询，可以使数据库的容量更大，数据库的数据涵盖范围更广，由于进行了编码统计，数据的脉络会更加清晰，政府职能部门即可基于数据的脉络来进行城市维度的规划，如道路修建和维护的规划，学校、商场区域的划分等等。The same database can also serve government agencies. Government agencies can obtain the location information of passengers and drivers. In this case, drivers can include taxi drivers and private car drivers. By storing and querying data quickly and efficiently, The capacity of the database can be increased, and the data of the database can cover a wider range. Due to the coding statistics, the context of the data will be clearer, and government functional departments can plan the city dimension based on the context of the data, such as road construction and maintenance. Planning, division of schools, shopping malls, etc.
实施例二Embodiment two
基于相同的构思，本申请还提出了一种基于编码查询方式的数据库查询扩容装置，包括：Based on the same idea, this application also proposes a database query expansion device based on coded query mode, including:
建立模块，用于遍历原始数据并进行解析，以获取原始数据中每个数据的维度关键词；对每个维度关键词进行编码，以使得编码与维度关键词一一对应关联；以维度关键词之间的映射关系，构建数据库的映射网格关系；以编码与维度关键词之间的对应关系，修正数据库的映射网格关系并确定数据库的数据集存储方式；基于数据库的数据集存储方式的结构构建查询密钥；将原始数据以确定的数据集存储方式存储于数据库中；Build a module for traversing the original data and analyzing it to obtain the dimension keywords of each data in the original data; encode each dimension keyword so that the encoding is associated with the dimension keywords one by one; use the dimension keywords The mapping relationship between databases is used to construct the mapping grid relationship of the database; the mapping grid relationship of the database is corrected and the data set storage mode of the database is determined based on the corresponding relationship between codes and dimension keywords; the data set storage mode based on the database The structure constructs the query key; the original data is stored in the database in a definite data set storage method;
扩容模块，用于接收并解析数据库需要存储的扩容数据，以获得扩容数据的扩容维度关键词；将扩容维度关键词与数据库中原有的维度关键词进行比对，以获得两者之间的差异；判断两者之间的差异大小；若差异大于阈值，则将扩容维度关键词进行编码，以构建新的编码，并以新的编码与扩容维度关键词之间的对应关系并更新数据库的数据集存储方式，同时更新查询密钥，使扩容数据以更新后的数据集存储方式存入数据库中，完成扩容；若差异小于等于阈值，则将扩容维度关键词整合入原有的维度关键词中，使扩容数据以原有的数据集存储放入存入数据库中，完成扩容；The expansion module is used to receive and analyze the expansion data to be stored in the database to obtain the expansion dimension keywords of the expansion data; compare the expansion dimension keywords with the original dimension keywords in the database to obtain the difference between the two ;Judging the difference between the two; if the difference is greater than the threshold, encode the keywords of the expansion dimension to construct a new code, and update the data in the database with the corresponding relationship between the new code and the keywords of the expansion dimension Set the storage method, and update the query key at the same time, so that the expansion data is stored in the database with the updated data set storage method, and the expansion is completed; if the difference is less than or equal to the threshold, the expansion dimension keywords are integrated into the original dimension keywords , so that the expansion data is stored in the original data set and stored in the database to complete the expansion;
查询模块，用于接收并解析输入的查询密钥，以获取查询密钥中包含的维度关键词；基于获取到的维度关键词确认对应的查询编码；The query module is configured to receive and parse the input query key to obtain the dimension keyword contained in the query key; confirm the corresponding query code based on the obtained dimension keyword;
输出模块，用于输出查询的数据。The output module is used to output the queried data.
实施例三Embodiment Three
本实施例还提供了一种电子装置，参考图4，包括存储器404和处理器402，该存储器404中存储有计算机程序，该处理器402被设置为运行计算机程序以执行上述任一项方法实施例中的步骤。This embodiment also provides an electronic device, referring to FIG. 4 , including a
具体地，上述处理器402可以包括中央处理器（CPU），或者特定集成电路（ApplicationSpecificIntegratedCircuit，简称为ASIC），或者可以被配置成实施本申请实施例的一个或多个集成电路。Specifically, the
其中，存储器404可以包括用于数据或指令的大容量存储器404。举例来说而非限制，存储器404可包括硬盘驱动器（HardDiskDrive，简称为HDD）、软盘驱动器、固态驱动器（SolidStateDrive，简称为SSD）、闪存、光盘、磁光盘、磁带或通用串行总线（UniversalSerialBus，简称为USB）驱动器或者两个或更多个以上这些的组合。在合适的情况下，存储器404可包括可移除或不可移除（或固定）的介质。在合适的情况下，存储器404可在数据处理装置的内部或外部。在特定实施例中，存储器404是非易失性（Non-Volatile）存储器。在特定实施例中，存储器404包括只读存储器（Read-OnlyMemory，简称为ROM）和随机存取存储器（RandomAccessMemory，简称为RAM）。在合适的情况下，该ROM可以是掩模编程的ROM、可编程ROM（ProgrammableRead-OnlyMemory，简称为PROM）、可擦除PROM（ErasableProgrammableRead-OnlyMemory，简称为EPROM）、电可擦除PROM（ElectricallyErasableProgrammableRead-OnlyMemory，简称为EEPROM）、电可改写ROM（ElectricallyAlterableRead-OnlyMemory，简称为EAROM）或闪存（FLASH）或者两个或更多个以上这些的组合。在合适的情况下，该RAM可以是静态随机存取存储器（StaticRandom-AccessMemory，简称为SRAM）或动态随机存取存储器（DynamicRandomAccessMemory，简称为DRAM），其中，DRAM可以是快速页模式动态随机存取存储器404（FastPageModeDynamicRandomAccessMemory，简称为FPMDRAM）、扩展数据输出动态随机存取存储器（ExtendedDateOutDynamicRandomAccessMemory，简称为EDODRAM）、同步动态随机存取内存（SynchronousDynamicRandom-AccessMemory，简称SDRAM）等。Wherein, the
存储器404可以用来存储或者缓存需要处理和/或通信使用的各种数据文件，以及处理器402所执行的可能的计算机程序指令。The
处理器402通过读取并执行存储器404中存储的计算机程序指令，以实现上述实施例中的任意基于编码查询方式的数据库构建方法。The
可选地，上述电子装置还可以包括传输设备406以及输入输出设备408，其中，该传输设备406和上述处理器402连接，该输入输出设备408和上述处理器402连接。Optionally, the above-mentioned electronic device may further include a
传输设备406可以用来经由一个网络接收或者发送数据。上述的网络具体实例可包括电子装置的通信供应商提供的有线或无线网络。在一个实例中，传输设备包括一个网络适配器（Network Interface Controller，简称为NIC），其可通过基站与其他网络设备相连从而可与互联网进行通讯。在一个实例中，传输设备406可以为射频（Radio Frequency，简称为RF）模块，其用于通过无线方式与互联网进行通讯。
输入输出设备408用于输入或输出信息。在本实施例中，输入的信息可以是需要存储的数据或者查询密钥等，输出的信息可以是需要查询的数据等。Input and
实施例四Embodiment Four
本实施例还提供了一种可读存储介质，可读存储介质中存储有计算机程序，计算机程序包括用于控制过程以执行过程的程序代码，过程包括根据实施例一的基于编码查询方式的数据库构建方法。This embodiment also provides a readable storage medium, in which a computer program is stored, the computer program includes program codes for controlling the process to execute the process, and the process includes the database based on the coding query method according to the first embodiment build method.
需要说明的是，本实施例中的具体示例可以参考上述实施例及可选实施方式中所描述的示例，本实施例在此不再赘述。It should be noted that, for specific examples in this embodiment, reference may be made to the examples described in the foregoing embodiments and optional implementation manners, and details will not be repeated in this embodiment.
通常，各种实施例可以以硬件或专用电路、软件、逻辑或其任何组合来实现。本发明的一些方面可以以硬件来实现，而其他方面可以由控制器、微处理器或其他计算设备执行的固件或软件来实现，但是本发明不限于此。尽管本发明的各个方面可以被示出和描述为框图、流程图或使用一些其他图形表示，但是应当理解，作为非限制性示例，本文中描述的这些框、装置、系统、技术或方法可以以硬件、软件、固件、专用电路或逻辑、通用硬件或控制器或其他计算设备或其某种组合来实现。In general, the various embodiments may be implemented in hardware or special purpose circuits, software, logic or any combination thereof. Some aspects of the invention may be implemented in hardware, while other aspects may be implemented in firmware or software executed by a controller, microprocessor or other computing device, although the invention is not limited thereto. Although aspects of the present invention may be shown and described as block diagrams, flowcharts, or using some other graphical representation, it should be understood that, as non-limiting examples, these blocks, devices, systems, techniques or methods described herein may be presented in hardware, software, firmware, special purpose circuits or logic, general purpose hardware or controllers or other computing devices, or some combination thereof.
本发明的实施例可以由计算机软件来实现，该计算机软件由移动设备的数据处理器诸如在处理器实体中可执行，或者由硬件来实现，或者由软件和硬件的组合来实现。包括软件例程、小程序和/或宏的计算机软件或程序(也称为程序产品)可以存储在任何装置可读数据存储介质中，并且它们包括用于执行特定任务的程序指令。计算机程序产品可以包括当程序运行时被配置为执行实施例的一个或多个计算机可执行组件。一个或多个计算机可执行组件可以是至少一个软件代码或其一部分。另外，在这一点上，应当注意，如图中的逻辑流程的任何框可以表示程序步骤、或者互连的逻辑电路、框和功能、或者程序步骤和逻辑电路、框和功能的组合。软件可以存储在诸如存储器芯片或在处理器内实现的存储块等物理介质、诸如硬盘或软盘等磁性介质、以及诸如例如DVD及其数据变体、CD等光学介质上。物理介质是非瞬态介质。Embodiments of the invention may be implemented by computer software executable by a data processor of a mobile device, such as in a processor entity, or by hardware, or by a combination of software and hardware. Computer software or programs (also called program products) including software routines, applets and/or macros can be stored on any device-readable data storage medium and they include program instructions for performing certain tasks. A computer program product may include one or more computer-executable components configured to perform an embodiment when the program is run. One or more computer-executable components may be at least one software code or a portion thereof. Also in this regard, it should be noted that any blocks of the logic flow in the figures may represent program steps, or interconnected logic circuits, blocks and functions, or a combination of program steps and logic circuits, blocks and functions. Software may be stored on physical media such as memory chips or memory blocks implemented within the processor, magnetic media such as hard or floppy disks, and optical media such as eg DVD and its data variants, CD. Physical media are non-transient media.
本领域的技术人员应该明白，以上实施例的各技术特征可以进行任意的组合，为使描述简洁，未对上述实施例中的各个技术特征所有可能的组合都进行描述，然而，只要这些技术特征的组合不存在矛盾，都应当认为是本说明书记载的范围。Those skilled in the art should understand that the various technical features of the above embodiments can be combined arbitrarily. For the sake of concise description, all possible combinations of the various technical features in the above embodiments are not described. There is no contradiction in the combination, and all should be considered as within the scope of the description.
以上实施例仅表达了本申请的几种实施方式，其描述较为具体和详细，但并不能因此而理解为对本申请范围的限制。应当指出的是，对于本领域的普通技术人员来说，在不脱离本申请构思的前提下，还可以做出若干变形和改进，这些都属于本申请的保护范围。因此，本申请的保护范围应以所附权利要求为准。The above examples only express several implementation modes of the present application, and the description thereof is relatively specific and detailed, but should not be construed as limiting the scope of the present application. It should be noted that those skilled in the art can make several modifications and improvements without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the present application should be determined by the appended claims.
Claims (9)
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211141746.5ACN115455149B (en) | 2022-09-20 | 2022-09-20 | Database construction method based on coding query mode and application thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202211141746.5ACN115455149B (en) | 2022-09-20 | 2022-09-20 | Database construction method based on coding query mode and application thereof |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115455149A CN115455149A (en) | 2022-12-09 |
| CN115455149Btrue CN115455149B (en) | 2023-05-30 |
Family
ID=84303922
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202211141746.5AExpired - Fee RelatedCN115455149B (en) | 2022-09-20 | 2022-09-20 | Database construction method based on coding query mode and application thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115455149B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN118939705B (en)* | 2024-10-14 | 2025-01-07 | 深圳市前海数据服务有限公司 | Method and system for realizing statistical data standardization |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7595485B1 (en)* | 2007-02-07 | 2009-09-29 | Thermo Finnigan Llc | Data analysis to provide a revised data set for use in peptide sequencing determination |
| CN105069109A (en)* | 2015-08-07 | 2015-11-18 | 北京思特奇信息技术股份有限公司 | Dilatation method and system of distributed database |
| CN106844534A (en)* | 2016-12-30 | 2017-06-13 | 西安电子科技大学 | Towards the GeoHash coding methods by geographical spatial data one-dimensional of NoSQL databases |
| CN108121712A (en)* | 2016-11-28 | 2018-06-05 | 北京国双科技有限公司 | A kind of keyword storage method and device |
| CN110489494A (en)* | 2019-08-27 | 2019-11-22 | 中国工商银行股份有限公司 | Distributed data base on-line rapid estimation method and device |
| CN110597961A (en)* | 2019-09-18 | 2019-12-20 | 腾讯科技（深圳）有限公司 | Text category labeling method and device, electronic equipment and storage medium |
| CN110929511A (en)* | 2018-09-04 | 2020-03-27 | 清华大学 | An intelligent matching method of personalized Chinese medicine diagnosis and treatment information and Chinese medicine information based on semantic similarity |
| CN111552783A (en)* | 2020-04-30 | 2020-08-18 | 深圳前海微众银行股份有限公司 | Content analysis query method, device, equipment and computer storage medium |
| CN111639153A (en)* | 2020-04-24 | 2020-09-08 | 平安国际智慧城市科技股份有限公司 | Query method and device based on legal knowledge graph, electronic equipment and medium |
Family Cites Families (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| AUPQ131399A0 (en)* | 1999-06-30 | 1999-07-22 | Silverbrook Research Pty Ltd | A method and apparatus (NPAGE02) |
| CN101673291A (en)* | 2009-10-28 | 2010-03-17 | 北京东方灵盾科技有限公司 | Method, system and device of data retrieval of patent documents |
| CN104217032B (en)* | 2014-09-28 | 2017-10-03 | 北京国双科技有限公司 | The processing method and processing device of database dimension |
| CN110837520A (en)* | 2019-10-10 | 2020-02-25 | 苏宁云计算有限公司 | Data processing method, platform and system |
- 2022
- 2022-09-20CNCN202211141746.5Apatent/CN115455149B/ennot_activeExpired - Fee Related
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7595485B1 (en)* | 2007-02-07 | 2009-09-29 | Thermo Finnigan Llc | Data analysis to provide a revised data set for use in peptide sequencing determination |
| CN105069109A (en)* | 2015-08-07 | 2015-11-18 | 北京思特奇信息技术股份有限公司 | Dilatation method and system of distributed database |
| CN108121712A (en)* | 2016-11-28 | 2018-06-05 | 北京国双科技有限公司 | A kind of keyword storage method and device |
| CN106844534A (en)* | 2016-12-30 | 2017-06-13 | 西安电子科技大学 | Towards the GeoHash coding methods by geographical spatial data one-dimensional of NoSQL databases |
| CN110929511A (en)* | 2018-09-04 | 2020-03-27 | 清华大学 | An intelligent matching method of personalized Chinese medicine diagnosis and treatment information and Chinese medicine information based on semantic similarity |
| CN110489494A (en)* | 2019-08-27 | 2019-11-22 | 中国工商银行股份有限公司 | Distributed data base on-line rapid estimation method and device |
| CN110597961A (en)* | 2019-09-18 | 2019-12-20 | 腾讯科技（深圳）有限公司 | Text category labeling method and device, electronic equipment and storage medium |
| CN111639153A (en)* | 2020-04-24 | 2020-09-08 | 平安国际智慧城市科技股份有限公司 | Query method and device based on legal knowledge graph, electronic equipment and medium |
| CN111552783A (en)* | 2020-04-30 | 2020-08-18 | 深圳前海微众银行股份有限公司 | Content analysis query method, device, equipment and computer storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115455149A (en) | 2022-12-09 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN113535962B (en) | Data warehouse-in method, device, electronic device, program product and storage medium | |
| CN111815432B (en) | Financial service risk prediction method and device | |
| CN104408584A (en) | Analysis method and system for transaction relevance | |
| CN110990520B (en) | Address coding method and device, electronic equipment and storage medium | |
| CN110704194B (en) | Method and system for managing memory data and maintaining data in memory | |
| CN112214617B (en) | Digital file management method and system based on block chain technology | |
| US9619657B2 (en) | Method and apparatus for storing redeem code, and method and apparatus for verifying redeem code | |
| CN109033295B (en) | Method and device for merging super-large data sets | |
| WO2018201980A1 (en) | Insurance policy service task allocation method, apparatus, computer device and storage device | |
| CN115455149B (en) | Database construction method based on coding query mode and application thereof | |
| CN114153898A (en) | Method, device and application for combing relationships among database tables | |
| WO2022142106A1 (en) | Text analysis method and apparatus, electronic device, and readable storage medium | |
| CN103714105A (en) | Method and devices for updating a database of a navigation device | |
| CA3145124A1 (en) | Machine learning enabled real time query handling system and method | |
| CN113312432A (en) | Associated information processing method and device, computer storage medium and electronic equipment | |
| US9213759B2 (en) | System, apparatus, and method for executing a query including boolean and conditional expressions | |
| CN109670153B (en) | Method and device for determining similar posts, storage medium and terminal | |
| US20200133583A1 (en) | Method, apparatus and computer program product for storing data | |
| CN114896197A (en) | Method, device and system for uniformly storing multi-format documents | |
| CN114818670A (en) | A double array-based address completion method and device, and storage medium | |
| CN118733717A (en) | File duplication checking method, device, equipment, storage medium and program product | |
| CN117313683A (en) | Metadata processing method, device, server and storage medium | |
| CN114281767B (en) | NTFS file formatting parameter analysis method, terminal equipment and storage medium | |
| KR102497634B1 (en) | Method and apparatus for compressing fastq data through character frequency-based sequence reordering | |
| CN115794861A (en) | Offline data query multiplexing method based on feature abstract and application thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee | Granted publication date:20230530 | |
| CF01 | Termination of patent right due to non-payment of annual fee |