CRYSTAL REPORTS® 2008 OFFICIAL GUIDE Whether you’re a DBA, data warehousing or business intelligence professional, Every significant enhancement introduced in Crystal Reports 2008 is covered, including its new visualization options and more robust Web services capabilities. The book concludes by showing how to use Crystal Reports’ powerful .NET and Java SDKs to customize and extend enterprise reporting in virtually unlimited ways. • Learn hands-on, through step-by-step examples and exercises–and discover tips and tricks proven in real-world enterprise environments • Master new Crystal Reports 2008 features, including interactive report viewing, Xcelsius dashboarding, Flex, and Flash integration, Report Designer improvements, report bursting, and more • Publish professional-quality reports against virtually any data source, including relational and OLAP databases, Universes, SAP, PeopleSoft, JavaBeans, .NET/COM objects, XML, and more • Discover advanced visualization techniques using Xcelsius, charts, and maps • Learn methods for distributing reports and integrating content into other applications • Learn about the latest reporting addition to the Business Objects family–Xcelsius and begin creating dynamic and interactive dashboards NEIL FITZGERALD has spent several years working at Business Objects and with one of Business Objects’ largest providers of custom BI and enterprise reporting solutions. BOB COATES currently works as a Sales Consultant for Business Objects, an SAP company, where he has been employed for more than eleven years. RYAN GOODMAN is the founder of Centigon Solutions, Inc., and remains one of the top Xcelsius experts and evangelists in the world. MICHAEL VOLOSHKO is a senior presales consultant for the financial services team at Business Objects. ON THE WEB Find all this and more at informit.com/sams: • Java and .NET sample reports and code samples for all examples in the book • Bonus chapters, tips, tricks, and links to great reporting resources CATEGORY: Database COVERS: Crystal Reports 2008, Crystal Reports Server 2008, Crystal Reports Viewer, crystalreports.com, Xcelsius 2008 USER LEVEL: Beginning–Intermediate informit.com/sams

SQL for the Real World Don’t just learn “generic” SQL. Learn SQL to get results with the world’s top database platforms–Oracle for the enterprise and Microsoft Access for the desktop. Based on John Patrick’s hands-on SQL course at the University of California, Berkeley Extension, this book shows exactly how to retrieve the data you want, when you need it, in any application–from ad hoc reports to the data warehouse. Thoroughly updated for the newest versions of Oracle, Access, and the SQL standard, this book contains more exercises, techniques, and solutions than ever before. You’ll learn exactly how to write SQL queries that are easy to understand, verify, modify, and extend–even if you’ve never worked with databases before. teaches you how to SQL Fundamentals,Third Edition, Build simple statements to retrieve, store, or modify data Craft complex queries that draw information from multiple tables Sort and summarize your data just the way you want it Create and edit your own tables Protect the integrity of your data Create more efficient, high-performance queries Work with unions, subqueries, self joins, cross joins, inner joins, and outer joins Use the Oracle Data Dictionary About the Web Site The accompanying Web site, https://www.box.com/shared/ylbckg2fn0 , contains all the SQL code and tables from the book, including the full databases for several versions of Access and code for building the corresponding Oracle databases. It also provides solutions to many of the book’s problems and an open area for discussions with the author and other readers.

