End-user specified insertion of elements into a database cache is disclosed.
The systems and methods of the invention define an efficient mechanism allowing
a user with knowledge of anticipated behavior of a database application program
to specify cell data that is cached before it is required by the application program.
The system determines an appropriate set of cell data to be cached that meets the
end-users specification and that can be obtained with a minimum of round-trips
to a database server. In a multidimensional database, the system determines a maximum
depth level for each user specified dimension member set. A target set of dimension
members is formed comprising the set of members at the maximum level that have
a common ancestor member. The cell data representing the cross product of the target
sets is then obtained and cached.
