When used with the MDX query language, SQL Server Analysis Services allows developers to build full-scale database applications to support such business functions as budgeting, forecasting, and market analysis. Shows readers how to build data warehouses and multi-dimensional databases, query databases, and use Analysis Services and other components of SQL Server 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 performance enhancements; improvements to aggregation designer, dimension designer, cube and dimension wizards, and cell writeback; extensibility and personalization; data mining; and more

SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble–shooting methodology for identifying poorly-performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems. Each chapter is dedicated to one of the top causes of poorly performing queries and shows methods for identifying and dealing with the problems in that chapter's domain. Emphasis is always put upon or placed upon practical methods that you can put to immediate use in your day-to-day work. SQL Server 2008 functionality, tips, and tricks are emphasized in each subject area. Emphasizes the practical. Does not bury readers in theory. Gives readers practical techniques to immediately apply in their daily work. Dedicates a chapter to each of the most common, performance-related problem areas.

Live Partition Mobility is the next step in the IBMs Power Systems™ virtualization continuum. It can be combined with other virtualization technologies, such as logical partitions, Live Workload Partitions, and the SAN Volume Controller, to provide a fully virtualized computing platform that offers the degree of system and infrastructure flexibility required by today's production data centers. This IBM® Redbooks® publication discusses how Live Partition Mobility can help technical professionals, enterprise architects, and system administrators: * Migrate entire running AIX® and Linux® partitions and hosted applications from one physical server to another without disrupting services and loads. * Meet stringent service-level agreements. * Rebalance loads across systems quickly, with support for multiple concurrent migrations. * Use a migration wizard for single partition migrations. This book can help you understand, plan, prepare, and perform partition migration on IBM Power Systems POWER6™ technology-based servers that are running AIX.

This IBM® Redbooks® publication discusses IBM Tivoli® Netcool® Service Quality Manager V4.1.1 data mediation development. It is aimed at implementers and system integrators connecting new data sources that will be managed by Service Quality Manager. Data mediation in Service Quality Manager is performed by Perl gateways. Gateways extract data from vendor specific hardware monitors and prepare the data to be loaded into the Service Quality Manager application. The development aspect of data mediation for gateways uses Perl extensively. The control files or rules are written as Perl subroutines. We discuss the detailed specifications and processing of these mediation rules.

Delve inside the core SQL Server engine—and put that knowledge to work—with guidance from a team of well-known internals experts. Whether database developer, architect, or administrator, you’ll gain the deep knowledge you need to exploit key architectural changes—and capture the product’s full potential. Discover how SQL Server works behind the scenes, including: What happens internally when SQL Server builds, expands, shrinks, and moves databases How to use event tracking—from triggers to the Extended Events Engine Why the right indexes can drastically reduce your query execution time How to transcend normal row-size limits with new storage capabilities How the Query Optimizer operates Multiple techniques for troubleshooting problematic query plans When to force SQL Server to reuse a cached query plan—or create a new one What SQL Server checks internally when running DBCC How to choose among five isolation levels and two concurrency models when working with multiple concurrent users

This guide demonstrates how to secure sensitive data and comply with internal and external audit regulations using Oracle 10g and 11g. It provides the hands-on guidance required to understand the complex options provided by Oracle and the know-how to choose the best option for a particular case.

This updated study guide for the latest release of the most popular database software in the world—Oracle Database 11 g— reviews using the RMAN recovery catalog, handling Flashback technology, managing memory and resources, automating tasks, diagnosing the database, and much more. Plus, more than 100 pages of workbook exercises help prepare you to take the 1Z0-053 exam. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Big Data: when the size and performance requirements for data management become significant design and decision factors for implementing a data management and analysis system. For some organizations, facing hundreds of gigabytes of data for the first time may trigger a need to reconsider data management options. For others, it may take tens or hundreds of terabytes before data size becomes a significant consideration.

