CN100386736C - 用于数据库的事务一致变化的跟踪的方法和系统 - Google Patents

用于数据库的事务一致变化的跟踪的方法和系统 Download PDF

Info

Publication number
CN100386736C
CN100386736C CNB2004100352346A CN200410035234A CN100386736C CN 100386736 C CN100386736 C CN 100386736C CN B2004100352346 A CNB2004100352346 A CN B2004100352346A CN 200410035234 A CN200410035234 A CN 200410035234A CN 100386736 C CN100386736 C CN 100386736C
Authority
CN
China
Prior art keywords
group
variation
consistent
affairs
variations
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.)
Expired - Fee Related
Application number
CNB2004100352346A
Other languages
English (en)
Chinese (zh)
Other versions
CN1540513A (zh
Inventor
S·L·沃德
J·M·贺林斯沃斯
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 CN1540513A publication Critical patent/CN1540513A/zh
Application granted granted Critical
Publication of CN100386736C publication Critical patent/CN100386736C/zh
Anticipated expiration legal-status Critical
Expired - Fee Related 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
    • G06F12/00—Accessing, addressing or allocating within memory systems or architectures
    • 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

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)
CNB2004100352346A 2003-04-01 2004-04-01 用于数据库的事务一致变化的跟踪的方法和系统 Expired - Fee Related CN100386736C (zh)

Applications Claiming Priority (2)

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

Publications (2)

Publication Number Publication Date
CN1540513A CN1540513A (zh) 2004-10-27
CN100386736C true CN100386736C (zh) 2008-05-07

Family

ID=32850586

Family Applications (1)

Application Number Title Priority Date Filing Date
CNB2004100352346A Expired - Fee Related CN100386736C (zh) 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)

Families Citing this family (53)

* 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
KR102271486B1 (ko) * 2020-10-13 2021-07-02 (주)소만사 데이터베이스에 저장된 개인정보의 보유현황 관리방법 및 장치
US11704335B2 (en) * 2020-11-13 2023-07-18 International Business Machines Corporation Data synchronization in a data analysis system
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

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5603024A (en) * 1993-10-08 1997-02-11 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
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
CN1271441A (zh) * 1997-07-21 2000-10-25 艾利森电话股份有限公司 一种关于数据库的方法

Family Cites Families (7)

* 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
US5590181A (en) * 1993-10-15 1996-12-31 Link Usa Corporation Call-processing system and method
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

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5603024A (en) * 1993-10-08 1997-02-11 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
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
CN1271441A (zh) * 1997-07-21 2000-10-25 艾利森电话股份有限公司 一种关于数据库的方法

Also Published As

Publication number Publication date
CN1540513A (zh) 2004-10-27
JP2005301329A (ja) 2005-10-27
EP1465085A2 (en) 2004-10-06
EP1465085A3 (en) 2006-04-19
US20040199552A1 (en) 2004-10-07
KR20040088397A (ko) 2004-10-16

Similar Documents

Publication Publication Date Title
CN100386736C (zh) 用于数据库的事务一致变化的跟踪的方法和系统
EP2260413B1 (en) Web content management
US11567681B2 (en) Method and system for synchronizing requests related to key-value storage having different portions
CN1680935B (zh) 通过用户建模的有效大写化文本的方法和系统
US20100250730A1 (en) Automated license reconciliation for deployed applications
US20100030824A1 (en) Statement logging in databases
US8756196B2 (en) Propagating tables while preserving cyclic foreign key relationships
CN110209735A (zh) 数据库备份方法、数据库备份装置、计算设备和存储介质
CN103593440B (zh) 日志文件的读写方法及装置
WO2017166815A1 (zh) 一种用于分布式数据库系统的更新数据的方法及装置
US20130097595A1 (en) Update scanning
Bejeck Kafka Streams in Action: Real-time apps and microservices with the Kafka Streams API
US11222022B2 (en) Method and system for searching a key-value storage
CN113918535A (zh) 一种数据读取方法、装置、设备及存储介质
CN103714062A (zh) 基于依赖关系导入实体-联系模型数据的方法和系统
CN111159040A (zh) 一种测试数据生成方法、装置、设备及存储介质
US7539934B2 (en) Computer-implemented method, system, and program product for developing a content annotation lexicon
CN108595488B (zh) 数据迁移方法和装置
US20230418833A1 (en) Generation of feature stores
CN107295060A (zh) 内容传送网络（cdn）中的无效
JP4299033B2 (ja) ジャーナル取得・配付装置、ジャーナル取得・配付方法、その方法をコンピュータに行わせるプログラム
CN113064943A (zh) 一种数据采集方法、装置、电子设备和存储介质
CN116821232A (zh) 一种数据同步方法及相关装置
CN118796865A (zh) 指标查询方法、装置、设备及存储介质
CN118069750A (zh) 数据处理方法和装置

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C14 Grant of patent or utility model
GR01 Patent grant
C17 Cessation of patent right
CF01 Termination of patent right due to non-payment of annual fee

Granted publication date: 20080507

Termination date: 20130401