JP2005301329A - データベースのためのトランザクション整合性のある変更追跡 - Google Patents

データベースのためのトランザクション整合性のある変更追跡 Download PDF

Info

Publication number
JP2005301329A
JP2005301329A JP2004109421A JP2004109421A JP2005301329A JP 2005301329 A JP2005301329 A JP 2005301329A JP 2004109421 A JP2004109421 A JP 2004109421A JP 2004109421 A JP2004109421 A JP 2004109421A JP 2005301329 A JP2005301329 A JP 2005301329A
Authority
JP
Japan
Prior art keywords
changes
change
database
event
source
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
JP2004109421A
Other languages
English (en)
Japanese (ja)
Other versions
JP2005301329A5 (enExample
Inventor
Sandra L Ward
エル．ウォード サンドラ
John Matthew Hollingsworth
マシュー ホリングスワース ジョン
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.)
Microsoft Corp
Original Assignee
Microsoft Corp
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 Microsoft Corp filed Critical Microsoft Corp
Publication of JP2005301329A publication Critical patent/JP2005301329A/ja
Publication of JP2005301329A5 publication Critical patent/JP2005301329A5/ja
Pending legal-status Critical Current

Links

Images

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/275—Synchronous replication
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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
    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F12/00—Accessing, addressing or allocating within memory systems or architectures

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)
  • Computing Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
JP2004109421A 2003-04-01 2004-04-01 データベースのためのトランザクション整合性のある変更追跡 Pending JP2005301329A (ja)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
US10/404,229 US20040199552A1 (en) 2003-04-01 2003-04-01 Transactionally consistent change tracking for databases

Publications (2)

Publication Number Publication Date
JP2005301329A true JP2005301329A (ja) 2005-10-27
JP2005301329A5 JP2005301329A5 (enExample) 2007-05-24

Family

ID=32850586

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2004109421A Pending JP2005301329A (ja) 2003-04-01 2004-04-01 データベースのためのトランザクション整合性のある変更追跡

Country Status (5)

Country Link
US (1) US20040199552A1 (enExample)
EP (1) EP1465085A3 (enExample)
JP (1) JP2005301329A (enExample)
KR (1) KR20040088397A (enExample)
CN (1) CN100386736C (enExample)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR102271486B1 (ko) * 2020-10-13 2021-07-02 (주)소만사 데이터베이스에 저장된 개인정보의 보유현황 관리방법 및 장치
JP2022078978A (ja) * 2020-11-13 2022-05-25 インターナショナル・ビジネス・マシーンズ・コーポレーション データ分析システムにおけるデータ同期のためのコンピュータ実装方法、コンピュータプログラム製品およびコンピュータシステム（データ分析システムにおけるデータ同期）

