Pandora Architecture


X88 Pandora is a self-contained, client/server product which runs on any java-compliant platform using commodity hardware. It takes full advantage of 64-bit technology and multiple CPUs to scale linearly.

Underpinning the unique capabilities of Pandora is a ground-breaking data and metadata engine that is self-configuring, self-indexing, self optimising and entirely dedicated to data management.

Pandora only ever stores data values once and provides ultra-fast analysis, discovery, manipulation, aggregation and transformation of enterprise-scale data with zero design or administration.

Pandora is resilient and provides multi-user, role-based security allowing teams to collaborate regardless of their location.



Pandora requires no components from other vendors or organisations, therefore there are none of the complications, problems or delays usually experienced due to compatibility issues with CPU architecture, operating system versions, software patch level incompatibilities, database versions, and so on.

Pandora is robust and tolerates any kind of hardware or network failure. User state is automatically memorised and restored if necessary.

Pandora never rejects data, it loads whatever it is given, analysing, categorising and storing it automatically.

Since there is no database schema and data is not stored in records, no database administration is required.

A single Pandora environment supports multiple character sets, including double-byte.
X88 Software - The Data Interrogation Company<br/>X88 Pandora Database Engine - Get your applications into the fast-lane

Key Features

  • Zero rejection of data on load
  • Self-creating Metadata repository
  • Loads data from files, spreadsheets and databases
  • 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 from data
  • Discovers functional dependencies from data
  • Fuzzy enterprise ranked searching of data
  • Every value in every Column and Table effectively indexed
  • Multi-dimensional aggregation and sorting
  • Supports Views of Tables and other Views
  • Instant where-used for values anywhere in the database
  • Instant where-used for formats anywhere in the database
  • Over 180 Column statistics
  • Over 300 transformation functions built-in
  • Built-in scheduling and management
  • Real-time evaluation of SQL function
  • Multi-user with high security, and auditing