Data warehousing is one of the hottest business topics, and there’s more to understanding data warehousing technologies than you might think. Find out the basics of data warehousing and how it facilitates data mining and business intelligence with Data Warehousing For Dummies, 2nd Edition. Data is probably your company’s most important asset, so your data warehouse should serve your needs. The fully updated Second Edition of Data Warehousing For Dummies helps you understand, develop, implement, and use data warehouses, and offers a sneak peek into their future. You’ll learn to: Analyze top-down and bottom-up data warehouse designs Understand the structure and technologies of data warehouses, operational data stores, and data marts Choose your project team and apply best development practices to your data warehousing projects Implement a data warehouse, step by step, and involve end-users in the process Review and upgrade existing data storage to make it serve your needs Comprehend OLAP, column-wise databases, hardware assisted databases, and middleware Use data mining intelligently and find what you need Make informed choices about consultants and data warehousing products Data Warehousing For Dummies, 2nd Edition also shows you how to involve users in the testing process and gain valuable feedback, what it takes to successfully manage a data warehouse project, and how to tell if your project is on track. You’ll find it’s the most useful source of data on the topic!

Teach yourself the Multidimensional Expressions (MDX) query language—one step at a time. With this practical, learn-by-doing tutorial, you’ll build the core techniques for using MDX with Analysis Services to deliver high-performance business intelligence solutions. Discover how to: Construct and execute MDX queries Work with tuples, sets, and expressions Build complex sets to retrieve the exact data users need Perform aggregation functions and navigate data hierarchies Assemble time-based business metrics Customize an Analysis Services cube through the MDX script Implement dynamic security to control data access Develop MDX-driven reports in SQL Server Reporting Services CD features: Practice exercises Database and code samples Fully searchable eBook

Teach yourself how to build, manage, and access SQL Server 2008 reports one step at a time. Whether you re a report developer, IT administrator, or business user, this sequential, learn-by-doing tutorial shows you how to deliver the business intelligence information your organization needs. Discover how to: Install and configure Reporting Services Put Report Builder and Report Designer tools to work Create interactive, online reports that enable users to sort and filter data Add charts and gauges to present data visually Deploy reports to Microsoft Office SharePoint Server Monitor server performance and help secure content Use subscriptions to distribute reports via e-mail Build ad hoc reports and extend them with custom code CD features: Practice exercises and code samples Fully searchable eBook.

Data leaks expose your customers to identity theft and your business to security risks. But how do you set up a data loss prevention plan? Start with Data Leaks For Dummies! Now more than ever, it’s critical to keep your company data locked up tighter than Fort Knox. Data Leaks For Dummies has the scoop on what’s at risk, how leaks happen, how to keep your data safe without being inflexible, and even what to do if the worst happens. It shows you how to: Identify risk by learning to see your data the way a criminal would Recognize how innocent mistakes, common carelessness, and malicious insiders also pose a threat Learn how to defend against phishing, e-mail threats, and wireless security breaches Be alert for social engineering attacks, suspicious contract workers, dumpster divers, and plain old eavesdroppers Plan for safe disposal of old hardware, use caution with SMS and e-mail archives, and be aware of how Webcasts and conference calls can be invaded Discover how crooks steal data in public places such as Internet cafes Develop a recovery plan, build a team, and even manage press coverage should data loss occur You’ll learn why free data storage devices could cost you a lot, how to protect mobile devices, why data corruption might be even worse than data loss, and how you can help software developers build safer applications. Data Leaks For Dummies will help you protect your customers, the reputation of your business, and your bottom line.

