Real Time Analytics with PostgreSQL
Many companies are in need of a real-time analytics solution. Events such as website clicks or sensor measurements come in at a high rate and users want real-time insight into this data using a dashboard, which involves a number of scalability problems. A typical approach is to store events data in HDFS, compute different aggregates using Spark, and put the results into Cassandra to let the application access them. In this webinar, we will show that PostgreSQL can perform all of these tasks efficiently by using a combination of cached aggregates and a queue of changes that is periodically flushed into the cache. Using the Github archive data, we will demonstrate that this approach performs well on both the ingestion side and the querying side even for very large datasets.
Видео Real Time Analytics with PostgreSQL канала Citus Data
Видео Real Time Analytics with PostgreSQL канала Citus Data
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Understanding Advanced Datatypes in PostgreSQLPostgres Listen/Notify with CardanoSharp and LIFT WalletIntro to RedisTimeSeriesCitus vs. Single-Node Postgres Database | A Side-by-Side ComparisonBuild a Real Time Chat App With Node.js And Socket.ioScaling Postgres for Time Series Data with the Citus DatabaseWhat is a Multitenancy Architecture and Why Is it becoming popular?Citus 11 Release Party for the Postgres you love at any scalePostgreSQL crosstab() for reporting and analyticsHow to build your career in IOT? - Ashish Gupta, Jigsaw AcademyDocker For Data ScienceReal-Time Streaming Stock Market Data with Python and WebsocketsCapture streaming data using Azure Event Hub, Azure Stream Analytics, Power BI and Azure SQL DB.Multi-tenant architecture in 20 minutesBuilding data pipelines with Kafka and PostgreSQLPGLogical the logical replication for PostgresqlHow to use MongoDB and PostgreSQL in GraphQLReal time streaming in Power BIGooge cloud platfom- GCP - Cloud SQL - Postgres Database Engine with SSL security + PgAdminHigh Performance PostgreSQL, Tuning and Optimization Guide - Ibrar Ahmed - PostgreSQL Tutorial