05176nam 2200709 a 450 991045733880332120200520144314.01-283-30835-597866133083511-84968-221-6(CKB)2550000000053835(EBL)948548(OCoLC)797917755(SSID)ssj0000647044(PQKBManifestationID)11380991(PQKBTitleCode)TC0000647044(PQKBWorkID)10593408(PQKB)11713909(MiAaPQ)EBC948548(WaSeSS)Ind00024373(PPN)228030420(Au-PeEL)EBL948548(CaPaEBR)ebr10500142(CaONFJC)MIL330835(EXLCZ)99255000000005383520111014d2011 uy 0engur|n|---|||||txtccrOracle Information integration, migration, and consolidation[electronic resource] 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 NauduriBirmingham [U.K.] Packt Pub. Ltd.20111 online resource (332 p.)"Professional expertise distilled"--Cover.Includes index.1-84968-220-8 Includes index.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 approachIntegration 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 IntegratorOracle 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 ManagementOracle 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 specificationsFunctional 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 scenariosMigrating an Oracle database from one platform to anotherThe definitive book and eBook guide to Oracle information integration and migration in a heterogeneous worldData miningData warehousingElectronic books.Data mining.Data warehousing.005.75005.7575Williamson Jason885185Laszewski Tom885186Nauduri Prakash885187MiAaPQMiAaPQMiAaPQBOOK9910457338803321Oracle Information integration, migration, and consolidation1976480UNINA