NYOUG does not share its email list with any vendors or other organizations. You
may opt out of receiving our email blasts at any time by sending an email to
info@nyoug.org with "Remove" in the subject line.
NYOUG
CALL FOR PAPERS
ABSTRACT FORM
Name
Paul Dorsey
Organization
Dulcian, Inc.
Street address
123 Main Street
Address (cont.)
Suite 2332
City
My City
State/Province
My State
Zip/Postal code
12345
Country
Work Phone
212 595-7223
E-mail
pdorsey@dulcian.com
PRESENTATION TOPICS:
All topics of interest to Oracle Professionals are welcome. Please indicate your presentation's category (e.g. DBA, Developer, WEB, etc.)
TOPIC: Dwvwloper
LEVEL:
Advanced - Intermediate -
Beginner
TITLE: Cut Your Data Models Down to Size
Use Generic Modeling
SUMMARY (What will the participant learn from your
presentation? Please do not exceed 3 sentences.)
Using generic modeling techniques, the
number of tables in a database can be decreased by up to
50%, while
simultaneously making the model more robust. Learn a
variety of generic modeling techniques to improve your
data models in this presentation.
ABSTRACT (A brief description of your presentation.
Please do not exceed 200 words.)
There are a variety of generic modeling
techniques. When most people think of generic modeling,
they only think of the fully flexible models that Ulka
Rodgers and David Hay have been talking about for years.
However, those types of generic structures are only one
of many types that can be used to decrease the size of
models. These techniques are as follows:
1. Overloading reference tables
2. Storing relationships in a table 3. Recursive reference tables 4. Overloading primary data tables
All of these techniques will be
discussed in this presentation. All data models will be
shown in both ERD and UML syntax.
Presentation Experience:
Paul
Dorsey has given presentations at OOW 96, 97,
98, and 99, ECO95, 96, 97,
98, 99, 2000, IOUW 96 and 97,
IOUG-A Live 98, 99, 2000, ODTUG97,
98, 99 and 2000 and the keynote speech for
the Fall VOUG99 conference in addition to numerous
other speaking engagements at local user conferences,
technical expositions and corporation sponsored events.
PRESENTER BIOGRAPHY (Not to exceed 3 sentences)
Dr. Paul Dorsey is the President of
Dulcian, Inc., an Oracle consulting firm that specializes
in data warehousing, systems development and products
that support the Oracle environment. Paul is co-author
with Peter Koletzke of Oracle Press Oracle
Designer Handbook, Oracle Developer: Advanced
Forms and Reports and with Joseph Hudicka of Oracle
Press Oracle8 Design Using UML Object Modeling,
all from Oracle Press. Paul is President of the NY Oracle
Users Group and very active in the Oracle user
community.