Today, when we talk about application modernization, most think about having to reface their application and going mobile. 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?
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. Add row and column access control (RCAC) for avoiding unauthorized data access. Start using instead of triggers to allow a further 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.
Moving Business Logic into Database
DDS described logical files versus Views versus Indexes
Binary Radix Tree Indexes
Encoded Vector Indexes
DDS described physical files versus SQL Tables
Unique Identifier (Identity columns, RowId, Sequences, Generate_Unique)
CREATE OR REPLACE – From DDS to SQL
Row and Column Access Control (RCAC)
Journaling and Commitment Control
Constraints and Referential Integrities
System and SQL Trigger
Instead Of Trigger