KùzuDB
KùzuDB
  • Видео 16
  • Просмотров 5 860
Turn your JSON data into a graph with Kùzu
Learn how to use Kùzu's JSON extension to transform JSON data into a graph. We demonstrate ingesting data from JSON files into Kùzu, querying nested JSON fields, and exporting query results to JSON. The example involves modeling patient records and medical conditions as a graphs. The use of `COPY FROM` for bulk ingestion, `LOAD FROM` to scan a subset or transform the data, and `COPY TO` to output Cypher query results to JSON files (including nested JSON fields), highlights the usability features of Kùzu when working with semi-structured data.
Code to reproduce the demo workflow: github.com/kuzudb/tutorials/tree/main/src/video_6
JSON extension docs: docs.kuzudb.com/extensions/json/
Find us at...
Просмотров: 277

Видео

Interoperability Features In Kùzu: Build a simple product recommendation system
Просмотров 241Месяц назад
This video showcases a demo on how to leverage Kùzu's seamless integration with the PyData ecosystem and its ability to handle diverse data formats, both upstream and downstream. ✅ We demonstrate Kùzu's interoperability features for a data science workflow, using a graph-based product recommendation system as an example. ✅ We show how to ingest data from various formats like Parquet and CSV int...
Deep Dive Into Kùzu Explorer
Просмотров 2642 месяца назад
In this video, we dive into Kùzu Explorer, a browser-based UI for the Kùzu graph database. The video covers launching Kùzu Explorer using Docker and Docker Compose, and we deep dive into its key panels: the shell, schema, import data and settings panels. We demonstrate how to import, query, and visualize data using these panels to their fullest capability. The tutorial covers an example financi...
Cypher vs SQL: When do you need graph querying & modeling?
Просмотров 4133 месяца назад
In this video, we'll cover the advantages of using graph databases and the Cypher query language for efficient data analysis using practical examples. We highlight the benefits of graph modeling, including handling dependencies between entities, traversing paths, and querying on patterns in data. Watch a comparison of Cypher vs. SQL, and understand the conciseness and efficiency of Cypher for c...
3 Ways to Interact with Kùzu: Using Python, Rust, CLI
Просмотров 2963 месяца назад
In this video, Prashanth Rao, AI Engineer at Kùzu Inc. discusses 3 ways to interact with Kùzu: the client API, the Command Line Interface (CLI), and the browser-based visual interface, Kùzu Explorer. Although Python and Rust were the language clients shown, Kùzu can be run using other language APIs too: Node.js, Java, C/C , and Go. The video clearly highlights the benefits of the each approach ...
Data Ingestion into Kùzu: Why you should use COPY FROM
Просмотров 2783 месяца назад
In this video, Prashanth Rao discusses the power of using the COPY FROM technique for data ingestion in Kùzu. COPY FROM is a powerful way to rapidly insert or ingest large amounts of data into Kùzu from a variety of sources, including files, subqueries and DataFrames. Once the data is ingested, learn how to run simple Cypher queries to analyze your graph data and visualize the graph in Kùzu Exp...
History of Graph Databases - Part 2
Просмотров 2534 месяца назад
This is the second part of Prof. Salihoğlu's video series on history of databases with graph-based models. This video covers 3 classes of systems: (i) document stores, such as MongoDB; (ii) RDF systems, such as Ontotext's GraphDB; and (iii) property graph systems, such as Kùzu and Neo4j. You will learn about how the birth of the world wide web lead to document-based datasets, which necessitated...
History of Graph Databases - Part 1
Просмотров 5094 месяца назад
With this first of two videos, Prof. Semih Salihoglu discusses the history of database systems based on graph-based data models. This is a fascinating history that includes many systems, from the very first database system in history called IDS, which was based on a model called the "network model" and to the modern property graph databases, such as Neo4j and Kùzu, from document stores, such as...
RDF - Part 2: RDF as knowledge representation and reasoning system
Просмотров 2184 месяца назад
Prof. Semih Salihoğlu discusses why Resource Description Framework (RDF) and the standards around it form a knowledge representation and reasoning (KRR) system, and how one can do automatic reasoning with these standards. He provides examples of reasoning one can do with RDF, RDFS, and OWL. He overviews KRR systems, which are the foundation of what is nowadays referred to as symbolic AI or "goo...
RDF - Part 1: What is Resource Description Framework, and its benefits?
Просмотров 3724 месяца назад
Prof. Salihoğlu explains the fundamentals of RDF, covering resources, URIs, literals, and (subject, predicate, object) triples, and how they form a graph with resources and literals represented as nodes and directed edges representing relationships between them. Prof. Semih Salihoğlu then highlights the advantages of using Resource Description Framework (RDF) as a data model for complex and irr...
Graph vs. Relational databases? When do you need a graph database?
Просмотров 6945 месяцев назад
Graph databases offer significant benefits for modeling complex and irregular domains, including the ability to express complex relationships between entities, and the flexibility in describing join sequences. They also excel at making it very natural and easy to ask recursive queries and handle entity-oriented business questions, and provide natural graph-specific metrics to answer such querie...
What Is A Graph Database? Common features of graph DBMSs.
Просмотров 1 тыс.5 месяцев назад
Join us as we dive into the fascinating world of graph databases with Semih Salihoğlu, an expert in the field! Discover the core features of graph database management systems and unlock their potential for your applications. If you're coming from the world of relational databases, we highly recommend you watch our next video in this series: ruclips.net/video/sr63gtm1-j8/видео.html Find us at: G...
Kùzu user meeting - February 27 2024
Просмотров 1898 месяцев назад
This is the recording of the fourth Kùzu user meeting. We discussed the new features from the v0.0.12 release up until the v0.2.0 release and talked about what's coming up in the next few releases. Attendees: Doug Fils, Jürgen Müller, Paco Nathan, Pratul Gupta, Tom Hutchinson, Zahidur Basher, Harish Butani, Semih Salihoğlu, , Xiyang Feng, Ziyi Chen, Prashanth Rao, Benjamin Winger, Chang Liu, Gu...
Kùzu user meeting - November 22 2023
Просмотров 30911 месяцев назад
This is the recording of the third Kùzu user meeting. We discussed the new features from the v0.0.7 release up until the v0.1.0 release and talked about what's coming up in the next few releases. Attendees: Alberto Aimi, Ashley Huo, Benjamin Winger, Chang Liu, Guodong jin, Jurgen Muller, Keenan Gugeler, Kebing Liu, Martin Sahlen, Prashanth Rao, Russel Liu, Saschamc Donald, Semih Salihoğlu, , Xi...
Kùzu user meeting - August 23 2023
Просмотров 210Год назад
Kùzu user meeting - August 23 2023
Kùzu user meeting - June 12 2023
Просмотров 325Год назад
Kùzu user meeting - June 12 2023

