| Why ER/Studio? |
ER/Studio is a powerful and complete solution for modeling, architecture, and creating physical database designsThe ER/Studio® XE2 is the most innovative and intuitive modeling and information architecture solution on the market. Combining process, data, application modeling and reporting into a multi-level design environment, ER/Studio XE2 enables you to understand, design and communicate complex systems and architecture faster and easier. Manage all of your database designs and models from multiple database platforms in a single windowER/Studio provides multi-platform DBMS support across your heterogeneous DBMS environment. ER/Studio supports InterBase®, Oracle®, DB2®, Sybase®, SQL Server, Netezza, Teradata, MySQL®, PostgreSQL, and more, all from a single window. Reduce redundant data by leveraging fully separated logical and physical modelsER/Studio supports both logical (non-DBMS or technology-specific) modeling and physical (DBMS-specific) modeling. It is designed to allow organizations the flexibility to analyze and design a business problem or application logically and generate as many different physical interpretations from the logical model as you want. Multiple physical models can also be generated from the logical model for the same DBMS or other DBMSs. Easily create highly readable, highly navigable diagramsER/Studio's progressive interface and simplicity has been designed to effectively address the ease-of-use issues which have plagued data modeling and CASE tools for the past decade and more. The application equips you to create, understand, and manage the life-cycle of mission-critical database designs and business metadata within the enterprise. Ensure standardization across your SOA implementations with XSD generationEnsure XML projects such as those using Service Oriented Architecture (SOA) are based on the same standards and metadata as your data models by modeling them in ER/Studio and generating XSD from either the physical or logical model. This allows for the re-use of existing metadata and ensures corporate standards are enforced. Improve communication and documentation with automatic report generationFacilitate communication with non-users of ER/Studio by publishing data models and metadata directly to a corporate intranet or website for review by executive management or business analysts. ER/Studio's documentation generator enables users to automatically create reports in HTML or RTF that provide simple navigability through data models and model metadata. Take search and reporting capabilities even further with ER/Studio Portal. Visually trace and document data origins across systemsThe visual data lineage functionality provides data professionals with more flexibility, richer metadata and a visual representation of data movement between databases, flat files and XML structures. With a clear understanding of where data originated and where it is used, organizations can be assured that they know what their data actually means and how it can best be utilized.
|
