Oracle Corporation
Methods, systems, and computer readable media for recycling order identifiers

Abstract:

Methods, systems, and computer readable media for recycling order identifiers are disclosed. According to one method, the method occurs at an order management system that utilizes an order database. The order management system includes at least one processor and a memory. The method includes selecting, using an order block data structure, an order slot identifier from a range of order slot identifiers usable in a database partition of the order database, wherein the order slot identifier is reusable; storing order data for an order in the database partition using the order slot identifier; purging the order data in the database partition; and modifying, periodically or aperiodically, the order block data structure to indicate that the order slot identifier is available for reuse, wherein the order block data structure indicates a recycle count associated with usage.