providex data dictionary views system n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
ProvideX Data Dictionary & Views System PowerPoint Presentation
Download Presentation
ProvideX Data Dictionary & Views System

Loading in 2 Seconds...

play fullscreen
1 / 32

ProvideX Data Dictionary & Views System - PowerPoint PPT Presentation


  • 255 Views
  • Uploaded on

ProvideX Data Dictionary & Views System. Presented by: Patrizio Lucci. Presentation Overview. Data Dictionary Maintenance Enhancements Data Dictionary Object Suite Views System Enhancements. Data Dictionary Maintenance Enhancements. Data Dictionary Merge Utility Zlib Compression Type

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'ProvideX Data Dictionary & Views System' - eve-howell


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
providex data dictionary views system

ProvideXData Dictionary & Views System

Presented by:

Patrizio Lucci

presentation overview
Presentation Overview
  • Data Dictionary Maintenance Enhancements
  • Data Dictionary Object Suite
  • Views System Enhancements
data dictionary maintenance enhancements
Data Dictionary Maintenance Enhancements
  • Data Dictionary Merge Utility
  • Zlib Compression Type
  • Signed Integer Key Segment Support
data dictionary maintenance enhancements1
Data Dictionary Maintenance Enhancements

Data Dictionary Merge Utility

  • Available in three forms
  • An interactive utility in Data Dictionary Maintenance
  • Object method of the *dict/database and *dict/pvxdb object

Merge (SourceDDF$, SourceTable$, DestinationDDF$, MergeOption$)

Merge (SourceDDF$, DestinationDDF$, MergeOption$)

Merge (SourceChannel, SourceTable$, DestinationChannel, MergeOption$)

Merge (SourceChannel, DestinationChannel, MergeOption$)

  • A callable program

CALL “*dict/merge;Merge_Tables”,SourceDDF$,SourceTable$,DestinationDDF$,MergeOption$

CALL “*dict/merge;Merge”,SourceChannel,SourceTable$,DestinationChannel,MergeOption$

  • All methods and call properties are fully documented in the new ProvideX Data Dictionary Manual
data dictionary maintenance enhancements2
Data Dictionary Maintenance Enhancements

Data Dictionary Merge Utility

Information about the currently selected item

Information is organized by data group.

data dictionary maintenance enhancements3
Data Dictionary Maintenance Enhancements

Data Dictionary Merge Utility

Replace Contents

data dictionary maintenance enhancements4
Data Dictionary Maintenance Enhancements

Data Dictionary Merge Utility

Merge Contents

data dictionary maintenance enhancements5
Data Dictionary Maintenance Enhancements

Data Dictionary Merge Utility

Skip

data dictionary maintenance enhancements6
Data Dictionary Maintenance Enhancements

Zlib Compression

  • ZLib Compression is for VLR and EFF files only
  • Systems must be capable of dynamically loading the ZLib DLL (Windows) or shared library object (UNIX) in order to create physical files that are Zlib Compressed
  • New TCB(195) will return 1 if ZLib support is available
data dictionary maintenance enhancements7
Data Dictionary Maintenance Enhancements

Signed Integer Key Segment Support

  • Now signed integers will be sorted correctly
  • Solution is flipping the high order bit (Sign bit) on all signed integers in the key segment, which results in the following

sort sequence:

0x80000000 Largest negative # becomes 0x00000000 (Lowest key)

... ...

0xFFFFFFFE negative 2 becomes 0x7FFFFFE

0xFFFFFFFF negative 1 becomes 0x7FFFFFF

0x000000000 zero becomes 0x80000000

0x000000001 one becomes 0x80000001

0x000000002 two becomes 0x80000002

... ...

0x7FFFFFFF highest positive # becomes 0xFFFFFFFF (Highest key)

data dictionary object suite
Data Dictionary Object Suite

Consists of 3 Main Objects

DataBase

  • Creating and maintaining Dictionary information (providex.ddf and providex.dde)
  • Basically provides the same functionality as Data Dictionary Maintenance interface

PVXdb

  • Creating and maintaining embedded dictionary of your physical file

ODBsql, OCIsql or DB2sql

  • New for Version 7
  • Creating and maintaining relational Data Base information (SqlServer, MySql, Access, Oracle and DB2)
  • All methods and properties are fully documented in the new ProvideX Data Dictionary Manual
data dictionary object suite1
Data Dictionary Object Suite

Entity Objects

Control Objects

Control Objects

views enhancements
Views Enhancements
  • New Wizard Look
  • SQL Database Support
  • Logic Procedures
  • Free-Form Filters
  • Import/Export Utilities
  • Object Interface for Creating Views
  • New ways to accessing View Data
  • Views Deployment
views enhancements1
Views Enhancements

New Wizard Look for Data Source Maintenance

  • Allows for a quicker setup
  • Forces user to follow a proper procedural protocol for creating data sources

