Databases Reference
In-Depth Information
Oracle GoldenGate
GoldenGate enables lightweight capture, routing, transformation, and delivery of
changed data among a variety of Oracle and non-Oracle databases in near real time.
The Capture software component resides on the source database or monitors JMS
messaging for changes. Trail Files containing changed data reside on the source or
target server. The Delivery Module takes changed data from the Trail Files and
applies it to the target database.
Business Intelligence Tools
Oracle data warehouses are often accessed using business intelligence tools from a va‐
riety of vendors. Usage of Oracle's own tools became more common for such deploy‐
ment as Oracle grew its offerings through acquisitions, replacing Oracle's earlier Dis‐
coverer and Reports products.
Oracle's flagship product in this area is Oracle Business Intelligence Foundation Suite,
consisting of former Siebel Analytics/Oracle Business Intelligence Enterprise Edition
and Hyperion Essbase components. The product has evolved into an integrated middle-
tier platform that features reporting, ad hoc query and analysis, dashboards, balanced
scorecard and strategy management, Office plug-ins, and mobile support.
Oracle also offers business intelligence applications that include data models and re‐
porting and analysis with pre-populated business metadata. Applications include Ora‐
cle's Business Intelligence Applications (the former Siebel Business Analytics applica‐
tions) and Hyperion Financial Performance Management applications.
Other business intelligence offerings include Endeca Information Discovery (EID) and
Real-Time Decisions (RTD). EID features a multifaceted server for data discovery that
provides multiple drill paths through structured and unstructured data without the need
to pre-define a schema. RTD is a real-time recommendation engine that can mine data
or use input from other data mining and statistics models in order to present best rec‐
ommendations to web interfaces and through applications.
WebCenter
The WebCenter Suite of products features WebCenter Portal and WebCenter Content.
WebCenter Portal is Oracle's enterprise portal framework based on the Oracle ADF and
used for creating dynamic portals, websites, composite applications, and mash-ups.
Social collaboration is enabled through services such as discussion forums, wikis, blogs,
RSS, tags, links, social networking, and activity streams.
WebCenter Content is a content management platform that provides version control,
security, indexing and search, metadata, a workflow engine, and replication. Capabilities
include content publishing, digital asset management, document imaging, records and
