Time and Relational Theory provides an in-depth description of temporal database systems, which provide special facilities for storing, querying, and updating historical and future data. Traditionally, database management systems provide little or no special support for temporal data at all. This situation is changing because: - Cheap storage enables retention of large volumes of historical data in data warehouses - Users are now faced with temporal data problems, and need solutions - Temp...

Ramp Up Your PL/SQL Programming SkillsMaster PL/SQL through the hands-on exercises, extensive examples, and real-world projects inside this Oracle Press guide. Filled with best practices, Oracle Database 11g PL/SQL Programming Workbook covers all the latest features and enhancements of the language. Mastery checks at the end of each chapter reinforce the material covered, and sample code from the book is available for download. Even experienced Oracle professionals will ...

This book sheds light on the principles behind the relational model, which is fundamental to all database-backed applications--and, consequently, most of the work that goes on in the computing world today. Database in Depth: The Relational Model for Practitioners goes beyond the hype and gets to the heart of how relational databases actually work.Ideal for experienced database developers and designers, this concise guide gives you a clear view of the technology--a view tha...

Implement a powerful end-to-end SAP administration solutionGet 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 perf...

MySQL is the world's most popular open source database. MySQL is designed for speed, power, and flexibility in mission-critical, heavy-use environments and modest applications as well. It's also surprisingly rich in features. If you're a database administrator or programmer you probably love the myriad of things MySQL can do, but sometimes wish there wasn't such a myriad of things to remember. With MySQL in a Nutshell by your keyboard, you can drill down into the full depth of MyS...

Learn How to Design Effective Visualization SystemsVisualization Analysis and Design provides a systematic, comprehensive framework for thinking about visualization in terms of principles and design choices. The book features a unified approach encompassing information visualization techniques for abstract data, scientific visualization techniques

Expert Oracle Exadata, 2nd Edition opens up the internals of Oracle's Exadata platform so that you can fully benefit from the most performant and scalable database hardware appliance capable of running Oracle Database. This edition is fully-updated to cover Exadata 5-2 and Oracle Database 12c. If you're new to Exadata, you'll soon learn that it embodies a change in how you think about and manage relational databases. A key part of that change lies in the concept of offloading SQL ...

Everything a DBA needs to know in one volume--this is the must-have reference for anyone working with the Oracle database, and it’s been fully revised and updated for Oracle Database 10g. Co-author Kevin Loney is the all-time, best-selling Oracle Press author.

Get a solid grounding in Apache Oozie, the workflow scheduler system for managing Hadoop jobs. With this hands-on guide, two experienced Hadoop practitioners walk you through the intricacies of this powerful and flexible platform, with numerous examples and real-world use cases.Once you set up your Oozie server, you’ll dive into techniques for writing and coordinating workflows, and learn how to write complex data pipelines. Advanced topics show you how to handle shared libraries i...

Pro SQL Server Wait Statistics is a practical guide for analyzing and troubleshooting SQL Server performance using wait statistics. Whether you are new to wait statistics, or already familiar with them, this book will help you gain a deeper understanding on how wait statistics are generated and what they can mean for your SQL Server’s performance.Besides the most common wait types, Pro SQL Server Wait Statistics goes further into the more complex and performance t...

Filled with practical, step-by-step instructions and clear explanations for the most important and useful tasks. This book is written in a concise, focused style with numerous practical and hands-on recipes and examples. If you want to leverage Redis to create blazing fast applications, then this book is for you.This book is for developers who are already proficient in programming and traditional databases and want to start learning about Redis for its simplicity and fast performance. A ba...

Implement and Maintain Rock-Solid Security for Oracle E-Business SuiteSecure Oracle E-Business Suite within organizations and across the Internet using the in-depth guidance of this comprehensive volume. Oracle E-Business Suite Security covers everything from key infrastructure, technical, and functional information to cutting-edge auditing, cryptography, and VPD techniques. Real-world scenarios and insightful tips throughout illustrate how to hacker-proof...