Overview of Database Design & Management with Visual Paradigm
Software applications are most likely to be developed with a database such that all data working with the application system can be retained, resulting in information and knowledge. Hence, database application is widely adopted by businesses of all sizes. In order to access and manipulate the relational database, a standard computer language, Structured Query Language (SQL) has to be used. The use of SQL statements was nearly the only choice when developing database application.
Taking a trading system as an example, if the end-user wants to update a Sales Order record, the system has to retrieve the corresponding record from the Sales Order table and display to the end-user. After the end-user confirms the modification of data, the system has to update the record accordingly. It is noticeable that a database application requires a lot of coding for handling SQL statements so as to access and manipulate the database.
Hence, it is inevitable that developers spend almost 50% of development time for implementing the code with SQL statement. Moreover, mapping between the persistent code and database table is maintained throughout the development life cycle. Once there is a change in the structure of a database table, SQL statements which related to the modified table have to be re-written. Developers have to keep an eye on every change in the database schema.
Visual Paradigm provides a solution to develop database application. Visual Paradigm features Object-Relational Mapping tool which provides an ease-to-use environment bridging between object model, data model and relational database. Visual Paradigm not only provides you a visual modeling for both logical data design and physical data design with ERD, but also automates the mapping between object model and data model.
Visual Paradigm generates not only Java and .NET persistent code, but also a cost-effective, reliable, scalable and high-performance object to relational mapping layer. The generated mapping layer includes the support of transaction, cache and other optimized feature. Visual Paradigm increases the productivity and significantly reduces the risk of developing the mapping layer manually.
The following resources may help you to learn more about the topic discussed in this page.
|Chapter 1. Introduction||Table of Contents||2. Benefits of Designing Database with Visual Paradigm|