Cunha, Jácome, João Paulo Fernandes, Jorge Mendes, and João Saraiva. "
MDSheet: A Framework for Model-driven Spreadsheet Engineering."
Proceedings of the 34rd International Conference on Software Engineering. ICSE'12. ACM, 2012. 1395-1398.
Abstractn this paper, we present MDSHEET, a framework for the embedding, evolution and inference of spreadsheet models. This framework offers a model-driven software development mechanism for spreadsheet users.
Cunha, Jácome, João Saraiva, and Joost Visser. "
Model-Based Programming Environments for Spreadsheets."
Programming Languages. Eds. Francisco de Carvalho Junior, and Luis Barbosa. Vol. 7554. Lecture Notes in Computer Science, 7554. Springer Berlin / Heidelberg, 2012. 117-133.
AbstractAlthough spreadsheets can be seen as a flexible programming environment, they lack some of the concepts of regular programming languages, such as structured data types. This can lead the user to edit the spreadsheet in a wrong way and perhaps cause corrupt or redundant data. 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. The extraction algorithm is specific for spreadsheets since it considers particularities such as layout and column arrangement. The extracted model is used to generate formulas and visual elements that are then embedded in the spreadsheet helping the user to edit data in a correct way. We present preliminary experimental results from applying our approach to a sample of spreadsheets from the EUSES Spreadsheet Corpus.
Cunha, Jácome Model-based Spreadsheet Engineering: Using Relational Models to Improve Spreadsheets. Eds. Shahanaz Soogah. LAP LAMBERT Academic Publishing, 2012.
AbstractSpreadsheets can be viewed as programming languages for non-professional programmers. These so-called ``end-user'' programmers vastly outnumber professional programmers creating millions of new spreadsheets every year. As a programming language, spreadsheets lack support for abstraction, testing, encapsulation, or structured programming. As a result, and as numerous studies have shown, the high rate of production is accompanied by an alarming high rate of errors. Some studies report that up to 90% of real-world spreadsheets contain errors. After their initial creation, many spreadsheets turn out to be used for storing and processing increasing amounts of data and supporting increasing numbers of users over long periods of time, making them complicated systems. An emerging solution to handle the complex and evolving software systems is Model-driven Engineering (MDE). To consider models as first class entities and any software artifact as a model or a model element is one of the basic principles of MDE. We adopted some techniques from MDE to solve spreadsheet problems. Most spreadsheets (if not all) lack a proper specification or a model. Using reverse engineering techniques we are able to derive various models from legacy spreadsheets. We use functional dependencies (a formalism that allow us to define how some column values depend on other column values) as building blocks for these models. Models can be used for several spreadsheet improvements, namely refactoring, safe evolution, migration or even generation of edit assistance. The techniques presented in this work are available under the framework HAEXCEL that we developed. It is composed of online and batch tools, reusable HASKELL libraries and OpenOffice.org extensions. A study with several end-users was organized to survey the impact of the techniques we designed. The results of this study indicate that the models can bring great benefits to spreadsheet engineering helping users to commit fewer errors and to work faster.
Monteiro, Rui, João Araújo, Vasco Amaral, Miguel Goulão, and Pedro Patrício. "
Model-Driven Development for Requirements Engineering: The Case of Goal-Oriented Approaches."
8th International Conference on the Quality of Information and Communications Technology (QUATIC 2012). Eds. João Pascoal Faria, Ana Paiva, and Ricardo Machado. Lisbon, Portugal: IEEE CPS, 2012.
AbstractGoal-Oriented Requirements Engineering (GORE) has received increasing attention over the past few years.
There are several goal-oriented approaches, each one using different kinds of models. We argue that it would be useful to relate them or even perform transformations among them automatically, in order to understand their similarities and differences, their advantages and disadvantages, allowing a possible migration or comparison between approaches. This is something that has not received enough attention. In this paper
we propose the definition and implementation of goal model transformations between i* and KAOS. As an immediate contribution, the approach can be used to migrate from one goal model to another through automatic model transformations. This approach also contributes to relate the concepts of i* and KAOS models and will help, for example, a development team in making the decision on which approach to follow, according to the nature of the project and the expressiveness of an approach to represent certain concepts
(e.g., obstacles are represented explicitly in KAOS, but not in i*). Another contribution is to facilitate communication among members of the same team, if they are specialized in different approaches.
Mateus, O. "
New dinosaur and pterosaur tracksites from the Late Jurassic of Portugal." Chongqing, China: 2012 Abstract Book of Qijiang International Dinosaur Tracks Symposium, 2012.
AbstractPortugal is rich on dinosaur remains (bones, eggs, and tracks) from Early Jurassic to Late
Cretaceous ages, but mainly from the Late Jurassic, in which dozen of tracksites have been reported.
Here are reported new or poorly known track localities:
1) Five tracksites share the preservation substrate (marine carbonated limestone), age (late Jurassic), geographic area (Leiria district of Portugal), kind of preservation (true tracks), and completeness (trackways of multiple individuals):
i) Praia dos Salgados includes eight trackways, mostly ornithopods and theropods, and one wide gauge sauropod, made in very soft sediment; some preserve the hallux impression.
ii) Serra de Mangues is mostly covered with vegetation but seems to include dozens of tracks comprising theropods, thyreophorans, ornithopods and sauropods.
iii) Sobral da Lagoa (Pedreira do Rio Real) include six trackways but poorly preserved;
and
iv) Serra de Bouro that preserves four sauropod trackways in one single layer.
v) Pedrógão, preserved, at least, one theropod trackway and several isolated tracks of
theropods and ornithopods were found in different layers in the Early Oxfordian.
2) The locality in Praia de Porto das Barcas yielded natural casts of stegosaur tracks
(including pes print with skin impression) and a very large sauropod pes print with about
1.2 m long pes.
3) A new pterosaur tracksite was found in the Late Jurassic of Peralta, Lourinhã (Sobral Member, Lourinhã Fm.; Late Kimmeridgian/Early Tithonian). More than 220 manus and pes tracks have been collected in about five square meters, all ascribed to pterosaurs. The tracks were produced in a thin mud layer that has been covered by sand which preserved them as sandstone mould infill (natural casts). The manus of the largest specimens is 13 cm wide and 5.5 cm long and the pes measures 14.5 cm in length and 9 cm in width. This shows the occurrence of very large pterosaurs in the Late Jurassic. Other pterosaur tracksites in the Late Jurassic of Portugal are: Porto das Barcas (Lourinhã Municipality), South of Consolação (Peniche Municipality), and Zambujal de Baixo (Sesimbra Municipality).
Hendrickx, C., R. Araújo, and O. Mateus. "
The nonavian theropod quadrate: systematics usefulness, major trends and phylogenetic morphometrics analysis." Journal of Vertebrate Paleontology, Program and Abstracts, 2012, p.110. ISSN 1937-2809 , 2012.
Abstract
The quadrate in nonavian theropods is incredibly diverse morphologically; however this morphological disparity has been underestimated for taxonomic purposes. The quadrate topological homologies and anatomy, as well as the terminology, among nonavian theropod clades are reviewed. In order to evaluate the phylogenetic potential and investigate the evolutionary transformations of the quadrate, we conducted a Catalano-Goloboff phylogenetic morphometric analysis using 3 morphometric characters, a total of 28 landmarks coded for 23 taxa, as well as a cladistic analysis using 115 discrete quadrate-related characters coded for 43 taxa. The cladistic analysis provides a fully resolved tree mirroring the current classification of nonavian theropods. The quadrate morphology by its own provides a wealth of data with strong phylogenetic signal. Several unambiguous synapomorphies support nonavian theropod relationships and the resulting consensus tree allows inference of major trends in the evolution of this bone. Important synapomorphies include: for Abelisauridae, a lateral ramus extending to the ectocondyle; for Tetanurae, the absence of the lateral process; for Spinosauridae, a medial curvature of the ventral part of the pterygoid ramus occurring just above the mandibular articulation; for Neotetanurae, an anterior margin of the pterygoid flange formed by a roughly parabolic margin; and for Tyrannosauroidea, a semi-oval pterygoid flange shape in medial view. The Catalano-Goloboff phylogenetic morphometric analysis reveals two main morphotypes of the mandibular articulation of the quadrate linked to function. The first morphotype, characterized by an anteroposteriorly broad mandibular articulation with two ovoid/subcircular condyles roughly subequal in size, is found in Ceratosauria, Tyrannosauroidea and Oviraptorosauria. This morphotype allows a very weak displacement of the mandible laterally. The second morphotype is characterized by an elongate and anteroposteriorly narrow mandibular articulation and a long and parabolic/sigmoid ectocondyle. Present in Megalosauroidea, Allosauroidea and Dromaeosauridae, this morphotype permits the lower jaw rami to be displaced laterally when the mouth opened.
Vicente da Silva, M., and A. N. Antão. "
A novel augmented Lagrangian based formulation for upper bound limit analysis."
International Journal for Numerical Methods in Engineering. vol. 89.nº 12 (2012): pp. 1471-1496.
AbstractThis paper describes a novel upper-bound formulation of limit analysis. This formulation is an innovative variant of an existing two-field mixed formulation based on the augmented Lagrangian method also developed by the authors. A natural approach is used to describe the deformation of each finite element. Furthermore, and in contrast to the previous formulation, two independent field approximations are now both used to define the velocity field, defined globally and at element level. It is shown that this feature allows a governing system of uncoupled linear equations to be obtained. Some numerical examples in plane strain conditions are presented in order to illustrate the current model performance. In conclusion, the potential and advantages of this new approach are discussed.