Semantic SQL queries are no different in syntax than the standard SQL queries known to every data engineer, data scientist or analyst. However, despite the syntax being the same, Semantic SQL queries deliver a significant advantage: consumers benefit from a 360° view of data without JOINs and UNIONs, so query complexity is eliminated and time to value is dramatically reduced.
So how exactly does Timbr enable Semantic SQL?
Timbr enables users to create a virtual semantic business model that provides meaning to the many tables and columns of data, using abstract concepts that represent common business terms, such as: Customer, Location, Product, Transaction¸ etc. Concepts are then mapped to the underlying data stored in single or multiple sources, so each concept provides a 360° view of data by integrating the available sources and encapsulating relationships.
Concepts can represent aggregated or filtered data, and can also be used to define hierarchies and classifications of data applying logic with simple SQL statements.
Once the model is ready, data consumers use standard SQL to query the business model concepts (thus Semantic SQL) instead of querying the underlying data, allowing users to benefit from semantic reasoning features and graph capabilities that make SQL queries considerably less complex.
Click here to learn how you too can benefit from Timbr’s unique Semantic SQL.
