MX2023006491A - Mejora del rendimiento de trabajos por lotes en arquitectura activo-activo. - Google Patents

Mejora del rendimiento de trabajos por lotes en arquitectura activo-activo.

Info

Publication number
MX2023006491A
MX2023006491A MX2023006491A MX2023006491A MX2023006491A MX 2023006491 A MX2023006491 A MX 2023006491A MX 2023006491 A MX2023006491 A MX 2023006491A MX 2023006491 A MX2023006491 A MX 2023006491A MX 2023006491 A MX2023006491 A MX 2023006491A
Authority
MX
Mexico
Prior art keywords
database server
active
batch job
processor
responsive
Prior art date
Application number
MX2023006491A
Other languages
English (en)
Inventor
Shuo Li
Xiaobo Wang
Jiatian Zhong
Shengyan Sun
Original Assignee
Ibm
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 Ibm filed Critical Ibm
Publication of MX2023006491A publication Critical patent/MX2023006491A/es

Links

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/24—Querying
    • G06F16/242—Query formulation
    • G06F16/2433—Query languages
    • 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/2308—Concurrency control
    • G06F16/2336—Pessimistic concurrency control approaches, e.g. locking or multiple versions without time stamps
    • G06F16/2343—Locking methods, e.g. distributed locking or locking implementation details
    • 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
    • G06F16/2386—Bulk updating operations
    • 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/242—Query formulation
    • G06F16/2423—Interactive query statement specification based on a database schema
    • 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
    • G06F16/273—Asynchronous replication or reconciliation
    • 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/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/284—Relational 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)
  • Computational Linguistics (AREA)
  • Mathematical Physics (AREA)
  • Computing Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Preparation Of Compounds By Using Micro-Organisms (AREA)
  • Pharmaceuticals Containing Other Organic And Inorganic Compounds (AREA)

Abstract

En un planteamiento para mejorar el rendimiento de un trabajo por lotes (232) que se ejecuta en servidores de bases de datos en una arquitectura activo-activo Un procesador de (504), en respuesta a que el trabajo por lotes (232) está listo para ser ejecutado en un servidor de base de datos de origen (210), envía una primera comunicación a un servidor de base de datos de destino (220) con un punto de inicio de sincronización (410). Mientras se ejecuta el trabajo por lotes (232), el procesador (504) utiliza una función de pre-bloqueo, función de pre-carga, y función de evitación de bloqueo para evitar conflictos de bloqueo (420). El procesador (504), en respuesta a que cualquiera del servidor de base de datos de origen (210) o el servidor de base de datos de destino (220) encuentra una instrucción de confirmación, suspende el servidor de base de datos respectivo y envía una segunda comunicación para preguntar si el otro servidor de base de datos respectivo está listo para completar la instrucción de confirmación (430). El procesador (504), en respuesta a que el otro servidor de base de datos respectivo confirma que está listo para completar la instrucción de confirmación, completa la instrucción de confirmación tanto en el servidor de base de datos de origen (210) como en el servidor de base de datos de destino (220).
MX2023006491A 2020-12-03 2021-11-17 Mejora del rendimiento de trabajos por lotes en arquitectura activo-activo. MX2023006491A (es)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US17/110,523 US11461315B2 (en) 2020-12-03 2020-12-03 Batch job performance improvement in active-active architecture
PCT/CN2021/131196 WO2022116828A1 (en) 2020-12-03 2021-11-17 Batch job performance improvement in active-active architecture

Publications (1)

Publication Number Publication Date
MX2023006491A true MX2023006491A (es) 2023-06-20

Family

ID=81848137

Family Applications (1)

Application Number Title Priority Date Filing Date
MX2023006491A MX2023006491A (es) 2020-12-03 2021-11-17 Mejora del rendimiento de trabajos por lotes en arquitectura activo-activo.

Country Status (10)

Country Link
US (1) US11461315B2 (es)
JP (1) JP2023551830A (es)
CN (1) CN116529722A (es)
AU (1) AU2021390717B2 (es)
CA (1) CA3192544A1 (es)
DE (1) DE112021005573T5 (es)
GB (1) GB2617015A (es)
IL (1) IL301851A (es)
MX (1) MX2023006491A (es)
WO (1) WO2022116828A1 (es)

