|
|
| |
Subscribe
to QueryObject Newsletter!
|
| |
|
A
R C H I T E C T U R E
|
|
QueryObject SYSTEM architecture is modular in design and
consists of following components:
 |
| |
|
Back-end middleware
|
|
The
Back-end
middleware provides a simple means of
connecting to relational and non-relational data sources
(Oracle, MS SQL Server, DB2, SAP/BW, flat files, etc.).
With support for most standard databases and file
formats (over 22 natively) and with versions on most
common computing platforms UNIX (Sun, Compaq, HP) and
Windows (NT, 2K, XP), back-end middleware is ready for
large-scale deployment in any enterprise. The back-end
middleware enables both connections to data sources
residing locally on the user machine, and connections to
remote data sources. Its functions as a universal
relational source by simultaneously accessing multiple
data sources and viewing them as a single, integrated
virtual database: Back-end middleware allows to make
joins across multiple data sources with a single SQL
statement, and then it exploits each data source’s
native capabilities to carry out the joins in the most
efficient way. Through native adapters, it takes
advantage of platform specific features to improve
performance and compensate sources with limited or no
SQL support; this feature shields developers from
differences among data sources. The result is a very
fast and straightforward consolidation of a large volume
of disparate data. Moreover, QueryObject can be used
themselves as an optimized upstream data source, for
more complex analytical applications, requiring the
integration of transactional data with pre-aggregated
data views
provides a simple means of connecting to your relational
and non-relational data sources (Oracle, MS SQL Server,
DB2, SAP/BW, flat files, etc.). With support for most
standard databases and file formats (over 22 natively)
and with versions on most common computing platforms
UNIX (Sun, Compaq, HP) and Windows (NT, 2K, XP), Data
Gateway is ready for large-scale deployment in any
enterprise. |
c |
|
Engine
|
|
The QO ENGINE
is the module for launching and managing the QueryObject
creation process. QO Engine consists mainly of three
modules: |
 |
Loader: extracts, using parallel loading
architecture, selected source data and stores them into
a proprietary, optimized and denormalized ODS format –
QueryObject Ready File (QORF). This file uses an
optional special data-condensation algorithm to provide
an additional up to 80% reduction in size compared to
the input data. An interesting side effect of this
condensation is the improved performance resulting from
dealing with much smaller files, which has a proprietary
structure that facilitates fast random access.
QueryObject ReadyFile can be updated through row based
and/or append processes. |
|
|
Builder: Using XML based informational model the
builder is particularly appropriate to compile
analytical data, based on records stored in Ready File,
with pre-calculated answers corresponding to every
possible combination of analysis variable and numeric
facts. query user can formulate on the Informational
model. The aggregation process has been extensively
optimized and parallelized over the last 10 years
providing unparalleled performance in build times. |
|
|
SOAP Server: SOAP Server has been designed for
remotely performing the main Engine processes management
and control. Soap Server enable the integration of
engine module in Service Oriented Architectures. |
| c |
|
Front-end
middleware
|
| It’s a set of API and
Connectors for the access to the proprietary QueryObject
structures its mainly composed of: |
|
|
Qod HBF Access drivers & API: The access to the
proprietary structure storing compressed database images
and aggregated data can be executed through an ODBC
driver that, through standard SQL syntax, let the
extraction of all or part of denormalized detail data or
aggregated ones. A High speed ODBC-JDBC Bridge is
available to let JDBC access from Java applets,
applications, servlets or application servers to the
QueryObject data. Full documented API complete, access
options to QueryObject. These API allow the build of
customized applications that exploit the exceptional
data storage optimization for unleashing efficient data
replica for massive data movement processes and
analytical information access. |
|
|
QO EII Middleware: QO EII Middleware supports the
analysis of large volumes of information over the
Internet, corporate networks, or on standalone PCs,
spreading the Query Object’s powerful data analysis
capabilities over an unlimited numbers of users.
QueryObjects hosted by the EII Middleware can be
accessed using the most popular BI toolkits (Excel,
Brio, Business Objects, Cognos etc.) that access
QueryObjects using standard SQL statements issued
through an ODBC or JDBC driver. The QueryObject
structure is seen by these tools as a relational table.
Furthermore, QO EII Middleware let the users join the QO
Holograms to external tables, residing on RDBMS or other
compliant databases or flat files, within a
cross-platform architecture delivering a superior level
of rich information view. QueryObject EII Middleware is
available on UNIX, Windows and Linux platforms. The
fully pre-calculated nature of the QueryObject
analytical sub-structures enables the EII Middleware to
support a large number of concurrent users, providing
centralized maintenance and management of the objects as
well. The server provides virtually instant, consistent
query response, allowing existing BI tools to offer more
data, to more concurrent users, with higher user
satisfaction and without intensive hardware upgrades. |
|
The QO Engine runs on UNIX, Windows and Linux servers
allowing organizations to save time by processing the
data directly on the platform on which they are stored. |
|
c |
|
QO Tools
|
| Voyager: .NET
application that allows a smooth and comfortable
experience when preparing projects and running them on a
local or remote QueryObject Engine. Voyager incorporates
in a user friendly interface several management features
that speed-up the process of QueryObject modeling. |
The combination of
multilevel-based access rights provides the Security
Administrator with the flexibility to customize security
for any application.
Moreover, LDAP servers are used to provide a central
repository of single users or group accounts for
security, enabling a simple and centralized security
administration. |
QO Security Manager is available on UNIX and Windows
platform.
It is included in the QueryObject System Security
edition. |
|
a |
|
c |
|
|
|
|
|
|
|
|
|
| "We
have found an optimized software tool which allows us
to analyze several tens of millions of daily Call Detail
Records over a long timescale in great detail and faster
speed than we thought possible."
Bradley Rockwell, Circuit & Traffic Systems Manager, MCI
WorldCom
|
|
|
| "The
QueryObject is an ideal environment for high-volume
Business Intelligence analysis over intranets and
Internets.
The QueryObject represents large amounts of source data
in a small, manageable object, and it delivers consistent
query speed regardless of the data volume. Its virtually
instantaneous query response against any data volume
will deliver critically important user satisfaction."
Bob Moran, Vice President, DSS Research, Enterprise Business
Applications at the Boston-based Aberdeen Group
|
|
| |
Want more information?
|
| |
|
