{"id":18613,"date":"2024-06-23T09:19:44","date_gmt":"2024-06-23T16:19:44","guid":{"rendered":"https:\/\/www.pingcap.com\/?post_type=event&p=18613"},"modified":"2024-08-22T21:19:27","modified_gmt":"2024-08-23T04:19:27","slug":"how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database","status":"publish","type":"event","link":"https:\/\/www.pingcap.com\/ko\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/","title":{"rendered":"How to Deliver Zero ETL Real-Time Analytics in a Distributed Database"},"content":{"rendered":"
The boundary between transactional and analytical workloads is blurring: transactional workloads are becoming more analytical, and vice versa. But how can a database unify both types of workloads while eliminating the latency, complexity, and operational support of separate systems?\u00a0<\/p>\n\n\n\n
With hybrid transactional\/analytical processing (HTAP), businesses don\u2019t have to perform transactions in one database, and analytics in another\u2014they can now do both, in a single database. By combining row store and column store, HTAP draws on the advantages of both to accomplish more than simply connecting the two formats.<\/p>\n\n\n\n
In this webinar, PingCAP Senior Solutions Engineer Daniel James explores the practical applications of HTAP in action with TiDB, an open-source, distributed SQL database. You\u2019ll discover:<\/p>\n\n\n\n
\n
What defines HTAP and how it simplifies data infrastructure<\/li>\n\n\n\n
Real-world use cases including fraud detection, complex event processing, and data serving<\/li>\n\n\n\n
How TiDB delivers real-time data processing and integration<\/li>\n\n\n\n
The business benefits large-scale companies have gained\u00a0<\/li>\n<\/ul>\n\n\n\n
<\/div>\n\n\n\n
Speaker: <\/strong><\/p>\n\n\n\n
\n
\n<\/figure>\n<\/div>\n\n\n\n
\n
Daniel James<\/strong><\/p>\n\n\n\n
Senior Solutions Engineer at PingCAP<\/strong><\/p>\n\n\n\n
Daniel spent over thirty years as a DBA and software engineer. He has also worked on every major RDBMS platform including Oracle, SQL Server, Informix, DB2, MySQL, and Sybase. Daniel spent several years as a solutions engineer at Couchbase and Snowflake, and prior to that he worked at large enterprise companies such as AT&T and Microsoft.<\/p>\n<\/div>\n<\/div>","protected":false},"excerpt":{"rendered":"
The boundary between transactional and analytical workloads is blurring: transactional workloads are becoming more analytical, and vice versa. But how can a database unify both types of workloads while eliminating the latency, complexity, and operational support of separate systems?\u00a0 With hybrid transactional\/analytical processing (HTAP), businesses don\u2019t have to perform transactions in one database, and analytics […]<\/p>\n","protected":false},"featured_media":18615,"template":"","categories":[],"tags":[],"region":[214,215,216],"location":[207],"class_list":["post-18613","event","type-event","status-publish","has-post-thumbnail","hentry","region-apac","region-emea","region-north-america","location-virtual"],"acf":[],"yoast_head":"\n
Delivering Zero ETL Real-Time Analytics in a Distributed Database<\/title>\n<meta name=\"description\" content=\"Explore practical applications of HTAP in action using TiDB through use cases, architecture walkthroughs, and real-world case studies.\" \/>\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\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Delivering Zero ETL Real-Time Analytics in a Distributed Database\" \/>\n<meta property=\"og:description\" content=\"Explore practical applications of HTAP in action using TiDB through use cases, architecture walkthroughs, and real-world case studies.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.pingcap.com\/ko\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/\" \/>\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-08-23T04:19:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/static.pingcap.com\/files\/2024\/08\/22173229\/20240822-173049.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"2560\" \/>\n\t<meta property=\"og:image:height\" content=\"1440\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/static.pingcap.com\/files\/2024\/08\/22173229\/20240822-173049.jpeg\" \/>\n<meta name=\"twitter:site\" content=\"@PingCAP\" \/>\n<meta name=\"twitter:label1\" content=\"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04\" \/>\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\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/\",\"url\":\"https:\/\/www.pingcap.com\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/\",\"name\":\"Delivering Zero ETL Real-Time Analytics in a Distributed Database\",\"isPartOf\":{\"@id\":\"https:\/\/www.pingcap.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/static.pingcap.com\/files\/2024\/07\/22183913\/pingcap_feature_1800x600-1.png\",\"datePublished\":\"2024-06-23T16:19:44+00:00\",\"dateModified\":\"2024-08-23T04:19:27+00:00\",\"description\":\"Explore practical applications of HTAP in action using TiDB through use cases, architecture walkthroughs, and real-world case studies.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.pingcap.com\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.pingcap.com\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ko-KR\",\"@id\":\"https:\/\/www.pingcap.com\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/#primaryimage\",\"url\":\"https:\/\/static.pingcap.com\/files\/2024\/07\/22183913\/pingcap_feature_1800x600-1.png\",\"contentUrl\":\"https:\/\/static.pingcap.com\/files\/2024\/07\/22183913\/pingcap_feature_1800x600-1.png\",\"width\":3600,\"height\":1200},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.pingcap.com\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.pingcap.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Events\",\"item\":\"https:\/\/www.pingcap.com\/event\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Deliver Zero ETL Real-Time Analytics in a Distributed Database\"}]},{\"@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":"Delivering Zero ETL Real-Time Analytics in a Distributed Database","description":"Explore practical applications of HTAP in action using TiDB through use cases, architecture walkthroughs, and real-world case studies.","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\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/","og_locale":"ko_KR","og_type":"article","og_title":"Delivering Zero ETL Real-Time Analytics in a Distributed Database","og_description":"Explore practical applications of HTAP in action using TiDB through use cases, architecture walkthroughs, and real-world case studies.","og_url":"https:\/\/www.pingcap.com\/ko\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/","og_site_name":"TiDB","article_publisher":"https:\/\/facebook.com\/pingcap2015","article_modified_time":"2024-08-23T04:19:27+00:00","og_image":[{"width":2560,"height":1440,"url":"https:\/\/static.pingcap.com\/files\/2024\/08\/22173229\/20240822-173049.jpeg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_image":"https:\/\/static.pingcap.com\/files\/2024\/08\/22173229\/20240822-173049.jpeg","twitter_site":"@PingCAP","twitter_misc":{"\uc608\uc0c1 \ub418\ub294 \ud310\ub3c5 \uc2dc\uac04":"1\ubd84"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.pingcap.com\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/","url":"https:\/\/www.pingcap.com\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/","name":"Delivering Zero ETL Real-Time Analytics in a Distributed Database","isPartOf":{"@id":"https:\/\/www.pingcap.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.pingcap.com\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/#primaryimage"},"image":{"@id":"https:\/\/www.pingcap.com\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/#primaryimage"},"thumbnailUrl":"https:\/\/static.pingcap.com\/files\/2024\/07\/22183913\/pingcap_feature_1800x600-1.png","datePublished":"2024-06-23T16:19:44+00:00","dateModified":"2024-08-23T04:19:27+00:00","description":"Explore practical applications of HTAP in action using TiDB through use cases, architecture walkthroughs, and real-world case studies.","breadcrumb":{"@id":"https:\/\/www.pingcap.com\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.pingcap.com\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/"]}]},{"@type":"ImageObject","inLanguage":"ko-KR","@id":"https:\/\/www.pingcap.com\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/#primaryimage","url":"https:\/\/static.pingcap.com\/files\/2024\/07\/22183913\/pingcap_feature_1800x600-1.png","contentUrl":"https:\/\/static.pingcap.com\/files\/2024\/07\/22183913\/pingcap_feature_1800x600-1.png","width":3600,"height":1200},{"@type":"BreadcrumbList","@id":"https:\/\/www.pingcap.com\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.pingcap.com\/"},{"@type":"ListItem","position":2,"name":"Events","item":"https:\/\/www.pingcap.com\/event\/"},{"@type":"ListItem","position":3,"name":"How to Deliver Zero ETL Real-Time Analytics in a Distributed Database"}]},{"@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":"<a class=\"card-resource bg-white\" href=\"https:\/\/www.pingcap.com\/ko\/event\/how-to-deliver-zero-etl-real-time-analytics-in-a-distributed-database\/\"><div class=\"card-event__image-container\"><img class=\"card-event__image\" alt=\"pingcap_feature_1800x600\" src=\"https:\/\/static.pingcap.com\/files\/2024\/07\/22183913\/pingcap_feature_1800x600-1.png\" loading=\"lazy\" width=3600 height=1200 \/><\/div><div class=\"card-event__content-container\"><div class=\"card-resource__content-status\"><div class=\"card-resource__status completed\">Completed<\/div><div class=\"card-resource__webinar\"><i><\/i>On-Demand<\/div><\/div><h5 class=\"card-resource__title\">How to Deliver Zero ETL Real-Time Analytics in a Distributed Database<\/h5><p class=\"card-resource__date\"><i class=\"icon-calendar-check\"><\/i>Jan 1 12:00 am - 12:00 am PDT<\/p><p class=\"card-resource__location\"><i class=\"icon-map-pin\"><\/i>Virtual<\/p><\/div><\/a>","_links":{"self":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/event\/18613","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/event"}],"about":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/types\/event"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media\/18615"}],"wp:attachment":[{"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/media?parent=18613"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/categories?post=18613"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/tags?post=18613"},{"taxonomy":"region","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/region?post=18613"},{"taxonomy":"location","embeddable":true,"href":"https:\/\/www.pingcap.com\/ko\/wp-json\/wp\/v2\/location?post=18613"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
![\"\"](\"https:\/\/static.pingcap.com\/files\/2024\/07\/22183601\/Daniel-James-Profile-Picture.png\")
<\/figure>\n<\/div>\n\n\n\n