Open data api delivery open xdx
This presentation is the property of its rightful owner.
Sponsored Links
1 / 17

Open Data API delivery “Open-XDX” PowerPoint PPT Presentation


  • 52 Views
  • Uploaded on
  • Presentation posted in: General

O pen D ata E xchange. October, 2012. Open Data API delivery “Open-XDX”. David Webber, Information Architect, Oracle Public Sector.

Download Presentation

Open Data API delivery “Open-XDX”

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


Open data api delivery open xdx

Open

Data

Exchange

October, 2012

Open Data API delivery “Open-XDX”

David Webber, Information Architect, Oracle Public Sector


Open data api delivery open xdx

The following is intended to outline Oracle general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.

The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

DisclaimerNotice


Background

Background

"Open Data is the new default… anywhere, anytime on any device, and everything should be APIs"

Steven VanRoekel

Federal CIO – Whitehouse Digital Strategy Architect


Decoding the digital strategy

Decoding the Digital Strategy

  • What exactly are Open Data APIs?

  • How can Oracle solutions support them?

  • What does a solution architecture look like?


Open data apis explained

Open Data APIs explained

  • A way, via the internet, to securely deliver information between entities and systems

  • API – Application Programming Interface

  • Security is supported along with roles and permissions for requestors, e.g.

    • Public information – such as road works, health services, voting

    • Private information – patient data, student data, company data


Oracle open data solution open xdx

Oracle Open Data Solution – Open-XDX

  • Open-XDX is an all new component designed to deliver rapid Open Data APIs

  • Integrates into Oracle Fusion Middleware foundation and Database products

  • Uses XML configuration templates and code-less methods and open source NIEM tools

  • Allows plug-and-play delivery for Oracle customers and applications


Integration conceptual view open xdx deployment

Integration Conceptual ViewOpen XDX deployment

Data Delivery

Design

Test

Deploy

SQL

CAM Editor

DB

XML

Open XDX

Open XDX

FMW

SQL

XML

CAMV

  • Device

  • Browser

  • Server

Web

  • Generate Data

  • Validate Data

  • Send Data

  • Visual Editor

  • SQL Browser

  • Dictionaries

  • Drag and Drop

  • Open XDX

  • Web Services

  • FMW / BPM


Open data api delivery open xdx

Open XDX - Conceptual Overview

Data Exchange

Existing Information Databases

Control template contains information of the exchange structure design and DB mapping rules of data tables and columns

SQL

SQL

Template

JDBC connection

Rapid

Deploy

Structure

Open-XDX

Rules

Configuration

DB Mappings

Parameters

Send

Open Data XML


Open data api delivery open xdx

Option #1 – Visual Mapping Mode

Data Exchange Mapping

Data store connection wizard

XML structure viewer

Control template contains information of the exchange structure design and DB mapping rules of data tables and columns

Drag and Drop Mappings

Template

Structure

Rules

Store Configuration

Database schema viewer

DB Mappings

Parameters

  • Individual column assignments made as DB mapping rules to existing XML structure layout;

  • Original XML layout imported from industry schema (such as NIEM PMIX shown here)

Existing application SQL tables; e.g. Oracle Healthcare, E-Business Suite, custom system, etc.


Open data api delivery open xdx

Option #2 – Visual Designer Mode

Data Exchange Design

XML structure viewer

Drag and Drop Designer

EMPTY (Patient Report)

Database schema viewer

  • Start with new empty XML structure;

  • Toggle database viewer to designer mode.


Open data api delivery open xdx

Visual Designer Mode

Data Exchange Design

XML structure viewer

Control template contains information of the exchange structure design and DB mapping rules of data tables and columns

Drag and Drop Designer

Drag and Drop of Table

Template

Structure

Rules

Store Configuration

Database schema viewer

DB Mappings

Parameters

  • Drag and Drop table into XML structure

  • Complete XML structure components automatically inserted (with DBMappings);

  • All component names / definitions conform to NIEM NDR (smart rename wizard converts SQL to XML)


Open data api delivery open xdx

Demonstration – Open-XDX Data Generation

Oracle Tools

Data Exchange

SQL

2

XML Designer

Existing Information

Open-XDX

MySQL Workbench

1

Generate

Application Data Tables

Send

5 minutes from zero to LIVE data Demo

Open Data XML

3


Deployment usage scenarios

Deployment Usage Scenarios

  • Rapid prototyping of information exchange packages

  • Developing NIEM conformant exchange structures / dictionaries

  • Query / Response interfaces with filter parameters

  • Publish / Subscribe Daily or Hourly reporting

  • XML information structures conform to SQL database model

  • Limited number of SQL tables involved

  • SQL data model well behaved with primary indexes and foreign keys

  • Out of Scope

    • Highly complex reporting and data manipulation

    • Huge data volumes / massively high query rates per minute

    • Multiple sets of tables and relationships


Applicability to government challenges

Applicability to Government Challenges

  • Cost of building information exchanges

    • Reduction of development sunk costs through minimizing coding tasks

    • Allowing rapid prototyping and proof of concepts (agile development)

    • Flexibility - dynamic adaptable templates instead of rigid fixed code

    • Reuse – templates for common systems / solutions easily shared and adapted

  • Government transparency and public information sharing

    • Structured content from data stores – e.g. election results reporting, monthly cost reports, scheduled road maintenance; obvious metadata and semantics

    • Simple search requests on data – e.g. part numbers, codes, licenses lookup

    • Not intended for unstructured and textual content document delivery

  • Practical real world data sharing anywhere

    • Direct simple tool with short learning curve and plug and play deployment


Key technology capabilities

Key Technology Capabilities

  • Delivering on the Open Data Digital Strategy Vision for government

  • Open Standards and Open Source based

  • Plug and play with code-free templates and rapid development

  • Supports NIEM and Open XML exchanges

  • Leverages deployed technology today

  • Workflow integration

  • Secure messaging delivery and partner management

  • Delivered across-platform and device

  • End-to-end security & governance


Cameditor org project statistics

CAMeditor.ORG Project Statistics

  • SNAPSHOT OF PROJECT ACTIVITIES50,000+ CAMeditor.org page visits in one year

  • 130+ countries have downloaded tools;

  • 30% of visitors are from U.S.;

  • 400+ downloads weekly

  • 5 to 10 students use online video training resource weekly

  • 6 languages now available

www.cameditor.org

‹#›


  • Login