CN110782313A - 一种基于分库分表的数据库事务处理方法及装置 - Google Patents
一种基于分库分表的数据库事务处理方法及装置 Download PDFInfo
- Publication number
- CN110782313A CN110782313A CN201910939439.3A CN201910939439A CN110782313A CN 110782313 A CN110782313 A CN 110782313A CN 201910939439 A CN201910939439 A CN 201910939439A CN 110782313 A CN110782313 A CN 110782313A
- Authority
- CN
- China
- Prior art keywords
- sub
- base
- initial
- service
- database
- 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.)
- Granted
Links
- 238000003672 processing method Methods 0.000 title claims abstract description 20
- 238000000034 method Methods 0.000 claims abstract description 341
- 238000013507 mapping Methods 0.000 claims abstract description 110
- 230000008569 process Effects 0.000 claims description 23
- 238000012545 processing Methods 0.000 claims description 12
- 238000010276 construction Methods 0.000 claims description 3
- 238000011161 development Methods 0.000 abstract description 6
- 238000010586 diagram Methods 0.000 description 5
- 238000004364 calculation method Methods 0.000 description 3
- 230000009286 beneficial effect Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000036961 partial effect Effects 0.000 description 2
- 238000011176 pooling Methods 0.000 description 2
- 230000004044 response Effects 0.000 description 2
- 238000000638 solvent extraction Methods 0.000 description 2
- 230000002860 competitive effect Effects 0.000 description 1
- 230000003111 delayed effect Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION 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
- G06Q30/00—Commerce
- G06Q30/06—Buying, selling or leasing transactions
- G06Q30/0601—Electronic shopping [e-shopping]
-
- 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/23—Updating
- G06F16/2379—Updates performed during online database operations; commit processing
-
- 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/24—Querying
- G06F16/245—Query processing
- G06F16/2453—Query optimisation
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
-
- 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/25—Integrating or interfacing systems involving database management systems
- G06F16/256—Integrating or interfacing systems involving database management systems in federated or virtual databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Computational Linguistics (AREA)
- Development Economics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910939439.3A CN110782313B (zh) | 2019-09-29 | 2019-09-29 | 一种基于分库分表的数据库事务处理方法及装置 |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201910939439.3A CN110782313B (zh) | 2019-09-29 | 2019-09-29 | 一种基于分库分表的数据库事务处理方法及装置 |
Publications (2)
Publication Number | Publication Date |
---|---|
CN110782313A true CN110782313A (zh) | 2020-02-11 |
CN110782313B CN110782313B (zh) | 2022-12-23 |
Family
ID=69384992
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201910939439.3A Active CN110782313B (zh) | 2019-09-29 | 2019-09-29 | 一种基于分库分表的数据库事务处理方法及装置 |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN110782313B (zh) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2021169272A1 (zh) * | 2020-02-27 | 2021-09-02 | 平安科技(深圳)有限公司 | 数据库表格变更方法、装置、计算机设备及存储介质 |
CN114116754A (zh) * | 2021-12-06 | 2022-03-01 | 税友软件集团股份有限公司 | 分布式数据库的数据更新方法、装置、设备及存储介质 |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20110178906A1 (en) * | 2004-10-13 | 2011-07-21 | Ares Capital Management Pty Ltd | Data processing system and method incorporating valuation method toggle |
CN104866577A (zh) * | 2015-05-26 | 2015-08-26 | 深圳市六度人和科技有限公司 | 一种基于嵌入式数据库的数据处理方法及装置 |
-
2019
- 2019-09-29 CN CN201910939439.3A patent/CN110782313B/zh active Active
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20110178906A1 (en) * | 2004-10-13 | 2011-07-21 | Ares Capital Management Pty Ltd | Data processing system and method incorporating valuation method toggle |
CN104866577A (zh) * | 2015-05-26 | 2015-08-26 | 深圳市六度人和科技有限公司 | 一种基于嵌入式数据库的数据处理方法及装置 |
Non-Patent Citations (2)
Title |
---|
M. SATO等: "Electromagnetic Noise Suppression Composite Sheet Made of Hexagonal Ferrite Particles", 《2018 IEEE INTERNATIONAL MAGNETICS CONFERENCE (INTERMAG)》 * |
刘雷: "分布式数据库在金融应用场景中的探索与实践", 《大数据》 * |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
WO2021169272A1 (zh) * | 2020-02-27 | 2021-09-02 | 平安科技(深圳)有限公司 | 数据库表格变更方法、装置、计算机设备及存储介质 |
CN114116754A (zh) * | 2021-12-06 | 2022-03-01 | 税友软件集团股份有限公司 | 分布式数据库的数据更新方法、装置、设备及存储介质 |
Also Published As
Publication number | Publication date |
---|---|
CN110782313B (zh) | 2022-12-23 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
JP7423816B2 (ja) | 注文情報処理方法、装置、コンピュータ機器及び媒体 | |
CN104699712B (zh) | 对数据库中的库存记录信息进行更新的方法及装置 | |
US5311424A (en) | Method and system for product configuration definition and tracking | |
CN104516895B (zh) | 商品对象库存信息处理方法及系统 | |
CN106997557B (zh) | 订单信息采集方法及装置 | |
CN104794249A (zh) | 一种数据库的实现方法和设备 | |
US10831737B2 (en) | Method and device for partitioning association table in distributed database | |
CN110782313B (zh) | 一种基于分库分表的数据库事务处理方法及装置 | |
WO2016169451A1 (zh) | 物流服务信息提供方法及装置 | |
US20070239666A1 (en) | Method and System for a De-Normalized Electronic-Catalog | |
US9342812B2 (en) | Taxonomy based database partitioning | |
CN106933891A (zh) | 访问分布式数据库的方法和分布式数据服务的装置 | |
KR102327572B1 (ko) | 데이터 저장과 서비스 처리 방법 및 장치 | |
CN107357557B (zh) | 一种信息更新方法及装置 | |
CN110740155A (zh) | 分布式系统中的请求处理方法及装置 | |
CN111773666B (zh) | 订单数据的处理方法、装置、存储介质和电子装置 | |
CN105590178A (zh) | 一种资源处理方法与设备 | |
CN115456739B (zh) | 数据管理方法及相关装置 | |
JP2005165610A (ja) | トランザクション処理システムおよび方法 | |
US10503696B1 (en) | Maintaining stable record identifiers in the presence of updated data records | |
CN111026963A (zh) | 数据查询的方法及装置、配置信息的设置方法及装置 | |
US20160371629A1 (en) | Method for cost efficient fulfillment | |
US20040143517A1 (en) | System and method for managing material distribution and returned materials | |
CN114564501A (zh) | 一种数据库数据存储、查询方法、装置、设备及介质 | |
CN109472668B (zh) | 一种商品数据的处理方法、系统、服务器和存储介质 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
GR01 | Patent grant | ||
GR01 | Patent grant | ||
CP03 | Change of name, title or address | ||
CP03 | Change of name, title or address |
Address after: No.1-1 Suning Avenue, Xuzhuang Software Park, Xuanwu District, Nanjing, Jiangsu Province, 210000 Patentee after: Jiangsu Suning cloud computing Co.,Ltd. Country or region after: China Address before: No.1-1 Suning Avenue, Xuzhuang Software Park, Xuanwu District, Nanjing, Jiangsu Province, 210000 Patentee before: Suning Cloud Computing Co.,Ltd. Country or region before: China |
|
TR01 | Transfer of patent right | ||
TR01 | Transfer of patent right |
Effective date of registration: 20240410 Address after: 210000, 1-5 story, Jinshan building, 8 Shanxi Road, Nanjing, Jiangsu. Patentee after: SUNING.COM Co.,Ltd. Country or region after: China Address before: No.1-1 Suning Avenue, Xuzhuang Software Park, Xuanwu District, Nanjing, Jiangsu Province, 210000 Patentee before: Jiangsu Suning cloud computing Co.,Ltd. Country or region before: China |