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 Studio for MySQL is a multi-featured IDE that covers nearly every aspect of MySQL and MariaDB development, management, administration, data analysis, and reporting. The rich feature set of the Studio is augmented by a clean and intuitive GUI and CLI-powered automation capabilities.
Key features:
Database Development.
dbForge Studio for MySQL offers quite a few features to streamline routine SQL coding and ensure the high quality of the output.
For example:
*SQL coding assistance
*Query Profiler
*MySQL Debugger
*Visual Query Builder
*Source Control. Using dbForge Studio for MySQL, you can set up and streamline effective version control of database schemas and static table data.
Database Design.
In terms of database design, the Studio provides visual object editors and handy functionality that helps you visualize databases on entity-relationship diagrams.
Database Management.
The Studio delivers a set of features for effective and versatile database management.
Data Analysis & Reporting.
dbForge Studio for MySQL facilitates data aggregation, analysis, and reporting.
Database Administration.
There are also integrated features to ensure quick and smooth database administration.
API Access
Has API
API Access
Has API
Pricing Details
No price information available.
Free Trial
Free Version
Pricing Details
$9.95
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
Devart
Founded
1997
Country
Czech Republic
Website
www.devart.com/dbforge/mysql/studio/
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