English (United Kingdom)

https://curated-unify.zendy.io/wp-json/zendy-region/v1/featured_content/oa?rat=en

https://curated-unify.zendy.io/wp-json/zendy-region/v1/highlighted_journal/

Global: Zendy Plus annual

Presents the access of premium content as premium feature

Premium Content

Presents the keyphrase highlighting as premium feature

Keyphrase Highlighting

Presents the summarisation as premium feature

Summarisation

Insights

Presents the pdf analysis as premium feature

PDF Analysis

Presents the zaia usage as premium feature

ZAIA

Global: Zendy Plus monthly

Global: Zendy Tools annual

Global: Zendy Tools monthly

Global: Zendy Free Plan

Spreadsheet software is the tool of choice for interactive ad-hoc datamanagement, with adoption by billions of users. However, spreadsheets are notscalable, unlike database systems. On the other hand, database systems, whilehighly scalable, do not support interactivity as a first-class primitive. Weare developing DataSpread, to holistically integrate spreadsheets as afront-end interface with databases as a back-end datastore, providingscalability to spreadsheets, and interactivity to databases, an integration weterm presentational data management (PDM). In this paper, we make a first steptowards this vision: developing a storage engine for PDM, studying how toflexibly represent spreadsheet data within a database and how to support andmaintain access by position. We first conduct an extensive survey ofspreadsheet use to motivate our functional requirements for a storage enginefor PDM. We develop a natural set of mechanisms for flexibly representingspreadsheet data and demonstrate that identifying the optimal representation isNP-Hard; however, we develop an efficient approach to identify the optimalrepresentation from an important and intuitive subclass of representations. Weextend our mechanisms with positional access mechanisms that don't suffer fromcascading update issues, leading to constant time access and modificationperformance. We evaluate these representations on a workload of typicalspreadsheets and spreadsheet operations, providing up to 20% reduction instorage, and up to 50% reduction in formula evaluation time.

Towards a Holistic Integration of Spreadsheets with Databases: A Scalable Storage Engine for Presentational Data Management