<p>Open source software is becoming increasingly popular and many organizations are using them, such as apache (used by over 50% of the world’s web servers) and Linux (a popular operating system). There exist mixed opinions about the quality of this type of software.</p><p>The purpose of this study is to evaluate quality of open source CASE-tools and compare it with quality of proprietary CASE-tools. The evaluation concerns tools used for database modeling, where the DDL-generation capabilities of these tools are studied. The study is performed as a case study where one open source (two, after experiencing some difficulties with the first tool) and one proprietary tool are studied.</p><p>The results of this study indicate that open source database modeling CASE-tools are not ready to challenge proprietary tools. However software developed as open source usually evolve rapidly (compared to proprietary software) and a more mature open source tool could emerge in the near future.</p>

Open source software is becoming increasingly popular and many organizations are using them, such as apache (used by over 50% of the world’s web servers) and Linux (a popular operating system). There exist mixed opinions about the quality of this type of software. The purpose of this study is to evaluate quality of open source CASE-tools and compare it with quality of proprietary CASE-tools. The evaluation concerns tools used for database modeling, where the DDL-generation capabilities of these tools are studied. The study is performed as a case study where one open source (two, after experiencing some difficulties with the first tool) and one proprietary tool are studied. The results of this study indicate that open source database modeling CASE-tools are not ready to challenge proprietary tools. However software developed as open source usually evolve rapidly (compared to proprietary software) and a more mature open source tool could emerge in the near future.

Submitted by Fabio Sobreira Campos da Costa (fabio.sobreira@ufpe.br) on 2016-07-01T11:58:46Z No. of bitstreams: 2 license_rdf: 1232 bytes, checksum: 66e71c371cc565284e70f40736c94386 (MD5) Dissertacao_Jones_final.pdf: 3458864 bytes, checksum: 62e534b2f1fc2266364c4ce46ccf020a (MD5) / Made available in DSpace on 2016-07-01T11:58:46Z (GMT). No. of bitstreams: 2 license_rdf: 1232 bytes, checksum: 66e71c371cc565284e70f40736c94386 (MD5) Dissertacao_Jones_final.pdf: 3458864 bytes, checksum: 62e534b2f1fc2266364c4ce46ccf020a (MD5) Previous issue date: 2015-08-28 / FACEPE / Model-Driven Development (MDD) é um paradigma que usa modelos como o principal artefato no processo de desenvolvimento de sistemas. Isto é, neste paradigma, modelos não são apenas artefatos de documentação, pois devem corresponder a códigos executáveis. Em projetos de Banco de Dados Espaciais (BDE), existem várias linguagens de modelagens (e.g., OMT-G, MADS, GeoProfile e UML-GeoFrame), as quais permitem representar características espaciais (e.g., Múltiplas Representações e Relacionamento Espacial) por meio de uma ferramenta do tipo Computer-Aided Software Engineering (CASE). Embora essas linguagens sejam bem exploradas e difundidas na literatura, constatou-se que estas têm deficiências para modelar e implementar integridade espacial a partir de entidades com múltiplas representações. Assim, de modo a avançar o estado da arte sobre projeto de BDE, este trabalho faz uma análise dos principais trabalhos relacionados, e, de modo a contribuir para superar as deficiências encontradas, propõe uma extensão espacial para a linguagem de modelagem Enhanced Entity Relationship (EER). Essa extensão é implementada na ferramenta EERCASE e avalidada por meio de uma análise comparativa com os principais trabalhos relacionados, evidenciando seus pontos fortes e fracos. / Model-Driven Development (MDD) is a paradigm that uses models as the primary artifact in the systems development process. That is, in this paradigm, models are not only documentation artifacts, since these should be the executable code. In Spatial Databases projects (SDB), there are several modeling languages (e.g., OMT-G, MADS, GeoProfile and UML-GeoFrame), which allow to represent spatial characteristics (e.g., Multiple Representations and Spatial Relationship) by means of a tool type Computer-Aided Software Engineering (CASE). Although these languages are better exploited and widespread in the literature, it was found that they have deficiencies in modeling and implement spatial integrity from entities with multiple representations. Thus, in order to advance the state of the art in SDB project, this paper analyzes the main works related and, in order to contribute to overcome the deficiencies, proposes a spatial extension for modeling language Enhanced Entity Relationship (EER). This extension is implemented in tool EERCASE and evaluated through a comparison with the main work related, highlighting their strengths and weaknesses.

