02 January 2013

Oracle OBIEE 11.1.5 extended with Oracle Endeca

Oracle Endeca Information Discovery is a data discovery platform that guides people to better decisions on diverse and changing data. It is based on a patented hybrid search-analytical database, and gives IT a centralized platform to rapidly deploy interactive analytic applications,

and keep pace with changing business requirements while maintaining information governance.

  •     Explore vast amounts of information from a variety of unstructured and structured data sources in one easy-to-use application
  •     Determine cross-channel behaviors with seasonality, location
  •     Monitor performance of digital merchandising strategies
  •     Drill in to customer sentiment via user generated content
  •     Ingest data from data warehouses, Web analytics, product management systems, social data, and more

The Sales Overview page provides a dashboard to view and explore overall sales figures.

To support an interactive user experience, the database must be able to process and respond to rapidfire queries in sub-second intervals. It should also be able to accommodate new data and changes to existing data with minimal rework. Oracle Endeca Server does this by providing:

  • Multicore query parallelism – increase scale and reduce latency with additional cores.
  • In-memory caching of frequently accessed working column segments and query results.
  • Per-attribute column storage: record order for value lookup, value order for range filters.
  • Full range of type-specific compression techniques including: Prefix, String Coding, Run Length, Delta, Variable Length Numeric Coding, etc.

Figure below demonstrates how the Oracle Endeca Server achieves these performance characteristics
through an intelligent use of CPU, memory and storage resources.

Scalability and performance characteristics of Oracle Endeca Server

Flexible Data Model

Oracle Endeca Server employs a unique flexible data model that reduces the need for up-front
modeling, enables the integration of diverse and changing data, and supports the broad exploration and analysis needs of business users.

Oracle Endeca Server's data model is based on the concept of "records". Roughly analogous to data
warehouse facts, each record consists of an arbitrary collection of attributes made up of key/value
pairs. These attributes can have a single value, multiple values, or a hierarchy of values based on an
external taxonomy definition. Values may be text of any length, numeric, date/time, geospatial, or

Importantly, Oracle Endeca Server does not employ an overarching schema for data. Instead, every
record has its own schema. This enables the rapid integration of any type of data, whether structured
or unstructured, from inside or beyond the confines of the enterprise data warehouse, without the efforts associated with traditional data modeling.

Created with Admarket's flickrSLiDR.

Overview video:

Endeca overview (before take over last year by Oracle):

Oracle Endeca overview:

Adding a Datasource:

Created with Admarket's flickrSLiDR.

Drs. Albert Spijkers
DBA Consulting
web: http://www.dbaconsulting.nl
blog: http://drsalbertspijkers.blogspot.com/
profile: http://nl.linkedin.com/pub/drs-albert-spijkers/13/b4a/7a8
Facebook : http://www.facebook.com/pages/DBA-Consulting/101640233252655
email: info@dbaconsulting.nl

1 comment:

  1. Studying this information So i happy to show that I have an incredibly just right uncanny feeling I found out just what I needed.Oracle Security