Families Citing this family (51)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US8738568B2 (en) * 2011-05-05 2014-05-27 Oracle International Corporation User-defined parallelization in transactional replication of in-memory database
US8589346B2 (en) 2011-04-26 2013-11-19 Oracle International Corporation Techniques for combining statement level, procedural, and row level replication
US7155633B2 (en) * 2003-12-08 2006-12-26 Solid Data Systems, Inc. Exchange server method and system
KR100789771B1 (ko) * 2005-12-08 2007-12-28 한국전자통신연구원 트리거를 이용한 입력 데이터 스트림과 저장 데이터의 통합질의 처리 시스템 및 그 방법
US20070162516A1 (en) * 2005-12-30 2007-07-12 Microsoft Corporation Computing asynchronous transaction log replication progress based on file change notifications
EP1811404A1 (de) * 2006-01-20 2007-07-25 Ubs Ag Technik zum Beliefern eines Data Warehouse unter Gewährleistung einer konsistenten Datensicht
US7730538B2 (en) * 2006-06-02 2010-06-01 Microsoft Corporation Combining virus checking and replication filtration
US7801867B2 (en) * 2006-12-27 2010-09-21 Microsoft Corporation Optimizing backup and recovery utilizing change tracking
US7685189B2 (en) * 2006-12-27 2010-03-23 Microsoft Corporation Optimizing backup and recovery utilizing change tracking
KR100926880B1 (ko) * 2007-05-21 2009-11-16 엔에이치엔(주) Ｄｂｍｓ에서의 데이터 복제 방법 및 시스템
JP5020005B2 (ja) * 2007-09-06 2012-09-05 三洋電機株式会社 放送信号受信装置
US7483922B1 (en) 2007-11-07 2009-01-27 International Business Machines Corporation Methods and computer program products for transaction consistent content replication
US8306951B2 (en) 2009-09-18 2012-11-06 Oracle International Corporation Automated integrated high availability of the in-memory database cache and the backend enterprise database
KR101024494B1 (ko) * 2008-07-18 2011-03-31 (주)디에프아이비즈 메타데이타를 이용한 변경 데이타 추출방법
KR101014524B1 (ko) * 2008-09-22 2011-02-14 콘티넨탈 오토모티브 시스템 주식회사 데이터 일관성을 유지하는 임베디드 시스템의 데이터 리드 방법
US20110082832A1 (en) * 2009-10-05 2011-04-07 Ramkumar Vadali Parallelized backup and restore process and system
US20110258160A1 (en) * 2010-04-15 2011-10-20 Po-Yen Lee Data synchronization methods for synchronizing data in communication system and communication systems
US8738583B2 (en) * 2011-02-09 2014-05-27 Cisco Technology, Inc. Efficiently delivering event messages using compiled indexing and paginated reporting
US9128974B2 (en) * 2011-07-19 2015-09-08 Infosys Limited Methods for tracking database changes and devices thereof
US8521699B2 (en) * 2011-09-13 2013-08-27 Microsoft Corporation Tracking changes across collection of data tables
US8818947B2 (en) 2011-11-16 2014-08-26 Sap Ag Landscape transformation replication server
KR101535703B1 (ko) * 2012-09-28 2015-07-09 삼성에스디에스 주식회사 데이터 객체 변환 장치 및 방법
US9589041B2 (en) 2013-07-25 2017-03-07 Oracle International Corporation Client and server integration for replicating data
US10311154B2 (en) 2013-09-21 2019-06-04 Oracle International Corporation Combined row and columnar storage for in-memory databases for OLTP and analytics workloads
CN105718491A (zh) 2014-12-04 2016-06-29 阿里巴巴集团控股有限公司 数据库之间更新的方法及其装置
US9864816B2 (en) 2015-04-29 2018-01-09 Oracle International Corporation Dynamically updating data guide for hierarchical data objects
US11829349B2 (en) 2015-05-11 2023-11-28 Oracle International Corporation Direct-connect functionality in a distributed database grid
US10191944B2 (en) 2015-10-23 2019-01-29 Oracle International Corporation Columnar data arrangement for semi-structured data
US20170235770A1 (en) * 2016-02-17 2017-08-17 International Business Machines Corporation Method for restoring containers in a database based on priorities of the containers
US11442823B2 (en) 2016-06-03 2022-09-13 International Business Machines Corporation Transaction consistency query support for replicated data from recovery log to external data stores
US10216582B2 (en) 2016-08-15 2019-02-26 International Business Machines Corporation Recovery log analytics with a big data management platform
KR101956236B1 (ko) * 2016-11-16 2019-03-11 주식회사 실크로드소프트 데이터베이스 관리 시스템에서의 데이터 복제 기법
GB201704973D0 (en) * 2017-03-28 2017-05-10 Gb Gas Holdings Ltd Data replication system
US10803039B2 (en) 2017-05-26 2020-10-13 Oracle International Corporation Method for efficient primary key based queries using atomic RDMA reads on cache friendly in-memory hash index
US10719446B2 (en) 2017-08-31 2020-07-21 Oracle International Corporation Directly mapped buffer cache on non-volatile memory
US10802766B2 (en) 2017-09-29 2020-10-13 Oracle International Corporation Database with NVDIMM as persistent storage
US11086876B2 (en) 2017-09-29 2021-08-10 Oracle International Corporation Storing derived summaries on persistent memory of a storage device
US10732836B2 (en) 2017-09-29 2020-08-04 Oracle International Corporation Remote one-sided persistent writes
US10956335B2 (en) 2017-09-29 2021-03-23 Oracle International Corporation Non-volatile cache access using RDMA
US11675761B2 (en) 2017-09-30 2023-06-13 Oracle International Corporation Performing in-memory columnar analytic queries on externally resident data
WO2019097563A1 (ja) * 2017-11-14 2019-05-23 川崎重工業株式会社 車両監視システム
US11151111B2 (en) * 2017-11-30 2021-10-19 Futurewei Technologies, Inc. Redistributing table data in a database cluster
US11170002B2 (en) 2018-10-19 2021-11-09 Oracle International Corporation Integrating Kafka data-in-motion with data-at-rest tables
US11347714B2 (en) * 2018-11-06 2022-05-31 Snowflake Inc. Tracking changes in database data
US11086840B2 (en) * 2018-12-07 2021-08-10 Snowflake Inc. Transactional streaming of change tracking data
US11886439B1 (en) * 2019-08-27 2024-01-30 Amazon Technologies, Inc. Asynchronous change data capture for direct external transmission
US20220014598A1 (en) * 2020-07-09 2022-01-13 Ge Aviation Systems Llc Data service tracker module for a communication system and method of determining a set of data couplings
US11704327B2 (en) 2021-03-19 2023-07-18 International Business Machines Corporation Querying distributed databases
US11727022B2 (en) * 2021-03-19 2023-08-15 International Business Machines Corporation Generating a global delta in distributed databases
US11853319B1 (en) 2021-03-25 2023-12-26 Amazon Technologies, Inc. Caching updates appended to an immutable log for handling reads to the immutable log
US11803324B2 (en) 2021-12-10 2023-10-31 Nxp B.V. System and method for managing transactions in integrated circuits

