Transient data facility for database applications
AssigneeOracle Corporation
InventorsSanjin Tulac, Min Lu, Jon Rexford Degenhardt, Sudhakar Kaki
Life of this patent
Estimating the term…
Abstract
In one embodiment, a method for providing a transient data facility for database applications includes creating a definition of transient data that corresponds to a unit of work to be performed by an application, and mapping the definition of transient data to a temporary storage table. The method further includes storing the transient data in the temporary storage table while the application performs the unit of work spanning one or more user sessions, and deleting the transient data after the application completes the unit of work.
Claims22
A computerized method comprising:
- creating a definition of transient data corresponding to a unit of work to be performed by an application, wherein the definition of transient data comprises one or more fields that describe a format of one or more columns needed to store transient data;
- mapping the definition of transient data to one or more columns of a temporary storage table, wherein a format of a mapped column corresponds to the format described by at least one field of the one or more fields of the definition of transient data;
- storing the transient data in the one or more columns of the temporary storage table while the application performs the unit of work, the unit of work spanning one or more user sessions;
- and
- deleting the transient data from the temporary storage table after the application completes the unit of work.
A non-transitory machine-readable storage medium storing executable instructions to cause a machine to perform a method comprising:
- creating a definition of transient data corresponding to a unit of work to be performed by an application, wherein the definition of transient data comprises one or more fields that describe a format of one or more columns needed to store transient data;
- mapping the definition of transient data to one or more columns of a temporary storage table, wherein a format of a mapped column corresponds to the format described by at least one field of the one or more fields of the definition of transient data;
- storing the transient data in the one or more columns of the temporary storage table while the application performs the unit of work, the unit of work spanning one or more user sessions;
- and
- deleting the transient data from the temporary storage table after the application completes the unit of work.
A system comprising:
- a metadata repository to store a definition of transient data corresponding to a unit of work to be performed by an application, wherein the definition of transient data comprises one or more fields that describe a format of one or more columns needed to store transient data;
- a temporary storage table to store the transient data while the application performs the unit of work, the unit of work spanning one or more user sessions;
- and
- an object manager to map the definition of transient data to one or more columns of the temporary storage table, to use the mapping when processing the transient data, to store the transient data in the one or more columns of the temporary storage table, and to cause the transient data to be deleted from the temporary storage table after the application completes the unit of work, wherein a format of a mapped column of the temporary storage table corresponds to the format described by at least one field of the one or more fields of the definition of transient data.
Dependencies are inferred from the claim text.