|LOS ANGELES AREA
DB2 USERS GROUP NOTICE TO MEMBERS
|March 25, 1999
To: Los Angeles Area DB2 Users Group Members
||The next meeting of the Los Angeles Area DB2 User Group
will be on Thursday, April 1, at the Sequoia Conference Center in Buena Park. Directions:
The Sequoia Conference Center is located at 7530 Orangethorpe Avenue, Buena Park, CA.
Telephone is (714) 670-9252. It is one block north of the 91 Freeway at the Beach
Boulevard exit (same exit as for Knott's Berry Farm). Coffee will be served at 8:30 am;
the presentation will begin at 9:00 and end at 12:00.
|Program: The April program will consist of two
||Presentation:"Time Dependent Data? Two Companies - Two DB2 Solutions."
How to store and access time dependent data is a weighty design
issue with numerous pros and cons. Two nationwide companies, an insurer and an automobile
manufacturer, have addressed their specific requirements with very different DB2
solutions. Faced with all the legal ramifications that go along with being an
auto/home/life insurer, one of our nations largest insurance companies requires an audit
trail of every single change applied to a policy. They support present-dated, past-dated
and future-dated transactions. And, they require access to this data in their operational
DB2 database as it was (or will be) at any point in time. A well-known automobile
manufacturer has quite different time dependent data requirements in their expanding DB2
Data Warehouse. While some user views include a complete audit trail, other user views
require limiting the result set to only the most current data. The detailed requirements
and solutions chosen by these two companies will give you insight into handling your own
time dependent data issues.
Janice Bies has supported every version of DB2 since 1984 when
she joined the DB2 V1.1 ESP (Early Support Program) at Northrop Corp. As a DBA, she has
provided design, development, capacity planning and maintenance support, managed
Northrop's participation in the DB2 V2.1 ESP, and trained over 600 programmers in DB2/QMF.
She currently supports a DB2 Data Warehouse expansion project for a large automobile
manufacturer. Her specialty is designing for performance and the tuning of large-scale
Round Table Panel Discussion
An "open question" session, during which your technical DB2 questions will be
addressed by a panel of specialists. Moderated by Judson Howard. So, bring your burning
questions to our April meeting. And, tell your friends!
I look forward to seeing all of you at the next meeting.
President -- Los Angeles Area DB2 User Group