InfiniDB

InfiniDB

Database of Databases
+
+

Related Products

  • Google Cloud SQL
    554 Ratings
    Visit Website
  • DbVisualizer
    584 Ratings
    Visit Website
  • Google Cloud BigQuery
    2,023 Ratings
    Visit Website
  • Teradata VantageCloud
    1,124 Ratings
    Visit Website
  • RaimaDB
    12 Ratings
    Visit Website
  • Windocks
    7 Ratings
    Visit Website
  • Concord
    237 Ratings
    Visit Website
  • StrongDM
    102 Ratings
    Visit Website
  • Bitrise
    401 Ratings
    Visit Website
  • Google Cloud Platform
    61,023 Ratings
    Visit Website

About

InfiniDB is a column-store DBMS optimized for OLAP workloads. It has a distributed architecture to support Massive Paralllel Processing (MPP). It uses MySQL as its front-end such that users familiar with MySQL can quickly migrate to InfiniDB. Due to this fact, users can connect to InfiniDB using any MySQL connector. InfiniDB applies MVCC to do concurrency control. It uses term System Change Number (SCN) to indicate a version of the system. In its Block Resolution Manager (BRM), it utilizes three structures, version buffer, version substitution structure, and version buffer block manager, to manage multiple versions. InfiniDB applies deadlock detection to resolve conflicts. InfiniDB uses MySQL as its front-end and supports all MySQL syntaxes, including foreign keys. InfiniDB is a columnar DBMS. For each column, InfiniDB applies range partitioning and stores the minimum and maximum value of each partition in a small structure called extent map.

About

Snowflake is a comprehensive AI Data Cloud platform designed to eliminate data silos and simplify data architectures, enabling organizations to get more value from their data. The platform offers interoperable storage that provides near-infinite scale and access to diverse data sources, both inside and outside Snowflake. Its elastic compute engine delivers high performance for any number of users, workloads, and data volumes with seamless scalability. Snowflake’s Cortex AI accelerates enterprise AI by providing secure access to leading large language models (LLMs) and data chat services. The platform’s cloud services automate complex resource management, ensuring reliability and cost efficiency. Trusted by over 11,000 global customers across industries, Snowflake helps businesses collaborate on data, build data applications, and maintain a competitive edge.

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Platforms Supported

Windows
Mac
Linux
Cloud
On-Premises
iPhone
iPad
Android
Chromebook

Audience

Developers, professionals, and enterprises seeking a column-store database solution optimized for OLAP workloads

Audience

Organizations interested in a powerful and comprehensive cloud data platform

Support

Phone Support
24/7 Live Support
Online

Support

Phone Support
24/7 Live Support
Online

API

Offers API

API

Offers API

Screenshots and Videos

Screenshots and Videos

Pricing

No information available.
Free Version
Free Trial

Pricing

$2/credit
Pay for the compute and storage you actually use.
- Turn compute resources on and off, so you only pay for what you use
- Store near-unlimited amounts of data at affordable cloud rates
- Grow your analytics infrastructure with linear cost scalability
Free Version
Free Trial

Reviews/Ratings

Overall 0.0 / 5
ease 0.0 / 5
features 0.0 / 5
design 0.0 / 5
support 0.0 / 5

This software hasn't been reviewed yet. Be the first to provide a review:

Review this Software

Reviews/Ratings

Overall 4.8 / 5
ease 4.8 / 5
features 5.0 / 5
design 4.8 / 5
support 4.8 / 5

Pros & Cons from Real Users

Pros

  • Snowflake is being used across our whole organization. It addresses the need to combine disparate data sources into one single data source and discover insights into our business that would not be easily possible with lots of disconnected data sources. It has great SQL features like LISTAGG or Count Distinct, which go above and beyond Oracle and MS SQL. - Reporting queries run in a fraction of the time that they would in our production systems - We can run simple SQL queries. - Scales up and down seamlessly - Optimized table structures under the hood - Sharing data between accounts - Easy if use - Continuous data pipelines - Snowflake also includes caching at various levels to help speed up your queries and minimum costs. - Support members are very good.
  • Snowflake is acting as a company-wide Data Repository. With its cloud architecture and scalability, it addresses our storage, warehouse, and computation problem at the same time. Snowflake has powerful group roles and policy, which makes it beneficial for enterprise edition and usage. Snowflake acts as a single platform for both data storage and warehousing needs. For deployment purposes, it has the best group policy management and the best UI I've encountered personally. It also accommodates direct connection with AWS and Azure, which is another advantage. - Hosted on cloud: Helps with scalability. - Handling large data scale and ingestion - Separation of compute and storage - Community is active and ever-growing: You will have someone from the community to help whenever you need it.
  • Simple & clean interface Great querying performance Integration with all the major cloud providers Easy to learn querying language Good documentation
  • (+) Easy to adapt and easy to use. (+) The run time of queries is much faster compared to other products in the market. (+) One can select a part of a query for execution. (+) Integration with S3 and other data storage platforms makes snowflake more compatible. (+) One may run concurrent queries without giving up on speed.

Cons

  • Nothing to dislike in Snowflake. Awesome data warehouse for huge data set.
  • - Very expensive - Indexing by primary key is non performant
  • Web based IDE is not suitable for writing complex queries, it feels sluggish when heavily used.
  • (-) Performance drops in the case of multiple users. (-) No option for scheduling of a task or a query. (-) The coding syntax has some restrictions like the case-sensitivity issue.

Training

Documentation
Webinars
Live Online
In Person

Training

Documentation
Webinars
Live Online
In Person

Company Information

Database of Databases
Founded: 2000
United States
dbdb.io/db/infinidb

Company Information

Snowflake
Founded: 2012
United States
www.snowflake.com

Alternatives

InfiniGuard

InfiniGuard

Infinidat

Alternatives

InfiniTime 7.0

InfiniTime 7.0

Inception Technologies
InfiniBox

InfiniBox

Infinidat
Infiny

Infiny

Epsilon Telecommunications
TrinityX

TrinityX

Cluster Vision

Categories

Categories

Database Features

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

Data Warehouse Features

Ad hoc Query
Analytics
Data Integration
Data Migration
Data Quality Control
ETL - Extract / Transfer / Load
In-Memory Processing
Match & Merge

ETL Features

Data Analysis
Data Filtering
Data Quality Control
Job Scheduling
Match & Merge
Metadata Management
Non-Relational Transformations
Version Control

Integrations

Akitra Andromeda
Appenate
Aqua Data Studio
Avalor
Bloomreach
CData Sync
CaptivateIQ
Coginiti
Comet LLM
DataOps.live
Fabi.ai
HStreamDB
InsurSuite
Inte Q Genesis
Key Ward
Knowi
Opsera
Surf AI
Toolio
Yogi

Integrations

Akitra Andromeda
Appenate
Aqua Data Studio
Avalor
Bloomreach
CData Sync
CaptivateIQ
Coginiti
Comet LLM
DataOps.live
Fabi.ai
HStreamDB
InsurSuite
Inte Q Genesis
Key Ward
Knowi
Opsera
Surf AI
Toolio
Yogi
Claim InfiniDB and update features and information
Claim InfiniDB and update features and information
Claim Snowflake and update features and information
Claim Snowflake and update features and information