This book presents two data warehouse solutions that deliver significant ROI; market basket analysis, approached as a database design issue rather than a data model issue; and time variance or temporal data, which present past events in their historical context. The former is available to any enterprise with a data warehouse, while the latter provides a simple design that accommodates large data volumes. The text combines these two database designs into one design, which performs market basket analysis of transactions in their historical context.

NEWER EDITION AVAILABLE MongoDB in Action, Second Edition is now available. An eBook of this older edition is included at no additional cost when you buy the revised edition! A limited number of pBook copies of this edition are still available. Please contact Manning Support to inquire about purchasing previous edition copies. MongoDB in Action is a comprehensive guide to MongoDB for application developers. The book begins by explaining what makes MongoDB unique and describing its ideal use cases. A series of tutorials designed for MongoDB mastery then leads into detailed examples for leveraging MongoDB in e-commerce, social networking, analytics, and other common applications. About the Technology Big data can mean big headaches. MongoDB is a document-oriented database designed to be flexible, scalable, and very fast, even with big data loads. It's built for high availability, supports rich, dynamic schemas, and lets you easily distribute data across multiple servers. About the Book MongoDB in Action introduces you to MongoDB and the document-oriented database model. This perfectly paced book provides both the big picture you'll need as a developer and enough low-level detail to satisfy a system engineer. Numerous examples will help you develop confidence in the crucial area of data modeling. You'll also love the deep explanations of each feature, including replication, auto-sharding, and deployment. What's Inside Indexes, queries, and standard DB operations Map-reduce for custom aggregations and reporting Schema design patterns Deploying for scale and high availability About the Reader Written for developers. No MongoDB or NoSQL experience required. About the Author Kyle Banker is a software engineer at 10gen where he maintains the official MongoDB drivers for Ruby and C. Quotes Awesome! MongoDB in a nutshell. - Hardy Ferentschik, Red Hat Excellent. Many practical examples. - Curtis Miller, Flatterline Not only the how, but also the why. - Philip Hallstrom, PJKH, LLC Has a developer-centric flavor--an excellent reference. - Rick Wagner, Red Hat A must-read. - Daniel Bretoi, Advanced Energy

Gillenson's new edition of Fundamentals of Database Management Systems provides concise coverage of the fundamental topics necessary for a deep understanding of the basics. In this issue, there is more emphasis on a practical approach, with new "your turn" boxes and much more coverage in a separate supplement on how to implement databases with Access. In every chapter, the author covers concepts first, then show how they're implemented in continuing case(s.) "Your Turn" boxes appear several times throughout the chapter to apply concepts to projects. And "Concepts in Action" boxes contain examples of concepts used in practice. This pedagogy is easily demonstrable and the text also includes more hands-on exercises and projects and a standard diagramming style for the data modeling diagrams. Furthermore, revised and updated content and organization includes more coverage on database control issues, earlier coverage of SQL, and new coverage on data quality issues.

Expert Oracle Application Express Plugins is your “go to” book on the groundbreaking plugin architecture introduced in Oracle Application Express 4.0. Using the new APEX functionality, you can create well-packaged, documented, reusable components and reliably leverage your coding investments across many applications. Components you create can define new item and region types, specify validation processes, and present dynamic actions to client applications. You can design innovative and colorful ways to display information, such as displaying the temperature using an image of a thermometer, or displaying sales velocity in the form of an automotive speedometer. The new plugin architecture is sure to create a tidal wave of creativity. Author Martin D'Souza shows everything you need to know to get started in building and deploying plugins of your own design. You'll learn the underlying architecture, including the APIs used to tie your plugins seamlessly into an Application Express environment. You'll learn about the different types of plugins, and you'll walk through examples of each to ensure that you can create the right type of plugin when you need it. Finally, Expert Oracle Application Express Plugins shows how to work as part of the larger Application Express community by leveraging that community's efforts and by giving back as you deploy your own plugins to the broad audience of Application Express developers. Presents the architecture and APIs available for customizing Application Express Gives clear examples of plugin development, for each type of plugin Helps you work as part of the broader community of plugin developers What you'll learn Understand the APEX plugin architecture Design and develop each of the four types of plugin Debug and troubleshoot plugin-based applications Deploy your plugins to the wider community Make your plugins compatible across different browsers Master the plugin APIs that APEX provides Who this book is for Expert Oracle APEX Plugins is aimed at Oracle Application Express developers wanting to develop reusable components using Application Express's new, plugin architecuture. The book appeals to in-house developers wanting to preserve their investment in writing code by packaging it for convenient reuse in other applications. The book also appeals to commercial software developers who want to write plugins for sale.

