AllFusion ERwin Data Modeler: Database Design Made Easy

Data — A Critical Business Asset

Successful Information Management Starts With Optimal Database Design

ERwin Features and Functionalities

ERwin Data Modeler: Transform Technology
Rarely does a physical database design match the original logical data design. Business constraints dictate the need to denormalize tables to meet the performance requirements of today’s business applications. Transform technology lets you implement these types of changes while maintaining the integrity of the original design.

ERwin Data Modeler: Standards Definition
The definition and maintenance of standards is supported through the Domain Dictionary, Naming Standards Editor and Datatype Standards Editor. The Domain Dictionary contains reusable attributes and helps ensure consistent names and definitions across the model. The Naming Standards editor lets you create a glossary of valid words, abbreviations and naming rules that can also be reused across the model. The Datatype Standards Editor enables you to define the standards for mapping both user-defined and default data types to specific database management system data types.

ERwin Data Modeler: Large Model Management
AllFusion ERwin DM helps you manage large enterprise models through Subject Areas and Stored Displays. Subject Areas provide a focused view for individual modelers, dividing the model into smaller, manageable subsets. Stored Displays offer multiple graphical views of the model or its Subject Areas, facilitating information exchange between specialized groups of users.

ERwin Data Modeler: Complete Compare
This powerful feature automates model and database synchronization. AllFusion ERwin DM compares the model with the database, displays the differences and lets you select which differences to move into the model and which to generate to the database. If model changes move into the database, AllFusion ERwin DM automatically generates a database alter script. In addition, model-to model Complete Compare and importing/ exporting capabilities are offered.

ERwin Data Modeler: Database Design Generation
AllFusion ERwin DM includes optimized referential integrity trigger templates and a rich crossdatabase macro language, allowing you to customize triggers and stored procedures. From the model’s physical design, full definitions (as appropriate for the target database) are generated for databases/ tablespaces, tables and views, columns with defaults and domain constraints, primary keys, foreign keys and indexes, stored procedure and trigger code, and volumetric and other physical properties.

ERwin Data Modeler: Data Warehouse and Data Mart Design
The performance, usability and value of a data warehouse are determined by its underlying design. AllFusion ERwin DM supports data warehousing-specific modeling techniques (such as Star Schema and Snowflake dimensional modeling), thereby optimizing the data warehouse for your performance and analysis needs. ERwin Data Modeler also captures and documents a rich set of information about the warehouse, including data sources, transformation logic and data management rules.

ERwin Data Modeler: Drawing Objects
AllFusion ERwin DM lets you graphically represent business rules through drawing objects. These objects, such as lines and ellipses, are fully editable and you can customize their font and color.

Model Explorer.
The AllFusion ERwin DM Model Explorer provides an additional method for creating and modifying model objects. Rather than presenting a picture of the model in the traditional diagram window manner, the Model Explorer provides an organized, ordered view of the model and its contents. The Model Explorer lets you create, display, navigate and modify a model using the model, subject area or domains pane.

ERwin Data Modeler: Reporting and Printing
Visualization and publication are the keys to communication and collaboration in data modeling. AllFusion ERwin DM provides flexible, customizable reporting and printing capabilities.

ERwin Data Modeler: Complete, Open and Integrated
The value proposition of the AllFusion Erwin DM can be extended in unique and valuable ways through the use of tightly integrated AllFusion® companion products and/or thirdparty metadata integrations.

• AllFusion Saphir Option for ERP.
  This solution extracts and stores detailed metadata from cryptic ERP packages such as SAP R/3, SAP BW, PeopleSoft and J.D. Edwards. AllFusion Saphir Option then allows the user to search, browse and subset this ERP-specific metadata prior to creating AllFusion ERwin DM models. These “ERP-specific” AllFusion ERwin DM models can then be utilized to support numerous initiatives, such as ad hoc reporting, data warehousing and metadata management, as well as ERP package management and customization.
• AllFusion Data Model: Validator
  This valuable add-in allows modelers to automate the validation of their database designs, thus allowing them to perform this task quicker, more accurately and earlier in the development life cycle. The AllFusion Data Model Validator provides the user with the choice of more than 80 ranked diagnostics to be applied against their data models. AllFusion Data Model Validator provides a knowledge base, design tips and corrective suggestions, as well as generating corrective scripts to be applied against the model and associated database.
• ERwin Data Modeler: API and Add-In Manager
  Using the ERwin Data Modeler API and Add-In Manager, you can work with secondary software applications supplied by third parties to perform specific tasks outside the boundaries and offerings included in AllFusion ERwin DM.

What’s New in ERwin Data Modeler r4.1.4

• Windows Authentication for Connections to SQL Server Version 7 and Oracle Version 8 Databases.
• Improved Support for Oracle and DB2 UDB Databases.
• Creating Transforms When Opening an ERwin® Release 3.5.2 Model in AllFusion® ERwin® DM r4.1.4.
• Setting TABLE and INDEX OWNER Names During Forward Engineering.
• Complete Compare Enhancements.
  • Dialog Updates.
  • Key Import/Export Capabilities.
  • Filtering.
  • Tablespace Deletion.
• Synchronizing Comments and Definitions.

AllFusion ERwin Data Modeler Supported Environments:

Databases:
Advantage™ CA-Clipper®, Advantage™ Ingres® Enterprise Relational Database, DB2, dBASE, FoxPro, HiRDB, Informix, InterBase, iSeries, Microsoft Access, Microsoft SQL Server, ODBC 2.0/3.0, Oracle, Paradox, Rdb, Red Brick Warehouse, SAS, SQL Anywhere, SQL Base, Sybase, Teradata