Database performance for business intelligence and analytics is all about how fast you can get data in, and how fast you can get data out in a useful format. And if you can do both at the same time – load data and simultaneously query data – and do it at high velocity with the massive data volumes inherent in Big Data analytics, then you’ve got something that is genuinely unique. This is exactly the breakthrough in relational database performance JustOne has achieved, without sacrificing any of the traditional advantages of a relational database.
JustOneDB excels at getting data in fast and, in fact, loads data comparable in speed to writing data to a flat file. Fast data loading is essential when working with the enormous volume of data underlying Big Data analytics efforts. In practical terms, this means no database down-time for the business users and no more missed service-level-agreements as data volumes grow and batch processing windows remain unchanged.
JustOneDB is equally adept at making data accessible and useful very quickly through highly selective queries and broad aggregate queries, with both styles being required for effective Big Data analytics. For highly selective queries, JustOneDB behaves as a traditional row-store database with every column indexed – delivering fast selective queries while offering complete flexibility for querying, without incurring any of the customary performance trade-offs inherent in creating indexes. For aggregate queries, JustOneDB delivers performance comparable to the best columnar databases, but without sacrificing selective query performance.
JustOneDB achieves this performance on a modest hardware footprint of commodity servers without resorting to large amounts of memory or the massively parallel processing approach that is so common among other solutions attempting to offer similar performance.
JustOneDB breaks the longstanding linkage between database size and database performance, thereby enabling an entirely new perspective on database system design. In each of the dimensions of scalability – load performance, query performance, and the ability to support large volumes of data – with JustOneDB the size of the database has essentially no relationship to loading or query performance. Rather, CPU and memory requirements are determined by database workload, which is the volume and speed at which data needs to be loaded, how many concurrent users need to be supported, and what types of queries they will be running.
Agility is the ability to quickly respond and adapt to new and unanticipated requirements, and this is an area where traditional relational database design struggles and JustOneDB’s unique performance profile offers substantial benefit. With JustOneDB, the traditional need to make design-time database optimization trade-offs that constrain future flexibility is eliminated.
Databases deliver value at the intersection of performance, scalability, agility and cost – and it is at this intersection that JustOneDB fundamentally changes the value equation for relational databases. This is critically important as organizations must demonstrate a business intelligence ROI, and where Big Data analytics makes scaling traditional high-performance database solutions cost-prohibitive.
Complete Agility JustOneDB means no more design-time choices that constrain what the business can do with data months or years down the road. JustOneDB offers the agility to quickly respond to new and changing business requirements — not only will business users be satisfied, but the need for the information technology team to rip-and-replace with a new database project or Big Data tools in a few years’ time is also eliminated.
Easy Scalability JustOneDB scales to extreme data volumes simply by adding low-cost, high-capacity disk drives without a corresponding increase in CPUs, memory or architectural complexity in the database project. This is unique in the market for Big Data tools, and is of immediate value for virtually any volume of data, while being an absolute requirement for a solution to be practical and affordable for Big Data analytics.
Most Cost-Effective With JustOneDB, cost is not only about spending less, but about making business intelligence ROI a reality through entirely new ideas and data management strategies. JustOneDB makes it possible to capture, retain and extract value from more data than ever before — thereby creating completely new insights, innovative information products and other uses of data that would otherwise not be possible.
Drop-in, Legacy Compatible JustOneDB is a standards-compliant, full-featured, 100% ACID relational database management system. As such, all of your current skills and tools work with JustOneDB and there’s no need for expensive retraining or recruiting individuals with specialized and scarce skill sets. Database migration to JustOneDB from a traditional RDBMS is straightforward with no need for redesign or database optimization.