WO2002027561A3 - System and method for providing fine-grained temporal database access - Google Patents

System and method for providing fine-grained temporal database access Download PDF

Info

Publication number
WO2002027561A3
WO2002027561A3 PCT/US2001/030538 US0130538W WO0227561A3 WO 2002027561 A3 WO2002027561 A3 WO 2002027561A3 US 0130538 W US0130538 W US 0130538W WO 0227561 A3 WO0227561 A3 WO 0227561A3
Authority
WO
WIPO (PCT)
Prior art keywords
row data
database
committed
transaction
database access
Prior art date
Application number
PCT/US2001/030538
Other languages
French (fr)
Other versions
WO2002027561A2 (en
Inventor
Jonathan D Klein
Amit Ganesh
Juan R Loaiza
Gary C Ngai
Original Assignee
Oracle 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 Oracle Corp filed Critical Oracle Corp
Priority to AU2001294896A priority Critical patent/AU2001294896B2/en
Priority to DE60142702T priority patent/DE60142702D1/en
Priority to AU9489601A priority patent/AU9489601A/en
Priority to EP01975583A priority patent/EP1358579B1/en
Priority to AT01975583T priority patent/ATE475935T1/en
Priority to JP2002531275A priority patent/JP2004512585A/en
Priority to CA002422887A priority patent/CA2422887C/en
Publication of WO2002027561A2 publication Critical patent/WO2002027561A2/en
Publication of WO2002027561A3 publication Critical patent/WO2002027561A3/en
Priority to HK03108921.4A priority patent/HK1056634A1/en

Links

Classifications

    • 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/24—Querying
    • G06F16/245—Query processing
    • G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2477—Temporal data queries
    • 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/99931—Database or file accessing
    • Y10S707/99938—Concurrency, e.g. lock management in shared database
    • 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
    • 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

Abstract

A system and method for selectively viewing temporal row data in a consistent read-implemented database are described. Committed transactions effecting row data changes to a database are tracked and a stored system change number is assigned upon each committed transaction. A queried selection of row data values from the database is performed as of a query time occurring prior to the commit time of at least one committed transaction. The ordered row data values contained in the rollback segments storing a transaction identifier for at least one committed transaction are retrieved.
PCT/US2001/030538 2000-09-29 2001-09-28 System and method for providing fine-grained temporal database access WO2002027561A2 (en)

Priority Applications (8)

Application Number Priority Date Filing Date Title
AU2001294896A AU2001294896B2 (en) 2000-09-29 2001-09-28 System and method for providing fine-grained temporal database access
DE60142702T DE60142702D1 (en) 2000-09-29 2001-09-28 SYSTEM AND METHOD FOR FINELY TIMELY ACCESS TO A DATABASE
AU9489601A AU9489601A (en) 2000-09-29 2001-09-28 System and method for providing fine-grained temporal database access
EP01975583A EP1358579B1 (en) 2000-09-29 2001-09-28 System and method for providing fine-grained temporal database access
AT01975583T ATE475935T1 (en) 2000-09-29 2001-09-28 SYSTEM AND METHOD FOR FINE-GRAINED TEMPORAL ACCESS TO A DATABASE
JP2002531275A JP2004512585A (en) 2000-09-29 2001-09-28 Systems and methods for providing fine-grained temporary database access
CA002422887A CA2422887C (en) 2000-09-29 2001-09-28 System and method for providing fine-grained temporal database access
HK03108921.4A HK1056634A1 (en) 2000-09-29 2003-12-09 System and method for providing fine-grained temporal database access

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US09/676,305 US6631374B1 (en) 2000-09-29 2000-09-29 System and method for providing fine-grained temporal database access
US09/676,305 2000-09-29

Publications (2)

Publication Number Publication Date
WO2002027561A2 WO2002027561A2 (en) 2002-04-04
WO2002027561A3 true WO2002027561A3 (en) 2003-08-28

Family

ID=24713993

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2001/030538 WO2002027561A2 (en) 2000-09-29 2001-09-28 System and method for providing fine-grained temporal database access

Country Status (9)

Country Link
US (3) US6631374B1 (en)
EP (1) EP1358579B1 (en)
JP (1) JP2004512585A (en)
AT (1) ATE475935T1 (en)
AU (2) AU2001294896B2 (en)
CA (1) CA2422887C (en)
DE (1) DE60142702D1 (en)
HK (1) HK1056634A1 (en)
WO (1) WO2002027561A2 (en)

Families Citing this family (176)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6618822B1 (en) * 2000-01-03 2003-09-09 Oracle International Corporation Method and mechanism for relational access of recovery logs in a database system
WO2002003219A1 (en) 2000-06-30 2002-01-10 Plurimus Corporation Method and system for monitoring online computer network behavior and creating online behavior profiles
US8650169B1 (en) 2000-09-29 2014-02-11 Oracle International Corporation Method and mechanism for identifying transaction on a row of data
US6631374B1 (en) 2000-09-29 2003-10-07 Oracle Corp. System and method for providing fine-grained temporal database access
US6799188B2 (en) * 2001-08-31 2004-09-28 Borland Software Corporation Transaction processing system providing improved methodology for two-phase commit decision
ATE434786T1 (en) 2001-09-20 2009-07-15 Hitwise Pty Ltd METHOD AND SYSTEM FOR CHARACTERIZING ONLINE BEHAVIOR
US6983286B1 (en) 2002-05-10 2006-01-03 Oracle International Corporation Method and apparatus for accessing data as it existed at a previous point in time
FR2844372B1 (en) * 2002-09-11 2005-01-14 Michel Zamfiroiu METHOD FOR ORGANIZING A DIGITAL DATABASE IN A TRACABLE FORM
US6976022B2 (en) * 2002-09-16 2005-12-13 Oracle International Corporation Method and mechanism for batch processing transaction logging records
US20040103084A1 (en) * 2002-11-21 2004-05-27 International Business Machines Corporation Data management system that provides flexible time-based query capability
US7333992B2 (en) * 2003-05-22 2008-02-19 Microsoft Corporation System and method for identifying and storing changes made to a table
US7647344B2 (en) * 2003-05-29 2010-01-12 Experian Marketing Solutions, Inc. System, method and software for providing persistent entity identification and linking entity information in an integrated data repository
US7395278B2 (en) * 2003-06-30 2008-07-01 Microsoft Corporation Transaction consistent copy-on-write database
US7480662B2 (en) * 2003-07-03 2009-01-20 Oracle International Corporation Fact table storage in a decision support system environment
US7552149B2 (en) * 2003-09-06 2009-06-23 Oracle International Corporation Querying past versions of data in a distributed database
KR100659971B1 (en) * 2003-12-26 2006-12-22 한국전자통신연구원 System for aborting web services automatically and method of the same
US7558917B2 (en) * 2004-02-13 2009-07-07 Microsoft Corporation Inverse query engine systems with cache and methods for cache maintenance
US7277885B2 (en) 2004-02-18 2007-10-02 Microsoft Corporation Systems and methods for filter processing using hierarchical data and data structures
US20080077612A1 (en) * 2004-03-05 2008-03-27 Bridgestream Working with temporal data
CN100461164C (en) * 2004-03-29 2009-02-11 微软公司 Systems and methods for versioning based triggers
US7499953B2 (en) 2004-04-23 2009-03-03 Oracle International Corporation Online recovery of user tables using flashback table
US7953749B2 (en) * 2004-05-11 2011-05-31 Oracel International Corporation Providing the timing of the last committed change to a row in a database table
US7574419B2 (en) * 2004-05-13 2009-08-11 Oracle International Corporation Automatic tuning of undo retention
US8756200B2 (en) * 2004-05-14 2014-06-17 Oracle International Corporation Undo advisor
US7240065B2 (en) * 2004-05-27 2007-07-03 Oracle International Corporation Providing mappings between logical time values and real time values
US7251660B2 (en) 2004-06-10 2007-07-31 Oracle International Corporation Providing mappings between logical time values and real time values in a multinode system
US7822727B1 (en) * 2004-07-02 2010-10-26 Borland Software Corporation System and methodology for performing read-only transactions in a shared cache
WO2006059251A2 (en) * 2004-08-19 2006-06-08 Copernic Technologies, Inc. Electronic mail indexing systems and methods
WO2006044357A2 (en) * 2004-10-13 2006-04-27 Copernic Technologies, Inc. Systems and methods for protecting private electronic data
US20060123001A1 (en) * 2004-10-13 2006-06-08 Copernic Technologies, Inc. Systems and methods for selecting digital advertisements
CA2484694A1 (en) * 2004-10-14 2006-04-14 Alcatel Database ram cache
US7814367B1 (en) * 2004-11-12 2010-10-12 Double-Take Software Canada, Inc. Method and system for time addressable storage
US7554908B2 (en) * 2004-12-10 2009-06-30 Intel Corporation Techniques to manage flow control
CN100387002C (en) * 2004-12-24 2008-05-07 华为技术有限公司 Method for testing mechanism of data rollback
US8103624B2 (en) 2005-01-13 2012-01-24 International Business Machines Corporation Apparatus and method for automating the logging of table changes in a database
US7403958B2 (en) * 2005-01-19 2008-07-22 International Business Machines Corporation Synchronization-replication concurrency using non-shared snapshot query on a history table at read-uncommitted isolation level
US7509307B2 (en) * 2005-01-19 2009-03-24 International Business Machines Corporation Redundant version information in history table that enables efficient snapshot querying
US8271448B2 (en) * 2005-01-28 2012-09-18 Oracle International Corporation Method for strategizing protocol presumptions in two phase commit coordinator
US8175889B1 (en) 2005-04-06 2012-05-08 Experian Information Solutions, Inc. Systems and methods for tracking changes of address based on service disconnect/connect data
US7908242B1 (en) 2005-04-11 2011-03-15 Experian Information Solutions, Inc. Systems and methods for optimizing database queries
US20070033157A1 (en) * 2005-08-08 2007-02-08 Simdesk Technologies Transaction protection in a stateless architecture using commodity servers
US7418544B2 (en) * 2005-10-05 2008-08-26 Oracle International Corporation Method and system for log structured relational database objects
US7634520B1 (en) * 2005-10-07 2009-12-15 Advent Software, Inc. Audit trail tools for transaction systems
US7801932B2 (en) * 2005-10-11 2010-09-21 Oracle International Corporation Undo hints to speed up segment extension and tuning of undo retention
US7885939B2 (en) * 2005-10-11 2011-02-08 Oracle International Corporation Longest query duration for auto tuning undo retention
US7716193B2 (en) * 2005-10-13 2010-05-11 Oracle International Corporation Ensuring timely servicing of desired transactions in a database server
US7552150B2 (en) * 2005-11-10 2009-06-23 International Business Machines Corporation Reason-based database changes
US20070168720A1 (en) * 2005-11-30 2007-07-19 Oracle International Corporation Method and apparatus for providing fault tolerance in a collaboration environment
JP4794571B2 (en) * 2005-12-02 2011-10-19 インターナショナル・ビジネス・マシーンズ・コーポレーション System and method for efficient access to database
EP1826692A3 (en) * 2006-02-22 2009-03-25 Copernic Technologies, Inc. Query correction using indexed content on a desktop indexer program.
US8635330B2 (en) * 2006-04-24 2014-01-21 Vmware, Inc. Method and system for learning web applications
US8386732B1 (en) * 2006-06-28 2013-02-26 Emc Corporation Methods and apparatus for storing collected network management data
US8005759B2 (en) 2006-08-17 2011-08-23 Experian Information Solutions, Inc. System and method for providing a score for a used vehicle
US7912865B2 (en) * 2006-09-26 2011-03-22 Experian Marketing Solutions, Inc. System and method for linking multiple entities in a business database
US8036979B1 (en) 2006-10-05 2011-10-11 Experian Information Solutions, Inc. System and method for generating a finance attribute from tradeline data
US8589357B2 (en) * 2006-10-20 2013-11-19 Oracle International Corporation Techniques for automatically tracking and archiving transactional data changes
US8627268B2 (en) * 2006-11-06 2014-01-07 International Business Machines Corporation System and method for a non-sequential undo mechanism
US20080120309A1 (en) * 2006-11-17 2008-05-22 Microsoft Corporation Storing, maintaining and locating information
GB0623333D0 (en) * 2006-11-23 2007-01-03 Ibm Software regression facility
US20080147603A1 (en) * 2006-12-14 2008-06-19 Olli Pekka Kostamaa Converting temporal data into time series data
US7873605B2 (en) * 2007-01-29 2011-01-18 Oracle International Corporation Apparatus to selectively remove the effects of transactions in online database and enable logical recovery
US8606666B1 (en) 2007-01-31 2013-12-10 Experian Information Solutions, Inc. System and method for providing an aggregation tool
US8285656B1 (en) 2007-03-30 2012-10-09 Consumerinfo.Com, Inc. Systems and methods for data verification
US7814117B2 (en) * 2007-04-05 2010-10-12 Oracle International Corporation Accessing data from asynchronously maintained index
US7742982B2 (en) 2007-04-12 2010-06-22 Experian Marketing Solutions, Inc. Systems and methods for determining thin-file records and determining thin-file risk levels
US20080294540A1 (en) 2007-05-25 2008-11-27 Celka Christopher J System and method for automated detection of never-pay data sets
US7886124B2 (en) * 2007-07-30 2011-02-08 Oracle International Corporation Method and mechanism for implementing dynamic space management for large objects
US8301574B2 (en) 2007-09-17 2012-10-30 Experian Marketing Solutions, Inc. Multimedia engagement study
US9690820B1 (en) 2007-09-27 2017-06-27 Experian Information Solutions, Inc. Database system for triggering event notifications based on updates to database records
US8290966B2 (en) * 2007-11-29 2012-10-16 Sap Aktiengesellschaft System and method for implementing a non-destructive tree filter
US7984020B2 (en) * 2007-12-06 2011-07-19 Sap Ag System and method for business object sync-point and rollback framework
US7996370B2 (en) * 2007-12-13 2011-08-09 International Business Machines Corporation System restoration apparatus and method for management of dependencies, ordering sensitivities, and database index rebuilds
US8341128B1 (en) * 2008-05-09 2012-12-25 Workday, Inc. Concurrency control using an effective change stack and tenant-based isolation
US8312033B1 (en) 2008-06-26 2012-11-13 Experian Marketing Solutions, Inc. Systems and methods for providing an integrated identifier
US7991689B1 (en) 2008-07-23 2011-08-02 Experian Information Solutions, Inc. Systems and methods for detecting bust out fraud using credit data
US8028194B2 (en) * 2008-07-25 2011-09-27 Inmage Systems, Inc Sequencing technique to account for a clock error in a backup system
US8745052B2 (en) * 2008-09-18 2014-06-03 Accenture Global Services Limited System and method for adding context to the creation and revision of artifacts
KR101259557B1 (en) * 2008-12-18 2013-04-30 한국전자통신연구원 Cluster data management system and method for data recovery using parallel processing in cluster data management system
US9256599B1 (en) * 2008-12-23 2016-02-09 Symantec Corporation Programmatically receiving and storing transaction information in support of a database recovery engine
US20100332292A1 (en) 2009-06-30 2010-12-30 Experian Information Solutions, Inc. System and method for evaluating vehicle purchase loyalty
US8364518B1 (en) 2009-07-08 2013-01-29 Experian Ltd. Systems and methods for forecasting household economics
US8228413B2 (en) * 2009-09-01 2012-07-24 Geovector Corp. Photographer's guidance systems
US8725613B1 (en) 2010-04-27 2014-05-13 Experian Information Solutions, Inc. Systems and methods for early account score and notification
US9092576B2 (en) * 2010-06-25 2015-07-28 International Business Machines Corporation Non-intrusive measurement of content quality using dry runs with roll-back
US9152727B1 (en) 2010-08-23 2015-10-06 Experian Marketing Solutions, Inc. Systems and methods for processing consumer information for targeted marketing applications
US8639616B1 (en) 2010-10-01 2014-01-28 Experian Information Solutions, Inc. Business to contact linkage system
US8782217B1 (en) 2010-11-10 2014-07-15 Safetyweb, Inc. Online identity management
US9147042B1 (en) 2010-11-22 2015-09-29 Experian Information Solutions, Inc. Systems and methods for data verification
US8515948B2 (en) 2011-03-09 2013-08-20 International Business Machines Corporation Managing materialized query tables (MQTS) over fine-grained access control (FGAC) protected tables
US8938429B1 (en) * 2011-03-31 2015-01-20 Emc Corporation Resynchronization of nonactive and active segments
US8818954B1 (en) 2011-03-31 2014-08-26 Emc Corporation Change tracking
US9767268B2 (en) 2011-04-20 2017-09-19 International Business Machines Corporation Optimizing a compiled access control table in a content management system
US8930330B1 (en) 2011-06-27 2015-01-06 Amazon Technologies, Inc. Validation of log formats
US8818944B2 (en) * 2011-06-30 2014-08-26 Microsoft Corporation Data change tracking and event notification
US9483606B1 (en) 2011-07-08 2016-11-01 Consumerinfo.Com, Inc. Lifescore
US8775299B2 (en) 2011-07-12 2014-07-08 Experian Information Solutions, Inc. Systems and methods for large-scale credit data processing
GB2494867A (en) 2011-09-19 2013-03-27 Cloudtran Inc Scalable distributed transaction processing method
US9390147B2 (en) * 2011-09-23 2016-07-12 Red Lambda, Inc. System and method for storing stream data in distributed relational tables with data provenance
US11030562B1 (en) 2011-10-31 2021-06-08 Consumerinfo.Com, Inc. Pre-data breach monitoring
US9853959B1 (en) 2012-05-07 2017-12-26 Consumerinfo.Com, Inc. Storage and maintenance of personal data
US9116935B2 (en) * 2012-10-31 2015-08-25 Sap Se Method and system to promote database cost savings
US9244961B2 (en) * 2012-12-14 2016-01-26 Oracle International Corporation Concurrent access for hierarchical data storage
US9747313B2 (en) * 2012-12-19 2017-08-29 Sap Se Timeline index for managing temporal data
US9596279B2 (en) 2013-02-08 2017-03-14 Dell Products L.P. Cloud-based streaming data receiver and persister
US9141680B2 (en) * 2013-02-11 2015-09-22 Dell Products L.P. Data consistency and rollback for cloud analytics
US9191432B2 (en) 2013-02-11 2015-11-17 Dell Products L.P. SAAS network-based backup system
US9442993B2 (en) 2013-02-11 2016-09-13 Dell Products L.P. Metadata manager for analytics system
US9697263B1 (en) 2013-03-04 2017-07-04 Experian Information Solutions, Inc. Consumer data request fulfillment system
US9244775B2 (en) 2013-03-14 2016-01-26 International Business Machines Corporation Reducing reading of database logs by persisting long-running transaction data
US10180951B2 (en) 2013-03-15 2019-01-15 Amazon Technologies, Inc. Place snapshots
US9672237B2 (en) 2013-03-15 2017-06-06 Amazon Technologies, Inc. System-wide checkpoint avoidance for distributed database systems
US11030055B2 (en) 2013-03-15 2021-06-08 Amazon Technologies, Inc. Fast crash recovery for distributed database systems
US9501501B2 (en) 2013-03-15 2016-11-22 Amazon Technologies, Inc. Log record management
US9514007B2 (en) 2013-03-15 2016-12-06 Amazon Technologies, Inc. Database system with database engine and separate distributed storage service
US10747746B2 (en) 2013-04-30 2020-08-18 Amazon Technologies, Inc. Efficient read replicas
US9317213B1 (en) * 2013-05-10 2016-04-19 Amazon Technologies, Inc. Efficient storage of variably-sized data objects in a data store
US9760596B2 (en) 2013-05-13 2017-09-12 Amazon Technologies, Inc. Transaction ordering
US9208032B1 (en) 2013-05-15 2015-12-08 Amazon Technologies, Inc. Managing contingency capacity of pooled resources in multiple availability zones
US10303564B1 (en) 2013-05-23 2019-05-28 Amazon Technologies, Inc. Reduced transaction I/O for log-structured storage systems
US9305056B1 (en) 2013-05-24 2016-04-05 Amazon Technologies, Inc. Results cache invalidation
US9047189B1 (en) 2013-05-28 2015-06-02 Amazon Technologies, Inc. Self-describing data blocks of a minimum atomic write size for a data store
US9128965B1 (en) 2013-08-07 2015-09-08 Amazon Technologies, Inc. Configurable-capacity time-series tables
US8886671B1 (en) 2013-08-14 2014-11-11 Advent Software, Inc. Multi-tenant in-memory database (MUTED) system and method
US9507843B1 (en) 2013-09-20 2016-11-29 Amazon Technologies, Inc. Efficient replication of distributed storage changes for read-only nodes of a distributed database
US9519664B1 (en) 2013-09-20 2016-12-13 Amazon Technologies, Inc. Index structure navigation using page versions for read-only nodes
US10216949B1 (en) 2013-09-20 2019-02-26 Amazon Technologies, Inc. Dynamic quorum membership changes
US9280591B1 (en) 2013-09-20 2016-03-08 Amazon Technologies, Inc. Efficient replication of system transactions for read-only nodes of a distributed database
US9460008B1 (en) 2013-09-20 2016-10-04 Amazon Technologies, Inc. Efficient garbage collection for a log-structured data store
US10223184B1 (en) 2013-09-25 2019-03-05 Amazon Technologies, Inc. Individual write quorums for a log-structured distributed storage system
US9552242B1 (en) 2013-09-25 2017-01-24 Amazon Technologies, Inc. Log-structured distributed storage using a single log sequence number space
US9699017B1 (en) 2013-09-25 2017-07-04 Amazon Technologies, Inc. Dynamic utilization of bandwidth for a quorum-based distributed storage system
US9767178B2 (en) 2013-10-30 2017-09-19 Oracle International Corporation Multi-instance redo apply
US9760480B1 (en) 2013-11-01 2017-09-12 Amazon Technologies, Inc. Enhanced logging using non-volatile system memory
US10387399B1 (en) 2013-11-01 2019-08-20 Amazon Technologies, Inc. Efficient database journaling using non-volatile system memory
US10102536B1 (en) 2013-11-15 2018-10-16 Experian Information Solutions, Inc. Micro-geographic aggregation system
US9880933B1 (en) 2013-11-20 2018-01-30 Amazon Technologies, Inc. Distributed in-memory buffer cache system using buffer cache nodes
US9529851B1 (en) 2013-12-02 2016-12-27 Experian Information Solutions, Inc. Server architecture for electronic data quality processing
US9223843B1 (en) 2013-12-02 2015-12-29 Amazon Technologies, Inc. Optimized log storage for asynchronous log updates
US9405788B2 (en) 2014-01-24 2016-08-02 International Business Machines Corporation Mass delete restriction in a database
US10262362B1 (en) 2014-02-14 2019-04-16 Experian Information Solutions, Inc. Automatic generation of code for attributes
US9576030B1 (en) 2014-05-07 2017-02-21 Consumerinfo.Com, Inc. Keeping up with the joneses
US10303663B1 (en) 2014-06-12 2019-05-28 Amazon Technologies, Inc. Remote durable logging for journaling file systems
US9563521B2 (en) * 2014-07-21 2017-02-07 Oracle International Corporation Data transfers between cluster instances with delayed log file flush
US9639565B2 (en) * 2014-09-04 2017-05-02 Sap Se Transaction support using intrusive hash tables
US9594713B2 (en) 2014-09-12 2017-03-14 Qualcomm Incorporated Bridging strongly ordered write transactions to devices in weakly ordered domains, and related apparatuses, methods, and computer-readable media
US9870386B1 (en) 2014-10-31 2018-01-16 Amazon Technologies, Inc. Reducing I/O operations for on-demand demand data page generation
US10242019B1 (en) 2014-12-19 2019-03-26 Experian Information Solutions, Inc. User behavior segmentation using latent topic detection
US9817587B1 (en) 2015-03-04 2017-11-14 Amazon Technologies, Inc. Memory-based on-demand data page generation
US10133768B2 (en) * 2015-04-14 2018-11-20 Microsoft Technology Licensing, Llc Latest external dependee entity in transaction record
US10592494B2 (en) 2015-04-14 2020-03-17 Microsoft Technology Licensing, Llc Collection record for overlapping data stream collections
US10102251B2 (en) 2015-04-14 2018-10-16 Microsoft Technology Licensing, Llc Lockless open collection data structure
US9959137B2 (en) 2015-04-14 2018-05-01 Microsoft Technology Licensing, Llc Transaction redo using skip element for object
US10031814B2 (en) 2015-04-14 2018-07-24 Microsoft Technology Licensing, Llc Collection record location as log tail beginning
US9690821B2 (en) 2015-05-14 2017-06-27 Walleye Software, LLC Computer data system position-index mapping
US10896096B2 (en) 2016-04-21 2021-01-19 International Business Machines Corporation Temporal logical transactions
US20170345001A1 (en) * 2016-05-27 2017-11-30 Bank Of America Corporation Failed resource usage monitor and remediation system
US10229012B2 (en) 2016-08-15 2019-03-12 Oracle International Corporation Committing copy-on-write transaction with a persist barrier for a persistent object including payload references
WO2018039377A1 (en) 2016-08-24 2018-03-01 Experian Information Solutions, Inc. Disambiguation and authentication of device users
US10474668B2 (en) * 2016-11-17 2019-11-12 Sap Se Database systems architecture incorporating distributed log
US10489356B1 (en) * 2016-12-19 2019-11-26 Amazon Technologies, Inc. Truncate and append database operation
CN116205724A (en) 2017-01-31 2023-06-02 益百利信息解决方案公司 Large scale heterogeneous data ingestion and user resolution
WO2018203377A1 (en) * 2017-05-01 2018-11-08 株式会社Ｍｕｒａｋｕｍｏ Database system, method, and program
US10241965B1 (en) 2017-08-24 2019-03-26 Deephaven Data Labs Llc Computer data distribution architecture connecting an update propagation graph through multiple remote query processors
US11914571B1 (en) 2017-11-22 2024-02-27 Amazon Technologies, Inc. Optimistic concurrency for a multi-writer database
US10963434B1 (en) 2018-09-07 2021-03-30 Experian Information Solutions, Inc. Data architecture for supporting multiple search models
US11138182B2 (en) * 2018-11-28 2021-10-05 Salesforce.Com, Inc. Compensating data corruption causing actions at runtime
US11086840B2 (en) 2018-12-07 2021-08-10 Snowflake Inc. Transactional streaming of change tracking data
CN111190935B (en) * 2019-08-27 2022-10-14 中国人民大学 Data reading method and device, computer equipment and storage medium
US11941065B1 (en) 2019-09-13 2024-03-26 Experian Information Solutions, Inc. Single identifier platform for storing entity data
US11874796B1 (en) 2019-09-27 2024-01-16 Amazon Technologies, Inc. Efficient garbage collection in optimistic multi-writer database systems
US11366802B1 (en) * 2019-09-27 2022-06-21 Amazon Technologies, Inc. Batch undo processing for transaction rollbacks in a multi-writer database
US11481285B1 (en) * 2019-11-19 2022-10-25 Cdw Llc Selective database data rollback
US11341163B1 (en) 2020-03-30 2022-05-24 Amazon Technologies, Inc. Multi-level replication filtering for a distributed database
US10936571B1 (en) * 2020-04-28 2021-03-02 Salesforce.Com, Inc. Undo based logical rewind in a multi-tenant system
US11379432B2 (en) 2020-08-28 2022-07-05 Bank Of America Corporation File management using a temporal database architecture
US11880377B1 (en) 2021-03-26 2024-01-23 Experian Information Solutions, Inc. Systems and methods for entity resolution

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5440730A (en) * 1990-08-09 1995-08-08 Bell Communications Research, Inc. Time index access structure for temporal databases having concurrent multiple versions
FR2746526A1 (en) * 1996-03-25 1997-09-26 Digital Equipment Corp Information in computer memory system maintaining
US6018746A (en) * 1997-12-23 2000-01-25 Unisys Corporation System and method for managing recovery information in a transaction processing system

Family Cites Families (73)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4498145A (en) 1982-06-30 1985-02-05 International Business Machines Corporation Method for assuring atomicity of multi-row update operations in a database system
US4868744A (en) 1986-03-03 1989-09-19 International Business Machines Corporation Method for restarting a long-running, fault-tolerant operation in a transaction-oriented data base system without burdening the system log
JP2718031B2 (en) 1987-07-17 1998-02-25 株式会社日立製作所 History information acquisition method
JPH07104868B2 (en) 1988-04-08 1995-11-13 インターナシヨナル・ビジネス・マシーンズ・コーポレーシヨン Data storage retrieval system
US5249300A (en) 1990-04-27 1993-09-28 Bachman Information Systems, Inc. System and method of constructing models of complex business transactions using entity-set variables for ordered sets of references to user data
DE69126066T2 (en) 1990-06-29 1997-09-25 Oracle Corp Method and device for optimizing logbook usage
US5317731A (en) * 1991-02-25 1994-05-31 International Business Machines Corporation Intelligent page store for concurrent and consistent access to a database by a transaction processor and a query processor
US5363473A (en) 1991-05-28 1994-11-08 The Trustees Of Columbia University In The City Of New York Incremental update process and apparatus for an inference system
US5347653A (en) * 1991-06-28 1994-09-13 Digital Equipment Corporation System for reconstructing prior versions of indexes using records indicating changes between successive versions of the indexes
US5701480A (en) * 1991-10-17 1997-12-23 Digital Equipment Corporation Distributed multi-version commitment ordering protocols for guaranteeing serializability during transaction processing
US5280612A (en) * 1991-11-26 1994-01-18 International Business Machines Corporation Multiple version database concurrency control system
US5469562A (en) 1992-06-26 1995-11-21 Digital Equipment Corporation Durable atomic storage update manager
JP2870308B2 (en) * 1992-07-14 1999-03-17 日本電気株式会社 Database management system
EP1003103B1 (en) * 1993-06-03 2008-10-01 Network Appliance, Inc. Write anywhere file-system layout method and apparatus
GB2281644A (en) 1993-09-02 1995-03-08 Ibm Fault tolerant transaction-oriented data processing.
US5642503A (en) * 1993-12-15 1997-06-24 Microsoft Corporation Method and computer system for implementing concurrent accesses of a database record by multiple users
JP3441807B2 (en) 1994-09-19 2003-09-02 株式会社日立製作所 B-tree index management method and system
US5819020A (en) 1995-10-16 1998-10-06 Network Specialists, Inc. Real time backup system
US5862318A (en) 1995-10-26 1999-01-19 Microsoft Corporation System for generating a gapless series of identity values
US5870758A (en) 1996-03-11 1999-02-09 Oracle Corporation Method and apparatus for providing isolation levels in a database system
GB2311391A (en) 1996-03-19 1997-09-24 Ibm Restart and recovery of OMG compliant transaction systems
US5850507A (en) 1996-03-19 1998-12-15 Oracle Corporation Method and apparatus for improved transaction recovery
US5852715A (en) 1996-03-19 1998-12-22 Emc Corporation System for currently updating database by one host and reading the database by different host for the purpose of implementing decision support functions
US5995980A (en) 1996-07-23 1999-11-30 Olson; Jack E. System and method for database update replication
US6321234B1 (en) 1996-09-18 2001-11-20 Sybase, Inc. Database server system with improved methods for logging transactions
US5835698A (en) 1996-09-20 1998-11-10 Novell, Inc. Unilaterally-controlled, time-insensitive, data-link recovery apparatus and method
US6014674A (en) 1996-11-14 2000-01-11 Sybase, Inc. Method for maintaining log compatibility in database systems
US5864849A (en) 1996-12-16 1999-01-26 Lucent Technologies Inc. System and method for restoring a multiple checkpointed database in view of loss of volatile memory
US5845292A (en) 1996-12-16 1998-12-01 Lucent Technologies Inc. System and method for restoring a distributed checkpointed database
US5996088A (en) 1997-01-22 1999-11-30 Oracle Corporation High-speed database checkpointing through sequential I/O to disk
US5930824A (en) * 1997-02-04 1999-07-27 International Business Machines Corporation System and method for demand-base data recovery
US5966706A (en) 1997-02-19 1999-10-12 At&T Corp Local logging in a distributed database management computer system
US5933838A (en) * 1997-03-10 1999-08-03 Microsoft Corporation Database computer system with application recovery and recovery log sequence numbers to optimize recovery
US5907848A (en) * 1997-03-14 1999-05-25 Lakeview Technology, Inc. Method and system for defining transactions from a database log
US5940839A (en) 1997-04-04 1999-08-17 Hewlett-Packard Company Fault-tolerant system and method of managing transaction failures in hierarchies
US6237001B1 (en) 1997-04-23 2001-05-22 Oracle Corporation Managing access to data in a distributed database environment
US5956731A (en) * 1997-04-23 1999-09-21 Oracle Corporation Sharing snapshots for consistent reads
US5873102A (en) 1997-04-29 1999-02-16 Oracle Corporation Pluggable tablespaces on a transportable medium
US5890167A (en) 1997-05-08 1999-03-30 Oracle Corporation Pluggable tablespaces for database systems
US6012060A (en) * 1997-05-30 2000-01-04 Oracle Corporation Sharing, updating data blocks among multiple nodes in a distributed system
US5963959A (en) 1997-05-30 1999-10-05 Oracle Corporation Fast refresh of snapshots
US6289335B1 (en) 1997-06-23 2001-09-11 Oracle Corporation Fast refresh of snapshots containing subqueries
US5890161A (en) * 1997-10-28 1999-03-30 Microsoft Corporation Automatic transaction processing of component-based server applications
US5999943A (en) 1997-10-31 1999-12-07 Oracle Corporation Lob locators
US6185699B1 (en) 1998-01-05 2001-02-06 International Business Machines Corporation Method and apparatus providing system availability during DBMS restart recovery
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
JPH11272529A (en) * 1998-03-25 1999-10-08 Canon Inc Constitution reproduction device, its method and storage medium
US6192377B1 (en) * 1998-05-13 2001-02-20 Oracle Corporation Method and apparatus for determing whether a transaction can use a version of a data item
US6138121A (en) * 1998-05-29 2000-10-24 Hewlett-Packard Company Network management event storage and manipulation using relational database technology in a data warehouse
US6192370B1 (en) 1998-06-19 2001-02-20 Sap Aktiengesellschaft Method and system for rapid memory-resident processing of transactional data
US6341288B1 (en) * 1998-07-29 2002-01-22 Sybase, Inc. Database system with methodology for accessing a database from portable devices
US6457021B1 (en) * 1998-08-18 2002-09-24 Microsoft Corporation In-memory database system
US6405217B1 (en) 1998-09-21 2002-06-11 Microsoft Corporation State-based implementation of transactions on a file system
US6363499B1 (en) 1998-09-21 2002-03-26 Microsoft Corporation Method and system for restoring a computer to its original state after an unsuccessful installation attempt
US6438749B1 (en) 1999-03-03 2002-08-20 Microsoft Corporation Method and system for restoring a computer to its original state after an unsuccessful patch installation attempt
US6529921B1 (en) * 1999-06-29 2003-03-04 Microsoft Corporation Dynamic synchronization of tables
US6480848B1 (en) * 1999-07-19 2002-11-12 International Business Machines Corporation Extension of data definition language (DDL) capabilities for relational databases for applications issuing DML and DDL statements
US6801915B1 (en) 1999-07-28 2004-10-05 Robert Mack Paired keys for data structures
US6513093B1 (en) 1999-08-11 2003-01-28 International Business Machines Corporation High reliability, high performance disk array storage system
US6640244B1 (en) 1999-08-31 2003-10-28 Accenture Llp Request batcher in a transaction services patterns environment
US7206805B1 (en) * 1999-09-09 2007-04-17 Oracle International Corporation Asynchronous transcription object management system
US6449624B1 (en) * 1999-10-18 2002-09-10 Fisher-Rosemount Systems, Inc. Version control and audit trail in a process control system
US6618822B1 (en) 2000-01-03 2003-09-09 Oracle International Corporation Method and mechanism for relational access of recovery logs in a database system
US6918053B1 (en) * 2000-04-28 2005-07-12 Microsoft Corporation Compensation framework for long running transactions
US6567928B1 (en) 2000-05-23 2003-05-20 International Business Machines Corporation Method and apparatus for efficiently recovering from a failure in a database that includes unlogged objects
US6769074B2 (en) 2000-05-25 2004-07-27 Lumigent Technologies, Inc. System and method for transaction-selective rollback reconstruction of database objects
US6631374B1 (en) 2000-09-29 2003-10-07 Oracle Corp. System and method for providing fine-grained temporal database access
US6804672B1 (en) * 2001-01-31 2004-10-12 Oracle International Corporation Method and mechanism for dependency tracking
US6889231B1 (en) 2002-08-01 2005-05-03 Oracle International Corporation Asynchronous information sharing system
US7103597B2 (en) * 2002-10-03 2006-09-05 Mcgoveran David O Adaptive transaction manager for complex transactions and business process
US7281023B2 (en) 2003-12-15 2007-10-09 At&T Knowledge Ventures, L.P. Architecture of database application with robust online recoverability
US7334002B2 (en) 2004-02-27 2008-02-19 Microsoft Corporation System and method for recovery units in databases
US7499953B2 (en) 2004-04-23 2009-03-03 Oracle International Corporation Online recovery of user tables using flashback table

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5440730A (en) * 1990-08-09 1995-08-08 Bell Communications Research, Inc. Time index access structure for temporal databases having concurrent multiple versions
FR2746526A1 (en) * 1996-03-25 1997-09-26 Digital Equipment Corp Information in computer memory system maintaining
US6018746A (en) * 1997-12-23 2000-01-25 Unisys Corporation System and method for managing recovery information in a transaction processing system

Non-Patent Citations (2)

* Cited by examiner, † Cited by third party
Title
AMAGASA T ET AL: "Implementing time-interval class for managing temporal data", PROCEEDINGS. INTERNATIONAL WORKSHOP ON DATABASE AND EXPERT SYSTEMS APPLICATIONS, XX, XX, 26 August 1998 (1998-08-26), pages 843 - 849, XP002167975 *
LEE C ET AL: "TEMPORAL GRID FILE: A FILE STRUCTURE FOR INTERVAL DATA", DATA & KNOWLEDGE ENGINEERING, AMSTERDAM, NL, vol. 26, no. 1, May 1998 (1998-05-01), pages 71 - 97, XP001004414 *

Also Published As

Publication number Publication date
HK1056634A1 (en) 2004-02-20
DE60142702D1 (en) 2010-09-09
EP1358579B1 (en) 2010-07-28
AU2001294896B2 (en) 2004-05-20
US20060212492A1 (en) 2006-09-21
CA2422887C (en) 2008-07-15
US6631374B1 (en) 2003-10-07
WO2002027561A2 (en) 2002-04-04
EP1358579A2 (en) 2003-11-05
ATE475935T1 (en) 2010-08-15
CA2422887A1 (en) 2002-04-04
US7937368B2 (en) 2011-05-03
AU9489601A (en) 2002-04-08
US7277900B1 (en) 2007-10-02
JP2004512585A (en) 2004-04-22

Similar Documents

Publication Publication Date Title
WO2002027561A3 (en) System and method for providing fine-grained temporal database access
US5564047A (en) Trigger generation in an active database management system
CN103927238B (en) Technique For Timeline Compression In Data Store
WO2001080177A3 (en) Interactive intelligent searching with executable suggestions
WO2002093420A3 (en) Method for managing distributed savepoints across multiple dbms's within a distributed transaction
MXPA05009733A (en) System and method to acquire information from a database.
CA2146171A1 (en) Method for Estimating Cardinalities for Query Processing in a Relational Database Management System
WO2002006999A3 (en) Performing spreadsheet-like calculations in a database system
EP0943997A3 (en) System and method for providing hot spare redundancy and recovery for a very large database management system
CA2371121A1 (en) Database management system with a multiple-level cache arrangement
CA2282022A1 (en) A system and method of optimizing database queries in two or more dimensions
CA2410798A1 (en) System and method allowing advertisers to manage search listings in a pay for placement search system using grouping
EP0783150A3 (en) System and method for space efficient object locking
CA2189307A1 (en) Method of commitment in a distributed database transaction
WO2001044082A3 (en) Method and system for tracking clustered items
CA2281287A1 (en) Method and system for efficiently searching for free space in a table of a relational database having a clustering index
WO2001009754A3 (en) Modular method and system for performing database queries
WO2003056805A3 (en) System and method for storing and distributing television viewing patterns from a clearinghouse
WO2003085490A3 (en) Patient oriented point of care system and method implementing same
WO2007038183A3 (en) Update processes in an enterprise planning system
WO2005116816A3 (en) Record management and retrieval computer program and method
WO2006105160A3 (en) Distributed search services for electronic data archive systems
WO2000079436A3 (en) Search engine interface
US20030177117A1 (en) Metadata system for managing data mining environments
US20050065939A1 (en) Method and system for optimizing snow flake queries

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A2

Designated state(s): AU CA JP

AL Designated countries for regional patents

Kind code of ref document: A2

Designated state(s): AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE TR

121 Ep: the epo has been informed by wipo that ep was designated in this application
DFPE Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101)
WWE Wipo information: entry into national phase

Ref document number: 2422887

Country of ref document: CA

WWE Wipo information: entry into national phase

Ref document number: 2002531275

Country of ref document: JP

WWE Wipo information: entry into national phase

Ref document number: 2001975583

Country of ref document: EP

Ref document number: 2001294896

Country of ref document: AU

WWP Wipo information: published in national office

Ref document number: 2001975583

Country of ref document: EP

WWG Wipo information: grant in national office

Ref document number: 2001294896

Country of ref document: AU