Loading…
Attending this event?
Welcome to the Online Session Guide for the COMMON 2017 Annual Meeting and Exposition. With your free account, you will be able to create a personal schedule, connect with other attendees, take session evaluations and download handouts.

Please note: the log in information for the Online Session Guide is different than your Cosmo ID and password. If you have an Online Session Guide account from a past COMMON event, please use it to log in. If you do not have an account, set up one here.
View analytic
Saturday, May 6 • 8:00am - 11:30am
A1AA WORKSHOP: Application Modernization Database

Sign up or log in to save this to your schedule and see who's attending!

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? In this workshop you will learn why to go from DDS to SQL, what are the benefits of SQL over DDS. Techniques for converting and redesigning your existing grown over the time database into a modern normalized database will be shown. In a modern environment database objects can and must be accessed from multiple interfaces and programming languages. For guaranteeing data integrity and security business logic and security rules should be moved 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. 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. This session 170027.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Software and Database Engineer, Toolmaker Advanced Efficiency GmbH
Birgitta Hauser has been a Software and Database Engineer since 2008, focusing on RPG, SQL and Web development on IBM i at Toolmaker Advanced Efficiency GmbH in Germany. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She also works in consulting and education as a trainer for RPG and SQL developers. Since 2002 she has frequently spoken at the COMMON User Groups and other IBM i and Power Conferences... Read More →


Saturday May 6, 2017 8:00am - 11:30am
Grand Caribbean 1 - 2, Lobby/Grand Caribbean Level
  • Operating System IBMi
  • Session Content Level Advanced
  • 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.

Attendees (13)




Twitter Feed