首页> 外文期刊>Knowledge and Data Engineering, IEEE Transactions on >Translating Relational Queries into Spreadsheets
【24h】

Translating Relational Queries into Spreadsheets

机译:将关系查询转换为电子表格

获取原文
获取原文并翻译 | 示例

摘要

Spreadsheets are among the most commonly used applications for data management and analysis. They combine data processing with very diverse supplementary features: statistics, visualization, reporting, linear programming solvers, Web queries periodically downloading data from external sources, etc. However, the spreadsheet paradigm of computation still lacks sufficient analysis. In this article, we demonstrate that a spreadsheet can implement all data transformations definable in SQL, merely by utilizing spreadsheet formulas. We provide a query compiler, which translates any given SQL query into a worksheet of the same semantics, including values. Thereby, database operations become available to the users who do not want to migrate to a database. They can define their queries using a high-level language and then get their execution plans in a plain vanilla spreadsheet. The functions available in spreadsheets impose limitations on the algorithms one can implement. In this paper, we offer sorting spreadsheet, using a non-constant number of rows, and, surprisingly, Depth-First-Search and Breadth-First-Search on graphs.
机译:电子表格是最常用的数据管理和分析应用程序之一。它们将数据处理与非常多样化的补充功能相结合:统计,可视化,报告,线性编程求解器,Web查询定期从外部源下载数据等。但是,电子表格的计算范式仍然缺乏足够的分析。在本文中,我们演示了电子表格仅通过利用电子表格公式即可实现SQL中定义的所有数据转换。我们提供了一个查询编译器,该编译器将任何给定的SQL查询转换为具有相同语义(包括值)的工作表。从而,数据库操作对不想迁移到数据库的用户可用。他们可以使用高级语言定义查询,然后在普通的电子表格中获取执行计划。电子表格中可用的功能限制了人们可以实现的算法。在本文中,我们提供了使用非恒定行数进行排序的电子表格,并且令人惊讶的是,图上的深度优先搜索和广度优先搜索。

著录项

相似文献

  • 外文文献
  • 中文文献
  • 专利
获取原文

客服邮箱:kefu@zhangqiaokeyan.com

京公网安备:11010802029741号 ICP备案号:京ICP备15016152号-6 六维联合信息科技 (北京) 有限公司©版权所有
  • 客服微信

  • 服务号