{"id":"https://openalex.org/W2970492358","doi":"https://doi.org/10.14778/3352063.3352065","title":"Synergistic graph and SQL analytics inside IBM Db2","display_name":"Synergistic graph and SQL analytics inside IBM Db2","publication_year":2019,"publication_date":"2019-08-01","ids":{"openalex":"https://openalex.org/W2970492358","doi":"https://doi.org/10.14778/3352063.3352065","mag":"2970492358"},"language":"en","primary_location":{"id":"doi:10.14778/3352063.3352065","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3352063.3352065","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5090562336","display_name":"Yuanyuan Tian","orcid":"https://orcid.org/0000-0002-6835-8434"},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"Yuanyuan Tian","raw_affiliation_strings":["IBM Research"],"affiliations":[{"raw_affiliation_string":"IBM Research","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5052118000","display_name":"Wen Sun","orcid":"https://orcid.org/0000-0002-7268-2085"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Wen Sun","raw_affiliation_strings":["IBM Research"],"affiliations":[{"raw_affiliation_string":"IBM Research","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5018399308","display_name":"Sui Jun Tong","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Sui Jun Tong","raw_affiliation_strings":["IBM Research"],"affiliations":[{"raw_affiliation_string":"IBM Research","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5005238601","display_name":"En Liang Xu","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"En Liang Xu","raw_affiliation_strings":["IBM Research"],"affiliations":[{"raw_affiliation_string":"IBM Research","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5088562929","display_name":"Mir Hamid Pirahesh","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mir Hamid Pirahesh","raw_affiliation_strings":["IBM Research"],"affiliations":[{"raw_affiliation_string":"IBM Research","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5009415287","display_name":"Wei Zhao","orcid":"https://orcid.org/0000-0002-6686-3883"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Wei Zhao","raw_affiliation_strings":["IBM Research"],"affiliations":[{"raw_affiliation_string":"IBM Research","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":6,"corresponding_author_ids":["https://openalex.org/A5090562336"],"corresponding_institution_ids":[],"apc_list":null,"apc_paid":null,"fwci":0.2024,"has_fulltext":false,"cited_by_count":6,"citation_normalized_percentile":{"value":0.53674627,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":93,"max":96},"biblio":{"volume":"12","issue":"12","first_page":"1782","last_page":"1785"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T12292","display_name":"Graph Theory and Algorithms","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T12292","display_name":"Graph Theory and Algorithms","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1707","display_name":"Computer Vision and Pattern Recognition"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9988999962806702,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T10772","display_name":"Distributed systems and fault tolerance","score":0.9962999820709229,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.8247940540313721},{"id":"https://openalex.org/keywords/graph-database","display_name":"Graph database","score":0.7659012675285339},{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6815475225448608},{"id":"https://openalex.org/keywords/analytics","display_name":"Analytics","score":0.5411192178726196},{"id":"https://openalex.org/keywords/wait-for-graph","display_name":"Wait-for graph","score":0.4661729633808136},{"id":"https://openalex.org/keywords/ibm","display_name":"IBM","score":0.44591498374938965},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.4372386336326599},{"id":"https://openalex.org/keywords/graph","display_name":"Graph","score":0.4303928315639496},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.425870805978775},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.3831365406513214}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8247940540313721},{"id":"https://openalex.org/C176225458","wikidata":"https://www.wikidata.org/wiki/Q595971","display_name":"Graph database","level":3,"score":0.7659012675285339},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6815475225448608},{"id":"https://openalex.org/C79158427","wikidata":"https://www.wikidata.org/wiki/Q485396","display_name":"Analytics","level":2,"score":0.5411192178726196},{"id":"https://openalex.org/C106891557","wikidata":"https://www.wikidata.org/wiki/Q4148051","display_name":"Wait-for graph","level":4,"score":0.4661729633808136},{"id":"https://openalex.org/C70388272","wikidata":"https://www.wikidata.org/wiki/Q5968558","display_name":"IBM","level":2,"score":0.44591498374938965},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.4372386336326599},{"id":"https://openalex.org/C132525143","wikidata":"https://www.wikidata.org/wiki/Q141488","display_name":"Graph","level":2,"score":0.4303928315639496},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.425870805978775},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.3831365406513214},{"id":"https://openalex.org/C192562407","wikidata":"https://www.wikidata.org/wiki/Q228736","display_name":"Materials science","level":0,"score":0.0},{"id":"https://openalex.org/C171250308","wikidata":"https://www.wikidata.org/wiki/Q11468","display_name":"Nanotechnology","level":1,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.14778/3352063.3352065","is_oa":false,"landing_page_url":"https://doi.org/10.14778/3352063.3352065","pdf_url":null,"source":{"id":"https://openalex.org/S4210226185","display_name":"Proceedings of the VLDB Endowment","issn_l":"2150-8097","issn":["2150-8097"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319798","host_organization_name":"Association for Computing Machinery","host_organization_lineage":["https://openalex.org/P4310319798"],"host_organization_lineage_names":["Association for Computing Machinery"],"type":"journal"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Proceedings of the VLDB Endowment","raw_type":"journal-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Decent work and economic growth","id":"https://metadata.un.org/sdg/8","score":0.4099999964237213}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":3,"referenced_works":["https://openalex.org/W2033523472","https://openalex.org/W2580647187","https://openalex.org/W2798762352"],"related_works":["https://openalex.org/W2155593665","https://openalex.org/W2573939812","https://openalex.org/W2120098008","https://openalex.org/W2786902633","https://openalex.org/W2898886863","https://openalex.org/W1639806124","https://openalex.org/W2902831276","https://openalex.org/W3033305489","https://openalex.org/W2165259096","https://openalex.org/W4281562483"],"abstract_inverted_index":{"To":[0],"meet":[1],"the":[2,32,159,234],"challenge":[3],"of":[4,19,53,59,117,156,233],"analyzing":[5],"rapidly":[6],"growing":[7],"graph":[8,21,74,87,101,120,144,149,161,170,197,216,225,231,241,245,271],"and":[9,29,36,67,73,88,105,169,211,217,272],"network":[10],"data":[11,121,150,157,246],"created":[12],"by":[13],"modern":[14],"applications,":[15],"a":[16,115,176,185,204,224,230],"large":[17,154],"number":[18],"specialized":[20,160],"databases":[22,102],"have":[23],"emerged,":[24],"such":[25,184],"as":[26,114,141,203],"Neo4j,":[27],"JanusGraph,":[28],"Sqlg.":[30],"At":[31],"same":[33,177],"time,":[34],"RDBMSs":[35],"SQL":[37,72,89,168,218,273],"continue":[38],"to":[39,92,158,228,243,261,268],"support":[40,214,269],"mission-critical":[41],"business":[42],"analytics.":[43,54,69],"However,":[44],"real-life":[45],"analytical":[46,82],"applications":[47],"seldom":[48],"contain":[49],"only":[50],"one":[51,81],"type":[52],"They":[55],"are":[56,76,103,129,137],"often":[57],"made":[58],"heterogeneous":[60],"workloads,":[61],"including":[62],"SQL,":[63],"machine":[64],"learning,":[65],"graph,":[66],"other":[68],"In":[70,112,179],"particular,":[71],"analytics":[75,90,145,171,219,274],"usually":[77],"accompanied":[78],"together":[79],"in":[80,132,175,248],"workload.":[83],"This":[84,237],"means":[85],"that":[86],"need":[91],"be":[93,172],"synergistic":[94,215,270],"with":[95,109],"each":[96],"other.":[97],"Unfortunately,":[98],"most":[99],"existing":[100,244],"standalone":[104],"cannot":[106],"easily":[107],"integrate":[108],"relational":[110,133,148,235,249],"databases.":[111,162],"addition,":[113],"matter":[116],"fact,":[118],"many":[119],"(data":[122],"about":[123],"relationships":[124],"between":[125],"objects":[126],"or":[127],"people)":[128],"already":[130],"prevalent":[131],"databases,":[134],"although":[135],"they":[136],"not":[138],"explicitly":[139],"stored":[140,247],"graphs.":[142],"Performing":[143],"on":[146,256],"these":[147],"today":[151],"requires":[152],"exporting":[153],"amount":[155],"A":[163],"natural":[164],"question":[165],"arises:":[166],"can":[167,213],"performed":[173],"synergistically":[174],"system?":[178],"this":[180],"demo,":[181],"we":[182],"present":[183],"working":[186],"system":[187],"called":[188],"IBM":[189,209],"Db2":[190,192,221,264],"Graph.":[191],"Graph":[193,222,265],"is":[194,201,266],"an":[195,207,253],"in-DBMS":[196],"query":[198],"approach.":[199],"It":[200],"implemented":[202],"layer":[205],"inside":[206,275],"experimental":[208],"Db2\u2122,":[210],"thus":[212],"efficiently.":[220],"employs":[223],"overlay":[226],"approach":[227,238],"expose":[229],"view":[232],"data.":[236],"flexibly":[239],"retrofits":[240],"queries":[242],"tables.":[250],"We":[251],"use":[252],"example":[254],"scenario":[255],"health":[257],"insurance":[258],"claim":[259],"analysis":[260],"demonstrate":[262],"how":[263],"used":[267],"Db2.":[276]},"counts_by_year":[{"year":2024,"cited_by_count":2},{"year":2023,"cited_by_count":2},{"year":2021,"cited_by_count":2}],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}