Companies build their own customer data platform to collect and and manage user data from various sources. With this data, they create 360-degree user profiles, analyze user behaviors, interests, and demands as a reference for their marketing and business operations, in order to improve user experience and boost growth.
The above shows the typical workflow of user profiling and behavior analysis. Common solutions are often challenged by the following problems:
Inflexible table schema
As part of production iteration, new fields need to be added to data tables. Solutions that do not support flexible schema change will not be able to serve the needs of the evolving business.
Complicated computation
In the analysis of discrete events, general-purpose SQLs often add to the complexity of computation and introduce large amounts of join operations. Those cause low efficiency in computation.
No support for real-time update
Affected by computing resources and business needs, the hundreds of user tags are generated at various paces, making it hard to generate the "latest" user profiles.
Slow query response
As each user produces multiple events and behaviors per day, the total data size grows exponentially as user base expands. Common solutions often find it hard to provide real-time query response with such huge data.
The VeloDB solution
VeloDB-based customer data platform
Data integration
·VeloDB can extract data from event tracking and databases such as MySQL and Oracle. It supports Flink CDC and high-concurrency small-batch imports to ensure low data latency. It also provides Exactly-Once guarantee in data ingestion.
·VeloDB provides data lakehousing capabilities and allows access to multiple external data sources including Hive, JDBC, and Elasticsearch.
Data storage
·To write data from multiple data sources to message queues, VeloDB supports lightweight data cleaning and data modeling in the real-time computation layer via ETL or ELT mode.
·VeloDB Cloud utilizes low-cost and highly available object storage. VeloDB Enterprise supports tiered storage and moving cold data to object storage.
Data service & application
·VeloDB supports MySQL protocol and ANSI SQL so it can be easily integrated with data services and applications.
·After user tagging and segmentation, VeloDB can provide interfaces for recommendation and queries to facilitate user profile analysis and precision marketing.
Schema change within milliseconds
Enable real-time column update of flat tables to support frequent changes in user behavior attributes.
Extensive function support
VeloDB provides users with a rich collection of behavior analytic functions that are simple and efficient. It can deliver a query latency of less than 10 seconds in behavior analysis of 300 billion rows of active data.
User segmentation within seconds
Powered by orthogonal bitmap
Try VeloDB now
VeloDB Cloud
Fully managed, cloud-native, real-time data warehouse service