Tom Haughey
Data Warehouse Architectures
Together with
Chris O'Brien
Network Architecture at Wyeth
and
Craig Phillips
An Architecture First, Use Case Driven Approach To Enterprise Reinvention
The Presenters:
Tom Haughey is one of four founders of Information Engineering in America. He is currently President of InfoModel, Inc., specializing in Data Warehousing, Database, Information Engineering and related topics such as Distributed Data, Object Oriented and Client Server. He was formerly CTO for Pepsi Bottling Group and Director of Enterprise Data Warehousing for PepsiCo. He has also served as Vice President of Technology for Silverrun Technologies (developers of the CASE tools SILVERRUN and POSE) and as Senior Project Manager for IBM. His most recent Data Warehousing achievements were an enterprise data warehouse at Pepsi Bottling Group and a federated data warehouse for Prudential. He has worked on the development of seven different CASE products and wrote his own CASE tool in 1984. His courses on Data Warehousing, Information Engineering, Data Modeling and CASE have been delivered to Fortune 1000 companies around the world. He is the author of many articles on Data Warehousing and Information Engineering. He is working on a book, entitled "Designing the Data Warehouse - The Real Deal".
An architecture is a set of guidelines, structures and relationships that unify and guide the development of an end product. The first part of the presentation describes the architecture of a DBMS and alternatives for accessing data from one or more sites (centralized, distributed, replicated and federated DBMSs). The second part of the presentation describes the architecture of a data warehouse and maps the DBMS architectures to it. Data warehouse architecture alternatives include centralized, functional, federated, imbedded data mart, dependent data mart and independent data mart. The choice of correct architecture is dependent on many factors, among them the goals of the business, the maturity of the organization, the kind of data and queries, the centralization of the organization, and others. This presentation will discuss these architectures and present case examples of successful and unsuccessful examples of each. The most popular current trend will also be discussed; the answer may surprise you.
Chris O’Brien is Enterprise Consultant for Enterprise Technology & Application Architecture at Wyeth. He has been responsible for developing and communicating the vision for Wyeth Pharmaceuticals’ network architecture and continues to be involved with its implementation.
Networks are a key factor in distributing and managing data in a global organization. The network architecture at Wyeth Pharmaceuticals consists of "principles, technical positions, and templates". The process of developing these architectural components required communication with many parts of the organization. This presentation will focus on the steps taken and lessons learned.
Craig Phillips has 22 years experience designing and writing software. A certified Rational consultant, Mr. Phillips serves as an OO mentor for Praxis Engineering Technologies, enabling and evangelizing RUP/UML/CBD/OO to the community.
This presentation will focus on methodology techniques, envisioned by Dr. Murray Cantor, of Rational Software, that inject architecture early into the analysis and design process, especially targeted to large-scale systems development.
Use cases are targeted to architecture artifacts in a breadth-first, layered decomposition approach. Enterprise level use cases form the basis of an enterprise concept of operations (CONOP). Key business domain objects are discovered; an initial, top level, enterprise architecture is abstracted using UML packages; and enterprise level use cases are expanded to manifest the architectural components and interactions thereof. These interactions are then illustrated using UML interaction diagrams. The messages flowing into an architectural component become the set of candidate use cases at the next level of decomposition. The process continues to the component level of detail.
All contents copyright © 2003, DAMA Philadelphia all rights reserved