ZA200307863B - System and method for reorganizing stored data. - Google Patents

System and method for reorganizing stored data. Download PDF

Info

Publication number
ZA200307863B
ZA200307863B ZA200307863A ZA200307863A ZA200307863B ZA 200307863 B ZA200307863 B ZA 200307863B ZA 200307863 A ZA200307863 A ZA 200307863A ZA 200307863 A ZA200307863 A ZA 200307863A ZA 200307863 B ZA200307863 B ZA 200307863B
Authority
ZA
South Africa
Prior art keywords
file
log
record
destination
reorganization
Prior art date
Application number
ZA200307863A
Other languages
English (en)
Inventor
Amando B Isip Jr
Original Assignee
Computer Ass Think Inc
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 Computer Ass Think Inc filed Critical Computer Ass Think Inc
Publication of ZA200307863B publication Critical patent/ZA200307863B/en

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F12/00—Accessing, addressing or allocating within memory systems or architectures
    • 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/22—Indexing; Data structures therefor; Storage structures
    • G06F16/2282—Tablespace storage structures; Management thereof
    • 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/99951—File or database maintenance
    • Y10S707/99952—Coherency, e.g. same view to multiple users
    • Y10S707/99953—Recoverability

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Software Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
ZA200307863A 2001-04-09 2003-10-08 System and method for reorganizing stored data. ZA200307863B (en)

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
US09/829,164 US7225206B2 (en) 2001-04-09 2001-04-09 System and method for reorganizing stored data

Publications (1)

Publication Number Publication Date
ZA200307863B true ZA200307863B (en) 2004-10-08

Family

ID=25253712

Family Applications (1)

Application Number Title Priority Date Filing Date
ZA200307863A ZA200307863B (en) 2001-04-09 2003-10-08 System and method for reorganizing stored data.

Country Status (10)

Country Link
US (1) US7225206B2 (xx)
EP (1) EP1379955A4 (xx)
JP (1) JP2004524632A (xx)
KR (1) KR20030094328A (xx)
CN (1) CN1555527A (xx)
BR (1) BR0208783A (xx)
CA (1) CA2443495A1 (xx)
IL (2) IL158292A0 (xx)
WO (1) WO2002082276A1 (xx)
ZA (1) ZA200307863B (xx)

Families Citing this family (19)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7085787B2 (en) 2002-07-19 2006-08-01 International Business Machines Corporation Capturing data changes utilizing data-space tracking
KR100644612B1 (ko) * 2004-04-26 2006-11-10 삼성전자주식회사 유알엘 정보 변경 방법, 라스트유알엘 정보 변경 장치 및 그 방법을 수행하는 프로그램이 기록된 컴퓨터 판독가능한 기록매체
US8131674B2 (en) 2004-06-25 2012-03-06 Apple Inc. Methods and systems for managing data
WO2006015536A1 (fr) * 2004-08-08 2006-02-16 Huawei Technologies Co. Ltd. Procede de notification d'une operation d'enregistrement
US7774304B2 (en) * 2005-01-31 2010-08-10 International Business Machines Corporation Method, apparatus and program storage device for managing buffers during online reorganization
DE102005019153A1 (de) * 2005-04-25 2007-06-06 Robert Bosch Gmbh Verfahren und System zum Verarbeiten von Daten
JP4683546B2 (ja) * 2005-07-15 2011-05-18 国立大学法人 東京大学 データベースの再編成方法及びデータベース再編成システム
US20070118574A1 (en) * 2005-11-22 2007-05-24 Franklin William J Reorganizing data with update activity
US7958091B2 (en) * 2006-02-16 2011-06-07 Ingrian Networks, Inc. Method for fast bulk loading data into a database while bypassing exit routines
JP2008204141A (ja) * 2007-02-20 2008-09-04 Nec Corp インデックス構成提案システムおよび方法ならびにデータ解析装置およびプログラム
US8225204B2 (en) 2008-03-27 2012-07-17 Kai Kei Cheng System and method of document reuse
US8234316B2 (en) * 2008-09-30 2012-07-31 Microsoft Corporation Nested file system support
US8166038B2 (en) * 2009-06-11 2012-04-24 Kaufman Mark A Intelligent retrieval of digital assets
KR101587995B1 (ko) * 2009-10-28 2016-01-22 삼성전자주식회사 적응적 로깅 장치 및 방법
US8527481B2 (en) * 2010-03-29 2013-09-03 International Business Machines Corporation Methods and systems for obtaining and correcting an index record for a virtual storage access method keyed sequential data set
CN102970158B (zh) * 2012-11-05 2017-02-08 广东睿江云计算股份有限公司 日志存储与处理的方法及日志服务器
US10521309B1 (en) * 2013-12-23 2019-12-31 EMC IP Holding Company LLC Optimized filesystem walk for backup operations
US10657275B2 (en) * 2015-06-02 2020-05-19 K2View Ltd Encryption directed database management system and method
CN111913916A (zh) * 2020-07-07 2020-11-10 泰康保险集团股份有限公司 一种文件重组的方法及设备

