Autore	Vieira Robert
Edizione	[1st edition]
Pubbl/distr/stampa	Indianapolis, IN, : Wiley Pub., 2008
Descrizione fisica	1 online resource (724 p.)
Disciplina	005.75/85
Collana	Wrox beginning guides.
Soggetto topico	Database management Relational databases
Soggetto genere / forma	Electronic books.
ISBN	1-118-05960-3 1-282-68296-2 9786612682964 0-470-42394-3
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Beginning Microsoft SQL Server 2008 Programming; About the Author; Credits; Acknowledgments; Contents; Introduction; Chapter 1: RDBMS Basics: What Makes Up a SQL Server Database?; Chapter 2: Tools of the Trade; Chapter 3: The Foundation Statements of T-SQL; Chapter 4: JOINs; Chapter 5: Creating and Altering Tables; Chapter 6: Constraints; Chapter 7: Adding More to Our Queries; Chapter 8: Being Normal: Normalization and Other Basic Design Issues; Chapter 9: SQL Server Storage and Index Structures; Chapter 10: Views; Chapter 11: Writing Scripts and Batches; Chapter 12: Stored Procedures Chapter 13: User-Defined FunctionsChapter 14: Transactions and Locks; Chapter 15: Triggers; Chapter 16: A Brief XML Primer; Chapter 17: Reporting for Duty, Sir! A Look At Reporting Services; Chapter 18: Getting Integrated with Integration Services; Chapter 19: Playing Administrator; Appendix A: System Functions; Appendix B: Very Simple Connectivity Examples; Index
Record Nr.	UNINA-9910454130303321

Autore	Aspin Adam
Edizione	[1st ed. 2015.]
Pubbl/distr/stampa	Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015
Descrizione fisica	1 online resource (413 p.)
Disciplina	005.75 005.75/85
Collana	The expert's voice in SQL server
Soggetto topico	Database management Data structures (Computer science) Data mining Database Management Data Structures and Information Theory Data Mining and Knowledge Discovery
ISBN	1-4842-0532-4
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	""Contents at a Glance""; ""Contents""; ""About the Author""; ""About the Technical Reviewers""; ""Acknowledgments""; ""Introduction""; ""Chapter 1: SQL Server Reporting Services as a Business Intelligence Platform""; ""Business Intelligence Concepts""; ""Key Performance Indicators""; ""Scorecards""; ""Dashboards""; ""SSRS for Business Intelligence, Practically""; ""Getting the Data Right""; ""Prepare the Data""; ""Use Views and Stored Procedures""; ""Views""; ""Stored Procedures""; ""Some Ideas on Source Data Definition""; ""Real-World Data"" ""Designing SQL Server Reports for Business Intelligence""""Presentation""; ""Design""; ""Layout""; ""Interface and Interactivity""; ""Multi-Purposing""; ""The Sample Database""; ""Preparing Your Environment""; ""Creating an SSDT Project""; ""Adding a Shared Datasource""; ""Add Shared Datasets""; ""Configuring Parameters""; ""Code and Stored Procedures""; ""Reusability""; ""The CarSales_Reports Database""; ""Book Audience""; ""How Best to Use This Book""; ""Conclusion""; ""Chapter 2: KPIs and Scorecards""; ""What Are Key Performance Indicators?""; ""KPI Value""; ""KPI Goal""; ""KPI Status"" ""KPI Status Thresholds""""Threshold Flags""; ""KPI Trends""; ""KPI Trend Thresholds and Flags""; ""A Simple KPI""; ""The Source Data""; ""How the Code Works""; ""Building the KPI""; ""How It Works""; ""A More Complex KPI Using Sparklines""; ""The Source Data""; ""How the Code Works""; ""Building the KPI""; ""How It Works""; ""Gauge-Based KPIs""; ""The Source Data""; ""How the Code Works""; ""Building the Gauge-Based KPI""; ""How It Works""; ""Hints and Tips""; ""Text-Based KPIs""; ""A Simple Text-Based KPI""; ""The Source Data""; ""How the Code Works""; ""Building a Text-Based KPI"" ""How It Works""""A Complex Text-Based KPI""; ""The Source Data""; ""How the Code Works""; ""Building a Complex Text-Based KPI""; ""How It Works""; ""Conclusion""; ""Chapter 3: Gauges for Business Intelligence""; ""Gauge Elements""; ""Data for Gauges""; ""Gauge Development""; ""Classic Gauges""; ""The Source Data""; ""How the Code Works""; ""Building the Gauge""; ""How It Works""; ""Hints and Tips""; ""Using Multiple Pointers in Gauges""; ""The Source Data""; ""How the Code Works""; ""Creating the Gauge""; ""How It Works""; ""Varying the Pointer Types and Assembling Gauges"" ""The Source Data""""How the Code Works""; ""Building the Gauge""; ""How It Works""; ""Hints and Tips""; ""Gauges with Multiple Elements""; ""The Source Data""; ""Creating the Gauge""; ""How It Works""; ""Hints and Tips""; ""Less Traditional Gauges""; ""Thermometers""; ""The Source Data""; ""How the Code Works""; ""Building the Thermometer""; ""How It Works""; ""Hints and Tips""; ""Sub-Gauges""; ""The Source Data""; ""How the Code Works""; ""Creating Gauges with Sub-Gauges""; ""How It Works""; ""Hints and Tips""; ""Interesting Tricks with Gauges""; ""The Source Data""; ""How the Code Works"" ""Creating and Assembling the Gauges""
Record Nr.	UNINA-9910300638303321

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

