Abstract: Enterprise systems, methods and computer program products are disclosed for providing value-based positioning for outer join database queries in an enterprise resource planning system operating on a specially programmed computer server. The computer implemented method comprises; receiving a query at a server and processing the query for inner join and then evaluating a returned value for Order by direction and whether the current row returns NULL. Depending on forward paging and reverse paging for outer join, the process involves changing an inequality operator depending on the evaluated Order by direction and whether the current row is NULL. The process for inner join and outer join queries is implemented on an application object server including a kernel instance, a query framework and query generation model and a data access layer engine to a database of the enterprise resource planning system.

Abstract: Enterprise systems, methods and computer program products are disclosed for providing value-based positioning for outer join database queries in an enterprise resource planning system operating on a specially programmed computer server. The computer implemented method comprises; receiving a query at a server and processing the query for inner join and then evaluating a returned value for Order by direction and whether the current row returns NULL. Depending on forward paging and reverse paging for outer join, the process involves changing an inequality operator depending on the evaluated Order by direction and whether the current row is NULL. The process for inner join and outer join queries is implemented on an application object server including a kernel instance, a query framework and query generation model and a data access layer engine to a database of the enterprise resource planning system.

Abstract: Enterprise systems, methods and computer program products are disclosed for providing bulk create (insert), update and delete operations for table inheritance in an enterprise resource system using an object-oriented language supporting polymorphism. The computer implemented method comprises receiving a request for one of a create, update and delete operation with respect to data of first and second tables of an inheritance table hierarchy; creating a temporary table comprising a surrogate key and a record identifier; establishing a filter condition with fields from different tables in table inheritance; and one of creating, updating and deleting data from the different tables in table inheritance according to the filter condition. The process is implemented on an application object server including a compiler for the object-oriented language, a kernel instance and a data access layer.