The market for Radio Frequency Identification (RFID) technology is expanding rapidly, constituting billions of dollars annually. As more organizations adopt RFID solutions and related equipment, the need to route, map, and execute workflows based on RFID data grows exponentially. Microsoft's solution to this demand is BizTalk RFID, an application built to distribute, track, analyze, and provide visibility into enterprise data collected using RFID technologies. To aid in the rapid understanding and adoption of BizTalk RFID, this book's authors have joined together to present Pro RFID in BizTalk Server 2009, the definitive resource for unlocking the potential of the application. With extensive code and configuration examples and multiple case studies illustrating how this application is being used in various industries, authors Ram Venkatesh, the lead developer of the BizTalk RFID platform, Mark Simms, a leading architect and developer of BizTalk RFID solutions, and Mark Beckner, a BizTalk Server and enterprise architecture specialist, ensure that you will gain the insight and master the tools necessary to be able to confidently and efficiently implement a BizTalk RFID solution. What you'll learn Understand RFID BizTalk application design and architecture. Build and develop an RFID BizTalk solution. Explore in-depth analysis and examples for event and command processing. Utilize and implement Mobile RFID solutions. Instantiate workflows with the core BizTalk engine's adapters and orchestrations. Validate and route data using the Business Rules Engine. Integrate with MSMQ, WCF, web services, and external applications to ensure enterprise adoption. Understand guidelines around testing, deploying, and managing RFID BizTalk solutions. Store and access RFID-related metrics. Learn how the technology is being applied across numerous industries through extensive real-world case studies. Who this book is for This book is for solution architects, application developers, and IT administrators involved in the development and deployment of Microsoft BizTalk RFID solutions. The essential reference for covering the vital aspects of building solutions with Microsoft BizTalk RFID, adding crucial real-world context and experience to the standard product documentation, this book will cover the end-to-end BizTalk RFID experience: learning, developing, deploying, and managing. Readers at any level of experience should expect to walk away with concrete, tangible actions that can be taken to achieve success with any BizTalk RFID implementation.

GIS (geographic information system) is a totally cool technology that has been called "geography on steroids." GIS is what lets you see the schools in your neighborhood or tells you where the nearest McDonald's is. GIS For Dummies tells you all about mapping terminology and digital mapping, how to locate geographic features and analyze patterns such as streets and waterways, and how to generate travel directions, customer location lists, and much more with GIS. Whether you're in charge of creating GIS applications for your business or you simply love maps, you'll find GIS For Dummies is packed with information. For example, you can: Learn all the hardware and software necessary to collect, analyze, and manipulate GIS data Explore the difference between 2D and 3D maps, create a map, or manage multiple maps Analyze patterns that appear in maps and interpret the results Measure distance in absolute, comparative, and functional ways Recognize how spatial factors relate to geographic data Discover how GIS is used in business, the military, city planning, emergency services, land management, and more Find out how GIS can help you find out where flooding may occur Determine what your organization needs, do appropriate analyses, and actually plan and design a GIS system You'll find dozens of applications for GIS queries and analyses, and even learn to create animated GIS output. Whether your goal is to implement a GIS or just have fun, GIS For Dummies will get you there! Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

XML has become the standard for all kinds of integration and deployment of applications, regardless of the technology platform. XML & Related Technologies covers all aspects of dealing with XML, both from a conceptual as well as from a practical po

Your One-Stop Guide to Oracle CRM On Demand Reporting Plan, build, and distribute data-rich business intelligence reports with ease. Oracle CRM On Demand Reporting details the entire report-building process and explains how to use the powerful features available in Answers On Demand to create and share comprehensive, integrated reports. The book includes proven strategies for report design and development, real-world examples, formatting tips, advanced reporting techniques, and sample formulas. Convert disparate corporate data into actionable business intelligence with help from this detailed guide. Maximize the features of Answers On Demand Strategically plan your reports Format, sort, filter, and modify report data Use column formulas with numeric, date and time, and text data Apply logic and transform data with column formulas Format report title and table views Add charts, graphs, pivot tables, filter prompts, and interactivity to reports Configure advanced views and create custom dashboards Manage reports and control access

Advice and techniques that you need to get the job done. Looking for ways to streamline your work so that you can focus on maximizing your time? In Depth provides specific, tested, and proven solutions to the problems you run into every day–things other books ignore or oversimplify. This is the one book that you can rely on to answer all the questions you have now and will have in the future. In Depth offers: Comprehensive coverage, with detailed solutions Breakthrough techniques and shortcuts that are unavailable elsewhere Practical, real-world examples with nothing glossed over or left out Troubleshooting help for tough problems you can’t fix on your own Outstanding authors recognized worldwide for their expertise and teaching style Quick information via sidebars, tips, reminders, notes, and warnings In Depth is the only tool you need to get more done in less time! CATEGORY: Databases COVERS: FileMaker® Pro

