Jerry Held - PowerPoint PPT Presentation

1 / 42
About This Presentation
Title:

Jerry Held

Description:

Treehouse Software, Inc. & Oracle Corporation. Carrie-Anne Michos. Oracle Corporation. Carrie-anne.michos_at_oracle.com. January 15, 2003. Mitch Doricich. Treehouse ... – PowerPoint PPT presentation

Number of Views:58
Avg rating:3.0/5.0
Slides: 43
Provided by: anal136
Category:

less

Transcript and Presenter's Notes

Title: Jerry Held


1
Treehouse Software, Inc. Oracle Corporation
January 15, 2003
Mitch Doricich Treehouse Software, Inc.
Carrie-Anne Michos Oracle Corporation Carrie-anne.
michos_at_oracle.com
Daniel J. Sycalik Treehouse Software, Inc.
2
Agenda
  • Company Overviews
  • Public Sector Challenges
  • Business Solutions
  • Treehouse Solutions
  • Oracle Solutions
  • Products
  • tRelational/DPS
  • Oracle Public Sector Applications
  • Oracle Business Intelligence
  • Questions and Answers
  • Contact Information

3
Treehouse Corporate Overview
  • Founded in 1982, Treehouse Software is the
    leading independent software vendor for the
    Software AG community. Treehouse provides
  • A broad suite of systems management products
    including performance management, change
    management, development, security and database
    utilities.
  • The most comprehensive data transfer and
    integration management products available for
    ADABAS.
  • A complete set of implementation and support
    services to ensure customer satisfaction.

4
Oracles Government, Education, and Health
Division
  • Dedicated Government Industry Division
  • 525 professional staff
  • Dedicated development team
  • Dedicated professional services group
  • Dedicated sales and sales support organization
  • Leverages Oracle Corporations 1B RD budget

5
Traditional Business Model for Public Sector
  • Partners
  • Suppliers
  • Agencies
  • Service Providers
  • Customers
  • Citizens
  • Students

Administrators
6
Public Sector and e-Government Today
Semi-Manual Transactions
  • Partners
  • Fax
  • E-mail
  • Phone
  • EDI

Electronic Transactions
  • Customers
  • Web Store
  • Kiosks
  • Administrators
  • ERP Applications

Mostly Paper-based
7
Challenges with Legacy Applications
  • The world speaks relational
  • Desktop tools and COTS packages do not support
    ADABAS
  • Difficult end-user or web access
  • OLTP-oriented ADABAS file designs do not suit
    business intelligence apps
  • Ongoing cost of ownership

8
Leading to
  • Non-scalable in-house or purchased solutions
  • Complex architecture with add-ons to give partial
    relational-like use
  • ETL vendors need bolt-ons because they dont
    know ADABAS
  • Middleware masquerading as ETL
  • Non-standard SQL implementations
  • The dirty read problem
  • Suspect data in BI systems
  • Scheduling, performance and maintenance issues

9
Oracle / Treehouse Solutions
10
Treehouse Products
  • tRelational
  • Data Modeling and Mapping
  • Data Propagation System (DPS)
  • Extract, Transform, and Load (ETL)
  • Change Data Capture (CDC)

11
tRelational / DPS Advantages
  • A native ADABAS solution
  • ETL CDC capability
  • Support for complex modeling and transformations
  • High-performance, fully-scalable architecture
  • Native, direct Oracle support

12
tRelational / DPS Features
  • Metadata repository
  • PREDICT integration with FDT conflict resolution
  • ADABAS file analysis tools for modeling
    decision-making
  • ORACLE schema auto-generation
  • ORACLE DDL generation
  • Complex modeling and mapping
  • Automatic datatype mapping/transformation
  • GUI modeling environment
  • Materialization (ETL) produces native output for
    SQL loader utility
  • Propagation (CDC) produces native output for SQL
    processing utility
  • ADABAS PLOG Consolidation (APC)
  • Intelligent handling of primary keys

