Method and system for rapid memory-resident processing of transactional data

A system for storing and executing at least one stored procedure on a data object in a database management system comprising:

• a) means for defining at least one object-oriented optimized data structure as a persistent class of an object oriented programming language in said database management system;
• b) means for mapping relational data into said at least one object-oriented optimized data structure;
• c) means for storing said relational data as said data object which is an instance of said persistent class;
• d) means for storing said data object in a physical memory;
• e) means for generating an object identifier unique to said data object;
• f) means for storing said object identifier in an SQL table;
• g) means for defining said at least one stored procedure as a method of a COM object stored in a COM object container;
• h) means for calling said at least one stored procedure through an SQL query provided by an application program;
• i) means for providing said at least one stored procedure with at least one of a plurality of input parameters;
• j) means for executing said database management system in an address space;
• k) means for dynamically linking said at least one stored procedure to an address space in which said database management system is executing;
• l) means for providing a copy of said data object in said address space;
• and
• m) means for executing said at least one stored procedure upon said data object.

A system for storing and executing at least one stored procedure on a data object in a database management system comprising:

• a) a database for storing amounts of relational data;
• b) a first interface for defining at least one object-oriented optimized data structure as a persistent class of an object oriented programming language for said relational data;
• c) a second interface for mapping said relational data into said at least one object-oriented optimized data structure;
• d) a third interface for defining said at least one stored procedure as a method of a COM object;
• e) a COM library for storing said at least one stored procedure;
• f) an application program from which a user interface calls said at least one stored procedure through an SQL query from said COM library;
• and
• g) a main memory for storing said relational data as said data object which is an instance of said persistent class and for executing said at least one stored procedure on said data object.

A method for storing and executing at least one stored procedure on a data object in an R/3 system comprising the steps of:

• a) defining at least one object-oriented optimized data structure as a persistent class of an object oriented programming language in said R/3 system;
• b) mapping transactional data from said R/3 system into said at least one object-oriented optimized data structure;
• c) storing said transactional data from said R/3 system as said data object which is an instance of said persistent class;
• d) storing said data object in a physical memory;
• e) generating an object identifier unique to said data object;
• f) storing said object identifier in an SQL table;
• g) defining said at least one stored procedure as a method of a COM object stored in a COM object container;
• h) calling said at least one stored procedure through an SQL query provided by a user interface to the R/3 system;
• i) providing said at least one stored procedure with a plurality of input parameters;
• j) executing said database management system in an address space;
• k) dynamically linking said at least one stored procedure to an address space in which a database management system module of said R/3 system is executing;
• l) providing a copy of said data object in said address space;
• and
• m) executing said at least one stored procedure upon said data object.

A computer-readable medium having stored thereupon a plurality of instructions, said plurality of instructions includes instructions which, when executed by a processor, cause the processor to perform the steps of:

• a) defining at least one object-oriented optimized data structure as a persistent class of an object oriented programming language in said database management system;
• b) mapping relational data into said at least one object-oriented optimized data structure;
• c) storing said relational data as said data object which is an instance of said persistent class;
• d) storing said data object in a physical memory;
• e) generating an object identifier unique to said data object;
• f) storing said object identifier in an SQL table;
• g) defining at least one stored procedure as a method of a COM object stored in a COM object container;
• h) calling said at least one stored procedure through an SQL query provided by an application program;
• i) providing said at least one stored procedure with a plurality of input parameters;
• j) executing said database management system in an address space;
• k) dynamically linking said at least one stored procedure to an address space in which said database management system is executing;
• l) providing a copy of said data object in said address space;
• and
• m) executing said at least one stored procedure upon said data object.