Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

Average Ratings 0 Ratings

Total
ease
features
design
support

No User Reviews. Be the first to provide a review:

Write a Review

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.

Description

PartiQL extends SQL in a manner that is straightforward, allowing nested data to be treated as integral components and enabling a smooth integration with SQL itself. This capability facilitates intuitive operations such as filtering, joining, and aggregating various types of data, including structured, semistructured, and nested datasets. By decoupling the syntax and semantics of queries from the actual data format or storage system, PartiQL provides a cohesive querying experience across diverse data stores and formats. It empowers users to engage with data irrespective of the presence of a standard schema. Additionally, the components of PartiQL—including its syntax, semantics, embedded reference interpreter, command-line interface, testing framework, and associated tests—are distributed under the Apache License, version 2.0. This licensing grants users the freedom to use, modify, and share their contributions while adhering to their preferred terms. Thus, the overall design of PartiQL enhances accessibility and flexibility in data management across various platforms.

API Access

Has API

API Access

Has API

Screenshots View All

Screenshots View All

Integrations

AWS IoT
Amazon DynamoDB
Amazon Quantum Ledger Database (QLDB)
Amazon Redshift
MySQL
SQLAI.ai

Integrations

AWS IoT
Amazon DynamoDB
Amazon Quantum Ledger Database (QLDB)
Amazon Redshift
MySQL
SQLAI.ai

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

Database of Databases

Founded

2000

Country

United States

Website

dbdb.io/db/infinidb

Vendor Details

Company Name

PartiQL

Website

partiql.org

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

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

Alternatives

InfiniTime 7.0 Reviews

InfiniTime 7.0

Inception Technologies

Alternatives

InfiniGuard Reviews

InfiniGuard

Infinidat
GraphDB Reviews

GraphDB

Ontotext
Infiny Reviews

Infiny

Epsilon Telecommunications
InfiniBox Reviews

InfiniBox

Infinidat