In order to improve the performance and operational efficiency of businesses worldwide, a customer using SAP® wanted to establish a global business program to define and implement a standardized, group-wide business process architecture and associated master data for the parameterization of the group of software tools. The expected growth of the number of users and the size of the database would be at a level never reached by other customers, however, so IBM® was asked to undertake the following tasks: * Test the application to be sure that it can sustain such growth. This project illustrates the new near real time business intelligence (BI) context approached by customers who want the ability to rapidly analyze their business data to gain market shares. Data today comes from many diverse global sources and needs to be merged into an intelligent data warehouse. This IBM Redbooks® publication describes the testing that was done in terms of performance and manageability in an SAP NetWeaver® BI and DB2® environment on IBM System p™ when scaling a client's solution to a data warehouse of 60 terabytes (TB). This book resulted from a joint cooperative effort that included the PSSC, the IBM/SAP International Competency Center, the DB2-SAP Center of Excellence, SAP AG, and a customer. The customer involved in this project is a worldwide company employing more than 250,000 employees with factories and logistics operations in almost every country in the world. This project involved multiple technical skills and multiple products, as described here: * Chapter 1, "Project overview: business objectives, architecture, infrastructure, and results" on page 1, summarizes the entire project, starting from the business needs through the description of the environment and options used, to the results achieved. This chapter can be viewed as an executive summary from an IT specialist perspective. * Chapter 2, "The SAP NetWeaver BI perspective" on page 47; Chapter 3, "The DB2 perspective" on page 127; and Chapter 4, "The IBM System p perspective" on page 287, provide detailed views of the project from the perspectives of SAP specialists, DB2 specialists, and System p and AIX® specialists, respectively. * Chapter 5, "The system storage perspective" on page 319, and Chapter 6, "The Tivoli Storage Manager perspective" on page 349, describe the storage environment and the manageability issues in such a large environment. * Finally Appendix A, "The scripts used" on page 395, provides the scripts that we needed to develop for this project.

You're intelligent, right? So you've already figured out that Business Intelligence can be pretty valuable in making the right decisions about your business. But you’ve heard at least a dozen definitions of what it is, and heard of at least that many BI tools. Where do you start? Business Intelligence For Dummies makes BI understandable! It takes you step by step through the technologies and the alphabet soup, so you can choose the right technology and implement a successful BI environment. You'll see how the applications and technologies work together to access, analyze, and present data that you can use to make better decisions about your products, customers, competitors, and more. You’ll find out how to: Understand the principles and practical elements of BI Determine what your business needs Compare different approaches to BI Build a solid BI architecture and roadmap Design, develop, and deploy your BI plan Relate BI to data warehousing, ERP, CRM, and e-commerce Analyze emerging trends and developing BI tools to see what else may be useful Whether you’re the business owner or the person charged with developing and implementing a BI strategy, checking out Business Intelligence For Dummies is a good business decision.

The world of data warehousing has changed remarkably since the first edition of The Data Warehouse Lifecycle Toolkit was published in 1998. With this new edition, Ralph Kimball and his colleagues have refined the original set of Lifecycle methods and techniques based on their consulting and training experience. They walk you through the detailed steps of designing, developing, and deploying a data warehousing/business intelligence system. With substantial new and updated content, this second edition again sets the standard in data warehousing for the next decade.

