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 Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (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
US8909604B1 (en) * 2013-03-06 2014-12-09 Gravic, Inc. Methods for returning a corrupted database to a known, correct state by selectively using redo and undo operations
CN104809199B (zh) 2015-04-24 2018-11-16 联动优势科技有限公司 一种数据库同步的方法和装置
US10296632B2 (en) 2015-06-19 2019-05-21 Sap Se Synchronization on reactivation of 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
WO2022116828A1 (en) 2022-06-09
AU2021390717A1 (en) 2023-06-15
CN116529722A (zh) 2023-08-01
IL301851A (en) 2023-06-01
GB202309848D0 (en) 2023-08-16
CA3192544A1 (en) 2022-06-09
DE112021005573T5 (de) 2023-08-24
AU2021390717B2 (en) 2023-09-21
US20220179852A1 (en) 2022-06-09
JP2023551830A (ja) 2023-12-13
US11461315B2 (en) 2022-10-04
GB2617015A (en) 2023-09-27

Similar Documents

Publication Publication Date Title
US9892153B2 (en) Detecting lost writes
US8572051B1 (en) Making parallel execution of structured query language statements fault-tolerant
EP3069276B1 (en) Method and apparatus of maintaining data for online analytical processing in a database system
US11586614B2 (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
EP3213230A1 (en) Efficient maintenance of column store indexes on memory-optimized tables
US20160259837A1 (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
WO2001003037A3 (en) Workflow method and system
Ali et al. Improving bug location using binary class relationships
US10318520B2 (en) System and method for reducing communications overhead in a distributed transactions environment by modifying implementation of the transaction end function
MX2023006491A (es) Mejora del rendimiento de trabajos por lotes en arquitectura activo-activo.
CA2395282A1 (en) Preserving consistency of passively-replicated non-deterministic objects
Luiz et al. Mitra: Byzantine fault-tolerant middleware for transaction processing on replicated databases
US11301515B2 (en) Method and apparatus for generating data based on query content
CN103729391A (zh) 能够重新启动事务的客户端装置和数据库服务器及方法
US9984096B2 (en) System and method for reducing communications overhead in a distributed transactions environment by modifying implementation of the transaction start function
Hemed et al. Brief announcement: concurrency-aware linearizability
WO2020106548A4 (en) Single entry combined functionality
GB2613484A (en) Shiftleft topology construction and information augmentation using machine learning
CN118170791A (zh) 一种sql防注入的实现方法及处理终端
CN106909674B (zh) 一种数据库统计信息更新的方法及装置
Geetha et al. Intelligent query processing from biotechnological database using co-operating agents based on FIPA standards and Hadoop, in a secure cloud environment