Spreadsheet to SQL translation

Details Spreadsheet to SQL translation Spreadsheet to SQL translation

2007-11-20

2007-11-20

Hwang, Joon Hwan (Department: 2166)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

10893547

ABSTRACT:
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.

REFERENCES:
patent: 6385604 (2002-05-01), Bakalash et al.
patent: 6631497 (2003-10-01), Jamshidi et al.
patent: 2005/0187952 (2005-08-01), Werner
Witkowski et al. (“Spreadsheets in RDBMS for Olap”, ACM, Jun. 2003, pp. 52-63).
Oracle User's Guide, Release 6.3, Oct. 1999, Part No. A73223—01, Oracle Express Spreadsheet Add-In (42 pgs).
Hyperion Solutions Corporation, “Hyperion Analyzer Release 6.5, Managing OLAP and Relational Data with SQL Queries” (2003) (33 pgs).
SAP, “SAP and Microsoft announce their first joint product. Microsoft and SAP: Revolutionizing How Information Workers Access Enterprise Business Applications” http://www.sap.com/solutions/mendocino/index.epx, printed Jul. 19, 2005 (2 pgs).
Microsoft Office, “Mendocino Version 1.0 (features, functionality and timing of the release can change without notice) Improve the efficiency of your organization's decision making process, utilize and interact with SAP data, seamlessly participate in best-practice mySAP ERP processes—all from a familiar Microsoft Office Professional 2003 user Interface” (2 pgs).
“Providing Microsoft-SAP Technical Guidance”, http://www.microsoft-sap.com/technology/aspx, printed Jul. 19, 2005 (1 pg).
“Introducing the Microsoft Office Information Bridge Framework”, http://msdn.microsoft.com/office/understanding/ibframework/gettingstarted/default.aspx?p. . . , printed Jul. 19, 2005 (10 pgs).
“SAPGenie.com -> Interfaces -> Interfaces -> The Mendocino Project”, http://www.sapgenie.com/interfaces/mendocino.htm, printed Jul. 19, 2005 (2 pgs).
Witkowski, Andrew et al.; “Business Modeling Using SQL Spreadsheets”; 2003,Proceedings of the 29th VLDB Conference, pp. 1-4.

Affiliated with

Also associated with

Rating

Spreadsheet to SQL translation does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Spreadsheet to SQL translation, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Spreadsheet to SQL translation will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3877544