HoloWeb is a visualized end-to-end database management and development platform based on Hologres. This platform is suitable for scenarios such as database management, database access, data development, data analysis, and performance analysis and diagnostics. This topic describes HoloWeb and its development and O&M features.
HoloWeb overview
Hologres is an all-in-one real-time data warehouse service that allows you to write data in real time, analyze and process petabytes of data with high concurrency and low latency, and perform point queries with an ultra-high level of queries per second (QPS). Hologres is seamlessly integrated with MaxCompute. It supports accelerated data queries and is compatible with the PostgreSQL ecosystem. You can use business intelligence (BI) tools that you are most familiar with to perform multi-dimensional analysis as well as business exploration on large amounts of data to suit your needs of data warehouse analysis and service integration.
HoloWeb provides a visual interface for developing and operating Hologres databases without requiring SQL for most tasks. Compared to standard PostgreSQL development tools, HoloWeb offers three core advantages:
-
Low learning curve
Complete big data development tasks through point-and-click interactions, significantly reducing the time needed to become productive with Hologres.
-
Deep Hologres integration
HoloWeb exposes Hologres-specific capabilities directly in the interface: import data using foreign tables or local file uploads, tune execution plans visually, and review slow query logs — covering most Hologres features without writing SQL.
-
End-to-end development and O&M
HoloWeb combines development tools and O&M capabilities — including IP address whitelists and resource isolation — in a single platform, eliminating the need to build or maintain a separate operations interface.
O&M features
-
Metadata Management
Connect to Hologres instances and manage all database objects — instances, databases, schemas, tables, and views — from a single page. Create internal and foreign tables, import data, and manage and modify existing objects without writing DDL statements.
-
SQL Editor
Write and run standard PostgreSQL statements, inspect execution plans, and analyze query performance to optimize slow workloads. The SQL Editor supports interactive and ad hoc queries. Query execution time cannot exceed 60 minutes.
-
Diagnostics and Optimization
Monitor instance health and troubleshoot issues using slow query logs, active query views, and connection management. The built-in metrics console helps diagnose anomalies and reduces manual intervention in day-to-day operations.
-
Data Solutions
Import data visually — upload files from your computer or pull from foreign tables — without writing SQL. This reduces onboarding time and simplifies routine data loading tasks.
-
Security Center
Manage instance security from one place: configure user authorization, set IP address whitelists, and assign resource groups. Security Center provides end-to-end security management capabilities to meet end-to-end O&M and management requirements.