JP2004348744A5 - - Google Patents
Download PDFInfo
- Publication number
- JP2004348744A5 JP2004348744A5 JP2004152121A JP2004152121A JP2004348744A5 JP 2004348744 A5 JP2004348744 A5 JP 2004348744A5 JP 2004152121 A JP2004152121 A JP 2004152121A JP 2004152121 A JP2004152121 A JP 2004152121A JP 2004348744 A5 JP2004348744 A5 JP 2004348744A5
- Authority
- JP
- Japan
- Prior art keywords
- row
- sequence number
- transaction identifier
- transaction
- equal
- 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.)
- Granted
Links
- 239000003550 marker Substances 0.000 claims 52
- 238000003780 insertion Methods 0.000 claims 29
- 230000037431 insertion Effects 0.000 claims 29
- 238000000034 method Methods 0.000 claims 10
- 238000012217 deletion Methods 0.000 claims 7
- 230000037430 deletion Effects 0.000 claims 7
- 238000001914 filtration Methods 0.000 claims 7
- 238000012986 modification Methods 0.000 claims 6
- 230000004048 modification Effects 0.000 claims 6
- 238000013500 data storage Methods 0.000 claims 2
Applications Claiming Priority (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| US10/445,095 US7333992B2 (en) | 2003-05-22 | 2003-05-22 | System and method for identifying and storing changes made to a table |
| US10/445,095 | 2003-05-22 |
Publications (3)
| Publication Number | Publication Date |
|---|---|
| JP2004348744A JP2004348744A (ja) | 2004-12-09 |
| JP2004348744A5 true JP2004348744A5 (enExample) | 2007-07-05 |
| JP4806168B2 JP4806168B2 (ja) | 2011-11-02 |
Family
ID=33098041
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| JP2004152121A Expired - Fee Related JP4806168B2 (ja) | 2003-05-22 | 2004-05-21 | テーブルに対して行われる変更を識別する識別方法及びそのシステム |
Country Status (5)
| Country | Link |
|---|---|
| US (1) | US7333992B2 (enExample) |
| EP (1) | EP1480132B1 (enExample) |
| JP (1) | JP4806168B2 (enExample) |
| KR (1) | KR101085735B1 (enExample) |
| CN (1) | CN100465949C (enExample) |
Families Citing this family (22)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7640229B1 (en) * | 2003-12-15 | 2009-12-29 | Teradata Us, Inc. | Row triggers |
| KR101084816B1 (ko) | 2004-03-29 | 2011-11-21 | 마이크로소프트 코포레이션 | 버저닝 기반 트리거를 위한 시스템 및 방법 |
| CA2506756C (en) * | 2005-04-14 | 2008-08-12 | Rajesh Kapur | Method for preserving access to deleted and overwritten documents by means of a system recycle bin |
| CA2504070C (en) * | 2005-04-14 | 2006-11-14 | Computer Training Canada Ltd. | Method for preserving access to deleted and overwritten documents |
| US20060235903A1 (en) * | 2005-04-14 | 2006-10-19 | Rajesh Kapur | Method and system for retrieving deleted and overwritten documents |
| US7409413B2 (en) * | 2005-12-21 | 2008-08-05 | International Business Machines Corporation | Detecting granular data store changes |
| US7756821B2 (en) * | 2006-11-02 | 2010-07-13 | Microsoft Corporation | Virtual deletion in merged file system directories |
| US8290966B2 (en) * | 2007-11-29 | 2012-10-16 | Sap Aktiengesellschaft | System and method for implementing a non-destructive tree filter |
| US8868508B2 (en) | 2010-02-09 | 2014-10-21 | Google Inc. | Storage of data in a distributed storage system |
| US8352424B2 (en) * | 2010-02-09 | 2013-01-08 | Google Inc. | System and method for managing replicas of objects in a distributed storage system |
| US8615485B2 (en) * | 2010-02-09 | 2013-12-24 | Google, Inc. | Method and system for managing weakly mutable data in a distributed storage system |
| US9305069B2 (en) * | 2010-02-09 | 2016-04-05 | Google Inc. | Method and system for uploading data into a distributed storage system |
| US8862617B2 (en) * | 2010-02-09 | 2014-10-14 | Google Inc. | System and method for replicating objects in a distributed storage system |
| US8380659B2 (en) * | 2010-02-09 | 2013-02-19 | Google Inc. | Method and system for efficiently replicating data in non-relational databases |
| US8874523B2 (en) * | 2010-02-09 | 2014-10-28 | Google Inc. | Method and system for providing efficient access to a tape storage system |
| US9817879B2 (en) * | 2014-12-18 | 2017-11-14 | International Business Machines Corporation | Asynchronous data replication using an external buffer table |
| US9830558B1 (en) * | 2016-05-03 | 2017-11-28 | Sas Institute Inc. | Fast training of support vector data description using sampling |
| US11379433B2 (en) * | 2018-05-25 | 2022-07-05 | Microsoft Technology Licensing, Llc | Persistent version storage for relational database management system |
| CN110865829B (zh) * | 2018-08-28 | 2024-04-16 | 京东科技控股股份有限公司 | 数据库升级方法、系统、设备及存储介质 |
| US11138213B2 (en) * | 2019-04-10 | 2021-10-05 | Snowflake Inc. | Internal resource provisioning in database systems |
| CN113076326B (zh) * | 2021-03-25 | 2024-05-31 | 上海达梦数据库有限公司 | 一种大字段数据处理方法、装置、设备及存储介质 |
| CN114510495B (zh) * | 2022-04-21 | 2022-07-08 | 北京安华金和科技有限公司 | 一种数据库业务数据一致性处理方法和系统 |
Family Cites Families (27)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US4425618A (en) * | 1981-11-23 | 1984-01-10 | Bell Telephone Laboratories, Incorporated | Method and apparatus for introducing program changes in program-controlled systems |
| DE69126066T2 (de) * | 1990-06-29 | 1997-09-25 | Oracle Corp | Verfahren und Gerät zur Optimierung des Logbuchaufhebungsgebrauchs |
| JPH0540681A (ja) * | 1991-08-07 | 1993-02-19 | Nec Software Ltd | データベースの前進復旧方式 |
| US5561795A (en) * | 1994-05-13 | 1996-10-01 | Unisys Corporation | Method and apparatus for audit trail logging and data base recovery |
| JPH09106364A (ja) * | 1995-10-12 | 1997-04-22 | Nippon Telegr & Teleph Corp <Ntt> | 情報管理方法及び装置 |
| US5729744A (en) | 1996-06-10 | 1998-03-17 | International Business Machine Corp. | Method and system of enhanced versioning control of objects in a data processing system using change control information which includes reasons for changes |
| US5924096A (en) * | 1997-10-15 | 1999-07-13 | Novell, Inc. | Distributed database using indexed into tags to tracks events according to type, update cache, create virtual update log on demand |
| US6182086B1 (en) | 1998-03-02 | 2001-01-30 | Microsoft Corporation | Client-server computer system with application recovery of server applications and client applications |
| US6341288B1 (en) * | 1998-07-29 | 2002-01-22 | Sybase, Inc. | Database system with methodology for accessing a database from portable devices |
| US6275832B1 (en) * | 1998-09-21 | 2001-08-14 | International Business Machines Corporation | Providing transaction undo without logging |
| US6363387B1 (en) * | 1998-10-20 | 2002-03-26 | Sybase, Inc. | Database system providing methodology for enhancing concurrency using row update bit and deferred locking |
| US6397227B1 (en) * | 1999-07-06 | 2002-05-28 | Compaq Computer Corporation | Database management system and method for updating specified tuple fields upon transaction rollback |
| US6453313B1 (en) * | 1999-07-06 | 2002-09-17 | Compaq Information Technologies Group, L.P. | Database management system and method for dequeuing rows published to a database table |
| US6339772B1 (en) * | 1999-07-06 | 2002-01-15 | Compaq Computer Corporation | System and method for performing database operations on a continuous stream of tuples |
| US6542883B1 (en) * | 2000-03-09 | 2003-04-01 | International Business Machines Corporation | Ordering relational database operations according to referential integrity constraints |
| CA2302981C (en) * | 2000-03-29 | 2004-06-01 | Ibm Canada Limited-Ibm Canada Limitee | Online database table reorganization |
| US6636846B1 (en) | 2000-04-28 | 2003-10-21 | International Business Machines Corporation | Method for providing a system maintained materialized functionally dependent column for a database management system |
| JP2002032248A (ja) * | 2000-07-19 | 2002-01-31 | Ricoh Co Ltd | データベース問合せ処理におけるトランザクションの版の提供システム及び該システムにより提供された版を用いたデータベース問合せ処理システム |
| US6631374B1 (en) * | 2000-09-29 | 2003-10-07 | Oracle Corp. | System and method for providing fine-grained temporal database access |
| US6829616B2 (en) * | 2001-03-26 | 2004-12-07 | International Business Machines Corporation | Method, system, and program for implementing a database trigger |
| CA2445576C (en) * | 2001-04-27 | 2013-01-08 | W. Quinn, Inc. | Filter driver for identifying disk files by analysis of content |
| US7111023B2 (en) * | 2001-05-24 | 2006-09-19 | Oracle International Corporation | Synchronous change data capture in a relational database |
| JP3772105B2 (ja) * | 2001-09-21 | 2006-05-10 | 株式会社三菱東京Ufj銀行 | データベース管理装置、方法、プログラム及び記録媒体 |
| US6963878B2 (en) * | 2001-09-24 | 2005-11-08 | Microsoft Corporation | Generating a focused data set from an original data set |
| US6874001B2 (en) | 2001-10-05 | 2005-03-29 | International Business Machines Corporation | Method of maintaining data consistency in a loose transaction model |
| US6882993B1 (en) * | 2002-01-28 | 2005-04-19 | Oracle International Corporation | Incremental refresh of materialized views with joins and aggregates after arbitrary DML operations to multiple tables |
| US7076508B2 (en) * | 2002-08-12 | 2006-07-11 | International Business Machines Corporation | Method, system, and program for merging log entries from multiple recovery log files |
-
2003
- 2003-05-22 US US10/445,095 patent/US7333992B2/en not_active Expired - Fee Related
-
2004
- 2004-05-10 EP EP04011092.6A patent/EP1480132B1/en not_active Expired - Lifetime
- 2004-05-21 CN CNB2004100478005A patent/CN100465949C/zh not_active Expired - Fee Related
- 2004-05-21 KR KR1020040036457A patent/KR101085735B1/ko not_active Expired - Fee Related
- 2004-05-21 JP JP2004152121A patent/JP4806168B2/ja not_active Expired - Fee Related
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| JP2004348744A5 (enExample) | ||
| JP2014526735A5 (enExample) | ||
| JP2005509951A5 (enExample) | ||
| JP2011524587A5 (enExample) | ||
| JP4806168B2 (ja) | テーブルに対して行われる変更を識別する識別方法及びそのシステム | |
| JP2009187400A5 (enExample) | ||
| JP2008269503A5 (enExample) | ||
| JP2011527799A5 (enExample) | ||
| JP2006139780A5 (enExample) | ||
| JP2007287147A (ja) | 高速ファイル属性検索 | |
| WO2014157244A1 (ja) | ストレージ制御装置、ストレージ制御方法、およびストレージ制御プログラム | |
| CN106547477B (zh) | 用于在线地减少缓存设备的方法和装置 | |
| JP4304194B2 (ja) | ファイルシステム管理装置及び方法 | |
| CN106503260B (zh) | 一种提高数据库的有效存储空间的方法和装置 | |
| TW201308193A (zh) | 一種文件分配表的資料儲存方法 | |
| CN114595066B (zh) | 一种预留内存的处理方法、装置、电子设备和介质 | |
| CN114647619B (zh) | 存储设备的数据处理方法及装置 | |
| CN103425802A (zh) | 一种磁盘文件的快速检索方法 | |
| CN112698866A (zh) | 一种基于Git的代码行生命周期追溯方法及电子装置 | |
| JP2006216027A5 (enExample) | ||
| JP2020197787A5 (enExample) | ||
| JP2002366445A5 (enExample) | ||
| CN110737408B (zh) | 一种硬盘清除方法、系统及装置 | |
| JP2006018492A5 (enExample) | ||
| JP2006004157A5 (enExample) |