Encontrados 58 documentos, a visualizar página 1 de 6
Model inference for spreadsheets
Mendes, Jorge; Erwig, Martin; Cunha, Jácome Miguel Costa; Saraiva, João AlexandreMany errors in spreadsheet formulas can be avoided if spreadsheets are built automati- cally from higher-level models that can encode and enforce consistency constraints in the generated spreadsheets. Employing this strategy for legacy spreadsheets is dificult, because the model has to be reverse engineered from an existing spreadsheet and existing data must be transferred into the new model-generated spreadshe...
Spreadsheet engineering
Cunha, Jácome Miguel Costa; Fernandes, João Paulo Soares; Mendes, Jorge; Saraiva, João AlexandreThese tutorial notes present a methodology for spreadsheet engineering. First, we present data mining and database techniques to reason about spreadsheet data. These techniques are used to compute relationships between spreadsheet elements (cells/columns/rows). These relations are then used to infer a model defining the business logic of the spreadsheet. Such a model of a spreadsheet data is a visual domain spe...
Embedding, evolution, and validation of model-driven spreadsheets
Cunha, Jácome Miguel Costa; Fernandes, João Paulo; Mendes, Jorge; Saraiva, João AlexandreThis paper proposes and validates a model-driven software engineering technique for spreadsheets. The technique that we envision builds on the embedding of spreadsheet models under a widely used spreadsheet system. This means that we enable the creation and evolution of spreadsheet models under a spreadsheet system. More precisely, we embed ClassSheets, a visual language with a syntax similar to the one offered...
Defining energy consumption plans for data querying processes
Gonçalves, R.; Saraiva, João Alexandre; Belo, O.During the last few years, we have been witnessing a significant increase in research about the development and production of hardware and software components with low levels of energy consumption. Today, energy consumption is one of the most critical issues in the area of information technologies and communication. One of the fractions in which this concern is most evident is in the management of database syst...
Towards the design and implementation of aspect-oriented programming for spread...
Maia, Pedro; Mendes, Jorge; Cunha, Jácome Miguel Costa; Rebêlo, Henrique; Saraiva, João AlexandreA spreadsheet usually starts as a simple and singleuser software artifact, but, as frequent as in other software systems, quickly evolves into a complex system developed by many actors. Often, different users work on different aspects of the same spreadsheet: while a secretary may be only involved in adding plain data to the spreadsheet, an accountant may define new business rules, while an engineer may need to ...
Design and implementation of queries for model-driven spreadsheets
Cunha, Jácome Miguel Costa; Fernandes, João Paulo; Mendes, Jorge; Pereira, Rui; Saraiva, João AlexandreThis paper presents a domain-specific querying language for model-driven spreadsheets. We briefly show the design of the language and present in detail its implementation, from the denormalization of data and translation of our user-friendly query language to a more efficient query, to the execution of the query using Google. To validate our work, we executed an empirical study, comparing QuerySheet with an alt...
BiYacc: Roll your parser and reflective printer into one
Zhu, Zirun; Ko, Hsiang-Shang; Martins, Pedro Miguel Ribeiro; Saraiva, João Alexandre; Hu, ZhenjiangLanguage designers usually need to implement parsers and printers. Despite being two related programs, in practice they are designed and implemented separately. This approach has an obvious disadvantage: as a language evolves, both its parser and printer need to be separately revised and kept synchronised. Such tasks are routine but complicated and error-prone. To facilitate these tasks, we propose a language c...
Categorização do consumo de energia em sistemas de povoamento de Data Warehouses
Guimarães, Miguel; Saraiva, João Alexandre; Belo, O.Os recursos computacionais exigidos durante o processamento de grandes volumes de dados durante um processo de povoamento de um data warehouse faz com que a necessidade da procura de novas implementações tenha também em atenção a eficiência energética dos diversos componentes processuais que integram um qualquer sistema de povoamento. A lacuna de técnicas ou metodologias para categorizar e avaliar o consumo de ...
Refactoring meets model-driven spreadsheet evolution
Cunha, Jácome Miguel Costa; Fernandes, João Paulo; Martins, Pedro; Pereira, Rui; Saraiva, João AlexandreSoftware refactoring is a well-known technique that provides transformations on software artifacts with the aim of improving their overall quality. In this paper we present a set of refactorings for ClassSheets, a modeling language that allows to specify the business logic of a spreadsheet in an object-oriented fashion. The set of refactorings that we propose allows us to improve the quality of these spreadshee...
Smelling faults in spreadsheets
Abreu, Rui; Cunha, Jácome Miguel Costa; Fernandes, João Paulo Sousa Ferreira; Martins, Pedro Miguel Ribeiro; Perez, Alexandre; Saraiva, João AlexandreDespite being staggeringly error prone, spreadsheets are a highly flexible programming environment that is widely used in industry. In fact, spreadsheets are widely adopted for decision making, and decisions taken upon wrong (spreadsheet-based) assumptions may have serious economical impacts on businesses, among other consequences. This paper proposes a technique to automatically pinpoint potential faults in sp...