CN100465949C - 用于识别和存储表格变化的系统和方法 - Google Patents
用于识别和存储表格变化的系统和方法 Download PDFInfo
- Publication number
- CN100465949C CN100465949C CNB2004100478005A CN200410047800A CN100465949C CN 100465949 C CN100465949 C CN 100465949C CN B2004100478005 A CNB2004100478005 A CN B2004100478005A CN 200410047800 A CN200410047800 A CN 200410047800A CN 100465949 C CN100465949 C CN 100465949C
- Authority
- CN
- China
- Prior art keywords
- row
- version
- affairs
- transaction number
- 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.)
- Expired - Fee Related
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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- General Physics & Mathematics (AREA)
- Computer Hardware Design (AREA)
- Mathematical Physics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Test And Diagnosis Of Digital Computers (AREA)
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 (11)
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 CN1609851A (zh) | 2005-04-27 |
CN100465949C true 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 (21)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7640229B1 (en) * | 2003-12-15 | 2009-12-29 | Teradata Us, Inc. | Row triggers |
US7200624B2 (en) * | 2004-03-29 | 2007-04-03 | Microsoft Corporation | Systems and methods for versioning based triggers |
CA2504070C (en) * | 2005-04-14 | 2006-11-14 | Computer Training Canada Ltd. | Method for preserving access to deleted and overwritten documents |
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 |
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 |
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 |
US8744997B2 (en) | 2010-02-09 | 2014-06-03 | Google Inc. | Pruning of blob replicas |
US8874523B2 (en) * | 2010-02-09 | 2014-10-28 | Google Inc. | Method and system for providing efficient access to a tape storage system |
US8380659B2 (en) | 2010-02-09 | 2013-02-19 | Google Inc. | Method and system for efficiently replicating data in non-relational databases |
US8868508B2 (en) * | 2010-02-09 | 2014-10-21 | Google Inc. | Storage of data in 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 |
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 |
CN114510495B (zh) * | 2022-04-21 | 2022-07-08 | 北京安华金和科技有限公司 | 一种数据库业务数据一致性处理方法和系统 |
Citations (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
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 |
US6275832B1 (en) * | 1998-09-21 | 2001-08-14 | International Business Machines Corporation | Providing transaction undo without logging |
US20010047360A1 (en) * | 2000-03-29 | 2001-11-29 | Huras Matthew A. | Online database table reorganization |
US6341288B1 (en) * | 1998-07-29 | 2002-01-22 | Sybase, Inc. | Database system with methodology for accessing a database from portable devices |
US6363387B1 (en) * | 1998-10-20 | 2002-03-26 | Sybase, Inc. | Database system providing methodology for enhancing concurrency using row update bit and deferred locking |
US20020174102A1 (en) * | 2001-04-27 | 2002-11-21 | Kyler Daniel B. | Filter driver for identifying disk files by analysis of content |
US20030061193A1 (en) * | 2001-09-24 | 2003-03-27 | Anson David L.A. | Generating a focused data set from an original data set |
JP2003099300A (ja) * | 2001-09-21 | 2003-04-04 | Bank Of Tokyo-Mitsubishi Ltd | データベース管理装置、方法、プログラム及び記録媒体 |
Family Cites Families (19)
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 |
US6182086B1 (en) | 1998-03-02 | 2001-01-30 | Microsoft Corporation | Client-server computer system with application recovery of server applications and client applications |
US6339772B1 (en) * | 1999-07-06 | 2002-01-15 | Compaq Computer Corporation | System and method for performing database operations on a continuous stream of tuples |
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 |
US6542883B1 (en) * | 2000-03-09 | 2003-04-01 | International Business Machines Corporation | Ordering relational database operations according to referential integrity constraints |
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 |
US7111023B2 (en) * | 2001-05-24 | 2006-09-19 | Oracle International Corporation | Synchronous change data capture in a relational database |
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 active IP Right Grant
- 2004-05-21 JP JP2004152121A patent/JP4806168B2/ja not_active Expired - Fee Related
Patent Citations (8)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
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 |
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 |
US20010047360A1 (en) * | 2000-03-29 | 2001-11-29 | Huras Matthew A. | Online database table reorganization |
US20020174102A1 (en) * | 2001-04-27 | 2002-11-21 | Kyler Daniel B. | Filter driver for identifying disk files by analysis of content |
JP2003099300A (ja) * | 2001-09-21 | 2003-04-04 | Bank Of Tokyo-Mitsubishi Ltd | データベース管理装置、方法、プログラム及び記録媒体 |
US20030061193A1 (en) * | 2001-09-24 | 2003-03-27 | Anson David L.A. | Generating a focused data set from an original data set |
Also Published As
Publication number | Publication date |
---|---|
KR20040101077A (ko) | 2004-12-02 |
EP1480132A2 (en) | 2004-11-24 |
CN1609851A (zh) | 2005-04-27 |
KR101085735B1 (ko) | 2011-11-21 |
EP1480132A3 (en) | 2006-05-10 |
JP4806168B2 (ja) | 2011-11-02 |
EP1480132B1 (en) | 2017-03-29 |
US20040236763A1 (en) | 2004-11-25 |
US7333992B2 (en) | 2008-02-19 |
JP2004348744A (ja) | 2004-12-09 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN100465949C (zh) | 用于识别和存储表格变化的系统和方法 | |
CN1477522B (zh) | 管理图像文件的方法和系统 | |
CN101167058B (zh) | 用于恢复文件的设备、方法和系统 | |
US7313572B2 (en) | Attribute partitioning for user extensibility | |
CN104090922B (zh) | 一种清理隐私数据的方法和装置 | |
CN110442585B (zh) | 数据更新方法、数据更新装置、计算机设备及存储介质 | |
CN102024046A (zh) | 数据重复性校验方法和装置及系统 | |
CN108875077A (zh) | 数据库的列存储方法、装置、服务器及存储介质 | |
US20080120270A1 (en) | Database system | |
US7653663B1 (en) | Guaranteeing the authenticity of the data stored in the archive storage | |
CN103064660A (zh) | 一种基于数组技术的电子合同版本控制方法 | |
EP1591914A1 (en) | Method, computer program product and device for importing a plurality of data sets into a system | |
CN101122975A (zh) | 库存管理方法 | |
US20070073765A1 (en) | Metadata-based schema generator | |
CN103605479B (zh) | 数据文件写入方法及系统、数据文件读取方法及系统 | |
CN107621924A (zh) | 一种基于云端清理固态硬盘数据的方法和装置 | |
US20070294316A1 (en) | Synchronization of application rules across database instances | |
CN109815213A (zh) | 一种Append-Only数据库上删除和修改数据的方法及系统 | |
CN115455059A (zh) | 一种基于底层数据解析用户行为的方法、装置及相关介质 | |
CN100498777C (zh) | 管理电子文件系统中的列表和其它项 | |
CN113407261A (zh) | 数据配置方法、装置和计算机设备 | |
CN112419058A (zh) | 数据管理方法和装置、存储介质及电子设备 | |
US7996366B1 (en) | Method and system for identifying stale directories | |
US8972335B2 (en) | Method and system for extracting information from electronic data sources | |
CN106101356A (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 | ||
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 | ||
CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20090304 Termination date: 20200521 |