Shulou(Shulou.com)05/31 Report--

This article mainly introduces the use of Neo4j in QlikView to deal with graphic data, the article is very detailed, has a certain reference value, interested friends must read it!

The graphic database uses a graph structure with nodes, edges and attributes to store and display the data. In many scenarios, we can use the graphic database to solve the corresponding problems. The following editor will explain how to use Neo4j to deal with graphic data in QlikView.

How to use Neo4j to deal with graphic data in QlikView

Neo4j is a high-performance NoSQL graphics database, and its functions and features are relatively mature and robust in the field of NoSQL. Neo4j is an open source Java-based project developed by Neo Technology. DBA can go to the company official website to read more about Neo4j, or you can refer to the ppt.

At present, there is a JDBC driver in Neo4j, so we can use QlikView's JDBC connector and Cypher query language (equivalent to Neo4j's SQL) to query graphic data efficiently. Because Cypher is quite different from the SQL language we are familiar with, be sure to read the technical documentation of Cypher before you start using Neo4j:

You can connect to the Neo4j drawing database with the following statement:

CUSTOM CONNECT TO "Provider=JDBCConnector_x64.dll;jdbc:neo4j://localhost:7474/?connector.driverClass=org.neo4j.jdbc.Driver;XUserId=MfJbFYD;XPassword=IYRXBVD;"

Some of the following statements are Cypher queries that I often use in QlikView:

1. Read the attributes of all nodes and some nodes:

SQL START n=node (*)

RETURN ID (n) as NodeID, n as NodeText, n. As NodeType, n.name? As NodeName, n.biography? As Biography, n.birthplace? As Birthplace, n.birthday? As Birthday, n.title? As MovieTitle, n.releaseDate? As ReleaseDate

2. Read the properties of all relationships and some relationships:

SQL START r=relationship (*)

RETURN ID (r) as RelID, r as RelText, r. As RelType

R.name? As RelName, type (r) as RelLabel

How to use Neo4j to deal with graphic data in QlikView

3. Read all paths (nodes and relationship sequences):

SQL START n=node (*)

MATCH n-[r]-> m

RETURN ID (r) as RelID, ID (n) as Node1_ID, Type (r) as Label, ID (m) as Node2_ID

Create an QlikView data model in the load script. As shown in the following figure, the Graph table needs a path (path)

The results can be displayed in an interactive QlikView analysis application, and you can use various UI elements to explore the relevant information in the graphic data. In the picture below, you can see all the relevant information in the Star Trek movie:

Google Chart API is used here to visualize the graphics, and we will use the cooler QlikView Extension Object in the next step.

Next, we will use QlikView's associated search function to search Captain Spock:

We will find all the actors who play Captain Spock and present their associated sub-graphics:

In addition, we can also do some business analysis, for example, we can create a chart to calculate the actors of each film and their average age when the film is released. On the far left is the youngest actor and the title of the movie:

I hope that some of the demonstrations above will give you some understanding of interactive analysis using graphical data, and how to connect the following elements, such as graphical data and relational data, NoSQL databases and BI,Java OSS and attributes.

The above is all the contents of this article entitled "how to use Neo4j to deal with graphic data in QlikView". Thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.