Technology and Features
Technology and Features#
Broad connectivity to Data Sources#
Querona can directly connect to over 200 data source types like relational, MPP, NoSQL, SaaS, CRM’s, or Social Media and supports data access technologies like ODBC, JDBC, and ADO.Net.
For a full list of supported data sources please consult the Data sources article.
Emulation of SQL Server#
Querona’s emulation of Microsoft SQL Server allows any client supporting connectivity to SQL Server to connect to Querona.
Emulation delivers compatibility with the following SQL Server features:
Metadata model exposed by SQL Server, including metadata catalog, system views, stored procedures, and functions
SQL dialect supported by SQL Server
Tabular Data Stream network protocol as described in Microsoft TDS documentation
Data types and conversions (data types from sources are automatically converted into equivalent SQL Server data types)
Procedural programming constructs: IF, WHILE, DECLARE
Temporary tables (stored in memory)
Selected SQL session environment variables
Security model (object-level permissions, row-level security, and data masking)
Authentication using Windows Integrated Authentication and SQL Server Standard Authentication (Mixed Mode)
Job scheduling model and accompanying stored procedures
Connectivity to Querona was verified using notable tools and technologies listed below.
Analytical, reporting, or development tools (not a complete list):
Microsoft SQL Server Management Studio
Data access technologies:
Built-in Apache Spark#
Apache Spark engine is built into Querona. No configuration is needed and a standalone instance of Spark is ready to use for querying and data storage. To utilize the power of Spark users do not have to learn to code in Scala or SparkSQL, because everything is wrapped and hidden by Querona’s emulation of Microsoft SQL Server.
Querona traces and maintains the metadata lineage using all created objects and their dependencies. Each view’s dependency graph can be examined graphically and searched.
Querona is a columnar data virtualization engine. Incoming rows of data are converted into a columnar format for high parallelism and high-performance processing. Outgoing results are converted into rows for compatibility with the SQL Server protocol (TDS).
Compared to classic, flow-based ETL tools, Querona implements ETL responsibilities differently. Most of the processing requirements can be expressed using SQL and Views and that is the approach in Querona.
Virtual Databases are wrappers over a data source to provide direct access to data, or created over many supported data processing engines, that may be used for data integration and materialization.
Views may depend on each other and blend data using the full power of SQL language.
Views created in Querona’s virtual databases are materializable (aka. cachable).
Many processing-engine-dependent strategies can be utilized, for example, in-memory materialization (caching) or persistent materialization using table rotation.
SQL Server’s restrictions of so-called “indexed views” do not apply to Querona.
Transparent data pseudonymization#
Data pseudonymization works transparently for the end user. If any user decides to cache sensitive data on the untrusted system, Querona will automatically detect that sensitive data is being stored and will encrypt the data. The user will not detect that encryption happened because he or she will see real data, even if processing happened on an untrusted system.
For more information see Data Security.
The use of pre-computed aggregate data is a technique to address performance challenges in Data Warehouse systems (DW). An aggregate retargeting mechanism redirects a query to an available physical aggregate when possible. The adoption of aggregates is completely transparent to the users.
For more information see Overview of Query Retargeting.
Flexible deployment model#
Querona can be deployed using the following models:
on-premise, using a physical or virtual machine with Windows (server and desktop)
hybrid (mixed), on-premise, cloud, or desktop computer
Multilanguage user interface#
Querona supports the following GUI localizations: