Return of the Table Michael Vitrano and Jared Pochtar 4115 Final Project Professor Stephen Edwards Problem Area Working with relaEonal databases can be di cult using tradiEonal SQL queries which makes querying certain subsets of data di cult AddiEonally learning certain staEsEcs about a dataset can be impossible to do solely in SQL The tradiEonal way of compuEng these staEsEcs is to issue queries to the database parse the informaEon through a database driver and use a second language to compute staEsEcs RT s SoluEon RelaEonal tables and records become rst class language objects Driver for interfacing with database is built in to the language Filter Join and Map operaEons allow the programmer to easily create any composite dataset from the original database or lter to any subset of the original database ReporEng generated datasets in a neat and organized fashion is easy CommiSng data to the database is also easy Translator Design RT code is translated into Java source code and automaEcally compiled to class les rtc sh and rt sh are scripts that manage compiling and running RT programs respecEvely rtc the RT translator is wriVen in OCaml and is responsible for Scanning Parsing SemanEc Analysis and Code GeneraEon Generated Java source is linked against RTLib which provides the framework for all table related features DemonstraEon Problem Business has informaEon regarding customer purchases in their database and want to know who are their best customers Also want to know which store locaEon and item sold are the most popular Steps Join customer item store and purchase data Calculate each customer s total amount purchased favorite store amount spent at that store favorite item and the amount spent on that item Sort customers based on total amount purchased Display results and commit to database Lessons Learned Quit talking about the project and just start wriEng code Work with people who you trust to do work on Eme and correctly Divide the project into separate units and assign each to a team member make sure everyone knows how the parts interface SVN is a necessity but can cause headaches if you re lazy about using it Advice to Future Groups Start early this can not be stressed enough This is an iteraEve process and must be done steps at a Eme It is impossible to do all at once Pick an end point to your project and sEck to it Test cases are important for two reasons they both make sure you re doing it right and keep you focused on what the language is trying to do Choose a problem area that interests you
View Full Document
Unlocking...