可扩展的电子表格查询外数据源方法

电子表格是一种分析工具,具有友好的用户界面,提供了简单计算模型。但与RDBMS相比,电子表格没有一个共享机制,而导致多个电子表格需要产生多个副本。此外,电子表格也不能提供可扩展的计算。为了解决共享性和可扩展性问题,提出把Excel计算自动地转换为SQL。可以从一个系统中输入数据,在系统中用类似的Excel公式定义计算,然后把它作为一个SQL视图转换和存储起来,然后通过系统执行Excel计算。实验显示,方法是可行和有效的。

Extendable method for querying quter data resources in spreadsheets

Spreadsheets are analysis tools with a friendly user interface,provides a simple computational model.However,as opposed to RDBMS,spreadsheets do not provide shareability of models and lead to proliferation of multiple copies of the same spreadsheet.Furthermore,spreadsheets do not offer scalable computation.To solve the two problems,this paper proposes to automatically translate Excel computation into SQL.Users can import the data from RDBMS,define computation using familiar Excel formulas and then translate and store it as a SQL view.The Excel computation is then performed by the relational system.The experiments show that the method is feasible and effective.