sales@x88.com
+44 118 324 1000
Panorama Database Engine
Accelerate your data applications
Panorama is a completely new kind of intelligent database server that
provides ultra-fast interrogation, analysis, manipulation, aggregation and
transformation of enterprise-scale data with zero design or administration.
Designed to be embedded into 3rd party applications, it
forms the core of our X88 Pandora product.
Data can be loaded of any quality, with the correct structure, relationships and content automatically evaluated from the data. Panorama automatically assesses the quality of data and creates navigation structures to allow for ultra-fast querying, filtering, aggregation and transformation of data using simple and familiar SQL statements. Data is never rejected.
Panorama automatically relates all tables and columns together that have common values, discovering relationships across the entire Enterprise based on the actual data content itself, not just semantics.
It runs on everything from a laptop to a multi-core server and turns raw data into business information with simplicity. The value centric storage model employed means that data values are only ever stored once regardless of how many tables or columns a value appears in. As a result, every Row/Column location of every value is automatically indexed.
Panorama instantly identifies Joins being Tables, duplicate data, and much more. The advanced query engine breaks down SQL statements to take advantage of the internal structure and can answer many questions prior to query execution which means no table scans and no manual indexing.
Over 200 transformation, cleansing, manipulation and aggregation functions are provided that are the match of any Data Integration product. They are executed in real-time so there is no need to build an entire result set to see the result of an expression, even for multi-column table lookups. Panorama also provides a customisable self-creating metadata repository and a full business glossary to classify data in business terms. Panorama allows exactly the same query capabilities for the repository and glossary as it does for data.
Data can be loaded of any quality, with the correct structure, relationships and content automatically evaluated from the data. Panorama automatically assesses the quality of data and creates navigation structures to allow for ultra-fast querying, filtering, aggregation and transformation of data using simple and familiar SQL statements. Data is never rejected.
Panorama automatically relates all tables and columns together that have common values, discovering relationships across the entire Enterprise based on the actual data content itself, not just semantics.
How Panorama Works
Panorama combines the best aspects of Relational, Column-Oriented and Correlation database technologies to provide astounding performance with a familiar SQL interface. It has built-in market-leading profiling, quality and transformation capabilities.It runs on everything from a laptop to a multi-core server and turns raw data into business information with simplicity. The value centric storage model employed means that data values are only ever stored once regardless of how many tables or columns a value appears in. As a result, every Row/Column location of every value is automatically indexed.
Panorama instantly identifies Joins being Tables, duplicate data, and much more. The advanced query engine breaks down SQL statements to take advantage of the internal structure and can answer many questions prior to query execution which means no table scans and no manual indexing.
Over 200 transformation, cleansing, manipulation and aggregation functions are provided that are the match of any Data Integration product. They are executed in real-time so there is no need to build an entire result set to see the result of an expression, even for multi-column table lookups. Panorama also provides a customisable self-creating metadata repository and a full business glossary to classify data in business terms. Panorama allows exactly the same query capabilities for the repository and glossary as it does for data.
Key Benefits
- Accelerates development time of analytical apps
- Simplifies development for multiple platforms
- Simplifies installation and support with Zero configuration, administration or design
- Reduces development, licensing, installation and support costs
- SQL Database with full query capability
- Data Analysis, Profiling, Quality and Integration
- Data and Metadata exporting
Key Features
- Zero rejection of data on load
- Self-creating Metadata repository
- Loads data from any file or database
- Flexible Business Glossary built-in
- Extended SQL for querying data and metadata
- Automatically discovers joins between Tables
- Automatically discovers common value Domains
- Automatic Data Profiling and Statistical Analysis
- Automatic format and phonetic pattern analysis
- Discovers multi-column keys and functional dependencies from data
- Fuzzy enterprise ranked searching of data
- Every value in every Column and Table indexed
- Multi-dimensional aggregation and sorting
- Supports Views of Tables and other Views
- Instant where-used for values and formats anywhere in the database
Technical Highlights
- 100% Java supporting any hardware platform
- 64-bit parallel, scalable architecture
- Over 150 automatic statistics
- Over 200 transformation functions built-in
- Built-in scheduling and management
- Real-time evaluation of SQL function
- Multi-user with high security, and auditing