Wow! eBook – Blog

Book Description

What makes this book different from others on database design? Many resources on design practice do little to explain the underlying theory, and books on design theory are aimed primarily at theoreticians. In this book, renowned expert Chris Date bridges the gap by introducing design theory in ways practitioners can understand—drawing on lessons learned over four decades of experience to demonstrate why proper database design is so critical in the first place.

Every chapter includes a set of exercises that show how to apply the theoretical ideas in practice, provide additional information, or ask you to prove some simple theoretical result. If you’re a database professional familiar with the relational model, and have more than a passing interest in database design, this book is for you.

Questions this book answers include:

• Why is Heath’s Theorem so important?
• What is The Principle of Orthogonal Design?
• What makes some JDs reducible and others irreducible?
• Why does dependency preservation matter?
• Should data redundancy always be avoided? Can it be?

Databases often stay in production for decades Download Now »

Book Description

Apply powerful window functions in T-SQL—and increase the performance and speed of your queries

Optimize your queries—and obtain simple and elegant solutions to a variety of problems—using window functions in Transact-SQL. Led by T-SQL expert Itzik Ben-Gan, you’ll learn how to apply calculations against sets of rows in a flexible, clear, and efficient manner. Ideal whether you’re a database administrator or developer, this practical guide demonstrates ways to use more than a dozen T-SQL querying solutions to address common business tasks.

Discover how to:

• Go beyond traditional query approaches to express set calculations more efficiently
• Delve into ordered set functions such as rank, distribution, and offset
• Implement hypothetical set and inverse distribution functions in standard SQL
• Use strategies for improving sequencing, paging, filtering, and pivoting
• Increase query speed using partitioning, ordering, and coverage indexing
• Apply new optimization iterators such as Window Spool
• Handle common issues such as running totals, intervals, medians, and gaps

Download Now »

Book Description

IBM’s Definitive One-Stop Guide to IMS Versions 12, 11, and 10: for Every IMS DBA, Developer, and System Programmer

Over 90% of the top Fortune® 1000 companies rely on IBM’s Information Management System (IMS) for their most critical IBM System z® data management needs: 50,000,000,000+ transactions run through IMS databases every day. What’s more, IBM continues to upgrade IMS: Versions 12, 11, and 10 meet today’s business challenges more flexibly and at a lower cost than ever before. In An Introduction to IMS, Second Edition, leading IBM experts present the definitive technical introduction to these versions of IMS.

More than a complete tutorial, this book provides up-to-date examples, cases, problems, solutions, and a complete glossary of IMS terminology. Prerequisite reading for the current IBM IMS Mastery Certification Program, it reflects major recent enhancements such as dynamic information generation; new access, interoperability and development tools; improved SOA support; and much more. Whether you’re a DBA, database developer, or system programmer, it brings together all the knowledge you’ll need to succeed with IMS in today’s mission critical environments.

Coverage includes:

• What IMS is, how it works, how it has evolved, and how it fits into modern enterprise IT architectures
• Providing secure access to IMS via IMS-managed application programs Download Now »

Book Description

Implement Configuration Management Databases that Deliver Rapid ROI and Sustained Business Value

Implementing an enterprise-wide Configuration Management Database (CMDB) is one of the most influential actions an IT organization can take to improve service delivery and bridge the gap between technology and the business. With a well-designed CMDB in place, companies are better positioned to manage and optimize IT infrastructure, applications, and services; automate more IT management tasks; and restrain burgeoning costs. Now, there’s an objective, vendor-independent guide to making a CMDB work in your organization. The CMDB Imperative presents a start-to-finish implementation methodology that works and describes how the CMDB is shifting to the superior Configuration Management System (CMS).

Expert CMDB industry analyst Glenn O’Donnell and leading-edge architect and practitioner Carlos Casanova first review the drivers behind a CMDB and the technical, economic, cultural, and political obstacles to success. Drawing on the experiences of hundreds of organizations, they present indispensable guidance on architecting and customizing CMDB solutions to your specific environment. They’ll guide you through planning, implementation, transitioning into production, day-to-day operation and maintenance, and much more. Coverage includes

• Defining the tasks and activities associated with configuration management
• Understanding the CMDB’s role in ITIL Download Now »

Book Description

Agile Oracle Application Express shows how skilled, motivated, and self-organizing developers can realize extraordinary commercial benefits from Oracle Application Express. The secret is to couple Application Express with an agile software development approach. This book leads the way.

Oracle Application Express is well-suited to agile processes, with its support for rapid prototyping and team development. Application Express supports a gamut of enabling technologies such as SQL, HTML, CSS, JavaScript, and more that enable you to deliver any type of web application to meet your development needs. Agile Oracle Application Express helps you take the feature set of Application Express and marry it with the processes of agile development to iteratively design, create, and deliver quality applications on time and within budget.

What you’ll learn

• Discover how Application Express features compliment agile development
• Apply principles of agile software development to Application Express projects
• Deliver working code to your clients quickly
• Meet cost, schedule, and quality targets
• Increase productivity through team-based techniques
• Create the right amount and size of governance for any Application Express project

Download Now »

Book Description

Oracle’s JD Edwards Enterprise One Supply Chain Management (SCM) aids your business in enhancing your interactions with enterprise suppliers, and this practical cookbook provides essential implementation sequences to make the most of the suite. The functionality across the application described in this comprehensive guide allows you to be proactive in reacting to real-time information and developing procurement strategies and best practices.

“Oracle JD Edwards EnterpriseOne 9.0: Supply Chain Management Cookbook” explains with step by step instructions how to fully implement the EnterpriseOne Supply Chain suite, set up Inventory Management, Procurement Management and Sales Order Management, and much more. Each chapter will provide you the details of setup-related information, and instructions which will direct you in configuring your company’s business processes.

This business-ready cookbook provides you with all the instructions you need to set up the SCM application, and utilize it based on your company’s individual business requirements. It begins by demonstrating how to review inventory quantity information and perform physical inventory through cycle count and tag count, and later moves onto how to configure the interactive application, and how to set up the batch versions.
Along the way it will also cover the item master information, classification, AAI setup, and system integration. Ultimately, “Oracle JD Edwards EnterpriseOne 9.0 Download Now »