Aggregation Across Multiple Data Sources

  • Article

This topic describes the ability of the OLE DB Provider for Commerce Server to aggregate profile object data from multiple disparate data sources into a single homogeneous OLE DB Row object.

The data aggregation layer handles requests for fetching specified properties of profile object data, inserting new profile objects, deleting profile objects, updating specified properties of profile object data, and combining the results of running search queries simultaneously across multiple data stores.

The data aggregation layer provides support for the following data source types:

  • Microsoft Active Directory directory service

  • Microsoft SQL Server 2000

  • Line-of-Business (LOB) store with the following support:

    • An OLE DB/Open Database Connectivity (ODBC) provider with support for a simple published subset of ANSI SQL

    or

    • A Lightweight Directory Access Protocol version 3 (LDAPv3) compliant directory store.

The data aggregation layer is optimized for performance and scalability against Active Directory and SQL Server stores.

The data aggregation layer is implemented as four components:

  • Aggregation layer, which is part of the OLE DB Provider for Commerce Server itself.
  • Directory component.
  • Microsoft SQL Server 2000.
  • LOB stores component.

The aggregation layer processes requests by splitting them into sub-requests appropriate to each aggregated data store and passing them to components responsible for those stores.

Copyright © 2005 Microsoft Corporation.
All rights reserved.