Data Management Forum  -  PO Box 20303, Greeley Square Station, New York, N.Y. 10001-0007


Send Page To a Friend
:: Menu ::

We now have 11611
on-line registered users!


We have an email list of over 27,000 interested
IT professionals!


We also have a postal mailing list of over 83,000.

For greater anti-spam accountability, DMForum uses a professional email subscription service.
:: PLATINUM SPONSOR::
Dataguise
Dataguise


:: GOLD SPONSORS::
Commvault
Commvault
Scientel Information Technology, Inc
Scientel Information Technology, Inc

:: MEDIA SPONSORS::
Dama International
Dama International
DAMA NCR
DAMA NCR
Database Trends and Applications
Database Trends and Applications
ibmdatamag
ibmdatamag
Information Management
Information Management
Inmon Consulting
Inmon Consulting

:: PATRONS::
BI Ready
BI Ready
Embarcadero
Embarcadero
EW Solutions
EW Solutions
keyword search
About Us :: Prior Events
Pre-Conference Seminar- 4-26-2007
Prior Events    1/21/2007 8:01:28 PM

ABOUT  THE  PRE-CONFERENCE  SEMINAR  ON  FEA 
AND  DATA WAREHOUSING

Seminar Program:
Full-Day Tutorial - April 26 - Prior to Conference Day)
ENTERPRISE ARCHITECTURE AND DATA WAREHOUSING DESIGN:
A FEDERAL ENTERPRISE ARCHITECTURE APPROACH

Michael Hermida, President, K3MP Technologies,
Popular Seminar Leader and World Leading Expert in Data Warehouse Design
Past Lead Architect, Space Shuttle and SpaceLab Programs
DB2 & DRM Program Manager with 16 Years Experience at IBM 

SEMINAR  TOPICS  COVERED

Role of PMO and

Industry Advisory Council

Transitioning from a Baseline to a Target Architecture

President’s eGov Initiatives / Management Agenda

FEA Framework Using Reference  Models

DRM & Data Sharing

SCBA / SOA and

Component Re-Use

Bridging FEA and

DW Architectures

Zachman’s Framework / Inmon’s GIF  / Kimball Bus

Dimensional vs Relational Modeling

Central Data Warehouse

vs Constellations

Designing Star Schemas

Surrogate vs Business Keys

Data Quality Assessment

Source to Target Mapping

Master Data Management

 

Value Banding Techniques

Bridge & Outrigger Tables

Best Practices in Design

Techniques in Near Real-time Data Warehousing

Summary Tables and Query Rewrite

Ease of Use in Designing  Hierarchies

Handling History  and

Change Management

Data load /  Refresh Strategy

Data Staging  and

Control Methods

Snowflaking

Data Quality Scorecards

Indexing and

Partitioning Schemes

 

Full-Day Seminar Includes:
 - Refreshment Breaks - Continental Breakfast - Seminar Workbook - Discounts for Government / Academic, DAMA, Groups of 3 or More (see website)

 

WHAT YOU WILL LEARN

  • What are the Goals and Objectives of the FEA – What is the impact on Data Warehousing
  • How does the Presidents eGov Initiatives and Management Agenda Drive the FEA Program
  • Why does the Data Reference Model play a Key Role in Data Sharing and Component Re-Use
  • Why do Inmon’s GIF and Zachman’s Framework Support FEA Strategy
  • Moving from Government-Centric to Customer-Centric Focus
  • How Enterprise Architecture Shapes Your Data Warehouse Plan
  • Review the Development Phases, Tasks and Optimal Deployment of Staff
  • When to Build Independent Marts vs. Central Data Warehouses
  • How Data Warehouse Modeling and Design Differs from Application Modeling
  • Gain Insight into Building Resilient Databases that Evolve Gracefully
  • How Source to Target Data Mapping / Translation Help Achieve Data Integration
  • Interlocking STAR Schemas or Classic Relational Design….Which Is For You
  • Learn the role of Type, Translation, Trigger and Status Tables in Design
  • Understand the Reasons Why Some Data Warehousing Implementations Fail
  • Understand How to Decide on the Best Data Architecture for Your Organization
  • Fine-Tuning Your Data Warehouse for Maximum Flexibility and Efficiency
  • Why Data Quality Techniques are Mission-Critical to Successful Implementation

SEMINAR ABSTRACT and BIOGRAPHY

Existing Information Technology assets must be leveraged and reused to support agency initiatives, where appropriate. Investment in future assets must demonstrate a strong business case, and be built in such a way that processes and services can be applied across Government segments. This seminar takes a look at the Federal Enterprise Architecture (FEA) in terms of a services and component based architecture, and how an approach like this is key to implementing the vision laid out in IT strategies. It looks at both process component reuse and data sharing and how they lead to more flexible and easier to construct systems and business intelligence platforms. Following the architecture discussion, the seminar focuses in on data warehousing from both an architecture and a design standpoint. The data warehouse development lifecycle is followed with an emphasis on pitfalls to avoid and important processes required for successful warehouse implementations. Dimensional modeling is also covered in detail with many design techniques and physical implementation guidelines presented.   During Mike Hermida's sixteen-year career with IBM, he developed operating systems and access methods for the nation's enroute air traffic control system, and ground-based Space Shuttle programs, and was a lead architect for the Spacelab's command and control system. He was also a technical member of the field test team for the rollout of IBM's DB2 database management system. Within IBM he managed a staff responsible for the development of tools and  utilities to enhance the DB2 development environment, and also managed a Data Resource Management (DRM) department of data modelers, DBAs, and performance analysts supporting DB2, SQL/DS and IMS systems.  With a partner, Mike started the Knauer DB2 User Group in New York City that grew to over one thousand members, and developed and implemented a set of DB2 value added services to support the firm's national database practice. Mike is currently the President of K3MP Technologies, a consulting firm that specializes in relational database implementation, data warehousing, and decision support systems. Mike has developed and taught numerous classes and lectured extensively to professional groups both nationally and internationally on data and database management topics, data warehousing, and business intelligence tools. He has also taught seminars for DAMA Chapters, the Potomac Forum, and is a Technical Advisor to the Data Management forum.