Tika in Action is a hands-on guide to content mining with Apache Tika. The book's many examples and case studies offer real-world experience from domains ranging from search engines to digital asset management and scientific data processing. About the Technology Tika is an Apache toolkit that has built into it everything you and your app need to know about file formats. Using Tika, your applications can discover and extract content from digital documents in almost any format, including exotic ones. About the Book Tika in Action is the ultimate guide to content mining using Apache Tika. You'll learn how to pull usable information from otherwise inaccessible sources, including internet media and file archives. This example-rich book teaches you to build and extend applications based on real-world experience with search engines, digital asset management, and scientific data processing. In addition to architectural overviews, you'll find detailed chapters on features like metadata extraction, automatic language detection, and custom parser development. What's Inside Crack MS Word, PDF, HTML, and ZIP Integrate with search engines, CMS, and other data sources Learn through experimentation Many examples About the Reader This book requires no previous knowledge of Tika or text mining techniques. It assumes a working knowledge of Java. About the Authors Chris Mattmann is an information architect experienced in the construction of large data-intensive systems. Jukka Zitting is a core Tika developer, a member of the JCR expert group, and chairman of the Apache Jackrabbit project. Quotes By Tika's two main creators and maintainers. - Jérôme Charron, WebPulse Easily the most definitive guide to this great new text analysis toolkit. - John Guthrie, SAP An easy-to-read guide--plenty of technical content. - Rick Wagner, Red Hat There's not a single page of 'inaction' in the entire book! - Sean Kelly, Technologist, NASA Complete, practical, accurate - Julien Nioche, DigitalPebble Ltd

If you can build websites with CSS and JavaScript, this book takes you to the next level—creating dynamic, database-driven websites with PHP and MySQL. Learn how to build a database, manage your content, and interact with users through queries and web forms. With step-by-step tutorials, real-world examples, and jargon-free explanations, you’ll soon discover the power of server-side programming. The important stuff you need to know: Get a running start. Write PHP scripts and create a web form right away. Learn the language. Get up to speed on PHP and SQL syntax quickly. Build a database. Use MySQL to store user information and other data. Make it dynamic. Create pages that change with each new viewing. Be ready for mistakes. Plan error messages to help direct users. Manage your content. Use the file system to access user data, including images and other binary files. Control operations. Create an administrative interface to oversee your site.

Oracle Core: Essential Internals for DBAs and Developers by Jonathan Lewis provides just the essential information about Oracle Database internals that every database administrator needs for troubleshooting—no more, no less. Oracle Database seems complex on the surface. However, its extensive feature set is really built upon upon a core infrastructure resulting from sound architectural decisions made very early on that have stood the test of time. This core infrastructure manages transactions and the ability to commit and roll back changes, protects the integrity of the database, enables backup and recovery, and allows for scalability to thousands of users all accessing the same data. Most performance, backup, and recovery problems that database administrators face on a daily basis can easily be identified through understanding the essential core of Oracle Database architecture that Lewis describes in this book. Provides proven content from a world-renowned performance and troubleshooting expert Emphasizes the significance of internals knowledge to rapid identification of database performance problems Covers the core essentials and does not waste your time with esoterica

Essential Microsoft SQL Server 2012 Skills Made Easy Get up and running on Microsoft SQL Server 2012 in no time with help from this thoroughly revised, practical resource. Filled with real-world examples and hands-on exercises, Microsoft SQL Server 2012: A Beginner's Guide, Fifth Edition starts by explaining fundamental relational database system concepts. Then, you'll learn how to write Transact-SQL statements, execute simple and complex database queries, handle system administration and security, and use the powerful analysis, business intelligence, and reporting tools. XML, spatial data, and full-text search are also covered in this step-by-step tutorial. Install, configure, and customize SQL Server 2012 Create and modify database objects with Transact SQL statements Write stored procedures and user-defined functions Handle backup and recovery Automate administrative tasks Tune your database system for optimal performance, availability, and reliability Implement security measures using authentication, encryption, and authorization Work with SQL Server Analysis Services, SQL Server Reporting Services, and other business intelligence tools Store, display, and query XML documents Manage spatial data Query documents using MS Full-Text Search (FTS)

