Filters








33,456 Hits in 7.6 sec

From spreadsheets to relational databases and back

Jácome Cunha, João Saraiva, Joost Visser
2008 Proceedings of the 2009 ACM SIGPLAN workshop on Partial evaluation and program manipulation - PEPM '09  
This paper presents techniques and tools to transform spreadsheets into relational databases and back.  ...  We use well-known relational database techniques to optimize and query the data.  ...  We have shown how the resulting system can be employed to convert spreadsheets to relational databases and back.  ... 
doi:10.1145/1480945.1480972 dblp:conf/pepm/CunhaSV09 fatcat:3n3oj65bdbbs5cxiin7rrcjpxm

DataSpread

Mangesh Bendre, Bofan Sun, Ding Zhang, Xinyan Zhou, Kevin Chen-Chuan Chang, Aditya Parameswaran
2015 Proceedings of the VLDB Endowment  
relational databases, such as scalability and the ability to use arbitrary SQL to import, filter, or join external or internal tables and have the results appear in the spreadsheet.  ...  DATA-SPREAD continues to offer a Microsoft Excel-based spreadsheet front-end, while in parallel managing all the data in a back-end database, specifically, Postgres.  ...  data from the relational database. 3 ) demonstrating that DATA-SPREAD keeps data in the front-end and back-end in-sync during modifications at either end.  ... 
doi:10.14778/2824032.2824121 fatcat:lnw3gssfjffb7akd2wq3wfe3oi

DataSpread: Unifying Databases and Spreadsheets

Mangesh Bendre, Bofan Sun, Ding Zhang, Xinyan Zhou, Kevin ChenChuan Chang, Aditya Parameswaran
2015 Proceedings of the VLDB Endowment  
It continues to offer a Microsoft Excel-based spreadsheet front-end, while in parallel managing all the data in a back-end database, specifically, PostgreSQL.  ...  databases, such as scalability and the ability to use arbitrary SQL to import, filter, or join external or internal tables and have the results appear in the spreadsheet.  ...  from the relational database. c) demonstrating that DATASPREAD keeps data in the front-end and back-end in-sync during modifications at either end.  ... 
pmid:26900487 pmcid:PMC4756475 fatcat:5tj3sniozvdjbbsondxlzjps2q

A spreadsheet-based user interface for managing plural relationships in structured data

Eirik Bakke, David Karger, Rob Miller
2011 Proceedings of the 2011 annual conference on Human factors in computing systems - CHI '11  
In this paper, we propose to reduce the cost-usability gap between spreadsheets and tailor-made relational database applications by extending the spreadsheet paradigm to let the user establish relationships  ...  A key feature of relational database applications is managing plural relationships-one-to-many and many-to-manybetween entities.  ...  ACKNOWLEDGEMENTS We thank Paul Grogan and Phumpong Watanaprakornkul for their help designing and implementing the original Related Worksheets prototype.  ... 
doi:10.1145/1978942.1979313 dblp:conf/chi/BakkeKM11 fatcat:7npv5ddmn5azrlbxu6no2vjxtm

Artificial Intelligence Research: The Utility and Design of a Relational Database System (RDBS)

Thomas J. Dilling
2020 Advances in Radiation Oncology  
This article describes relational database systems and how they differ from spreadsheets. At their core, spreadsheets are only capable of describing one-to-one (1:1) relationships.  ...  Consequently, spreadsheets are very inefficient relative to relational database systems, which gracefully manage such data.  ...  In fact, many researchers erroneously describe spreadsheets as databases. This article will demonstrate both what a relational database system is and how it is superior to a spreadsheet.  ... 
doi:10.1016/j.adro.2020.06.027 pmid:33305089 pmcid:PMC7718502 fatcat:emqxt22vsbeepis7fwhmxzmpnq

Spreadsheet driven web applications

Edward Benson, Amy X. Zhang, David R. Karger
2014 Proceedings of the 27th annual ACM symposium on User interface software and technology - UIST '14  
We draw conclusions from their experience and discuss future extensions to this programming model.  ...  We present a system for creating basic web applications using such spreadsheets in place of a server and using HTML to describe the client UI.  ...  System-level design is also required to coordinate front-end and back-end systems, along with a data storage system such as a database.  ... 
doi:10.1145/2642918.2647387 dblp:conf/uist/BensonZK14 fatcat:zhk5cims3bf7blbahkyh4yls44

Qtier-Rapor: Managing Spreadsheet Systems & Improving Corporate Performance, Compliance and Governance

Keith Bishop
2008 arXiv   pre-print
The growth and deployment of such integrated spreadsheet SYSTEMS raises the scale of issues to a whole new level.  ...  The correct management of spreadsheet systems is necessary to ensure that the business achieves its goals of improved performance and good corporate governance, within the constraints of legislative compliance  ...  The process can itself write system data and status data back to the database for use by other processes.  ... 
arXiv:0803.0011v1 fatcat:d26vgu4rovbpnd43wuxm2j2uwy

The exception that improves the rule

