ZA200307863B - System and method for reorganizing stored data. - Google Patents
System and method for reorganizing stored data. Download PDFInfo
- 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
Links
- 238000000034 method Methods 0.000 title claims description 51
- 230000008521 reorganization Effects 0.000 claims description 64
- 230000008859 change Effects 0.000 claims description 26
- 238000012545 processing Methods 0.000 claims description 22
- 230000008569 process Effects 0.000 claims description 8
- 230000000694 effects Effects 0.000 claims description 7
- 238000010586 diagram Methods 0.000 description 8
- 238000007726 management method Methods 0.000 description 5
- 230000006870 function Effects 0.000 description 4
- 238000012217 deletion Methods 0.000 description 3
- 230000037430 deletion Effects 0.000 description 3
- 230000008901 benefit Effects 0.000 description 2
- 238000013500 data storage Methods 0.000 description 2
- 230000006872 improvement Effects 0.000 description 2
- 238000003780 insertion Methods 0.000 description 2
- 230000037431 insertion Effects 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 230000007246 mechanism Effects 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000008520 organization Effects 0.000 description 2
- 238000007792 addition Methods 0.000 description 1
- 230000004075 alteration Effects 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
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)
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 (ko) |
EP (1) | EP1379955A4 (ko) |
JP (1) | JP2004524632A (ko) |
KR (1) | KR20030094328A (ko) |
CN (1) | CN1555527A (ko) |
BR (1) | BR0208783A (ko) |
CA (1) | CA2443495A1 (ko) |
IL (2) | IL158292A0 (ko) |
WO (1) | WO2002082276A1 (ko) |
ZA (1) | ZA200307863B (ko) |
Families Citing this family (20)
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 | 泰康保险集团股份有限公司 | 一种文件重组的方法及设备 |
US12093254B1 (en) * | 2023-04-28 | 2024-09-17 | Ocient Holdings LLC | Query execution during storage formatting updates |
Family Cites Families (14)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
DE69126067T2 (de) * | 1990-06-29 | 1997-10-02 | Oracle Corp | Verfahren und Gerät zur Verwaltung von Zustandsidentifizierern zur effizienten Wiederherstellung |
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 |
-
2001
- 2001-04-09 US US09/829,164 patent/US7225206B2/en not_active Expired - Lifetime
-
2002
- 2002-04-09 CN CNA028097203A patent/CN1555527A/zh active Pending
- 2002-04-09 EP EP02725596A patent/EP1379955A4/en not_active Ceased
- 2002-04-09 CA CA002443495A patent/CA2443495A1/en not_active Abandoned
- 2002-04-09 KR KR10-2003-7013169A patent/KR20030094328A/ko not_active Application Discontinuation
- 2002-04-09 WO PCT/US2002/011254 patent/WO2002082276A1/en active Application Filing
- 2002-04-09 BR BR0208783-9A patent/BR0208783A/pt not_active IP Right Cessation
- 2002-04-09 IL IL15829202A patent/IL158292A0/xx unknown
- 2002-04-09 JP JP2002580176A patent/JP2004524632A/ja not_active Abandoned
-
2003
- 2003-10-07 IL IL158292A patent/IL158292A/en not_active IP Right Cessation
- 2003-10-08 ZA ZA200307863A patent/ZA200307863B/en unknown
Also Published As
Publication number | Publication date |
---|---|
EP1379955A4 (en) | 2006-07-12 |
US20020147736A1 (en) | 2002-10-10 |
CA2443495A1 (en) | 2002-10-17 |
EP1379955A1 (en) | 2004-01-14 |
BR0208783A (pt) | 2004-06-22 |
IL158292A (en) | 2008-07-08 |
JP2004524632A (ja) | 2004-08-12 |
IL158292A0 (en) | 2004-05-12 |
KR20030094328A (ko) | 2003-12-11 |
WO2002082276A1 (en) | 2002-10-17 |
CN1555527A (zh) | 2004-12-15 |
US7225206B2 (en) | 2007-05-29 |
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 | |
EP0097239A2 (en) | Method and apparatus for restoring data in a computing system | |
KR102214697B1 (ko) | 데이터베이스 관리 시스템에서 데이터 저장을 위한 공간 관리를 제공하는 컴퓨터 프로그램 | |
KR20210033880A (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) | 데이터베이스 관리 시스템에서 데이터 저장을 위한 공간 관리를 제공하는 컴퓨터 프로그램 |