Users can create computational models in a spreadsheet application and
automatically apply the model to data stored in a relational database. By
importing a sample of the data from a database table into the spreadsheet
application, users can build spreadsheet models that perform analysis and
computations on the sample data. Once the model is complete, the
spreadsheet model is translated into an SQL format model understood by
the database. The SQL model can operate on the entire data set in the
database, rather than just the sample data used to construct the model.
The SQL model and its associated data are stored in the database, and the
model can be executed on a different sets of data. A web browser based
front-end allows model users to access the SQL model via a web browser,
eliminating the need for model users to have a spreadsheet application.