Комментарии

  • @chillbeach7322
    @chillbeach7322 Месяц назад

    Part 1, 2, and the segue to the potential of hybrid S+SAIS is brilliant! Thank you for this very valuable content!

  • @jpgarcia90
    @jpgarcia90 2 месяца назад

    Hi Prashanth, curious as to why the express server repo is pulling the server out of the explorer and not the other way around. Is it just that the server repo came up as an afterthought?

    • @semihsalihoglu
      @semihsalihoglu Месяц назад

      Hi @jpgarcia90. Sorry, we missed this comment. You're somewhat right. Our engineer building Explorer, built Explorer first and then published API server by writing a script to remove files form Explorer. We might refactor this at some point to do it the other way around.

  • @DearGeorge3
    @DearGeorge3 3 месяца назад

    Thanks! Why kuzu doesn't have native API, like cursors for node tables, for fetching and updating or deleting links 'in place' via node references, etc.? This would increase performance in Python by 10 times or more by eliminating the need to create and decode queries, planning (it just direct call few C++ already existing code lines) and would significantly simplify programming in most scenarios. Cypher is great, but native API has superiority in speed and conciseness.

    • @KuzuDB
      @KuzuDB 3 месяца назад

      Hi @DearGeorge3, thanks for checking out the video! There are a few reasons why we think updates/deletion with a native API is unlikely to be faster than Cypher. 1. Kùzu is not an in-memory system (it is fully disk-based), so updating/deleting by cursor/pointer does not mean we can directly update the memory object that the cursor is pointing to - we'd still need to go through the same thing at the storage level. 2. The Python API in Kùzu is a simple wrapper over C++. We do not parse / decode / plan queries in Python at any stage, but rather simply pass the query string to the C++ layer that does planning, binding and execution, so querying your database from Python should basically be roughly as fast as querying from any other API. 3. Compared to query execution (which can get really expensive real quick), query planning is the faster operation, and any additional overheads in Python are likely to be negligible. Please join us in Discord to discuss more details if required, and cheers!

  • @NaveenSiddareddy
    @NaveenSiddareddy 3 месяца назад

    Thanks Prasanth, It would be nice to see the flip side of issuing queries like " give me all accounts or persons" how do we optimize those compared to SQL.

    • @KuzuDB
      @KuzuDB 3 месяца назад

      Hi Naveen, you can run aggregation queries in Cypher like you might do in SQL (avg, max, min with group bys), though in those cases, the benefit of Cypher is not as apparent. SQL does the job great in those cases. Not to mention that analytical databases and query engines that implement SQL likely have many optimizations in place already for these use cases.

  • @staceyhorricks
    @staceyhorricks 3 месяца назад

    Excellent demo - thank you for breaking down the steps on graph/data visualization.

    • @KuzuDB
      @KuzuDB 3 месяца назад

      Thanks so much! We appreciate it. Let us know what other areas you might like covered.

  • @theseedship6147
    @theseedship6147 4 месяца назад

    Very interesting, thanks for sharing this ! I did not get exactly how OWL is usable (or not) at the moment with Kùzu ?

    • @semihsalihoglu
      @semihsalihoglu 4 месяца назад

      Thanks. You are right. You cannot use owl in Kuzu. To be clear. This first set of videos are not about discussing the features of Kuzu. They are intended for a broad audience who want to learn the fundamentals of main classes of graph databases.

    • @theseedship6147
      @theseedship6147 4 месяца назад

      @@semihsalihoglu thanks ! Is it something you may plan in a future release ? I'd really need to create ontologies also, with a unique tool...Then Sparql at some point also for a deepter semantic reasonning ?

    • @KuzuDB
      @KuzuDB 3 месяца назад

      @@theseedship6147 We are not planning on supporting SPARQL natively within Kùzu for now - however, we do offer an interface within Kùzu that allows you to ingest your RDF data (from turtle files) into Kùzu and then query it using Cypher. Please reach out to us on Discord if you want to learn more! docs.kuzudb.com/rdf-graphs/

  • @PannaLalBiswas
    @PannaLalBiswas 4 месяца назад

    Excellent

    • @KuzuDB
      @KuzuDB 3 месяца назад

      Thanks very much for the feedback!

  • @NaveenSiddareddy
    @NaveenSiddareddy 4 месяца назад

    Audio is good but could be better , it may be the room echo

    • @KuzuDB
      @KuzuDB 3 месяца назад

      Thanks for the feedback. We're working on improving each video as we go :)

  • @NaveenSiddareddy
    @NaveenSiddareddy 4 месяца назад

    Thank you! schema + data while writing and querying is definitely helpful

    • @KuzuDB
      @KuzuDB 3 месяца назад

      Thanks. Let us know what other areas are of interest to you.

    • @NaveenSiddareddy
      @NaveenSiddareddy 3 месяца назад

      @@KuzuDB ingests to graphs and events out of graph ( event listeners) helps integrate to existing systems

  • @mehmetdoe
    @mehmetdoe 5 месяцев назад

    Wow! Great explanation. I love using CozoDB and suggest it to everyone I meet, go Cozo!