Manufacturing today has become a matter of the effective and efficient application of information technology and knowledge engineering. Manufacturing firms success depends to a great extent on information technology, which emphasizes the integration of the information systems used by a manufacturing enterprise. This integration is also called enterprise application integration (here the term application means information systems or software systems). The methodology for enterprise application integration, in particular enterprise application integration automation, has been studied for at least a decade; however, no satisfactory solution has been found. Enterprise application integration is becoming even more difficult due to the explosive growth of various information systems as a result of ever increasing competition in the software market. This thesis aims to provide a novel solution to enterprise application integration. The semantic data model concept that evolved in database technology is revisited and applied to enterprise application integration. This has led to two novel ideas developed in this thesis. First, an ontology of an enterprise with five levels (following the data abstraction: generalization/specialization) is proposed and represented using unified modeling language. Second, both the ontology for the enterprise functions and the ontology for the enterprise applications are modeled to allow automatic processing of information back and forth between these two domains. The approach with these novel ideas is called the enterprise semantic model approach. The thesis presents a detailed description of the enterprise semantic model approach, including the fundamental rationale behind the enterprise semantic model, the ontology of enterprises with levels, and a systematic way towards the construction of a particular enterprise semantic model for a company. A case study is provided to illustrate how the approach works and to show the high potential of solving the existing problems within enterprise application integration.

Manufacturing today has become a matter of the effective and efficient application of information technology and knowledge engineering. Manufacturing firms success depends to a great extent on information technology, which emphasizes the integration of the information systems used by a manufacturing enterprise. This integration is also called enterprise application integration (here the term application means information systems or software systems). The methodology for enterprise application integration, in particular enterprise application integration automation, has been studied for at least a decade; however, no satisfactory solution has been found. Enterprise application integration is becoming even more difficult due to the explosive growth of various information systems as a result of ever increasing competition in the software market. This thesis aims to provide a novel solution to enterprise application integration. The semantic data model concept that evolved in database technology is revisited and applied to enterprise application integration. This has led to two novel ideas developed in this thesis. First, an ontology of an enterprise with five levels (following the data abstraction: generalization/specialization) is proposed and represented using unified modeling language. Second, both the ontology for the enterprise functions and the ontology for the enterprise applications are modeled to allow automatic processing of information back and forth between these two domains. The approach with these novel ideas is called the enterprise semantic model approach. The thesis presents a detailed description of the enterprise semantic model approach, including the fundamental rationale behind the enterprise semantic model, the ontology of enterprises with levels, and a systematic way towards the construction of a particular enterprise semantic model for a company. A case study is provided to illustrate how the approach works and to show the high potential of solving the existing problems within enterprise application integration.

Clinical study data is usually collected without knowing what kind of data is going to be collected in advance. In addition, all of the possible data points that can apply to a patient in any given clinical study is almost always a superset of the data points that are actually recorded for a given patient. As a result of this, clinical data resembles a set of sparse data with an evolving data schema. To help researchers at the Moffitt Cancer Center better manage clinical data, a tool was developed called GURU that uses the Entity Attribute Value model to handle sparse data and allow users to manage a database entity’s attributes without any changes to the database table definition. The Entity Attribute Value model’s read performance gets faster as the data gets sparser but it was observed to perform many times worse than a wide table if the attribute count is not sufficiently large. Ultimately, the design trades read performance for flexibility in the data schema.

<p>Општи информациони модел (CIM) користи се за опис електроенергетске мреже и за размену података између оператера преносних електроенергетских система. Како је модел постајао све заступљенији, појавила се потреба за његовим складиштењем. У раду је развијен методолошки приступ за развој базе података која би подржала релативно једноставно складиштење и рад са инстанцама CIM модела, које описују тренутно, активно стање у систему. Такође, омогућено је и праћење претходних, историјских стања CIM инстанци, као и њихова рестаурација у жељено стање. Очекује се да предложени приступ олакша увођење CIM модела у различита, наменска програмска решења.</p> / <p>Opšti informacioni model (CIM) koristi se za opis elektroenergetske mreže i za razmenu podataka između operatera prenosnih elektroenergetskih sistema. Kako je model postajao sve zastupljeniji, pojavila se potreba za njegovim skladištenjem. U radu je razvijen metodološki pristup za razvoj baze podataka koja bi podržala relativno jednostavno skladištenje i rad sa instancama CIM modela, koje opisuju trenutno, aktivno stanje u sistemu. Takođe, omogućeno je i praćenje prethodnih, istorijskih stanja CIM instanci, kao i njihova restauracija u željeno stanje. Očekuje se da predloženi pristup olakša uvođenje CIM modela u različita, namenska programska rešenja.</p> / <p>Common Information Model (CIM) is used for describing power grid networks<br />and data exchange among transmission system operators (TSO). As the<br />model became widely used, there was a need to store such model. In this<br />thesis we present a methodological approach to development of a database<br />that supports relatively easy storing and managing CIM instances, which<br />describe current, active state of the system. Also, tracking changes and<br />restoring CIM instances to its previous states are supported. We expect that<br />such methodological approach would ease the implementation of CIM model<br />in various, domain specific software solutions.</p>