Mixed Workload Management

1010data naturally handles mixed workloads and delivers performance and features unmatched by any competing technology.

Near-Real-Time Updates

A well-known issue with concurrent updates and queries is that each successive query may see a different version of the data. Since a typical report or analysis is built with multiple database queries, the report will be based on inconsistent data and will lack integrity. Some vendors have attempted to address this issue to varying degrees of success, but a true solution to the problem must go beyond any of those approaches.

Suppose for example that two users (or applications) are accessing the database while it is being updated in real time. The first is running queries that are independent of one another and desires the latest possible data for each query. In contrast, the second user wants an unchanging view of the data so that he or she can interact with the database and run various queries over an extended period of time, all of which need to be consistent.

This problem may seem intractable but in fact 1010data solved it ten years ago. Our system automatically allows for this sort of thing and we use it in virtually all our databases and applications. That is why we have always said - and can continue to say - that 1010data databases are available 24/7, even during updates.

Mixed Query Types

Another well-known issue with mixed workloads is balancing complex, ad-hoc analytics with high-traffic BI-type queries and reports. 1010data's distributed, parallel architecture is ideally suited to this type of environment and numerous POCs have demonstrated our superiority in handling this type of mixed workload.