{"title":"On efficiently storing huge property graphs in relational database management systems","authors":"Matthias Schmid","doi":"10.1145/3366030.3366046","DOIUrl":null,"url":null,"abstract":"Graph structured data can be found in an increasing amount of use-cases. While there exists a considerable number of solutions to store graphs in NoSQL databases, the combined storage of relationally stored data with huge graph structured data within the same relational database system is not well researched. We present a relational approach for storing and querying huge property graphs by combining NoSQL features, provided by nearly any state-of-the-art database system, and an adjacency table approach. Our approach is optimized for read-only queries but also performs well on update queries. Through an empirical evaluation we show that we achieve a 10 times higher throughput than previous works on a graph with up to 650 million edges. This way, we can use all the advantages of full-fledged relational database systems and seamlessly integrate classical relational data with graph-structured data in an efficient way.","PeriodicalId":446280,"journal":{"name":"Proceedings of the 21st International Conference on Information Integration and Web-based Applications & Services","volume":"1 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2019-12-02","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"4","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings of the 21st International Conference on Information Integration and Web-based Applications & Services","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1145/3366030.3366046","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}
引用次数: 4
Abstract
Graph structured data can be found in an increasing amount of use-cases. While there exists a considerable number of solutions to store graphs in NoSQL databases, the combined storage of relationally stored data with huge graph structured data within the same relational database system is not well researched. We present a relational approach for storing and querying huge property graphs by combining NoSQL features, provided by nearly any state-of-the-art database system, and an adjacency table approach. Our approach is optimized for read-only queries but also performs well on update queries. Through an empirical evaluation we show that we achieve a 10 times higher throughput than previous works on a graph with up to 650 million edges. This way, we can use all the advantages of full-fledged relational database systems and seamlessly integrate classical relational data with graph-structured data in an efficient way.