Average Ratings 0 Ratings
Average Ratings 0 Ratings
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
dbForge's Query Builder for MySQL allows you to create any type of MySQL query, from simple lookups up to complex JOINS. The tool offers a wide range of compatibility options, and allows you to construct and edit complex MySQL queries with just a few clicks. You don't have to worry about writing complex code, just "draw" the query on a chart.
Key Features
• Powerful visual MySQL query builder functionality
The MySQL statement generator allows you to edit tables and execute queries.
• Use the visual MySQL query editor to combine a few queries into a sub-query
• Manage databases proactively
• Easy to join tables
Find trends in mountains of data
Reduce the time spent on complex queries
The official Devart site is always the best place to find the latest version.
API Access
Has API
No
API Access
Has API
No
Pricing Details
No price information available.
Free Trial
No
Free Version
No
Pricing Details
79.95 $
Free Trial
Yes
Free Version
No
Deployment
Web-Based
No
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
No
Mac
No
Linux
Yes
Chromebook
No
Deployment
Web-Based
No
On-Premises
No
iPhone App
No
iPad App
No
Android App
No
Windows
Yes
Mac
No
Linux
No
Chromebook
No
Customer Support
Business Hours
No
Live Rep (24/7)
No
Online Support
Yes
Customer Support
Business Hours
No
Live Rep (24/7)
No
Online Support
Yes
Types of Training
Training Docs
Yes
Webinars
No
Live Training (Online)
No
In Person
No
Types of Training
Training Docs
Yes
Webinars
Yes
Live Training (Online)
No
In Person
No
Vendor Details
Company Name
Database of Databases
Founded
2000
Country
United States
Website
dbdb.io/db/infinidb
Vendor Details
Company Name
Devart
Founded
1997
Country
United States of America
Website
www.devart.com/dbforge/mysql/querybuilder/
Product Features
Database
Backup and Recovery
No
Creation / Development
No
Data Migration
No
Data Replication
No
Data Search
No
Data Security
No
Database Conversion
No
Mobile Access
No
Monitoring
No
NOSQL
No
Performance Analysis
No
Queries
No
Relational Interface
No
Virtualization
No
Product Features
Database
Backup and Recovery
No
Creation / Development
Yes
Data Migration
No
Data Replication
No
Data Search
No
Data Security
No
Database Conversion
No
Mobile Access
No
Monitoring
No
NOSQL
No
Performance Analysis
No
Queries
No
Relational Interface
No
Virtualization
No