top

  Info

  • Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.

  Info

  • Utilizzare questo link per rimuovere la selezione effettuata.

Biblioteca

MARC Lista (tabellare)
The business value of DB2 for z/OS : IBM DB2 analytics accelerator and optimizer / / John Campbell [and four others]
The business value of DB2 for z/OS : IBM DB2 analytics accelerator and optimizer / / John Campbell [and four others]
Autore Campbell John
Edizione [First edition.]
Pubbl/distr/stampa Boise : , : MC Press, , [2013]
Descrizione fisica 1 online resource (145 p.)
Soggetto topico Business - Data processing
Client/server computing
Database management
ISBN 1-58347-758-6
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Cover; Copyright; Contents; About the Authors; Foreword by Don Haderle; Introduction by Surekha Parekh; 30 Years of Innovation; The Vision of DB2; Revolution in IBM DB2 Performance: IBM DB2 Analytics Accelerator by Namik Hrle, Ruiping Li, and Wolfgang Hengstler; Abstract; Objectives; Introduction; What Is Business Analytics?; How Business Analytics Can Help Your Organization; Key Design and Operational Features; Query Execution Process Flow; DB2 Analytics Accelerator Content Maintenance; DB2 Analytics Accelerator Table Definition and Deployment; High-Performance Storage Saver
Connectivity OptionsDisaster Recovery Considerations; Query Acceleration Criteria; Query Acceleration Control Knobs; EXPLAIN Function; System-Scope Instrumentation; Thread-Scope Instrumentation; DB2 Analytics Accelerator Administrative Stored Procedures; DISPLAY ACCELerator Command; Performance Considerations; The PureData System for Analytics S-Blade, Based on Netezza Technology; Applying Data Stream Processing to DB2 Queries; Comparing PureData System for Analytics Appliance Models; Minimizing Disk Failures; Minimizing S-Blade Failures; Summary
DB2 10 for z/OS Query Optimization Update by Terry PurcellAccess Path Management; DB2 10 Takes Plan Management to the Next Level; Predicate Processing and Runtime Optimizations; Sort Performance Enhancements; New Choices for the Query Optimizer; Improving Parallelism Efficiency and Removing Limitations; Improving the Inputs to the Query Optimizer; Summary; Planning for IBM DB2 10 for z/OS Upgrade by John Campbell; Highlights of the Beta Program Testing; Performance and Scalability; Availability; Other Issues; Incompatible Changes; Migration and Planning Considerations
Items Planned for Post-GA DeliveryWhen Should You Migrate to DB2 10 for z/OS?; Summary; DB2 10 for z/OS Case Studies Kela Invests in Improving Service Delivery for Finland's Citizens; Primerica Improves Efficiency and Gains More Flexibility; GAD Upgrades Database Systems to Boost Power and Productivity; DB2 10 for z/OS Eases Workload Consolidation for Bankdata and JN Data; Bank Hapoalim Improves Efficiency, Reduces Tape Usage by 25 Percent
Record Nr. UNINA-9910790515203321
Campbell John  
Boise : , : MC Press, , [2013]
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
The business value of DB2 for z/OS : IBM DB2 analytics accelerator and optimizer / / John Campbell [and four others]
The business value of DB2 for z/OS : IBM DB2 analytics accelerator and optimizer / / John Campbell [and four others]
Autore Campbell John
Edizione [First edition.]
Pubbl/distr/stampa Boise : , : MC Press, , [2013]
Descrizione fisica 1 online resource (145 p.)
Soggetto topico Business - Data processing
Client/server computing
Database management
ISBN 1-58347-758-6
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Cover; Copyright; Contents; About the Authors; Foreword by Don Haderle; Introduction by Surekha Parekh; 30 Years of Innovation; The Vision of DB2; Revolution in IBM DB2 Performance: IBM DB2 Analytics Accelerator by Namik Hrle, Ruiping Li, and Wolfgang Hengstler; Abstract; Objectives; Introduction; What Is Business Analytics?; How Business Analytics Can Help Your Organization; Key Design and Operational Features; Query Execution Process Flow; DB2 Analytics Accelerator Content Maintenance; DB2 Analytics Accelerator Table Definition and Deployment; High-Performance Storage Saver
Connectivity OptionsDisaster Recovery Considerations; Query Acceleration Criteria; Query Acceleration Control Knobs; EXPLAIN Function; System-Scope Instrumentation; Thread-Scope Instrumentation; DB2 Analytics Accelerator Administrative Stored Procedures; DISPLAY ACCELerator Command; Performance Considerations; The PureData System for Analytics S-Blade, Based on Netezza Technology; Applying Data Stream Processing to DB2 Queries; Comparing PureData System for Analytics Appliance Models; Minimizing Disk Failures; Minimizing S-Blade Failures; Summary
DB2 10 for z/OS Query Optimization Update by Terry PurcellAccess Path Management; DB2 10 Takes Plan Management to the Next Level; Predicate Processing and Runtime Optimizations; Sort Performance Enhancements; New Choices for the Query Optimizer; Improving Parallelism Efficiency and Removing Limitations; Improving the Inputs to the Query Optimizer; Summary; Planning for IBM DB2 10 for z/OS Upgrade by John Campbell; Highlights of the Beta Program Testing; Performance and Scalability; Availability; Other Issues; Incompatible Changes; Migration and Planning Considerations
Items Planned for Post-GA DeliveryWhen Should You Migrate to DB2 10 for z/OS?; Summary; DB2 10 for z/OS Case Studies Kela Invests in Improving Service Delivery for Finland's Citizens; Primerica Improves Efficiency and Gains More Flexibility; GAD Upgrades Database Systems to Boost Power and Productivity; DB2 10 for z/OS Eases Workload Consolidation for Bankdata and JN Data; Bank Hapoalim Improves Efficiency, Reduces Tape Usage by 25 Percent
Record Nr. UNINA-9910822132503321
Campbell John  
Boise : , : MC Press, , [2013]
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Database design and SQL for DB2 [[electronic resource] /] / James Cooper
Database design and SQL for DB2 [[electronic resource] /] / James Cooper
Autore Cooper James
Edizione [1st ed.]
Pubbl/distr/stampa Boise, ID, : MC Press, c2013
Descrizione fisica 1 online resource (505 p.)
Disciplina 005.75/6
Soggetto topico Database design
SQL (Computer program language)
Soggetto genere / forma Electronic books.
ISBN 1-58347-719-5
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Cover; Copyright; Dedication; Acknowledgments; Contents At A Glance; Contents; Introduction; Intended Audience; Companion Website; Instructors; Students; Contributors; Chapter 1: Database Concepts; Chapter Objectives; Introduction to Database and Database Management System; Relational Database Model; The DB2 Database; Database Terminology; The Importance of Database Design; Database Development Process; Database Planning; Requirements Analysis; Database Design; DBMS Selection; Database Implementation; Testing and Evaluation; Database Maintenance; Operation; End-of-Chapter; Chapter Summary
Key Terms Chapter 2: Conceptual Design Using ER Diagrams; Introduction to Database Design; Developing Entity Relationship Diagrams; ERD Case Study; Step 1: Identify Entities; Step 2: Identify Attributes; Step 3: Identify Unique Identifier (UID); Step 4: Determine Relationships; Step 5: Determine Optionality and Cardinality; Step 6: Eliminate Many-to-Many Relationships; Step 7: Named Relationships; Step 8: Determine Data Types; Recursive Relationship; Entity Subtypes; End-of-Chapter; Chapter Summary; Key Terms; Chapter 3: Normalization; Normalization; Normal Forms; Representing Database Tables
Functional Dependency First Normal Form (1NF); Second Normal Form (2NF); Third Normal Form (3NF); Boyce-Codd Normal Form (BCNF); Fourth Normal Form (4NF); Practical Example; First Normal Form (1NF); Second Normal Form (2NF); Third Normal Form (3NF); End-of-Chapter; Chapter Summary; Key Terms; Chapter 4: Physical Database Design: Creating Tables; Physical Database Design; Transforming Conceptual Design To Physical Design; Primary, Candidate, and Foreign Keys; Specify View Implementation; Specify Security Implementation; Specifying Additional Indexes for Performance; Hierarchy of Data; Variables
Database, Tables, Rows, and Columns Internal Binary Representation of Data; Data Types; Character Data Type; Numeric Data Types; Simulating a Boolean Data Type; Date Format; Timestamp Fields; Sample Data from a Table; Introduction to SQL; Running SQL Commands; Editor Pane; SQL Results Pane; Creating a Schema; Changing the Default Schema; Creating a Table; CREATE TABLE Command; Verify Syntax of SQL Script; Run SQL Script; Constraints; Qualified Names; Comments; NULL Values; Default Values; VARCHAR Data Type; ALTER Table Command; DROP (Delete) Table Command; Saving SQL Scripts; Edit SQL Scripts
Adding Data to a Table The INSERT Command; Displaying Data in a Table; Display Table Description Information; Rename a Database Object; End-of-Chapter; Chapter Summary; Key Terms; Chapter 5: Database Constraints; Introduction to Constraints; Data Integrity; Entity Integrity; Referential Integrity; Constraint Types; Primary Key Constraints; Unique Constraints; Foreign Key Constraints; Defining Foreign Key Constraints; Foreign Key Actions; Additional Foreign Key Constraint Considerations; Avoid Foreign Key Constraints for Read-Only Tables; Check Constraints; Check Constraint Guidelines
Defining Check Constraints
Record Nr. UNINA-9910462898103321
Cooper James  
Boise, ID, : MC Press, c2013
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Database design and SQL for DB2 [[electronic resource] /] / James Cooper
Database design and SQL for DB2 [[electronic resource] /] / James Cooper
Autore Cooper James
Edizione [1st ed.]
Pubbl/distr/stampa Boise, ID, : MC Press, c2013
Descrizione fisica 1 online resource (505 p.)
Disciplina 005.75/6
Soggetto topico Database design
SQL (Computer program language)
ISBN 1-58347-719-5
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Cover; Copyright; Dedication; Acknowledgments; Contents At A Glance; Contents; Introduction; Intended Audience; Companion Website; Instructors; Students; Contributors; Chapter 1: Database Concepts; Chapter Objectives; Introduction to Database and Database Management System; Relational Database Model; The DB2 Database; Database Terminology; The Importance of Database Design; Database Development Process; Database Planning; Requirements Analysis; Database Design; DBMS Selection; Database Implementation; Testing and Evaluation; Database Maintenance; Operation; End-of-Chapter; Chapter Summary
Key Terms Chapter 2: Conceptual Design Using ER Diagrams; Introduction to Database Design; Developing Entity Relationship Diagrams; ERD Case Study; Step 1: Identify Entities; Step 2: Identify Attributes; Step 3: Identify Unique Identifier (UID); Step 4: Determine Relationships; Step 5: Determine Optionality and Cardinality; Step 6: Eliminate Many-to-Many Relationships; Step 7: Named Relationships; Step 8: Determine Data Types; Recursive Relationship; Entity Subtypes; End-of-Chapter; Chapter Summary; Key Terms; Chapter 3: Normalization; Normalization; Normal Forms; Representing Database Tables
Functional Dependency First Normal Form (1NF); Second Normal Form (2NF); Third Normal Form (3NF); Boyce-Codd Normal Form (BCNF); Fourth Normal Form (4NF); Practical Example; First Normal Form (1NF); Second Normal Form (2NF); Third Normal Form (3NF); End-of-Chapter; Chapter Summary; Key Terms; Chapter 4: Physical Database Design: Creating Tables; Physical Database Design; Transforming Conceptual Design To Physical Design; Primary, Candidate, and Foreign Keys; Specify View Implementation; Specify Security Implementation; Specifying Additional Indexes for Performance; Hierarchy of Data; Variables
Database, Tables, Rows, and Columns Internal Binary Representation of Data; Data Types; Character Data Type; Numeric Data Types; Simulating a Boolean Data Type; Date Format; Timestamp Fields; Sample Data from a Table; Introduction to SQL; Running SQL Commands; Editor Pane; SQL Results Pane; Creating a Schema; Changing the Default Schema; Creating a Table; CREATE TABLE Command; Verify Syntax of SQL Script; Run SQL Script; Constraints; Qualified Names; Comments; NULL Values; Default Values; VARCHAR Data Type; ALTER Table Command; DROP (Delete) Table Command; Saving SQL Scripts; Edit SQL Scripts
Adding Data to a Table The INSERT Command; Displaying Data in a Table; Display Table Description Information; Rename a Database Object; End-of-Chapter; Chapter Summary; Key Terms; Chapter 5: Database Constraints; Introduction to Constraints; Data Integrity; Entity Integrity; Referential Integrity; Constraint Types; Primary Key Constraints; Unique Constraints; Foreign Key Constraints; Defining Foreign Key Constraints; Foreign Key Actions; Additional Foreign Key Constraint Considerations; Avoid Foreign Key Constraints for Read-Only Tables; Check Constraints; Check Constraint Guidelines
Defining Check Constraints
Record Nr. UNINA-9910786222603321
Cooper James  
Boise, ID, : MC Press, c2013
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Database design and SQL for DB2 / / James Cooper
Database design and SQL for DB2 / / James Cooper
Autore Cooper James
Edizione [1st ed.]
Pubbl/distr/stampa Boise, ID, : MC Press, c2013
Descrizione fisica 1 online resource (505 p.)
Disciplina 005.75/6
Soggetto topico Database design
SQL (Computer program language)
ISBN 1-58347-719-5
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Cover; Copyright; Dedication; Acknowledgments; Contents At A Glance; Contents; Introduction; Intended Audience; Companion Website; Instructors; Students; Contributors; Chapter 1: Database Concepts; Chapter Objectives; Introduction to Database and Database Management System; Relational Database Model; The DB2 Database; Database Terminology; The Importance of Database Design; Database Development Process; Database Planning; Requirements Analysis; Database Design; DBMS Selection; Database Implementation; Testing and Evaluation; Database Maintenance; Operation; End-of-Chapter; Chapter Summary
Key Terms Chapter 2: Conceptual Design Using ER Diagrams; Introduction to Database Design; Developing Entity Relationship Diagrams; ERD Case Study; Step 1: Identify Entities; Step 2: Identify Attributes; Step 3: Identify Unique Identifier (UID); Step 4: Determine Relationships; Step 5: Determine Optionality and Cardinality; Step 6: Eliminate Many-to-Many Relationships; Step 7: Named Relationships; Step 8: Determine Data Types; Recursive Relationship; Entity Subtypes; End-of-Chapter; Chapter Summary; Key Terms; Chapter 3: Normalization; Normalization; Normal Forms; Representing Database Tables
Functional Dependency First Normal Form (1NF); Second Normal Form (2NF); Third Normal Form (3NF); Boyce-Codd Normal Form (BCNF); Fourth Normal Form (4NF); Practical Example; First Normal Form (1NF); Second Normal Form (2NF); Third Normal Form (3NF); End-of-Chapter; Chapter Summary; Key Terms; Chapter 4: Physical Database Design: Creating Tables; Physical Database Design; Transforming Conceptual Design To Physical Design; Primary, Candidate, and Foreign Keys; Specify View Implementation; Specify Security Implementation; Specifying Additional Indexes for Performance; Hierarchy of Data; Variables
Database, Tables, Rows, and Columns Internal Binary Representation of Data; Data Types; Character Data Type; Numeric Data Types; Simulating a Boolean Data Type; Date Format; Timestamp Fields; Sample Data from a Table; Introduction to SQL; Running SQL Commands; Editor Pane; SQL Results Pane; Creating a Schema; Changing the Default Schema; Creating a Table; CREATE TABLE Command; Verify Syntax of SQL Script; Run SQL Script; Constraints; Qualified Names; Comments; NULL Values; Default Values; VARCHAR Data Type; ALTER Table Command; DROP (Delete) Table Command; Saving SQL Scripts; Edit SQL Scripts
Adding Data to a Table The INSERT Command; Displaying Data in a Table; Display Table Description Information; Rename a Database Object; End-of-Chapter; Chapter Summary; Key Terms; Chapter 5: Database Constraints; Introduction to Constraints; Data Integrity; Entity Integrity; Referential Integrity; Constraint Types; Primary Key Constraints; Unique Constraints; Foreign Key Constraints; Defining Foreign Key Constraints; Foreign Key Actions; Additional Foreign Key Constraint Considerations; Avoid Foreign Key Constraints for Read-Only Tables; Check Constraints; Check Constraint Guidelines
Defining Check Constraints
Record Nr. UNINA-9910827799703321
Cooper James  
Boise, ID, : MC Press, c2013
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
DB2 10 for z/OS database administration [[electronic resource] ] : certification study guide / / Susan Lawson, Daniel Luksetich
DB2 10 for z/OS database administration [[electronic resource] ] : certification study guide / / Susan Lawson, Daniel Luksetich
Autore Lawson Susan
Edizione [1st ed.]
Pubbl/distr/stampa Ketchum, Idaho, : MC Press, 2006
Descrizione fisica 1 online resource (1009 p.)
Disciplina 005.75/85
005.7585
Altri autori (Persone) LuksetichDan
Soggetto topico Electronic data processing personnel - Certification
Database management
Soggetto genere / forma Electronic books.
ISBN 1-58347-645-8
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Cover; Acknowledgments; Copyright; Contents; Introduction IBM DB2 10 for z/OS Certified Database Administrator ; 1: DB2 Product Fundamentals; DB2 and the On Demand Business; The DB2 Product Family; DB2 Middleware and Connectivity; InfoSphere Optim Data Lifecycle Management for DB2; Additional DB2 Application Development and Administration; Summary and Resources; Practice Questions and Answers; 2: Environment; z/OS; DB2 for z/OS; DB2 and Security; Parallel Sysplex Support; Storage Management Subsystem; DB2 Interfaces; Installation, Migration, and Conversion; DSNZPARMs; Commands
DB2 Utilities Catalog and Directory; Distributed Data; Memory Management; Summary and Resources; Practice Questions and Answers; 3: Access and Security; DB2 Subsystem Access; Data Set Protection; Encryption; DB2 Object Access; Multilevel Security; Auditing; Summary and Resources; Practice Questions and Answers; 4: Database Objects; Understanding Data Structures; Managing Database Objects; Data Types; Tables; Sequence Objects; Table Spaces; Views; Materialized Query Tables; Clone Tables; Temporal Tables; Hash Tables (Tables with Hash Access Enabled); Indexes; Databases; Storage Groups
Database Design and Implementation Sample Implementation; Summary and Resources; Practice Questions and Answers; 5: Retrieving and Manipulating Database Objects; Data Retrieval; Data Modification; Summary and Resources; Practice Questions and Answers; 6: Advanced SQL Coding; Subqueries; Unions; Excepts; Intersects; Nested Table Expressions; Common Table Expressions; Data Change Tables; Joins; ORDER BY and FETCH FIRST in Subselects and Fullselects; CASE Expressions; Row Expressions; PureXML Usage; OLAP Specification; Predicates and Filtering; Summary and Resources
Practice Questions and Answers 7: Maintaining Data; Data Movement; Data Maintenance; Rebuilding Indexes; Data Statistics; Real-Time Statistics; Data Maintenance Process; Diagnose Utility; Standalone Utilities; Displaying Utilities; Resolving Restrictive and Advisory States; Summary and Resources; Practice Questions and Answers; 8: Recovery and Restart; Database Recovery Concepts; Logging; Image Copies; Establishing a Point of Consistency; Recovery Concepts; System-Level Backup and Recovery; Backup and Recovery of the DB2 Catalog and Directory; Disaster Recovery; LOB and XML Recovery
Tracker Site Recovery DB2 Restart; Data Sharing Recovery; Summary and Resources; Practice Questions and Answers; 9: Data Sharing; Data Sharing Benefits; Data Sharing Components; Shared Data; Maintaining Data Integrity; Performance; Processing Costs; Movement to Data Sharing; Workload Management and Affinity Processing; Submitting Work; Communicating with a Data Sharing Group; Sysplex Query Parallelism; Recovery Considerations; Summary and Resources; Practice Questions and Answers; 10: Using SQL in an Application Program; Delimiting SQL in a Program; Declaring Table and View Definitions
SQL Execution Validation
Record Nr. UNINA-9910453088703321
Lawson Susan  
Ketchum, Idaho, : MC Press, 2006
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
DB2 10 for z/OS database administration [[electronic resource] ] : certification study guide / / Susan Lawson, Daniel Luksetich
DB2 10 for z/OS database administration [[electronic resource] ] : certification study guide / / Susan Lawson, Daniel Luksetich
Autore Lawson Susan
Edizione [1st ed.]
Pubbl/distr/stampa Ketchum, Idaho, : MC Press, 2006
Descrizione fisica 1 online resource (1009 p.)
Disciplina 005.75/85
005.7585
Altri autori (Persone) LuksetichDan
Soggetto topico Electronic data processing personnel - Certification
Database management
ISBN 1-58347-645-8
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Cover; Acknowledgments; Copyright; Contents; Introduction IBM DB2 10 for z/OS Certified Database Administrator ; 1: DB2 Product Fundamentals; DB2 and the On Demand Business; The DB2 Product Family; DB2 Middleware and Connectivity; InfoSphere Optim Data Lifecycle Management for DB2; Additional DB2 Application Development and Administration; Summary and Resources; Practice Questions and Answers; 2: Environment; z/OS; DB2 for z/OS; DB2 and Security; Parallel Sysplex Support; Storage Management Subsystem; DB2 Interfaces; Installation, Migration, and Conversion; DSNZPARMs; Commands
DB2 Utilities Catalog and Directory; Distributed Data; Memory Management; Summary and Resources; Practice Questions and Answers; 3: Access and Security; DB2 Subsystem Access; Data Set Protection; Encryption; DB2 Object Access; Multilevel Security; Auditing; Summary and Resources; Practice Questions and Answers; 4: Database Objects; Understanding Data Structures; Managing Database Objects; Data Types; Tables; Sequence Objects; Table Spaces; Views; Materialized Query Tables; Clone Tables; Temporal Tables; Hash Tables (Tables with Hash Access Enabled); Indexes; Databases; Storage Groups
Database Design and Implementation Sample Implementation; Summary and Resources; Practice Questions and Answers; 5: Retrieving and Manipulating Database Objects; Data Retrieval; Data Modification; Summary and Resources; Practice Questions and Answers; 6: Advanced SQL Coding; Subqueries; Unions; Excepts; Intersects; Nested Table Expressions; Common Table Expressions; Data Change Tables; Joins; ORDER BY and FETCH FIRST in Subselects and Fullselects; CASE Expressions; Row Expressions; PureXML Usage; OLAP Specification; Predicates and Filtering; Summary and Resources
Practice Questions and Answers 7: Maintaining Data; Data Movement; Data Maintenance; Rebuilding Indexes; Data Statistics; Real-Time Statistics; Data Maintenance Process; Diagnose Utility; Standalone Utilities; Displaying Utilities; Resolving Restrictive and Advisory States; Summary and Resources; Practice Questions and Answers; 8: Recovery and Restart; Database Recovery Concepts; Logging; Image Copies; Establishing a Point of Consistency; Recovery Concepts; System-Level Backup and Recovery; Backup and Recovery of the DB2 Catalog and Directory; Disaster Recovery; LOB and XML Recovery
Tracker Site Recovery DB2 Restart; Data Sharing Recovery; Summary and Resources; Practice Questions and Answers; 9: Data Sharing; Data Sharing Benefits; Data Sharing Components; Shared Data; Maintaining Data Integrity; Performance; Processing Costs; Movement to Data Sharing; Workload Management and Affinity Processing; Submitting Work; Communicating with a Data Sharing Group; Sysplex Query Parallelism; Recovery Considerations; Summary and Resources; Practice Questions and Answers; 10: Using SQL in an Application Program; Delimiting SQL in a Program; Declaring Table and View Definitions
SQL Execution Validation
Record Nr. UNINA-9910790632403321
Lawson Susan  
Ketchum, Idaho, : MC Press, 2006
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
DB2 10 for z/OS database administration : certification study guide / / Susan Lawson, Daniel Luksetich
DB2 10 for z/OS database administration : certification study guide / / Susan Lawson, Daniel Luksetich
Autore Lawson Susan
Edizione [1st ed.]
Pubbl/distr/stampa Ketchum, Idaho, : MC Press, 2006
Descrizione fisica 1 online resource (1009 p.)
Disciplina 005.75/85
005.7585
Altri autori (Persone) LuksetichDan
Soggetto topico Electronic data processing personnel - Certification
Database management
ISBN 1-58347-645-8
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Cover; Acknowledgments; Copyright; Contents; Introduction IBM DB2 10 for z/OS Certified Database Administrator ; 1: DB2 Product Fundamentals; DB2 and the On Demand Business; The DB2 Product Family; DB2 Middleware and Connectivity; InfoSphere Optim Data Lifecycle Management for DB2; Additional DB2 Application Development and Administration; Summary and Resources; Practice Questions and Answers; 2: Environment; z/OS; DB2 for z/OS; DB2 and Security; Parallel Sysplex Support; Storage Management Subsystem; DB2 Interfaces; Installation, Migration, and Conversion; DSNZPARMs; Commands
DB2 Utilities Catalog and Directory; Distributed Data; Memory Management; Summary and Resources; Practice Questions and Answers; 3: Access and Security; DB2 Subsystem Access; Data Set Protection; Encryption; DB2 Object Access; Multilevel Security; Auditing; Summary and Resources; Practice Questions and Answers; 4: Database Objects; Understanding Data Structures; Managing Database Objects; Data Types; Tables; Sequence Objects; Table Spaces; Views; Materialized Query Tables; Clone Tables; Temporal Tables; Hash Tables (Tables with Hash Access Enabled); Indexes; Databases; Storage Groups
Database Design and Implementation Sample Implementation; Summary and Resources; Practice Questions and Answers; 5: Retrieving and Manipulating Database Objects; Data Retrieval; Data Modification; Summary and Resources; Practice Questions and Answers; 6: Advanced SQL Coding; Subqueries; Unions; Excepts; Intersects; Nested Table Expressions; Common Table Expressions; Data Change Tables; Joins; ORDER BY and FETCH FIRST in Subselects and Fullselects; CASE Expressions; Row Expressions; PureXML Usage; OLAP Specification; Predicates and Filtering; Summary and Resources
Practice Questions and Answers 7: Maintaining Data; Data Movement; Data Maintenance; Rebuilding Indexes; Data Statistics; Real-Time Statistics; Data Maintenance Process; Diagnose Utility; Standalone Utilities; Displaying Utilities; Resolving Restrictive and Advisory States; Summary and Resources; Practice Questions and Answers; 8: Recovery and Restart; Database Recovery Concepts; Logging; Image Copies; Establishing a Point of Consistency; Recovery Concepts; System-Level Backup and Recovery; Backup and Recovery of the DB2 Catalog and Directory; Disaster Recovery; LOB and XML Recovery
Tracker Site Recovery DB2 Restart; Data Sharing Recovery; Summary and Resources; Practice Questions and Answers; 9: Data Sharing; Data Sharing Benefits; Data Sharing Components; Shared Data; Maintaining Data Integrity; Performance; Processing Costs; Movement to Data Sharing; Workload Management and Affinity Processing; Submitting Work; Communicating with a Data Sharing Group; Sysplex Query Parallelism; Recovery Considerations; Summary and Resources; Practice Questions and Answers; 10: Using SQL in an Application Program; Delimiting SQL in a Program; Declaring Table and View Definitions
SQL Execution Validation
Record Nr. UNINA-9910808837303321
Lawson Susan  
Ketchum, Idaho, : MC Press, 2006
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
DB2 11 : database for big data and analytics / / Cristian Molaro [and three others]
DB2 11 : database for big data and analytics / / Cristian Molaro [and three others]
Autore Molaro Cristian
Pubbl/distr/stampa Boise : , : MC Press, , [2013]
Descrizione fisica 1 online resource (129 p.)
Disciplina 650.02855369
Soggetto topico Database management
Relational databases
Soggetto genere / forma Electronic books.
ISBN 1-58347-388-2
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Front Cover ; Title Page; Copyright; Contents; About the Authors; Introduction by Surekha Parekh; DB2 11 for z/OS: Unmatched Efficiency for Big Data and Analytics by Julian Stuhler, Triton Consulting; DB2 11 for z/OS: The Database for Big Data and Analytics; Efficiency; CPU Reductions; zEC12 Exploitation; Application Compatibility; Transparent Archiving; Temporal Data Enhancements; Global Variables; Variable Arrays; Java Stored Procedure Enhancements; pureXML Enhancements; Optimizer and Query Performance Improvements; Data Sharing Performance Enhancements; Utility Enhancements
Other Efficiency Enhancements Resilience; Extended Log Record Addressing: Current Issues; Extended Log Record Addressing: DB2 11 Enhancements; Enhanced Dynamic Schema Change; BIND/REBIND Enhancements; Security Enhancements; Other Resilience Enhancements; Business Analytics; SQL Aggregation Improvements; IBM DB2 Analytics Accelerator Enhancements; Hadoop and Big Data Support; QMF 11; Other Enhancements for Analytics Workloads; Upgrading to DB2 11; DB2 Version Prerequisites; Other Prerequisites; Upgrade Timing; Upgrade Process and Impact; DB2 11 Customer Case Studies; BMW Group
Stadtwerke Bielefeld GmbHJN Data; Improved Query Performance in DB2 11 for z/OS by Terry Purcell; Predicate Indexability; Duplicate Removal; Hash Join and Sparse Index; Page Range Screening and Indexing for Partitioned Table Spaces; RUNSTATS Enhancements; Additional Performance Improvements; Summary; IBM DB2 Utilities and Tools with DB2 11 for z/OS by Haakon Roberts; How DB2 for z/OS Can Help Reduce Total Cost of Ownership by Cristian Molaro; Business Needs and DB2 TCO; DB2 and TCO; Reducing TCO Through Synergy with System z; DB2 Synergy with System z; Reducing TCO Through CPU Savings
DB2 10 CPU Savings and Performance Improvements DB2 10 Performance Expectations; DB2 11 CPU Savings and Performance Improvements; DB2 11 Performance Expectations; Specialty Engines; DB2 10 and Specialty Engines; DB2 11 and Specialty Engines; Estimating zIIP Savings; Special Considerations for High zIIP Utilization; DB2 and zAAP on zIIP; Reducing TCO with Better Performance; Identifying Better Performance Opportunities; Getting Better Performance with REBIND; DB2 Plan Management; DB2 11 APREUSE(WARN) Enhancement; DB2 11 RELEASE(DEALLOCATE) Optimization
DB2 11 Application Compatibility and APPLCOMPAT Case Study: Performance Benefits of REBIND; DB2 EXPLAIN At a Glance; DB2 10 High-Performance DBATs; Reducing TCO Through Storage Savings; DB2 Data Compression; DB2 Managed Disk Space Allocation; Case Study: Combined Effects of Data Compression and DB2 Managed Disk Space Allocation; Index Compression; Reducing TCO with Faster Analytics; IBM DB2 Analytics Accelerators; Leverage Legacy QMF Objects; Reducing TCO with Improved Scalability; DB2 10 Throughput Enhancements; DB2 Storage and Scalability; Data Sharing Member Consolidations; Conclusion
Record Nr. UNINA-9910453365703321
Molaro Cristian  
Boise : , : MC Press, , [2013]
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
DB2 11 : database for big data and analytics / / Cristian Molaro [and three others]
DB2 11 : database for big data and analytics / / Cristian Molaro [and three others]
Autore Molaro Cristian
Pubbl/distr/stampa Boise : , : MC Press, , [2013]
Descrizione fisica 1 online resource (129 p.)
Disciplina 650.02855369
Soggetto topico Database management
Relational databases
ISBN 1-58347-388-2
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Front Cover ; Title Page; Copyright; Contents; About the Authors; Introduction by Surekha Parekh; DB2 11 for z/OS: Unmatched Efficiency for Big Data and Analytics by Julian Stuhler, Triton Consulting; DB2 11 for z/OS: The Database for Big Data and Analytics; Efficiency; CPU Reductions; zEC12 Exploitation; Application Compatibility; Transparent Archiving; Temporal Data Enhancements; Global Variables; Variable Arrays; Java Stored Procedure Enhancements; pureXML Enhancements; Optimizer and Query Performance Improvements; Data Sharing Performance Enhancements; Utility Enhancements
Other Efficiency Enhancements Resilience; Extended Log Record Addressing: Current Issues; Extended Log Record Addressing: DB2 11 Enhancements; Enhanced Dynamic Schema Change; BIND/REBIND Enhancements; Security Enhancements; Other Resilience Enhancements; Business Analytics; SQL Aggregation Improvements; IBM DB2 Analytics Accelerator Enhancements; Hadoop and Big Data Support; QMF 11; Other Enhancements for Analytics Workloads; Upgrading to DB2 11; DB2 Version Prerequisites; Other Prerequisites; Upgrade Timing; Upgrade Process and Impact; DB2 11 Customer Case Studies; BMW Group
Stadtwerke Bielefeld GmbHJN Data; Improved Query Performance in DB2 11 for z/OS by Terry Purcell; Predicate Indexability; Duplicate Removal; Hash Join and Sparse Index; Page Range Screening and Indexing for Partitioned Table Spaces; RUNSTATS Enhancements; Additional Performance Improvements; Summary; IBM DB2 Utilities and Tools with DB2 11 for z/OS by Haakon Roberts; How DB2 for z/OS Can Help Reduce Total Cost of Ownership by Cristian Molaro; Business Needs and DB2 TCO; DB2 and TCO; Reducing TCO Through Synergy with System z; DB2 Synergy with System z; Reducing TCO Through CPU Savings
DB2 10 CPU Savings and Performance Improvements DB2 10 Performance Expectations; DB2 11 CPU Savings and Performance Improvements; DB2 11 Performance Expectations; Specialty Engines; DB2 10 and Specialty Engines; DB2 11 and Specialty Engines; Estimating zIIP Savings; Special Considerations for High zIIP Utilization; DB2 and zAAP on zIIP; Reducing TCO with Better Performance; Identifying Better Performance Opportunities; Getting Better Performance with REBIND; DB2 Plan Management; DB2 11 APREUSE(WARN) Enhancement; DB2 11 RELEASE(DEALLOCATE) Optimization
DB2 11 Application Compatibility and APPLCOMPAT Case Study: Performance Benefits of REBIND; DB2 EXPLAIN At a Glance; DB2 10 High-Performance DBATs; Reducing TCO Through Storage Savings; DB2 Data Compression; DB2 Managed Disk Space Allocation; Case Study: Combined Effects of Data Compression and DB2 Managed Disk Space Allocation; Index Compression; Reducing TCO with Faster Analytics; IBM DB2 Analytics Accelerators; Leverage Legacy QMF Objects; Reducing TCO with Improved Scalability; DB2 10 Throughput Enhancements; DB2 Storage and Scalability; Data Sharing Member Consolidations; Conclusion
Record Nr. UNINA-9910790611003321
Molaro Cristian  
Boise : , : MC Press, , [2013]
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui