Query By Excel
Query By Excel
复制标题
Excel查询
DOI：
--
复制
发表时间：
2005
期刊：
影响因子：
--
通讯作者：
Allison Waingold
中科院分区：
文献类型：
--
作者：
Andrew Witkowski;Srikanth Bellamkonda;Tolga Bozkaya;Aman Naimat;Lei Sheng;Sankar Subramanian;Allison Waingold
电子表格和MS Excel是建立的分析工具。它们提供了有吸引力的用户界面，提供了易于使用的计算模型，并为何种分析提供了实质性的交互性。但是，与RDBM相比，电子表格没有提供中央存储库，因此它们不提供excel内置模型的共同性，并导致同一电子表格的多个副本的扩散。此外，电子表格不提供可扩展的计算，例如，它们缺乏并行化。为了解决共享性和可伸缩性问题，我们建议将Excel计算自动转化为SQL。分析师可以从关系系统导入数据，使用熟悉的Excel公式对其定义计算，然后将其转换和存储为对导入数据的关系SQL视图。然后由关系系统执行Excel计算。要编辑模型，分析师可以将模型重新带回Excel，将其修改为Excel，然后将其作为SQL视图存储回。我们将此系统称为Excel，QBX的查询。
Spreadsheets, and MS Excel in particular, are established analysis tools. They offer an attractive user interface, provide an easy to use computational model, and offer substantial interactivity for what-if analysis. However, as opposed to RDBMS, spreadsheets do not provide a central repository hence they do not provide shareability of models built in Excel and lead to proliferation of multiple copies of the same spreadsheet. Furthermore, spreadsheets do not offer scalable computation, for example, they lack parallelization. To address the shareability, and scalability problems, we propose to automatically translate Excel computation into SQL. An analyst can import the data from a relational system, define computation over it using familiar Excel formulas and then translate and store it as a relational SQL view over the imported data. The Excel computation is then performed by the relational system. To edit the model, the analyst can bring the model back to Excel, modify it in Excel and store it back as an SQL View. We refer to this system as Query by Excel, QBX in short.