“The authors, the best minds on the topic, are breaking new ground. They show how every organization can realize the benefits of a system that can search and present complex ideas or data from what has been a mostly untapped source of raw data.” --Randy Chalfant, CTO, Sun Microsystems The Definitive Guide to Unstructured Data Management and Analysis--From the World’s Leading Information Management Expert A wealth of invaluable information exists in unstructured textual form, but organizations have found it difficult or impossible to access and utilize it. This is changing rapidly: new approaches finally make it possible to glean useful knowledge from virtually any collection of unstructured data. William H. Inmon--the father of data warehousing--and Anthony Nesavich introduce the next data revolution: unstructured data management. Inmon and Nesavich cover all you need to know to make unstructured data work for your organization. You’ll learn how to bring it into your existing structured data environment, leverage existing analytical infrastructure, and implement textual analytic processing technologies to solve new problems and uncover new opportunities. Inmon and Nesavich introduce breakthrough techniques covered in no other book--including the powerful role of textual integration, new ways to integrate textual data into data warehouses, and new SQL techniques for reading and analyzing text. They also present five chapter-length, real-world case studies--demonstrating unstructured data at work in medical research, insurance, chemical manufacturing, contracting, and beyond. This book will be indispensable to every business and technical professional trying to make sense of a large body of unstructured text: managers, database designers, data modelers, DBAs, researchers, and end users alike. Coverage includes What unstructured data is, and how it differs from structured data First generation technology for handling unstructured data, from search engines to ECM--and its limitations Integrating text so it can be analyzed with a common, colloquial vocabulary: integration engines, ontologies, glossaries, and taxonomies Processing semistructured data: uncovering patterns, words, identifiers, and conflicts Novel processing opportunities that arise when text is freed from context Architecture and unstructured data: Data Warehousing 2.0 Building unstructured relational databases and linking them to structured data Visualizations and Self-Organizing Maps (SOMs), including Compudigm and Raptor solutions Capturing knowledge from spreadsheet data and email Implementing and managing metadata: data models, data quality, and more William H. Inmon is founder, president, and CTO of Inmon Data Systems. He is the father of the data warehouse concept, the corporate information factory, and the government information factory. Inmon has written 47 books on data warehouse, database, and information technology management; as well as more than 750 articles for trade journals such as Data Management Review, Byte, Datamation, and ComputerWorld. His b-eye-network.com newsletter currently reaches 55,000 people. Anthony Nesavich worked at Inmon Data Systems, where he developed multiple reports that successfully query unstructured data. Preface xvii 1 Unstructured Textual Data in the Organization 1 2 The Environments of Structured Data and Unstructured Data 15 3 First Generation Textual Analytics 33 4 Integrating Unstructured Text into the Structured Environment 47 5 Semistructured Data 73 6 Architecture and Textual Analytics 83 7 The Unstructured Database 95 8 Analyzing a Combination of Unstructured Data and Structured Data 113 9 Analyzing Text Through Visualization 127 10 Spreadsheets and Email 135 11 Metadata in Unstructured Data 147 12 A Methodology for Textual Analytics 163 13 Merging Unstructured Databases into the Data Warehouse 175 14 Using SQL to Analyze Text 185 15 Case Study--Textual Analytics in Medical Research 195 16 Case Study--A Database for Harmful Chemicals 203 17 Case Study--Managing Contracts Through an Unstructured Database 209 18 Case Study--Creating a Corporate Taxonomy (Glossary) 215 19 Case Study--Insurance Claims 219 Glossary 227 Index 233

FOREWORD by Tom Kyte Your Must-Have Guide to Everything New in Oracle Database 11 g Realize the full potential of Oracle Database 11 g with help from the experts. Written by Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code samples, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11 g, including: New Oracle Automatic Storage Management features, such as Fast Disk Resync, Compatibility Attributes, P referred Mirror Read, and Rolling Upgrade components Improved Automated Memory Management capabilities New database design features, such as virtual columns, tablespace encryption, and true table-level data compression New Database Advisors for data recovery and repair, partitioning, and streams performance New tuning features, such as Automatic SQL Tuning and SQL Performance Analyzer Enhancements to Oracle RMAN, including active database duplication and UNDO backup optimization Improved auditing and security capabilities Advanced BI, data warehousing, and partitioning features New SQL and PL/SQL enhancements

