Oracle Information integration, migration, and consolidation : the definitive guide to information integration and migration in a heterogeneous world : use Oracle technologies and best practices to manage, maintain, migrate, and mobilize data / / Jason Williamson ; with Tom Laszewski and Prakash Nauduri

• Record Nr.: UNINA9910815348403321
• Autore: Williamson Jason
• Pubbl/distr/stampa: Birmingham [U.K.], : Packt Pub. Ltd., 2011
• ISBN: 1-283-30835-5; 9786613308351; 1-84968-221-6
• Edizione: [1st ed.]
• Descrizione fisica: 1 online resource (332 p.)
• Altri autori (Persone): LaszewskiTom; NauduriPrakash
• Disciplina: 005.75; 005.7575
• Soggetti: Data mining; Data warehousing
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: "Professional expertise distilled"--Cover.; Includes index.
• Nota di bibliografia: Includes index.
• Nota di contenuto: Cover; Copyright; Credits; About the Author; About the Contributing Authors; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Getting Started with Information Integration; Why consider information integration?; Business challenges in data integration and migration; Technical challenges of information integration; General approaches to information integration and migration; Data integration; Data migration; Architectures: federated versus shared; Data sharing integration; Considerations when choosing an integration approach; Integration and SOA, bringing it togetherArchitected for the Internet; Scalability; Availability; Greater software options; On-demand reporting; Security; Overcoming barriers to change; Custom integration applications and utilities; Custom workflow; The real world: studies in integration; Banking case; Education case; High technology case; ; Summary; Chapter 2: Oracle Tools and Products; Database migration products and tools; SQL Loader; Oracle external tables; Oracle Warehouse Builder; SQL Developer Migration Workbench; Oracle Data Integrator; Oracle Enterprise Manager tuning and diagnostic packsPhysical federation products; Oracle Data Integrator; Oracle GoldenGate; Oracle CDC adapters; Oracle Master Data Management; Oracle Data Quality and Profiling; Virtual federation products; Oracle Gateways and Heterogeneous Services; Oracle Business Intelligence Suite; Oracle SOA adapters; Oracle Web Center and Portal; Oracle Business Activity Monitoring; Data services; Oracle Data Integration Suite; Data consolidation; Oracle Exadata; Data grid; Oracle Coherence; Oracle TimesTen; Oracle Exalogic; Information Lifecycle Management; Oracle Information Lifecycle ManagementOracle-to-Oracle; Oracle Streams; Oracle Data Pump; Oracle XStream; Application integration; Oracle SOA Suite; Oracle Advanced Queuing; Oracle Application Information Architecture; Products matrix summary; Products not covered; Summary; Chapter 3: Application and Data Integration Case Study; What is the POV?; Solving a business problem; Estimated level of effort; Software and hardware requirements; Software; Hardware and network; Original architecture-nightly batch process; Batch cycle diagram-technical architecture; Functional specifications; Functional design diagramTechnical specifications; Technical specifications diagram; Assumptions, out of scope, and success criteria; Assumptions; Out of scope; Success criteria; Technical implementation details; Reading from the Oracle Database; Writing to flat files; Executing the z/OS COBOL module; Reading from VSAM files; Writing to IBM MQSeries; BPEL process; Security; Actual level of effort and outcome; Challenges and lessons learned; Cultural change in technology organizations; Next steps; Summary; Chapter 4: Oracle Database Migrations; Database migration scenarios; Migrating an Oracle database from one platform to another
• Sommario/riassunto: The definitive book and eBook guide to Oracle information integration and migration in a heterogeneous world