Transcript Oracle Decision and Benfits

Rearchitecting an Internet
Delivery Platform on Oracle
How OneSource uses Oracle to Solve
the Problem of Combining Multiple
Content Types
Agenda






About OneSource
Technical Challenges
Our Solution
What this Enables
Where we are going
Conclusion
OneSource – who we are
 The leading provider of comprehensive
business information solutions
 In business since 1987
–
–
–
–
Spun out of Lotus in 1993
Public since 1999 (NASDAQ: ONES)
$57.8M in 2002, 11 profitable quarters
Locations in US, UK and Pacific Rim
 5 million reports/month to delivered to over 800 clients
 Information industry leader
–
First to deliver premier business intelligence over the
Internet (Business Browser )
Early integrator of business information within
CRM, portal, enterprise applications
At the forefront of XML innovation (active member of
XBRL consortium)
SM
–
–
"Business
information that
would have
taken weeks to
obtain can now
be found in
minutes."
– Jane Heath
Information Mgr
Aon Risk Services
What We Do – product
schematic
Combine
strengths of
all providers
2500
Content
Sources
•
•
•
•
•
•
•
Assess quality
Prioritize vendors
Apply GBT
Organize
Categorize
Normalize
Interconnect
Global
Business
Taxonomy
Enhanced Information
Warehouse
NEWS
INDUSTRY
EXECS
COMPANY
Synthesize
& analyze
information
Full-featured generalpurpose Web interface
Business
Browser
Intelligent
Information
Engine
Web interface
USERS
Synergy
Solutions
AppLink
SDK
Application
Integration
Services
Content
Optimization
Services
Portal CRM ERP
Organize and
enhance client
internal data
Advanced tools and services for
custom integration with enterprise
applications
High Level View
Content
Information
Refinement
Repository
OneSource
Framework
Solutions
Customers
Tree/Network/Graph
Text/Document
Many to Many
XML/Hierarchal
Many to One
Relational/Fielded
One to one
Content Type
Technical Challenge
C
re
as
Relationships
A
pa
om
try
us
ny
d
In
xe
E
cu
s
e
ew
tiv
N
Technical Challenge Continued
 Storage
 Search
–
–
Across all content types
Including calculations
on the fly
 Retrieval
–
–
For Presentation
XML
 Allow easy addition of
new content
 Abstract data model
away from
applications/Business
Services
 Large number of items
stored
–
3-5 million companies
(growing to 20)
 Hundreds to thousands of
attributes on each
–
–
12 million executives
(growing to 30)
20-40 million documents
Solution
 Metadata Driven Database
 Combine Relational Database with XML
 Create Abstraction for Queries based on
XPath
 Oracle Backend with .NET Applications
Metadata Driven
 Two levels
–
–
Data dictionary about content
Metadata associated with content
 Why important?
–
–
Allows new content to be added easily
Allows search and retrieval of metadata
 Date of change, units, source, attribute definition
Conceptual Model
Corporate Family/Relationship
Hierarchy
Location
Company
Employee
Line of
Business
Topic
Geography
News
Industry
Topic
Hierarchy
Topic
Person
Example of Conceptual Model
Peoplesoft
Event:
Tender Offer, $7.3 billion
Expiries Sept. 17th
Employee:
Board Member
Employee:
Larry Ellison CEO
Oracle
Employee:
Former Board Member
Left September 2002
Apple
Location:
Headquarters
Redwood
City, CA
Employee:
Board Member
Arthur Levinson
Corporate Family:
Past Subsidiary
Genentech
E-Travel, Inc
Event:
Sold, 2001, to Amadeus Global Travel
Data Model Overview
Source
Entity
Instance
Value
Attribute
Attribute
Source
Information
Combining Data Types
 Many Value Tables
–
–
Number, Money, Date, String
Text/Document, XML, XBRL
 Query Examples
–
–
Find Companies where sales > $1B and
company description contains “Software”
Find Companies with 25% annual sales growth
over the last year and has a news story that
contains “Footing” near “Cement”.
 SQL Queries become complex
Query Abstraction




Virtual XML document representing all content
Use XPath style query syntax abstraction above SQL
Transform XPath Syntax into PL/SQL
Examples:
–
–
–
Company[Employees > 10000 and Country/ISO2 = ‘US’]
Company[os:contains(BusinessDescription,
‘near(software,application))’ and AreaCode= ‘508’ and
Sales[@currency = ‘USD’] > 10000000 ]
Company[Parent/State = ‘MA’ and Sale[@currency =
‘USD’] > 10000000]
Oracle and .NET
 .NET front end using ODP.NET
–
–
–
Flexibility where we process (database, business service,
UI)
ODP.NET is full featured and performs well
Oracle has full support of .NET
 Common business service layer
 Allows multiple front-ends
–
–
–
Web subscription
SDK
Modules for third-party applications
What this Solution Enables
 Complex queries across all content types
–
Example: “Find all companies where there has been new
CFO, and revenue per employee greater than $500k, with
ultimate parent in CA”
 Storage of XML content natively (XBRL,
NewsML)
–
Detailed financial data integrated into 3rd party
applications via Web services
 Faster integration of new content
 Rapid deployment of new products