CN112184204A - Data operation method and system based on data routing rule and database and table division - Google Patents

Data operation method and system based on data routing rule and database and table division Download PDF

Info

Publication number
CN112184204A
CN112184204A CN202011065758.5A CN202011065758A CN112184204A CN 112184204 A CN112184204 A CN 112184204A CN 202011065758 A CN202011065758 A CN 202011065758A CN 112184204 A CN112184204 A CN 112184204A
Authority
CN
China
Prior art keywords
transaction
database
gateway
pos
data
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
Application number
CN202011065758.5A
Other languages
Chinese (zh)
Inventor
张光阳
郑咏华
赵强
吴海波
郭倩
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Yinsheng Payment Service Co Ltd
Original Assignee
Yinsheng Payment Service Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Yinsheng Payment Service Co Ltd filed Critical Yinsheng Payment Service Co Ltd
Priority to CN202011065758.5A priority Critical patent/CN112184204A/en
Publication of CN112184204A publication Critical patent/CN112184204A/en
Pending legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q20/00Payment architectures, schemes or protocols
    • G06Q20/08Payment architectures
    • G06Q20/20Point-of-sale [POS] network systems
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q20/00Payment architectures, schemes or protocols
    • G06Q20/02Payment architectures, schemes or protocols involving a neutral party, e.g. certification authority, notary or trusted third party [TTP]
    • G06Q20/027Payment architectures, schemes or protocols involving a neutral party, e.g. certification authority, notary or trusted third party [TTP] involving a payment switch or gateway

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Accounting & Taxation (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • Strategic Management (AREA)
  • Computer Security & Cryptography (AREA)
  • Software Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Finance (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a data operation method and system based on data routing rule and sub-database sub-table, relating to the technical field of data processing, comprising an operation system, a transaction routing service, a POS gateway, a transaction pre-system, a channel gateway and a POS terminal, wherein the operation system is used for configuring the sub-database rules, the transaction routing service is used for reading the sub-database configuration rules, dynamically generating application group numbers and storing transaction routing information, the transaction routing information is returned to the POS gateway, the POS gateway is used for accessing the transaction routing service, the transaction pre-system is used for calling a plurality of transaction clusters, storing transaction flow into a date table in the transaction clusters according to accounting date, the channel gateway is used for receiving the transaction cluster information and returning the transaction result to the transaction clusters, the POS terminal is used for recording consumption information and printing the transaction result in the form of a receipt, the invention supports an infinite capacity expansion mode, and failover can be made to quickly resume transactions.

Description

Data operation method and system based on data routing rule and database and table division
Technical Field
The invention relates to the technical field of data processing, in particular to a data operation method and a data operation system based on data routing rules and database and table splitting.
Background
The existing database partitioning scheme of the POS acquiring transaction system is to perform modular database partitioning according to the last bit of the merchant number, and only 2 odd-even databases are supported at present. When one database fails, the transaction cannot be switched to the other database, and the database cannot be rapidly failed over. When the database expands the capacity, the historical transaction data needs to be migrated, and the expansion of the database by multiples of 2n is needed each time, so that the rapid and transverse expansion is troublesome. The other point is that the increase of transaction flow data is accelerated, the cleaning of the data is troublesome, the transaction flow cannot be uniformly distributed, the data generation period cannot be well managed, and the like, all the problems affect the stable operation of the system.
Disclosure of Invention
In order to overcome the defects of the prior art, the data operation method and the data operation system based on the data routing rule and the database and table division can quickly switch the transaction to other databases and achieve the purpose of quickly recovering the transaction by fault transfer.
The technical scheme adopted by the invention for solving the technical problems is as follows: the improvement of a data operation method based on data routing rules and sub-base and sub-table is characterized by comprising the following steps:
s1: configuring a sub-base rule in an operation system;
s2: the POS gateway accessing a transaction routing service;
s3: the transaction routing service reads the sub-base configuration rule, dynamically generates an application group number, stores transaction routing information and returns the transaction routing information to the POS gateway;
s4: and the POS gateway calls a transaction front-end system according to the application group number, the transaction front-end system calls a plurality of transaction clusters, and transaction streams are stored in a date table in the transaction clusters according to the accounting date.
As a further improvement of the technical scheme, the date table is a sub-date table, and the total number of the sub-date tables is 366.
As a further improvement of the above technical solution, in step S1, before the operation system configures the banking rule, a card swiping transaction needs to be performed on the POS terminal, and the POS terminal uploads the consumption message to the POS gateway.
As a further improvement of the above technical solution, in step S3, the specific steps of the transaction routing service reading the sub-base configuration rule, dynamically generating the application group number, storing the transaction routing information, and returning the transaction routing information to the POS gateway are as follows:
s31: the transaction routing service determines the storage position of the current transaction routing information according to the merchant region code range matching sub-base rule, and distributes the current transaction routing information to different DB database groups according to the merchant region code range;
s32: the transaction is evenly distributed according to the last number of the transaction serial number and distributed to different DB databases in a DB database group;
s32: and then dynamically generating an application group number according to the database dividing information, simultaneously storing transaction routing information, and returning a database dividing result to the POS gateway.
As a further improvement of the above technical solution, in step S3, the transaction routing service has a first storage unit and a second storage unit, the first storage unit stores the transaction routing information for 180 days, and the second storage unit stores the transaction routing information for the previous 3 days.
As a further improvement of the technical scheme, the last number of the transaction serial number is used for evenly distributing the transactions, and a specific database is found and stored by a HASH matching sub-database rule.
As a further improvement of the above technical solution, in step S4, after saving the transaction pipeline in the date table in the transaction cluster, the following operations are performed:
s41: the transaction cluster calls a channel gateway, uploads transaction flow to a gateway channel, and returns a transaction result to the transaction front-end system;
s42: the transaction front-end system returns the transaction result to the POS gateway;
s43: the POS gateway returns the transaction result to the POS terminal, and the POS terminal displays the transaction result;
s44: printing the receipt if the success is achieved;
s45: if not, the operation ends.
In a data operating system based on data routing rules, a library and a table, the improvement comprising:
an operation system: the operation system is used for configuring a database partitioning rule;
transaction routing service: the transaction routing service is used for reading the sub-base configuration rule, dynamically generating an application group number, storing transaction routing information and returning the transaction routing information to the POS gateway;
POS gateway: the POS gateway is used for accessing transaction routing service;
the transaction front-end system: the transaction front-end system is used for calling a plurality of transaction clusters and storing transaction flow to a date table in the transaction clusters according to the accounting date;
channel gateway: the channel gateway is used for receiving the transaction cluster information and returning a transaction result to the transaction cluster;
POS terminal: and the POS terminal is used for recording consumption information and printing a transaction result in a form of a receipt.
As a further improvement of the above technical solution, a first storage unit and a second storage unit are provided in the transaction routing service, the first storage unit is used for storing the transaction routing information for 180 days, and the second storage unit is used for storing the transaction routing information for the previous 3 days.
The invention has the beneficial effects that:
1. the concept of a database group is introduced, and the system simultaneously supports infinite capacity expansion modes of multiple database groups and multiple databases in the same group;
2. when the database fails, the transaction can be quickly switched to other databases according to the database partitioning rule, so that the transaction can be quickly recovered through failover;
3. when the database is expanded, historical transaction data does not need to be migrated, and the related transaction can find the database where the original transaction is located according to the transaction routing information;
4. the transaction flow water meter divides the table according to the date, the transaction of the current day is stored in the table of the date of the current day, the historical data which is not needed by the service can be cold-prepared, and the data can be cleaned according to the date table.
Drawings
FIG. 1 is a timing diagram of the present invention;
FIG. 2 is an architectural diagram of the present invention;
fig. 3 is a library-partitioned routing diagram of the present invention.
Detailed Description
The invention is further illustrated with reference to the following figures and examples.
The conception, the specific structure, and the technical effects produced by the present invention will be clearly and completely described below in conjunction with the embodiments and the accompanying drawings to fully understand the objects, the features, and the effects of the present invention. It is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all embodiments, and those skilled in the art can obtain other embodiments without inventive effort based on the embodiments of the present invention, and all embodiments are within the protection scope of the present invention. In addition, all the connection/connection relations referred to in the patent do not mean that the components are directly connected, but mean that a better connection structure can be formed by adding or reducing connection auxiliary components according to specific implementation conditions. All technical characteristics in the invention can be interactively combined on the premise of not conflicting with each other.
Referring to fig. 1-2, the present invention discloses a data operation method based on data routing rule and database and table division, comprising the following steps:
s1: configuring a database dividing rule in an operation system, wherein before the database dividing rule is configured in the operation system, card swiping transaction needs to be carried out on a POS terminal, and the POS terminal uploads a consumption message to a POS gateway;
s2: the POS gateway accessing a transaction routing service;
s3: the transaction routing service reads the sub-base configuration rule, dynamically generates an application group number, stores transaction routing information and returns the transaction routing information to the POS gateway;
s4: and the POS gateway calls a transaction front-end system according to the application group number, the transaction front-end system calls a plurality of transaction clusters, transaction flow is stored in a date table in the transaction clusters according to the accounting date, and the date table is a date sub-table and is totally 366 tables.
In the above embodiment, the invention first performs a card swiping transaction on a POS terminal to upload a consumption message to a POS gateway, and then configures a banking rule (write Redis + DB) in an operating system, where Redis an open source log-type, Key-Value database which is compiled using ANSIC language, supports network, can be based on memory, and can also be persistent, and provides API in multiple languages, the POS gateway calls a banking router to read the banking configuration rule (distinguish DB from intra-group DB), dynamically generates an application group number and stores transaction routing information, returns to the POS gateway, the POS gateway calls a transaction front-end system according to the application group number, the transaction front-end system then calls multiple transaction clusters, stores transactions according to accounting dates into a date table in the cluster transactions, where multiple transaction clusters are provided with DB database groups, the application group number is generated in the date table of the DB database groups, the transaction flow water meter is divided into tables according to dates, the transactions of the same day are stored in the table of the date to which the same day belongs, and historical data which is not needed by the service can be cold-prepared and cleaned according to the date table.
Further, in step S3, the specific steps of the transaction routing service reading the sub-base configuration rule, dynamically generating an application group number, storing the transaction routing information, and returning the transaction routing information to the POS gateway are as follows:
s31: the transaction routing service determines the storage position of the current transaction routing information according to the merchant region code range matching sub-base rule, and stores the current transaction routing information into a DB database group according to the merchant region code range;
s32: carrying out average distribution on the transactions according to the transaction serial numbers, wherein HASH matching sub-database rules are adopted for carrying out average distribution on the transactions by the transaction serial numbers and are distributed to different DB databases in a DB database group;
s32: and then dynamically generating an application group number according to the database dividing information, simultaneously storing transaction routing information, and returning a database dividing result to the POS gateway.
In step S3, the transaction routing service has a first storage unit and a second storage unit built therein, the first storage unit stores the transaction routing information for 180 days, and the second storage unit stores the transaction routing information for the previous 3 days.
In the embodiment, when the transaction serial number is averagely distributed, the transaction serial number is distributed to different DB databases in a DB database group of the same transaction cluster or different transaction clusters according to the HASH matching database distribution rule, and when the database fails, the transaction can be quickly switched to other databases according to the database distribution rule, so that the failure transfer and quick recovery of the transaction are realized; when the database expands, historical transaction data does not need to be migrated, and the related transaction can find the database where the original transaction is located according to the transaction routing information.
The library dividing mode of the invention is as follows: regional grouping + transaction serial number HASH banking.
Referring to fig. 3, the sub-library description: according to the area code range, the transaction is divided into a certain DB group, and then HASH is divided into different DB banks according to the last 1 bit of the serial number, and the following examples are given:
db01 and db02 are arranged in the group1, the region code is placed in a group1 at [0000-8000], and then is evenly distributed to db01 and db02 through the HASH of the last 1 bit of the serial number;
db03 and db04 are arranged in the group2, region codes are placed in the group2 at [ 8001-;
and (3) returning data format: dubbo group number: environment (production/gray) _ group number (group1/group2) _ DB name;
if capacity expansion is needed, the number of the DB in one group is increased, or a group of the DB is directly increased;
if one of the DBs fails, the transaction may be handed off at the operating system to the other DBs in the other group or in the same group.
In many data, if the data of a certain day is to be inquired, all the data are mixed into a whole, and the searching in the sea fishing needle type is troublesome, so the invention is also provided with an inquiry service, the data of 180 days is stored in the first storage unit, the data of the previous 3 days is stored in the second storage unit, and the data of the previous 3 days is the data in the general inquiry, thereby ensuring that the needed data can be quickly inquired.
In addition, when the transaction serial number is averagely distributed to the transaction, a HASH matching sub-library rule is adopted, the HASH matching sub-library rule belongs to a mature technology in the prior art, and repeated description is omitted.
Finally, in step S4, the following operations are performed after the transaction pipeline is saved in the date table in the transaction cluster:
s41: the transaction cluster calls a channel gateway, uploads transaction flow to a gateway channel, and returns a transaction result to the transaction front-end system;
s42: the transaction front-end system returns the transaction result to the POS gateway;
s43: the POS gateway returns the transaction result to the POS terminal, and the POS terminal displays the transaction result;
s44: printing the receipt if the success is achieved;
s45: if not, the operation ends.
In the above embodiment, the transaction information stored in the transaction cluster is transmitted to the channel gateway, the channel gateway receives the transaction cluster information and returns the transaction result to the transaction cluster, the transaction cluster submits the transaction result to the transaction front-end system, the transaction front-end system returns the transaction result to the POS gateway, the POS gateway returns the transaction result to the POS terminal, and the receipt is printed to the cardholder after the transaction result is successfully displayed.
A data routing rule, sub-base, sub-table based data operating system, comprising:
an operation system: the operation system is used for configuring a database partitioning rule;
transaction routing service: the transaction routing service is used for reading the sub-base configuration rule, dynamically generating an application group number, storing transaction routing information and returning the transaction routing information to the POS gateway;
POS gateway: the POS gateway is used for accessing transaction routing service;
the transaction front-end system: the transaction front-end system is used for calling a plurality of transaction clusters and storing transaction flow to a date table in the transaction clusters according to the accounting date;
channel gateway: the channel gateway is used for receiving the transaction cluster information and returning a transaction result to the transaction cluster;
POS terminal: and the POS terminal is used for recording consumption information and printing a transaction result in a form of a receipt.
The transaction routing service is internally provided with a first storage unit and a second storage unit, wherein the first storage unit is used for storing the transaction routing information for 180 days, and the second storage unit is used for storing the transaction routing information for the previous 3 days.
The invention firstly carries out card swiping transaction on a POS terminal to upload consumption messages to a POS gateway, then configures a database splitting rule (writing Redis + DB) in an operation system, wherein Redis is an open source log-type and Key-Value database which is compiled by ANSIC language, supports network, can be based on memory and can be endured, and provides API of multiple languages, the POS gateway calls a database splitting router to read the database splitting configuration rule (distinguishing DB groups in the DB database group and the DB group in the DB database group), dynamically generates an application group number and stores transaction routing information, returns to the POS gateway, the POS gateway calls a transaction front-end system according to the application group number, the transaction front-end system then calls a plurality of transaction clusters, stores transaction flow into a date table in the transaction clusters according to accounting date, wherein, a plurality of transaction clusters are internally provided with DB database groups, and the application group number is generated in the date table of the DB database groups, the invention introduces the concept of a database group, simultaneously supports the unlimited capacity expansion modes of a plurality of database groups and a plurality of databases in the same group, and the transaction flow meter divides the table according to the date, the transaction of the current day is stored in the table of the current day, and the history data which is not needed by the service can be cold-prepared and cleaned according to the date table.
When the transaction serial number is averagely distributed, the transaction serial number is distributed to different DB databases in a DB database group of the same transaction cluster or different transaction clusters according to the HASH matching database distribution rule, and when the database fails, the transaction can be quickly switched to other databases according to the database distribution rule, so that the failure transfer and quick recovery transaction are realized; when the database expands, historical transaction data does not need to be migrated, and the related transaction can find the database where the original transaction is located according to the transaction routing information.
The library dividing mode of the invention is as follows: regional grouping + transaction serial number HASH banking.
Referring to fig. 3, the sub-library description: according to the region code range, the transaction is firstly divided into a certain DB database group, and then HASH is divided into different DB databases according to the last 1 bit of the serial number, and the following examples are given:
db01 and db02 are arranged in the group1, the region code is placed in a group1 at [0000-8000], and then is evenly distributed to db01 and db02 through the HASH of the last 1 bit of the serial number;
db03 and db04 are arranged in the group2, region codes are placed in the group2 at [ 8001-;
and (3) returning data format: dubbo group number: environment (production/gray) _ group number (group1/group2) _ DB name;
if capacity expansion is needed, the number of DB database groups is increased in one group, or a group of DBs is directly increased;
if one of the DB database groups fails, the transaction may be handed off at the operating system to other DBs in other groups or in the same group.
In many data, if the data of a certain day is to be inquired, all the data are mixed into a whole, and the searching in the sea fishing needle type is troublesome, so the invention is also provided with an inquiry service, the data of 180 days is stored in the first storage unit, the data of the previous 3 days is stored in the second storage unit, and the data of the previous 3 days is the data in the general inquiry, thereby ensuring that the needed data can be quickly inquired.
The transaction information stored in the transaction cluster is transmitted to the channel gateway, the channel gateway receives the transaction cluster information and returns a transaction result to the transaction cluster, the transaction cluster submits the transaction result to the transaction front-end system, the transaction front-end system returns the transaction result to the POS gateway, the POS gateway returns the transaction result to the POS terminal, and the small ticket is printed to the card holder after the transaction result is successfully displayed.
The invention has the beneficial effects that:
1. the concept of a database group is introduced, and the system simultaneously supports infinite capacity expansion modes of multiple database groups and multiple databases in the same group;
2. when the database fails, the transaction can be quickly switched to other databases according to the database partitioning rule, so that the transaction can be quickly recovered through failover;
3. when the database is expanded, historical transaction data does not need to be migrated, and the related transaction can find the database where the original transaction is located according to the transaction routing information;
4. the transaction flow water meter divides the table according to the date, the transaction of the current day is stored in the table of the date of the current day, the historical data which is not needed by the service can be cold-prepared, and the data can be cleaned according to the date table.
While the preferred embodiments of the present invention have been illustrated and described, it will be understood by those skilled in the art that various changes in form and details may be made therein without departing from the spirit and scope of the invention as defined by the appended claims.

Claims (9)

1. A data operation method based on data routing rules and sub-base and sub-table is characterized by comprising the following steps:
s1: configuring a sub-base rule in an operation system;
s2: the POS gateway accessing a transaction routing service;
s3: the transaction routing service reads the sub-base configuration rule, dynamically generates an application group number, stores transaction routing information and returns the transaction routing information to the POS gateway;
s4: and the POS gateway calls a transaction front-end system according to the application group number, the transaction front-end system calls a plurality of transaction clusters, and transaction streams are stored in a date table in the transaction clusters according to the accounting date.
2. The data operation method based on the data routing rule and the database and table division as claimed in claim 1, wherein the date table is a date table division, and the total number of the date table division is 366 tables.
3. The data operation method according to claim 1, wherein in step S1, before the operation system configures the database splitting rule, a card swiping transaction is performed on the POS terminal, and the POS terminal uploads the consumption message to the POS gateway.
4. The data operation method based on the data routing rule and the database and table division according to claim 1, wherein in step S3, the transaction routing service reads the database configuration rule, dynamically generates the application group number, stores the transaction routing information, and returns the transaction routing information to the POS gateway, and the specific steps are as follows:
s31: the transaction routing service determines the storage position of the current transaction routing information according to the merchant region code range matching sub-base rule, and distributes the current transaction routing information to different DB database groups according to the merchant region code range;
s32: the transaction is evenly distributed according to the last number of the transaction serial number and distributed to different DB databases in a DB database group;
s32: and then dynamically generating an application group number according to the database dividing information, simultaneously storing transaction routing information, and returning a database dividing result to the POS gateway.
5. The data operation method according to claim 4, wherein in step S3, the transaction routing service has a first storage unit and a second storage unit, the first storage unit stores 180 days of transaction routing information, and the second storage unit stores the previous 3 days of transaction routing information.
6. The data operation method based on data routing rule and database and table division according to claim 5, wherein the last number of the transaction serial number is used for evenly distributing the transaction by matching HASH with the database division rule to find a specific database and storing.
7. The data operation method according to claim 1, wherein in step S4, the following operations are further performed after the transaction pipeline is saved in the date table in the transaction cluster:
s41: the transaction cluster calls a channel gateway, uploads transaction flow to a gateway channel, and returns a transaction result to the transaction front-end system;
s42: the transaction front-end system returns the transaction result to the POS gateway;
s43: the POS gateway returns the transaction result to the POS terminal, and the POS terminal displays the transaction result;
s44: printing the receipt if the success is achieved;
s45: if not, the operation ends.
8. A data operation system based on data routing rules and sub-base and sub-table is characterized by comprising:
an operation system: the operation system is used for configuring a database partitioning rule;
transaction routing service: the transaction routing service is used for reading the sub-base configuration rule, dynamically generating an application group number, storing transaction routing information and returning the transaction routing information to the POS gateway;
POS gateway: the POS gateway is used for accessing transaction routing service;
the transaction front-end system: the transaction front-end system is used for calling a plurality of transaction clusters and storing transaction flow to a date table in the transaction clusters according to the accounting date;
channel gateway: the channel gateway is used for receiving the transaction cluster information and returning a transaction result to the transaction cluster;
POS terminal: and the POS terminal is used for recording consumption information and printing a transaction result in a form of a receipt.
9. The data operating system according to claim 8, wherein the transaction routing service is provided with a first storage unit and a second storage unit, the first storage unit is used for storing 180 days of transaction routing information, and the second storage unit is used for storing the previous 3 days of transaction routing information.
CN202011065758.5A 2020-09-30 2020-09-30 Data operation method and system based on data routing rule and database and table division Pending CN112184204A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202011065758.5A CN112184204A (en) 2020-09-30 2020-09-30 Data operation method and system based on data routing rule and database and table division

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202011065758.5A CN112184204A (en) 2020-09-30 2020-09-30 Data operation method and system based on data routing rule and database and table division

Publications (1)

Publication Number Publication Date
CN112184204A true CN112184204A (en) 2021-01-05

Family

ID=73948265

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202011065758.5A Pending CN112184204A (en) 2020-09-30 2020-09-30 Data operation method and system based on data routing rule and database and table division

Country Status (1)

Country Link
CN (1) CN112184204A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112929271A (en) * 2021-02-04 2021-06-08 华控清交信息科技(北京)有限公司 Route configuration method and device for configuring route

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101976397A (en) * 2010-11-16 2011-02-16 广东浚祥商务服务有限公司 Ordering and paying integrated management system and realizing method thereof
CN107229688A (en) * 2017-05-12 2017-10-03 上海前隆金融信息服务有限公司 A kind of database level point storehouse point table method and system, server
CN107944862A (en) * 2017-11-30 2018-04-20 银联商务股份有限公司 Order method for processing business, device and server based on transaction front platform
CN108492108A (en) * 2018-03-29 2018-09-04 深圳前海微众银行股份有限公司 Across the chain communication means of block chain, system and computer readable storage medium
US20200074416A1 (en) * 2018-08-30 2020-03-05 Mastercard International Incorporated Routing transactions to a priority processing network based on routing rules
CN111064669A (en) * 2019-12-19 2020-04-24 北京达佳互联信息技术有限公司 Route storage method, device, equipment and storage medium

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101976397A (en) * 2010-11-16 2011-02-16 广东浚祥商务服务有限公司 Ordering and paying integrated management system and realizing method thereof
CN107229688A (en) * 2017-05-12 2017-10-03 上海前隆金融信息服务有限公司 A kind of database level point storehouse point table method and system, server
CN107944862A (en) * 2017-11-30 2018-04-20 银联商务股份有限公司 Order method for processing business, device and server based on transaction front platform
CN108492108A (en) * 2018-03-29 2018-09-04 深圳前海微众银行股份有限公司 Across the chain communication means of block chain, system and computer readable storage medium
US20200074416A1 (en) * 2018-08-30 2020-03-05 Mastercard International Incorporated Routing transactions to a priority processing network based on routing rules
CN111064669A (en) * 2019-12-19 2020-04-24 北京达佳互联信息技术有限公司 Route storage method, device, equipment and storage medium

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112929271A (en) * 2021-02-04 2021-06-08 华控清交信息科技(北京)有限公司 Route configuration method and device for configuring route

Similar Documents

Publication Publication Date Title
US20100161565A1 (en) Cluster data management system and method for data restoration using shared redo log in cluster data management system
CN105787058B (en) A kind of user tag system and the data delivery system based on user tag system
CN107977396B (en) Method and device for updating data table of KeyValue database
CN101504672A (en) Method and system for dynamically configuring physical data table
CN103744906A (en) System, method and device for data synchronization
CN105426419B (en) Data promotion system and method between heterogeneous system
CN104182898A (en) Additional recording method of on-line transaction during night mode for bank system
CN106649729A (en) Log running method and system, client and server
CN112184204A (en) Data operation method and system based on data routing rule and database and table division
CN101790257A (en) Method for memorizing data and network management system
US20240037119A1 (en) A method and device for storing data in a distributed database
CN101071434A (en) User distributing method, device and system for distributed database system
CN110096509A (en) Realize that historical data draws the system and method for storage of linked list modeling processing under big data environment
CN106570163A (en) Unreliable environment-oriented audit log read-write managing method and system
CN109241056B (en) Digital ID generation system for distributed system
CN107766355B (en) Hierarchical data management method, hierarchical data management system and instant messaging system
CN115525693A (en) Incremental event log-oriented process model mining method and system
CN113177051A (en) Method for dynamically adding and maintaining data tag
CN108304527B (en) Data extraction method
CN109241057B (en) Digital ID generation method for distributed system
CN101526925A (en) Processing method of caching data and data storage system
CN101645085B (en) Method and system for storing irregular fields
CN113934797B (en) Banking industry super-large data synchronization method and system
Iliadis Reliability evaluation of erasure coded systems under rebuild bandwidth constraints
CN108090034A (en) Document code Unified coding generation method and system based on cluster

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20210105