×

DBFS with flashback archive

  • US 10,509,773 B2
  • Filed: 01/29/2015
  • Issued: 12/17/2019
  • Est. Priority Date: 06/10/2004
  • Status: Active Grant
First Claim
Patent Images

1. A method comprising:

  • accessing a plurality of files stored in a database table through an application programming interface (API) that supports access primitives, said access primitives including creating a file, opening a file, and reading a file,wherein said database table is stored in a database managed by a database server,wherein said files include a particular file;

    in response to executing database transactions that make changes to the particular file, storing undo records in an undo tablespace in the database, said undo records recording information usable to undo said changes;

    archiving said undo records into a historical data tablespace in the database;

    receiving a file operation request to perform on the particular file;

    in response to receiving said file operation request;

    generating a particular database query that conforms to SQL (“

    Structure Query Language”

    ) to generate a set of version identifiers for the particular file, the particular database query being executable on the historical data tablespace with respect to a point in time in the past, said point in time being specified by a session context variable or as a parameter specified by the particular database query; and

    executing the particular database query thereby generating said set of version identifiers of the particular file, each version identifier of said set of version identifiers identifying a respective version of said particular file.

View all claims
  • 1 Assignment
Timeline View
Assignment View
    ×
    ×