In this paper we propose a novel specification of a UML profile for the representation of a relational database schema. The profile specification is based on the UML class diagram extension that exploits operation signature for the representation of specific relational database concepts, such as single and multi-column primary and foreign keys, indices, etc. The advantages of the proposed approach are: reduction of additional properties in the stereotypes representing the keys, better visualization of database constraints and more efficient forward database engineering. We also present the corresponding profile implementation as an open source development platform plug-in, which allows manual modeling, as well as the automatic (software/program) generation of a relational database scheme in accordance with the defined profile. The application of the implemented profile is illustrated by an example of visualization of a particular relational database schema.

In this paper we perform performance measurements of six different servers that can function as key-value stores, ranging from purpose made key-value store memcached, over more complex Redis to MySQL, a traditional relational database that also implements access by memcached protocol. We analyze the influence of number of simultaneous clients and item data size on measured wall time of client and server components.

This article presents a survey of model-driven techniquesfor data model synthesis. During an extensive research,we identified more than 70 research papers in the field andmore than 15 different graphical notations used for the sourcemodel representation.We have classified the proposed approachesinto four distinct groups: function-oriented, process-oriented,communication-oriented and goal-oriented. Their contributionsare presented in chronological order and evaluated based onseveral main criteria. Although the idea of model-driven designof the data model is more than 25 years old, the survey showsthe richness and diversity of ideas, but only a small number ofimplemented automatic generators.

This paper presents a software tool for the automatic visualization of the UML activity diagram representing a business process model. The implemented tool takes the XMI-based representation of a programmatically generated activity diagram as the input and automatically generates its layout in accordance with the UMLDI specification. This auto layout feature is implemented as an Eclipse-Topcased plug-in named VisualAD.

This paper presents an approach to the automated design of the initial conceptual database model. The UML activity diagram, as a frequently used business process modeling notation, is used as the starting point for the automated generation of the UML class diagram representing the conceptual database model. Formal rules for automated generation cover the automatic extraction of business objects and business process participants, as well as the automatic generation of corresponding classes and their associations. Based on these rules we have implemented an automatic generator and evaluated it on a real business model.

In this paper we have analysed the impact of running transactions at different isolation levels on application performance, more specifically on the execution time of the set of transactions. Three scenarios of transaction executions were defined, based on real applicative cases, and applied to different transaction sets and transaction isolation levels. Tests were performed using three actual DBMS: Oracle, Microsoft SQL Server and MySQL.

This paper presents an ATL-based automatic generator of the initial conceptual database model. The implemented generator takes the detailed UML business activity diagram as the source business model and generates the UML class diagram representing the target initial conceptual database model.

In this paper we present an approach to the use-case-driven conceptual design of the relational database completely based on the Unified Modeling Language (UML). We base the initial conceptual model on the standard UML business profile. In the first phase, business use cases are identified and described by macroactivity diagrams. After that, detailed business activity diagrams are designed by populating macroactivity diagrams with used business objects, object flows and worker's responsibilities. Based on detailed business activity diagrams, related business class diagrams are designed, and finally integrated into a single business class diagram that describes the static structure of the entire business system. In the last phase, that integral business class diagram is mapped into a system class diagram that represents the initial conceptual model of the target relational database. Therefore, some transformations of the initial conceptual model are proposed and illustrated. Thanks to the unified notation and integrated treatment of business modeling and database design, the proposed approach unifies and accelerates the implementation of the information system. This approach is illustrated by taking a visa issuing system as an example.

In this paper one approach for business modeling (BM) based on UML business profile (BP) is presented. The static aspect of the BM in the iterative-incremental (I-I) software process development is described and both business models: business use case model and business object model are presented. Dynamic aspect of the BM is presented too, as well as the mechanisms to connect the BM with the other activities in the system development. Some appropriate recommendations for efficient migration of the business models in the initial system UML models are given. Described methodology is wholly integrated in the I-I process, and because of the advantages of the BM based on UML BP, all advantages of the I-I software process development are additionally improved