In the classic style of Manning's "In Action" series, NHibernate in Action introduces .NET developers to the NHibernate Object/Relational Mapping tool. As NHibernate is a port of Hibernate from Java to .NET, the book is based on Manning's bestselling Hibernate in Action. NHibernate in Action begins by describing how to implement persistence in a layered .NET application. The book then quickly springs into action by introducing NHibernate through a classic "Hello World" example. It explains how to configure NHibernate to specify the mapping information between business objects and database tables, and then explores the internal architecture of NHibernate. A complete example application is progressively built with Agile methodologies in mind, which shows readers all kinds of entity and relationship mappings and how to perform CRUD operations. The book also covers advanced techniques like caching, concurrency access, and isolation levels. The Hibernate Query Language (HQL) and criteria query APIs are thoroughly detailed with optimization tips. The last chapters of this book discuss various development scenarios, how to implement the layers of an NHibernate application (covering Windows and Web development), and which tools are available for these tasks. They also provide some solutions for data-binding objects to .NET GUI controls, integrating services, and interacting with components using DataSets. Finally, they explain how to build a complex application involving advanced session management and distributed transactions. About the Technology About the Book NHibernate in Action begins by describing how to implement persistence in a layered .NET application. The book then quickly springs into action by introducing NHibernate through a classic "Hello World" example. It explains how to configure NHibernate to specify the mapping information between business objects and database tables, and then explores the internal architecture of NHibernate. A complete example application is progressively built with Agile methodologies in mind, which shows readers all kinds of entity and relationship mappings and how to perform CRUD operations. The book also covers advanced techniques like caching, concurrency access, and isolation levels. The Hibernate Query Language (HQL) and criteria query APIs are thoroughly detailed with optimization tips. The last chapters of this book discuss various development scenarios, how to implement the layers of an NHibernate application (covering Windows and Web development), and which tools are available for these tasks. They also provide some solutions for data-binding objects to .NET GUI controls, integrating services, and interacting with components using DataSets. Finally, they explain how to build a complex application involving advanced session management and distributed transactions. What's Inside Object/Relational Mapping for .NET NHibernate configuration, mapping, and query APIs Development processes for the domain model and data-binding Advanced session management and distributed transactions Using NHibernate in real-world projects About the Reader About the Author Pierre Henri Kuaté is one of the main developers on the NHibernate project team, author of the NHibernate.Mapping.Attributes library, and a major contributor to the NHibernate forum. He's responsible for managing the NHibernate documentation, website, and forum on the Hibernate.org site. He started using NHibernate more than two years ago in commercial development. Tobin Harris has worked with NHibernate since it was in early Beta. His passion is tools and practices that help build quality software at high speeds. As an independent consultant and entrepreneur, Tobin works with companies across the globe in various sectors including banking, personal finance, healthcare, software components and new media. In 2001, Tobin was the founder of the Open Source SqlBuddy project. Subsequently he has worked in partnership with Frost Innovation on Gaia Ajax Widgets, an Open Source Ajax suite for .NET. Tobin obtained his degree in Software Engineering at Leeds Metropolitan University, and continues to work and live in Leeds, UK. Christian Bauer is a member of the Hibernate developer team and a trainer, consultant, and product manager for Hibernate, EJB 3.0, and JBoss Seam at JBoss. He is the lead author of Hibernate in Action and Java Persistence with Hibernate. Gavin King is a lead developer at JBoss, the creator of Hibernate, and a member of the EJB 3.0 (JSR 220) expert group. He also leads the Web Beans JSR 299, a standardization effort involving Hibernate concepts, JSF, and EJB 3.0. Quotes A much needed book for novices and experts. - Mark Monster, Rubicon Finally, a great book covering NHibernate. - Paul Wilson, McKesson A must-have for NHibernate developers. - Ayende Rahien, NHibernate Committer Accelerates your learning curve for ORM in .NET. - Doug Warren, Java Web Services

