Abstract: Systems and methods for reclaiming and reusing primary key values are provided. According to one embodiment, multiple unused primary key values of a database application are reclaimed by a key generator by locating a gap in a sequence of a primary key column of the database application. Reuse of the reclaimed unused primary key values is facilitated by the key generator by returning a reclaimed unused primary key value responsive to a request from the database system for a new primary key value for the primary key column.

Abstract: Methods and systems for facilitating distribution of application functionality across a multi-tier client-server architecture are provided. According to one embodiment, multiple data points from a database associated with a server computer system are cached into a hierarchical data map representing a random access memory-resident data structure. Each of the data points includes a field name and a calculated value. A request, containing input values that are to be stored within the hierarchical data map, is received by the server computer system from a client computer system. Responsive to the request: (i) the input values are transferred to target data points of the multiple data points; (ii) the calculated value of at least one of the data points is updated based on the target data points and a formula corresponding to the calculated value; and (iii) changed contents within the hierarchical data map are persisted to the database.

Abstract: An intelligent framework is provided that is disposed between a high-level language environment and a database system environment. According to one embodiment, the framework programmatically receives information regarding definitions of data structures of objects participating in a software application and information regarding relationships among the objects. Based upon the particular request from the high-level language environment and upon the definitions and relationships, the framework programmatically and dynamically generates appropriate statements associated with the database system environment that accomplish the request. For example, the framework may issue statements to define the structure of a database, access information from the database, and/or manipulate information within the database.