Bigdata
Now Reading
CrateDB
0
Review

CrateDB

Overview
Synopsis

CrateDB is a distributed SQL database built on top of a NoSQL foundation. It combines the familiarity of SQL with the scalability and data flexibility of NoSQL, enabling developers to: Use SQL to process any type of data, structured or unstructured.

Category

Document Database

Features

• Dynamic schemas: Add columns anytime without slowing performance or downtime
• Geospatial queries: Store and query geographical information using the geo_point and geo_shape types
• SQL with integrated search for data and query versatility
• Container architecture and automatic data sharding for simple scaling
• Indexing optimizations enable fast, complex cybersecurity analyses
• Performance-monitoring tools

License

Proprietary

Price

Contact for Pricing

Pricing

Subscription

Free Trial

Available

Users Size

Small (<50 employees), Medium (50 to 1000 employees), Enterprise (>1001 employees)

Company

CrateDB

What is best?

• Geospatial queries: Store and query geographical information using the geo_point and geo_shape types
• SQL with integrated search for data and query versatility
• Container architecture and automatic data sharding for simple scaling
• Indexing optimizations enable fast, complex cybersecurity analyses
• Performance-monitoring tools

What are the benefits?

• Transactional: Allows synchronous real-time access to single records, immediately after they are written
• Scalable: Automatically shards and redistributes data across the cluster as it changes size to optimize performance
• Real-time speed: Distributed, columnar field caches enable in-memory SQL query performance
• Built-in high availability: Automatic replication & self-healing for non-stop performance

PAT Rating™ ( Beta)
Editor Rating
Aggregated User Rating
Rate Here
Ease of use
7.6
8.8
Features & Functionality
7.6
9.2
Advanced Features
7.6
8.8
Integration
7.6
Performance
7.6
Customer Support
7.6
4.0
Implementation
Renew & Recommend
Bottom Line

CrateDB is a distributed SQL database that makes it simple to store and analyze massive amounts of machine data in real-time.

7.6
Editor Rating
7.7
Aggregated User Rating
1 rating
You have rated this

CrateDB is a distributed SQL database built on top of a NoSQL foundation. It combines the familiarity of SQL with the scalability and data flexibility of NoSQL, enabling developers to: Use SQL to process any type of data, structured or unstructured; Perform SQL queries at real time speed, even JOINs and aggregates and scale simply. CrateDB’s distributed SQL query engine features columnar field caches, and a more modern query planner. These give CrateDB the unique ability to perform aggregations, JOINs, sub-selects, and ad-hoc queries at in-memory speed. CrateDB also integrates native, full-text search features, which enable users to store and query structured or unstructured data together. Automatic replication of data across the cluster and rolling software updates help ensure hardware failures and scheduled maintenance do not interrupt access to data. In addition, CrateDB clusters are self healing, so when nodes are added to the cluster, CrateDB automatically loads them with data. Analytic data is often loaded in batches, with transactional locks and other overhead. By contrast, CrateDB eliminates locking overhead to enable massive write performance (e.g. 40.000+ inserts per second per node on commodity hardware). Furthermore, CrateDB can deliver millisecond-speed query performance, even when writes are in action. All nested JSON attributes can be included in any SQL command. CrateDB makes time series analysis fast and easy with automatic table partitions, which are like virtual tables that can be queried, moved or deleted. Partitioning data by time intervals delivers very fast time series query performance. It offers Optimistic Concurrency Control by providing an internal versioning that allows detection and resolution of write conflicts.

Filter reviews
User Ratings





User Company size



User role





User industry





Ease of use
Features & Functionality
Advanced Features
Integration
Performance
Customer Support
Implementation
Renew & Recommend

What's your reaction?
Love It
0%
Very Good
0%
INTERESTED
0%
COOL
0%
NOT BAD
0%
WHAT !
0%
HATE IT
0%