One of a firm's most valuable resources is its data: client lists, accounting data, employee information, and so on. This critical data has to be securely managed and controlled, and simultaneously made available to those users authorized to see it. The IBM® z/VSE™ system has extensive capabilities to simultaneously share the firm's data among multiple users and protect them. Threats to this data come from a variety of sources. Insider threats, as well as malicious hackers, are not only difficult to detect and prevent—they could have been using resources without the business even being aware that they are there. This IBM Redbooks® publication was written to assist z/VSE support and security personnel in providing the enterprise with a safe, secure and manageable environment. This book provides an overview of the security provided by z/VSE and the processes for the implementation and configuration of z/VSE security components, Basic Security Manager (BSM), IBM CICS® security, TCP/IP security, single sign-on using LDAP, and connector security.

Using Google Advanced Search is the one book you shouldn’t be without if you regularly search the Web. And who doesn’t search the Web with Google or one of its competitors at least once a day? And if you’re a scholar, researcher or teacher, learning how to comb millions of Web pages for exactly the piece of information you need is critical to your success. Stop wasting time combing through search results that aren’t what you want or need. Using Google Search will show you how to: use the ~ operator to search for similar words, or to use quote marks for performing an exact search use wildcards to search for missing words in an exact phrase search for specific file types search only a specific website or domain search only in the title of web pages, the URL or to within the text of the page search of pages that link to a specific webpage search in a different language use Google to locate bargains specifically search blogs and blog posts search libraries search for scholarly and specialty information perform calculations within the search box

Today, organizations face tremendous challenges with data explosion and information governance. InfoSphere™ Optim™ solutions solve the data growth problem at the source by managing the enterprise application data. The Optim Data Growth solutions are consistent, scalable solutions that include comprehensive capabilities for managing enterprise application data across applications, databases, operating systems, and hardware platforms. You can align the management of your enterprise application data with your business objectives to improve application service levels, lower costs, and mitigate risk. In this IBM® Redbooks® publication, we describe the IBM InfoSphere Optim Data Growth solutions and a methodology that provides implementation guidance from requirements analysis through deployment and administration planning. We also discuss various implementation topics including system architecture design, sizing, scalability, security, performance, and automation. This book is intended to provide various systems development professionals, Data Solution Architects, Data Administrators, Modelers, Data Analysts, Data Integrators, or anyone who has to analyze or integrate data structures, a broad understanding about IBM InfoSphere Optim Data Growth solutions. By being used in conjunction with the product manuals and online help, this book provides guidance about implementing an optimal solution for managing your enterprise application data.

Implement a powerful end-to-end SAP administration solution Get peak performance from your SAP ERP infrastructure using the detailed implementation, maintenance, and support information in this comprehensive resource. SAP Basis Administration Handbook, NetWeaver Edition delivers integrated management strategies covering both ABAP and Java stacks. Discover how to deploy components, accurately size throughout, configure Oracle databases, back up your system, and repair performance problems. Career trends, certification requirements, and marketable SAP Basis skills are also discussed in this practical guide. Essential Skills for SAP Professionals: Plan, prepare, and install SAP NetWeaver Application Server Set up, configure, and troubleshoot Java and ABAP stacks Establish server infrastructure and efficiently balance workloads Incorporate transport management and software logistics Resolve performance issues and startup problems Access SAP support infrastructure through SAP Service Marketplace Manage and back up Oracle databases using BR*TOOLS Perform system copies, stack upgrades, and OS/DB migrations

