rss Home » Tag Archive For ‘SQL’

Oracle Essbase 11 Development Cookbook

Oracle Essbase 11 Development Cookbook

Book Description

Essbase is a Multi-Dimensional Online Analytical Processing () server, providing a rich environment for effectively developing custom analytic and enterprise management applications. Essbase enables users to quickly model complex scenarios.

This practical shows you the advanced techniques when building Essbase Applications and how to take these applications further.

Packed with over 90 task-based and immediately reusable recipes, this book starts by showing you how to use a relational data model to build and load an Essbase cube and how to create a data source, prepare the mini schema, and work with the data elements in Essbase Studio. The book then dives into topics such as building the BSO cube, building the ASO cube, using for , creating Calculation Scripts and using MaxL to automate processes.

What you will learn from this book

  • Design components of a Data Mart to use as data source, maintain meta-data, and support drill-through .
  • Setup a Data Source and Minischema in Essbase Studio so that metadata elements can be manipulated and hierarchies built.
  • Create an Essbase Model, Cube Schema, drill-through report, and deploy both a Block Storage (BSO) and Aggregate Storage (ASO) application. Download Now »

Oracle Database 11g R2 Performance Tuning Cookbook

Oracle Database 11g R2 Performance Tuning Cookbook

Book Description

’s offers great , scalability, and many features for DBAs and developers. Due to a wide choice of technologies, successful applications are good candidates to run into issues and when a problem arises it’s very difficult to identify the cause and the right solution to the problem.

The 11g R2 Tuning helps DBAs and developers to understand every aspect of that can affect performance. You will be guided through implementing the correct solution in a proactive way before problems arise, and how to diagnose issues on your -based solutions.

This fast-paced book offers solutions starting from application design and , through the implementation of well-performing applications, to the details of deployment and delivering best-performance databases.

With this book you will quickly learn to apply the right methodology to tune the performance of an , and to optimize application design and and code. By following the real-world examples you will see how to store your data in correct structures and access and manipulate them at a lightning speed. You will learn to speed up sort operations, hack the optimizer and the data loading process, and diagnose and tune memory, I/O, and contention issues.

The purpose of this is to provide concise recipes, which will help you to build and maintain a very high-speed Oracle Database environment. Download Now »

Beginning iOS 5 Development: Exploring the iOS SDK

Beginning iOS 5 Development: Exploring the iOS SDK

Book Description

The team that brought you the bestselling Beginning 4  is back again for Beginning 5 , bringing this definitive guide up-to-date with ’s latest and greatest SDK, as well as with the latest version of .

There’s coverage of brand new technologies, with chapters on storyboards and , for example, as well as significant updates to existing chapters to bring them in line with all the changes that came with the iOS 5 SDK. You’ll have everything you need to create your very own apps for the latest iOS devices, including the 4S, 2, and the latest . Every single sample program in the book has been rebuilt from scratch using 4.2 and the latest iOS 5-specific project templates and designed to take advantage of the latest features.

Assuming only a minimal working knowledge of Objective-, and written in a friendly, easy-to-follow style, Beginning iOS 5 Development offers a complete soup-to-nuts course in iPhone, , and . The book starts with the basics, walking through the process of downloading and installing Xcode and the iOS 5 SDK, and then guides you though the creation of your first simple application.

From there, you’ll learn how to integrate all the interface elements touch users have come to know and love, such as buttons, switches, pickers, toolbars, and sliders. You’ll master a variety of design patterns, from the simplest single view to complex hierarchical drill-downs. The confusing art of table building will be demystified, and you’ll learn how to save your data Download Now »

Introduction to Design Patterns in C++ with Qt, 2nd Edition

Introduction to Design Patterns in C++ with Qt, 2nd Edition

Book Description

Master ++ “The Way” with Modern Design Patterns and Efficient Reuse

This fully updated, classroom-tested book teaches ++ “The Way,” emphasizing design patterns and efficient reuse. Readers will master both the ++ language and Qt libraries, as they learn to develop maintainable software with well-defined code layers and simple, reusable classes and functions.

Every chapter of this edition has been improved with new content, better organization, or both. Readers will find extensively revised coverage of QObjects, Reflection, Widgets, Main Windows, Models and Views, Databases, Multi-Threaded , and Reflection. This edition introduces the powerful new Qt Creator IDE; presents new multimedia APIs; and offers extended coverage of Qt Designer and C++ Integration. It has been restructured to help readers start writing software immediately and write robust, effective software sooner.

The authors introduce several new design patterns, add many quiz questions and labs, and present more efficient solutions relying on new Qt features and best practices. They also provide an up-to-date C++ reference section and a complete application case study.

  • Master C++ keywords, literals, identifiers, declarations, types, and type conversions.
  • Understand classes and objects, organize them, and describe their interrelationships.
  • Learn consistent style and naming rules.
  • Use lists, functions, and other essential techniques. Download Now »

Professional Microsoft SQL Server Analysis Services 2008 with MDX

Professional Microsoft SQL Server Analysis Services 2008 with MDX

Book Description

  • When used with the query language, Services allows developers to build full-scale applications to support such functions as budgeting, forecasting, and market .
  • Shows readers how to build data warehouses and multi-dimensional databases, query databases, and use Analysis Services and other components of to provide end-to-end solutions
  • Revised, updated, and enhanced, the book discusses new features such as improved integration with Office and Excel 2007; query enhancements; improvements to aggregation designer, dimension designer, cube and dimension wizards, and cell writeback; extensibility and personalization; data mining; and more

From the Back Cover
The new features of Analysis Services 2008 make it even easier to use andbuild your databases for efficient and improved . This authoritative book, written by key members of the Analysis Services product team at , explains how to best use these enhancements for your needs. The authors provides you with valuable insight on how to use Analysis Services 2008 effectively to build, process, and deploy top-of-the-line intelligence applications.

You’ll explore everything that Analysis Services 2008 has to offer and examinethe important features of this product with the help of step-by-step instructionson building Download Now »

Professional Microsoft SQL Server 2008 Reporting Services

Professional Microsoft SQL Server 2008 Reporting Services

Book Description

  • Teaches solution architects, designers, and developers how to use ’s platform to create and intelligence (BI) solutions
  • Updated with new information about holistic BI solutions, comprehensive / Services , and complete production deployment scenarios
  • Includes examples focused on specific, scenario-based solutions
  • Explains reporting services architecture and intelligence, teaches the fundamentals of designing reports through the use of careful planning considerations, and covers advanced report design and filtering techniques

From the Back Cover
Professional 2008 Reporting Services

Reporting Services makes reporting faster and easier than ever. This hands-on guide will show you how to harness the full power of Reporting Services to create reporting and business intelligence solutions that meet your company’s needs. It walks you step-by-step through the fundamentals of designing the most effective reports by following careful planning considerations.

The authors progress from beginning to advanced report design and filtering techniques, showing you the conditions where reports could be more efficient. They also explore holistic business intelligence solutions, comprehensive / Services reporting, and complete production-deployment scenarios. Download Now »