Expert Database Updates and Delivery

1. Expert Database Updatesand Delivery Roundtable TSMS Jeff Ledbetter Roundtable Product Architect

2. Tugboat Software • Progress Technology Alliance Partner • Roundtable TSMS • Roundtable Team • Other Solutions • SOS Labor Scheduling • SOS Vacation Scheduling

3. Session Agenda • What is Roundtable and SCM? • Logical Schema • Schema Domains • Updating the Physical Database • Promoting Schema Changes • Sneak Preview • Questions

4. Roundtable TSMS Roundtable TSMS is a team-oriented extension for the OpenEdge Studio and OpenEdge Architect development environments that provides Software Configuration Management and developer productivity tools.

5. Software Configuration Management Software Configuration Management is the discipline of managing the entire life cycle of a software project.

6. Software Configuration Management Software Configuration Management is the heartbeat of any serious software development effort. One would not start mass producing a car without first building a factory and defining the production line. SCM is THE factory for software development. It is the discipline, based on the principles of the manufacturing industry that brings repeatable, high-quality production to your software applications. Gary S. Clink, Senior Solutions Engineer Progress Software, UK

7. Software Configuration Management • Configuration Identification • Configuration Control • Configuration Status Accounting • Configuration Auditing

8. Configuration Identification • Identify application components • Define the physical and functional hierarchy • Identify application configurations

9. Configuration Control • Establish configuration security • Manage application changes • Define workflow

10. Configuration Auditing • Ensure existence of required components • Review configuration changes

11. Configuration Status Accounting • Identify changes made to configuration • Identify work in process

12. Problem – Managing Schema without SCM • Store .df files • No history of schema changes • Difficult to revert to previous schema releases • Promoting schema changes is manual process • No impact analysis

13. Solution – Logical Schema Management • Stored in Roundtable repository • Access controlled by security settings • Changes associated with a task • Version history per schema object • Promoted through lifecycle • Revert to previous versions • Impact analysis

14. Logical Schema – Object Types • PDBASE • Database Object Definition • PFILE • File Object definition • PFIELD • Field Object definition Sports2000 - 2.0.0 Sports2000 -1.0.0 Customer -1.1.0 Customer -1.0.0 Customer.Name -1.0.0 Customer.Number -1.0.0

15. Logical Schema - PDBASE • Database Object Definition • PDBASE is a collection of... • PFILE Objects • Sequence definitions PFILE assignments are attributes of this version of the PDBASE Object

16. Logical Schema - PDBASE • Different versions of PDBASE Objects can have… • Different PFILE Object assignments • Different Sequence definitions New PFILE Object assignment for this version

17. Logical Schema - PFILE • File Object Definition • PFILE is a collection of… • PFIELD Objects • Index definitions PFIELD assignments are attributes of this version of the PFILE Object

18. Logical Schema - PFILE • Different versions of PFILE Objects can have… • Different PFIELD Object assignments • Different Index Definitions New PFIELD Object assignment for this version

19. Logical Schema - PFIELD • Field Object Definition • Different versions of PFIELD Objects can have different attributes • Can be assigned to multiple parents

20. Logical Schema – Direct Manipulation • Logical schema Object definitions are created/modified via Roundtable • Logical Schema is modified/assembled using Schema Manager • Logical Schema is later applied to physical database via Schema Update

21. Logical Schema – Indirect Manipulation • Schema Object definitions can be loaded from a physical database using Load Schema tool • Preview and selectively load schema changes • Logical schema is updated automatically • Automatically create update notes

22. Logical Schema - Putting it Together Demo

23. Schema Domains • Assignment of a single PFIELD or PFILE Object to multiple parents • Share a common Object definition • Facilitates managing common fields across multiple tables • Not supported via Schema Load

24. Logical Schema – PFIELD Domain • Provides a single PFIELD definition for multiple assignments • The PFIELD assignments inherit changes made to the domain PFIELD definition

25. Logical Schema – Schema Domains Demo

26. Promoting Schema Changes • Schema changes can be promoted through development life-cycle • Make schema changes once and push them downstream • Update downstream physical databases using Schema Update

27. Delivering Schema Changes • Schema changes can be delivered to your end-user by including schema in a Workspace deployment • Data Processing procedures can also be included in your deployment • Database updating and data transformation processing is automated at your end-user site with the Roundtable setup and update tools • Roundtable is not required at the end-user site

28. Delivering Schema Changes Demo

29. Some Common Problems • Partially promoting schema changes • Making schema changes twice • Manually reverting physical schema • Confusing loading and udpating

30. Roundtable 11.0 - What’s Coming • Schema viewer • Schema compare • Improved Schema Update UI • Improved data procedure handling • Direct manipulation via plug-in for OEA

31. What Did We Learn • Software Configuration Management is a defined set of principals • Roundtable manages logical schema definitions • Schema domain Objects are an effective way to manage common fields • Deployments help deliver targeted schema application schema changes

32. More Information • www.roundtable-tsms.com • White Papers • Come by our Booth!

33. Questions