{"id":2167,"date":"2023-08-08T00:11:20","date_gmt":"2023-08-07T18:41:20","guid":{"rendered":"http:\/\/sites.iitgn.ac.in\/digitalstudies\/?page_id=2167"},"modified":"2024-07-11T02:44:54","modified_gmt":"2024-07-10T21:14:54","slug":"ruthvik","status":"publish","type":"page","link":"http:\/\/sites.iitgn.ac.in\/digitalstudies\/ruthvik\/","title":{"rendered":"Ruthvik"},"content":{"rendered":"<p style=\"text-align: center;\"><strong>Database Management Using Neo4j<\/strong><\/p>\n<p>Neo4j is a database management tool on the cloud. It is an automated, visualizable, graph\u00a0based tool that can process queries on complex connections with ease and speed. It stores the\u00a0properties as key-value pairs. We communicate with the database through queries written in a declarative language called Cipher. The tool is user friendly and visually intuitive to operate. It is\u00a0an open-source project created by Emil Eifrem in 2007 using Java.<\/p>\n<p>We, as a team of 12, built a telephone directory database using mySQL in the Databases course (CS 432) offered in Spring 2023 at IIT Gandhinagar, instructed by Prof. Mayank Singh.\u00a0This project is developed in Neo4j for the following demonstration.<\/p>\n<p>For instance, I have made a small dummy dataset of faculty, students and a few other details\u00a0and imported the csv files into Neo4j. I created and connected entity nodes. The tool organized\u00a0and visualized the data of the dataset like below.<\/p>\n<p><a href=\"http:\/\/sites.iitgn.ac.in\/digitalstudies\/ruthvik\/r1\/\" rel=\"attachment wp-att-2168\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-2168\" src=\"http:\/\/sites.iitgn.ac.in\/digitalstudies\/wp-content\/uploads\/2023\/08\/R1.jpg\" alt=\"\" width=\"1192\" height=\"575\" srcset=\"http:\/\/sites.iitgn.ac.in\/digitalstudies\/wp-content\/uploads\/2023\/08\/R1.jpg 1192w, http:\/\/sites.iitgn.ac.in\/digitalstudies\/wp-content\/uploads\/2023\/08\/R1-300x145.jpg 300w, http:\/\/sites.iitgn.ac.in\/digitalstudies\/wp-content\/uploads\/2023\/08\/R1-768x370.jpg 768w, http:\/\/sites.iitgn.ac.in\/digitalstudies\/wp-content\/uploads\/2023\/08\/R1-1024x494.jpg 1024w\" sizes=\"(max-width: 1192px) 100vw, 1192px\" \/><\/a><\/p>\n<p>The Cipher queries are intuitive and easy to follow. \u2018()\u2019 would contain an entity and \u2018[]\u2019 would\u00a0describe the relation type between the entities attached with arrows \u2018\u2192\u2019<\/p>\n<p>Simple queries like:<br \/>\nmatch (x:Faculty)-[:belongs]-&gt;(y:Department)<br \/>\nwhere y.dept_name=&#8217;Humanities and Social Sciences&#8217;<br \/>\nreturn x<\/p>\n<p>returns us all the faculty members from the HSS department as shown below:<\/p>\n<p><a href=\"http:\/\/sites.iitgn.ac.in\/digitalstudies\/ruthvik\/r2\/\" rel=\"attachment wp-att-2169\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-2169 aligncenter\" src=\"http:\/\/sites.iitgn.ac.in\/digitalstudies\/wp-content\/uploads\/2023\/08\/R2.jpg\" alt=\"\" width=\"643\" height=\"492\" srcset=\"http:\/\/sites.iitgn.ac.in\/digitalstudies\/wp-content\/uploads\/2023\/08\/R2.jpg 643w, http:\/\/sites.iitgn.ac.in\/digitalstudies\/wp-content\/uploads\/2023\/08\/R2-300x230.jpg 300w, http:\/\/sites.iitgn.ac.in\/digitalstudies\/wp-content\/uploads\/2023\/08\/R2-263x200.jpg 263w\" sizes=\"(max-width: 643px) 100vw, 643px\" \/><\/a><br \/>\nOne can add, edit, delete entries in the database like any other database management system.\u00a0I have used variables in the queries to easily refer to them, used constraints on attributes like\u00a0IDs to be unique, and set the size and shade of some nodes to vary based on attributes like salary and experience, easily without needing much prior database concepts.<\/p>\n<p>The tool can take care of heavy datasets, complex queries, and data-based customizable\u00a0visualizations. This is a widely used tool by leading organizations both in government and\u00a0private sectors. This database tool, like some others freely available on the internet, is a good platform to look up to for database management applications.<\/p>\n<p><strong>References:<\/strong><\/p>\n<p>Neo4j platform has tutorials and good documentation about the tool:\u00a0https:\/\/neo4j.com\/cloud\/platform\/aura-graph-database\/?ref=nav-get-started-cta.<\/p>\n<p>Neo4j in 100 Seconds, Fireship, Youtube:\u00a0https:\/\/www.youtube.com\/watch?v=T6L9EoBy8Zk.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Database Management Using Neo4j Neo4j is a database management tool on the cloud. It is an automated, visualizable, graph\u00a0based tool that can process queries on complex connections with ease and speed. It stores the\u00a0properties as key-value pairs. We communicate with the database through queries written [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-2167","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/sites.iitgn.ac.in\/digitalstudies\/wp-json\/wp\/v2\/pages\/2167"}],"collection":[{"href":"http:\/\/sites.iitgn.ac.in\/digitalstudies\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/sites.iitgn.ac.in\/digitalstudies\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/sites.iitgn.ac.in\/digitalstudies\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"http:\/\/sites.iitgn.ac.in\/digitalstudies\/wp-json\/wp\/v2\/comments?post=2167"}],"version-history":[{"count":4,"href":"http:\/\/sites.iitgn.ac.in\/digitalstudies\/wp-json\/wp\/v2\/pages\/2167\/revisions"}],"predecessor-version":[{"id":2640,"href":"http:\/\/sites.iitgn.ac.in\/digitalstudies\/wp-json\/wp\/v2\/pages\/2167\/revisions\/2640"}],"wp:attachment":[{"href":"http:\/\/sites.iitgn.ac.in\/digitalstudies\/wp-json\/wp\/v2\/media?parent=2167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}