A Deep Embedding of Queries into Ruby

Torsten Grust, Manuel Mayr
2012 2012 IEEE 28th International Conference on Data Engineering  
We demonstrate SWITCH, a deep embedding of relational queries into RUBY and RUBY on RAILS. With SWITCH, there is no syntactic or stylistic difference between RUBY programs that operate over in-memory array objects or databaseresident tables, even if these programs rely on array order or nesting. SWITCH's built-in compiler and SQL code generator guarantee to emit few queries, addressing long-standing performance problems that trace back to RAILS' ACTIVE-RECORD database binding. "Looks likes
more » ... but performs like handcrafted SQL," is the ideal that drives the research and development effort behind SWITCH. Orders id user¯id item¯total · · · Line¯Items id price quantity order¯id · · · Fig. 1 . Tables holding Spree application data (excerpt). The id columns serve as primary keys, order¯id references Orders.
doi:10.1109/icde.2012.121 dblp:conf/icde/GrustM12 fatcat:fta3xc6s7ffyhfcxo2sclownge