EAI IA

EAI IA - Enterprise Application Integration – An Inside...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Enterprise Application Integration – An Inside Integration By Dr. Atanu Rakshit Email: arakshit@isquareit.ac.in atanu.rakshit@usa.net atanu.rakshit@usa.net EAI – Course Outline EAI EAI – An Overview Data Level EAI Application Interface Level EAI Method Level EAI User Interface Level EAI The EAI Process Methodology EAI and Middleware EAI – Course Outline EAI Transactional Middleware and EAI Messaging Oriented EAI Distributed Objects and EAI Database Oriented Middleware and EAI Java Middleware and EAI XML and EAI E – Business and EAI Process Automation and EAI Future Trends in EAI Data – Level EAI Data Federated Database EAI Federated Federated database software is leveraged to allow the Federated developers to access any number of databases using various brands, models, schema through a single ‘virtual’ database model. ‘virtual’ This virtual database model is software and mapped This to any number of connected physical databases to This virtual database is the single point of application This integration integration Federated Database EAI Federated This approach is the reliance on middleware to This share information between applications and not a custom solution not Moreover, the middleware hides the Moreover, differences in the integrated databases from the other applications the Unified Model Federated Database Systems for Managing Distributed, Heterogeneous, and Autonomous Database Autonomous Agenda Agenda Reference Architecture Specific FDBS Architecture FDBS Evolution Process FDBS Development Tasks FDBS Operation Conclusion Reference Architecture Reference System components Data User Data Database Database Commands Requests for specific actions Processors S/W modules that manipulate command or data Schemas Descriptions of data managed by DBMS Mappings Functions that translate objects in one schema to objects in another User Command Translator Federated Schema External Schema Conceptual Schema Mapping Reference Architecture Reference Processor types Transforming processor Filtering processor Constructing processor Accessing processor Reference Architecture Reference Transforming processor (1) Provide data model transparency Provide data Transform data from one format to another Transform command in one language to another Transform language language Need mappings among the objects of each Need schema schema Reference Architecture Reference Transforming processor (2) Command A Command Translator Command B Schema A Schema A Schema B Mappings Schema B Data A Schema A Data Converter Transforming Processor Data B Schema B Reference Architecture Reference Filtering processor (1) Constrain the commands and associated data Constrain that can be passed to another processor that Example Syntactic constraint checker Semantic integrity constraint Access controller Practical use: view update Practical view Reference Architecture Reference Filtering processor (2) Sub-schema A Command sub-A Command Filter Data sub-A Sub-schema A Schema A Mappings Sub-schema A Schema A Filtering Processor Data A Command A Data Filter Schema A Reference Architecture Reference Constructing processor (1) Partition/replicate an operation submitted by a Partition/replicate single processor into operations that are accepted by two or more other processors accepted Merge data produced by several processors Merge into a single processor into Support location, distribution, and replication Support transparencies transparencies Reference Architecture Reference Constructing processor (2) Tasks handled Schema integration Negotiation Query decomposition/optimization Global transaction management Reference Architecture Reference Constructing processor (3) Command A Command Decomposer Command B Command C Schema A Data A Schema A Schema B/C Mappings Schema B Schema C Data Merger Data B Data C Reference Architecture Reference Constructing processor (4) Schema A Constructing Processor Schema A Schema A Distribution Schema Reference Architecture Reference Accessing Processor (1) Accept commands and produces data by Accept executing the commands against a database executing Tasks handled Local concurrency control Commitment Backup Recovery Reference Architecture Reference Accessing processor (2) Data Commands Accessing Processor Database Reference Architecture Reference Schema architectures ANSI/SPARC three-level schema architecture Five-level schema architecture Five-level Reference Architecture Reference ANSI/SPARC three-level schema architecture (1) Traditional database system Consists of Conceptual schema Internal/physical schema Describe the conceptual/logical data structures and the Describe relationships among them relationships Describe physical characteristics of the logical data structures in Describe the conceptual schema the Export schema Describe subset of the database that may be accessed by users Reference Architecture Reference ANSI/SPARC three-level schema architecture (2) Reference Architecture Reference Five-level schema architecture Five-level Represent federated databases Consists of Local schema Component schema Export schema Federated schema External schema Reference Architecture Reference Five-level schema architecture Five-level Reference Architecture Reference Five-level schema architecture Five-level Local schema The conceptual schema of a component DBS Component schema Translation of local schema into a data model Translation called the canonical or common data model canonical (CDM) of the FDBS (CDM) Heterogeneity support Reference Architecture Reference Five-level schema architecture Five-level Export schema A subset of a component schema available to the FDBS Association autonomy is achieved by filtering processor Association and export schema and Federated schema An integration of multiple export schemas Support distribution transparency by using constructing Support processor and federated schemas processor Having Multiple federated schemas is possible Reference Architecture Reference Five-level schema architecture External schema Schema for users or applications Features: customization, additional integrity Features: constraints, access control constraints, Reference Architecture Reference System architecture for an FDBS Reference Architecture Reference FDBS schemas with missing schemas at some levels Agenda Agenda Reference Architecture Specific FDBS Architecture FDBS Evolution Process FDBS Development Tasks FDBS Operation Conclusion Specific FDBS Architectures Specific Classification Non-federated database Non-federated system system Not autonomous One level of management No distinction between local No and global operations and Federated database system Autonomous No centralized control Specific FDBS Architectures Specific Classification Classification Loosely-coupled FDBS Provide an interface to deal with multiple DBMSs directly Provide (Multi-database language) (Multi-database Pros Good for integrating a large number of autonomous read-only Good databases databases More flexible (multiple semantics) Cons Ill-suited for Update Require users’ expertise Specific FDBS Architectures Specific Classification Classification Tightly-coupled FDBS Pros Provide location, replication an distribution Provide transparency transparency Allow update Cons Need DBAs’ administration Specific FDBS Architectures Specific Examples DDTS Single federated schema, called Global Single Representation Schema (Relational data model) Representation (Relational One external schema, called Conceptual schema One Conceptual (Entity-Category-Relationship (ECR) model) Use the query language GORDAS Use GORDAS Specific FDBS Architectures Specific Conceptual schema (ECR model) & GORDAS query language Global Representation Schema (Relational data model) Local operations Transforming Module CODASYL model Specific FDBS Architectures Specific Multibase architecture Specific FDBS Architectures Specific Mermaid architecture Specific FDBS Architectures Specific MRDSM architecture Agenda Agenda Reference Architecture Specific FDBS Architecture FDBS Evolution Process FDBS Development Tasks FDBS Operation Conclusion FDBS Evolution Process FDBS To manage distributed data Distributed DBMS Federated DBMS The federation approach offers a preferred The evolutionary path. evolutionary The process of the federation approach Pre-integration phase Developing a federation database system Federated database system operations FDBS Evolution Process FDBS Pre-integration phase Deals with data stored on files, not DBMS Two alternatives Migrate the files to a DBMS Extend the file system to support DBMS-like features Developing a federation database system Create component, export, federated, and external schema Define mappings between schemas Implement processors Federated database system operations Manage and manipulate multiple integrated database using an FDBMS FDBS Evolution Process FDBS FDBS development Two approaches Bottom-up Bottom-up Top-down Use a data dictionary/directory (DD/D) to store All schemas representing information about the data All managed by the FDBS managed Mappings among schemas Information about schemas and database Schema-independent information System information FDBS Evolution Process FDBS Bottom-up approach Used to integrate several existing databases to Used develop a FDBS develop Procedure Translate schemas : transforming processor Define export schema : DBA Integrate schema : constructing processor Define external schema : filtering and transforming Define processor processor FDBS Evolution Process FDBS Bottom-up approach FDBS Evolution Process FDBS Top-down approach Used when a FDBS already exists and addition Used user requirements are placed on it. user Procedure Define or modify externnal schemas Analyze schemas Integrate schema FDBS Evolution Process FDBS Top-down approach Agenda Agenda Reference Architecture Specific FDBS Architecture FDBS Evolution Process FDBS Development Tasks FDBS Operation Conclusion FDBS Development Tasks FDBS Schema translation Access control Negotiation Schema integration Agenda Agenda Reference Architecture Specific FDBS Architecture FDBS Evolution Process FDBS Development Tasks FDBS Operation Conclusion FDBS Operation FDBS Query formulation Command transformation Query processing and optimization Global transaction Agenda Agenda Reference Architecture Specific FDBS Architecture FDBS Evolution Process FDBS Development Tasks FDBS Operation Conclusion Conclusion Conclusion Reference architecture Schema architectures ANSI/SPARC three-level schema architecture Five-level schema architecture FDBS development Top-down Bottom-up ...
View Full Document

This note was uploaded on 07/15/2011 for the course ECO 2023 taught by Professor Mr.raza during the Summer '10 term at FAU.

Ask a homework question - tutors are online