Data & Intelligence

Views in Denodo

abstract circuit networking blockchain concept background

Denodo Virtual DataPort tool can import data coming from different systems and with different structures or formats. To Retrieve Data from the source, views are created in Denodo.

I will be using an Oracle 11g data source to fetch the data here and Denodo Web Design studio to create views.

1.connecting Data Source

To Connect Data Source

“To know more about connecting different data sources with Denodo click here.”

So basically, There are two types of views available in Denodo.

  1. Base View
  2. Derived View

 

  1. Base View

To Create a base view, we will be selecting “create base view” in the data source. A list of all the Databases and Tables will appear on the screen.

  • We must select tables we want in our view.
  • We can also add a prefix in your view name like in Denodo standard prefix for a base view is ‘bv’.
  • Select the Database in which you are working in Denodo and select the path where you want to store your base view and then click on “create selected”.

2.creating Base View

 

Execution of Base view

  • To execute the base view, we need to click on the “Execute Panel” option present at the top of our base view.
  • An execute panel with a select query will appear. Click on Execute to retrieve view data from the data source.

3.execute Base View

Data Intelligence - The Future of Big Data
The Future of Big Data

With some guidance, you can craft a data platform that is right for your organization’s needs and gets the most return from your data capital.

Get the Guide

After execution, two tabs will appear “Result” and “Execution Trace”.

  • Data related to the view will be displayed in the Results tab.

4.bv Execution Results

  • Details of data coming from the data source, and in which view it is displayed will appear in Execution Trace.

5.bv Execution Trace

 

  1. Derived Views

The creation of derived views is based on relational algebra and involves the most common operations:

  • Selection and Projection
  • Union and Extended Union
  • Minus and Intersection
  • Join
  • Aggregation
  • Flatten

 

The creation of a derived view for an operation is almost identical for every operation, and we will do the same for the join operation.

In order to create a Join-derived view, we will use two base views.

  • Click on File -> New -> Join

6.join 1

  • As shown in the figure below, drag both Base views to the middle of the screen and connect them.

7.join 2

  • Connect Id’s and create a join condition for the derived view.

8.join 3

If you use clauses such as Where and Group By, you can also add conditions.

Save and Execute view just like the base view to see the results.

9.join 4

“For more details about Views in Denodo click here.”

 

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Ahmad Raza Kaliwala

Ahmad Raza Kaliwala is an Associate Technical Consultant at Perficient. He has over one year of experience in ETL Development and Testing. He has exposure to ETL tools like AWS Glue, SSIS, and Azure Data Factory.

More from this Author

Subscribe to the Weekly Blog Digest:

Sign Up
Follow Us
TwitterLinkedinFacebookYoutubeInstagram