Hi my name is Michael Schulman and I'm a product manager with Oracle No
SQL Database team. Oracle NoSQL database is a scalable distributed
database designed to provide highly reliable flexible and available data
management across a configurable set of storage nodes. Oracle NoSQL database
has meant for organizations that require very fast storage and retrieval of any
type of data. We do this by taking advantage of parallelism throughout the
entire system. What we want to demo for you today is how you can take data that
is in Oracle no database system combine it with other data in Oracle
database and even external files to get better insight into your sales process
or other types of data that you have. Take it away, Hema. Hello everyone, welcome
to the demo that shows integrating Oracle NoSQL database into data
visualization tools. The goal of this demo is to show how data from Oracle NoSQL
database can be joined with data from other data sources to generate
reports and dashboards using existing Oracle tools. In this demo, I use Oracle
data visualization desktop product to join data from three disparate data
sources. For relational store, I use Oracle RDBMS. For key value store, I used
Oracle NoSQL Database. For non database data,
I choose Excel spreadsheet. I use Oracle Big Data Lite VM to create and store
database tables. Though I use data visualization desktop product in this
demo, the same procedure can be applied to other visualization tools such as
Oracle Business Intelligence Enterprise Edition, also known as OBIEE.
Here is a typical customer scenario. The customer has an existing RDBMS table
that participates in reports and dashboards in data visualization tools
today. Given the variety of data in modern application, the customer adopts
polyglot solution and builds Oracle NoSQL database application. The
customer now wants to integrate this data into existing
tools. The problem is that the data is now into disparate data sources. One is
relational and the other is key-value and they need to be joined. The solution
we provide is to use Oracle Big Data SQL feature to connect Oracle NoSQL
database table to Oracle RDBMS, thus making the key value store data
available to the data visualization tools to the Oracle RDBMS connection
the customer already has. Steps 3 & 4 show how the solution is implemented and
step 5 shows a non database file participating in the reports. The first
step is to connect the relational data source to the visualization tool. The
customer usually has a relational data source added to the data visualization
desktop. In my case, I already created a RDBMS table called sales and made make
model and unit sold as part of the data visualization. Let me show you a bar
graph. For the second step, I have created a Oracle NoSQL Database
called vehicle table using the sample program that comes with the product. Now
that I have created a NoSQL vehicle table for step three I have connected
the Oracle NoSQL Database application to the oracle RDBMS. First, I
created a hive table using the hive external table interface in the Big Data
Lite VM and mapped it to the vehicle table through the hive table storage
handler. I use the properties to set the vehicle table to point to the KV
vehicle table in the oracle NoSQL Database. Next I create an Oracle RDBMS
vehicle table with organization set to external and of type Oracle hive and
make it point to the hive table. After these two simple steps, I have connected
the Oracle NoSQL Database application to the RDBMS engine.
Without the mappings complete, step four is to add the vehicle table as a data
source to the Oracle data visualization desktop tool. In the data visualization
canvas, I go and add the KV Store as a data store and I add it to the project.
As you can see, vehicle table which is a KV Store is now a data source and I pick
the column count and I add it to the visualization. Notice that out of the 246
Chrysler Aspen vehicles for sold and out of 256 for 155 sold and this
demonstrate that data from two different data sources are used in the report
generation. In the last part of the demo, I use a non Database file in my case an
Excel spreadsheet and show how it can participate in the report generation as
well. I go back to the canvas and add the data source and in this time I add a
file which is an Excel file and then I add that to the project. The information
that I am keying from this file is the promotion information and I add that to
the visualization. From the graph, you can tell that for Chrysler asked them for
three units promotions they replied and for Ford f-150 for five units that
which sold promotion was applied and say for example Chrysler journey or Chrysler
pacifica, there was no promotion that was applied.
The promotion information comes somewhere
yet another disparate data source which is an Excel file. That concludes our demonstration
where we have shown that data stored in Oracle NoSQL Database can
be integrated with other data sources to generate valued reports and charts using
existing Oracle software products. Thank you!