The Most Complete and Practical Guide to MySQL Version 5’s Powerful SQL Dialect MySQL version 5 offers a SQL dialect with immense power. In SQL for MySQL Developers, Rick F. van der Lans helps you master this version ofSQL and take advantage of its full potential. Using case study examplesand hands-on exercises, van der Lans illuminates every key concept,technique, and statement–including advanced features that make iteasier to create even the most complex statements and programs. Drawing on decades of experience as an SQL standards team member and enterprise consultant, he reveals exactly why MySQL’s dialect works as it does–and how to get the most out of it. You’ll gain powerful insight into everything from basic queries to stored procedures, transactions to data security. Whether you’re a programmer, Web developer, analyst, DBA, or database user, this book can take you from “apprentice” to true SQL expert. If you’ve used SQL in older versions of MySQL, you’ll become dramatically more effective–and if you’re migrating from other database platforms, you’ll gain practical mastery fast. Coverage includes Writing queries, including joins, functions, and subqueries Updating data Creating tables, views, and other database objects Specifying keys and other integrity constraints Improving efficiency with indexes Enforcing security via passwords and privileges Embedding SQL statements within PHP programs Building stored procedures and triggers Using transactions, locking, rollback, and isolation levels Utilizing MySQL’s catalog All of the book’s sample programs are available for download from www.r20.nl. About the Author Rick F. van der Lans is author of the classic Introduction to SQL, the definitive SQL guide that database developers have relied on for more than 20 years. He is a consultant, author, and lecturer specializing in database technology, development tools, data warehousing, and XML. As managing director of the Netherlands-based R20/Consultancy, he has advised many large companies on defining their IT architectures. He chairs the European Meta Data Conference, and writes columns for several magazines. Contents About the Author Preface PART I Introduction CHAPTER 1 Introduction to MySQL CHAPTER 2 The Tennis Club Sample Database CHAPTER 3 Installing the Software CHAPTER 4 SQL in a Nutshell PART II Querying and Updating Data CHAPTER 5 SELECT Statement: Common Elements CHAPTER 6 SELECT Statements, Table Expressions, and Subqueries CHAPTER 7 SELECT Statement:The FROM Clause CHAPTER 8 SELECT Statement: The WHERE Clause CHAPTER 9 SELECT Statement: SELECT Clause and Aggregation Functions CHAPTER 10 SELECT Statement: The GROUP BY Clause CHAPTER 11 SELECT Statement: The HAVING Clause CHAPTER 12 SELECT Statement: The ORDER BY Clause CHAPTER 13 SELECT Statement: The LIMIT Clause CHAPTER 14 Combining Table Expressions CHAPTER 15 The User Variable and the SET Statement CHAPTER 16 The HANDLER Statement CHAPTER 17 Updating Tables CHAPTER 18 Loading and Unloading Data CHAPTER 19 Working with XML Documents PART III Creating Database Objects CHAPTER 20 Creating Tables CHAPTER 21 Specifying Integrity Constraints CHAPTER 22 Character Sets and Collations CHAPTER 23 The ENUM and SET Types CHAPTER 24 Changing and Dropping Tables CHAPTER 25 Using Indexes CHAPTER 26 Views CHAPTER 27 Creating Databases CHAPTER 28 Users and Data Security CHAPTER 29 Statements for Table Maintenance CHAPTER 30 The SHOW, DESCRIBE, and HELP Statements PART IV Procedural Database Objects CHAPTER 31 Stored Procedures CHAPTER 32 Stored Functions CHAPTER 33 Triggers CHAPTER 34 Events PART V Programming with SQL CHAPTER 35 MySQL and PHP CHAPTER 36 Dynamic SQL with Prepared Statement CHAPTER 37 Transactions and Multiuser Usage APPENDIX A Syntax of SQL APPENDIX B Scalar Functions APPENDIX C System Variables APPENDIX D Bibliography Index

Up-to-date, comprehensive coverage of the Oracle database and business intelligence tools Written by a team of Oracle insiders, this authoritative book provides you with the most current coverage of the Oracle data warehousing platform as well as the full suite of business intelligence tools. You'll learn how to leverage Oracle features and how those features can be used to provide solutions to a variety of needs and demands. Plus, you'll get valuable tips and insight based on the authors' real-world experiences and their own implementations. Avoid many common pitfalls while learning best practices for: Leveraging Oracle technologies to design, build, and manage data warehouses Integrating specific database and business intelligence solutions from other vendors Using the new suite of Oracle business intelligence tools to analyze data for marketing, sales, and more Handling typical data warehouse performance challenges Uncovering initiatives by your business community, security business sponsorship, project staffing, and managing risk