Microsoft SQL Server Integration Services is Microsoft’s powerful platform for building enterprise-level data integration and data transformation solutions. It’s a powerful product, but it’s also complex and can be confusing if you don’t have a clear map for the journey. Microsoft SQL Server 2008 Integration Services Unleashed will be the only book you’ll need to harness the power that Integration Services provides. Through clear, concise explanations and samples, you’ll grasp a clear understanding of working in the Integration Services environment, including how to set up stock components, how to use the various designer features, and how to gain practical knowledge on configuring, deploying, securing, and managing packages. Sample packages are provided to reinforce the discussion and quickly help you gain hands-on experience, and more complex topics such as Data Flow Task internals and tuning, advanced transformations, and writing custom components are all illustrated in easy-to-understand graphics. In addition, there are several custom tasks and transformations and two useful utilities with full source code available for you to use and study, including an ADO.NET destination, a text file encryption task, and a data profiling transform. Detailed information on: Using the powerful Integration Services tools to create solutions without the need to write lines of code Creating packages programmatically or developing custom tasks via the Integration Services object Building robust packages to solve common requirements Securing packages for different environments Using often overlooked or unknown platform features Setting up all the stock components, including data flow components, tasks, Foreach enumerators, connection managers, and log providers Writing robust and useful custom tasks Building packages that seamlessly deploy to other environments Writing custom data flow adapters and transforms Using script tasks and components Easily modifying configurations for multiple packages simultaneously Writing a Task UI that looks just like the stock tasks Tapping into the power of Integration Services for accessing heterogeneous data sources Using expressions to make packages more responsive to the environment Migrating your DTS packages with no stress Kirk Haselden is the Group Program Manager for the Microsoft Master Data Management product forthcoming in the next wave of Office SharePoint Services and owns the long term strategy, vision, planning, and development of that product. Kirk has been with Microsoft for 12 years in various groups including Hardware, eHome, Connected Home, SQL Server, and Office Business Platform. He was the development manager for Integration Services and the primary designer for the runtime, as well as many of the tasks. He has written a number of articles for SQL Server Magazine, speaks regularly at industry events, writes profusely on his personal and MSDN blog, and holds 35 patents or patents pending. Category: Microsoft SQL Server Covers: Microsoft SQL Server 2008 Integration Services User Level: Intermediate—Advanced $59.99 US / $71.99 CAN / £38.99 Net UK

