Practical Distributed Database Case Study Raytheon.pptVIP

Handling Distributed DataCase Study: Raytheon Ross ScottCS56104/01/04 Agenda Description the problem space Attempt 1: Distributed Database Attempt 2: Data Warehouse Attempt 3: Federation Q A Problem Space Problem Space: Engineering How Do We Handle This? Monolithic Server What is a monolithic server? Distributed Databases What is a distributed database? System Requirements Realtime Manufacturing Work in Process Prototype Engineering Release Data Distributed Vaults Now What Do We Do? Data Warehouse What is a data warehouse? “A data warehouse is a structured extensible data environment designed for the analysis of non-volatile data, logically and physically transformed from multiple source applications to align with business structure, updated and maintained for a long time period, expressed in simple business terms, and summarized for quick analysis.” Data Warehouse Data Warehouse contd. Data Warehouse Data Warehouse Federation What is Federation? The linking together of information management systems for the purpose of distributed, collaborative, product development. The creation and use of a heterogeneous network of data and processes where portions of the network are managed by different systems, yet the user sees a unified whole Federation: Data Network What is the definition of a Data Network? A network consisting of associations between data in distributed systems Associations can be built using three techniques: Links Proxies Replicas Federation by Link Federation by Link Federation by Proxy Federation by Proxy Federation by Replica Federation by Replica Federation: Process Networks Federated data is of limited use without having the business processes involving the Federated systems also being able to interact Process networks should support: Workflow interaction Activity in local workflow, initiates a workflow in a remote system Remote approval of activities Change process interaction Local change order init