Hotsos Symposium Speaker – Kevin Williams

Kevin Williams is a new Hotsos Symposium presenter.

Biography

Kevin WilliamsKevin has been working with Oracle software since 1991, where he was a marketing analyst at a large cellular telephone company. The version was 6.0.33 on VMS and the database was a DSS (Decision Support System) with more than 40GB of data — at the time this was extraordinary. Since 1996, he has been an independent consultant DBA, mostly implementing large packaged applications (Oracle E-Business Suite and Siebel). He has spoken to local Oracle User groups, led classes at many of his clients about Oracle tuning issues and techniques, and taught for two years at the University of New Mexico. Kevin earned an MBA in Investment Finance from California State University Long Beach (CSULB) in 1986, and has recently finished his coursework (but not the dissertation) for a Ph.D. in Information Systems and Technology at Claremont Graduate University (CGU).

Presentation Title

How We Dealt With The Chronic Problem Of Too Much Data On A Large OLTP System

Abstract

Many or all of you have worked on systems with chronic problems. The system still functions well, but there are constant problems to be worked around or ignored. When he initially converted to a Siebel OLTP system, Mr. Williams asked one of the Vice Presidents about the corporation's data retention policy and with absolute seriousness he said, "Our data retention policy is 28 years" — which is funny since the company at that time was less than 15 years old.

Fast forward — by the time the project was started, the system was about seven years old and had too much data. Too much data? What do we mean by this? How did we go about resolving it? How did we justify the cost of the initiative?

In this presentation, Kevin will detail many of the problems in his journey to address the issue of too much obsolete data in a large OLTP system. The problems were not acute, but were slowly zapping extraordinary system resources and money. They were very similar to chronic health problems that had been ignored far too long.

As a key system in a complex organization, there were a large number of constraints to address the basic problem of having data in the database that was no longer needed. This presentation will share some of the lessons learned from this exercise. These useful lessons appeal to anyone with a system that is growing continually, and for which the system issues may or may not be solved by future technological or organizational innovation.

Ignoring a problem definitely doesn't make it go away.

Presentation Materials

Presentation materials are available online to attendees only.

Schedule

The speaker schedule is as follows: