The paper presents the most recent achievements in developing AMADEOS - the first online web-based tool aimed at business process model-driven database design. The preexisting AMADEOS was able only to derive an initial conceptual database model automatically, while other design phases were not supported. The most recent development efforts resulted in the complete coverage of the database design process, from conceptual model to physical database, by using the standard UML notation.

The paper presents an early prototype of an online tool named SpeeD, which is aimed at conversion of a recorded speech into the corresponding conceptual database model. SpeeD is the first tool that provides such functionality. The tool is currently able to process English speech and generate the model represented by the corresponding UML class diagram.

The paper presents an approach to reverse engineering of a relational database schema. The approach enables database schema extraction from the corresponding metadata stored in the data dictionary by executing a universal set of queries regardless of the source database management system. The concrete queries are generated by combining predefined templates with concrete metadata for the particular source system. Based on the proposed approach, we implemented a software tool and experimentally validated it. The implemented solution enables reverse engineering of relational databases managed by several contemporary database management systems.

The article presents an approach aimed at automatically deriving the initial conceptual database model from a set of business process models. The approach proposes the incremental synthesis of the target model by iteratively composing the partial conceptual database models that are derived from the models contained in the source set. The approach is implemented by the AMADEOS tool, which is the first online web-based tool enabling the automatic derivation of the conceptual database model from a set of business process models. The experimental evaluation proves that the implemented approach enables effective automatic derivation of the initial conceptual database model.

The paper presents an approach aimed at automatically deriving the conceptual database model from a set of business process models. The approach proposes the incremental synthesis of the target model by iteratively composing the partial conceptual database models that are derived from the models contained in the source set. The approach is implemented by the AMADEOS tool, which is the first online web-based tool enabling the automatic derivation of the conceptual database model from a set of business process models.

The paper presents an online system named REDBUL, which is aimed at reverse engineering of relational databases. REDBUL enables database designers to automatically extract the schema from an existing relational database, and visualize it in a web browser, whereby the extracted schema is represented by the standard UML class diagram. Currently, two relational database management systems are supported by the REDBUL system, MS SQL and MySQL, while the paper illustrates reverse schema engineering for a MySQL database.

The paper presents an online web-oriented system named SOLARS, which is aimed at calculating the feasibility of building the photovoltaic (PV) systems. SOLARS currently enables potential investors to calculate the technical and financial feasibility of building the PV systems in the Republic of Srpska (Bosnia and Herzegovina). Very intuitive GUI design enables investors to obtain feasibility calculations in three simple steps: (i) selection of a geographical location, (ii) specification of technical parameters, and (iii) specification of financial parameters. A usage scenario is illustrated by a real feasibility calculation example.

The paper presents an algorithm for automatic layout of class diagrams. The presented algorithm efficiently and openly tries to lay out a diagram in the landscape format using a modified Sugiyama algorithm. The proposed algorithm is implemented as an Eclipse plug-in and works within Papyrus class diagram modeling projects.

The paper presents an approach to web-based visualization of automatically generated data models, which combines visualization principles used in desktop applications, and usage of web-based technologies. The proposed approach is implemented and integrated with an existing online system for automatic synthesis of conceptual database models based on business process models. The approach and implemented online system named AMADEOS are illustrated by an example of visualization of the UML class diagram representing the conceptual database model automatically generated based on the source BPMN model.