Data Modeling Tools

There are a number of data modeling tools to transform business requirements into logical data model, and logical data model to physical data model. From physical data model, these tools can be instructed to generate sql code for creating database. Popular Data Modeling Tools: Tool Name Company Name Erwin Computer Associates Embarcadero Embarcadero Technologies Rational…

Read More

Data Warehouse and Data Mart

A Data Warehouse is a relational/multidimensional database that is designed for query and analysis rather than transaction processing. A data warehouse usually contains historical  data that is derived from transaction data. It separates analysis workload from transaction workload and enables a  business to consolidate data from several sources. In addition to a relational/multidimensional database, a…

Read More

DDL Scripts from a Data Model

How to create DDL Scripts from Data Model? Open the physical data model “Data_Modeling_Relationship.txl”. Click menu Model/Verify Model. A new window will be opened. Check the appropriate objects like entities, functions, packages, materialized views, relationship, synonyms, data types etc which are listed in the new window. Click “Verify” button on the bottom of the page….

Read More
error: Content is protected !!