Expert Database Updates and Delivery

crookpatedspongyΛογισμικό & κατασκευή λογ/κού

2 Δεκ 2013 (πριν από 3 χρόνια και 11 μήνες)

65 εμφανίσεις

Jeff Ledbetter

Roundtable Product Architect

Expert Database Updates

and Delivery

Roundtable TSMS

©
2011 Tugboat Software. All rights reserved.

2

Tugboat Software


Progress Technology Alliance Partner


Roundtable TSMS


Roundtable Team


Other Solutions


SOS Labor Scheduling


SOS Vacation Scheduling


©
2011 Tugboat Software. All rights reserved.

3

Session Agenda


What is Roundtable and SCM?


Logical Schema


Schema Domains


Updating the Physical Database


Promoting Schema Changes


Sneak Preview


Questions


©
2011 Tugboat Software. All rights reserved.

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.

©
2011 Tugboat Software. All rights reserved.

5

Software Configuration Management

Software Configuration Management

is
the discipline of managing the entire
life cycle of a software project
.


©
2011 Tugboat Software. All rights reserved.

6

Software Configuration Management

Gary S. Clink, Senior Solutions Engineer

Progress Software, UK

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.


©
2011 Tugboat Software. All rights reserved.

7

Software Configuration Management


Configuration Identification


Configuration Control


Configuration Status Accounting


Configuration Auditing

©
2011 Tugboat Software. All rights reserved.

8


Identify application components


Define the physical and functional hierarchy


Identify application configurations

Configuration Identification

©
2011 Tugboat Software. All rights reserved.

9


Establish configuration security


Manage application changes


Define workflow

Configuration Control

©
2011 Tugboat Software. All rights reserved.

10


Ensure existence of required components


Review configuration changes

Configuration Auditing

©
2011 Tugboat Software. All rights reserved.

11


Identify changes made to configuration


Identify work in process

Configuration Status Accounting

©
2011 Tugboat Software. All rights reserved.

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


©
2011 Tugboat Software. All rights reserved.

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


©
2011 Tugboat Software. All rights reserved.

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

©
2011 Tugboat Software. All rights reserved.

15

Logical Schema
-

PDBASE


Database Object Definition


PDBASE is a collection of...


PFILE Objects


Sequence definitions

Sports2000 (WIP) 2.0.0

Customer 1.0.0

Order 2.0.0

OrderLine

1.1.0

Warehouse 1.0.0

PFILE assignments
are attributes of
this version of the
PDBASE Object

©
2011 Tugboat Software. All rights reserved.

16

Sports2000 (1.0.0)

Customer

Order

OrderLine

Logical Schema
-

PDBASE


Different versions of PDBASE
Objects
can
have…


Different
PFILE
Object assignments


Different Sequence definitions

Sports2000 (2.0.0)

Customer

Order

OrderLine

Warehouse

New PFILE
Object
assignment for
this version

©
2011 Tugboat Software. All rights reserved.

17

Logical Schema
-

PFILE


File Object Definition


PFILE is a collection of…


PFIELD Objects


Index definitions

Customer (WIP) 2.0.0

CustNum

1.0.0

Name 2.0.0

City 1.1.0

Hairstyle 1.0.0

PFIELD
assignments are
attributes of this
version of the
PFILE Object

©
2011 Tugboat Software. All rights reserved.

18

Customer (1.0.0)

CustNum

Name

City

Logical Schema
-

PFILE


Different versions of
PFILE Objects
can
have…


Different PFIELD Object assignments


Different Index Definitions

Customer (2.0.0)

CustNum

Name

City

Hairstyle

New PFIELD
Object
assignment for
this version

©
2011 Tugboat Software. All rights reserved.

19

Logical Schema
-

PFIELD


Field Object Definition


Different versions of PFIELD Objects can have
different attributes


Can be assigned to multiple parents

©
2011 Tugboat Software. All rights reserved.

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

©
2011 Tugboat Software. All rights reserved.

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

©
2011 Tugboat Software. All rights reserved.

22

Logical Schema
-

Putting it Together

Demo

©
2011 Tugboat Software. All rights reserved.

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

©
2011 Tugboat Software. All rights reserved.

24

FIELD Object

myNameField

Customer.Name

Supplier.Name

Warehouse.Name

Logical Schema


PFIELD Domain


Provides a single
PFIELD
definition for multiple
assignments


The
PFIELD
assignments inherit changes made to the
domain
PFIELD definition

©
2011 Tugboat Software. All rights reserved.

25

Logical Schema


Schema Domains

Demo

©
2011 Tugboat Software. All rights reserved.

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

©
2011 Tugboat Software. All rights reserved.

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

©
2011 Tugboat Software. All rights reserved.

28

Delivering Schema Changes

Demo

©
2011 Tugboat Software. All rights reserved.

29

Some Common Problems


Partially promoting schema changes


Making schema changes twice


Manually reverting physical schema


Confusing loading and
udpating


©
2011 Tugboat Software. All rights reserved.

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

©
2011 Tugboat Software. All rights reserved.

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



©
2011 Tugboat Software. All rights reserved.

32

More Information


www.roundtable
-
tsms.com


White Papers


Come by our Booth!

©
2011 Tugboat Software. All rights reserved.

33

Questions