Step-by-step lessons for using PHP and MySQL in a unique book-and-video combination Assuming no previous experience with PHP or MySQL, this book-and-video package is ideal reading for anyone who wants to go beyond HTML/CSS in order to provide clients with the most dynamic web sites possible. The approachable tone breaks down the basics of programming and PHP and MySQL in individual lessons starting with the installation of the programs necessary to run PHP. You begin with a static web site and then watch and learn as PHP functionality is added as you work through the lessons. When working with databases, the MySQL database is introduced with demonstrations that show how to interact with it. The accompanying videos enhance your learning experience, as each lesson in the book is portrayed in the video exercises. Lessons include: Getting started with PHP Setting up your workspace Adding PHP to a web page Learning PHP syntax Working with variables Debugging code Working with complex data Making decisions Repeating program steps Learning about scope Reusing code with functions Creating forms Introducing object-oriented programming Defining classes Using classes Using advanced techniques Handling errors Writing secure code Introducing databases Introducing MySQL Creating and connecting to the Creating tables Entering data Selecting data Using multiple tables Changing data Deleting data Preventing database security issues Creating user logins Turn the case study into a content management system Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.

This IBM® Redbooks® publication describes how to build production topologies for IBM Business Process Manager Advanced V7.5. It is aimed at IT Architects and IT Specialists who want to understand and implement these topologies. Use this book to select the appropriate production topologies for a given environment, then follow the step-by-step instructions included in this book to build these topologies. Part one introduces IBM Business Process Manager and provides an overview of basic topology components, and Process Server and Process Center. This part also provides an overview of the production topologies that we describe in this book, including a selection criteria for when to select a given topology. Part two provides a series of step-by-step instructions for creating production topology environments using deployment environment patterns. This includes topologies that incorporate IBM Business Monitor. This part also discusses advanced topology topics.

Microsoft BizTalk Server 2010 Patterns introduces readers to BizTalk Server 2010, providing a comprehensive overview of its core functionalities and advanced development practices. Through real-world examples and detailed step-by-step instructions, this book equips developers with the necessary tools to craft scalable, robust integration solutions that solve modern middleware challenges effectively. What this Book will help me do Understand the architecture and internals of BizTalk Server 2010 and design optimal topologies for various scenarios. Develop and structure BizTalk Server 2010 projects efficiently, including robust unit testing practices. Implement integration solutions using WCF services, Business Activity Monitoring, and the Business Rules Engine effectively. Apply best practices like convoy patterns and dynamic message routing to build scalable and adaptable solutions. Deploy, manage, and troubleshoot BizTalk Server 2010 applications while ensuring ease of future modifications and maintenance. Author(s) Dan Rosanova, a recognized Microsoft BizTalk Server Architecture MVP, shares his expertise honed through years of building and deploying enterprise solutions. With his deep understanding of middleware integration and his clear, no-nonsense writing style, Dan aims to guide developers through mastering BizTalk effectively while leveraging its full potential. Who is it for? This book is ideal for developers and architects tasked with building solutions utilizing BizTalk Server 2010. If you have prior experience with Visual Studio and basic familiarity with BizTalk, you'll find advanced concepts and practical guidance to enhance your skills. Technical managers overseeing BizTalk projects will also benefit from the structured methodologies and foundational patterns presented.

In a growing number of organizations, policies are the key mechanism by which the capabilities and requirements of services are expressed and made available to other entities. The goals established and driven by the business need to be consistently implemented, managed and enforced by the service-oriented infrastructure; expressing these goals as policy and effectively managing this policy is fundamental to the success of any IT and application transformation. First, a flexible policy management framework must be in place to achieve alignment with business goals and consistent security implementation. Second, common re-usable security services are foundational building blocks for SOA environments, providing the ability to secure data and applications. Consistent IT Security Services that can be used by different components of an SOA run time are required. Point solutions are not scalable, and cannot capture and express enterprise-wide policy to ensure consistency and compliance. In this IBM® Redbooks® publication, we discuss an IBM Security policy management solution, which is composed of both policy management and enforcement using IT security services. We discuss how this standards-based unified policy management and enforcement solution can address authentication, identity propagation, and authorization requirements, and thereby help organizations demonstrate compliance, secure their services, and minimize the risk of data loss. This book is a valuable resource for security officers, consultants, and architects who want to understand and implement a centralized security policy management and entitlement solution.