Family Cites Families (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5701480A (en) * 1991-10-17 1997-12-23 Digital Equipment Corporation Distributed multi-version commitment ordering protocols for guaranteeing serializability during transaction processing
US5553279A (en) * 1993-10-08 1996-09-03 International Business Machines Corporation Lossless distribution of time series data in a relational data base network
US5613113A (en) * 1993-10-08 1997-03-18 International Business Machines Corporation Consistent recreation of events from activity logs
US5590181A (en) * 1993-10-15 1996-12-31 Link Usa Corporation Call-processing system and method
US5758150A (en) * 1995-10-06 1998-05-26 Tele-Communications, Inc. System and method for database synchronization
US5926819A (en) * 1997-05-30 1999-07-20 Oracle Corporation In-line triggers
SE510050C2 (sv) * 1997-07-21 1999-04-12 Ericsson Telefon Ab L M Metod för insamlande av logginformation vid förändring av databas
US6125360A (en) * 1998-07-02 2000-09-26 Oracle Corporation Incremental maintenance of materialized views containing one-to-N lossless joins
US6925476B1 (en) * 2000-08-17 2005-08-02 Fusionone, Inc. Updating application data including adding first change log to aggreagate change log comprising summary of changes
US6609126B1 (en) * 2000-11-15 2003-08-19 Appfluent Technology, Inc. System and method for routing database requests to a database and a cache
US7111023B2 (en) * 2001-05-24 2006-09-19 Oracle International Corporation Synchronous change data capture in a relational database
US7024584B2 (en) * 2003-01-09 2006-04-04 International Business Machines Corporation Method, system, and article of manufacture for maintaining data integrity

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
CSNB200200461001, ガルシア マルシ フロホック, Ｍｉｃｒｏｓｏｆｔ ＳＱＬ Ｓｅｒｖｅｒ ２０００ オフィシャルマニュアル 下, 20010319, 第１版, ｐ．７９−１２０, 日経ＢＰソフトプレス 岡村 宏平 *
JPN6009065714, ガルシア マルシ フロホック, Ｍｉｃｒｏｓｏｆｔ ＳＱＬ Ｓｅｒｖｅｒ ２０００ オフィシャルマニュアル 下, 20010319, 第１版, ｐ．７９−１２０, 日経ＢＰソフトプレス 岡村 宏平 *

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR102271486B1 (ko) * 2020-10-13 2021-07-02 (주)소만사 데이터베이스에 저장된 개인정보의 보유현황 관리방법 및 장치
JP2022078978A (ja) * 2020-11-13 2022-05-25 インターナショナル・ビジネス・マシーンズ・コーポレーション データ分析システムにおけるデータ同期のためのコンピュータ実装方法、コンピュータプログラム製品およびコンピュータシステム（データ分析システムにおけるデータ同期）
JP7773831B2 (ja) 2020-11-13 2025-11-20 インターナショナル・ビジネス・マシーンズ・コーポレーション データ分析システムにおけるデータ同期のためのコンピュータ実装方法、コンピュータプログラムおよびコンピュータシステム（データ分析システムにおけるデータ同期）

Also Published As

Publication number Publication date
CN1540513A (zh) 2004-10-27
EP1465085A2 (en) 2004-10-06
EP1465085A3 (en) 2006-04-19
US20040199552A1 (en) 2004-10-07
CN100386736C (zh) 2008-05-07
KR20040088397A (ko) 2004-10-16

Similar Documents

Publication Publication Date Title
JP2005301329A (ja) データベースのためのトランザクション整合性のある変更追跡
CN109656934B (zh) 基于日志解析的源端Oracle数据库DDL同步方法及设备
US7822710B1 (en) System and method for data collection
EP1877906B1 (en) Maintenance of link level consistency between database and file system
KR101099199B1 (ko) 데이터베이스 복구 중의 스냅샷 질의를 위한 시스템 및 방법
US6714943B1 (en) Method and mechanism for tracking dependencies for referential integrity constrained tables
US6728719B1 (en) Method and mechanism for dependency tracking for unique constraints
US8170981B1 (en) Computer method and system for combining OLTP database and OLAP database environments
JP4522170B2 (ja) リレーショナルデータベースのインデックス追加プログラム，インデックス追加装置及びインデックス追加方法
US9830372B2 (en) Scalable coordination aware static partitioning for database replication
JP4526876B2 (ja) データベースオブジェクトスクリプト生成方法およびシステム
US20090119346A1 (en) Automatic error correction for replication and instantaneous instantiation
CN100541489C (zh) 外部元数据处理
US7958167B2 (en) Integration of unstructed data into a database
JP2004362596A (ja) 自動タスク生成方法およびシステム
US8782013B1 (en) System and method for archiving data
CN110245037B (zh) 一种基于日志的Hive用户操作行为还原方法
CN106155832A (zh) 一种数据恢复的方法、装置及Android设备
CN109271452A (zh) Db2数据库数据同步更新方法及设备
US20050289186A1 (en) DDL replication without user intervention
CN114996734B (zh) 半透明加密列的数据管理方法、装置、设备及存储介质
Liu et al. Capturing global transactions from multiple recovery log files in a partitioned database system
CN116501767B (zh) 基于总线实时采集的高通量实体历史信息流式治理方法
CN112732331B (zh) 一种代码历史记录恢复方法、系统及介质
US20240346027A1 (en) Data Generation Based on Data Stored in Relational Databases

Legal Events

Date Code Title Description
A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20070402

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20070402

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20091218

A02 Decision of refusal

Free format text: JAPANESE INTERMEDIATE CODE: A02

Effective date: 20100518