UIP Data Administration
UIP Data Modeling and Analysis Techniques
Data Administration can provide data modeling and analysis services for new
systems as well as major enhancements to existing systems.
What is a Data Model?
A data model is an abstract, unambiguous representation of the structure and
content of the body of information used by an organization.
Why develop a Data Model?
A data model documents the data requirements of a database system. The goal is to create a model with the simplest, least redundant structure. The model is an ideal starting point for building a physical database. It is the most flexible design possible, because it allows for future growth and expansion.
How is a Data Model typically developed?
A data model is developed in a series of structured, moderated modeling sessions. In the sessions, a data analyst leads a group of users and designers through questions and discussions about the data that will be tracked in the system. As the data is discussed and analyzed by this group, the data model is created using a methodology called Extended Relational Analysis (ERA).(Note: Your browser must support "tables" to view this
page) ERA was developed in 1970s specifically for 4th generation
--relational--database products. It is efficient, understandable, and
consistent. The data model is then transcribed and a validation session is held to review and make any changes to the model.
The individuals involved in the modeling sessions, as well as other users, participate in the review.
How long does it take to develop a Data Model?
The length and number of modeling sessions required to develop a data
model varies according to the scope of the system being developed. Data
Administration will provide an estimate for services, prior to beginning
work.
What does a Logical Data Model look like?
The components of a Data Administration standard data model include ERA tables (Note: Your browser must support "tables" to view
this page) which include sample data, an Entity Relationship
diagram, and a data dictionary.(Note: Your
browser must support "tables" to view this page)
The Organization *
The Services * The Techniques * The People * UIP Home Page