SQL – Database Modernization |
| Abstract: |
Today, when we talk about application modernization, most think about having to reface their
application. New technologies will be used to change the layout and programs will be
rewritten. … but what will a nice design be worth if the base, i.e. the underlying database is
still in your grandfather’s style grown over the years with lots of redundancies? In this
workshop you will learn why to go from DDS to SQL, what are the benefits of SQL over DDS,
how you can transform, step by step, an old database design towards a modern normalized
database design by using the new features in SQL introduced with the latest releases and
how you can minimize your source code by moving business logic into the database.
|
| Learning Objectives: |
Discover the advantages of SQL over DDS and the SQL enhancements within the last
releases. Replace DDS described physical files with SQL Tables. Use SQL Indexes for
native I/O instead of DDS described keyed logical files. Move business logic into database
by using SQL views, materialized query tables and referential integrities. Encapsulate data
access into procedures or functions (either written in an HLL language or SQL). Replace
native I/O with embedded SQL and integrate SQL Routine, such as stored procedures and
user defined functions. Start using instead of triggers to allow a future redesign of the
existing data base |
| Audience: |
IT Managers, project leaders, programmers and database administrators who are currently
working with an old “grown over time” database and want to modernize this database,
without destroying the current applications. This presentation will also be valuable for those
who need to design the database for a new project. |
| Agenda: |
- Today --> Future: Modernization Goals
- Moving Business Logic into Database
- Logical Files - Versus Views and Indexes
- Views
- Indexes
- Binary Radix Tree and Encoded Vector Indices
- Index Analysis Tools
- Physical Files versus Tables
- Unique Identifiers
- Constraints
- Materialized Query Tables (MQT)
- Journaling and Commitment Control
- Triggers
- External and SQL Triggers
- Instead Of Triggers
- Externalizing Data Access
- Embedded SQL – Overview including Consuming Result Sets
- External and SQL Stored Procedures
- External and SQL User Defined (Table) Functions)
|
| Level: | Advanced |
| Duration: | Full-day |
