BP0740: What's In A DataType

1
BP0740 What's In A DataType?

• Simon Epps Product Manager
• Donna McMann Principal Software Engineer
• Progress Software

2
Products Under Development

• This talk includes information about potential
  future products and/or product enhancements.
• What we are going to say reflects our current
  thinking, but the information contained herein is
  preliminary and subject to change. Any future
  products we ultimately deliver may be materially
  different from what is described here.
• In other words - you cant believe everything we
  are going to say.

3
Objectives

• To understand the commitment and the options
  available when deploying a DataServer solution
• Becoming the right domain expert
• Best practices to make the DataServer solution
  and YOU, look good

4
Agenda

• DataServer Introduction
• The need for Domain Expertise
• DataServer Domain Expertise
• Conclusions
• Questions and Answers

5
What Are DataServers?

• Connectivity to non-Progress data sources
• read and update access to data
• Application consistency technology
• Single source solution
• Data source type transparent to application

Your 4GL Application
DataServer Engine
6
Agenda

• DataServer Introduction
• The need for Domain Expertise
• DataServer Domain Expertise
• Conclusions
• Questions and Answers

7
DataServer Domain Expertise

• The Progress DataServer Technology relies on
  three distinct areas each requiring Domain
  Expertise

8
Agenda

• DataServer Introduction
• The need for Domain Expertise
• DataServer Domain Expertise
• The environment
• The Schema Holder
• Conclusions
• Questions and Answers

9
Becoming a DataServer Domain Expert

• The DataServer is the bridge between the unique
  architectures of a 4GL Application and a non
  Progress RDBMS
• For optimization the DataServer must be tailored
  to best suit the traffic between these two unique
  architectures
• Must understand the influence of
• The Progress 4GL
• The environment

10
Influencing Environment

• Not every application or RDBMS is the same
• Methods to tailor and bridge the differences
  between the 4GL and target RDBMS
• Record locking behavior
• Query behavior
• Cache sizes
• Connection characteristics

11
Influencing Environment Schema Holder
4GL Application

• Translation repository
• between Progress and
• foreign data source
• Issues affecting
• Performance
• R-code

Schema Holder
Progress Validation Help
Progress Client with DataServer capabilities
12
... And the Survey Says

• FREE Gifts
• Highest user count ?
• Oracle DataServer
• MS SQL Server DataServer
• Other
• Best Oracle or Microsoft joke

13
Agenda

• DataServer Introduction
• The need for Domain Expertise
• DataServer Domain Expertise
• The environment
• The Schema Holder
• Internals
• Maintenance
• Deployment
• Futures
• Conclusions
• Questions and Answers

14
Schema Holder Explained

• Methods to update schema
• Using the Delta SQL Utility, how does it work and
  what does it produce for deployment
• Performing maintenance in the foreign data source
  and how to update your schema holder

15
Update Schema Method 1

• Native tools and DataServer Utilities
• SQL Tool of Choice
• SQLPlus
• Query Analyzer
• Enterprise Manager
• DataServer Utilities
• Update Server Schema
• Adjust Server Schema

16
Update Schema Method 2

• Generate Delta SQL Utility
• Why use it
• What's produced
• Business problem it solves

17
Generate Delta Utility

• What do you need available to use utility
• What does the utility do
• What does the utility NOT do
• How does it help deployment

18
Generate Delta Utility

• Whats Needed to begin
• Original Schema Holder
• Progress Delta .df file

Schema Holder
19
Generate Delta Utility

• Connect To schema holder.
• Select Generate Delta SQL from Schema Migration
  Menu.
• Using SQL Width.

20
What Is Happening

• Read Progress Delta.df
• Read Original Schema
• Create SQL Script
• Create Schema Holder delta .df
• Create Report

21
Whats NOT Happening

• Change in Format or Width
• Missing renamed/updated/dropped object will abort
  utility
• Rename only renames in schema holder
• Drop Constraints
• Initial Values

22
Delta Utility Feedback

• Should objects be renamed?
• Initial values Does anyone use something else
  beside TODAY for dates?
• Should utility abort if something missing like
  dropping field?

23
Deployment

• SQL Script
• Schema Holder .df or new Schema Holder

Schema Holder
24
Schema Holder Futures

• Changes to Utilities for Oracle
• MSS new utility and what it supports
• Data Width report
• New support for Data Types

25
Enhancements for Oracle

• Shadow Column vs Upper Function Based Index
• Supports dropping columns
• Eliminate creation of views

26
MS SQL Server DataServer

• Will now have Delta SQL Utility
• Based on Oracles
• Code Page Considerations
• Constraints

27
Data Width Report

• Why use
• Where it is
• Who benefits
• How to avoid future problems

28
New Data Types

• BLOBS, CLOBS
• Datetime Timestamp
• ?

29
Agenda

• DataServer Introduction
• The need for Domain Expertise
• DataServer Domain Expertise
• Conclusions
• Questions and Answers

30
Where Have We Been?

• Delta SQL Utility
• What you need
• How to use
• Why to use
• Format vs Width
• We have listened

31
Walk-away Conclusions

• Must become a Domain Expert in
• The 4GL Application
• The DataServer
• The target RDBMS
• The DataServer should be tailored to suit the
  application and target RDBMS
• Environment
• Schema holder

32
Questions and Answers
!
All questionsanswered