Family Cites Families (14)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP0465019B1 (en) * 1990-06-29 1997-05-14 Oracle Corporation Method and apparatus for managing state identifiers for efficient recovery
US5565316A (en) * 1992-10-09 1996-10-15 Educational Testing Service System and method for computer based testing
US6460036B1 (en) * 1994-11-29 2002-10-01 Pinpoint Incorporated System and method for providing customized electronic newspapers and target advertisements
US5721915A (en) 1994-12-30 1998-02-24 International Business Machines Corporation Interaction between application of a log and maintenance of a table that maps record identifiers during online reorganization of a database
US5832508A (en) 1996-09-18 1998-11-03 Sybase, Inc. Method for deallocating a log in database systems
US6070170A (en) * 1997-10-01 2000-05-30 International Business Machines Corporation Non-blocking drain method and apparatus used to reorganize data in a database
US6173292B1 (en) * 1998-03-04 2001-01-09 International Business Machines Corporation Data recovery in a transactional database using write-ahead logging and file caching
US6119128A (en) * 1998-03-30 2000-09-12 International Business Machines Corporation Recovering different types of objects with one pass of the log
US6122640A (en) 1998-09-22 2000-09-19 Platinum Technology Ip, Inc. Method and apparatus for reorganizing an active DBMS table
US6351744B1 (en) 1999-05-28 2002-02-26 Unisys Corporation Multi-processor system for database management
CA2302981C (en) * 2000-03-29 2004-06-01 Ibm Canada Limited-Ibm Canada Limitee Online database table reorganization
US6775679B2 (en) * 2001-03-20 2004-08-10 Emc Corporation Building a meta file system from file system cells
US7117229B2 (en) * 2001-05-31 2006-10-03 Computer Associates Think, Inc. Method and system for online reorganization of databases
US6985914B2 (en) * 2002-02-20 2006-01-10 Emc Corporation Cluster meta file system of file system cells managed by respective data movers of a network file server

Also Published As

Publication number Publication date
CN1555527A (zh) 2004-12-15
EP1379955A4 (en) 2006-07-12
EP1379955A1 (en) 2004-01-14
KR20030094328A (ko) 2003-12-11
JP2004524632A (ja) 2004-08-12
IL158292A0 (en) 2004-05-12
CA2443495A1 (en) 2002-10-17
BR0208783A (pt) 2004-06-22
US7225206B2 (en) 2007-05-29
IL158292A (en) 2008-07-08
WO2002082276A1 (en) 2002-10-17
US20020147736A1 (en) 2002-10-10

Similar Documents

Publication Publication Date Title
US7225206B2 (en) System and method for reorganizing stored data
US6243718B1 (en) Building indexes on columns containing large objects
US5999943A (en) Lob locators
US6360225B1 (en) System, method and computer program product for host variable support
US6567928B1 (en) Method and apparatus for efficiently recovering from a failure in a database that includes unlogged objects
US4498145A (en) Method for assuring atomicity of multi-row update operations in a database system
US6321234B1 (en) Database server system with improved methods for logging transactions
US6738790B1 (en) Approach for accessing large objects
US5903898A (en) Method and apparatus for user selectable logging
US6834275B2 (en) Transaction processing system using efficient file update processing and recovery processing
US6651073B1 (en) Method and apparatus for insuring database data integrity without data recovery logging
US6182241B1 (en) Method and apparatus for improved transaction recovery
US7933927B2 (en) Method and apparatus for building index of source data
US11567921B2 (en) Rowgroup consolidation with global delta accumulation and versioning in distributed systems
JPH0212460A (ja) 索引木への並列アクセスのためのデータ・アクセス方法およびデータ処理システム
US20090164524A1 (en) Shadow-page deferred-update recovery technique integrating shadow page and deferred update techniques in a storage system
EP0336548A2 (en) Supporting long fields of recoverable database records in a computer system
US20120317384A1 (en) Data storage method
EP0097239B1 (en) Method and apparatus for restoring data in a computing system
KR102214697B1 (ko) 데이터베이스 관리 시스템에서 데이터 저장을 위한 공간 관리를 제공하는 컴퓨터 프로그램
AU2002256151A1 (en) System and method for reorganizing stored data
WO2022212026A1 (en) Rowgroup consolidation with global delta accumulation and versioning in distributed systems
Diehr et al. Maintaining remote decision support databases
KR20210013747A (ko) 데이터베이스 관리 시스템에서 데이터 저장을 위한 공간 관리를 제공하는 컴퓨터 프로그램
Hvasshovd et al. The Record Oriented Approach