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

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Morris, Michael
• Primary Examiner(s): Leroux, Etienne P
• Application Number:
  US14/609,265
• Publication Number:
  US 20160224550A1
• Time in Patent Office: 1,783 Days
• CPC Class Codes: G06F 16/1873 Versioning file systems, temporal file systems, e.g. file system supporting different historic versions of files
• CPC Class Codes: G06F 16/2474 Sequence data queries, e.g. querying versioned data
• CPC Class Codes: G06F 16/9032 Query formulation

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.

Claims

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 claim 15, 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.

17. The one or more non-transitory computer-readable storage media of claim 15, 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.

18. The one or more non-transitory computer-readable storage media of claim 15, 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.

19. The one or more non-transitory computer-readable storage media of claim 15, the method further comprising the steps of:

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.

20. The one or more non-transitory computer-readable storage media of claim 15, wherein generating a set of version identifiers of the particular file is configurable based upon a specified time range.

21. The one or more non-transitory computer-readable storage media of claim 15, wherein generating a set of version identifiers of the particular file is configurable for each database table within the database.