{"id":4541,"date":"2024-03-14T01:35:59","date_gmt":"2024-03-14T01:35:59","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/"},"modified":"2025-07-31T09:28:50","modified_gmt":"2025-07-31T09:28:50","slug":"how-to-perform-data-modeling-and-pre-aggregation-in-kylin","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/","title":{"rendered":"Kylin Data Modeling &#038; Pre-aggregation Guide"},"content":{"rendered":"<p>In Kylin, data modeling and pre-aggregation are achieved through the construction of Cubes.<\/p>\n<p>Data modeling mainly includes defining data source tables, defining dimension tables, defining measure tables, and defining Cubes. In Kylin, data models can be created through the Web UI or command line tools. First, the data source table, where the data comes from, needs to be defined. Then, dimension tables and measure tables are defined, with dimension tables describing the properties of business objects and measure tables describing the quantity of business objects. Finally, a Cube needs to be defined to combine the data source table, dimension tables, and measure tables for pre-aggregate calculations.<\/p>\n<p>Pre-aggregation is achieved through the Cube Segment in the Cube. Multiple Cube Segments can be defined in the Cube, each corresponding to a specific time range or other conditions. Within the Cube Segment, pre-aggregation calculations can be performed to aggregate data based on different dimensions, speeding up query performance.<\/p>\n<p>Overall, the data modeling and pre-aggregation in Kylin are achieved through the construction of Cubes, where data source tables, dimension tables, measure tables, and Cubes can be defined according to requirements, and pre-aggregated calculations can be performed within the Cube Segment.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Kylin, data modeling and pre-aggregation are achieved through the construction of Cubes. Data modeling mainly includes defining data source tables, defining dimension tables, defining measure tables, and defining Cubes. In Kylin, data models can be created through the Web UI or command line tools. First, the data source table, where the data comes from, [&hellip;]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[897,302,2279,4243,4242],"class_list":["post-4541","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-apache-kylin","tag-big-data","tag-data-modeling","tag-olap-cubes","tag-pre-aggregation"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Kylin Data Modeling &amp; Pre-aggregation Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn data modeling and pre-aggregation in Apache Kylin using Cubes. Step-by-step guide for dimension\/measure tables.\" \/>\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.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Kylin Data Modeling &amp; Pre-aggregation Guide\" \/>\n<meta property=\"og:description\" content=\"Learn data modeling and pre-aggregation in Apache Kylin using Cubes. Step-by-step guide for dimension\/measure tables.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T01:35:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-31T09:28:50+00:00\" \/>\n<meta name=\"author\" content=\"Emily Johnson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Emily Johnson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/\"},\"author\":{\"name\":\"Emily Johnson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\"},\"headline\":\"Kylin Data Modeling &#038; Pre-aggregation Guide\",\"datePublished\":\"2024-03-14T01:35:59+00:00\",\"dateModified\":\"2025-07-31T09:28:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/\"},\"wordCount\":201,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"Apache Kylin\",\"Big Data\",\"Data modeling\",\"OLAP Cubes\",\"Pre-aggregation\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/\",\"name\":\"Kylin Data Modeling & Pre-aggregation Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T01:35:59+00:00\",\"dateModified\":\"2025-07-31T09:28:50+00:00\",\"description\":\"Learn data modeling and pre-aggregation in Apache Kylin using Cubes. Step-by-step guide for dimension\/measure tables.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Kylin Data Modeling &#038; Pre-aggregation Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378\",\"name\":\"Emily Johnson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g\",\"caption\":\"Emily Johnson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Kylin Data Modeling & Pre-aggregation Guide - Blog - Silicon Cloud","description":"Learn data modeling and pre-aggregation in Apache Kylin using Cubes. Step-by-step guide for dimension\/measure tables.","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.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/","og_locale":"en_US","og_type":"article","og_title":"Kylin Data Modeling & Pre-aggregation Guide","og_description":"Learn data modeling and pre-aggregation in Apache Kylin using Cubes. Step-by-step guide for dimension\/measure tables.","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T01:35:59+00:00","article_modified_time":"2025-07-31T09:28:50+00:00","author":"Emily Johnson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Emily Johnson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/"},"author":{"name":"Emily Johnson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378"},"headline":"Kylin Data Modeling &#038; Pre-aggregation Guide","datePublished":"2024-03-14T01:35:59+00:00","dateModified":"2025-07-31T09:28:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/"},"wordCount":201,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["Apache Kylin","Big Data","Data modeling","OLAP Cubes","Pre-aggregation"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/","name":"Kylin Data Modeling & Pre-aggregation Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T01:35:59+00:00","dateModified":"2025-07-31T09:28:50+00:00","description":"Learn data modeling and pre-aggregation in Apache Kylin using Cubes. Step-by-step guide for dimension\/measure tables.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-perform-data-modeling-and-pre-aggregation-in-kylin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Kylin Data Modeling &#038; Pre-aggregation Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/3b041b19cffc258705478ecfab895378","name":"Emily Johnson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a5cb4e73d02ab1d79f2dfe919389ff7c1de072baa97686392031c03d858cc358?s=96&d=mm&r=g","caption":"Emily Johnson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/emilyjohnson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4541","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=4541"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4541\/revisions"}],"predecessor-version":[{"id":149214,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4541\/revisions\/149214"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=4541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=4541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=4541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}