Loading...
Please wait, while we are loading the content...
Similar Documents
Uma linguagem de modelagem e uma ferramenta CASE para apoiar o projeto lógico de banco de dados relacionais
| Content Provider | Semantic Scholar |
|---|---|
| Author | Fernandes, Lúcio Alves |
| Copyright Year | 2017 |
| Abstract | The design of a BD is divided into three stages: conceptual design, logical design and physical design. The conceptual design is the first step in the process of constructing the BD system and has the function of creating the conceptual schema. The conceptual schema has the role of specifying the objects and the relationships between them that are relevant to the BD system being implemented. The logical design consists of transforming the conceptual schema into a logical schema by mapping the structures present in the conceptual schema using an implementation data model. A commonly used implementation model is the Relational Model, which implements the BD as a set of relations. The physical project defines which SGBD will be used, as well as storage, backup and optimization issues. However, while the design phases of a BD system are clearly defined, logical design is often polluted with elements from other phases. For example, information about cardinality of relationships, user groups, access rules can often be found in the logical schema. In this way, it was sought in literature to make the distinction of the relevant concepts the different stages of the design of a relational BD system. A metamodel is designed based on the Model Driven Development (MDD) paradigm, whose greatest benefit is the specification of executable models. That is, diagrams that abstract the complexity of the syntax of a computational language and are used by Computer Aided Software Engineering (CASE) tools to automatically generate executable or interpretable code. However, the solutions found CWM and IMM do not distinguish between concepts related to logical and physical design, nor do they support the creation of CASE tools. In this way, in order to solve the presented problems, this work proposes a modeling language based on MDD and focusing on the domain of the Relational Model for the construction of the logical project. In order to validate the proposal and provide an application of the elements used by the metamodel, the RMMCASE tool was developed, a CASE tool that supports the elements of the modeling language. In addition, a logical example project was created that explores all the proposed elements in order to certify the expressiveness and feasibility of this work. As a result, it can be seen that the proposed work presents an expressive metamodel and a simplified graphical notation that contemplates the concepts of the Relational Model. |
| File Format | PDF HTM / HTML |
| Alternate Webpage(s) | https://repositorio.ufpe.br/bitstream/123456789/28363/1/DISSERTA%C3%87%C3%83O%20L%C3%BAcio%20Alves%20Fernandes.pdf |
| Language | English |
| Access Restriction | Open |
| Content Type | Text |
| Resource Type | Article |