Edizione	[1st ed.]
Pubbl/distr/stampa	[S.l.], : IBM, International Technical Support Organization, 2002
Descrizione fisica	xxviii, 510 p. : ill
Disciplina	005.75/85
Altri autori (Persone)	BaragoinCorinne
Collana	IBM redbooks
Soggetto topico	Database management OLAP technology
Formato	Materiale a stampa
Livello bibliografico	Monografia
Lingua di pubblicazione	eng
Nota di contenuto	Front cover -- Contents -- Figures -- Tables -- Examples -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Part 1 Introduction -- Chapter 1. DB2 OLAP Server V8.1 overview -- 1.1 Advanced analytical functions -- 1.1.1 Combining OLAP and relational databases: Hybrid Analysis -- 1.1.2 OLAP Miner -- 1.2 Advanced enterprise functions -- 1.3 Advanced administrative functions -- 1.3.1 Parallel calculation -- 1.3.2 Parallel data load -- 1.3.3 Parallel export -- 1.3.4 Administration Services -- 1.3.5 Security Migration Tool -- 1.3.6 Custom Defined Functions and Custom Defined Macros -- 1.3.7 API enhancements -- 1.3.8 Additional improvements and new functions -- Chapter 2. DB2 OLAP Server components and case studies -- 2.1 DB2 OLAP Server components architecture -- 2.1.1 The basic DB2 OLAP Server installation -- 2.1.2 Expanding OLAP capabilities with Integration Server -- 2.1.3 Expanding with Enterprise Services -- 2.1.4 Expanding with Administration Services -- 2.1.5 Using Security Migration Tool -- 2.1.6 Using Analyzer -- 2.1.7 The big picture -- 2.2 Case studies and our test environment -- 2.2.1 E-banking case study -- 2.2.2 Online Investment case study -- 2.2.3 Our test environment setup -- Part 2 Advanced analytical functions -- Chapter 3. Hybrid Analysis -- 3.1 Hybrid Analysis overview -- 3.1.1 Terminology and definitions -- 3.2 When to use Hybrid Analysis -- 3.3 Hybrid Analysis architecture -- 3.4 Hybrid Analysis challenges -- 3.5 Implementation of Hybrid Analysis -- 3.5.1 Building Hybrid Analysis using Integration Server -- 3.5.2 Hybrid Analysis member transformation -- 3.5.3 Impact of Hybrid Analysis versus multidimensional -- 3.5.4 Hybrid Analysis in Application Manager -- 3.5.5 Hybrid Analysis and Administration Services. 3.6 Tips and tricks for tuning Hybrid OLAP applications -- 3.6.1 Defining HAMEMORYCACHESIZE -- 3.6.2 Defining HAMAXNUMCONNECTION -- 3.6.3 Defining HAMAXNUMSQLQUERY -- 3.6.4 Defining HAMAXQUERYROWS -- 3.6.5 Defining HAMAXQUERYTIME -- 3.6.6 Defining HARETRIEVENUMROW -- 3.6.7 Conclusions: Hybrid Analysis configuration settings -- 3.7 Queries in the Hybrid Analysis environment -- 3.7.1 Member caching for better query performance -- 3.8 Query performance -- 3.9 Hybrid Analysis and Drill-Through Reports -- 3.9.1 Characteristics of Drill-Through Reports -- 3.9.2 Characteristics of Hybrid Analysis -- 3.9.3 Drill-Through Reports versus Hybrid Analysis -- 3.10 Data modeling for Hybrid Analysis -- 3.11 Security configuration for Hybrid Analysis -- 3.11.1 Tracing Hybrid Analysis -- Chapter 4. Mining your OLAP cube with OLAP Miner -- 4.1 OLAP Miner overview -- 4.2 Deviation detection in OLAP Miner -- 4.2.1 OLAP Miner performance -- 4.3 When to use OLAP Miner, and when not to use it -- 4.4 Mining and interpreting E-banking cube results -- 4.4.1 Scenario 1: PC-banking usage by branch -- 4.4.2 Scenario 2: Equity trade and Net-banking in branches -- 4.5 OLAP Miner setup and architecture -- 4.6 Running and monitoring OLAP Miner -- 4.6.1 Getting OLAP Miner to run, and stopping it -- 4.6.2 OLAP Miner client configuration -- 4.7 OLAP Miner results and logs -- Part 3 Advanced functions of Enterprise Services -- Chapter 5. Enterprise Services -- 5.1 Enterprise Services overview -- 5.1.1 Enterprise Services components -- 5.2 Enterprise Services configurations -- 5.2.1 TCP/IP Client Programs -- 5.2.2 HTTP client programs -- 5.2.3 EJB client programs -- 5.2.4 CORBA client programs -- 5.3 Enterprise Services deployment scenarios -- 5.3.1 Scalability overview -- 5.3.2 Clustering -- 5.3.3 Connection pooling -- 5.3.4 Workload balancing. 5.3.5 Server and application failure and failover -- 5.3.6 Enterprise Services: the whole picture -- 5.3.7 Guidelines for implementing a full cluster of OLAP servers -- 5.3.8 Copy DB2 OLAP applications and databases across servers -- 5.3.9 Synchronizing data across DB2 OLAP Servers in a cluster -- 5.3.10 Synchronizing security across all OLAP Servers in a cluster -- 5.4 Implementing Enterprise Services with TCP/IP -- 5.4.1 Installation tips for Enterprise Services: Windows and AIX -- 5.4.2 Setting up the domain storage -- 5.4.3 Starting Enterprise Services -- 5.4.4 Creating a domain -- 5.4.5 Defining users -- 5.4.6 Defining DB2 OLAP Server and Enterprise Services servers -- 5.4.7 Creating clusters -- 5.4.8 Creating connection pools -- 5.4.9 Using the sample programs -- 5.4.10 Additional tasks -- Part 4 Advanced administrative functions -- Chapter 6. Parallel calculation, data load, and export -- 6.1 Performing parallel calculation -- 6.1.1 Understanding parallel calculation -- 6.1.2 Parallel calculation architecture -- 6.1.3 Requirements -- 6.1.4 Enabling parallel calculation -- 6.1.5 Identifying concurrent tasks for parallel calculation -- 6.1.6 Running parallel calculation -- 6.1.7 Parallel calculation performance -- 6.1.8 Monitoring using the log -- 6.1.9 Estimating the size of a database calculation -- 6.2 Performing parallel load -- 6.2.1 Understanding the parallel load -- 6.2.2 Enabling parallel load -- 6.2.3 Running parallel data load -- 6.2.4 Monitoring using the log -- 6.2.5 Parallel load performance: Defining the right parameters -- 6.2.6 Tools to monitor parallel calculation and load -- 6.3 Performing parallel export -- 6.3.1 Running parallel export -- 6.3.2 Monitoring using the log -- 6.3.3 Parallel export performance -- 6.3.4 Exporting files larger than 2 GB -- Chapter 7. Administration Services -- 7.1 Administration Services components. 7.2 New administrative capabilities -- 7.3 Administration Services configurations -- 7.4 Using Administration Services -- 7.4.1 Managing security -- 7.4.2 Managing DB2 OLAP Servers, applications, and databases -- 7.4.3 Managing logs -- 7.4.4 Managing scripts -- 7.4.5 Miscellaneous -- 7.5 Implementing Administration Services -- 7.5.1 Preparing for installation -- 7.5.2 Installing DB2 OLAP Server components -- 7.5.3 Installing Administration Services -- 7.5.4 Starting Administration Services -- 7.5.5 Setting up users -- 7.5.6 Backing up Administration Services users information -- 7.5.7 Creating views -- Chapter 8. Additional enhancements -- 8.1 Direct I/O -- 8.1.1 Understanding the DB2 OLAP Server caches -- 8.1.2 The difference between buffered I/O and direct I/O -- 8.1.3 New features in DB2 OLAP Server version 8.1 -- 8.1.4 Changing the I/O access mode (buffered I/O or direct I/O) -- 8.1.5 The cache memory locking option -- 8.1.6 Defining the DB2 OLAP Server caches when using direct I/O -- 8.2 Security Migration Tool -- 8.2.1 Before running the Security Migration Tool -- 8.2.2 Running the Security Migration Tool -- 8.3 Multiple OLAP agents on the same machine -- 8.3.1 Hints and tips -- 8.3.2 A sample configuration scenario -- 8.4 Custom Defined Functions -- 8.4.1 Software requirements -- 8.4.2 Performance considerations in the Windows environment -- 8.4.3 Creating a CDF -- 8.4.4 Using a CDF in the outline -- 8.4.5 Using a CDF in calculations -- Part 5 Appendixes -- Appendix A. DB2 OLAP Integration Server -- A.1 Integration Server enhancements -- A.2 Migration of earlier OLAP metadata catalogs -- A.2.1 New configuration file for Integration Server -- A.2.2 Multiple data sources in Integration Server -- A.2.3 Drill through -- A.2.4 XML export/import of models and metaoutlines -- A.2.5 Intelligent help and increased usability. Appendix B. Setting up DB2 OLAP Analyzer Analysis Server V8.1 -- B.1 Analyzer V8.1 overview -- B.1.1 Supported platforms -- B.1.2 Architectural overview -- B.2 WebSphere Application Server setup -- B.3 Setting up and configuring Analyzer Server V8.1 -- B.3.1 Configuring Analyzer -- B.3.2 Uninstalling Analyzer V8.1 -- B.4 Using Analyzer V8.1 -- B.4.1 Analyzer Server console -- B.4.2 Analyzer Administration Tool -- Appendix C. Enterprise Services sample programs -- C.1 Copy application/database using CopyOLAP -- C.2 Sample runsamples.cmd script -- Appendix D. Data modeling basics -- D.1 ER data models -- D.2 Multidimensional data models: star and snowflake -- Related publications -- IBM Redbooks -- Other resources -- Referenced Web sites -- How to get IBM Redbooks -- IBM Redbooks collections -- Index -- Back cover.
Record Nr.	UNINA-9910808500703321