CN1609851A - 用于识别和存储表格变化的系统和方法 - Google Patents
用于识别和存储表格变化的系统和方法 Download PDFInfo
- Publication number
- CN1609851A CN1609851A CNA2004100478005A CN200410047800A CN1609851A CN 1609851 A CN1609851 A CN 1609851A CN A2004100478005 A CNA2004100478005 A CN A2004100478005A CN 200410047800 A CN200410047800 A CN 200410047800A CN 1609851 A CN1609851 A CN 1609851A
- Authority
- CN
- China
- Prior art keywords
- row
- version
- sequence number
- equal
- mark
- 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
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F17/00—Digital computing or data processing equipment or methods, specially adapted for specific functions
- G06F17/40—Data acquisition and logging
-
- 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/99942—Manipulating data structure, e.g. compression, compaction, compilation
-
- 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/99941—Database schema or data structure
- Y10S707/99944—Object-oriented database structure
- Y10S707/99945—Object-oriented database structure processing
Abstract
Description
顾客标识符 | 姓名 | XID | SEQ |
101 | Andy | 30 | 1 |
102 | Bob | 30 | 2 |
103 | 30 | 3 | |
104 | Dave | 30 | 4 |
105 | Ed | 30 | 5 |
变化的XID | 变化的SEQ | 顾客标识符 | 姓名 | XID | SEQ |
30 | 3 | 103 | Chris | 20 | 3 |
30 | 2 | 102 | Betty | 20 | 2 |
30 | 1 | 101 | Alex | 20 | 1 |
30 | 1 | 101 | Adam | 10 | 1 |
主关键字 | 变化 |
102 | Delete |
102 | Insert |
103 | Delete |
104 | Insert |
顾客标识符 | 姓名 |
102 | Betty |
103 | Chris |
顾客标识符 | 姓名 |
102 | Bob |
104 | Dave |
顾客标识符 | 姓名 | XID | SEQ |
101 | Andy | 30 | 1 |
102 | Betty | 20 | 2 |
103 | Chris | 20 | 3 |
顾客标识符 | 姓名 | XID | SEQ |
102 | Betty | 20 | 2 |
103 | Chris | 20 | 3 |
顾客标识符 | 姓名 | XID | SEQ |
101 | Andy | 30 | 1 |
102 | Bob | 30 | 2 |
103 | 30 | 3 | |
104 | Dave | 30 | 4 |
顾客标识符 | 姓名 | XID | SEQ |
102 | Bob | 30 | 2 |
104 | Dave | 30 | 4 |
Claims (38)
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 (2)
Publication Number | Publication Date |
---|---|
CN1609851A true CN1609851A (zh) | 2005-04-27 |
CN100465949C CN100465949C (zh) | 2009-03-04 |
Family
ID=33098041
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNB2004100478005A Expired - Fee Related CN100465949C (zh) | 2003-05-22 | 2004-05-21 | 用于识别和存储表格变化的系统和方法 |
Country Status (5)
Country | Link |
---|---|
US (1) | US7333992B2 (zh) |
EP (1) | EP1480132B1 (zh) |
JP (1) | JP4806168B2 (zh) |
KR (1) | KR101085735B1 (zh) |
CN (1) | CN100465949C (zh) |
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 |
CN100461164C (zh) | 2004-03-29 | 2009-02-11 | 微软公司 | 用于基于版本控制的触发器的系统和方法 |
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 |
US20060235903A1 (en) * | 2005-04-14 | 2006-10-19 | Rajesh Kapur | Method and system for retrieving deleted and overwritten documents |
CA2504070C (en) * | 2005-04-14 | 2006-11-14 | Computer Training Canada Ltd. | Method for preserving access to 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 |
US8862617B2 (en) * | 2010-02-09 | 2014-10-14 | Google Inc. | System and method for replicating 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 |
US8886602B2 (en) | 2010-02-09 | 2014-11-11 | Google Inc. | Location assignment daemon (LAD) for a distributed storage system |
US8868508B2 (en) | 2010-02-09 | 2014-10-21 | Google Inc. | Storage of 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 |
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 |
CN113076326A (zh) * | 2021-03-25 | 2021-07-06 | 上海达梦数据库有限公司 | 一种大字段数据处理方法、装置、设备及存储介质 |
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 |
US7024403B2 (en) * | 2001-04-27 | 2006-04-04 | Veritas Operating Corporation | 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 KR KR1020040036457A patent/KR101085735B1/ko active IP Right Grant
- 2004-05-21 CN CNB2004100478005A patent/CN100465949C/zh not_active Expired - Fee Related
- 2004-05-21 JP JP2004152121A patent/JP4806168B2/ja not_active Expired - Fee Related
Also Published As
Publication number | Publication date |
---|---|
JP2004348744A (ja) | 2004-12-09 |
EP1480132B1 (en) | 2017-03-29 |
US7333992B2 (en) | 2008-02-19 |
KR20040101077A (ko) | 2004-12-02 |
EP1480132A3 (en) | 2006-05-10 |
KR101085735B1 (ko) | 2011-11-21 |
CN100465949C (zh) | 2009-03-04 |
JP4806168B2 (ja) | 2011-11-02 |
EP1480132A2 (en) | 2004-11-24 |
US20040236763A1 (en) | 2004-11-25 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN1609851A (zh) | 用于识别和存储表格变化的系统和方法 | |
CN102804168B (zh) | 在数据库系统中减少存储需求的数据压缩 | |
US7200624B2 (en) | Systems and methods for versioning based triggers | |
US20140236906A1 (en) | Elimination of duplicate objects in storage clusters | |
CN101067822A (zh) | 用于元数据的分级存储管理的方法和系统 | |
US20020129028A1 (en) | System and method for managing file system extended attributes | |
CN1783072A (zh) | 便于使用的数据上下文过滤 | |
US20140344218A1 (en) | Paging hierarchical data | |
CN112740198A (zh) | 用于在数据库中提早移除墓碑记录的系统和方法 | |
CN101039278A (zh) | 数据管理方法及系统 | |
CN1975731A (zh) | 用于管理对数据库中数据的访问的系统和方法 | |
US7519636B2 (en) | Key sequenced clustered I/O in a database management system | |
CN1552022A (zh) | 文件归档 | |
CN101178726A (zh) | 数据文件解归档的方法和系统 | |
JP2022500723A (ja) | データベースにおいてレコードを一括削除するためのシステムおよび方法 | |
CN1773497A (zh) | 用于组织计算机系统内的文件的方法和系统 | |
CN1900935A (zh) | 访问扇区数据的方法和系统 | |
CN1275160C (zh) | 一种数据库备份方法 | |
KR101670473B1 (ko) | MySQL InnoDB 데이터베이스에서 삭제된 데이터를 복원하는 방법 | |
CN1791873A (zh) | 还原数据库系统中的对象和从属对象 | |
CN101122975A (zh) | 库存管理方法 | |
CN115858471A (zh) | 业务数据变更记录方法、装置、计算机设备及介质 | |
AU2020250158B2 (en) | Reducing number of queries on a relational database | |
CN1542653A (zh) | 用于生成对关于选择对象的信息的请求的系统和方法 | |
US7996366B1 (en) | Method and system for identifying stale directories |
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 | ||
ASS | Succession or assignment of patent right |
Owner name: MICROSOFT TECHNOLOGY LICENSING LLC Free format text: FORMER OWNER: MICROSOFT CORP. Effective date: 20150429 |
|
C41 | Transfer of patent application or patent right or utility model | ||
TR01 | Transfer of patent right |
Effective date of registration: 20150429 Address after: Washington State Patentee after: Micro soft technique license Co., Ltd Address before: Washington State Patentee before: Microsoft Corp. |
|
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20090304 Termination date: 20200521 |
|
CF01 | Termination of patent right due to non-payment of annual fee |