Three-dimensional code integrated query method for compatible database and operating system thereof
By encoding small and large 3D volumes in the parent database, the problem of inaccurate data storage during the integration of compatible databases is solved, enabling fast and accurate data querying and flexible query methods, thereby improving the efficiency of database integration and retrieval.
Patent Information
- Application Number
- CN202211031547.9
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-08-26
- Publication Date
- 2026-01-16
- Estimated Expiration
- 2042-08-26
AI Technical Summary
Existing compatible databases cannot achieve accurate storage and fast retrieval of data from multiple sub-databases during the integration process. This results in a large amount of similar data information appearing during the retrieval process, making it impossible to form a unique 3D code for location and storage through the 3D code integration algorithm, and thus making it impossible to quickly and accurately obtain the required data.
The method of integrating and querying data using three-dimensional codes involves reserving storage space within the parent database, encoding the data from the sub-databases into small three-dimensional volumes, forming a large three-dimensional volume, and generating corresponding address codes. This enables unified integration and accurate querying of data, including steps such as input method encoding conversion, reverse encoding, address three-dimensional code comparison, and data extraction.
It achieves unified integration and precise storage of data from multiple sub-databases, enabling quick and accurate location and extraction of required data, improving the flexibility and efficiency of database queries, and facilitating direct interactive queries for users.
Smart Images