Microsoft SQL Server Analysis Services provides fast access to data by means of multidimensional data structures and the multidimensional query languag MDX. Analysis Services provides the capability to design, create, and manage multidimensional cubes based on data warehouse tables, and it serves as the foundation for the Microsoft Business Intelligence strategy. Microsoft SQL Server 2005 Analysis Services gives the reader insight into the way Analysis Services functions. It not only explains ways to design and create multidimensional objects, databases, dimensions, and cubes, but also provides invaluable information about the reasons behind design decisions made by the development team. Here's what you will find inside: Understand the key concepts of multidimensional modeling Explore the multidimensional object model and its definition language Learn the main concepts of the MDX language and gain an in-depth understanding of advanced MDX concepts Understand the mechanisms of integrating multidimensional and relational databases Learn how to build client applications to access data in Analysis Services Examine server architecture, including main data structures, data processing, and query resolution algorithms Gain a deep understanding of the internal and external protocols for data transfer, including the XML/A protocol Explore how Analysis Services manages memory Explore the security model, including role-based security, code-access security, and data security Discover how to monitor and manage Analysis Services All the code for the sample database used in the book can be found at www.informit.com/title/0672327821.

In this IBM Redbooks publication we describe and discuss DB2 Data Warehouse Edition (DWE) Version 9.1, a comprehensive platform offering with functionality to build a business intelligence infrastructure for analytics and Web-based applications, and best practices for deployment. DB2 DWE integrates core components for data warehouse construction and administration, data mining, OLAP, and InLine Analytics and reporting. It extends the DB2 data warehouse with design-side tooling and runtime infrastructure for OLAP, data mining, InLine Analytics, and intra-warehouse data movement and transformation, on a common platform based on DB2 and WebSphere. The platform pillars are based on the technology of DB2, Rational Data Architect (for physical data modeling only), the SQL Warehousing Tool, Intelligent Miner, DB2 Cube Views, and Alphablox. DWE includes an Eclipse-based design environment, DWE Design Studio, that integrates the DWE products (with the exception of Alphablox and Query Patroller) with a common framework and user interface. The new SQL Warehousing Tool enables visual design of intra-warehouse, table-to-table data flows and control flows using generated SQL. DB2 Alphablox is the tool for developing custom applications with embedded analytics-based visual components. DWE enables faster time-to-value for enterprise analytics, while limiting the number of vendors, tools, skill sets and licenses required.

"This book is the definitive guide for SAP NetWeaver BI professionals. Based on their extraordinary expertise with the product, the authors provide deep insights about key innovations in the areas of user experience, query performance, integrated planning, and enterprise-wide data warehousing." —Stefan Sigg, Vice President, SAP NetWeaver Business Intelligence The long-anticipated publication of this second edition reflects the growing success of SAP NetWeaver as well as the various Business Intelligence (BI) capabilities that are embedded with SAP BW version 7.0. Written by SAP insiders, this comprehensive guide takes into account the ever-changing features, functionality, and toolsets of SAP NetWeaver to bring you the most updated information on how to use SAP BW to design, build, deploy, populate, access, analyze, present, and administer data. You'll discover the options that are available in SAP NetWeaver and uncover a new means to improve business performance. This book reflects the process an organization goes through during an implementation of the software. The authors begin with an introduction to BI and SAP NetWeaver and quickly progress to information modeling and enterprise data warehouse concepts. You'll learn how to access and deliver meaningful analytic information to the organization, as well as perform integrated planning functions. Finally, the authors share invaluable insight on warehouse administration, performance, and security. With more than 50 percent new or revised material, this second edition of Mastering the SAP Business Information Warehouse shows you how to: Extract data from online transaction processing systems Store transformed data in a way that best supports reporting and analysis Use the various Business Explorer tools such as BEx Report Designer, BEx Analyzer, BEx Broadcaster, and BEx Web Application Designer Schedule, monitor, troubleshoot, and archive data loads The companion Web site contains sample chapters in Wiki format and the authors' blog where readers may enter discussions about the book and SAP. Wiley Technology Publishing Timely. Practical. Reliable. Visit our Web site at www.wiley.com/compbooks/ Visit the companion Web site at www.wiley.com/compbooks/mcdonald The companion Web site contains the sample code presented in the text of the book, plus implementation templates.