13
tRelational Data Analysis and Modeling
14
tRelational Statistical Analysis
This screen shows descriptor/superdescriptor
usage statistics to determine candidate Primary
Keys and indexed columns.
15
tRelationalPC - Auto Generation Example
Five tables with Primary Key and Foreign Key
constraints, and the added DPS Sequencer (MU
or PE occurrence).
16
DPS Materialization (ETL)
17
DPS Propagation (CDC)
18
tRelational / DPS is the Answer
  • Maximum performance
  • Reliability through static data sources
  • Extensible architecture
  • Zero impact on ADABAS databases
  • No change in technology
  • TSI 20 years of ADABAS/NATURAL product
    development expertise
  • tRelational/DPS Available and advancing since
    1995

19
tRelational / DPS - The Benefits
  • Ability to leverage your operating data in ADABAS
    with Oracles Data Warehousing and Business
    Intelligence solutions
  • Offers both ETL and CDC capabilities to migrate
    and/or propagate ADABAS data without impacting
    performance
  • Capability to add new and powerful applications
    that can coexist with your current operating
    environment
  • Allows safe migration from your existing custom
    applications to Oracles packaged Applications

20
Oracle Public Sector e-GovernmentOverview
21
11i Transforming into e-Government
22
Fragmented Point Systemsto Integrated Suite
Goal
Oracle Solution
  • Oracle Applications 11i
  • Complete e-Business Suite
  • Runs entirely on the Internet

Seamless Integration
23
From Internal to External Focus
Goal
Oracle Solution
  • Oracle Applications 11i
  • Unifies all processes online
  • Improves efficiency and reduces costs

Connecting all constituents and operations online
24
From Administrative to Self-Service
Goal
Oracle Solution
  • Oracle Applications 11i
  • Lowers cost
  • Improves accuracy
  • Enhances speed
  • Promotes productivity

Move all administrative transactions to
self-service
25
From Local to Global
Goal
Oracle Solution
  • Oracle Applications 11i
  • Real-time information
  • Better decision-making
  • Lowers cost

Single source of Enterprise-wide information
26
E-Business Intelligence Suite 11i
Business Intelligence Portal
Organizational Planning
LOB Decision Maker
Agency Analyst
27
Oracle Balanced Scorecard
Balanced View of Measures of Government
Performance
28
Public Sector e-Business Architecture
Administrator Portal
Citizen Portal
29
Oracle Public Sector IntelligenceOverview
30
Oracle Solutions e-Government Intelligence
  • Provide Tools and Applications that are
  • Complete
  • Integrated
  • Scaleable
  • High Availability
  • Secure
  • Standards based

31
Data Warehousing andOrganizational Intelligence
?
Cobol or NATURAL Application
Ad Hoc Query
Treehouse Software
OLAP
ADABAS
Data Mining
RDBMS
Data Warehouse
Intelligence
Transactional Data Applications
32
Oracle9i Business Intelligence Platform
  • Single business intelligence platform
  • Reduce administration and implementation costs
  • Faster deployment
  • Improved scalability and reliability

33
(No Transcript)
34
(No Transcript)
35
Platform for Business Intelligence ETL
Oracle9i
36
Platform for BI OLAP
Oracle9i
37
Platform for Organizational IntelligenceData
Mining
Oracle9i
38
Platform for Organizational IntelligenceData
Warehousing
Oracle9i
39
Oracle Organizational IntelligenceSummary
  • Provide Organizational Intelligence
  • Technology and Applications
  • that are
  • Complete
  • Integrated
  • Scaleable
  • High Availability
  • Secure
  • Standards based

40
Why Should You Take Action?
  • Leverage your operating data in ADABAS with
    Oracles e-Business and Business Intelligence
    solutions
  • Offers both ETL and CDC capabilities to migrate
    and/or propagate ADABAS data without impacting
    performance
  • Capability to add new and powerful applications
    that can coexist with your current operating
    environment

41
Q

A
Q U E S T I O N S
A N S W E R S
42
Contact Information
  • To schedule an on site appointment, call
  • Mitch Doricich
  • National Sales Manager, Treehouse Software
  • (412) 741-1677 ext.226
  • mdoricich_at_treehouse.com
Write a Comment
User Comments (0)
About PowerShow.com