<\/span>Changing demands in data processing<\/span><\/h2>\n\n\n\nAs the world is going deep in the digital transformation, the demands for data technologies are changing and more challenging. Today, businesses need to:<\/p>\n\n\n\n
\n- Rapidly process tremendous amounts of data in real time to keep its fresh value<\/li>\n\n\n\n
- Make all links of the business chain digital and data-driven<\/li>\n\n\n\n
- Rapidly derive insights from data in real time and translate these insights into commercial value<\/li>\n<\/ul>\n\n\n\n
<\/p>\n\n\n\n![\"\"](\"https:\/\/static.pingcap.com\/files\/2023\/04\/14002957\/image-31-1024x605.png\")
<\/figure>\n\n\n\nThe flow chart of data processing<\/em><\/p>\n\n\n\n<\/p>\n\n\n\n
To meet these demands, companies need to upgrade their technologies\u2014especially data processing technologies. <\/p>\n\n\n\n
<\/span>Pain points in current data technologies<\/span><\/h2>\n\n\n\nData silos<\/h3>\n\n\n\n
Sometimes, a company\u2019s data infrastructure gets out of sync. The way they use and manage data has changed a lot, but their data processing technologies may have stayed the same for 40 or 50 years. This mismatch leaves them few choices but to combine different technologies in different stacks to handle the data. Data in different stacks, however, is barely accessible, and creates \u201cdata silos.\u201d<\/strong><\/p>\n\n\n\nFailure to keep data fresh<\/h3>\n\n\n\n
To bring together data from different stacks, a variety of data tools have been introduced, such as data synchronization tools with longer pipelines. But this can create new problems. Although data silos are connected by using data tools, data becomes out of date after going through a long and complex processing process. Real-time data cannot stay fresh. <\/strong><\/p>\n\n\n\nWeak commercial value<\/h3>\n\n\n\n
After massive fresh data is generated, businesses usually want to derive insights from this data for different commercial purposes. To meet this end, you have to process data a second time using complicated data stack complexes, which once again adds to the length of the data processing course. This inevitably leads to a loss of data\u2019s real-time value and weaker commercial value.<\/strong> <\/p>\n\n\n\n<\/p>\n\n\n
Request a Demo<\/a>\u00a0 \u00a0 \u00a0Subscribe to Blog<\/a><\/strong><\/p>\n\n\n<\/p>\n\n\n\n
<\/span>How TiDB helps different industries achieve business impact with data<\/span><\/h2>\n\n\n\nNow that we know the demands for data processing and the downsides of current data solutions, let\u2019s see TiDB\u2019s strengths, and most importantly, how it helps various businesses keep their data fresh and achieve their data\u2019s commercial value. <\/p>\n\n\n\n
What is TiDB?<\/h3>\n\n\n\n
\ud2f0DB<\/a> is a horizontally scalable, strongly consistent, and highly available open-source NewSQL database. It gives users a one-stop solution with Online Transactional Processing (OLTP), Online Analytical Processing (OLAP), and real-time Hybrid Transactional and Analytical Processing (HTAP) services. <\/p>\n\n\n\nThe scalable OLTP capability of TiDB helps business users rapidly process massive amounts of incoming data. This keeps the data as fresh as possible. In addition, TiDB\u2019s real-time HTAP ability can provide users with fresh intelligence related to risk control, marketing, and other areas for commercial decision-making, while not interfering with the OLTP tasks.<\/p>\n\n\n\n
<\/p>\n\n\n\n![\"\"](\"https:\/\/static.pingcap.com\/files\/2023\/04\/14003013\/image-32-1024x736.png\")
<\/figure>\n\n\n\nTiDB\u2019s data processing flow<\/em><\/p>\n\n\n\n<\/p>\n\n\n\n
Industry use cases<\/h3>\n\n\n\n
TiDB has been adopted by thousands of businesses of various shapes and sizes in many industries including logistics, internet, and financial services. Let\u2019s see how TiDB helps them upgrade their data infrastructure and achieve business impact with data. <\/p>\n\n\n\n
Industry: financial services<\/strong><\/h4>\n\n\n\n\n- Customer: <\/strong>Yillion Bank<\/strong><\/a>, <\/strong>a leading internet bank in China with the majority of its business coming from the internet
How does TiDB help?<\/strong>
TiDB helps build Yillion Bank\u2019s distributed database system to:\n\n- Support its mission-critical banking systems, loan and mortgage services, and asset-backed securitization business<\/li>\n\n\n\n
- Support multi-data center disaster recovery in Beijing and Changchun, two big cities in China <\/li>\n\n\n\n
- Migrate heterogeneous data seamlessly from Oracle to TiDB<\/li>\n\n\n\n
- Ensure that if the number of transactions greatly increase, the system will stay resilient<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
\n- Customer: <\/strong>Pingan Life Insurance<\/strong><\/a>,<\/strong> a subsidiary of Pingan Insurance Group<\/a> which is the world-leading technology-powered retail financial services company
How does TiDB help?<\/strong><\/a>
The major characteristic of Pingan\u2019s agile financial systems\u2014and also the major challenge of its data infrastructure\u2014is peak transactions occurring in a short time<\/strong>. During the annual \u201cWealth God Festival\u201d campaign on Pingan\u2019s Gold Keeper mobile app, the transaction volume once reached a record 100 billion yuan on a single day<\/strong>.
Behind these peak transactions, hundreds of TiDB database instances were unremittingly delivering smooth frontend queries and convenient backend operations. To be more specific, TiDB:
\n\n- Uses standard SQL syntax to speed up agile application development<\/li>\n\n\n\n
- Scales out and in quickly by adding or removing nodes online without downtime<\/li>\n\n\n\n
- Uses secondary indexes and SQL statements to analyze real-time data<\/li>\n\n\n\n
- Simplifies database operations<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
\n- Customer:<\/strong> a leading mobile payment company in Japan and with more than 29 million individual users out of Japan\u2019s 100 million population and over 2 million business users
How does TiDB help?<\/strong>
Previously, our customer used the Amazon Aurora database. However, they had problems scaling it out during peak payment transactions. TiDB, which features horizontal scalability and high throughput, has helped our customer:
\n\n- Seamlessly migrate its data from Amazon Aurora to TiDB clusters<\/li>\n\n\n\n
- Quickly scale out or in during large transactions <\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
\n- Customer:<\/strong>Bank of Beijing<\/strong><\/a> (BOB)<\/strong>, a leading city commercial bank in China
How does TiDB help?<\/strong><\/a>
We have helped BOB build its comprehensive real-time data service platform. This platform:
\n\n- Decouples many modern applications from BOB\u2019s legacy systems such as AS400 and DB2; TiDB can replicate all the real-time data from those systems, including up to 10 billion rows of payment transaction data from the mission-critical banking system, and respond to real-time online queries<\/li>\n\n\n\n
- Consolidates data from various sources into TiDB to provide comprehensive data services <\/li>\n\n\n\n
- Upholds diverse financial scenarios including payment, accounting, and financial channels with the help of TiDB\u2019s hybrid partitioning and real-time HTAP capabilities<\/li>\n\n\n\n
- Makes a ZERO error record when supporting BOB\u2019s mission-critical financial systems including the payment and credit systems<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
\n- Customer:<\/strong>Beike Finance<\/strong><\/a>, China’s largest provider of residential property financing services
How does TiDB help?<\/strong>
We have helped Beike build its real-time data center so that it:
\n\n- Integrates TiDB with stream processing systems such as Apache Flink and Apache Kafka<\/li>\n\n\n\n
- Forms a comprehensive system to support real-time data generation, processing, and synchronization<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
<\/h4>\n\n\n\nIndustry: catering<\/strong><\/h4>\n\n\n\n\n- Customer:<\/strong> A world-leading catering giant
How does TiDB help?<\/strong>
TiDB helps our customer:
\n\n- Build its mission-critical database to support its highly concurrent and scalable transaction systems including its order center, user center, and coupon center<\/li>\n\n\n\n
- Integrate with Kubernetes (K8s) to adapt to our client\u2019s production environment by leveraging TiDB\u2019s strengths in cloud-native architecture<\/a><\/li>\n\n\n\n
- Ensure safe and stable transactions 24×7 by leveraging TiDB\u2019s strengths in availability, cloud-native architecture, and multi-datacenter disaster recovery <\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
<\/h4>\n\n\n\nIndustry: logistics<\/strong><\/h4>\n\n\n\n\n- Customer: <\/strong>ZTO Express<\/strong><\/a>, one of the world\u2019s largest express delivery
How does TiDB help?<\/strong><\/a>
TiDB helped ZTO Express increase their IT efficiency by 300%, and reduce their cost per order by almost 20% year-on-year. An important step was upgrading their data system architecture with TiFlash<\/a>, TiDB’s analytical engine, and TiCDC<\/a>, a tool to replicate TiDB’s incremental data, to power their HTAP scenarios.
We also help ZTO Express develop their real-time analytics platform which:
\n\n- Uses TiSpark<\/a> to aggregate data from multiple sources and writes data into TiDB in real time<\/li>\n\n\n\n
- Can process 300 million rows of delivery data and whose queries per second (QPS) can reach 500,000\/s<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n
<\/span>Try us out!<\/span><\/h2>\n\n\n\nWe feel proud that TiDB, our flagship product, is gaining recognition from users in diverse industries<\/a>. We owe our success to the unremitting efforts of all PingCAP engineers and community contributors in the past six years. <\/p>\n\n\n\nWith horizontal scalability, strong availability, and OLTP and real-time HTAP capabilities, TiDB has become a key data infrastructure and has helped so many businesses process their data and empower the data to realize customers\u2019 business value. <\/p>\n\n\n\n
If you want to learn more about TiDB, you\u2019re welcome to follow TiDB on GitHub<\/a> \ub610\ub294 join our community discussions on Slack<\/a>. You can also request a demo<\/a> from us. <\/p>","protected":false},"excerpt":{"rendered":"This post talks about the pain points of current data solutions and shares how TiDB, a highly scalable enterprise-level distributed database, helps businesses keep their data fresh and realize the data\u2019s business value. <\/p>","protected":false},"author":120,"featured_media":4451,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ub_ctt_via":"","footnotes":""},"categories":[13],"tags":[55,10,11,9],"class_list":["post-4450","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-product","tag-high-availability","tag-htap","tag-real-time-analytics","tag-scalability"],"acf":[],"featured_image_src":"https:\/\/static.pingcap.com\/files\/2022\/01\/20220121-181736.png","author_info":{"display_name":"Jun Yu","author_link":"https:\/\/www.pingcap.com\/ko\/blog\/author\/jun-yu\/"},"yoast_head":"\n
How TiDB Helps Keep Data Fresh and Maximize Its Business Value<\/title>\n<meta name=\"description\" content=\"Explore the pain points of current data solutions and learn how TiDB helps users keep their data fresh and maximize its business value.\" \/>\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\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How TiDB Helps Keep Data Fresh and Maximize Its Business Value\" \/>\n<meta property=\"og:description\" content=\"Explore the pain points of current data solutions and learn how TiDB helps users keep their data fresh and maximize its business value.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/\" \/>\n<meta property=\"og:site_name\" content=\"TiDB\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/pingcap2015\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-27T05:22:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-14T10:05:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2022\/01\/20220121-181736.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1500\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jun Yu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:site\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jun Yu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7\ubd84\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/\"},\"author\":{\"name\":\"Jun Yu\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/dd1cec84cdc85acff2a9089bd9b18d15\"},\"headline\":\"How a NewSQL Database Helps Keep Data Fresh and Maximize Its Business Value\",\"datePublished\":\"2022-01-27T05:22:41+00:00\",\"dateModified\":\"2025-11-14T10:05:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/\"},\"wordCount\":1398,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.pingcap.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2022\/01\/20220121-181736.png\",\"keywords\":[\"High Availability\",\"HTAP\",\"Real-time analytics\",\"Scalability\"],\"articleSection\":[\"Product\"],\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/\",\"url\":\"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/\",\"name\":\"How TiDB Helps Keep Data Fresh and Maximize Its Business Value\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2022\/01\/20220121-181736.png\",\"datePublished\":\"2022-01-27T05:22:41+00:00\",\"dateModified\":\"2025-11-14T10:05:11+00:00\",\"description\":\"Explore the pain points of current data solutions and learn how TiDB helps users keep their data fresh and maximize its business value.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/#primaryimage\",\"url\":\"https:\/\/static.pingcap.com\/files\/2022\/01\/20220121-181736.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2022\/01\/20220121-181736.png\",\"width\":1500,\"height\":500},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pingcap.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How a NewSQL Database Helps Keep Data Fresh and Maximize Its Business Value\"}]},{\"@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\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/dd1cec84cdc85acff2a9089bd9b18d15\",\"name\":\"Jun Yu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg\",\"caption\":\"Jun Yu\"},\"url\":\"https:\/\/www.pingcap.com\/ko\/blog\/author\/jun-yu\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How TiDB Helps Keep Data Fresh and Maximize Its Business Value","description":"Explore the pain points of current data solutions and learn how TiDB helps users keep their data fresh and maximize its business value.","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\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/","og_locale":"ko_KR","og_type":"article","og_title":"How TiDB Helps Keep Data Fresh and Maximize Its Business Value","og_description":"Explore the pain points of current data solutions and learn how TiDB helps users keep their data fresh and maximize its business value.","og_url":"https:\/\/www.pingcap.com\/ko\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_published_time":"2022-01-27T05:22:41+00:00","article_modified_time":"2025-11-14T10:05:11+00:00","og_image":[{"width":1500,"height":500,"url":"https:\/\/static.pingcap.com\/files\/2022\/01\/20220121-181736.png","type":"image\/png"}],"author":"Jun Yu","twitter_card":"summary_large_image","twitter_creator":"@PingCAP","twitter_site":"@PingCAP","twitter_misc":{"Written by":"Jun Yu","Est. reading time":"7\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/#article","isPartOf":{"@id":"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/"},"author":{"name":"Jun Yu","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/dd1cec84cdc85acff2a9089bd9b18d15"},"headline":"How a NewSQL Database Helps Keep Data Fresh and Maximize Its Business Value","datePublished":"2022-01-27T05:22:41+00:00","dateModified":"2025-11-14T10:05:11+00:00","mainEntityOfPage":{"@id":"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/"},"wordCount":1398,"commentCount":0,"publisher":{"@id":"https:\/\/www.pingcap.com\/#organization"},"image":{"@id":"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2022\/01\/20220121-181736.png","keywords":["High Availability","HTAP","Real-time analytics","Scalability"],"articleSection":["Product"],"inLanguage":"ko-KR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/","url":"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/","name":"How TiDB Helps Keep Data Fresh and Maximize Its Business Value","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/#primaryimage"},"image":{"@id":"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2022\/01\/20220121-181736.png","datePublished":"2022-01-27T05:22:41+00:00","dateModified":"2025-11-14T10:05:11+00:00","description":"Explore the pain points of current data solutions and learn how TiDB helps users keep their data fresh and maximize its business value.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/#primaryimage","url":"https:\/\/static.pingcap.com\/files\/2022\/01\/20220121-181736.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2022\/01\/20220121-181736.png","width":1500,"height":500},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pingcap.com\/"},{"@type":"ListItem","position":2,"name":"How a NewSQL Database Helps Keep Data Fresh and Maximize Its Business Value"}]},{"@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"]},{"@type":"Person","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/dd1cec84cdc85acff2a9089bd9b18d15","name":"Jun Yu","image":{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/#\/schema\/person\/image\/","url":"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg","contentUrl":"https:\/\/static.pingcap.com\/files\/2022\/10\/17234942\/avatar.jpg","caption":"Jun Yu"},"url":"https:\/\/www.pingcap.com\/ko\/blog\/author\/jun-yu\/"}]}},"grav_blocks":false,"card_markup":"<a class=\"card-resource bg-white\" href=\"https:\/\/www.pingcap.com\/ko\/blog\/how-a-newsql-database-helps-keep-data-fresh-and-maximize-its-business-value\/\"><div class=\"card-resource__image-container\"><img class=\"card-resource__image\" alt=\"20220121-181736\" src=\"https:\/\/static.pingcap.com\/files\/2022\/01\/20220121-181736.png\" loading=\"lazy\" width=1500 height=500 \/><\/div><div class=\"card-resource__content-container\"><div class=\"card-resource__content-head\"><div class=\"card-resource__category\">Product<\/div><\/div><h5 class=\"card-resource__title\">How a NewSQL Database Helps Keep Data Fresh and Maximize Its Business Value<\/h5><\/div><\/a>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/4450","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/users\/120"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/comments?post=4450"}],"version-history":[{"count":17,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/4450\/revisions"}],"predecessor-version":[{"id":30491,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/posts\/4450\/revisions\/30491"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media\/4451"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=4450"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/categories?post=4450"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/tags?post=4450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
<\/p>\n\n\n\n The flow chart of data processing<\/em><\/p>\n\n\n\n <\/p>\n\n\n\n To meet these demands, companies need to upgrade their technologies\u2014especially data processing technologies. <\/p>\n\n\n\n Sometimes, a company\u2019s data infrastructure gets out of sync. The way they use and manage data has changed a lot, but their data processing technologies may have stayed the same for 40 or 50 years. This mismatch leaves them few choices but to combine different technologies in different stacks to handle the data. Data in different stacks, however, is barely accessible, and creates \u201cdata silos.\u201d<\/strong><\/p>\n\n\n\n To bring together data from different stacks, a variety of data tools have been introduced, such as data synchronization tools with longer pipelines. But this can create new problems. Although data silos are connected by using data tools, data becomes out of date after going through a long and complex processing process. Real-time data cannot stay fresh. <\/strong><\/p>\n\n\n\n After massive fresh data is generated, businesses usually want to derive insights from this data for different commercial purposes. To meet this end, you have to process data a second time using complicated data stack complexes, which once again adds to the length of the data processing course. This inevitably leads to a loss of data\u2019s real-time value and weaker commercial value.<\/strong> <\/p>\n\n\n\n <\/p>\n\n\n Request a Demo<\/a>\u00a0 \u00a0 \u00a0Subscribe to Blog<\/a><\/strong><\/p>\n\n\n <\/p>\n\n\n\n Now that we know the demands for data processing and the downsides of current data solutions, let\u2019s see TiDB\u2019s strengths, and most importantly, how it helps various businesses keep their data fresh and achieve their data\u2019s commercial value. <\/p>\n\n\n\n \ud2f0DB<\/a> is a horizontally scalable, strongly consistent, and highly available open-source NewSQL database. It gives users a one-stop solution with Online Transactional Processing (OLTP), Online Analytical Processing (OLAP), and real-time Hybrid Transactional and Analytical Processing (HTAP) services. <\/p>\n\n\n\n The scalable OLTP capability of TiDB helps business users rapidly process massive amounts of incoming data. This keeps the data as fresh as possible. In addition, TiDB\u2019s real-time HTAP ability can provide users with fresh intelligence related to risk control, marketing, and other areas for commercial decision-making, while not interfering with the OLTP tasks.<\/p>\n\n\n\n <\/p>\n\n\n\n TiDB\u2019s data processing flow<\/em><\/p>\n\n\n\n <\/p>\n\n\n\n TiDB has been adopted by thousands of businesses of various shapes and sizes in many industries including logistics, internet, and financial services. Let\u2019s see how TiDB helps them upgrade their data infrastructure and achieve business impact with data. <\/p>\n\n\n\n We feel proud that TiDB, our flagship product, is gaining recognition from users in diverse industries<\/a>. We owe our success to the unremitting efforts of all PingCAP engineers and community contributors in the past six years. <\/p>\n\n\n\n With horizontal scalability, strong availability, and OLTP and real-time HTAP capabilities, TiDB has become a key data infrastructure and has helped so many businesses process their data and empower the data to realize customers\u2019 business value. <\/p>\n\n\n\n If you want to learn more about TiDB, you\u2019re welcome to follow TiDB on GitHub<\/a> \ub610\ub294 join our community discussions on Slack<\/a>. You can also request a demo<\/a> from us. <\/p>","protected":false},"excerpt":{"rendered":" This post talks about the pain points of current data solutions and shares how TiDB, a highly scalable enterprise-level distributed database, helps businesses keep their data fresh and realize the data\u2019s business value. <\/p>","protected":false},"author":120,"featured_media":4451,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ub_ctt_via":"","footnotes":""},"categories":[13],"tags":[55,10,11,9],"class_list":["post-4450","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-product","tag-high-availability","tag-htap","tag-real-time-analytics","tag-scalability"],"acf":[],"featured_image_src":"https:\/\/static.pingcap.com\/files\/2022\/01\/20220121-181736.png","author_info":{"display_name":"Jun Yu","author_link":"https:\/\/www.pingcap.com\/ko\/blog\/author\/jun-yu\/"},"yoast_head":"\n<\/figure>\n\n\n\n<\/span>Pain points in current data technologies<\/span><\/h2>\n\n\n\n
Data silos<\/h3>\n\n\n\n
Failure to keep data fresh<\/h3>\n\n\n\n
Weak commercial value<\/h3>\n\n\n\n
<\/span>How TiDB helps different industries achieve business impact with data<\/span><\/h2>\n\n\n\n
What is TiDB?<\/h3>\n\n\n\n
<\/figure>\n\n\n\nIndustry use cases<\/h3>\n\n\n\n
Industry: financial services<\/strong><\/h4>\n\n\n\n
\n
How does TiDB help?<\/strong>
TiDB helps build Yillion Bank\u2019s distributed database system to:\n\n
\n
How does TiDB help?<\/strong><\/a>
The major characteristic of Pingan\u2019s agile financial systems\u2014and also the major challenge of its data infrastructure\u2014is peak transactions occurring in a short time<\/strong>. During the annual \u201cWealth God Festival\u201d campaign on Pingan\u2019s Gold Keeper mobile app, the transaction volume once reached a record 100 billion yuan on a single day<\/strong>.
Behind these peak transactions, hundreds of TiDB database instances were unremittingly delivering smooth frontend queries and convenient backend operations. To be more specific, TiDB:
\n\n
\n
How does TiDB help?<\/strong>
Previously, our customer used the Amazon Aurora database. However, they had problems scaling it out during peak payment transactions. TiDB, which features horizontal scalability and high throughput, has helped our customer:
\n\n
\n
How does TiDB help?<\/strong><\/a>
We have helped BOB build its comprehensive real-time data service platform. This platform:
\n\n
\n
How does TiDB help?<\/strong>
We have helped Beike build its real-time data center so that it:
\n\n
<\/h4>\n\n\n\n
Industry: catering<\/strong><\/h4>\n\n\n\n
\n
How does TiDB help?<\/strong>
TiDB helps our customer:
\n\n
<\/h4>\n\n\n\n
Industry: logistics<\/strong><\/h4>\n\n\n\n
\n
How does TiDB help?<\/strong><\/a>
TiDB helped ZTO Express increase their IT efficiency by 300%, and reduce their cost per order by almost 20% year-on-year. An important step was upgrading their data system architecture with TiFlash<\/a>, TiDB’s analytical engine, and TiCDC<\/a>, a tool to replicate TiDB’s incremental data, to power their HTAP scenarios.
We also help ZTO Express develop their real-time analytics platform which:
\n\n
<\/span>Try us out!<\/span><\/h2>\n\n\n\n