This is the first book to provide in-depth coverage of star schema aggregates used in dimensional modeling-from selection and design, to loading and usage, to specific tasks and deliverables for implementation projects Covers the principles of aggregate schema design and the pros and cons of various types of commercial solutions for navigating and building aggregates Discusses how to include aggregates in data warehouse development projects that focus on incremental development, iterative builds, and early data loads

Serving as both a tutorial and a reference guide to the MDX (Multidimensional Expressions) query language, this book shows data warehouse developers what they need to know to build effective multidimensional data warehouses After a brief overview of the MDX language and a look at how it is used to access data in sophisticated, multidimensional databases and data warehousing, the authors move directly to providing practical examples of MDX in use New material covers changes in the MDX language itself as well as major changes in its implementation with the latest software releases of Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase Also covers more advanced techniques, like aggregation, query templates, and MDX optimization, and shows users what they need to know to access and analyze data to make better business decisions Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

This groundbreaking book is the first in the Kimball Toolkit series to be product-specific. Microsoft’s BI toolset has undergone significant changes in the SQL Server 2005 development cycle. SQL Server 2005 is the first viable, full-functioned data warehouse and business intelligence platform to be offered at a price that will make data warehousing and business intelligence available to a broad set of organizations. This book is meant to offer practical techniques to guide those organizations through the myriad of challenges to true success as measured by contribution to business value. Building a data warehousing and business intelligence system is a complex business and engineering effort. While there are significant technical challenges to overcome in successfully deploying a data warehouse, the authors find that the most common reason for data warehouse project failure is insufficient focus on the business users and business problems. In an effort to help people gain success, this book takes the proven Business Dimensional Lifecycle approach first described in best selling The Data Warehouse Lifecycle Toolkit and applies it to the Microsoft SQL Server 2005 tool set. Beginning with a thorough description of how to gather business requirements, the book then works through the details of creating the target dimensional model, setting up the data warehouse infrastructure, creating the relational atomic database, creating the analysis services databases, designing and building the standard report set, implementing security, dealing with metadata, managing ongoing maintenance and growing the DW/BI system. All of these steps tie back to the business requirements. Each chapter describes the practical steps in the context of the SQL Server 2005 platform. Intended Audience The target audience for this book is the IT department or service provider (consultant) who is: Planning a small to mid-range data warehouse project; Evaluating or planning to use Microsoft technologies as the primary or exclusive data warehouse server technology; Familiar with the general concepts of data warehousing and business intelligence. The book will be directed primarily at the project leader and the warehouse developers, although everyone involved with a data warehouse project will find the book useful. Some of the book’s content will be more technical than the typical project leader will need; other chapters and sections will focus on business issues that are interesting to a database administrator or programmer as guiding information. The book is focused on the mass market, where the volume of data in a single application or data mart is less than 500 GB of raw data. While the book does discuss issues around handling larger warehouses in the Microsoft environment, it is not exclusively, or even primarily, concerned with the unusual challenges of extremely large datasets. About the Authors JOY MUNDY has focused on data warehousing and business intelligence since the early 1990s, specializing in business requirements analysis, dimensional modeling, and business intelligence systems architecture. Joy co-founded InfoDynamics LLC, a data warehouse consulting firm, then joined Microsoft WebTV to develop closed-loop analytic applications and a packaged data warehouse. Before returning to consulting with the Kimball Group in 2004, Joy worked in Microsoft SQL Server product development, managing a team that developed the best practices for building business intelligence systems on the Microsoft platform. Joy began her career as a business analyst in banking and finance. She graduated from Tufts University with a BA in Economics, and from Stanford with an MS in Engineering Economic Systems. WARREN THORNTHWAITE has been building data warehousing and business intelligence systems since 1980. Warren worked at Metaphor for eight years, where he managed the consulting organization and implemented many major data warehouse systems. After Metaphor, Warren managed the enterprise-wide data warehouse development at Stanford University. He then co-founded InfoDynamics LLC, a data warehouse consulting firm, with his co-author, Joy Mundy. Warren joined up with WebTV to help build a world class, multi-terabyte customer focused data warehouse before returning to consulting with the Kimball Group. In addition to designing data warehouses for a range of industries, Warren speaks at major industry conferences and for leading vendors, and is a long-time instructor for Kimball University. Warren holds an MBA in Decision Sciences from the University of Pennsylvania's Wharton School, and a BA in Communications Studies from the University of Michigan. RALPH KIMBALL, PH.D., has been a leading visionary in the data warehouse industry since 1982 and is one of today's most internationally well-known authors, speakers, consultants, and teachers on data warehousing. He writes the "Data Warehouse Architect" column for Intelligent Enterprise (formerly DBMS) magazine.