Figure HDA0003817327870000011 
Figure HDA0003817327870000021 
Figure HDA0003817327870000031
Abstract
Description
TECHNICAL FIELD
[0001] The present application relates to the technical field of data processing, in particular to a three-dimensional code integration query method for compatible databases and an operating system thereof. BACKGROUND
[0002] After human beings entered the era of information explosion, databases are needed in software development and application, network background servers or other data storage to store various data, so that the application end can query, extract, browse and use in real time and accurately. In order to meet the actual use requirements, the compatibility of the database needs to be considered. Due to the differences in built-in storage functions, system tables and SQL syntax in different databases, many application programs need to develop multiple sets of data manipulation languages to facilitate the integration and compatibility of small databases into large databases.
[0003] Referring to a multi-type database compatible method, device, equipment and storage medium of Chinese patent publication No. CN114706918A, by adopting the system based on the serial peripheral interface mechanism and the plug-in mode, the system can conveniently support the compatibility of domestic databases and non-relational databases. In addition, when some plug-ins fail during loading and use, it will not directly cause the system to be paralyzed. Furthermore, the loading and matching of the plug-ins can be dynamically managed according to the preset configuration file, so that the entire system does not need to have the execution ability of all databases, and can be loaded on demand, thereby making the system more lightweight. In this way, the business system shields the differences of various databases, and the business developers do not need to increase the development and maintenance cost for different databases, thereby solving the multi-database compatibility problem of the system.
[0004] Referring to a database compatible device of Chinese patent publication No. CN106649835B, by developing a general storage function library, only one set of data manipulation language is needed to compatible different database environments, thereby improving the development efficiency and compatibility of the application program. Even when the business logic is complex and a new general storage function library needs to be added, the general storage function library can be added in each database, thereby having good expansibility.
[0005] Based on the comprehensive analysis of the above reference patents, the following defects can be obtained:
[0006] 1) The existing compatible database in the integration process of other databases, after the data in the sub-database is configured into the parent database, generally a plurality of data in the sub-database is directly established in the parent database Storage space and matching archive address, resulting in a plurality of similar data information similar to the search term in the parent database search process, the developer or user needs to develop detailed information screening and searching, for example, the reference patent CN114706918A A kind of multi-type database compatible method, device, equipment, storage medium and CN106649835B database compatible device, Although it can realize the compatible configuration between multiple databases, but it cannot accurately store the integrated data, cannot realize the unified integration of data in multiple sub-databases through the three-dimensional code integration algorithm in the parent database, and form a precise unique three-dimensional code for positioning storage, cannot achieve the purpose of quickly and accurately obtaining the required data information in the database, thereby bringing great inconvenience to people's use.
[0007] 2) In the existing database search process, the same data cannot be accurately queried by different query methods, for example, a Chinese character needs to be queried, which can be queried according to the pinyin of the Chinese character, the strokes of the Chinese character or the corresponding English letters of the Chinese character. It cannot be accurately found by generating a unique three-dimensional code corresponding to these different query methods in the database, and it cannot achieve the purpose of making the entire database more flexible in the search process, thereby being very unfavorable to the data search of the database. SUMMARY
[0008] (I) The technical problem solved
[0009] In view of the deficiencies of the prior art, the present application provides a three-dimensional code integration query method and operation system for compatible database, which solves the problem that the existing compatible database in the integration process of other databases, after the data in the sub-database is configured into the parent database, generally a plurality of data in the sub-database is directly established in the parent database Storage space and matching archive address, resulting in a plurality of similar data information similar to the search term in the parent database search process, cannot accurately store the integrated data, cannot realize the unified integration of data in multiple sub-databases through the three-dimensional code integration algorithm in the parent database, and form a precise unique three-dimensional code for positioning storage, cannot achieve the purpose of quickly and accurately obtaining the required data information in the database.
[0010] (II) Technical scheme
[0011] The application aims to provide a three-dimensional code integrated query method and operation system for compatible databases to solve the above technical problems.
[0012] In the first aspect, the three-dimensional code integrated query method for compatible databases includes a three-dimensional code integrated method for databases and a data query method for databases integrated by the three-dimensional code integrated method, and can complete integration and query integration.
[0013] S1, reserving a storage space with a size of a prepared integrated sub-database in a mother database, and importing data of the prepared integrated sub-database into the mother database;
[0014] S2, encoding and storing the imported sub-database data in the mother database by a small three-dimensional body configuration algorithm to form a plurality of small three-dimensional bodies, and a plurality of small three-dimensional bodies forming a large three-dimensional body;
[0015] S3, encoding storage address information of each small three-dimensional body in the large three-dimensional body formed in step S2 by an encoding algorithm corresponding to the small three-dimensional body configuration algorithm, and generating an address code corresponding to a storage position of each small three-dimensional body in the large three-dimensional body, and completing the integration of the sub-database into the mother database after the address code is completed;
[0016] The three-dimensional code query method for databases specifically includes the following steps:
[0017] T1, inputting a text code or a digital code to be searched by an input method prepared by the mother database;
[0018] T2, converting the text code or the digital code to be searched input in step T1 into a three-dimensional code recognizable by a large three-dimensional body and a small three-dimensional body by a reverse code module of the mother database;
[0019] T3, comparing the three-dimensional code converted by the reverse code in step T2 with an address three-dimensional code in the mother database as a search target, and locking a corresponding large three-dimensional body, a small three-dimensional body and a storage position of corresponding data in the small three-dimensional body when the comparison is consistent;
[0020] T4, extracting the data stored in the corresponding storage position after the comparison is locked to the corresponding storage position, and feeding back the unrecognized data to an interactive interface when the storage position corresponding to the target three-dimensional code is not compared.
[0021] Preferably, the method for importing the data of the sub-database into the mother database in step S1 is data interface import or system input.
[0022] Preferably, the small three-dimensional body configuration algorithm in step S2 specifically includes the following steps:
[0023] A1, encode each storage location in the small three-dimensional body with a combination of letters aaa-zzz or a number 1-17576, one combination of letters or one number corresponds to a unique storage location in the small three-dimensional body;
[0024] A2, store the data in the imported sub-database in the storage location corresponding to the combination of letters or the number in the small three-dimensional body;
[0025] A3, convert the combination of letters or the number corresponding to each storage location in the small three-dimensional body in step A2 into a character code and a number code corresponding to the database operation input method through a conversion module.
[0026] Preferably, the small three-dimensional body is composed of: "line" composed of a-z, corresponding to the number 1-26, "face" composed of aa-z, corresponding to the number 1-676, "small three-dimensional body" composed of aaa-zzz, corresponding to the number 17576, that is, the total number of one to three letters is 17576+676+26=18278.
[0027] Preferably, the encoding algorithm in step S3 specifically includes the following steps:
[0028] B1, encode each storage location in the large three-dimensional body with a combination of letters aaa.aaa.aaa-zzz.zzz.zzz or a number 1 to 17576-1 to 17576-1 to 17576, 5.429504e12 numbers, one combination of letters or one number corresponds to a unique storage location in the large three-dimensional body;
[0029] B2, store the data in the small three-dimensional body in the storage location corresponding to the combination of letters or the number in the large three-dimensional body;
[0030] B3, convert the combination of letters or the number corresponding to each small three-dimensional body storage location in the large three-dimensional body in step B2 into a character code and a number code corresponding to the database operation input method through a conversion module.
[0031] Preferably, the large three-dimensional body is generated on the basis of the small three-dimensional body: one-dimensional aaa-zzz length is 17576, that is, the small three-dimensional body is sequentially unfolded, two-dimensional aaa.aaa-zzz.zzz corresponds to the number 17576*17576=308915776, three-dimensional body aaa.aaa.aaa-zzz.zzz.zzz corresponds to the cube of 17576 is 5.429504e12, that is, 5.429504e12 independent storage spaces.
[0032] In a second aspect, the application further provides an operating system for a three-dimensional code integrated query method of a compatible database, comprising a central processing module, a parent database, a database integration unit, a user interactive terminal and a data query unit, the central processing module is bidirectionally connected with the parent database, the database integration unit, the user interactive terminal and the data query unit respectively, and the output end of the user interactive terminal is connected with the input end of the database integration unit and the data query unit respectively, and the output end of the database integration unit and the data query unit is connected with the input end of the parent database.
[0033] The database integration unit comprises a data import module, an encoding storage module and a transcoding module, the data import module imports data in several sub-databases into the parent database, the encoding storage module is used for encoding and storing the data of the sub-databases imported into the parent database by a small three-dimensional body configuration algorithm, forming several small three-dimensional bodies, the several small three-dimensional bodies constitute a large three-dimensional body, and the storage address information of each small three-dimensional body in the large three-dimensional body is encoded by using an encoding algorithm corresponding to the small three-dimensional body configuration algorithm, and an address code corresponding to the storage position of each small three-dimensional body in the large three-dimensional body is generated.
[0034] The data query unit comprises an input module, an inverse transcoding module, a three-dimensional code comparison module and a data extraction module, the input module is used for inputting the text code or the digital code to be searched into the operating system, and the inverse transcoding module is used for transcoding the input text code or the digital code to be searched into a three-dimensional code recognizable by the large three-dimensional body and the small three-dimensional body.
[0035] Preferably, the transcoding module is used for transcoding the letter combination or the digital code corresponding to each storage position in the small three-dimensional body into the text code and the digital code corresponding to the database operation input method.
[0036] Preferably, the three-dimensional code comparison module is used for comparing the three-dimensional code transcoded reversely with the address three-dimensional code in the parent database, locking the corresponding large three-dimensional body and small three-dimensional body and the storage position of the corresponding data in the small three-dimensional body when the comparison is consistent, and the data extraction module is used for extracting the data stored in the comparison locked storage position to the interactive interface of the user interactive terminal.
[0037] In a third aspect, the application further provides a computer readable storage medium, characterized in that the computer readable storage medium stores machine executable instructions, when the machine executable instructions are called and run by a processor, the machine executable instructions make the processor run a three-dimensional code integrated query method for a compatible database.
[0038] (Three) beneficial effects
[0039] The application provides a three-dimensional code integrated query method for compatible databases and an operating system thereof.
[0040] (1) The three-dimensional code integrated query method for compatible databases and the operating system thereof adopt the theory of three-dimensional code positioning, implement stereoscopic storage positioning and fast query of endless massive ordered and disordered information, and establish a permanent corresponding relationship between letter combinations and numbers, which is the key and breakthrough point of building a new information structure. The application encodes small three-dimensional bodies and large three-dimensional bodies in the database, and the definition of the small three-dimensional bodies and the large three-dimensional bodies provides the most perfect technical support for the storage of various classified information and super-large information, realizes the overall correspondence between numbers and letters, and realizes the permanent correspondence between various languages and numbers on this basis, which is the significance of defining the small three-dimensional bodies and the large three-dimensional bodies. Therefore, multiple sub-databases are integrated into the parent database for unified coding and convenient accurate query in the later period, the data in the multiple sub-databases is uniformly integrated through the three-dimensional code integration algorithm in the parent database, and accurate and unique three-dimensional codes are formed for positioning storage, which achieves the purpose of quickly and accurately obtaining the required data information in the database, thereby greatly facilitating the use of people.
[0041] (2) The three-dimensional code integrated query method for compatible databases and the operating system thereof can realize accurate query of data through different query methods for the same data, can generate unique three-dimensional codes corresponding to the different query methods in the database for accurate query, and achieves the purpose of making the entire database more flexible in the query process, thereby being very beneficial to the data query of the database.
[0042] (3) The three-dimensional code integrated query method for compatible databases and the operating system thereof adopt the operating system matched with the integrated query method, can enable the developer or user to directly interact with the entire parent database, and the developer or user can directly and quickly and accurately query the required data through the interactive terminal, thereby greatly facilitating the use of people, and being simple, convenient and reliable. BRIEF DESCRIPTION OF DRAWINGS
[0043] Figure 1 It is a schematic diagram of the parent database model of the application;
[0044] Figure 2 It is a logic block diagram of the three-dimensional code integration for compatible databases of the application;
[0045] Figure 3 It is a logic block diagram of the three-dimensional code query for compatible databases of the application;
[0046] Figure 4 The structural principle block diagram of the operating system of the three-dimensional code integrated query method for the compatible database of the present application;
[0047] Figure 5 The first part of the operation interface diagram of the database of the application case two of the present application;
[0048] Figure 6 The second part of the operation interface diagram of the database of the application case two of the present application. DETAILED DESCRIPTION
[0049] The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application. Obviously, the described embodiments are only a part of the embodiments of the present application, rather than all the embodiments of the present application. Based on the embodiments in the present application, all other embodiments obtained by those skilled in the art without creative work fall within the scope of protection of the present application.
[0050] Please refer to Figures 1-6 The embodiments of the present application provide a technical solution: a three-dimensional code integrated query method for a compatible database, which includes a three-dimensional code integrated method of a database and a data query method of the database integrated by using the three-dimensional code integrated method, and can complete integration and query integration. The three-dimensional code integrated method of the database specifically includes the following steps:
[0051] S1, reserving a storage space with the size of the integrated sub-database in the mother database, and importing the data of the prepared sub-database into the mother database;
[0052] S2, encoding and storing the data of the sub-database imported into the mother database by using a small three-dimensional body configuration algorithm to form a plurality of small three-dimensional bodies, and a plurality of small three-dimensional bodies form a large three-dimensional body;
[0053] S3, encoding the storage address information of each small three-dimensional body in the large three-dimensional body formed in step S2 by using an encoding algorithm corresponding to the small three-dimensional body configuration algorithm, and generating an address code corresponding to the storage position of each small three-dimensional body in the large three-dimensional body. After the address code is completed, the sub-database is integrated into the mother database;
[0054] The three-dimensional code query method of the database specifically includes the following steps:
[0055] T1, inputting a text code or a digital code to be searched by using an input method prepared by the mother database;
[0056] T2, converting the text code or the digital code to be searched input in step T1 into a three-dimensional code recognizable by the large three-dimensional body and the small three-dimensional body by using a reverse code module of the mother database;
[0057] T3, the mother database reverses the three-dimensional code coded in step T2 as a retrieval target and compares it with the address three-dimensional code in the mother database, and when the comparison is consistent, the corresponding large three-dimensional body and small three-dimensional body and the storage position of the corresponding data in the small three-dimensional body are locked;
[0058] T4, after the comparison is locked to the corresponding storage position, the data stored in the storage position is extracted to the interactive interface, and when the storage position corresponding to the target three-dimensional code is not compared, the unrecognized data is fed back to the interactive interface.
[0059] In the embodiment of the application, the method for importing the data of the sub-database into the mother database in step S1 is data interface import or system entry.
[0060] In the embodiment of the application, the small three-dimensional body configuration algorithm in step S2 specifically includes the following steps:
[0061] A1, encode each storage position in the small three-dimensional body with 18278 numbers composed of letter combinations aaa-zzz or numbers 1-17576, and one letter combination or one number corresponds to a unique storage position in the small three-dimensional body;
[0062] A2, store the data in the imported sub-database to the storage position coded with the corresponding letter combination or number in the small three-dimensional body;
[0063] A3, convert the letter combination or number code corresponding to each storage position in the small three-dimensional body in step A2 into a character code and a number code corresponding to the database operation input method through a conversion module.
[0064] In the embodiment of the application, the composition of the small three-dimensional body: "line" composed of a-z, corresponding to numbers 1-26, "face" composed of aa-z, corresponding to numbers 1-676, "small three-dimensional body" composed of aaa-zzz, corresponding to the number 17576, that is, the total number of one to three letters is 17576+676+26=18278.
[0065] The small three-dimensional body is a powerful structure that realizes the digital positioning of Chinese characters and English, that is, a corresponding relationship between numbers, letters, English and Chinese characters is established, and the query of Chinese characters and English can be realized by using numbers or letters.
[0066] In the embodiment of the application, the encoding algorithm in step S3 specifically includes the following steps:
[0067] B1, 5.429504e12 number pairs encode each storage location in the large three-dimensional body, one letter combination or one number corresponds to a unique storage location in the large three-dimensional body;
[0068] B2, the data storage configuration of the small three-dimensional body is stored in the storage location corresponding to the letter combination or the number code in the large three-dimensional body;
[0069] B3, the letter combination or the number code corresponding to each small three-dimensional body storage location in the large three-dimensional body in step B2 is converted into the character code and the number code corresponding to the database operation input method through the conversion module.
[0070] In the embodiment of the application, the large three-dimensional body is generated on the basis of the small three-dimensional body: the length of one dimension aaa-zzz is 17576, that is, the small three-dimensional body is sequentially unfolded, the corresponding number of two dimensions aaa.aaa-zzz.zzz is 17576*17576=308915776, and the corresponding number of three dimensions aaa.aaa.aaa-zzz.zzz.zzz is the cube of 17576, which is 5.429504e12, that is, 5.429504e12 independent storage spaces, that is, there are 6 billion independent spaces, and the address of each space has various representation methods, one is the letter representation method such as: abb.bbc.dda, two is the number method such as: 12334-12346-17523, and three is any one number within 5429 billion, and 26 large three-dimensional bodies are increased for each letter, 676 large three-dimensional bodies are increased for each two letters, and so on.
[0071] The embodiment of the application also provides an operating system of a three-dimensional code integration query method for a compatible database, which comprises a central processing module, a mother database, a database integration unit, a user interactive terminal and a data query unit, the central processing module is bidirectionally connected with the mother database, the database integration unit, the user interactive terminal and the data query unit, the output end of the user interactive terminal is connected with the input end of the database integration unit and the data query unit, and the output end of the database integration unit and the data query unit is connected with the input end of the mother database.
[0072] The mother database is a three-dimensional library, the function of the three-dimensional library must be powerful, any language and character has been stored in the library to obtain permanent fixed digital positioning, and the related content in the horizontal direction is quickly integrated through the library operation, and the data can be quickly searched and extracted.
[0073] The database integration unit comprises a data import module, an encoding storage module and a transcoding module, the data import module imports data in a plurality of sub-databases into a parent database, the encoding storage module is configured to encode and store the data of the sub-databases imported into the parent database by using a small three-dimensional body configuration algorithm, form a plurality of small three-dimensional bodies, the plurality of small three-dimensional bodies form a large three-dimensional body, and an encoding algorithm corresponding to the small three-dimensional body configuration algorithm is used to encode the storage address information of each small three-dimensional body in the large three-dimensional body, and generate an address code corresponding to the storage position of each small three-dimensional body in the large three-dimensional body;
[0074] The data query unit comprises an input module, a reverse coding module, a three-dimensional code comparison module and a data extraction module, the input module is configured to input a text code or a digital code to be searched into an operating system, and the reverse coding module is configured to transcode the input text code or digital code to be searched into a three-dimensional code recognizable by the large three-dimensional body and the small three-dimensional body.
[0075] In the embodiment of the application, the transcoding module is configured to transcode the letter combination or the digital code corresponding to each storage position in the small three-dimensional body into a text code and a digital code corresponding to a database operation input method.
[0076] In the embodiment of the application, the three-dimensional code comparison module is configured to compare the three-dimensional code transcoded reversely with the address three-dimensional code in the parent database, lock the corresponding large three-dimensional body and small three-dimensional body and the storage position of the corresponding data in the small three-dimensional body when the comparison is consistent, and the data extraction module is configured to extract the data stored in the comparison-locked storage position to an interactive interface of a user interactive terminal.
[0077] The following introduces a positioning application case:
[0078] Case one: input Zhang Guojun, the reverse coding has a corresponding code zdx.gnl.jrp corresponding to a digital address; the sound shape code is 8156-1879-3101, and the sound sequence code is 8156-2153-3258. For example, the address of the input sentence I like it is 6766-8078-7554.
[0079] Case two: as shown in Figure 5 and 6 , the three-dimensional search database address information composed of letters, Chinese characters and numbers is used to mark each storage data in the database, so as to facilitate the user to search, and the storage information corresponding to the coding information composed of letters, Chinese characters and numbers in the case is a word, a district name and website information. Figure 5 As shown in the above table, take "abo" as an example, find "abo", the corresponding word is "about", the district name is "Qiaoxi District", and the corresponding website information is "national expressway query website", and clicking "abo" can open the storage space corresponding to "abo".Figure 6 It can be known that the storage space stores the website corresponding to the website address and the three-dimensional code "15649wgs" corresponding to the abo, which is the full storage related to the abo.
[0080] The embodiment of the present application further provides a computer readable storage medium, which stores computer executable instructions, and when the computer executable instructions are called and executed by a processor, the computer executable instructions cause the processor to execute the three-dimensional code integration query method for the compatible database.
[0081] The apparatus provided by the embodiment of the present application can be specific hardware on a device or software or firmware installed on the device, etc. The apparatus provided by the embodiment of the present application has the same implementation principle and generated technical effects as the foregoing method embodiment, and for brevity of description, the part not mentioned in the apparatus embodiment can be referred to the corresponding content in the foregoing method embodiment. It can be clearly understood by those skilled in the art that, for convenience and brevity of description, the specific working process of the system, apparatus and unit described above can be referred to the corresponding process in the foregoing method embodiment, which will not be repeated here.
[0082] If the functions are realized in the form of software function units and sold or used as independent products, the functions can be stored in a computer readable storage medium. Based on such understanding, the technical solutions of the present application or the part of the technical solutions which essentially contribute to the prior art or the part of the technical solutions can be embodied in the form of software product, and the computer software product is stored in a storage medium, including a plurality of instructions for causing a computer device (which can be a personal computer, a server or a network device, etc.) to execute all or part of the steps of the method of each embodiment of the present application. The foregoing storage medium includes a U disk, a mobile hard disk, a read-only memory (ROM), a random access memory (RAM), a magnetic disk or an optical disk and various media which can store program codes.
[0083] Meanwhile, the contents not described in detail in the specification all belong to the prior art known to those skilled in the art.
[0084] It is to be understood that the terminology used herein is for the purpose of describing particular embodiments only and is not intended to be limiting; it is not intended to exclude myriad other embodiments of the present application that other inventors can develop based on the same general inventive concepts embodied by the described embodiments. That is, although the present application is described in terms of particular embodiments and illustrative figures, it should be apparent that the scope of the present application is not limited to these specific embodiments.
[0085] While the embodiments of the application have been shown and described herein, it will be understood by those skilled in the art that many changes, modifications, substitutions and alterations to these embodiments can be made without departing from the principles and spirits of the application, and it is intended that the scope of the application be limited solely by the scope of the appended claims and the equivalents thereof.
Claims
1. A method for integrating query of three-dimensional code for compatible database, characterized in that: The application relates to a database three-dimensional code integration method and a database three-dimensional code query method. S1, reserving storage space with the size of a sub-database to be integrated in a mother database, and importing data of the sub-database to be integrated into the mother database; S2, encoding and storing the data of the sub-database imported into the mother database by using a small three-dimensional body configuration algorithm to form a plurality of small three-dimensional bodies, and the plurality of small three-dimensional bodies forming a large three-dimensional body; S3, encoding the storage address information of each small three-dimensional body in the large three-dimensional body formed in the step S2 by using an encoding algorithm corresponding to the small three-dimensional body configuration algorithm, and generating address codes corresponding to the storage positions of each small three-dimensional body in the large three-dimensional body, and completing the integration of the sub-database into the mother database after the address codes are completed; The database three-dimensional code query method specifically comprises the following steps: T1, inputting a character code or a digital code to be searched by using an input method provided by the mother database; T2, converting the character code or the digital code to be searched input in the step T1 into a three-dimensional code recognizable by a large three-dimensional body and a small three-dimensional body by using a reverse code module of the mother database; T3, comparing the three-dimensional code converted in the step T2 with address three-dimensional codes in the mother database as a search target, locking the storage positions of corresponding large three-dimensional bodies, small three-dimensional bodies and data in the small three-dimensional bodies when the comparison is consistent; T4, extracting the data stored in the storage positions after the comparison is locked to the corresponding storage positions, and feeding back the data not recognized to an interactive interface when the storage positions corresponding to the target three-dimensional code are not compared.
2. The 3D code integrated query method for compatible databases according to claim 1, characterized in that: The method for importing the data of the sub-database into the mother database in the step S1 is data interface import or system input.
3. The 3D code integrated query method for compatible databases according to claim 1, characterized in that: The small three-dimensional body configuration algorithm in the step S2 specifically comprises the following steps: A1, encoding each storage position in the small three-dimensional body by using 18278 numbers composed of letter combinations aaa-zzz or numbers 1-17576, and one letter combination or one number corresponding to only one storage position in the small three-dimensional body; A2, storing and configuring the data in the imported sub-database to the storage positions of the corresponding letter combinations or number codes in the small three-dimensional body; A3, converting the letter combinations or number codes corresponding to each storage position in the small three-dimensional body in the step A2 into character codes and digital codes corresponding to a database operation input method by using a conversion module.
4. The 3D code integrated query method for compatible databases according to claim 3, characterized in that: The small three-dimensional body is composed of "lines" composed of a-z, corresponding to numbers 1-26, "surfaces" composed of aa-z, corresponding to numbers 1-676, and "small three-dimensional bodies" composed of aaa-zzz, corresponding to numbers 17576, that is, the total corresponding numbers of one to three letters are 17576+676+26=18278.
5. The 3D code integrated query method for compatible databases according to claim 1, characterized in that: The encoding algorithm in the step S3 specifically comprises the following steps: B1, 5.429504e12 number pairs encode each storage location in the large three-dimensional body, one letter combination or one number corresponds to a unique storage location in the large three-dimensional body; B2, the data storage configuration of the small three-dimensional body is stored in the storage location corresponding to the letter combination or the number code in the large three-dimensional body; B3, the letter combination or the number code corresponding to each small three-dimensional body storage location in the large three-dimensional body in step B2 is converted into the character code and the number code corresponding to the database operation input method by the conversion module.
6. The 3D code integrated query method for compatible databases according to claim 5, characterized in that: The large three-dimensional body is generated on the basis of the small three-dimensional body: one dimension aaa-zzz length is 17576, that is, the small three-dimensional body is sequentially unfolded, two dimensions aaa.aaa-zzz.zzz correspond to the number 17576*17576=308915776, and three dimensions aaa.aaa.aaa-zzz.zzz.zzz correspond to the third power of 17576, which is 5.429504e12, that is, 5.429504e12 independent storage spaces.
7. An operating system for implementing the method of claim 1-6 for integrated query of 3D codes in a compatible database, characterized by: The central processing module, the mother database, the database integration unit, the user interactive terminal and the data query unit are included, the central processing module is bidirectionally connected with the mother database, the database integration unit, the user interactive terminal and the data query unit respectively, and the output end of the user interactive terminal is connected with the input end of the database integration unit and the data query unit respectively, and the output end of the database integration unit and the data query unit is connected with the input end of the mother database; The database integration unit includes a data import module, an encoding storage module and a conversion module, the data import module imports the data in the mother database from several sub-databases, and the encoding storage module is used for encoding and storing the sub-database data imported into the mother database by the small three-dimensional body configuration algorithm, forming several small three-dimensional bodies, several small three-dimensional bodies constitute a large three-dimensional body, and the storage address information of each small three-dimensional body in the large three-dimensional body is encoded by using the encoding algorithm corresponding to the small three-dimensional body configuration algorithm, and the address code corresponding to the storage location of each small three-dimensional body in the large three-dimensional body is generated; The data query unit includes an input module, an inverse conversion module, a three-dimensional code comparison module and a data extraction module, the input module is used for inputting the character code or the number code to be searched into the operating system, and the inverse conversion module is used for converting the input character code or the number code to be searched into the three-dimensional code which can be recognized by the large three-dimensional body and the small three-dimensional body.
8. The operating system for the 3D code integrated query method of the compatible database according to claim 7, wherein: The conversion module is used for converting the letter combination or the number code corresponding to each storage location in the small three-dimensional body into the character code and the number code corresponding to the database operation input method.
9. The operating system for the 3D code integrated query method of the compatible database according to claim 7, wherein: The three-dimensional code comparison module is used for comparing the address three-dimensional code in the parent database with the reverse-coded three-dimensional code as a search target, locking the corresponding large three-dimensional body and small three-dimensional body and the storage position of the corresponding data in the small three-dimensional body when the comparison is consistent, and the data extraction module is used for extracting the data stored in the comparison locking storage position to the interactive interface of the user interactive terminal.
10. A computer-readable storage medium, characterized in that, The computer readable storage medium stores machine executable instructions, when the machine executable instructions are called and run by the processor, the machine executable instructions cause the processor to run the method in any one of claims 1-6.
Citation Information
Patent Citations
Database compatible device
CN106649835B
Multi-type database compatibility method and device, equipment and storage medium
CN114706918A
Tile type large file organization storage method of three-dimensional model data
CN105956165A
Stock market information resource integration and query service platform
CN111369356A