CN112860691A - Method and device for sorting and tabulating, electronic equipment and storage medium - Google Patents
Method and device for sorting and tabulating, electronic equipment and storage medium Download PDFInfo
- Publication number
- CN112860691A CN112860691A CN202110118155.5A CN202110118155A CN112860691A CN 112860691 A CN112860691 A CN 112860691A CN 202110118155 A CN202110118155 A CN 202110118155A CN 112860691 A CN112860691 A CN 112860691A
- Authority
- CN
- China
- Prior art keywords
- database
- sql statement
- databases
- sql
- sub
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
- G06F16/2255—Hash tables
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2228—Indexing structures
- G06F16/2272—Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Software Systems (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the invention provides a method and a device for database and table division, electronic equipment and a storage medium. The method for dividing the database and the table comprises the following steps: the method comprises the steps of obtaining an SQL statement sent by a client, analyzing the SQL statement according to a pre-obtained table splitting rule of a database, and obtaining a target database in a plurality of databases accessed by the SQL statement, wherein the databases are built in advance by adopting a preset table splitting algorithm according to business requirements; sending the SQL statement to the target database so that the target database returns data corresponding to the SQL statement; and sending the data to the client. The embodiment of the invention can complete the database and table division under the condition of not changing the original service logic and not modifying the original service code, thereby ensuring the stability and the expandability of the service system.
Description
Technical Field
The invention relates to the technical field of databases, in particular to a method and a device for database and table division, electronic equipment and a storage medium.
Background
With the continuous increase of service system data, the single-table data volume becomes larger and larger. The single table and the single library cannot meet the requirements of services and data volume. Currently, the operation of sorting and tabulating is completed by modifying the code. Such invasive modification of code may result in unavailability of the original business system and violate the software design switching principle.
Disclosure of Invention
To solve the problems in the prior art, embodiments of the present invention provide a method and an apparatus for database and table partitioning, an electronic device, and a storage medium.
Specifically, the embodiment of the invention provides the following technical scheme:
in a first aspect, an embodiment of the present invention provides a method for sorting databases and tables, including:
the method comprises the steps of obtaining an SQL statement sent by a client, analyzing the SQL statement according to a pre-obtained table splitting rule of a database, and obtaining a target database in a plurality of databases accessed by the SQL statement, wherein the databases are built in advance by adopting a preset table splitting algorithm according to business requirements;
sending the SQL statement to the target database so that the target database returns data corresponding to the SQL statement;
and sending the data to the client.
Further, the method also comprises the step of establishing the library and table dividing rule, and specifically comprises the following steps:
and configuring the sub-database and sub-table rules by adopting the sub-table algorithm according to the service requirements of the service system.
Further, the sub-table algorithm comprises a Hash sub-table algorithm, a natural month sub-table algorithm or a date sub-table algorithm.
Further, the sub-library and sub-table rules include the mapping relationship between the tables and the library, the number of the sub-tables, the mapping relationship between the sub-tables of the splitting rules of the tables and the sub-library, and the number of the sub-tables.
Further, the acquiring the SQL statement sent by the client, analyzing the SQL statement according to a pre-obtained database partitioning rule, and acquiring a target database in a plurality of databases accessed by the SQL statement, includes:
analyzing the SQL statement to acquire the name of a database and the name of a data table accessed by the SQL statement;
and obtaining the names of the databases and the target databases corresponding to the names of the data tables in the databases based on the database-dividing and table-dividing rules.
Further, the analyzing the SQL statement includes a slicing analysis or a routing analysis.
In a second aspect, an embodiment of the present invention further provides a device for sorting and tabulating libraries, including:
the system comprises an acquisition module, a database management module and a database management module, wherein the acquisition module is used for acquiring SQL sentences sent by a client, analyzing the SQL sentences according to pre-acquired database partitioning rules and acquiring target databases in a plurality of databases accessed by the SQL sentences, and the databases are pre-established by adopting a preset partitioning algorithm according to business requirements;
the mapping module is used for sending the SQL statement to the target database so that the target database returns data corresponding to the SQL statement;
and the feedback module is used for sending the data to the client.
In a third aspect, an embodiment of the present invention further provides an electronic device, including a memory, a processor, and a computer program stored on the memory and executable on the processor, where the processor implements the steps of the method for performing banking and table division according to the first aspect when executing the program.
In a fourth aspect, the present invention further provides a non-transitory computer-readable storage medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the steps of the method for sub-warehousing and sub-listing according to the first aspect.
In a fifth aspect, an embodiment of the present invention further provides a computer program product, where the computer program product includes a computer program, and when the computer program is executed by a processor, the computer program implements the steps of the method for performing banking and spreadsheet according to the first aspect.
According to the technical scheme, the method, the device, the electronic equipment and the storage medium for splitting the database and the table provided by the embodiment of the invention have the advantages that the service serving as the middleware is constructed, the table splitting rule is configured by adopting a table splitting algorithm, the SQL sentence sent by the application program is intercepted, the SQL sentence is analyzed according to the table splitting rule of the database, the analyzed SQL sentence is sent to the real database at the rear end, the result is returned to the user, the database splitting can be completed under the condition that the original service logic is not changed and the original service code is not modified, and the stability and the expandability of a service system are ensured.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, and it is obvious that the drawings in the following description are some embodiments of the present invention, and those skilled in the art can also obtain other drawings according to the drawings without creative efforts.
Fig. 1 is a flowchart of a method for sorting and tabulating libraries according to an embodiment of the present invention;
FIG. 2 is a diagram illustrating a method for sorting and tabulating a database according to an embodiment of the present invention;
fig. 3 is a block diagram of a device for sorting and tabulating libraries according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are some, but not all, embodiments of the present invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
Fig. 1 shows a flowchart of a method for sorting and tabulating libraries according to an embodiment of the present invention. As shown in fig. 1, the method for sorting libraries and tables provided in the embodiment of the present invention includes the following steps:
step 101: the method comprises the steps of obtaining SQL sentences sent by a client, analyzing the SQL sentences according to pre-obtained database partitioning rules, and obtaining target databases in a plurality of databases accessed by the SQL sentences, wherein the databases are built in advance by adopting a preset partitioning algorithm according to business requirements.
The method may be performed by a built middleware, as shown in fig. 2, for example: and constructing a standard JAVA service as a middleware, and independently starting the JAVA service to realize the method of the embodiment of the invention.
Before step 101 is executed, firstly, a step of establishing the sub-library and sub-table rule is required, specifically:
and configuring the sub-database and sub-table rules by adopting the sub-table algorithm according to the service requirements of the service system. The sub-table algorithm includes, but is not limited to, a Hash sub-table algorithm, a natural month sub-table algorithm, or a date sub-table algorithm. The sub-database and sub-table rules include, but are not limited to, the mapping relationship between tables and databases, the number of sub-tables, the mapping relationship between sub-tables of the splitting rules of tables and sub-databases, and the number of sub-tables.
In particular, when the data size of an application is large, the operation speed is seriously influenced by using a single table and a single library for storage, for example, myisam storage of mysql is tested, the access speed of mysql is high when the data size is below 200w, but if the data size exceeds 200w, the access speed is sharply reduced, the access speed of webapp is influenced, and if the data size is too large, the system is quite unstable and mysql service is easily hung up if the single table is used for storage. So when the amount of data exceeds 200w, the system engineer is advised to consider the sublist as well.
Sorting/sorting according to natural time:
if the data amount of an application reaches about 200w after one year, the data of one year can be considered to be stored as a table or a library, for example, the table name is app, and the data of 2010 is app _2010 and app _ 2011; if the data amount reaches about 200w in a month, it can be divided into months, app _2010_01 and app _2010_ 02.
According to the number type, hash table/database division:
if the information of the user is to be stored, the registration amount of the application is large, and the single table cannot meet the storage requirement, the hash can be performed by using the number of the user, usually by using a remainder operation, if the information of the user is to be stored in 30 tables, then 1% 30 of the users with the number of 1 is 1, and then the user exists in the user _01 table, and if the number of the user is 500, then 500% 30 is 20, then the information of the user is stored in the table of the user _ 20.
Tabulation/binning by md5 value:
if the file uploaded by the user is stored, if the uploading amount is large, the bottleneck problem of the system is caused, and after experiments, if more than 200 files exist in one folder, the browsing efficiency of the files is reduced, and of course, the file does not belong to the scope discussed herein, and the block is also subjected to the hashing operation. The file name can be used for md5 or the md5 check value of the file, the first 5 bits of md5 can be used for hash, so that at most 5^ 3125 tables can be obtained, and each time the file is stored, the first 5 bits of the md5 value of the file name can be used for determining the table in which the file is stored.
In an embodiment of the present invention, acquiring an SQL statement sent by a client, analyzing the SQL statement according to a pre-obtained sub-database table-splitting rule, and acquiring a target database in a plurality of databases accessed by the SQL statement, includes: analyzing the SQL statement to acquire the name of a database and the name of a data table accessed by the SQL statement; and obtaining the names of the databases and the target databases corresponding to the names of the data tables in the databases based on the database-dividing and table-dividing rules.
In the above example, analyzing the SQL statement includes, but is not limited to, fragmentation analysis or routing analysis.
Step 102: and sending the SQL statement to the target database so that the target database returns data corresponding to the SQL statement.
Step 103: and sending the data to the client. The client is, for example, an application APP installed on the terminal. The terminal is but not limited to a PC or the like.
In specific application, a standard JAVA service is constructed as a middleware and is required to be started independently;
defining a sub-table algorithm;
configuring a database and table dividing rule according to the service requirement by adopting a table dividing algorithm;
intercepting SQL sentences sent by an application program, and analyzing the SQL sentences according to the database-partitioning rules;
sending the analyzed SQL statement to a real database at the back end;
and processing the result returned by the back end and returning the result to the user.
In one embodiment of the invention, the sub-table algorithm may be configured into rule.
In an embodiment of the present invention, the library and table partitioning rule may be configured into schema.
According to the method for database and table division provided by the embodiment of the invention, by constructing the service serving as the middleware, the database and table division rule is configured by adopting a table division algorithm, the SQL sentence sent by the application program is intercepted, the SQL sentence is analyzed according to the database and table division rule, the analyzed SQL sentence is sent to the real database at the rear end, and the result is returned to the user, so that the database and table division can be completed under the condition that the original service logic is not changed and the original service code is not modified, and the stability and the expandability of a service system are ensured.
Fig. 3 is a schematic structural diagram illustrating a device for sorting and tabulating libraries according to an embodiment of the present invention. As shown in fig. 3, the device for sorting and tabulating the database provided by this embodiment includes: an acquisition module 310, a mapping module 320, and a feedback module 330, wherein:
the acquiring module 310 is configured to acquire an SQL statement sent by a client, analyze the SQL statement according to a pre-obtained table partitioning rule of a sub-database, and acquire a target database in a plurality of databases accessed by the SQL statement, where the plurality of databases are established in advance by using a preset table partitioning algorithm according to a business requirement;
a mapping module 320, configured to send the SQL statement to the target database, so that the target database returns data corresponding to the SQL statement;
a feedback module 330, configured to send the data to the client.
According to the device for database and table division provided by the embodiment of the invention, by constructing a service serving as a middleware, configuring a database and table division rule by adopting a table division algorithm, intercepting an SQL sentence sent by an application program, analyzing the SQL sentence according to the database and table division rule, sending the analyzed SQL sentence to a real database at the rear end, and returning a result to a user, the database and table division can be completed under the condition that the original service logic is not changed and the original service code is not modified, and the stability and the expandability of a service system are ensured.
The library and table dividing device provided by the embodiment of the invention can be used for executing the library and table dividing method in the embodiment, and has similar working principle and beneficial effect, so detailed description is omitted here, and specific contents can be referred to the description of the embodiment.
In this embodiment, it should be noted that each module in the apparatus according to the embodiment of the present invention may be integrated into a whole or may be separately disposed. The modules can be combined into one module, and can also be further split into a plurality of sub-modules.
Based on the same inventive concept, another embodiment of the present invention provides an electronic device, which specifically includes the following components, with reference to fig. 4: a processor 301, a memory 302, a communication interface 303, and a communication bus 304;
the processor 301, the memory 302 and the communication interface 303 complete mutual communication through the communication bus 304;
the processor 301 is configured to call a computer program in the memory 302, and the processor implements all the steps of the above method for sorting and sorting the database and the table when executing the computer program, for example, the processor implements the following processes when executing the computer program: the method comprises the steps of obtaining an SQL statement sent by a client, analyzing the SQL statement according to a pre-obtained table splitting rule of a database, and obtaining a target database in a plurality of databases accessed by the SQL statement, wherein the databases are built in advance by adopting a preset table splitting algorithm according to business requirements; sending the SQL statement to the target database so that the target database returns data corresponding to the SQL statement; and sending the data to the client.
It will be appreciated that the detailed functions and extended functions that the computer program may perform may be as described with reference to the above embodiments.
Based on the same inventive concept, another embodiment of the present invention provides a non-transitory computer-readable storage medium, on which a computer program is stored, which when executed by a processor implements all the steps of the method for sub-warehousing and sub-listing described above, for example, the processor implements the following processes when executing the computer program: the method comprises the steps of obtaining an SQL statement sent by a client, analyzing the SQL statement according to a pre-obtained table splitting rule of a database, and obtaining a target database in a plurality of databases accessed by the SQL statement, wherein the databases are built in advance by adopting a preset table splitting algorithm according to business requirements; sending the SQL statement to the target database so that the target database returns data corresponding to the SQL statement; and sending the data to the client.
It will be appreciated that the detailed functions and extended functions that the computer program may perform may be as described with reference to the above embodiments.
Based on the same inventive concept, another embodiment of the present invention provides a computer program product, which includes a computer program, when being executed by a processor, the computer program implements all the steps of the method for sub-base and sub-table, for example, when the processor executes the computer program, the processor implements the following processes: the method comprises the steps of obtaining an SQL statement sent by a client, analyzing the SQL statement according to a pre-obtained table splitting rule of a database, and obtaining a target database in a plurality of databases accessed by the SQL statement, wherein the databases are built in advance by adopting a preset table splitting algorithm according to business requirements; sending the SQL statement to the target database so that the target database returns data corresponding to the SQL statement; and sending the data to the client.
It will be appreciated that the detailed functions and extended functions that the computer program may perform may be as described with reference to the above embodiments.
In addition, the logic instructions in the memory may be implemented in the form of software functional units and may be stored in a computer readable storage medium when sold or used as a stand-alone product. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-Only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
The above-described embodiments of the apparatus are merely illustrative, and the units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of the embodiment of the present invention. One of ordinary skill in the art can understand and implement it without inventive effort.
Through the above description of the embodiments, those skilled in the art will clearly understand that each embodiment can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware. Based on such understanding, the above technical solutions may be essentially or partially implemented in the form of software products, which may be stored in a computer-readable storage medium, such as ROM/RAM, magnetic disk, optical disk, etc., and include instructions for causing a computer device (which may be a personal computer, a server, or a network device, etc.) to execute the traffic auditing method according to various embodiments or some parts of embodiments.
Moreover, in the present invention, relational terms such as first and second, and the like may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
Furthermore, in the present disclosure, reference to the description of the terms "one embodiment," "some embodiments," "an example," "a specific example," or "some examples" or the like means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the present disclosure. In this specification, the schematic representations of the terms used above are not necessarily intended to refer to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, various embodiments or examples and features of different embodiments or examples described in this specification can be combined and combined by one skilled in the art without contradiction.
Finally, it should be noted that: the above examples are only intended to illustrate the technical solution of the present invention, but not to limit it; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (10)
1. A method for database and table division is characterized by comprising the following steps:
the method comprises the steps of obtaining an SQL statement sent by a client, analyzing the SQL statement according to a pre-obtained table splitting rule of a database, and obtaining a target database in a plurality of databases accessed by the SQL statement, wherein the databases are built in advance by adopting a preset table splitting algorithm according to business requirements;
sending the SQL statement to the target database so that the target database returns data corresponding to the SQL statement;
and sending the data to the client.
2. The method for sorting and tabulating according to claim 1, further comprising the step of establishing the sorting and tabulating rule, specifically:
and configuring the sub-database and sub-table rules by adopting the sub-table algorithm according to the service requirements of the service system.
3. The method for bank and table division according to claim 1 or 2, wherein the table division algorithm comprises a Hash table division algorithm, a natural month table division algorithm or a date table division algorithm.
4. The method for splitting the database and the table according to claim 1 or 2, wherein the rules for splitting the database and the table comprise mapping relationships between tables and the database, the number of the tables, mapping relationships between tables of splitting rules of the table and the database, and the number of the tables.
5. The method according to claim 1, wherein the obtaining the SQL statements sent by the client, analyzing the SQL statements according to pre-obtained rules for partitioning the database, and obtaining the target database in the multiple databases accessed by the SQL statements comprises:
analyzing the SQL statement to acquire the name of a database and the name of a data table accessed by the SQL statement;
and obtaining the names of the databases and the target databases corresponding to the names of the data tables in the databases based on the database-dividing and table-dividing rules.
6. The method according to claim 5, wherein the analyzing the SQL statement comprises a slicing analysis or a routing analysis.
7. An apparatus for sorting and tabulating, comprising:
the system comprises an acquisition module, a database management module and a database management module, wherein the acquisition module is used for acquiring SQL sentences sent by a client, analyzing the SQL sentences according to pre-acquired database partitioning rules and acquiring target databases in a plurality of databases accessed by the SQL sentences, and the databases are pre-established by adopting a preset partitioning algorithm according to business requirements;
the mapping module is used for sending the SQL statement to the target database so that the target database returns data corresponding to the SQL statement;
and the feedback module is used for sending the data to the client.
8. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the steps of the method of banking and sub-listing according to any one of claims 1 to 6 when executing the program.
9. A non-transitory computer readable storage medium, on which a computer program is stored, which, when being executed by a processor, performs the steps of the method of banking and sub-listing according to any one of claims 1 to 6.
10. A computer program product comprising a computer program, characterized in that the computer program, when being executed by a processor, carries out the steps of the method of banking and tabulation according to any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110118155.5A CN112860691A (en) | 2021-01-28 | 2021-01-28 | Method and device for sorting and tabulating, electronic equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110118155.5A CN112860691A (en) | 2021-01-28 | 2021-01-28 | Method and device for sorting and tabulating, electronic equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112860691A true CN112860691A (en) | 2021-05-28 |
Family
ID=75987606
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110118155.5A Pending CN112860691A (en) | 2021-01-28 | 2021-01-28 | Method and device for sorting and tabulating, electronic equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112860691A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113407519A (en) * | 2021-07-17 | 2021-09-17 | 广州汇思信息科技股份有限公司 | Adaptation device and device of database, computer equipment and storage medium |
| CN113407547A (en) * | 2021-07-17 | 2021-09-17 | 广州汇思信息科技股份有限公司 | Adaptation device and device of database, computer equipment and storage medium |
| CN113810466A (en) * | 2021-08-12 | 2021-12-17 | 北京科东电力控制系统有限责任公司 | Middleware for multi-source heterogeneous data, system and method applying middleware |
| CN114116777A (en) * | 2021-12-06 | 2022-03-01 | 深圳前海微众银行股份有限公司 | Data processing method, device, equipment and storage medium |
| CN118093726A (en) * | 2024-04-22 | 2024-05-28 | 北京国电通网络技术有限公司 | Database splitting method and device based on region |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107423387A (en) * | 2017-07-19 | 2017-12-01 | 北京北信源软件股份有限公司 | The method and apparatus of table is divided in a kind of point storehouse based on middleware |
| CN111209280A (en) * | 2019-12-31 | 2020-05-29 | 上海钧正网络科技有限公司 | Database and table dividing method and device |
-
2021
- 2021-01-28 CN CN202110118155.5A patent/CN112860691A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107423387A (en) * | 2017-07-19 | 2017-12-01 | 北京北信源软件股份有限公司 | The method and apparatus of table is divided in a kind of point storehouse based on middleware |
| CN111209280A (en) * | 2019-12-31 | 2020-05-29 | 上海钧正网络科技有限公司 | Database and table dividing method and device |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113407519A (en) * | 2021-07-17 | 2021-09-17 | 广州汇思信息科技股份有限公司 | Adaptation device and device of database, computer equipment and storage medium |
| CN113407547A (en) * | 2021-07-17 | 2021-09-17 | 广州汇思信息科技股份有限公司 | Adaptation device and device of database, computer equipment and storage medium |
| CN113810466A (en) * | 2021-08-12 | 2021-12-17 | 北京科东电力控制系统有限责任公司 | Middleware for multi-source heterogeneous data, system and method applying middleware |
| CN113810466B (en) * | 2021-08-12 | 2024-04-09 | 北京科东电力控制系统有限责任公司 | Middleware for multi-source heterogeneous data, system and method for applying middleware |
| CN114116777A (en) * | 2021-12-06 | 2022-03-01 | 深圳前海微众银行股份有限公司 | Data processing method, device, equipment and storage medium |
| CN118093726A (en) * | 2024-04-22 | 2024-05-28 | 北京国电通网络技术有限公司 | Database splitting method and device based on region |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112860691A (en) | Method and device for sorting and tabulating, electronic equipment and storage medium | |
| US11068439B2 (en) | Unsupervised method for enriching RDF data sources from denormalized data | |
| US10180992B2 (en) | Atomic updating of graph database index structures | |
| CN107506383B (en) | Audit data processing method and computer equipment | |
| US9229971B2 (en) | Matching data based on numeric difference | |
| CN109313640B (en) | Method and system for database optimization | |
| US20090024654A1 (en) | Multi-value property storage and query support | |
| US20170255708A1 (en) | Index structures for graph databases | |
| US11100152B2 (en) | Data portal | |
| CN109885585A (en) | Support the distributed data base system and method for storing process, trigger and view | |
| CN104050225A (en) | View variants in database schema mapping | |
| CN109753573B (en) | Processing method and device for constructing preset model based on graph database | |
| CN108228875A (en) | Daily record analysis method and device based on perfect Hash | |
| US20140289268A1 (en) | Systems and methods of rationing data assembly resources | |
| CN108255959A (en) | Data query method and device in a kind of Redis | |
| CN106886568A (en) | One kind point table method, device and electronic equipment | |
| RU2711717C1 (en) | Recruitment system using machine learning and downsizing of multidimensional data and a method for recruiting personnel using machine learning and lowering the dimension of multidimensional data | |
| CN110720097A (en) | Functional equivalence of tuples and edges in graph databases | |
| KR100906454B1 (en) | Database log data management apparatus and method thereof | |
| CN111488263B (en) | Method and device for analyzing journals in MySQL database | |
| US20100268723A1 (en) | Method of partitioning a search query to gather results beyond a search limit | |
| US20150032749A1 (en) | Method of creating classification pattern, apparatus, and recording medium | |
| US10311049B2 (en) | Pattern-based query result enhancement | |
| CN113591447A (en) | Data table creating method, device, equipment and storage medium | |
| CN117009430A (en) | Data management method, device, storage medium and electronic equipment |
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 |