JP4806168B2 - テーブルに対して行われる変更を識別する識別方法及びそのシステム - Google Patents

テーブルに対して行われる変更を識別する識別方法及びそのシステム Download PDF

Info

Publication number
JP4806168B2
JP4806168B2 JP2004152121A JP2004152121A JP4806168B2 JP 4806168 B2 JP4806168 B2 JP 4806168B2 JP 2004152121 A JP2004152121 A JP 2004152121A JP 2004152121 A JP2004152121 A JP 2004152121A JP 4806168 B2 JP4806168 B2 JP 4806168B2
Authority
JP
Japan
Prior art keywords
row
transaction
marker
sequence number
version
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
JP2004152121A
Other languages
English (en)
Japanese (ja)
Other versions
JP2004348744A (ja
JP2004348744A5 (enExample
Inventor
クリシュナムーアシー ガナパシー
ウェイ シャオ
アール．エリス ナイジェル
エヌ．クライン ロジャー
エイチ．アガーウォル サミート
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 Corp
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 JP2004348744A publication Critical patent/JP2004348744A/ja
Publication of JP2004348744A5 publication Critical patent/JP2004348744A5/ja
Application granted granted Critical
Publication of JP4806168B2 publication Critical patent/JP4806168B2/ja
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)
JP2004152121A 2003-05-22 2004-05-21 テーブルに対して行われる変更を識別する識別方法及びそのシステム Expired - Fee Related JP4806168B2 (ja)

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 JP2004348744A5 (enExample) 2007-07-05
JP4806168B2 true 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)

* 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
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)

* 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
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 株式会社三菱東京Ｕｆｊ銀行 データベース管理装置、方法、プログラム及び記録媒体
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

Also Published As

Publication number Publication date
KR20040101077A (ko) 2004-12-02
US7333992B2 (en) 2008-02-19
US20040236763A1 (en) 2004-11-25
KR101085735B1 (ko) 2011-11-21
CN100465949C (zh) 2009-03-04
JP2004348744A (ja) 2004-12-09
EP1480132A2 (en) 2004-11-24
EP1480132A3 (en) 2006-05-10
CN1609851A (zh) 2005-04-27
EP1480132B1 (en) 2017-03-29

Similar Documents

Publication Publication Date Title
JP4806168B2 (ja) テーブルに対して行われる変更を識別する識別方法及びそのシステム
US10901861B2 (en) Systems and methods of restoring a dataset of a database for a point in time
US6185569B1 (en) Linked data structure integrity verification system which verifies actual node information with expected node information stored in a table
US8180984B1 (en) System and method for consolidation of backups
CN112740198B (zh) 用于在数据库中提早移除墓碑记录的系统和方法
CN100337233C (zh) 事务文件系统
US7316015B2 (en) Method, apparatus, and program for constructing an execution environment, and computer readable medium recording program thereof
US6675257B1 (en) System and method for managing storage space on a sequential storage media
US20120005528A1 (en) Data set index record preservation
US6901418B2 (en) Data archive recovery
US20150039563A1 (en) Unobtrusive copies of actively used compressed indices
US7225206B2 (en) System and method for reorganizing stored data
WO2020119143A1 (zh) 一种数据库删除记录的恢复方法及系统
US20090216813A1 (en) Method and system for generating a transaction-bound sequence of records in a relational database table
CN114816470A (zh) 元数据库的管理方法、装置、电子设备和介质
US7653663B1 (en) Guaranteeing the authenticity of the data stored in the archive storage
CN113986974A (zh) 一种数据库事务管理方法及装置、恢复方法及装置
JP6585283B2 (ja) データ処理システム及びデータ処理方法
JP3730556B2 (ja) データベース管理システム
Khan Identifying factors affecting deleted file persistence through empirical study and analysis
CN111324484A (zh) 一种数据库误删数据的恢复方法、系统、终端及存储介质
AU2002256151A1 (en) System and method for reorganizing stored data
JP2011096211A (ja) 複数データベースのオンラインによるデータ処理方法及び処理プログラム

Legal Events

Date Code Title Description
A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20070521

A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20070521

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20100219

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20100519

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20100723

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20101025

A02 Decision of refusal

Free format text: JAPANESE INTERMEDIATE CODE: A02

Effective date: 20110225

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20110622

RD13 Notification of appointment of power of sub attorney

Free format text: JAPANESE INTERMEDIATE CODE: A7433

Effective date: 20110623

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A821

Effective date: 20110623

A911 Transfer to examiner for re-examination before appeal (zenchi)

Free format text: JAPANESE INTERMEDIATE CODE: A911

Effective date: 20110713

TRDD Decision of grant or rejection written
A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

Effective date: 20110805

A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20110812

R150 Certificate of patent or registration of utility model

Ref document number: 4806168

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150

Free format text: JAPANESE INTERMEDIATE CODE: R150

FPAY Renewal fee payment (event date is renewal date of database)

Free format text: PAYMENT UNTIL: 20140819

Year of fee payment: 3

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

S111 Request for change of ownership or part of ownership

Free format text: JAPANESE INTERMEDIATE CODE: R313113

R350 Written notification of registration of transfer

Free format text: JAPANESE INTERMEDIATE CODE: R350

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250

LAPS Cancellation because of no payment of annual fees