Family Cites Families (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8024299B2 (en) * 2006-10-20 2011-09-20 Oracle International Corporation Client-driven functionally equivalent database replay
JP5331555B2 (ja) * 2009-04-23 2013-10-30 株式会社日立製作所 データ移行システムおよびデータ移行方法
US8984170B2 (en) * 2011-09-09 2015-03-17 Oracle International Corporation Idempotence for database transactions
US8903779B1 (en) * 2013-03-06 2014-12-02 Gravic, Inc. Methods for returning a corrupted database to a known, correct state
CN104809199B (zh) 2015-04-24 2018-11-16 联动优势科技有限公司 一种数据库同步的方法和装置
US10095764B2 (en) 2015-06-19 2018-10-09 Sap Se Multi-replica asynchronous table replication
US10318349B2 (en) 2017-05-22 2019-06-11 Salesforce.Com, Inc. Distributed scheduling in a virtual machine environment
US11327788B2 (en) 2018-07-05 2022-05-10 Jpmorgan Chase Bank, N.A. Methods for scheduling multiple batches of concurrent jobs
US20200026786A1 (en) 2018-07-18 2020-01-23 International Business Machines Corporation Management and synchronization of batch workloads with active/active sites using proxy replication engines
CN109101364B (zh) 2018-07-20 2022-02-15 中国邮政储蓄银行股份有限公司 双中心双活数据处理系统和方法
CN111352766A (zh) 2018-12-21 2020-06-30 中国移动通信集团山东有限公司 一种数据库的双活实现方法及装置
CN109960710B (zh) 2019-01-16 2023-04-11 平安科技（深圳）有限公司 数据库之间的数据同步方法和系统
US11106554B2 (en) 2019-04-30 2021-08-31 JFrog, Ltd. Active-active environment control
CN110334156A (zh) 2019-07-10 2019-10-15 北京启迪区块链科技发展有限公司 一种数据库同步方法、装置、服务器和存储介质
CN111666144A (zh) 2020-06-19 2020-09-15 中信银行股份有限公司 批处理任务执行方法、系统以及机房部署系统
CN111953808B (zh) 2020-07-31 2023-08-15 上海燕汐软件信息科技有限公司 一种双机双活架构的数据传输切换方法及架构构建系统

Also Published As

Publication number Publication date
GB2617015A (en) 2023-09-27
AU2021390717A1 (en) 2023-06-15
WO2022116828A1 (en) 2022-06-09
JP2023551830A (ja) 2023-12-13
IL301851A (en) 2023-06-01
DE112021005573T5 (de) 2023-08-24
AU2021390717B2 (en) 2023-09-21
CN116529722A (zh) 2023-08-01
GB202309848D0 (en) 2023-08-16
CA3192544A1 (en) 2022-06-09
US11461315B2 (en) 2022-10-04
US20220179852A1 (en) 2022-06-09

Similar Documents

Publication Publication Date Title
US9892153B2 (en) Detecting lost writes
US9922105B2 (en) Method and apparatus of maintaining data for online analytical processing in a database system
US20210034606A1 (en) Native persistent store support for blockchains
US7769789B2 (en) High performant row-level data manipulation using a data layer interface
US20050015393A1 (en) System and method of processing queries
US10248685B2 (en) Efficient determination of committed changes
US9542468B2 (en) Database management system and method for controlling synchronization between databases
DE102012210420A1 (de) Verfahren für ein systemeigenes Programm für das Übernehmen desselben Transaktionskontextes, wenn durch das in einer separaten Umgebung laufende primäre Programm aufgerufen
EP3120261A1 (en) Dependency-aware transaction batching for data replication
WO2001003037A3 (en) Workflow method and system
JPS648742A (en) Method of searching resource
US8161492B2 (en) Continuation based runtimes in transactions
Ali et al. Improving bug location using binary class relationships
US20160294726A1 (en) System and method for reducing communications overhead in a distributed transactions environment by modifying implementation of the transaction end function
CN103729391A (zh) 能够重新启动事务的客户端装置和数据库服务器及方法
MX2023006491A (es) Mejora del rendimiento de trabajos por lotes en arquitectura activo-activo.
Luiz et al. Mitra: Byzantine fault-tolerant middleware for transaction processing on replicated databases
Fu A proof theoretical approach to communication
Bryla et al. Oracle Database 12c The Complete Reference
US11301515B2 (en) Method and apparatus for generating data based on query content
US20240134879A1 (en) Keeping stable leadership in raft-based protocol with fast automatic failover
Niazi et al. Leader election using NewSQL database systems
EP0394019A3 (en) Computerised database system
US9984096B2 (en) System and method for reducing communications overhead in a distributed transactions environment by modifying implementation of the transaction start function
CN106874074B (zh) 一种基于软件事务内存的并发缺陷规避系统及方法