IBM® Information Management System (IMS™) provides leadership in performance, reliability, and security to help you implement the most strategic and critical enterprise applications. IMS also keeps pace with the IT industry. IMS, Enterprise Suite 2.1, and IMS Tools continue to evolve to provide value and meet the needs of enterprise customers. With IMS 12, integration and open access improvements provide flexibility and support business growth requirements. Manageability enhancements help optimize system staff productivity by improving ease of use and autonomic computing facilities and by providing increased availability. Scalability improvements have been made to the well-known performance, efficiency, availability, and resilience of IMS by using 64-bit storage. IBM IMS Enterprise Suite for z/OS® V2.1 components enhance the use of IMS applications and data. In this release, components (either orderable or downloaded from the web) deliver innovative new capabilities for your IMS environment. They enhance connectivity, expand application development, extend standards and tools for a service-oriented architecture (SOA), ease installation, and provide simplified interfaces. This IBM Redbooks® publication explores the new features of IMS 12 and Enterprise Suite 2.1 and provides an overview of the IMS tools. In addition, this book highlights the major new functions and facilitates database administrators in their planning for installation and migration.

The Essential Guide to SQL Statement Optimization Written by Oracle ACE Director and MySQL expert Ronald Bradford, Effective MySQL: Optimizing SQL Statements is filled with detailed explanations and practical examples that can be applied immediately to improve database and application performances. Featuring a step-by-step approach to SQL optimization, this Oracle Press book helps you to analyze and tune problematic SQL statements. Identify the essential analysis commands for gathering and diagnosing issues Learn how different index theories are applied and represented in MySQL Plan and execute informed SQL optimizations Create MySQL indexes to improve query performance Master the MySQL query execution plan Identify key configuration variables that impact SQL execution and performance Apply the SQL optimization lifecycle to capture, identify, confirm, analyze, and optimize SQL statements and verify the results Improve index utilization with covering indexes and partial indexes Learn hidden performance tips for improving index efficiency and simplifying SQL statements

The Definitive Guide to Microsoft SQL Server 2012 Reporting Services Create, deploy, and manage business intelligence reports using the expert tips and best practices in this hands-on resource. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2012 Reporting Services, Fourth Edition covers the complete process of building and distributing reports and explains how to maximize all of the powerful, integrated SSRS capabilities, including the new and enhanced features. A detailed case study and sample reports are included in this practical reference. Plan for, install, configure, and customize SQL Server 2012 Reporting Services Retrieve data with SELECT queries Generate reports from the Report Wizard and from scratch Enhance your reports with charts, images, gauges, and maps Add value to reports through summarizing, totaling, and interactivity Build reusable report templates Embed Visual Basic, .NET functions and subreports into your reports Enable end-user access to reports via the Report Server and its Report Manager web interface Integrate SSRS reports with your own websites and custom applications Follow along with sample reports from the book's case study

Master Application Development in a Mixed-Platform Environment Build powerful database applications in a mixed environment using the detailed information in this Oracle Press guide. Oracle Database 11g & MySQL 5.6 Developer Handbook lays out programming strategies and best practices for seamlessly operating between the two platforms. Find out how to migrate databases, port SQL dialects, work with Oracle MySQL databases, and configure effective queries. Security, monitoring, and tuning techniques are also covered in this comprehensive volume. Understand Oracle Database 11 g and MySQL 5.6 architecture Convert databases between platforms and ensure transactional integrity Create tables, sequences, indexes, views, and user accounts Build and debug PL/SQL, SQL*Plus, SQL/PSM, and MySQL Monitor scripts Execute complex queries and handle numeric and date mathematics Merge data from source tables and set up virtual directories

Master Oracle Hyperion Financial Management Consolidate financial data and maintain a scalable compliance framework with expert instruction from an Oracle ACE. Oracle Hyperion Financial Management Tips & Techniques provides advanced, time-saving procedures not documented in user manuals or help files. Find out how to configure Oracle Hyperion Financial Management, import and reconcile data, deliver dynamic business reports, and automate administrative tasks. Stragegies for supporting, testing, and tuning your application are also covered in this comprehensive Oracle Press guide. Establish objectives and develop an effective rollout plan Set up and customize Oracle Hyperion Financial Management Create rules using VBScript and the Calculation Manager feature of Oracle Hyperion Foundation Services Load, test, and reconcile your data with Oracle Data Integrator and Oracle Hyperion Financial Data Quality Management Design, update, and distribute Web-based business reports Integrate content from Microsoft Excel, Word, and PowerPoint using SmartView Work with the Lifecycle Management feature of Oracle Hyperion Foundation Services Identify and resolve performance, design, and capacity problems

