Average Ratings 0 Ratings
Average Ratings 0 Ratings
Description
Pinot is built to efficiently handle OLAP queries on static data with minimal latency. It incorporates various pluggable indexing methods, including Sorted Index, Bitmap Index, and Inverted Index. While it currently lacks support for joins, this limitation can be mitigated by utilizing Trino or PrestoDB for querying purposes. The system offers an SQL-like language that enables selection, aggregation, filtering, grouping, ordering, and distinct queries on datasets. It comprises both offline and real-time tables, with real-time tables being utilized to address segments lacking offline data. Additionally, users can tailor the anomaly detection process and notification mechanisms to accurately identify anomalies. This flexibility ensures that users can maintain data integrity and respond proactively to potential issues.
Description
InfiniDB is a column-oriented database management system specifically designed for online analytical processing (OLAP) workloads, featuring a distributed architecture that facilitates Massive Parallel Processing (MPP). Its integration with MySQL allows users who are accustomed to MySQL to transition smoothly to InfiniDB, as they can connect using any MySQL-compatible connector. To manage concurrency, InfiniDB employs Multi-Version Concurrency Control (MVCC) and utilizes a System Change Number (SCN) to represent the system's versioning. In the Block Resolution Manager (BRM), it effectively organizes three key structures: the version buffer, the version substitution structure, and the version buffer block manager, which all work together to handle multiple data versions. Additionally, InfiniDB implements deadlock detection mechanisms to address conflicts that arise during data transactions. Notably, it supports all MySQL syntax, including features like foreign keys, making it versatile for users. Moreover, it employs range partitioning for each column, maintaining the minimum and maximum values of each partition in a compact structure known as the extent map, ensuring efficient data retrieval and organization. This unique approach to data management enhances both performance and scalability for complex analytical queries.
API Access
Has API
API Access
Has API
Integrations
Amazon S3
Apache Kafka
Astro by Astronomer
Azure Data Lake
Hadoop
Hue
Kestra
MySQL
Onehouse
OpenMetadata
Integrations
Amazon S3
Apache Kafka
Astro by Astronomer
Azure Data Lake
Hadoop
Hue
Kestra
MySQL
Onehouse
OpenMetadata
Pricing Details
No price information available.
Free Trial
Free Version
Pricing Details
No price information available.
Free Trial
Free Version
Deployment
Web-Based
On-Premises
iPhone App
iPad App
Android App
Windows
Mac
Linux
Chromebook
Deployment
Web-Based
On-Premises
iPhone App
iPad App
Android App
Windows
Mac
Linux
Chromebook
Customer Support
Business Hours
Live Rep (24/7)
Online Support
Customer Support
Business Hours
Live Rep (24/7)
Online Support
Types of Training
Training Docs
Webinars
Live Training (Online)
In Person
Types of Training
Training Docs
Webinars
Live Training (Online)
In Person
Vendor Details
Company Name
Apache Corporation
Founded
1954
Country
United Statess
Website
pinot.apache.org
Vendor Details
Company Name
Database of Databases
Founded
2000
Country
United States
Website
dbdb.io/db/infinidb
Product Features
Product Features
Database
Backup and Recovery
Creation / Development
Data Migration
Data Replication
Data Search
Data Security
Database Conversion
Mobile Access
Monitoring
NOSQL
Performance Analysis
Queries
Relational Interface
Virtualization