In a recent community call, Albert Wong, our StarRocks expert and developer advocate, provided valuable insights into the current OLAP (Online Analytical Processing) landscape, highlighting the latest trends in OLAP databases.

Albert also introduced StarRocks and its common use cases in real-time and user-facing analytics. He detailed the technical features and the development roadmap of StarRocks, with a special focus on the new features in StarRocks 3.2 and practical tips to help you leverage these improvements effectively.

------------------------------------------------ Timestamps ---------------------------------------------------------------------

00:00 Intro
00:16 Agenda
00:50 State of the OLAP Software Landscape
03:19 Cloud Native
04:59 Sub-second vs. Second/Minute Query Response Time
06:29 Streaming vs. Batch Data
07:08 Mutable vs. Immutable Data
08:18 Remote (Object) Storage vs. Local (SSD) Storage
09:18 Open Table Format vs. Product Native Storage Format
10:11 Data Warehouse + Data Lake = Data Lakehouse
13:43 What is StarRocks
14:20 The relationship between StarRocks and CelerData
16:26 Why people prefer StarRocks
25:04 StarRocks Use Cases: User-facing analytics
29:08 StarRocks Use Cases: Real-time analytics
32:21 StarRocks Architecture Overview
34:42 StarRocks Past and Future: Technical Features
37:24 StarRocks 3.x Series Roadmap
39:09 Major Features in StarRocks 3.2
39:50 Table Creation & Schema Change
41:09 Data Loading & Unloading
42:49 Data Query
44:15 Shared Data Architecture
45:06 Data Lake Analytics
46:49 Materialized Views
48:34 Synchronous Materialized Views
48:57 Row-column Mixed Storage (future minor versions)
50:26 Other Enhancements
51:24 Major Features in CelerData Cloud 3.2
51:44 Multi-warehouse (Cloud only feature)
54:16 Q&A
54:28 What are the best practices in StarRocks you would advise incomers from other data warehouse systems?
57:35 Community vs. CelerData enterprise version vs. managed service version
59:30 Is using HTTP faster than using the MySQL (JDBC) driver?
01:02:15 Is moving the persistent data on FE nodes to shared storage on the roadmap so the entirety of data and metadata exists in cloud storage
01:03:40 Do you want to plan to use Network file System for data? Maybe cold data; like that S3 or HDFS

-----------------------------------------------------------------------------------------------------------------------
Learn more at https://starrocks.com/

Connect with us:
LinkedIn:   / celerdata  
Twitter:   / celerdata  
CelerData Website: https://celerdata.com/
StarRocks GitHub: https://github.com/StarRocks/StarRocks
StarRocks Website: https://www.starrocks.io/
Slack: https://try.starrocks.com/join-starro...


#DataAnalytics #DataEngineering #DataLakeAnalytics #OLAP #DataAnalyst #DataEngineer #DataInfrastructure #UserFacingAnalytics #Database #AnalyticalDatabase #DataLake #DataLakeHouse #DataWarehouse #DataScience #ObjectStore