{"id":20365,"date":"2024-09-13T01:19:53","date_gmt":"2024-09-13T08:19:53","guid":{"rendered":"https:\/\/www.pingcap.com\/?post_type=case-study&#038;p=20365"},"modified":"2024-09-13T07:47:11","modified_gmt":"2024-09-13T14:47:11","slug":"how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration","status":"publish","type":"case-study","link":"https:\/\/www.pingcap.com\/ko\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/","title":{"rendered":"How a Leading DeFi Analytics Platform Achieved 40% Cost Reduction and Enhanced Agility with TiDB Integration"},"content":{"rendered":"<p><strong>Author<\/strong>: 0xfade, Head of Infra and Blockchain Development<\/p>\n\n\n\n<p><em>\u201c<a href=\"https:\/\/www.pingcap.com\/ko\/tidb-self-managed\/\">\ud2f0DB<\/a> has been a game-changer for our platform. We&#8217;ve cut operational costs by 40% while scaling seamlessly to handle growing Web3 data. Its real-time processing and simplified infrastructure have helped us innovate faster and deliver a better user experience.\u201d<\/em>                                               <em> \u2014 0xfade<\/em><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Executive_Summary\"><\/span><strong>Executive Summary<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>This case study explores how a leading decentralized finance (DeFi) analytics platform, leveraged TiDB to overcome scalability challenges and improve operational efficiency. By integrating TiDB, they achieved a 40% reduction in operation costs and query times while enhancing business agility.&nbsp;<\/p>\n\n\n\n<p>The transition to TiDB allowed seamless scaling to handle the growing Web3 data and provided real-time data processing for OLTP and OLAP queries. This shift simplified the platform&#8217;s technical architecture, enabling the company to enhance user experience and accelerate product innovation in the dynamic DeFi space.<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Company_Overview\"><\/span><strong>Company Overview<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The platform is a leading decentralized finance (DeFi) analytics provider that offers users comprehensive tools to manage, track, and optimize their DeFi investments. Launched in 2018, the platform aims to simplify the complexities of the DeFi ecosystem by providing a user-friendly interface and powerful features for tracking assets, yields, and protocols.<\/p>\n\n\n\n<p>The platform offers several key features to its users, including:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Portfolio Tracking<\/li>\n\n\n\n<li>DeFi Protocol Aggregation<\/li>\n\n\n\n<li>Yield Analysis<\/li>\n\n\n\n<li>Loan and Debt Tracking<\/li>\n\n\n\n<li>Cross-Chain Compatibility<\/li>\n\n\n\n<li>Security and Privacy<\/li>\n\n\n\n<li>Comprehensive Analytics<\/li>\n<\/ul>\n\n\n\n<p>These features allow users to manage and monitor all their DeFi investments from a single platform, saving time and reducing the complexity of managing assets across multiple services.<\/p>\n\n\n\n<p>As a vital tool for DeFi enthusiasts and investors, the platform contributes significantly to the growing adoption of decentralized finance by making it more accessible and manageable. Its focus on user experience and in-depth data analysis helps bridge the gap between complex DeFi protocols and everyday users.<\/p>\n\n\n\n<p>Overall, the platform plays a crucial role in the DeFi ecosystem by offering valuable tools and insights that empower users to navigate the rapidly evolving world of decentralized finance effectively.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Challenge_Scaling_and_Performance_Optimization_in_a_Growing_Web3_Platform\"><\/span><strong>Challenge<\/strong>: Scaling and Performance Optimization in a Growing Web3 Platform<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The platform&#8217;s primary challenge is developing a high-performance DeFi API and on-chain DeFi dataset SQL API that can handle real-time OLTP (Online Transaction Processing) and OLAP (Online Analytical Processing) queries to meet diverse needs. Their pivotal features\u2014the DeFi API and the on-chain DeFi dataset SQL API\u2014utilize different data stacks, including RDS for MySQL sharding and AnalyticalDB. The challenges they are facing include:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Lack of Scalability<\/strong>: With the surge in Web3 data volume and rapid user growth, the business plans to continually expand its operations to achieve a greater competitive edge. This will result in the ongoing growth of its data\u2014from a few terabytes to tens or even hundreds of terabytes and possibly reaching petabytes in the future. They aim to avoid making significant changes to the database infrastructure over the next five years. The platform faced challenges in scaling effectively, particularly during peak traffic periods.<\/li>\n\n\n\n<li><strong>Low Query Performance<\/strong>: Handling complex join queries with RDS for MySQL sharding proved inadequate for large Web3 data volumes. A system capable of executing extensive data queries with both speed and precision was crucial.<\/li>\n\n\n\n<li><strong>Complex operation<\/strong>: Managing multiple RDS for MySQL sharding clusters for the DeFi API and maintaining separate data copies in MySQL and AnalyticalDB for the DeFi dataset SQL API led to significant operational and development overhead. Balancing costs while maintaining high service levels became a critical challenge.<\/li>\n\n\n\n<li><strong>Low<\/strong> <strong>data flow efficiency\uff1a<\/strong>Originally, data analysis relied on AnalyticalDB, which brought more data processing time costs, and this is user-friendly to businesses.<\/li>\n\n\n\n<li><strong>Lack of Agility<\/strong>: As their business grew rapidly, the need to continuously upgrade their product to meet evolving demands became pressing. The current tech stack was insufficient to keep up with the fast-paced growth.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/static.pingcap.com\/files\/2024\/09\/13005954\/%E5%9B%BE%E7%89%87-1.png\" alt=\"\" class=\"wp-image-20380\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"The_Solution_Embracing_TiDB_a_Distributed_MySQL-Compatible_HTAP_Database\"><\/span><strong>The Solution: Embracing TiDB, a Distributed MySQL-Compatible HTAP Database<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To overcome the problem they were facing, the platform turned to TiDB for a long-term, all-in-one database solution that would provide a better user experience and accelerate their product upgrade.<\/p>\n\n\n\n<p>To meet business compliance requirements, migrating to AWS Cloud presented multiple challenges for the team. First, the existing tech stack lacked a fully compatible database solution after the migration. The team also sought this opportunity to upgrade and improve their tech architecture while aiming to reuse as much of the existing code as possible.<\/p>\n\n\n\n<p>In this situation, TiDB became the optimal choice. Its compatibility with the MySQL ecosystem made code modifications straightforward, allowing the original application framework and ORM to require minimal adjustments. The system could run smoothly on the new database with just a few tweaks.<\/p>\n\n\n\n<p>At the same time, the team was able to migrate the existing data using TiDB\u2019s official DM tool. This tool supports merging sharded tables into a single table, making the migration process easy and efficient.<\/p>\n\n\n\n<p>The cloud migration and database architecture upgrade were completed within two months. Ultimately, TiDB not only met the current business&#8217;s performance requirements but also supported the organization&#8217;s future growth needs through its scalability.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/static.pingcap.com\/files\/2024\/09\/13010032\/%E5%9B%BE%E7%89%87-2.png\" alt=\"\" class=\"wp-image-20382\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Benefits_of_migrating_to_TiDB\"><\/span><strong>Benefits of migrating to TiDB<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The platform\u2019s adoption of TiDB has improved its data management, particularly enhancing its Defi data API and SQL API services.<\/p>\n\n\n\n<p><strong>Key benefits include<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Enhanced Scalability<\/strong>: TiDB\u2019s distributed architecture allows the platform to seamlessly scale its database to handle the growing volume of Web3 data and increase user traffic, ensuring consistent performance even during peak periods.<\/li>\n\n\n\n<li><strong>Improved Data Querying<\/strong>: TiDB\u2019s support for OLTP and OLAP queries enables efficient processing of complex and large-scale data queries. This ensures that the platform can deliver real-time insights and precise data analytics, which are crucial for effective DeFi operations.<\/li>\n\n\n\n<li><strong>Cost Efficiency<\/strong>: By consolidating their data infrastructure into a single, unified system, the platform has reduced the need for multiple RDS for MySQL sharding clusters and duplicated data storage. This streamlining reduces operational costs and minimizes development overhead.<\/li>\n\n\n\n<li><strong>Real-Time Data Insights<\/strong>: Depending on TiDB&#8217;s <a href=\"https:\/\/www.pingcap.com\/ko\/blog\/htap-demystified-defining-modern-data-architecture-tidb\/\">HTAP<\/a> ability, the platform doesn&#8217;t need to process the data flow. This shortened their data analysis cycle and ensured the timeliness of data analysis.<\/li>\n\n\n\n<li><strong>Greater Agility<\/strong>: TiDB\u2019s flexibility and ease of use facilitate rapid updates and product enhancements, allowing the platform to quickly adapt to evolving market demands and continue innovating in the fast-paced DeFi space.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Conclusion\"><\/span><strong>Conclusion<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>By integrating TiDB, the platform successfully overcame its scalability and performance challenges, reducing operational costs by 40% and significantly improving business agility.&nbsp;<\/p>\n\n\n\n<p>TiDB&#8217;s distributed architecture allowed the platform to handle the growing volume of Web3 data and user traffic seamlessly while improving query performance for both OLTP and OLAP workloads. The transition streamlined the platform&#8217;s infrastructure, eliminating the need for multiple data stacks and reducing the complexity of managing large-scale DeFi data.&nbsp;<\/p>\n\n\n\n<p>With real-time data insights, enhanced scalability, and reduced operational overhead, the platform is now better positioned to innovate quickly and meet evolving market demands in the fast-paced DeFi industry.<\/p>","protected":false},"excerpt":{"rendered":"<p>Author: 0xfade, Head of Infra and Blockchain Development \u201cTiDB has been a game-changer for our platform. We&#8217;ve cut operational costs by 40% while scaling seamlessly to handle growing Web3 data. Its real-time processing and simplified infrastructure have helped us innovate faster and deliver a better user experience.\u201d \u2014 0xfade Executive Summary This case study explores [&hellip;]<\/p>\n","protected":false},"author":273,"featured_media":20387,"template":"","tags":[16,10,14,11,9,111],"customer":[285],"industry":[178],"class_list":["post-20365","case-study","type-case-study","status-publish","has-post-thumbnail","hentry","tag-distributed-system","tag-htap","tag-mysql","tag-real-time-analytics","tag-scalability","tag-tidb","customer-leading-defi-analytics-and-management-platform","industry-web3"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.9 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>DeFi Analytics Platform Cuts Cost and Enhances Agility with TiDB<\/title>\n<meta name=\"description\" content=\"How a leading DeFi analytics platform, leveraged TiDB to overcome scalability challenges and improve operational efficiency.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.pingcap.com\/ko\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"DeFi Analytics Platform Cuts Cost and Enhances Agility with TiDB\" \/>\n<meta property=\"og:description\" content=\"How a leading DeFi analytics platform, leveraged TiDB to overcome scalability challenges and improve operational efficiency.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/\" \/>\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-09-13T14:47:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2024\/09\/13010507\/20240913-160312.png\" \/>\n\t<meta property=\"og:image:width\" content=\"3125\" \/>\n\t<meta property=\"og:image:height\" content=\"1042\" \/>\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=\"6\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pingcap.com\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/\",\"url\":\"https:\/\/www.pingcap.com\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/\",\"name\":\"DeFi Analytics Platform Cuts Cost and Enhances Agility with TiDB\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2024\/09\/13010507\/20240913-160312.png\",\"datePublished\":\"2024-09-13T08:19:53+00:00\",\"dateModified\":\"2024-09-13T14:47:11+00:00\",\"description\":\"How a leading DeFi analytics platform, leveraged TiDB to overcome scalability challenges and improve operational efficiency.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/#primaryimage\",\"url\":\"https:\/\/static.pingcap.com\/files\/2024\/09\/13010507\/20240913-160312.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2024\/09\/13010507\/20240913-160312.png\",\"width\":3125,\"height\":1042},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pingcap.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Case Studies\",\"item\":\"https:\/\/www.pingcap.com\/customers\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How a Leading DeFi Analytics Platform Achieved 40% Cost Reduction and Enhanced Agility with TiDB Integration\"}]},{\"@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":"DeFi Analytics Platform Cuts Cost and Enhances Agility with TiDB","description":"How a leading DeFi analytics platform, leveraged TiDB to overcome scalability challenges and improve operational efficiency.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.pingcap.com\/ko\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/","og_locale":"ko_KR","og_type":"article","og_title":"DeFi Analytics Platform Cuts Cost and Enhances Agility with TiDB","og_description":"How a leading DeFi analytics platform, leveraged TiDB to overcome scalability challenges and improve operational efficiency.","og_url":"https:\/\/www.pingcap.com\/ko\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_modified_time":"2024-09-13T14:47:11+00:00","og_image":[{"width":3125,"height":1042,"url":"https:\/\/static.pingcap.com\/files\/2024\/09\/13010507\/20240913-160312.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@PingCAP","twitter_misc":{"Est. reading time":"6\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/","url":"https:\/\/www.pingcap.com\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/","name":"DeFi Analytics Platform Cuts Cost and Enhances Agility with TiDB","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pingcap.com\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/#primaryimage"},"image":{"@id":"https:\/\/www.pingcap.com\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2024\/09\/13010507\/20240913-160312.png","datePublished":"2024-09-13T08:19:53+00:00","dateModified":"2024-09-13T14:47:11+00:00","description":"How a leading DeFi analytics platform, leveraged TiDB to overcome scalability challenges and improve operational efficiency.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/#primaryimage","url":"https:\/\/static.pingcap.com\/files\/2024\/09\/13010507\/20240913-160312.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2024\/09\/13010507\/20240913-160312.png","width":3125,"height":1042},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pingcap.com\/"},{"@type":"ListItem","position":2,"name":"Case Studies","item":"https:\/\/www.pingcap.com\/customers\/"},{"@type":"ListItem","position":3,"name":"How a Leading DeFi Analytics Platform Achieved 40% Cost Reduction and Enhanced Agility with TiDB Integration"}]},{"@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=\"card-case-study\"><div class=\"card-case-study__image-container\"><img class=\"card-case-study__image\" alt=\"web3\" src=\"https:\/\/static.pingcap.com\/files\/2025\/04\/23062910\/web3.svg\" loading=\"lazy\" \/><\/div><span class=\"card-case-study__title\">How a Leading DeFi Analytics Platform Achieved 40% Cost Reduction and Enhanced Agility with TiDB Integration<\/span><div class=\"card-case-study__button\"><a class=\"button--secondary\" href=\"https:\/\/www.pingcap.com\/ko\/case-study\/how-a-leading-defi-analytics-platform-achieved-40-cost-reduction-and-enhanced-agility-with-tidb-integration\/\" target=\"_blank\">View Case Study<\/a><\/div><\/div>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/case-study\/20365","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/case-study"}],"about":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/types\/case-study"}],"author":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/users\/273"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media\/20387"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=20365"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/tags?post=20365"},{"taxonomy":"customer","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/customer?post=20365"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/industry?post=20365"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}