{"id":365,"date":"2019-10-24T02:09:37","date_gmt":"2019-10-24T02:09:37","guid":{"rendered":"http:\/\/www.juansequeda.com\/blog\/?p=365"},"modified":"2019-10-24T02:12:02","modified_gmt":"2019-10-24T02:12:02","slug":"a-pay-as-you-go-methodology-to-design-and-build-knowledge-graphs","status":"publish","type":"post","link":"https:\/\/www.juansequeda.com\/blog\/2019\/10\/24\/a-pay-as-you-go-methodology-to-design-and-build-knowledge-graphs\/","title":{"rendered":"A Pay-as-you-go Methodology to Design and Build Knowledge Graphs"},"content":{"rendered":"\n

At the 18th International Semantic Web Conference<\/a> I will be presenting our in-use paper:<\/p>\n\n\n\n

A Pay-as-you-go Methodology to Design and Build Enterprise Knowledge Graphs from Relational Databases<\/a><\/p>\n\n\n\n

Business users must answer business questions quickly to address Business Intelligence (BI) needs. The bottleneck is to understand the complex databases schemas. Only few people in the IT department truly understand them. A holy grail is to empower business users to ask and answer their own questions with minimal IT support. Semantic technologies, now dubbed as Knowledge Graphs, become useful here. Even though the research and industry community has provided evidence that semantic technologies works in the real world, our experience is that there continues to be a major challenge: the engineering of ontologies and mappings covering enterprise databases containing thousands of tables with tens of thousands of attributes. In this paper, we present a novel and unique pay-as-you-go methodology that addresses the aforementioned difficulties. We provide a case study with a large scale e-commerce company where Capsenta\u2019s Ultrawrap has been deployed in production for over 3 years.<\/em><\/p>\n\n\n\n

This is joint work with Will Briggs<\/a>, Daniel Miranker<\/a> and Wayne Heideman<\/a>. This paper documents our experience and lessons learned, while at Capsenta<\/a>, in order to design and build enterprise knowledge graphs from disparate and heterogeneous complex relational databases. <\/p>\n\n\n\n

The Problem<\/strong>: how do we get non-semantic aware folks to design and build ontologies and subsequently create mappings from the complex schemas of enterprise database (1000s of tables and 10000s of attributes) to the ontologies. <\/p>\n\n\n\n

Our answer<\/strong>: a methodology that combines ontologies and mappings, that is iterative, and focuses on answering business questions to avoid boiling the ocean.<\/p>\n\n\n\n

It is great to see how we are applying this methodology with our customers at data.world. <\/p>\n\n\n\n

Interested in learning more? Please read the paper<\/a>! Still have questions? Reach out to me!<\/p>\n\n\n\n

Finally, it is an amazing honor that this paper is nominated to best paper<\/em><\/strong>. We pride ourselves in striving for excellence. <\/p>\n","protected":false},"excerpt":{"rendered":"

At the 18th International Semantic Web Conference I will be presenting our in-use paper: A Pay-as-you-go Methodology to Design and Build Enterprise Knowledge Graphs from Relational Databases Business users must answer business questions quickly to address Business Intelligence (BI) needs. The bottleneck is to understand the complex databases schemas. Only few people in the IT … <\/p>\n

Continue reading “A Pay-as-you-go Methodology to Design and Build Knowledge Graphs”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-365","post","type-post","status-publish","format-standard","hentry","category-my-thoughts"],"yoast_head":"\nA Pay-as-you-go Methodology to Design and Build Knowledge Graphs - Juan Sequeda's Blog<\/title>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.juansequeda.com\/blog\/2019\/10\/24\/a-pay-as-you-go-methodology-to-design-and-build-knowledge-graphs\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"A Pay-as-you-go Methodology to Design and Build Knowledge Graphs - Juan Sequeda's Blog\" \/>\n<meta property=\"og:description\" content=\"At the 18th International Semantic Web Conference I will be presenting our in-use paper: A Pay-as-you-go Methodology to Design and Build Enterprise Knowledge Graphs from Relational Databases Business users must answer business questions quickly to address Business Intelligence (BI) needs. The bottleneck is to understand the complex databases schemas. Only few people in the IT … Continue reading "A Pay-as-you-go Methodology to Design and Build Knowledge Graphs"\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.juansequeda.com\/blog\/2019\/10\/24\/a-pay-as-you-go-methodology-to-design-and-build-knowledge-graphs\/\" \/>\n<meta property=\"og:site_name\" content=\"Juan Sequeda's Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-24T02:09:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-10-24T02:12:02+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.juansequeda.com\/blog\/#website\",\"url\":\"https:\/\/www.juansequeda.com\/blog\/\",\"name\":\"Juan Sequeda's Blog\",\"description\":\"Blog about Computer Science, Research, Knowledge Graphs, Semantic Web, Databases, Graphs and Travel!\",\"publisher\":{\"@id\":\"https:\/\/www.juansequeda.com\/blog\/#\/schema\/person\/11d82cc78d011661d7a9ace3be629323\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.juansequeda.com\/blog\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.juansequeda.com\/blog\/2019\/10\/24\/a-pay-as-you-go-methodology-to-design-and-build-knowledge-graphs\/#webpage\",\"url\":\"http:\/\/www.juansequeda.com\/blog\/2019\/10\/24\/a-pay-as-you-go-methodology-to-design-and-build-knowledge-graphs\/\",\"name\":\"A Pay-as-you-go Methodology to Design and Build Knowledge Graphs - Juan Sequeda's Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.juansequeda.com\/blog\/#website\"},\"datePublished\":\"2019-10-24T02:09:37+00:00\",\"dateModified\":\"2019-10-24T02:12:02+00:00\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.juansequeda.com\/blog\/2019\/10\/24\/a-pay-as-you-go-methodology-to-design-and-build-knowledge-graphs\/\"]}]},{\"@type\":\"Article\",\"@id\":\"http:\/\/www.juansequeda.com\/blog\/2019\/10\/24\/a-pay-as-you-go-methodology-to-design-and-build-knowledge-graphs\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/www.juansequeda.com\/blog\/2019\/10\/24\/a-pay-as-you-go-methodology-to-design-and-build-knowledge-graphs\/#webpage\"},\"author\":{\"@id\":\"https:\/\/www.juansequeda.com\/blog\/#\/schema\/person\/11d82cc78d011661d7a9ace3be629323\"},\"headline\":\"A Pay-as-you-go Methodology to Design and Build Knowledge Graphs\",\"datePublished\":\"2019-10-24T02:09:37+00:00\",\"dateModified\":\"2019-10-24T02:12:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/www.juansequeda.com\/blog\/2019\/10\/24\/a-pay-as-you-go-methodology-to-design-and-build-knowledge-graphs\/#webpage\"},\"commentCount\":2,\"publisher\":{\"@id\":\"https:\/\/www.juansequeda.com\/blog\/#\/schema\/person\/11d82cc78d011661d7a9ace3be629323\"},\"articleSection\":\"My Thoughts\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/www.juansequeda.com\/blog\/2019\/10\/24\/a-pay-as-you-go-methodology-to-design-and-build-knowledge-graphs\/#respond\"]}]},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.juansequeda.com\/blog\/#\/schema\/person\/11d82cc78d011661d7a9ace3be629323\",\"name\":\"Juan\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.juansequeda.com\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/bbfba6f29b3794e885f18fed1999917b8ac661fc907db094811b55ec455897d5?s=96&d=mm&r=g\",\"caption\":\"Juan\"},\"logo\":{\"@id\":\"https:\/\/www.juansequeda.com\/blog\/#personlogo\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/www.juansequeda.com\/blog\/wp-json\/wp\/v2\/posts\/365","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.juansequeda.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.juansequeda.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.juansequeda.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.juansequeda.com\/blog\/wp-json\/wp\/v2\/comments?post=365"}],"version-history":[{"count":5,"href":"https:\/\/www.juansequeda.com\/blog\/wp-json\/wp\/v2\/posts\/365\/revisions"}],"predecessor-version":[{"id":370,"href":"https:\/\/www.juansequeda.com\/blog\/wp-json\/wp\/v2\/posts\/365\/revisions\/370"}],"wp:attachment":[{"href":"https:\/\/www.juansequeda.com\/blog\/wp-json\/wp\/v2\/media?parent=365"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.juansequeda.com\/blog\/wp-json\/wp\/v2\/categories?post=365"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.juansequeda.com\/blog\/wp-json\/wp\/v2\/tags?post=365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}