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

SQLyog Ultimate serves as a robust solution for MySQL development and administration, allowing database professionals to visually analyze and document schemas while optimizing their structure. This powerful tool offers an automation feature that enables users to schedule data synchronization between two MySQL servers efficiently. Users can easily create job definition files through an interactive wizard, and the tool operates independently of any installation on the MySQL hosts, making it versatile for use with any host. Additionally, SQLyog Ultimate provides an interactive mode for data synchronization, allowing comparisons between source and target data before executing any changes. The user-friendly interface facilitates a detailed examination of data row-by-row, enabling users to make informed decisions on synchronization direction. Furthermore, SQLyog Ultimate also includes capabilities for interactive schema comparison, allowing users to identify differences in tables, indexes, columns, and routines across two databases. This comprehensive functionality makes SQLyog Ultimate an essential asset for any MySQL user looking to enhance their development and administration tasks.

API Access

Has API No 

API Access

Has API No 

Screenshots View All

Screenshots View All

Integrations

MySQL Yes 
Amazon Athena No 
Amazon RDS No 
Amazon Redshift No 
Amazon Web Services (AWS) No 
Apache Cassandra No 
C++Builder No 
Collate No 
Google Cloud BigQuery No 
Google Cloud SQL No 
IBM Informix No 
Microsoft 365 No 
Microsoft Excel No 
MongoDB No 
MongoDB Atlas No 
Oracle Database No 
Percona Backup for MongoDB No 
PostgreSQL No 
SQLite No 
Snowflake No 

Integrations

MySQL Yes 
Amazon Athena Yes 
Amazon RDS Yes 
Amazon Redshift Yes 
Amazon Web Services (AWS) Yes 
Apache Cassandra Yes 
C++Builder Yes 
Collate Yes 
Google Cloud BigQuery Yes 
Google Cloud SQL Yes 
IBM Informix Yes 
Microsoft 365 Yes 
Microsoft Excel Yes 
MongoDB Yes 
MongoDB Atlas Yes 
Oracle Database Yes 
Percona Backup for MongoDB Yes 
PostgreSQL Yes 
SQLite Yes 
Snowflake Yes 

Pricing Details

No price information available.
Free Trial No 
Free Version No 

Pricing Details

No price information available.
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 Yes 
On-Premises No 
iPhone App Yes 
iPad App No 
Android App No 
Windows Yes 
Mac Yes 
Linux Yes 
Chromebook No 

Customer Support

Business Hours No 
Live Rep (24/7) No 
Online Support Yes 

Customer Support

Business Hours Yes 
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 No 
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

Webyog

Country

United States

Website

webyog.com/product/sqlyog/

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 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 

Alternatives

InfiniTime 7.0 Reviews

InfiniTime 7.0

Inception Technologies

Alternatives

InfiniGuard Reviews

InfiniGuard

Infinidat
Infiny Reviews

Infiny

Epsilon Telecommunications
DBeaver Community Reviews

DBeaver Community

DBeaver Corp.
InfiniBox Reviews

InfiniBox

Infinidat