Go to first panel

Go to last panel

Previous sequential panel

Next sequential panel

views enhancements2
Views Enhancements

SQL Database Support

  • Enables connection to ODBC (Sql Server, MySql, Access),OCI, and DB2 at the client and/or server side
  • Allows for other connection options, such as PSWD=,USER=, etc.
    • Multiple options must be separated by a semi-colon
  • Sort
    • Any Column
    • Case
      • Case sensitive
      • Use upper case
      • Use lower case
  • Ascending or Descending sequence
views enhancements3
Views Enhancements

SQL Database Support

Indicates the DSN name

Drop box selection of valid database types (ODBC, OCI and DB2 Local or Server)

Once connected this drop box will contain a list of available tables

Display the defined primary key

Supports all OPEN parameters for connecting via ODBC, OCI and DB2 as specified in the ProvideX Language Reference Manual

views enhancements4
Views Enhancements

SQL Database Support

Specifying case

Drop down list of all columns in table.

This drop down list offers a choice of Ascending or Descending

views enhancements5
Views Enhancements

Logic Procedures

  • Enable you to specify logic to be performed at various levels.
  • You have a overall Initialization, Execution and Close Logic points.
  • Within the Data Source and Views Maintenance you can add Initialization and Close Logic points.
views enhancements6
Views Enhancements

Logic Procedures

Execution Order

1. General Initialization - when initially entering the Views system.

2. General Execution - prior to retrieving/displaying data.

3. View Initialization - when a View is opened via ’open( ) method.

4. Data Source Initialization - when a data source handler is established.

5. Data Source Close - when a data source handler is dropped.

6. View Close - when a View is closed via ’close( ) method.

7. General Close - prior to exiting the Views system.

views enhancements7
Views Enhancements

Logic Procedures

Access General Logic Procedures

views enhancements8
Views Enhancements

Logic Procedures

General Execution logic prior to retrieving/displaying data.

General Initialization logic when initially entering the Views system

General Close logic executed prior to exiting the Views system

Object Logic to perform these procedures using the methods OnLoad( ), OnClose( ), and OnExecute( )

views enhancements9
Views Enhancements

Data Source Close logic executed when a data source handler is dropped

Logic Procedures

Data Source Initialization logic executed when a data source handler is established

Object Logic to perform these procedures using the methods OnLoad( ), OnClose( )

views enhancements10
Views Enhancements

View Close - when a View is closed

via ’close( ) method

Logic Procedures

View Initialization logic executed when a View is opened via ’open( ) method

Object Logic to perform these procedures using the methods OnLoad( ), OnClose( )

Access Logic Procedures

views enhancements11
Views Enhancements

Free-Form Filter

  • Expression must evaluate to a zero/non-zero result
  • Zero value would result in a record being excluded
  • Non-zero result would cause a record to be included in the data set.
  • One free-form filter is allowed per View
  • Maximum expression length is 500 characters
  • Filter expression may consist of references to any of the data elements in the View
views enhancements12
Views Enhancements

Free-Form Filter

List of columns to assist in building the free-form filter

views enhancements13
Views Enhancements

Import/Export

  • These utilities allow you to merge from one set of View definition files (pvxview.*) into another
  • Exported Views definitions are stored as formatted text files
  • Export file options
    • Purge contents before export (default)
    • Append to pre-existing export file
  • Import utility has a easy to understand tree view with state indicators to deal with duplicate sources
views enhancements14
Views Enhancements

Information about the currently selected item

Import/Export

Information is organized by data group.

Export path and purge options

views enhancements15
Views Enhancements

Information about the currently selected item

Import/Export

Information is organized by data group.

views enhancements16
Views Enhancements

Object Interface for Creating Views

  • Provides same functionality programmatically, as the interactive Data Source Maintenance and View Maintenance
  • ViewCtl object delegates functionality to subordinate objects to deal with Views, Data Source and Data Group definitions
  • These subordinate objects delegate functionality to deal with Views items, data source items, and relationships

ObjID = NEW ("*views/viewctl [,ViewsDirectory$], ERR=stmtref)

  • All methods and properties are fully documented in the Views Version 7 Manual
views enhancements17
Views Enhancements

New Ways to Access View Data

  • You can now programmatically alter a view definition before the data is retrieved
  • This is all possible because you can now pass an object identifier to the View object

VCtl=NEW("*views/viewctl",err=DoErr)

Vu=VCtl'Load("View: Customer")

VCtl'RemoveItem(Vu,"cls_desc")

View=NEW("*views/view",VCtl)

View'open(Vu)

VCtl

View: Customer

View

VCtl

views enhancements18
Views Enhancements

Client would like to add OrderDate to this view.

I will export the view and ftp the text file to the client site.

Now I just need to Import this view in.

Views Deployment

ProvideX Developer

Web Site with Views

Clients System

thank you

THANK YOU!

End of Presentation