You know the rudiments of the SQL query language, yet you feel you aren't taking full advantage of SQL's expressive power. You'd like to learn how to do more work with SQL inside the database before pushing data across the network to your applications. You'd like to take your SQL skills to the next level. Let's face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT columns FROM table WHERE conditions. But there is so much more you can do with the language. In the SQL Cookbook, experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You'll learn about: Window functions, arguably the most significant enhancement to SQL in the past decade. If you're not using these, you're missing out Powerful, database-specific features such as SQL Server's PIVOT and UNPIVOT operators, Oracle's MODEL clause, and PostgreSQL's very useful GENERATE_SERIES function Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set Bucketization, and why you should never use that term in Brooklyn. How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques The technique of walking a string, which allows you to use SQL to parse through the characters, words, or delimited elements of a string Written in O'Reilly's popular Problem/Solution/Discussion style, the SQL Cookbook is sure to please. Anthony's credo is: "When it comes down to it, we all go to work, we all have bills to pay, and we all want to go home at a reasonable time and enjoy what's still available of our days." The SQL Cookbook moves quickly from problem to solution, saving you time each step of the way.

The new edition of the classic bestseller that launched the data warehousing industry covers new approaches and technologies, many of which have been pioneered by Inmon himself In addition to explaining the fundamentals of data warehouse systems, the book covers new topics such as methods for handling unstructured data in a data warehouse and storing data across multiple storage media Discusses the pros and cons of relational versus multidimensional design and how to measure return on investment in planning data warehouse projects Covers advanced topics, including data monitoring and testing Although the book includes an extra 100 pages worth of valuable content, the price has actually been reduced from $65 to $55

This book is a must read for anyone deploying BusinessObjects. It covers everything from planning your upgrade to the latest release, to best practices in universe design, and powerful report creation that maximizes business insight. This book covers the most frequently used features for the full BI suite, in one comprehensive book. There's in depth coverage of Designer, security via the Central Management Console, InfoView, Web Intelligence, and Desktop Intelligence. It goes beyond step-by-step instructions to cover how and why in a business context. Transition notes are interspersed for version 5 and 6 customers to understand the biggest changes in XI Release 2. If you drive BI requirements in your company or are a data warehouse program manager, Business Objects administrator, report author or consumer, this book is for you.