The popularity of the Internet and the affordability of IT hardware and software have resulted in an explosion of applications, architectures, and platforms. Workloads have changed. Many applications, including mission-critical ones, are deployed on a variety of platforms, and the System z® design has adapted to this change. It takes into account a wide range of factors, including compatibility and investment protection, to match the IT requirements of an enterprise. The zEnterprise System consists of the IBM zEnterprise 196 central processor complex, the IBM zEnterprise Unified Resource Manager, and the IBM zEnterprise BladeCenter® Extension. The z196 is designed with improved scalability, performance, security, resiliency, availability, and virtualization. The z196 Model M80 provides up to 1.6 times the total system capacity of the z10™ EC Model E64, and all z196 models provide up to twice the available memory of the z10 EC. The zBX infrastructure works with the z196 to enhance System z virtualization and management through an integrated hardware platform that spans mainframe, POWER7™, and System x® technologies. Through the Unified Resource Manager, the zEnterprise System is managed as a single pool of resources, integrating system and workload management across the environment. This IBM® Redbooks® publication provides an overview of the zEnterprise System and its functions, features, and associated software support. Greater detail is offered in areas relevant to technical planning. This book is intended for systems engineers, consultants, planners, and anyone wanting to understand the zEnterprise System functions and plan for their usage. It is not intended as an introduction to mainframes. Readers are expected to be generally familiar with existing IBM System z technology and terminology. The changes to this edition are based on the System z hardware announcement dated July 12, 2011.

Unfortunately purchasing software products does not automatically mean that these products are exploited throughout the organization providing the maximum possible value to the business units. Several issues call for a structured approach that gets the most business value out of software already purchased. The objectives of this approach are to: * Create maximum awareness throughout the organization of the software purchased. We can summarize the overall objective of this approach as ensuring that the business units in an organization obtain the maximum possible value of software products purchased, which is also the scope of this IBM Redbooks publication.

What do you know about your data? And how do you know what you know about your data? Information governance initiatives address corporate concerns about the quality and reliability of information in planning and decision-making processes. Metadata management refers to the tools, processes, and environment that are provided so that organizations can reliably and easily share, locate, and retrieve information from these systems. Enterprise-wide information integration projects integrate data from these systems to one location to generate required reports and analysis. During this type of implementation process, metadata management must be provided along each step to ensure that the final reports and analysis are from the right data sources, are complete, and have quality. This IBM® Redbooks® publication introduces the information governance initiative and highlights the immediate needs for metadata management. It explains how IBM InfoSphere™ Information Server provides a single unified platform and a collection of product modules and components so that organizations can understand, cleanse, transform, and deliver trustworthy and context-rich information. It describes a typical implementation process. It explains how InfoSphere Information Server provides the functions that are required to implement such a solution and, more importantly, to achieve metadata management. This book is for business leaders and IT architects with an overview of metadata management in information integration solution space. It also provides key technical details that IT professionals can use in a solution planning, design, and implementation process.

The IBM Style Guide distills IBM wisdom for developing superior content: information that is consistent, clear, concise, and easy to translate. The IBM Style Guide can help any organization improve and standardize content across authors, delivery mechanisms, and geographic locations. This expert guide contains practical guidance on topic-based writing, writing content for different media types, and writing for global audiences. Throughout, the authors illustrate the guidance with many examples of correct and incorrect usage. Writers and editors will find authoritative guidance on issues ranging from structuring information to writing usable procedures to presenting web addresses to handling cultural sensitivities. The guidelines cover these topics: Using language and grammar to write clearly and consistently Applying punctuation marks and special characters correctly Formatting, organizing, and structuring information so that it is easy to find and use Using footnotes, cross-references, and links to point readers to valuable, related information Presenting numerical information clearly Documenting computer interfaces to make it easy for users to achieve their goals Writing for diverse audiences, including guidelines for improving accessibility Preparing clear and effective glossaries and indexes The IBM Style Guide can help any organization or individual create and manage content more effectively. The guidelines are especially valuable for businesses that have not previously adopted a corporate style guide, for anyone who writes or edits for IBM as an employee or outside contractor, and for anyone who uses modern approaches to information architecture.