14 articles in this selection

2009/12/03

Anchor Modeling is an Open Source database modeling technique built on the premise that the environment surrounding a data warehouse is in constant change. A large change on the outside of the model will result in a small change within. The technique incorporates the natural concepts of objects, attribtues and relations making it easy to use and understand. It is based on the sixth normal form, resulting in a highly decomposed implementation, which avoids many of the pitfalls associated with traditional database modeling. Thanks to its modular nature the technique supports separation of concerns and simplifies project scoping. You can start small with prototyping and later grow into an enterprise data warehouse without having to redo any of your previous work....

2009/08/07

An extension ADAPT (Application Design for Analytical Processing Technologies) to facilitate the modeling of temporal aspects.

2009/08/02

ADAPT (Application Design for Analytical Processing Technologies) is the first design methodology specifically created to represent the objects and operations found in OLAP databases. ADAPT Visio template available.

2009/07/08

The Power*Architect is a user-friendly data modeling tool created by data warehouse designers, and has many unique features geared specifically for the data warehouse architect. It allows users to reverse-engineer existing databases, perform data profiling on source databases, and auto-generate ETL metadata....

2009/06/29

Oracle has paved the way for developers to more easily build data models that create and update existing databases. The Oracle SQL Developer Data Modeler, which integrates with Oracle SQL Developer, arrived today as a standalone tool that supports logical, relational, multi-dimensional and data type modeling....

2009/06/17

This activity is designed to help you understand the methodology for building a Decision Table. Decision tables are used to lay out in tabular form all possible situations which a business decision may encounter and to specify which action to take in each of these situations. You will use them in your projects to clarify complex decision making situations and should find them useful in your work as a computer professional....

2009/06/17

Decision tables are a precise yet compact way to model complicated logic. Decision tables, like if-then-else and switch-case statements, associate conditions with actions to perform. But, unlike the control structures found in traditional programming languages, decision tables can associate many independent conditions with several actions in an elegant way....

2009/06/17

Kalido delivers a robust, business model-driven, best practice-based information management engine that can automatically feed information to end users through their BI tools making them more productive far more quickly and reducing internal costs. Kalido's information management engine allows you to quickly model critical business scenarios such as organizational change or margin analysis, unlocking true intelligence about your business....

2009/06/17

Tool that enables model driven development of data warehouses and data marts.

2009/06/09

Follow the rules to ensure granular data, flexibility and a future-proofed information resource. Break the rules and you'll confuse users and run into data warehousing brick walls.

2009/04/30

2008/10/02

Cycle-time improvements and time-waste reduction are being accomplished by improving equipment setup times and operations. Realizing even greater efficiency, however, requires the use of more sophisticated means of collecting data and controlling the equipment. The Equipment Data Acquisition (EDA) interface brings direct improvements to manufacturing activities and opens new doors to accelerate process research, development, and deployment by providing enhanced data collection capabilities....

2008/04/22

MySQL Workbench enables a DBA, developer, or data architect to visually design, generate, and manage all types of databases including Web, OLTP, and data warehouse databases. It includes everything a data modeler needs for creating complex ER models, and...

2008/02/29

On this site we discuss the business sides of data modeling, how information can be modeled in different formats - the pros and cons of each modeling technique, the limitations of the modeling techniques, and what impacts they have on business. We discus...