CN100465949C - 用于识别和存储表格变化的系统和方法 - Google Patents

用于识别和存储表格变化的系统和方法 Download PDF

Info

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
transaction number
affairs
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
Application number
CNB2004100478005A
Other languages
English (en)
Chinese (zh)
Other versions
CN1609851A (zh
Inventor
G·克里西那莫西
W·肖
N·R·艾利斯
R·N·克莱恩
S·H·艾加瓦尔
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 Technology Licensing LLC
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 CN1609851A publication Critical patent/CN1609851A/zh
Application granted granted Critical
Publication of CN100465949C publication Critical patent/CN100465949C/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
    • 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 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/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)
CNB2004100478005A 2003-05-22 2004-05-21 用于识别和存储表格变化的系统和方法 Expired - Fee Related CN100465949C (zh)

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 (enExample)
EP (1) EP1480132B1 (enExample)
JP (1) JP4806168B2 (enExample)
KR (1) KR101085735B1 (enExample)
CN (1) CN100465949C (enExample)

Families Citing this family (22)

* Cited by examiner, † Cited by third party
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
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
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
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
US8380659B2 (en) 2010-02-09 2013-02-19 Google Inc. Method and system for efficiently replicating data in non-relational databases
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
US8352424B2 (en) * 2010-02-09 2013-01-08 Google Inc. System and method for managing replicas of objects in a distributed storage system
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 北京安华金和科技有限公司 一种数据库业务数据一致性处理方法和系统

Citations (8)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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
EP0465018B1 (en) * 1990-06-29 1997-05-14 Oracle Corporation Method and apparatus for optimizing undo log usage
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
US6397227B1 (en) * 1999-07-06 2002-05-28 Compaq Computer Corporation Database management system and method for updating specified tuple fields upon transaction rollback
US6339772B1 (en) * 1999-07-06 2002-01-15 Compaq Computer Corporation System and method for performing database operations on a continuous stream of tuples
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

Patent Citations (8)

* Cited by examiner, † Cited by third party
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
JP2004348744A (ja) 2004-12-09
KR20040101077A (ko) 2004-12-02
EP1480132B1 (en) 2017-03-29
EP1480132A3 (en) 2006-05-10
EP1480132A2 (en) 2004-11-24
US7333992B2 (en) 2008-02-19
KR101085735B1 (ko) 2011-11-21
US20040236763A1 (en) 2004-11-25
CN1609851A (zh) 2005-04-27
JP4806168B2 (ja) 2011-11-02

Similar Documents

Publication Publication Date Title
CN100465949C (zh) 用于识别和存储表格变化的系统和方法
US7219104B2 (en) Data cleansing
US8380671B2 (en) System and method for creating a new annotation for a data source
US8626717B2 (en) Database backup and restore with integrated index reorganization
US6185569B1 (en) Linked data structure integrity verification system which verifies actual node information with expected node information stored in a table
US7316015B2 (en) Method, apparatus, and program for constructing an execution environment, and computer readable medium recording program thereof
US20130339314A1 (en) Elimination of duplicate objects in storage clusters
CN110879813A (zh) 一种基于二进制日志解析的MySQL数据库增量同步实现方法
US8214377B2 (en) Method, system, and program for managing groups of objects when there are different group types
US6901418B2 (en) Data archive recovery
US7809764B2 (en) Method and apparatus for preserving dependancies during data transfer and replication
US6675257B1 (en) System and method for managing storage space on a sequential storage media
CN102629247A (zh) 一种数据处理方法、装置和系统
US7225206B2 (en) System and method for reorganizing stored data
WO2020119143A1 (zh) 一种数据库删除记录的恢复方法及系统
CN111897837A (zh) 数据查询方法、装置、设备和介质
CN115858471A (zh) 业务数据变更记录方法、装置、计算机设备及介质
US7653663B1 (en) Guaranteeing the authenticity of the data stored in the archive storage
CN114443653A (zh) 基于数据库数据字段枚举统一存取方法、系统、终端设备及存储介质
CN115878563B (zh) 一种分布式文件系统目录级快照的实现方法及电子设备
JP3730556B2 (ja) データベース管理システム
JP2000132435A (ja) 異種データベース管理システム間のデータ整合処理装置
JP3772105B2 (ja) データベース管理装置、方法、プログラム及び記録媒体
CN119848049B (zh) 数据库表管理方法、装置、设备及存储介质
CN116414882A (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

Granted publication date: 20090304

Termination date: 20200521

CF01 Termination of patent right due to non-payment of annual fee