Task: Research Relational Databases vs. Graph Databases

Relational Databases

• Structure: Tables
• Relationships: High-level, formed between tables

Great for: transactional data, modeling hierarchies, repetitive data

Graph Databases

• Structure: Nodes and edges 
• Relationships: Low-level, formed between records

Great for: Flexible data, visualizations, large and complicated data sets

 

Task: Representation of the Gallery to Graph Model

 

Task: Create Queries: Find Paintings in Zone

Cypher Query Statement

MATCH

(z:Zone)-[:CONTAINS]->(p:Painting) 

RETURN p, z

 

 

 

 

 

 

Task: Create Queries: Find Zone Based on Location

 

Cypher Query Statement

MATCH

(n:Node)-[:IS_IN]->(z:Zone) 

WHERE n.id = 17 

RETURN n, z

 

 

 

 

Team Database Design: Next Steps

• Web Visualization
• Administration Tool
• Tracking Data Integration