{"id":17188,"date":"2023-11-02T22:23:07","date_gmt":"2023-11-03T05:23:07","guid":{"rendered":"https:\/\/www.pingcap.com\/?post_type=video&#038;p=17188"},"modified":"2024-10-15T21:54:30","modified_gmt":"2024-10-16T04:54:30","slug":"leveraging-tidb-to-support-multiple-data-models-at-pinterest","status":"publish","type":"video","link":"https:\/\/www.pingcap.com\/ko\/video\/leveraging-tidb-to-support-multiple-data-models-at-pinterest\/","title":{"rendered":"Leveraging TiDB to Support Multiple Data Models at Pinterest"},"content":{"rendered":"<h2 class=\"wp-block-heading\">Overview<\/h2>\n\n\n\n<p>Pinterest\u2019s Storage and Caching team owns a number of online services that help deliver value to users. However, to reduce the maintenance burden of running these services, the team decided to 1) replace HBase with TiDB database as the storage engine; and 2) build a flexible framework that proxies TiDB and can easily power the different data models users need. The team calls this framework <strong>Structured Data Store<\/strong> (SDS). <\/p>\n\n\n\n<p>In this session, Pinterest Staff Software Engineer Alberto Ordonez Pereira explores the composable architecture powering the SDS framework, how it can be used to support multiple data models on top of TiDB database, and how Pinterest actually uses it.<\/p>","protected":false},"template":"","categories":[199],"class_list":["post-17188","video","type-video","status-publish","hentry","category-customer-stories"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Leveraging TiDB to Support Multiple Data Models at Pinterest | TiDB<\/title>\n<meta name=\"description\" content=\"Explore how structured data store can be used to support multiple data models on top of TiDB database, and how Pinterest actually uses it.\" \/>\n<meta name=\"robots\" content=\"noindex, follow\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Leveraging TiDB to Support Multiple Data Models at Pinterest | TiDB\" \/>\n<meta property=\"og:description\" content=\"Explore how structured data store can be used to support multiple data models on top of TiDB database, and how Pinterest actually uses it.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/video\/leveraging-tidb-to-support-multiple-data-models-at-pinterest\/\" \/>\n<meta property=\"og:site_name\" content=\"TiDB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/pingcap2015\" \/>\n<meta property=\"article:modified_time\" content=\"2024-10-16T04:54:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2024\/09\/11005522\/Homepage-Ad.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1440\" \/>\n\t<meta property=\"og:image:height\" content=\"714\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pingcap.com\/video\/leveraging-tidb-to-support-multiple-data-models-at-pinterest\/\",\"url\":\"https:\/\/www.pingcap.com\/video\/leveraging-tidb-to-support-multiple-data-models-at-pinterest\/\",\"name\":\"Leveraging TiDB to Support Multiple Data Models at Pinterest | TiDB\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"datePublished\":\"2023-11-03T05:23:07+00:00\",\"dateModified\":\"2024-10-16T04:54:30+00:00\",\"description\":\"Explore how structured data store can be used to support multiple data models on top of TiDB database, and how Pinterest actually uses it.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/video\/leveraging-tidb-to-support-multiple-data-models-at-pinterest\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/video\/leveraging-tidb-to-support-multiple-data-models-at-pinterest\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/video\/leveraging-tidb-to-support-multiple-data-models-at-pinterest\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pingcap.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Video\",\"item\":\"https:\/\/www.pingcap.com\/videos\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Leveraging TiDB to Support Multiple Data Models at Pinterest\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.pingcap.com\/#website\",\"url\":\"https:\/\/www.pingcap.com\/\",\"name\":\"TiDB\",\"description\":\"TiDB | SQL at Scale\",\"publisher\":{\"@id\":\"https:\/\/www.pingcap.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.pingcap.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.pingcap.com\/#organization\",\"name\":\"PingCAP\",\"url\":\"https:\/\/www.pingcap.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png\",\"width\":811,\"height\":232,\"caption\":\"PingCAP\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/pingcap2015\",\"https:\/\/x.com\/PingCAP\",\"https:\/\/linkedin.com\/company\/pingcap\",\"https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Leveraging TiDB to Support Multiple Data Models at Pinterest | TiDB","description":"Explore how structured data store can be used to support multiple data models on top of TiDB database, and how Pinterest actually uses it.","robots":{"index":"noindex","follow":"follow"},"og_locale":"ko_KR","og_type":"article","og_title":"Leveraging TiDB to Support Multiple Data Models at Pinterest | TiDB","og_description":"Explore how structured data store can be used to support multiple data models on top of TiDB database, and how Pinterest actually uses it.","og_url":"https:\/\/www.pingcap.com\/ko\/video\/leveraging-tidb-to-support-multiple-data-models-at-pinterest\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_modified_time":"2024-10-16T04:54:30+00:00","og_image":[{"width":1440,"height":714,"url":"https:\/\/static.pingcap.com\/files\/2024\/09\/11005522\/Homepage-Ad.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@PingCAP","twitter_misc":{"Est. reading time":"1\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/video\/leveraging-tidb-to-support-multiple-data-models-at-pinterest\/","url":"https:\/\/www.pingcap.com\/video\/leveraging-tidb-to-support-multiple-data-models-at-pinterest\/","name":"Leveraging TiDB to Support Multiple Data Models at Pinterest | TiDB","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"datePublished":"2023-11-03T05:23:07+00:00","dateModified":"2024-10-16T04:54:30+00:00","description":"Explore how structured data store can be used to support multiple data models on top of TiDB database, and how Pinterest actually uses it.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/video\/leveraging-tidb-to-support-multiple-data-models-at-pinterest\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/video\/leveraging-tidb-to-support-multiple-data-models-at-pinterest\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/video\/leveraging-tidb-to-support-multiple-data-models-at-pinterest\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pingcap.com\/"},{"@type":"ListItem","position":2,"name":"Video","item":"https:\/\/www.pingcap.com\/videos\/"},{"@type":"ListItem","position":3,"name":"Leveraging TiDB to Support Multiple Data Models at Pinterest"}]},{"@type":"WebSite","@id":"https:\/\/www.pingcap.com\/#website","url":"https:\/\/www.pingcap.com\/","name":"\ud2f0DB","description":"TiDB | SQL at Scale","publisher":{"@id":"https:\/\/www.pingcap.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.pingcap.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ko-KR"},{"@type":"Organization","@id":"https:\/\/www.pingcap.com\/#organization","name":"PingCAP","url":"https:\/\/www.pingcap.com\/","logo":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/","url":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2021\/11\/pingcap-logo.png","width":811,"height":232,"caption":"PingCAP"},"image":{"@id":"https:\/\/www.pingcap.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/pingcap2015","https:\/\/x.com\/PingCAP","https:\/\/linkedin.com\/company\/pingcap","https:\/\/youtube.com\/channel\/UCuq4puT32DzHKT5rU1IZpIA"]}]}},"card_markup":"        <div class=\"block-columns__column wysiwyg\">                            <a class=\"block-columns__video-container ignore-link-styles\" href=\"https:\/\/www.pingcap.com\/ko\/video\/leveraging-tidb-to-support-multiple-data-models-at-pinterest\/\">                    <img class=\"block-columns__video-image\" alt=\"Alberto Ordonez Pereira\" src=\"https:\/\/static.pingcap.com\/files\/2023\/10\/23173907\/Alberto-Ordonez-Pereira.jpg\" loading=\"lazy\" width=960 height=540 \/><div class=\"play-video-overlay\"><svg width=\"45\" height=\"45\" viewbox=\"0 0 45 45\" fill=\"none\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" version=\"1.1\" xmlns:xlink=\"http:\/\/www.w3.org\/1999\/xlink\" xml:space=\"preserve\" x=\"0px\" y=\"0px\" class=\"play-video-overlay__play-icon\"><use xlink:href=\"#general-icon-play\"><\/use><\/svg><\/div>                <\/a>                        <div class=\"block-columns__video-title\">HTAP Summit 2023 Session Replay: Structured Data Store: Leveraging TiDB to Support Multiple Data Models at Pinterest<\/div>                    <\/div>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/video\/17188","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/video"}],"about":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/types\/video"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=17188"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/categories?post=17188"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}