Querying for model-driven spreadsheetsd
暂无分享,去创建一个
Querying for Model-Driven Spreadsheets Spreadsheets are used for a diverse number of objectives, that range from simple applications to complete information systems. In all of these cases, they are frequently used as data repositories that can grow tremendously in size, and as the amount of the data grows, the frustration and challenge to withdraw information out of them also grows. This Thesis project focuses on the problem of spreadsheet querying. Specifically, the objective is to meticulously and carefully study competing query languages, and proposing our very own expressive and composable query language to be used in spreadsheets, where intuitive queries can be defined. This approach builds on a model-driven spreadsheet development environment, and queries are expressed referencing ClassSheet model entities instead of the actual data. Furthermore, this language shall be integrated into the MDSheet framework, taking into account evolution mechanisms, auto-generation of models for query results, and shall rely on Google’s QUERY function for spreadsheets.
[1] G. Lawrence Sanders,et al. Denormalization strategies for data retrieval from data warehouses , 2006, Decis. Support Syst..