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 RDS No 
C++Builder No 
Collate No 
Google Cloud BigQuery No 
Google Cloud Platform No 
Greenplum No 
IBM Cloud No 
IBM Db2 No 
IBM Informix No 
MariaDB No 
MongoDB No 
MongoDB Atlas No 
Percona Backup for MongoDB No 
PostgreSQL No 
SQL Server No 
SQLite No 
Snowflake No 
Teradata VantageCloud No 
VoltDB No 

Integrations

MySQL Yes 
Amazon RDS Yes 
C++Builder Yes 
Collate Yes 
Google Cloud BigQuery Yes 
Google Cloud Platform Yes 
Greenplum Yes 
IBM Cloud Yes 
IBM Db2 Yes 
IBM Informix Yes 
MariaDB Yes 
MongoDB Yes 
MongoDB Atlas Yes 
Percona Backup for MongoDB Yes 
PostgreSQL Yes 
SQL Server Yes 
SQLite Yes 
Snowflake Yes 
Teradata VantageCloud Yes 
VoltDB 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