Creating a Property Graph on Oracle Database

Creating a Property Graph on Oracle Database

Oracle Database 12c now includes property graphs, a great feature to analyze relationships in your data, such as finding the most influential people in a social network or discovering patterns of fraud in financial transactions. 

 

Graph analysis can do things that the relational model can't do - or can't do without very complicated queries and expensive table joins.  For someone who has never touched a property graph before it can be a little intimidating to get started.  It doesn’t help that most examples seem to start big and kind of assume that you already know what you are doing.  So for the people who are interested in exploring the new property graph functionality of the Oracle Database but don’t have a clue how to get started I thought it would be helpful to put an example together that assumes you don’t know anything.

Vlamis Force Directed Graph Plugin

The Force Directed Graph plugin from Vlamis Software Solutions in collaboration with Oracle allows you to visualize your data by creating an interactive node and link diagram. Each node’s location is customizable and are held together by a simulated force. Nodes can be expanded or collapsed to show more data or hide unwanted data and the size of the node represents a customized measure. If you click and drag a node to a new location the remainder of the diagram reacts by redistributing other nodes to prevent overlap.

Force Directed Graph.png

Force Directed Graphs are effective at representing multi-level hierarchies and are highly engaging due to their initial “bounce and balance” effect. Nodes will display subordinate data if they are clicked and can be pinned to a customized location by clicking ad dragging. Examples of good use cases for this graph are: product hierarchies, field service organizations, and time hierarchies.

 

The Force Directed Graph Plugin is now live on the Oracle Analytics Library!

For more information visit our Force Directed Graph Plugin page!

We will continue to update this blog entry as information is available.

Join us for a Webcast on OAC 17.4.5!

January 16th at 12:00pm Central. Registration is now open!

Oracle Analytics Cloud (OAC) brings the power of Oracle BI to the Oracle Cloud, including the headline from Oracle OpenWorld: Machine Learning. See a live demonstration of OAC 17.4.5. OAC prior version customers: add Machine learning and lots of other new features. OBIEE (Oracle BI Enterprise Edition) customers: move your content to the Oracle cloud to save on administrative headache and add new features.

Join Dan Vlamis, Oracle ACE Director, and President of Vlamis Software Solutions, as he breaks down the exciting new features in OAC 17.4.5. Expect a fast-paced presentation with live demos of OAC, on as many of the new features as time allows. Features that debuted in Data Visualization 4 for Desktop are covered more fully in the November 9 webcast, but will be summarized. Just like our previous demonstrations of new BI releases (see www.vlamis.com/obiwebinars for a list), we will give a live demonstration of as many of these features as we have time for, including:

Recap of DV4 features shown on November 9:

  • New Home Page
  • New Visualization control experience
  • New Column controls for date/time, auto-binning
  • New narrate experience
  • New data flow steps, including create Essbase cube step
  • Machine learning

New OAC 17.4.5 features:

  • Data limit truncation warnings
  • Narrate enhancements for groups
  • Data flow enhancements
    • Sequences for Data flows
    • Data flow scheduling
    • Renaming steps
    • Create Essbase cube step
  • BI Publisher consuming XSAs
  • Essbase new features
  • Admin / Console new features
    • Content embedding
    • Data replication
    • Email deliverables
    • Map Viewer console
    • Import / export TCM models
  • Public API support

We will also include an update on the new Oracle Analytics Cloud Store, where you can download many additional visualizations and see additional demonstrations of Oracle BI technology.

Dates and content of webinar are subject to change.

Register.

Vlamis to Present at New York Oracle User Group December 2017

We're excited to announce that we have been selected to present "Data Visualization for Oracle BI 12c and Visual Analyzer" at the NYOUG 2017 Winter General Meeting on December 7th, 2017. This meeting will take place at the Borough of Manhattan Community College in New York, NY. We are very excited to be presenting at the NYOUG and hope that you will be able to join us. Let us know if you are planning to attend!

New York Oracle User Group Winter General Meeting
Borough of Manhattan Community College
199 Chambers St
New York, NY 10007

For more information on our presentation visit our papers page

Oracle Analytics Cloud (OAC 4) New Features Webcast December 19th at 12:00pm Central.

Registration is now open!

Oracle Analytics Cloud (OAC) brings the power of Oracle BI to the Oracle Cloud, including the headline from Oracle OpenWorld: Machine Learning. See a live demonstration of OAC 4. OAC prior version customers: add Machine learning and lots of other new features. BICS (BI Cloud Service) and DVCS (Data Visualization Cloud Service) customers: control your own instances and license Oracle Analytics software by the OCPU instead of having to license by user. OBIEE (Oracle BI Enterprise Edition) customers: move your content to the Oracle cloud to save on administrative headaches and add new features.

Join Dan Vlamis, Oracle ACE Director, and President of Vlamis Software Solutions, as he breaks down the exciting new features in OAC 4. Expect a fast-paced presentation with live demos of OAC, on as many of the new features as time allows. Features that debuted in Data Visualization 4 for Desktop were covered more fully in the November 9 webcast, but will be summarized. Just like our previous demonstrations of new BI releases (see www.vlamis.com/obiwebinars for a list), we will give a live demonstration of as many of these features as we have time for, including:

Recap of DV4 features shown on November 9:

  • New Home Page
  • New Visualization control experience
  • New Column controls for date/time, auto-binning
  • New narrate experience
  • New data flow steps, including create Essbase cube step
  • Machine learning

New OAC 4 features:

  • Data limit truncation warnings
  • Narrate enhancements for groups
  • Data flow enhancements
    • Sequences for Data flows
    • Data flow scheduling
    • Renaming steps
    • Create Essbase cube step
  • BI Publisher consuming XSAs
  • Essbase new features
  • Admin / Console new features
    • Content embedding
    • Data replication
    • Email deliverables
    • Map Viewer console
    • Import / export TCM models
  • Public API support

We will also include an update on the new Oracle Analytics Cloud Store, where you can download many additional visualizations and see additional demonstrations of Oracle BI technology.

Register now!