|  TigerLogic® Dynamic Data Hub
Solution Overview
Raining Data’s TigerLogic Dynamic Data Hub provides a
central data repository for integrated views of enterprise information
and manages data quality and exceptions. The power of the solution
is that data structures, values and deltas are managed in a
flexible system that is not constrained by the rigid table structure
of a relational database management system (RDBMS). TigerLogic
Dynamic Data Hub is ideal for organizations with dynamic data
sources that need either to synchronize common accurate data
across enterprise systems (Master Data Management), or to aggregate
accurate enterprise data for data warehouse or analytic applications.
The TigerLogic Dynamic Data Hub is quickly deployed in most
customer technical environments. First, an easy-to-use wizard
sets up caches of data and data structures from the legacy systems
of record or data publisher. These caches are either physical
storage or virtual storage through a federated query. Cache
refresh policies are also specified (end of day, every three
hours, etc.). Next, this cached data, including data element
names, data values and exceptions, is mapped to the data hub.
Finally, the data hub is mapped to the data subscriber or to
the structure required by an analytic tool. Exhibit 1 illustrates
the TigerLogic Dynamic Data Hub and the fit with legacy systems
described as data publishers, data subscribers, data warehouses
and analytic tools.
Exhibit
1: TigerLogic Dynamic Data Hub
Dynamic
Data Requirements
Industries
are becoming more competitive and organizations must become
more nimble to compete effectively and efficiently. For example,
new products and product bundles must be brought to market more
quickly or sales regions and territories are changed to drive
up-sell and cross sell opportunities. Additionally, data values
are changing more frequently and these deltas need to be more
closely tracked. For example, according to a recent Sales &
Marketing Institute paper, 62% of business contact information
will change within a single year. Surprisingly few Customer
Relationship Management (CRM) systems take advantage of this
(identifying fast-rising stars in an organization).
To
enable these initiatives, accurate information is critical.
It must be gathered, cleansed, enriched and shared. This has
a large impact for information systems since they need to support
innovation at the business unit level but also support enterprise
information requirements – both real-time (Master Data
Management) and batch (Data Warehouse/Analytics). In order to
meet these business requirements, the data hub technology must:
 |
|
Accept data based on the incoming structure rather than
a predefined rigid structure |
|
|
Allow
data relationships to change and additional details to be
added |
|
|
Trigger
exception handling processes when exceptions occur |
|
|
Trigger
data enrichment processes |
|
|
Handle
multiple data schemas and be able to transform data among
them |
|
|
Record
all data deltas |
|
|
Synchronize
data across legacy systems and provide information to analytic
tools |
TigerLogic
Dynamic Data Hub
TigerLogic
Dynamic Data Hub supports data either physically stored in the
TigerLogic database with data refresh policies or virtually
available through federated queries of the data sources. A key
feature of the TigerLogic Dynamic Data Hub is that the database
structure evolves to handle changing data sources such as legacy
systems, databases, data warehouses and Comma Separated Value
(CSV) files. Specifically, the TigerLogic XML Data Management
Server (XDMS) builds indexes and stores data based on the structure
of the incoming data. For example, if the incoming data structure
changes from 10 fields to 12 or 8, then TigerLogic XDMS represents
the data as XML and evolves to handle both the old structures
as well as the new structure (no unload, rebuild, reload process
is necessary). TigerLogic Dynamic Data Hub also triggers a process
to handle the new data structure (email to a data steward, etc.).
TigerLogic
Dynamic Data Hub also supports the data consumer or analytic
tool by transforming the data into the required structure and
enforcing data security policies (hiding or obfuscating sensitive
data like social security numbers).
The
TigerLogic Dynamic Data Hub intrinsically handles temporal data
or dynamic data values. The TigerLogic XDMS structure allows
nesting so old data values and time stamps can be stored as
sub-elements. This functionality can be easily turned on and
off.
TigerLogic
XDMS Technology
TigerLogic Dynamic Data Hub is built on the TigerLogic XDMS,
which provides a self-evolving, high performance data management
system. It is comprised of two components: an XML database and
an XQuery engine. TigerLogic XDMS has a multi-schema engine,
which can manage multiple, evolving schemas on the same collection.
It provides high performance data management and includes a
64 GB in-memory data cache. The TigerLogic XML database has
all of the functionality required of an enterprise database
including XA transaction compliance, security, replication,
and HA clustering. The TigerLogic XQuery engine provides access
to the TigerLogic XML database as well as other data sources
including relational databases (through JDBC), Web Services,
FTP sites, file systems, Java objects and Web pages. TigerLogic
XQuery is compiled into byte code for high performance and can
also be deployed as XQuery stored procedures. TigerLogic XQuery
has an Application Programming Interface (API) for Java, .NET
(ADO), and Web Services (SOAP). See Exhibit 2.
Exhibit
2: TigerLogic XDMS Architecture
Use
Cases
TigerLogic
Dynamic Data Hub solution is applicable to many different data
management use cases. It’s ideal for technical environments
where data, metadata and relationships are changing in dynamic
ways and a flexible data management infrastructure is required.
|
|
ETL/Data Warehouse – TigerLogic Dynamic
Data Hub either acts as a data warehouse or as a staging
server to an existing ETL/Data Warehouse environment. |
|
|
Master
Data Management (MDM) – TigerLogic Dynamic
Data Hub acts as a custom Customer Data Integration (CDI),
Product Information Management (PIM) or other master data
domain solution. |
|
|
SOA
Enablement of Legacy Data via Data Services Builder
– TigerLogic Dynamic Data Hub caches legacy data and
makes it available through a simple WSDL (Web Services Description
Language). |
Product
Brochure
TigerLogic
Dynamic Data Hub Product Overview (439 KB pdf)
Contact
Us
For
inquiries, please contact TigerLogic Dynamic Data Hub sales
at 949-442-4400 or email
tl-datahub@rainingdata.com.
|
