The claimed subject matter provides systems and methods that effectuates and facilitates the generation of bidirectional views. The disclosed system can include components that transform queries and mappings into an internal representation that can be compiled into a bidirectional view. The bidirectional view can thereafter be employed to actuate query and update processing in a relational database management system.