1 / 19

BU 618 Enterprise Portal Alliance: e-Catalogs for e-Business

BU 618 Enterprise Portal Alliance: e-Catalogs for e-Business. Christi Garvey Vice President Product Development Cohera. Buyers. Sellers. E-Market Platform Technologies. Components work together to provide market transparency. E-Market Hub. Web Servers Apache, Microsoft, Netscape.

axel-workman
Download Presentation

BU 618 Enterprise Portal Alliance: e-Catalogs for e-Business

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BU 618 Enterprise Portal Alliance: e-Catalogs for e-Business • Christi Garvey • Vice President Product Development • Cohera

  2. Buyers Sellers E-Market Platform Technologies Components work together to provide market transparency E-Market Hub • Web Servers • Apache, Microsoft, • Netscape • Transaction Services • WebMethods • CommerceQuest • NetFish, XML • Yantra Web Servers • Application Servers • BEA Weblogic • Sun NetDynamics/Kiva • Silverstream Application Servers Search Technology • Database Sources • Oracle, Sybase, IBM, • Informix, Microsoft • IMS, VSAM, Legacy Mainframe • ERP Systems • Web-centric (HTML, XML) Catalog Services Transaction Services • Search Technology • Alta Vista • Frictionless • Kachinanet Database Sources

  3. Catalog Server Catalog Builder Join Servers Caching Servers Power Search Site Managers Pricing Agent Secure Network Cohera NetQuery Cohera E-Catalog System Components • Catalog Builder-Builds the Cohera E-Catalog • CoheraNetQuery- Scrapes HTML/XML Catalogs • Catalog Server - Integrates and displays live E-Catalogs to buyers • Join Servers - Process complex operations across multiple systems • Caching Servers - Tunable cache of high-demand data • PowerSearch Module - Fuzzy searching across disparate product descriptions, etc. • Site Managers - Provide access control/encryption for each seller site • Pricing Agent - Execute pricing algorithms on demand • SecureNetwork - SSL implementation for ensuring confidentiality and integrity

  4. Cohera Site Manager Cohera Site Manager Cohera Site Manager Cohera Site Manager Cohera Site Manager Cohera Site Manager Cohera E-Catalog System Architecture Web Server RDBMS Application Server Cohera Metadata RDBMS Cohera Catalog Server Cohera Cache RDBMS Static Data Cohera Join Servers • DB/2 • SQLServer • ORACLE • Informix • Sybase . . Flat Files SAP VSAM RDBMS HTML XML

  5. Cohera Catalog Server Category Description Price Discount Avail Gas Eng 10 $599 5% Cash 50 HP Elec Start Gas Eng 75 HP Pull Start $659 25 10% Cash Gas Eng 2 65 HP Elec Start $600 None Gas Eng 5 75 HP Elec Start $799 None Gas Eng 14 65 HP Elec Start $650 5% Cash Gas Eng 22 Price Discount Avail 50 HP Pull Start $499 7% Cash E-Catalog Constructed Dynamically Using SQL Price Discount Avail Supplier “A” Supplier “B” • Constructed “live” in response to SQL Query • Data pulled from source “on demand” • Customer receives up-to-the-second information Category Description Centralized Description

  6. Cohera E-Catalog Category Description Category Description Price Discount Avail Local Description Database Price Discount Avail Price Discount Avail Supplier “B” Database Supplier “A” Database Cohera E-Catalog Schema • E-Catalog looks and acts like a single SQL database • Data sources are mapped to the Cohera E-Catalog schema • Metadata contains the mappings and data transformations required to normalize data from the supplier data sources

  7. Catalog Server Catalog Server • Displays a live integrated E-Catalog to buyers • Supports powerful catalog browsing via standard SQL • Performs query optimization to retrieve requested data for the least cost. • Catalog Server can be distributed across multiple machines or clustered to balance the need for performance and high availability

  8. Site Manager Site Manager Site Manager Supplier Catalog Cohera Catalog Server Category Description Price Discount Avail Gas Eng 10 $599 5% Cash 50 HP Elec Start Gas Eng 75 HP Pull Start $659 25 10% Cash Gas Eng 2 65 HP Elec Start $600 None Gas Eng 5 75 HP Elec Start $799 None Gas Eng 14 65 HP Elec Start $650 5% Cash Gas Eng 22 50 HP Pull Start $499 7% Cash Site Managers Supplier A Supplier B Supplier Catalog Local Descriptions • Receive requests from the Catalog Server • Locate, retrieve and transform data in real-time • Supports disparate data formats Market Hub

  9. Site Manager Join Server 10 $599 5% Cash $659 25 10% Cash 2 $600 None 5 $799 None 14 $650 5% Cash 22 $499 7% Cash Join Servers Supplier Catalog Site Manager Data moved for joining Cohera Catalog Server Category Description Price Discount Avail Gas Eng 10 $599 5% Cash 50 HP Elec Start Joined data is moved to the catalog server Gas Eng 75 HP Pull Start $659 25 10% Cash Gas Eng 2 65 HP Elec Start $600 None Gas Eng 5 75 HP Elec Start $799 None Gas Eng 14 65 HP Elec Start $650 5% Cash Gas Eng 22 50 HP Pull Start $499 7% Cash Data moved for joining Site Manager Supplier Catalog Local Desctiptions • Offloads resource intensive operations • Frees up Catalog Server and Site Managers for other work • E-Catalog System co-processors • Automatic load balancing Market Hub

  10. Site Manager Site Manager Caching Servers Supplier A Supplier Catalog Keeps high-demand data at the hub for faster access Cohera Catalog Server Category Description Price Discount Avail Gas Eng 10 $599 5% Cash 50 HP Elec Start Gas Eng 75 HP Pull Start $659 25 10% Cash Caching Server Live data retrieval Gas Eng 2 65 HP Elec Start $600 None Gas Eng 50 HP Elec Start Gas Eng 5 75 HP Elec Start $799 None Gas Eng 75 HP Pull Start Gas Eng 14 65 HP Elec Start $650 5% Cash Gas Eng 65 HP Elec Start Gas Eng 22 50 HP Pull Start $499 7% Cash Gas Eng 75 HP Elec Start Gas Eng 65 HP Elec Start Supplier B Gas Eng 50 HP Pull Start Supplier Catalog • Stores materialized views - queries against base tables are dynamically rewritten to retrieve data from cache • Tunable by data source for data freshness vs speed based on application tolerance

  11. Catalog Builder • Java-based graphical tool • Builds the Cohera E-Catalog structure • Stores information as Cohera metadata • Maps supplier tables to the Cohera E-Catalog • Manages access control to an E-Catalog • Built-in conversion for standard ODBC Types • Manages user-defined transformations for catalog data via User Defined Functions (UDF)

  12. CoheraNetQuery E-Market Application CoheraNetQuery User Interface Site Map CoheraNetQuery ODBC Driver • Provides access to web data • via standard SQL/ODBC • Uses Regular Expressions to • parse HTML and XML source • Supports SSL and cookies • Turns HTML/XML into a • relational data source HTML/XML

  13. Cohera Secure Network • Utilizes RSA’s SSL algorithms- the Industry standard approach to security • Assures confidentiality of customer’s data • Able to communicate with secure web sites • Configurable security between Site Manager pairs or Site Manager and Catalog Server • clear text - communications within a firewall • encrypted stream - communication across untrusted networks

  14. Transformations in Cohera User Defined Functions: • Normalize and unify data as it is pulled from various individual catalog systems • Support for wide range of on-the-fly transformations - ranging from simple to very complex: • Column name mapping • Type Conversions • Field Concatenation • Complex Conversions • Complex Aggregations • Support for C, C++, PERL, and Java transformations

  15. Cohera Site Manager Cohera Site Manager Cohera Site Manager Cohera Site Manager Cohera Site Manager Cohera Site Manager Cohera E-Catalog System Architecture Web Server RDBMS Application Server Cohera Metadata RDBMS Cohera Catalog Server Cohera Cache RDBMS Static Data Cohera Join Servers • DB/2 • SQLServer • ORACLE • Informix • Sybase . . Flat Files SAP VSAM RDBMS HTML XML

  16. Summary

  17. The Cohera E-catalog System • Built on Industry Standards • Standard SQL, JDBC, ODBC • Agnostic to App Servers and Data Sources • Live Catalog Integration • Fetch fresh catalog data directly from sources • Suppliers control access (Local autonomy) • Multiple alternative sources can be leveraged • Flexible Integration Management • Easy-to-use catalog builder GUI • Add/drop/modify sources on the fly - point & click • Easy transformation scripting

  18. Engineered For The Web And The Enterprise • Engineered for the Internet • XML and HTML catalog sources • Java/JDBC applications • Industry-standard SSL network security • Engineered for the Enterprise • Intimate support for RDBMS, leveraging query engines • Access to legacy data sources and packaged applications • Industry-standard SQL interfaces

  19. Built For High Performance And Scalability • Data-intensive processing done at join server(s) • offloading catalog servers • Caching servers speed access to static data • offloading catalog providers • Breakthrough economic computing technology • adaptively binds the pieces together in the most efficient manner

More Related