RWTH Aachen University
The following paper presents results of combining two intensively developed technologies used to build database applications - SQL's (Structured Query Language's) recursive queries and object-relational mapping. Recursive queries are efficient tools for querying graph and hierarchical structures. They are very useful in solving problems such as searching for connections between two cities or calculating bill-of-material. Object-relational mapping allows for separation of business logic from database layer and more efficient implementation of computer software. However, modern mapping systems still lack support for many advanced SQL techniques.