DE60331909D1 - Verfahren und gerät zur speicherung von änderungsdaten in einer datenbank - Google Patents
Verfahren und gerät zur speicherung von änderungsdaten in einer datenbankInfo
- Publication number
- DE60331909D1 DE60331909D1 DE60331909T DE60331909T DE60331909D1 DE 60331909 D1 DE60331909 D1 DE 60331909D1 DE 60331909 T DE60331909 T DE 60331909T DE 60331909 T DE60331909 T DE 60331909T DE 60331909 D1 DE60331909 D1 DE 60331909D1
- Authority
- DE
- Germany
- Prior art keywords
- change data
- database
- storing change
- change
- change table
- 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 - Lifetime
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/25—Integrating or interfacing systems involving database management systems
- G06F16/254—Extract, transform and load [ETL] procedures, e.g. ETL data flows in data warehouses
-
- 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/2358—Change logging, detection, and notification
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99941—Database schema or data structure
- Y10S707/99943—Generating database or data structure, e.g. via user interface
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
- Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y10S707/00—Data processing: database and file management or data structures
- Y10S707/99951—File or database maintenance
- Y10S707/99952—Coherency, e.g. same view to multiple users
- Y10S707/99954—Version management
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
US10/140,818 US6999977B1 (en) | 2002-05-09 | 2002-05-09 | Method and apparatus for change data capture in a database system |
PCT/US2003/014431 WO2003096227A2 (en) | 2002-05-09 | 2003-05-09 | Method and apparatus for change data capture in a database system |
Publications (1)
Publication Number | Publication Date |
---|---|
DE60331909D1 true DE60331909D1 (de) | 2010-05-12 |
Family
ID=29418396
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
DE60331909T Expired - Lifetime DE60331909D1 (de) | 2002-05-09 | 2003-05-09 | Verfahren und gerät zur speicherung von änderungsdaten in einer datenbank |
Country Status (9)
Country | Link |
---|---|
US (1) | US6999977B1 (de) |
EP (1) | EP1502213B1 (de) |
JP (1) | JP4647308B2 (de) |
AT (1) | ATE463014T1 (de) |
AU (1) | AU2003232083B2 (de) |
CA (1) | CA2483039C (de) |
DE (1) | DE60331909D1 (de) |
HK (1) | HK1070447A1 (de) |
WO (1) | WO2003096227A2 (de) |
Families Citing this family (43)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7310653B2 (en) * | 2001-04-02 | 2007-12-18 | Siebel Systems, Inc. | Method, system, and product for maintaining software objects during database upgrade |
US7111023B2 (en) | 2001-05-24 | 2006-09-19 | Oracle International Corporation | Synchronous change data capture in a relational database |
US7657576B1 (en) | 2001-05-24 | 2010-02-02 | Oracle International Corporation | Asynchronous change capture for data warehousing |
US6999977B1 (en) | 2002-05-09 | 2006-02-14 | Oracle International Corp | Method and apparatus for change data capture in a database system |
US7647354B2 (en) | 2002-05-24 | 2010-01-12 | Oracle International Corporation | High-performance change capture for data warehousing |
US20040215656A1 (en) * | 2003-04-25 | 2004-10-28 | Marcus Dill | Automated data mining runs |
CA2427182A1 (en) * | 2003-04-29 | 2004-10-29 | Cognos Incorporated | Security filters in metadata modelling for reporting |
CA2427185A1 (en) * | 2003-04-29 | 2004-10-29 | Cognos Incorporated | Automated database query generation |
CA2427226A1 (en) * | 2003-04-29 | 2004-10-29 | Cognos Incorporated | Dynamic generation of dimensional metadata |
CA2427159A1 (en) * | 2003-04-29 | 2004-10-29 | Cognos Incorporated | Simplified metadata modelling for reporting |
US7624119B2 (en) * | 2004-02-11 | 2009-11-24 | International Business Machines Corporation | Low-overhead built-in timestamp column for relational database systems |
US7953749B2 (en) * | 2004-05-11 | 2011-05-31 | Oracel International Corporation | Providing the timing of the last committed change to a row in a database table |
US20060190501A1 (en) * | 2005-02-18 | 2006-08-24 | Sandy Massironi | System supporting data repository compatibility |
US20070027938A1 (en) * | 2005-07-26 | 2007-02-01 | Scribe Software Inc. | Detecting data changes |
US7840603B2 (en) * | 2005-11-14 | 2010-11-23 | International Business Machines Corporation | Method and apparatus for database change management |
US8856083B2 (en) * | 2006-06-09 | 2014-10-07 | Oracle International Corporation | Framework to optimize delete all row operations on database objects to improve throughput, query ability and flashback |
US8341646B2 (en) * | 2007-01-26 | 2012-12-25 | Sap Ag | Information system with event-enabled data objects |
US7984131B1 (en) * | 2007-06-28 | 2011-07-19 | Emc Corporation | Network configuration history tracking |
US20090106331A1 (en) * | 2007-10-22 | 2009-04-23 | General Electric Company | Dynamic two-stage clinical data archiving and retrieval solution |
US7769714B2 (en) * | 2007-11-06 | 2010-08-03 | Oracle International Corporation | Automatic error correction for replication and instantaneous instantiation |
KR101024494B1 (ko) * | 2008-07-18 | 2011-03-31 | (주)디에프아이비즈 | 메타데이타를 이용한 변경 데이타 추출방법 |
US8290260B2 (en) * | 2008-12-15 | 2012-10-16 | Xerox Corporation | Method and system for creating integrated remote custom rendering profile |
US8214324B2 (en) * | 2009-08-25 | 2012-07-03 | International Business Machines Corporation | Generating extract, transform, and load (ETL) jobs for loading data incrementally |
US9092474B2 (en) | 2010-10-12 | 2015-07-28 | Sap Se | Incremental conversion of database objects during upgrade of an original system |
US8984514B2 (en) | 2010-11-30 | 2015-03-17 | Sap Se | Modifying scheduled execution of object modification methods associated with database objects |
US8527471B2 (en) | 2010-12-27 | 2013-09-03 | Sap Ag | Shadow system mirroring of an original system during uptime of an upgrade process |
US9626390B2 (en) | 2010-12-27 | 2017-04-18 | Sap Se | Shadow system start during upgrade of an original system |
US8676757B2 (en) | 2011-10-18 | 2014-03-18 | Microsoft Corporation | Application of a differential dataset to a data store using sequential change sets |
US9213728B2 (en) | 2011-12-14 | 2015-12-15 | Sap Se | Change data capturing during an upgrade |
US9535932B1 (en) * | 2012-06-29 | 2017-01-03 | ParAccel, LLC | Backup and restore of databases |
KR101535703B1 (ko) * | 2012-09-28 | 2015-07-09 | 삼성에스디에스 주식회사 | 데이터 객체 변환 장치 및 방법 |
US9305067B2 (en) | 2013-07-19 | 2016-04-05 | International Business Machines Corporation | Creation of change-based data integration jobs |
US20150317567A1 (en) * | 2014-05-01 | 2015-11-05 | YeeJang James Lin | Business Change Management System |
MY188208A (en) | 2014-06-26 | 2021-11-24 | Mimos Berhad | System and method for managing change data in database |
US10922301B1 (en) * | 2016-07-26 | 2021-02-16 | Amdocs Development Limited | Apparatus, computer program, and method for trigger-based tracking of database modifications |
US10191930B2 (en) * | 2016-08-12 | 2019-01-29 | Sap Se | Priority queuing for updates in a database system |
KR101956236B1 (ko) | 2016-11-16 | 2019-03-11 | 주식회사 실크로드소프트 | 데이터베이스 관리 시스템에서의 데이터 복제 기법 |
US11423003B2 (en) * | 2017-12-11 | 2022-08-23 | Micro Focus Llc | Optimistic concurrency control for database transactions |
KR102119258B1 (ko) | 2018-11-14 | 2020-06-05 | 주식회사 실크로드소프트 | 데이터베이스 관리 시스템에서의 변경 데이터 캡쳐 구현 기법 |
KR20190022600A (ko) | 2019-02-25 | 2019-03-06 | 주식회사 실크로드소프트 | 데이터베이스 관리 시스템에서의 데이터 복제 기법 |
KR102225258B1 (ko) | 2019-04-18 | 2021-03-10 | 주식회사 실크로드소프트 | 데이터베이스 시스템에서 효율적인 변경 데이터 캡쳐를 제공하기 위한 컴퓨터 프로그램 |
KR20200056357A (ko) | 2020-03-17 | 2020-05-22 | 주식회사 실크로드소프트 | 데이터베이스 관리 시스템에서의 변경 데이터 캡쳐 구현 기법 |
US11909574B2 (en) * | 2021-06-01 | 2024-02-20 | Ciena Corporation | Grouping configuration-modifying transactions from collaborating agents |
Family Cites Families (12)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US5592660A (en) * | 1991-03-04 | 1997-01-07 | Fujitsu Limited | Database management system to alternately perform retrieval process and updating process |
US5280612A (en) | 1991-11-26 | 1994-01-18 | International Business Machines Corporation | Multiple version database concurrency control system |
US5553279A (en) | 1993-10-08 | 1996-09-03 | International Business Machines Corporation | Lossless distribution of time series data in a relational data base network |
US5710889A (en) * | 1995-02-22 | 1998-01-20 | Citibank, N.A. | Interface device for electronically integrating global financial services |
US5848405A (en) | 1997-04-21 | 1998-12-08 | Oracle Corporation | Method and apparatus for identifying new data by address ranges |
US5963959A (en) | 1997-05-30 | 1999-10-05 | Oracle Corporation | Fast refresh of snapshots |
US5926819A (en) | 1997-05-30 | 1999-07-20 | Oracle Corporation | In-line triggers |
US6125360A (en) | 1998-07-02 | 2000-09-26 | Oracle Corporation | Incremental maintenance of materialized views containing one-to-N lossless joins |
JP2938860B1 (ja) * | 1998-07-14 | 1999-08-25 | 三菱電機株式会社 | 分散型データ管理システム |
US6438538B1 (en) | 1999-10-07 | 2002-08-20 | International Business Machines Corporation | Data replication in data warehousing scenarios |
US7111023B2 (en) | 2001-05-24 | 2006-09-19 | Oracle International Corporation | Synchronous change data capture in a relational database |
US6999977B1 (en) | 2002-05-09 | 2006-02-14 | Oracle International Corp | Method and apparatus for change data capture in a database system |
-
2002
- 2002-05-09 US US10/140,818 patent/US6999977B1/en not_active Expired - Lifetime
-
2003
- 2003-05-09 WO PCT/US2003/014431 patent/WO2003096227A2/en active Application Filing
- 2003-05-09 EP EP03750092A patent/EP1502213B1/de not_active Expired - Lifetime
- 2003-05-09 AU AU2003232083A patent/AU2003232083B2/en not_active Expired
- 2003-05-09 JP JP2004504145A patent/JP4647308B2/ja not_active Expired - Lifetime
- 2003-05-09 DE DE60331909T patent/DE60331909D1/de not_active Expired - Lifetime
- 2003-05-09 CA CA2483039A patent/CA2483039C/en not_active Expired - Lifetime
- 2003-05-09 AT AT03750092T patent/ATE463014T1/de not_active IP Right Cessation
-
2005
- 2005-04-11 HK HK05103048.1A patent/HK1070447A1/xx not_active IP Right Cessation
Also Published As
Publication number | Publication date |
---|---|
HK1070447A1 (en) | 2005-06-17 |
WO2003096227A3 (en) | 2004-06-03 |
EP1502213A2 (de) | 2005-02-02 |
CA2483039C (en) | 2011-03-01 |
AU2003232083A1 (en) | 2003-11-11 |
ATE463014T1 (de) | 2010-04-15 |
WO2003096227A2 (en) | 2003-11-20 |
US6999977B1 (en) | 2006-02-14 |
JP4647308B2 (ja) | 2011-03-09 |
AU2003232083B2 (en) | 2008-11-06 |
EP1502213B1 (de) | 2010-03-31 |
JP2005524909A (ja) | 2005-08-18 |
CA2483039A1 (en) | 2003-11-20 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
ATE463014T1 (de) | Verfahren und gerät zur speicherung von änderungsdaten in einer datenbank | |
ATE450011T1 (de) | System und verfahren zur datenverarbeitung | |
DE69232761D1 (de) | Verfahren und vorrichtung zur aenderung von dynamische zuweisbaren objektcodedateien | |
DE60115607D1 (de) | Methode und system für die aktualisierung eines archivs einer datei | |
WO2003089995A3 (en) | Methods and apparatus for process, factory-floor, environmental, computer aided manufacturing-based or other control system with real-time data distribution | |
ATE372572T1 (de) | Vorrichtung und verfahren zur konfiguration von sprachlesern unter verwendung semantischer analyse | |
ATE352071T1 (de) | Verfahren und vorrichtung zur wahlweisen einstellung des zugangs zu anwendungsmerkmalen | |
EP1577797A3 (de) | Tabellenzugriff mit Befehlen aus natürlicher Sprache | |
ATE317992T1 (de) | Vorrichtung zur vermittlung von inhalten | |
WO2004003131A3 (en) | Method and system for controlling the development of biological entities | |
DE60227125D1 (de) | System, Verfahren und Computerprogramm zur Verwaltung von Dokumenten | |
DE60138753D1 (de) | Verfahren und Vorrichtung zur Erzeugung und Erhaltung von versionsspezifischen Eigenschaften in einer Datei | |
DE602005008800D1 (de) | Verfahren, Apparat und Computerprogramm zur stochastischen Simulation von Paleokanälen oder geologischen Paleostrukturen | |
WO2005036591A3 (en) | System and method for using first-principles simulation to facilitate a semiconductor manufacturing process | |
WO2007064896A3 (en) | Data exchange system and method | |
WO2004092974A3 (en) | System and method in a data table for managing insertion operations in recursive scalable template instances | |
TW200500890A (en) | Method and apparatus for analyzing claims in portfolios automatically | |
ATE387703T1 (de) | Auswahl eines musikstücks anhand von metadaten und einer externen tempo-eingabe | |
WO2003079139A3 (en) | System, method, and computer program product for network-based part management system | |
ATE370456T1 (de) | Verfahren und system zum automatisieren von internet-interaktionen | |
ATE361495T1 (de) | Verfahren und vorrichtung zur datensynchronisierung eines verteilten datenbanksystems | |
CN104731908A (zh) | 一种基于etl的数据清洗方法 | |
ATE305825T1 (de) | Verfahren und vorrichtung zur bearbeitung von postsendungen | |
DE60327020D1 (de) | Vorrichtung, Verfahren und computerlesbares Aufzeichnungsmedium zur Erkennung von Schlüsselwörtern in spontaner Sprache | |
CN105975675B (zh) | 一种导入本地文件在线编辑生成户型的方法 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
8364 | No opposition during term of opposition |