| TigerLogic® Dynamic Data Hub
Solution Overview
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 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 XML Data Management Server (XDMS) 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 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).
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 XDMS XML database has all of the functionality required of an enterprise database including XA transaction compliance, security, replication and HA clustering. The TigerLogic XDMS XQuery engine provides access to the TigerLogic XDMS 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 XDMS XQuery is compiled into byte code for high performance and can also be deployed as XQuery stored procedures. TigerLogic XDMS XQuery has an Application Programming Interface (API) for Java, .NET (ADO), JCA 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 – 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@tigerlogic.com.
|