Oracle database 10g : programmazine Pl/SQL / Scott Urman, Ron Hardman, Michael McLaughlin |
Autore | Urman, Scott |
Pubbl/distr/stampa | Milano : McGraw-Hill, c2005 |
Descrizione fisica | XVIII, 764 p. ; 24 cm |
Disciplina | 005.75 |
Altri autori (Persone) |
Hardman, Ron
McLaughilin, Michael |
Collana | Oracle press |
Soggetto non controllato | Oracle database 10gLinguaggio di programmazione PL/SQL |
ISBN | 88-386-4435-7 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | ita |
Record Nr. | UNIPARTHENOPE-000007646 |
Urman, Scott | ||
Milano : McGraw-Hill, c2005 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Parthenope | ||
|
Oracle Database XE 11gR2 jump start guide [[electronic resource] ] : build and manage your Oracle Database 11gXE environment with this fast paced, practical guide / / Asif Momen |
Autore | Momen Asif |
Pubbl/distr/stampa | Birmingham, : Packt Pub., 2012 |
Descrizione fisica | 1 online resource (146 p.) |
Disciplina |
005.75
005.75/65 |
Soggetto topico |
Database management
Online databases |
Soggetto genere / forma | Electronic books. |
ISBN |
1-282-11183-3
9786613804020 1-84968-675-0 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Database Editions and Oracle Database XE; About Oracle; Available database editions; Oracle Database Express Edition (XE); Summary; References; Chapter 2: Installing and Uninstalling Oracle Database XE; Downloading Oracle Database 11g XE; Installing Oracle Database 11g XE on Windows XP (32-bit); Starting and stopping Oracle Database XE in Windows; Uninstalling Oracle Database 11g XE on Windows XP (32-bit)
Installing Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)Starting and stopping Oracle Database XE in Linux; Uninstalling Oracle Database 11g XE on Oracle Enterprise Linux (64-bit); Summary; Chapter 3: Connecting and Configuring Oracle Database 11g XE; Local database connections; Oracle Net Listener; Configuring Oracle Net Listener; Viewing the status of Oracle Net Listener; Starting and stopping the listener; Configuring the tnsnames.ora file; Remote database connections; Changing SGA and PGA sizes; Summary; Chapter 4: Accessing Table Data, DML Statements, and Transactions Unlocking sample user accountsInstalling SQL Developer; Connecting SQL Developer to Oracle Database 11g XE; About TAB and DUAL; Writing simple queries; Selecting data from multiple tables; Exploring common functions; What are Transaction Control Statements?; Understanding DML statements; Summary; References; Chapter 5: Creating and Managing Schema Objects; Data Definition Language; Creating and managing tables; Creating and managing indexes; Integrity constraints; Creating and managing views; Creating and managing synonyms; Creating and managing sequences; Gathering statistics; Summary ReferencesChapter 6: Developing Stored Subprograms and Triggers; PL/SQL data types; Stored subprograms; Creating stored subprograms; About packages; Creating packages; Exception handling; Wrapping up the PL/SQL stored programs; PL/SQL triggers; Summary; References; Chapter 7: Building a Sample Application with Oracle Application Express; What is Oracle Application Express (APEX)?; Getting started with Oracle Application Express; Application Express components; Prerequisites for a sample application; Creating a sample application; Adding a page to the existing application Creating application usersLoading and unloading data to a text file; Unloading the EMP table to a text file; Loading text file to the EMP_LOAD table; Application Express Dashboard; Summary; References; Chapter 8: Managing Database and Database Storage; Memory structure; System Global Area; Process Global Area; Automatic Memory Management; Important background processes; Physical and logical database structures; Creating a tablespace; Adding datafiles to a tablespace; Dropping a tablespace; Viewing the tablespace usage; Managing the Flash Recovery Area; Summary Chapter 9: Moving Data between Oracle Databases |
Record Nr. | UNINA-9910452650903321 |
Momen Asif | ||
Birmingham, : Packt Pub., 2012 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Oracle Database XE 11gR2 jump start guide [[electronic resource] ] : build and manage your Oracle Database 11gXE environment with this fast paced, practical guide / / Asif Momen |
Autore | Momen Asif |
Pubbl/distr/stampa | Birmingham, : Packt Pub., 2012 |
Descrizione fisica | 1 online resource (146 p.) |
Disciplina |
005.75
005.75/65 |
Soggetto topico |
Database management
Online databases |
ISBN |
1-282-11183-3
9786613804020 1-84968-675-0 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Database Editions and Oracle Database XE; About Oracle; Available database editions; Oracle Database Express Edition (XE); Summary; References; Chapter 2: Installing and Uninstalling Oracle Database XE; Downloading Oracle Database 11g XE; Installing Oracle Database 11g XE on Windows XP (32-bit); Starting and stopping Oracle Database XE in Windows; Uninstalling Oracle Database 11g XE on Windows XP (32-bit)
Installing Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)Starting and stopping Oracle Database XE in Linux; Uninstalling Oracle Database 11g XE on Oracle Enterprise Linux (64-bit); Summary; Chapter 3: Connecting and Configuring Oracle Database 11g XE; Local database connections; Oracle Net Listener; Configuring Oracle Net Listener; Viewing the status of Oracle Net Listener; Starting and stopping the listener; Configuring the tnsnames.ora file; Remote database connections; Changing SGA and PGA sizes; Summary; Chapter 4: Accessing Table Data, DML Statements, and Transactions Unlocking sample user accountsInstalling SQL Developer; Connecting SQL Developer to Oracle Database 11g XE; About TAB and DUAL; Writing simple queries; Selecting data from multiple tables; Exploring common functions; What are Transaction Control Statements?; Understanding DML statements; Summary; References; Chapter 5: Creating and Managing Schema Objects; Data Definition Language; Creating and managing tables; Creating and managing indexes; Integrity constraints; Creating and managing views; Creating and managing synonyms; Creating and managing sequences; Gathering statistics; Summary ReferencesChapter 6: Developing Stored Subprograms and Triggers; PL/SQL data types; Stored subprograms; Creating stored subprograms; About packages; Creating packages; Exception handling; Wrapping up the PL/SQL stored programs; PL/SQL triggers; Summary; References; Chapter 7: Building a Sample Application with Oracle Application Express; What is Oracle Application Express (APEX)?; Getting started with Oracle Application Express; Application Express components; Prerequisites for a sample application; Creating a sample application; Adding a page to the existing application Creating application usersLoading and unloading data to a text file; Unloading the EMP table to a text file; Loading text file to the EMP_LOAD table; Application Express Dashboard; Summary; References; Chapter 8: Managing Database and Database Storage; Memory structure; System Global Area; Process Global Area; Automatic Memory Management; Important background processes; Physical and logical database structures; Creating a tablespace; Adding datafiles to a tablespace; Dropping a tablespace; Viewing the tablespace usage; Managing the Flash Recovery Area; Summary Chapter 9: Moving Data between Oracle Databases |
Record Nr. | UNINA-9910779495903321 |
Momen Asif | ||
Birmingham, : Packt Pub., 2012 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Oracle Database XE 11gR2 jump start guide : build and manage your Oracle Database 11gXE environment with this fast paced, practical guide / / Asif Momen |
Autore | Momen Asif |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Birmingham, : Packt Pub., 2012 |
Descrizione fisica | 1 online resource (146 p.) |
Disciplina |
005.75
005.75/65 |
Soggetto topico |
Database management
Online databases |
ISBN |
1-282-11183-3
9786613804020 1-84968-675-0 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Copyright; Credits; About the Author; Acknowledgement; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Database Editions and Oracle Database XE; About Oracle; Available database editions; Oracle Database Express Edition (XE); Summary; References; Chapter 2: Installing and Uninstalling Oracle Database XE; Downloading Oracle Database 11g XE; Installing Oracle Database 11g XE on Windows XP (32-bit); Starting and stopping Oracle Database XE in Windows; Uninstalling Oracle Database 11g XE on Windows XP (32-bit)
Installing Oracle Database 11g XE on Oracle Enterprise Linux (64-bit)Starting and stopping Oracle Database XE in Linux; Uninstalling Oracle Database 11g XE on Oracle Enterprise Linux (64-bit); Summary; Chapter 3: Connecting and Configuring Oracle Database 11g XE; Local database connections; Oracle Net Listener; Configuring Oracle Net Listener; Viewing the status of Oracle Net Listener; Starting and stopping the listener; Configuring the tnsnames.ora file; Remote database connections; Changing SGA and PGA sizes; Summary; Chapter 4: Accessing Table Data, DML Statements, and Transactions Unlocking sample user accountsInstalling SQL Developer; Connecting SQL Developer to Oracle Database 11g XE; About TAB and DUAL; Writing simple queries; Selecting data from multiple tables; Exploring common functions; What are Transaction Control Statements?; Understanding DML statements; Summary; References; Chapter 5: Creating and Managing Schema Objects; Data Definition Language; Creating and managing tables; Creating and managing indexes; Integrity constraints; Creating and managing views; Creating and managing synonyms; Creating and managing sequences; Gathering statistics; Summary ReferencesChapter 6: Developing Stored Subprograms and Triggers; PL/SQL data types; Stored subprograms; Creating stored subprograms; About packages; Creating packages; Exception handling; Wrapping up the PL/SQL stored programs; PL/SQL triggers; Summary; References; Chapter 7: Building a Sample Application with Oracle Application Express; What is Oracle Application Express (APEX)?; Getting started with Oracle Application Express; Application Express components; Prerequisites for a sample application; Creating a sample application; Adding a page to the existing application Creating application usersLoading and unloading data to a text file; Unloading the EMP table to a text file; Loading text file to the EMP_LOAD table; Application Express Dashboard; Summary; References; Chapter 8: Managing Database and Database Storage; Memory structure; System Global Area; Process Global Area; Automatic Memory Management; Important background processes; Physical and logical database structures; Creating a tablespace; Adding datafiles to a tablespace; Dropping a tablespace; Viewing the tablespace usage; Managing the Flash Recovery Area; Summary Chapter 9: Moving Data between Oracle Databases |
Record Nr. | UNINA-9910810411703321 |
Momen Asif | ||
Birmingham, : Packt Pub., 2012 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Oracle Essbase 11 development cookbook [[electronic resource] ] : over 90 advanced development recipes to build and take your Oracle Essbase applications further / / Jose R. Ruiz |
Autore | Ruiz Jose R |
Pubbl/distr/stampa | Birmingham, U.K., : Packt Enterprise, 2012 |
Descrizione fisica | 1 online resource (400 p.) |
Disciplina |
005.75
005.75/85 005.7585 |
Soggetto topico | Database management |
Soggetto genere / forma | Electronic books. |
ISBN |
1-283-45346-0
9786613453464 1-84968-327-1 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Copyright; Credits; About the Author; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1:Understanding and Modifying Data Sources; Introduction; Setting up an Account or Measure dimension with a parent-child reference; Setting up dimensions with a generation reference; Adding columns for outline formulas; Adding the solve order column to tables that have ASO formulas; Adding and populating the Sort Order Column; Adding tables for varying attributes; Determining hierarchies in relational tables; Using the Essbase Outline Extractor to extract dimensions
Using Star Analytics to build your star schema from existing Essbase cubesChapter 2:Using Essbase Studio; Introduction; Creating TBC sample database and connecting to the data source; Adding user-defined tables; Building your minischema; Setting up joins in a minischema; Adding tables to a minischema; Using a text file data source; Working with Common Platform Language (CPL); Using Sort Order on data elements; Chapter 3: Building theBSO Cube; Introduction; Creating hierarchies using a parent-child reference table; Creating hierarchies using a generation reference table Adding attribute dimensions to hierarchiesBuilding a Calendar dimension; Creating date elements; Creating Alias tables; Developing cube schema and an Essbase model; Setting Essbase properties; Deploying a cube; Creating an OLAP Model in EIS; Creating an OLAP metaoutline in EIS; Chapter 4:Building the ASO Cube; Introduction; Using the Connection Wizard to set up an ASO cube; Building a Measures dimension from the fact table; Creating an ASO Cube Schema and an Essbase Model; Understanding Essbase Model properties for the ASO cube; Designing a drill-through report Using the View dimension for Dynamic Time Series reportingChapter 5:Using EAS for Development; Introduction; Adding an application and database on an Essbase Server; Using the outline editor to add dimensions; Using dimension build rules to add the parent-child dimension; Creating dimension build rules to add a base and attribute dimensions; Using dimension build rules to add user-defined attributes and associate dimensions; Creating load rules for flat file data loads; Creating substitution variables; Using If/Else logic and substitution variables in outline formulas Using Text measures on a BSO cubeUsing Date measures on a BSO cube; Using different outline formula logic at parent level; Creating a load rule for SQL data load using substitution variables; Using MDX in aggregate storage applications; Chapter 6:Creating Calculation Scripts; Introduction; Using Essbase Set function commands and Calc All to calculate cubes; Using control flow commands, conditional, and logical operators; Using substitution variables in calculations script; Using UDAs and Calc Two Pass in calculation scripts; Using Attributes in calculation scripts Clearing data and using the cross- dimensional operators in a calculation script |
Record Nr. | UNINA-9910457519603321 |
Ruiz Jose R | ||
Birmingham, U.K., : Packt Enterprise, 2012 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Oracle Essbase 11 development cookbook [[electronic resource] ] : over 90 advanced development recipes to build and take your Oracle Essbase applications further / / Jose R. Ruiz |
Autore | Ruiz Jose R |
Pubbl/distr/stampa | Birmingham, U.K., : Packt Enterprise, 2012 |
Descrizione fisica | 1 online resource (400 p.) |
Disciplina |
005.75
005.75/85 005.7585 |
Soggetto topico | Database management |
ISBN |
1-283-45346-0
9786613453464 1-84968-327-1 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Copyright; Credits; About the Author; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1:Understanding and Modifying Data Sources; Introduction; Setting up an Account or Measure dimension with a parent-child reference; Setting up dimensions with a generation reference; Adding columns for outline formulas; Adding the solve order column to tables that have ASO formulas; Adding and populating the Sort Order Column; Adding tables for varying attributes; Determining hierarchies in relational tables; Using the Essbase Outline Extractor to extract dimensions
Using Star Analytics to build your star schema from existing Essbase cubesChapter 2:Using Essbase Studio; Introduction; Creating TBC sample database and connecting to the data source; Adding user-defined tables; Building your minischema; Setting up joins in a minischema; Adding tables to a minischema; Using a text file data source; Working with Common Platform Language (CPL); Using Sort Order on data elements; Chapter 3: Building theBSO Cube; Introduction; Creating hierarchies using a parent-child reference table; Creating hierarchies using a generation reference table Adding attribute dimensions to hierarchiesBuilding a Calendar dimension; Creating date elements; Creating Alias tables; Developing cube schema and an Essbase model; Setting Essbase properties; Deploying a cube; Creating an OLAP Model in EIS; Creating an OLAP metaoutline in EIS; Chapter 4:Building the ASO Cube; Introduction; Using the Connection Wizard to set up an ASO cube; Building a Measures dimension from the fact table; Creating an ASO Cube Schema and an Essbase Model; Understanding Essbase Model properties for the ASO cube; Designing a drill-through report Using the View dimension for Dynamic Time Series reportingChapter 5:Using EAS for Development; Introduction; Adding an application and database on an Essbase Server; Using the outline editor to add dimensions; Using dimension build rules to add the parent-child dimension; Creating dimension build rules to add a base and attribute dimensions; Using dimension build rules to add user-defined attributes and associate dimensions; Creating load rules for flat file data loads; Creating substitution variables; Using If/Else logic and substitution variables in outline formulas Using Text measures on a BSO cubeUsing Date measures on a BSO cube; Using different outline formula logic at parent level; Creating a load rule for SQL data load using substitution variables; Using MDX in aggregate storage applications; Chapter 6:Creating Calculation Scripts; Introduction; Using Essbase Set function commands and Calc All to calculate cubes; Using control flow commands, conditional, and logical operators; Using substitution variables in calculations script; Using UDAs and Calc Two Pass in calculation scripts; Using Attributes in calculation scripts Clearing data and using the cross- dimensional operators in a calculation script |
Record Nr. | UNINA-9910779069203321 |
Ruiz Jose R | ||
Birmingham, U.K., : Packt Enterprise, 2012 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Oracle Essbase 11 development cookbook : over 90 advanced development recipes to build and take your Oracle Essbase applications further / / Jose R. Ruiz |
Autore | Ruiz Jose R |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Birmingham, U.K., : Packt Enterprise, 2012 |
Descrizione fisica | 1 online resource (400 p.) |
Disciplina |
005.75
005.75/85 005.7585 |
Soggetto topico | Database management |
ISBN |
1-283-45346-0
9786613453464 1-84968-327-1 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
Cover; Copyright; Credits; About the Author; About the Reviewer; www.PacktPub.com; Table of Contents; Preface; Chapter 1:Understanding and Modifying Data Sources; Introduction; Setting up an Account or Measure dimension with a parent-child reference; Setting up dimensions with a generation reference; Adding columns for outline formulas; Adding the solve order column to tables that have ASO formulas; Adding and populating the Sort Order Column; Adding tables for varying attributes; Determining hierarchies in relational tables; Using the Essbase Outline Extractor to extract dimensions
Using Star Analytics to build your star schema from existing Essbase cubesChapter 2:Using Essbase Studio; Introduction; Creating TBC sample database and connecting to the data source; Adding user-defined tables; Building your minischema; Setting up joins in a minischema; Adding tables to a minischema; Using a text file data source; Working with Common Platform Language (CPL); Using Sort Order on data elements; Chapter 3: Building theBSO Cube; Introduction; Creating hierarchies using a parent-child reference table; Creating hierarchies using a generation reference table Adding attribute dimensions to hierarchiesBuilding a Calendar dimension; Creating date elements; Creating Alias tables; Developing cube schema and an Essbase model; Setting Essbase properties; Deploying a cube; Creating an OLAP Model in EIS; Creating an OLAP metaoutline in EIS; Chapter 4:Building the ASO Cube; Introduction; Using the Connection Wizard to set up an ASO cube; Building a Measures dimension from the fact table; Creating an ASO Cube Schema and an Essbase Model; Understanding Essbase Model properties for the ASO cube; Designing a drill-through report Using the View dimension for Dynamic Time Series reportingChapter 5:Using EAS for Development; Introduction; Adding an application and database on an Essbase Server; Using the outline editor to add dimensions; Using dimension build rules to add the parent-child dimension; Creating dimension build rules to add a base and attribute dimensions; Using dimension build rules to add user-defined attributes and associate dimensions; Creating load rules for flat file data loads; Creating substitution variables; Using If/Else logic and substitution variables in outline formulas Using Text measures on a BSO cubeUsing Date measures on a BSO cube; Using different outline formula logic at parent level; Creating a load rule for SQL data load using substitution variables; Using MDX in aggregate storage applications; Chapter 6:Creating Calculation Scripts; Introduction; Using Essbase Set function commands and Calc All to calculate cubes; Using control flow commands, conditional, and logical operators; Using substitution variables in calculations script; Using UDAs and Calc Two Pass in calculation scripts; Using Attributes in calculation scripts Clearing data and using the cross- dimensional operators in a calculation script |
Record Nr. | UNINA-9910823869203321 |
Ruiz Jose R | ||
Birmingham, U.K., : Packt Enterprise, 2012 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Oracle 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 Nauduri |
Autore | Williamson Jason |
Pubbl/distr/stampa | Birmingham [U.K.], : Packt Pub. Ltd., 2011 |
Descrizione fisica | 1 online resource (332 p.) |
Disciplina |
005.75
005.7575 |
Altri autori (Persone) |
LaszewskiTom
NauduriPrakash |
Soggetto topico |
Data mining
Data warehousing |
Soggetto genere / forma | Electronic books. |
ISBN |
1-283-30835-5
9786613308351 1-84968-221-6 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
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 |
Record Nr. | UNINA-9910457338803321 |
Williamson Jason | ||
Birmingham [U.K.], : Packt Pub. Ltd., 2011 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
Oracle 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 Nauduri |
Autore | Williamson Jason |
Pubbl/distr/stampa | Birmingham [U.K.], : Packt Pub. Ltd., 2011 |
Descrizione fisica | 1 online resource (332 p.) |
Disciplina |
005.75
005.7575 |
Altri autori (Persone) |
LaszewskiTom
NauduriPrakash |
Soggetto topico |
Data mining
Data warehousing |
ISBN |
1-283-30835-5
9786613308351 1-84968-221-6 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
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 |
Record Nr. | UNINA-9910781891703321 |
Williamson Jason | ||
Birmingham [U.K.], : Packt Pub. Ltd., 2011 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|
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 |
Autore | Williamson Jason |
Edizione | [1st ed.] |
Pubbl/distr/stampa | Birmingham [U.K.], : Packt Pub. Ltd., 2011 |
Descrizione fisica | 1 online resource (332 p.) |
Disciplina |
005.75
005.7575 |
Altri autori (Persone) |
LaszewskiTom
NauduriPrakash |
Soggetto topico |
Data mining
Data warehousing |
ISBN |
1-283-30835-5
9786613308351 1-84968-221-6 |
Formato | Materiale a stampa |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
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 |
Record Nr. | UNINA-9910815348403321 |
Williamson Jason | ||
Birmingham [U.K.], : Packt Pub. Ltd., 2011 | ||
Materiale a stampa | ||
Lo trovi qui: Univ. Federico II | ||
|