Juliana Freire, Boris Glavic, Oliver Kennedy, Heiko Mueller
2016 Proceedings of the Workshop on Human-In-the-Loop Data Analytics - HILDA '16  
The database community has developed numerous tools and techniques for data curation and exploration, from declarative languages, to specialized techniques for data repair, and more.  ...  In this work, we explore the integration of spreadsheets, notebooks, and relational databases.  ...  Acknowledgements: This work was supported in part by gifts from Oracle and NSF Grant CNS-1229185.  ... 
doi:10.1145/2939502.2939509 dblp:conf/sigmod/FreireGKM16 fatcat:5mswgtdje5cytbi55m7pg3my5y

The Exception that Improves the Rule [article]

Juliana Freire, Boris Glavic, Oliver Kennedy, Heiko Mueller
2016 arXiv   pre-print
The database community has developed numerous tools and techniques for data curation and exploration, from declarative languages, to specialized techniques for data repair, and more.  ...  In this work, we explore the integration of spreadsheets, notebooks, and relational databases.  ...  Acknowledgements: This work was supported in part by gifts from Oracle and NSF Grant CNS-1229185.  ... 
arXiv:1606.00046v1 fatcat:otgdnc4pmzb4nkkqv4clbehlle

Cell Stores [article]

Ghislain Fourny
2014 arXiv   pre-print
Cell stores provide a relational-like, tabular level of abstraction to business users while leveraging recent database technologies, such as key-value stores and document stores.  ...  Cell stores were abstracted from, and are compatible with the XBRL standard for importing and exporting data.  ...  We received a lot of very useful advice from Charles Hoffman.  ... 
arXiv:1410.0600v2 fatcat:mi3rwwvbhbfffn3fa4r5qa33ru

Model-based programming environments for spreadsheets

Jácome Cunha, Jorge Mendes, João Saraiva, Joost Visser
2014 Science of Computer Programming  
We devised a method for extraction of a relational model from a spreadsheet and the subsequent embedding of the model back into the spreadsheet to create a model-based spreadsheet programming environment  ...  We present preliminary experimental results from applying our approach to a sample of spreadsheets from the EUSES Spreadsheet Corpus.  ...  Acknowledgment The authors would like to thank Martin Erwig and his team for providing us the code from the UCheck project.  ... 
doi:10.1016/j.scico.2014.02.002 fatcat:wbjfnnvqbva4hjn4kjtz273xjy

Model-Based Programming Environments for Spreadsheets [chapter]

Jácome Cunha, João Saraiva, Joost Visser
2012 Lecture Notes in Computer Science  
We devised a method for extraction of a relational model from a spreadsheet and the subsequent embedding of the model back into the spreadsheet to create a model-based spreadsheet programming environment  ...  We present preliminary experimental results from applying our approach to a sample of spreadsheets from the EUSES Spreadsheet Corpus.  ...  Acknowledgment The authors would like to thank Martin Erwig and his team for providing us the code from the UCheck project.  ... 
doi:10.1007/978-3-642-33182-4_10 fatcat:ovljo72bmjecnmc7eczvkkxdve

A Spreadsheet Algebra for a Direct Data Manipulation Query Interface

Bin Liu, H. V. Jagadish
2009 Proceedings / International Conference on Data Engineering  
A spreadsheet-like "direct manipulation" interface is more intuitive for many non-technical database users compared to traditional alternatives, such as visual query builders.  ...  We built a prototype implementation of the spreadsheet algebra and show, through user studies with non-technical subjects, that the resultant query interface is easier to use than a standard commercial  ...  However, spreadsheets are not designed for querying databases (although it is possible to use them to load data from a database).  ... 
doi:10.1109/icde.2009.34 dblp:conf/icde/LiuJ09 fatcat:sxrncqcsuvg4xlxutlngikhtf4

SpreadDB: Spreadsheet-Based User Interface for Querying and Updating Data of External Databases

2018 International Journal of Advanced Trends in Computer Science and Engineering  
SpreadDB enables users to design spreadsheet templates used to perform data query and data update.  ...  We also present security measures of SpreadDB that prevent unauthorized persons from accessing and modifying database data.  ...  Therefore, Excel spreadsheet can be always up to date with the current data from the back end database.  ... 
doi:10.30534/ijatcse/2018/01722018 fatcat:pex3djzdlvd3dl33hm3nyumvoi

The EnzymeTracker: an open-source laboratory information management system for sample tracking

Thomas Triplet, Gregory Butler
2012 BMC Bioinformatics  
However, this approach poses a number of problems, ranging from sharing issues to inefficient datamining. Standard spreadsheets are also error-prone, as data do not undergo any validation process.  ...  The EnzymeTracker features online spreadsheets and tools for monitoring numerous experiments conducted by several collaborators to identify and characterize samples.  ...  A number of flags to fine tune SQL queries are available for advanced users.  ... 
doi:10.1186/1471-2105-13-15 pmid:22280360 pmcid:PMC3353834 fatcat:xyyept2yqjaafi434m7kzlutfa
« Previous Showing results 1 — 15 out of 33,456 results