• DocumentCode
    1788269
  • Title

    Embedding model-driven spreadsheet queries in spreadsheet systems

  • Author

    Cunha, Jacome ; Fernandes, Joao Paulo ; Mendes, J. ; Pereira, Rui ; Saraiva, Juliana

  • Author_Institution
    HASLab/INESC TEC, Univ. do Minho, Braga, Portugal
  • fYear
    2014
  • fDate
    July 28 2014-Aug. 1 2014
  • Firstpage
    151
  • Lastpage
    154
  • Abstract
    Spreadsheets are widely used not only to define mathematical expressions, but also to store large and complex data. To query such data is usually a difficult task to perform, usually for end user. In this work we embed the textual query language in the model-driven spreadsheet environment as a spreadsheet itself. The result is an expressive and powerful query environment that has knowledge of the business logic defined by the spreadsheet data (the spreadsheet model) to guide end users constructing correct queries.
  • Keywords
    query languages; query processing; spreadsheet programs; business logic; complex data storage; data query; model-driven spreadsheet queries; spreadsheet data; spreadsheet systems; textual query language; Computational modeling; Data models; Database languages; Databases; Object oriented modeling; Synchronization; Visualization;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Visual Languages and Human-Centric Computing (VL/HCC), 2014 IEEE Symposium on
  • Conference_Location
    Melbourne, VIC
  • Type

    conf

  • DOI
    10.1109/VLHCC.2014.6883039
  • Filename
    6883039