DBFS with flashback archive

Patent metadata

Field	Value
Publication number	US-10509773-B2
Application number	US-201514609265-A
Country	US
Kind code	B2
Filing date	Jan 29, 2015
Priority date	Jun 10, 2004
Publication date	Dec 17, 2019
Grant date	Dec 17, 2019

Abstract

A method for generating a query for version information on a file stored a database file system that is managed by a database server. When a client on a remote client machine sends a file operation request, the database management system, receives the file operation request and creates a database query for the requested file operation and an additional query for a set of version identifiers that identify the previous versions of the requested file of the requested file operation. The database management system executes the queries and generates a set of version identifiers, where each identifier from the set of version identifiers represents a specific version of the requested file at a particular point in time in the past.

First claim

What is claimed is:

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.

2. The method of claim 1 , wherein generating a set of version identifiers of the particular file further comprises using a transaction-based archiving mechanism to generate a set of versions of the particular file.

3. The method of claim 1 , wherein generating a set of version identifiers of the particular file further comprises generating a non-current version of the particular file with a version identifier.

4. The method of claim 1 , wherein generating a set of version identifiers of the particular file further comprises generating a non-current version of the particular file as a read-only version of the particular file.

5. The method of claim 1 , the method further comprising:
allowing a client to read a non-current version of the particular file; and
denying an update request on the non-current version of the particular file from the client.

6. The method of claim 1 , wherein generating a set of version identifiers of the particular file is configurable based upon a specified time range.

7. The method of claim 1 , wherein generating a set of version identifiers of the particular file is configurable for each database table within the database.

8. A system, the system comprising:
a memory;
one or more processors comprising a database management system configured to:
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 the database management system,
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.

9. The system of claim 8 , wherein the database management system configured to execute said particular database query thereby generating a set of version identifiers of the particular file further comprises using a transaction-based archiving mechanism to generate a set of versions of the particular file.

10. The system of claim 8 , wherein the database management system configured to execute said particular database query thereby generating a set of version identifiers of the particular file further comprises generating a non-current version of the particular file with a version identifier.

11. The system of claim 8 , wherein the database management system configured to execute said particular database query thereby generating a set of version identifiers of the particular file further comprises generating a non-current version of the particular file as a read-only version of the particular file.

12. The system of claim 8 , the system further comprising:
the database management system configured to allow a client to read a non-current version of the particular file; and
the database management system configured to deny an update request on the non-current version of the particular file from the client.

13. The system of claim 8 , wherein the database management system configured to execute said particular database query thereby generating a set of version identifiers of the particular file is configurable based upon a specified time range.

14. The system of claim 8 , wherein the database management system configured to execute said particular database query thereby generating a set of version identifiers of the particular file is configurable for each database table within the database.

15. One or more non-transitory computer-readable storage media storing instructions which, when executed by one or more computing devices, cause performance of a method comprising the steps of:
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 of 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.

16. The one or more non-transitory computer-readable storage media of clai

Assignees

• Oracle Int Corp

Inventors

• Morris Michael

Classifications

• G06F16/2474

  Sequence data queries, e.g. querying versioned data · CPC title

• G06F16/1873 Primary

  Versioning file systems, temporal file systems, e.g. file system supporting different historic versions of files · CPC title

• G06F16/9032 Primary

  Query formulation · CPC title