|
|
 |
|
|
Upcoming Events
|
|
|
| | Su | Mo | Tu | We | Th | Fr | Sa |
|---|
| 29 | 30 | 1 | 2 | 3 | 4 | 5 | | 6 | 7 | 8 | 9 | 10 | 11 | 12 | | 13 | 14 | 15 | 16 | 17 | 18 | 19 | | 20 | 21 | 22 | 23 | 24 | 25 | 26 | | 27 | 28 | 29 | 30 | 31 | 1 | 2 | | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
|
|
Sponsors |
 |
|
CTOUG EVENTS
Materialized Views, Caching & Database Worst
Practices
|
Cost: |
Free
|
|
Date:
|
Mar 26, 2008
|
|
Agenda: |
5:00 – 5:30 Networking and Refreshments
5:30 – 5:45 CTOUG Business
5:45 – 8:00 "Materialized Views", Tom Kyte
"Database Worst Practices or SQL Techniques", Tom Kyte "Open Forum", Tom Kyte
|
Location:
|
The Hartford
Hartford Plaza (Tower 22), Hartford, CT 06115
Visit our website for details, directions and much more!
|
|
Topics: |
Materialized Views, Caching – 1.5 hours
Materialized Views were a new feature in Oracle 8i Release 1 (8.1.5). Over the last
eight releases of the Oracle database, they have grown in capability and day to
day importance. In this session we’ll explore what a materialized view is, how they
work, when we might use them, and various useful ‘techniques’ you need to know in
order to make the most of them.
Database Worst Practices 1 hour
A lot of time is spent by IT professionals studying best practices in the industry.
This presentation turns that around and takes a look at some "worst practices,"
the top things you can do to ensure failure, delays, and poor performance in your
database applications. Instead of focusing on things to do in your database applications,
the presentation looks at things you should never do. The presentation uses actual
customer experiences to investigate the top 10 things done wrong over and over again,
and how to avoid making the same mistakes yourself.
|
|
|
Tom Kyte is a Senior Technical Architect in Oracle’s
Server Technology Division. Before starting at Oracle, Kyte worked as a systems
integrator building large-scale, heterogeneous databases and applications, mostly
for military and government customers. Kyte spends a great deal of time working
with the Oracle database and, more specifically, working with people who are working
with the Oracle database. In addition, Kyte is the Tom behind the AskTom column
in Oracle Magazine, answering people's questions about the Oracle database and its
tools (http://asktom.oracle.com/). Kyte is also the author of Expert Oracle Database
Architecture (Apress, 2005), Expert One on One Oracle(Wrox Press, 2001/Apress 2004),
Beginning Oracle Programing (Wrox press, 2002/Apress 2004), and Effective Oracle
by Design (Oracle Press, 2003). These are books about the general use of the database
and how to develop successful Oracle applications.
|
Archived Events:
|