Want to learn about databases without the tedium? With its unique combination of Japanese-style comics and serious educational content, The Manga Guide to Databases is just the book for you. Princess Ruruna is stressed out. With the king and queen away, she has to manage the Kingdom of Kod's humongous fruit-selling empire. Overseas departments, scads of inventory, conflicting prices, and so many customers! It's all such a confusing mess. But a mysterious book and a helpful fairy promise to solve her organizational problems-with the practical magic of databases. In The Manga Guide to Databases, Tico the fairy teaches the Princess how to simplify her data management. We follow along as they design a relational database, understand the entity-relationship model, perform basic database operations, and delve into more advanced topics. Once the Princess is familiar with transactions and basic SQL statements, she can keep her data timely and accurate for the entire kingdom. Finally, Tico explains ways to make the database more efficient and secure, and they discuss methods for concurrency and replication. Examples and exercises (with answer keys) help you learn, and an appendix of frequently used SQL statements gives the tools you need to create and maintain full-featured databases. (Of course, it wouldn't be a royal kingdom without some drama, so read on to find out who gets the girl-the arrogant prince or the humble servant.) This EduManga book is a translation of a bestselling series in Japan, co-published with Ohmsha, Ltd., of Tokyo, Japan.

The FileMaker Pro 10 desktop database lets you do almost anything with the information you give it -- especially with this book as your guide. Clear, thorough, and accessible, FileMaker Pro 10: The Missing Manual helps you get in, build your database, and get the results you need, whether you're running a business, pursuing a hobby, or planning your retirement. It's the ideal guide for non-technical and experienced folks alike. Each chapter in this fully updated edition covers the latest timesaving features of FileMaker Pro 10, including saved finds and a redesigned toolbar that reveals information and features more clearly than ever. You'll learn how to import information from the new Bento consumer database (Mac only), write scripts to make your database even easier to use, and send email without leaving FileMaker. With this book, you will: Get your first database running in minutes and perform basic tasks right away Catalog people, processes, and things with streamlined data entry and sorting tools Use your data to generate reports, correspondence, and other documents with ease Create, connect, and manage multiple tables and set up complex relationships that display just the data you need Crunch numbers, search text, or pin down dates and times with dozens of built-in formulas Outfit your database for the Web, and import and export data to other formats You'll also get objective advice on which features are really useful, and which aren't. To make the most of this database, you need FileMaker Pro 10: The Missing Manual -- the book that should have been in the box.

Understanding SQL's underlying theory is the best way to guarantee that your SQL code is correct and your database schema is robust and maintainable. On the other hand, if you're not well versed in the theory, you can fall into several traps. In SQL and Relational Theory, author C.J. Date demonstrates how you can apply relational theory directly to your use of SQL. With numerous examples and clear explanations of the reasoning behind them, you'll learn how to deal with common SQL dilemmas, such as: Should database access granted be through views instead of base tables? Nulls in your database are causing you to get wrong answers. Why? What can you do about it? Could you write an SQL query to find employees who have never been in the same department for more than six months at a time? SQL supports "quantified comparisons," but they're better avoided. Why? How do you avoid them? Constraints are crucially important, but most SQL products don't support them properly. What can you do to resolve this situation? Database theory and practice have evolved since Edgar Codd originally defined the relational model back in 1969. Independent of any SQL products, SQL and Relational Theory draws on decades of research to present the most up-to-date treatment of the material available anywhere. Anyone with a modest to advanced background in SQL will benefit from the many insights in this book.

As Microsoft's bestselling database manager, SQL Server is highly flexible and customizable, and has excellent support—the 2008 version offers several significant new capabilities. This book offers accurate and expert coverage on the updates to SQL Server 2008 such as its enhanced security; the ability to encrypt an entire database, data files, and log files without the need for application changes; a scalable infrastructure that can manage reports and analysis of any size and complexity; and its extensive performance data collection.

MySQL is the leading open source database on the market and PHP continues to dominate the server side of the scripting market—together, they are the most popular and common team for creating dynamic, database-driven web sites. This comprehensive book covers the newest version of PHP and MySQL and is packed with extensive code examples, full working applications, and valuable troubleshooting advice. You’ll explore installing, developing, and debugging the latest versions of PHP and MySQL and get insight on advanced topics such as error handling, debugging, PEAR, security, HTTP, cookies, and OOP.

XML is the lingua franca of the Web. All designers and developers working in a web environment need a sound understanding of XML and its role in application development. Many software packages and organizations allow for the exchange of data using an XML format. Web services and RSS feeds are now commonplace. For those working with Flash and Flex, a thorough understanding of XML is particularly important. XML documents are one option for the data provided to SWF applications. Flash and Flex can load, display, and modify XML content. These applications can also send XML content to other applications for updating or for use in different situations. ActionScript 3.0 introduced some fundamental changes to the way in which Flash and Flex applications work with XML. One significant change is that XML is now a native data type. ActionScript 3.0 also introduced new classes and a different framework for working with external documents. These changes are based on the E4X ECMAScript standard, and they streamline and simplify the process for working with XML in Flash and Flex. In Foundation XML and E4X for Flash and Flex, Sas Jacobs gives you an introduction to XML and E4X. She explores the XML and XMLList classes and explains E4X expressions, providing examples for both Flash and Flex. In addition to explaining how to incorporate XML documents in Shockwave Flash applications, Sas shows you approaches specific to Flash and Flex and explores real-world usage. The book finishes with two case studies. In the first, you will learn how to consume and display information and images from Flickr using Flash. In the second, you will work with Adobe Kuler in Flex. Whether you are a designer or developer, this book will help you work with XML and make the transition from ActionScript 2.0 to ActionScript 3.0. It will also provide you with an excellent grounding if you are new to Flash and Flex.