The C1DataEngine can be used independently for data blending and analysis by executing queries. A query takes data from base tables or from other queries, performs operations on that data such as joining multiple tables, filtering, calculations, grouping, aggregation, and saves results as a new table in the DataEngine.

Query results can then be used in various ways including but not limited to:

• Showing results in a grid (for example, aggregation results, for analysis)
• Feeding results to FlexPivot for analysis (for example, joining several tables so FlexPivot can analyze the joined table)
• Further programmatically transform the results to perform any batch tasks on data

The unique advantage of using DataEngine queries compared with other programming techniques is their exceptional performance. A query can often process millions of records in a second or less. In addition, DataEngine queries support custom operations, which allows you to create user-specific queries for both simple and group operations (aggregation).