“Riordan covers core skills for any developer—database design and development—in a perfect amount of detail. This book should be on every professional developer’s reading list.” — Duncan Mackenzie, developer, Microsoft (MSDN) “Designing a database is not a trivial subject. Riordan brings experience and clear explanations to a fundamental part of software development.” — Patrick Birch, database and technical writing consultant “If you buy only one book on database design, make it this one. Riordan has a talent for explaining technical issues in simple language, without over simplifying.” — Brendan Reynolds, developer, Dataset IT Systems and Microsoft Access MVP “A book that will expertly guide you in how to develop a database for a client— and how to do it right the first time!” — Kenneth D. Snell, Ph.D., ACCESS developer and Microsoft Access MVP “Riordan has produced a unique book that brings together a formal, yet commonsense, approach to relational database design...and then goes further! Many database designers will find immense value in the steps to developing practical data warehouse designs. If you are seeking a framework for designing transactional databases, or want to step out into the world of analytical databases, Riordan’s book excels at bridging both worlds.” — Paul Irvine, vice president, engineering, Via Training “Riordan takes a complex subject and makes it easy. If you’re over your head on a database design project, this book will help bail you out!” — Mike Gunderloy, contributing editor, Application Development Trends “This book covers a wide range of database design and data modeling topics in a well-organized, easy to understand format.” — Amy Sticksel, Sticksel Data Systems, Inc. “In Riordan’s style, wit, and attention to detail are outstanding.” Designing Effective Database Systems, — Sandra Daigle, Microsoft Access MVP The Software Developer’s Step-by-Step Guide to Database Design World-renowned expert Rebecca M. Riordan has written the definitive database design book for working developers who aren’t database experts. No matter how messy or complex your data challenge, shows you how to design an effective, high-performance database to solve it. Designing Effective Database Systems Riordan begins by thoroughly demystifying the principles of relational design, making them accessible to every professional developer. Next, she offers the field’s clearest introduction to dimensional database modeling—practical insight for designing today’s increasingly important analytical applications. One task at a time, the author illuminates every facet of database analysis and design for both traditional databases and the dimensional databases used for data warehousing, showing how to avoid common architectural pitfalls that complicate development and reduce extensibility. The book concludes with comprehensive, expert guidance on designing databases for maximum usability. This book will teach you to Understand relational database models, structures, relationships, and data integrity principles Define database system goals, criteria, scope, and work processes Construct accurate conceptual models: relationships, entities, domain analysis, and normalization Build efficient, secure database schema Master the elements of online analytical processing (OLAP) design: fact tables, dimension tables, snowflaking, and more Architect and construct easy, efficient interfaces for querying and reporting Learn from practice examples based on Microsoft’s Northwind sample database Riordan has helped thousands of professionals master database design and development, earning Microsoft’s coveted MVP honor for her exceptional contributions. Nobody is more qualified to help you master database design and apply it in your real-world environment.

The Oracle SQL is a must-have for anyone working with Oracle databases, especially those looking to maximize the effectiveness of SQLPlus. As Oracle's long-standing interactive query tool, SQL Plus Pocket Reference Plus is available at every Oracle site, from the largest data warehouse to the smallest single-user system. Despite its wide use, however, SQLPlus is still often not completely understood or fully utilized.Database administrators and developers alike will therefore find the Oracle SQL to be extremely beneficial. In addition to summarizing all of the SQLPlus syntax and format options, including new Oracle Database 10 Plus Pocket Reference g features, this handy, on-the-job guide specifically shows readers how to: The new third edition of this book has been updated for Oracle Database 10 Differentiate between SQL and SQL Plus Interact with SQLPlus from both the command line and the web browser Select, insert, update, and delete data Format both text and HTML reports with SQL Plus Specify SQLPlus commands and format elements Tune SQL queries g to include information on both SQL Plus and SQL. New SQL information includes the SELECT statement's new MODEL clause, flashback queries, partition outer joins, and DBMS_XPLAN.With its quick-reference format and compact size, the Plus Pocket Reference follows in the long line of successful "pocket references" offered by O'Reilly. It also serves as the ideal companion to O'Reilly's larger, more comprehensive book on SQL Oracle SQL Plus, the bestselling Plus: The Definitive Guide.Author Jonathan Gennick is an editor for O'Reilly specializing in database and programming titles, having amassed some 17 years of programming and database management experience. Oracle SQL