\n","children":[{"type":"text","text":""}]},{"type":"p","children":[{"type":"text","text":"At Relational AI, we have built the first Relational Knowledge Graph System\n(RKGS)."}]},{"type":"p","children":[{"type":"text","text":"We believe relational knowledge graphs are the foundation for data-centric\napplications - these are systems that learn, reason, and predict over richly\ninterconnected data."}]},{"type":"h3","children":[{"type":"text","text":"Why Relational?"}],"id":"why-relational"},{"type":"p","children":[{"type":"text","text":"In some of our other posts we discuss where we are today and where we will be in\nthe future. In this post we look at the historical trends that we have witnessed\nthat support our belief in the Relational paradigm and that a relational\nknowledge graph management system is history repeating itself . . . again!"}]},{"type":"p","children":[{"type":"img","url":"https://assets.tina.io/91d76337-e55d-4722-acb5-3106adb895b6/blog/relational-paradigm/data-history.png","alt":"RelationalAI - History of Data","caption":null,"children":[{"type":"text","text":""}]}]},{"type":"p","children":[{"type":"text","text":"Let’s revisit this history and trends. It’s been said often that data is growing\nin velocity, variety, and veracity; starting with structured, adding semi\nstructured, and most recently complex (unstructured for SQL). But this data\ngrowth is part of the back story."}]},{"type":"p","children":[{"type":"text","text":"We see everytime that data has hit a growth spurt (volume) or new types have\narisen (variety), the data model and approach to handle it has left relational\nfaltering and a new temporary paradigm comes along."}]},{"type":"p","children":[{"type":"text","text":"However, once the relational paradigm catches up, it replaces these temporary\nworkarounds and creates new multi-Billion dollar industries."}]},{"type":"p","children":[{"type":"img","url":"https://assets.tina.io/91d76337-e55d-4722-acb5-3106adb895b6/blog/relational-paradigm/data-datamodel-paradigm-history.png","alt":"RelationalAI - History of Data, Data Model, and Paradigm","caption":null,"children":[{"type":"text","text":""}]}]},{"type":"p","children":[{"type":"text","text":"The relational paradigm always wins."}]},{"type":"p","children":[{"type":"text","text":"It wins because it separates the WHAT from the HOW. And it wins when the hard\nparts that the patch solutions work around become part of the relational\nparadigm."}]},{"type":"p","children":[{"type":"text","text":"WHY? Because of the following features:"}]},{"type":"ul","children":[{"type":"li","children":[{"type":"lic","children":[{"type":"text","text":"Automatic query optimization: Cost estimation for operator ordering, join\nalgorithm, join order and index/data-structure selection"}]}]},{"type":"li","children":[{"type":"lic","children":[{"type":"text","text":"Automatic memory management: Garbage collection & Out of core support"}]}]},{"type":"li","children":[{"type":"lic","children":[{"type":"text","text":"Automatic parallelization & acceleration: Vectorization and compilation.\nShared memory, distributed shared memory, shared storage, shared nothing.\nMulti-core, GPU"}]}]},{"type":"li","children":[{"type":"lic","children":[{"type":"text","text":"Automatic transaction management: Atomic, Concurrent, Isolated, Durable (ACID)\nguarantees"}]}]},{"type":"li","children":[{"type":"lic","children":[{"type":"text","text":"Automatic incrementalization, liveness, and streaming"}]}]}]},{"type":"p","children":[{"type":"text","text":"WHEN these hard parts become part of the relational paradigm!"}]},{"type":"ul","children":[{"type":"li","children":[{"type":"lic","children":[{"type":"text","text":"New data structures (e.g. columnar storage, bitmap indices, semi-structured\ndata)"}]}]},{"type":"li","children":[{"type":"lic","children":[{"type":"text","text":"Query evaluation algorithms (e.g. parallel joins)"}]}]},{"type":"li","children":[{"type":"lic","children":[{"type":"text","text":"Query optimization technology (e.g. cost-based optimizers)"}]}]},{"type":"li","children":[{"type":"lic","children":[{"type":"text","text":"Query language innovations (e.g. stored procedures, recursive queries,\nmaterialized views)"}]}]}]},{"type":"p","children":[{"type":"text","text":"For example, the Map-reduce and NoSQL movements emerged because relational\nsystems couldn’t hack the new “web-scale” workloads. Control had to be given\nback to the programmer in order to get “web-scale” performance and scalability.\nThis control came at a big cost. But when cloud-based DW systems showed they\ncould operate at “web-scale” and still deliver the benefits of SQL and near\nzero-management of a hosted solution, then relational reasserted itself as the\nparadigm preferred by business."}]},{"type":"blockquote","children":[{"type":"text","text":"The most important motivation for the research work that resulted in the\nrelational model was the objective of providing a sharp and clear boundary\nbetween the logical and physical aspects of database management. - >\n"},{"type":"a","url":"https://libquotes.com/e-f-codd/quote/lbt1b0z","title":null,"children":[{"type":"text","text":"E. F. Codd"}]}]},{"type":"p","children":[{"type":"text","text":"You get to take advantage of all the investment (time/money) that has gone into\nthe relational paradigm, which is considerable and impactful, and delivers\nefficiency and scale."}]},{"type":"p","children":[{"type":"text","text":"We believe that Relational Knowledge Graphs are the foundation of modern Data\nApps and Machine Learning."}]},{"type":"p","children":[{"type":"img","url":"https://assets.tina.io/91d76337-e55d-4722-acb5-3106adb895b6/blog/relational-paradigm/data-historical-trends.png","alt":"RelationalAI - Historical Trends","caption":null,"children":[{"type":"text","text":""}]}]},{"type":"p","children":[{"type":"text","text":"And we believe the relational paradigm will win again."}]},{"type":"p","children":[{"type":"text","text":"This time, not only has the Relational technology caught up, but the underlying\nrelational math is a natural fit for machine learning (ML) algorithms. It\nfinally makes sense to build the ML directly into the relational database and to\neliminate hybrid ML/SQL approaches."}]},{"type":"p","children":[{"type":"text","text":"Thank you for reading this post on the history of relational paradigm. If you\nwould like to learn more, "},{"type":"a","url":"/contact-us","title":null,"children":[{"type":"text","text":"Contact Us"}]},{"type":"text","text":"."}]}],"_content_source":{"queryId":"src/content/resources/relational-paradigm.mdx","path":["resource","body"]}},"_content_source":{"queryId":"src/content/resources/relational-paradigm.mdx","path":["resource"]}}},"errors":null,"query":"\n query resource($relativePath: String!) {\n resource(relativePath: $relativePath) {\n ... on Document {\n _sys {\n filename\n basename\n breadcrumbs\n path\n relativePath\n extension\n }\n id\n }\n ...ResourceParts\n }\n}\n \n fragment ResourceParts on Resource {\n __typename\n title\n description\n date\n image\n categories\n authors {\n __typename\n name\n link\n }\n seo {\n __typename\n keywords\n description\n image\n image_alt\n canonical_url\n author\n published\n modified\n language\n robots\n site_name\n content_type\n }\n body\n}\n ","variables":{"relativePath":"relational-paradigm.mdx"}},"src/content/meta/meta.md":{"data":{"meta":{"_sys":{"filename":"meta","basename":"meta.md","breadcrumbs":["meta"],"path":"src/content/meta/meta.md","relativePath":"meta.md","extension":".md"},"id":"src/content/meta/meta.md","__typename":"Meta","banner":{"__typename":"MetaBanner","enabled":true,"content":{"type":"root","children":[{"type":"p","children":[{"type":"text","text":"Check out "},{"type":"a","url":"/resources/highlights-of-relationalai-at-snowflake-data-cloud-summit-2024","title":"SF summit highlights","children":[{"type":"text","text":"highlights"}]},{"type":"text","text":" of RelationalAI at "},{"type":"text","text":"Snowflake's Data Cloud Summit 2024!","bold":true}]}],"_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","banner","content"]}},"_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","banner"]}},"header":{"__typename":"MetaHeader","links":[{"__typename":"MetaHeaderLinks","text":"Product","url":"/product","style":"default","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","header","links",0]}},{"__typename":"MetaHeaderLinks","text":"Company","url":"/company","style":"default","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","header","links",1]}},{"__typename":"MetaHeaderLinks","text":"Docs","url":"/docs","style":"default","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","header","links",2]}},{"__typename":"MetaHeaderLinks","text":"Resources","url":"/resources/all/1","style":"default","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","header","links",3]}},{"__typename":"MetaHeaderLinks","text":"Get Started","url":"/get-started","style":"cta","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","header","links",4]}}],"_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","header"]}},"footer":{"__typename":"MetaFooter","sections":[{"__typename":"MetaFooterSections","name":"Product","links":[{"__typename":"MetaFooterSectionsLinks","text":"Overview","url":"/product","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer","sections",0,"links",0]}},{"__typename":"MetaFooterSectionsLinks","text":"Use Cases","url":"/product#for-problems-that-matter","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer","sections",0,"links",1]}},{"__typename":"MetaFooterSectionsLinks","text":"Capabilities","url":"/product#a-new-toolset","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer","sections",0,"links",2]}}],"_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer","sections",0]}},{"__typename":"MetaFooterSections","name":"Resources","links":[{"__typename":"MetaFooterSectionsLinks","text":"Documentation","url":"/docs/getting_started","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer","sections",1,"links",0]}},{"__typename":"MetaFooterSectionsLinks","text":"News","url":"/resources/news/1","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer","sections",1,"links",1]}},{"__typename":"MetaFooterSectionsLinks","text":"Research","url":"/resources/research/1","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer","sections",1,"links",2]}},{"__typename":"MetaFooterSectionsLinks","text":"Releases","url":"/resources/releases/1","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer","sections",1,"links",3]}}],"_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer","sections",1]}},{"__typename":"MetaFooterSections","name":"About Us","links":[{"__typename":"MetaFooterSectionsLinks","text":"Our Company","url":"/company","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer","sections",2,"links",0]}},{"__typename":"MetaFooterSectionsLinks","text":"Contact Us","url":"/get-started","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer","sections",2,"links",1]}},{"__typename":"MetaFooterSectionsLinks","text":"Careers","url":"/careers","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer","sections",2,"links",2]}},{"__typename":"MetaFooterSectionsLinks","text":"Legal","url":"/legal","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer","sections",2,"links",3]}},{"__typename":"MetaFooterSectionsLinks","text":"GDPR","url":"/gdpr","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer","sections",2,"links",4]}},{"__typename":"MetaFooterSectionsLinks","text":"Security & Trust","url":"https://trust.relational.ai/","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer","sections",2,"links",5]}}],"_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer","sections",2]}}],"socials":[{"__typename":"MetaFooterSocials","text":"GitHub","url":"https://github.com/RelationalAI","icon":"https://assets.tina.io/91d76337-e55d-4722-acb5-3106adb895b6/img/logos/github.png","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer","socials",0]}},{"__typename":"MetaFooterSocials","text":"LinkedIn","url":"https://www.linkedin.com/company/relationalai/about","icon":"https://assets.tina.io/91d76337-e55d-4722-acb5-3106adb895b6/img/logos/linkedin.png","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer","socials",1]}},{"__typename":"MetaFooterSocials","text":"Twitter","url":"https://twitter.com/relationalai","icon":"https://assets.tina.io/91d76337-e55d-4722-acb5-3106adb895b6/img/logos/twitter.png","_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer","socials",2]}}],"_content_source":{"queryId":"src/content/meta/meta.md","path":["meta","footer"]}},"_content_source":{"queryId":"src/content/meta/meta.md","path":["meta"]}}},"errors":null,"query":"\n query meta($relativePath: String!) {\n meta(relativePath: $relativePath) {\n ... on Document {\n _sys {\n filename\n basename\n breadcrumbs\n path\n relativePath\n extension\n }\n id\n }\n ...MetaParts\n }\n}\n \n fragment MetaParts on Meta {\n __typename\n banner {\n __typename\n enabled\n content\n }\n header {\n __typename\n links {\n __typename\n text\n url\n style\n }\n }\n footer {\n __typename\n sections {\n __typename\n name\n links {\n __typename\n text\n url\n }\n }\n socials {\n __typename\n text\n url\n icon\n }\n }\n}\n ","variables":{"relativePath":"./meta.md"}}};
globalThis.tina_info = tina;
})();
Relational Paradigm · RelationalAI
Check out highlights of RelationalAI at Snowflake's Data Cloud Summit 2024!
At Relational AI, we have built the first Relational Knowledge Graph System
(RKGS).
We believe relational knowledge graphs are the foundation for data-centric
applications - these are systems that learn, reason, and predict over richly
interconnected data.
Why Relational?
In some of our other posts we discuss where we are today and where we will be in
the future. In this post we look at the historical trends that we have witnessed
that support our belief in the Relational paradigm and that a relational
knowledge graph management system is history repeating itself . . . again!
Let’s revisit this history and trends. It’s been said often that data is growing
in velocity, variety, and veracity; starting with structured, adding semi
structured, and most recently complex (unstructured for SQL). But this data
growth is part of the back story.
We see everytime that data has hit a growth spurt (volume) or new types have
arisen (variety), the data model and approach to handle it has left relational
faltering and a new temporary paradigm comes along.
However, once the relational paradigm catches up, it replaces these temporary
workarounds and creates new multi-Billion dollar industries.
The relational paradigm always wins.
It wins because it separates the WHAT from the HOW. And it wins when the hard
parts that the patch solutions work around become part of the relational
paradigm.
WHY? Because of the following features:
Automatic query optimization: Cost estimation for operator ordering, join
algorithm, join order and index/data-structure selection
Automatic memory management: Garbage collection & Out of core support
Query language innovations (e.g. stored procedures, recursive queries,
materialized views)
For example, the Map-reduce and NoSQL movements emerged because relational
systems couldn’t hack the new “web-scale” workloads. Control had to be given
back to the programmer in order to get “web-scale” performance and scalability.
This control came at a big cost. But when cloud-based DW systems showed they
could operate at “web-scale” and still deliver the benefits of SQL and near
zero-management of a hosted solution, then relational reasserted itself as the
paradigm preferred by business.
The most important motivation for the research work that resulted in the
relational model was the objective of providing a sharp and clear boundary
between the logical and physical aspects of database management. - >
E. F. Codd
You get to take advantage of all the investment (time/money) that has gone into
the relational paradigm, which is considerable and impactful, and delivers
efficiency and scale.
We believe that Relational Knowledge Graphs are the foundation of modern Data
Apps and Machine Learning.
And we believe the relational paradigm will win again.
This time, not only has the Relational technology caught up, but the underlying
relational math is a natural fit for machine learning (ML) algorithms. It
finally makes sense to build the ML directly into the relational database and to
eliminate hybrid ML/SQL approaches.
Thank you for reading this post on the history of relational paradigm. If you
would like to learn more, Contact Us.