Patent ID: 9348831
Filing Date: 2016-05-24
CPC Classification: G06F

Claim Text:
1. A computer-implemented method comprising: receiving, by a create transaction of a database system, a request to create a database system object, the database system object including a physical file to be stored on a database file system; generating, in a persistent file system object table, a persistent state record that includes a status of the database system object, wherein the persistent file system object table is a first table of the database system configured to store one or more references to physical files and a respective status of each of the one or more physical files, and the status of the database system object in the persistent state record indicates that the request to create the database system object is pending; creating the requested database system object, including writing, in a system catalog, an entry referencing the database system object and referencing the persistent file system object table, the system catalog being a second table of the database system that is different from the persistent file system object table; determining that the database system was interrupted before completion of the create transaction, wherein an interruption causes the entry in the system catalog to be unusable to reference the database system object or the persistent file system object table; determining that the entry in the system catalog is no longer usable to reference the database system object and no longer usable to reference the persistent file system object table, and that the status of the database system object in the persistent state record indicates that the request to create the database system object is pending, wherein determining that the database system object is associated with the persistent state record indicating that the request to create the database system object is pending comprises determining the status of the database system object as part of a crash recovery process; and in response to determining that the entry in the system catalog is unusable and that the database system object is associated with the persistent state record indicating that the request to create the database system object is pending, modifying the databased file system, including deleting the database system object from the database file system.