Beginning Database Design, Second Edition provides short, easy-to-read explanations of how to get database design right the first time. This book offers numerous examples to help you avoid the many pitfalls that entrap new and not-so-new database designers. Through the help of use cases and class diagrams modeled in the UML, you’ll learn to discover and represent the details and scope of any design problem you choose to attack. Database design is not an exact science. Many are surprised to find that problems with their databases are caused by poor design rather than by difficulties in using the database management software. Beginning Database Design, Second Edition helps you ask and answer important questions about your data so you can understand the problem you are trying to solve and create a pragmatic design capturing the essentials while leaving the door open for refinements and extension at a later stage. Solid database design principles and examples help demonstrate the consequences of simplifications and pragmatic decisions. The rationale is to try to keep a design simple, but allow room for development as situations change or resources permit. Provides solid design principles by which to avoid pitfalls and support changing needs Includes numerous examples of good and bad design decisions and their consequences Shows a modern method for documenting design using the Unified Modeling Language

*The most updated PostgreSQL book on the market, covering version 8.0 *Highlights the most popular PostgreSQL APIs, including C, Perl, PHP, and Java *This is two books in one; it simultaneously covers key relational database design principles, while teaching PostgreSQL

Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will: Move quickly through SQL basics and learn several advanced features Use SQL data statements to generate, manipulate, and retrieve data Create database objects, such as tables, indexes, and constraints, using SQL schema statements Learn how data sets interact with queries, and understand the importance of subqueries Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.

Assuming only basic knowledge of C# 3.0, Beginning C# 3.0 Databases teaches all the fundamentals of database technology and database programming readers need to quickly become highly proficient database users and application developers. It explains and demonstrates how to create database objects and program against them in both T-SQL and C#. Full of practical, detailed examples, it's been fully revised and updated for C# 3.0 and offers the most complete, detailed, and gentle introduction to database technology for all C# programmers at any level of experience.

Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance. Now, for the first time, leading agile methodologist Scott Ambler and renowned consultant Pramodkumar Sadalage introduce powerful refactoring techniques specifically designed for database systems. Ambler and Sadalage demonstrate how small changes to table structures, data, stored procedures, and triggers can significantly enhance virtually any database design–without changing semantics. You’ll learn how to evolve database schemas in step with source code–and become far more effective in projects relying on iterative, agile methodologies. This comprehensive guide and reference helps you overcome the practical obstacles to refactoring real-world databases by covering every fundamental concept underlying database refactoring. Using start-to-finish examples, the authors walk you through refactoring simple standalone database applications as well as sophisticated multi-application scenarios. You’ll master every task involved in refactoring database schemas, and discover best practices for deploying refactorings in even the most complex production environments. The second half of this book systematically covers five major categories of database refactorings. You’ll learn how to use refactoring to enhance database structure, data quality, and referential integrity; and how to refactor both architectures and methods. This book provides an extensive set of examples built with Oracle and Java and easily adaptable for other languages, such as C#, C++, or VB.NET, and other databases, such as DB2, SQL Server, MySQL, and Sybase. Using this book’s techniques and examples, you can reduce waste, rework, risk, and cost–and build database systems capable of evolving smoothly, far into the future.

This two volume set LNCS 6587 and LNCS 6588 constitutes the refereed proceedings of the 16th International Conference on Database Systems for Advanced Applications, DASFAA 2011, held in Saarbrücken, Germany, in April 2010. The 53 revised full papers and 12 revised short papers presented together with 2 invited keynote papers, 22 demonstration papers, 4 industrial papers, 8 demo papers, and the abstract of 1 panel discussion, were carefully reviewed and selected from a total of 225 submissions. The topics covered are social network, social network and privacy, data mining, probability and uncertainty, stream processing, graph, XML, XML and graph, similarity, searching and digital preservation, spatial queries, query processing, as well as indexing and high performance.

Database marketing is at the crossroads of technology, business strategy, and customer relationship management. Enabled by sophisticated information and communication systems, today’s organizations have the capacity to analyze customer data to inform and enhance every facet of the enterprise—from branding and promotion campaigns to supply chain management to employee training to new product development. Based on decades of collective research, teaching, and application in the field, the authors present the most comprehensive treatment to date of database marketing, integrating theory and practice. Presenting rigorous models, methodologies, and techniques (including data collection, field testing, and predictive modeling), and illustrating them through dozens of examples, the authors cover the full spectrum of principles and topics related to database marketing. "This is an excellent in-depth overview of both well-known and very recent topics in customer management models. It is an absolute must for marketers who want to enrich their knowledge on customer analytics." (Peter C. Verhoef, Professor of Marketing, Faculty of Economics and Business, University of Groningen) "A marvelous combination of relevance and sophisticated yet understandable analytical material. It should be a standard reference in the area for many years." (Don Lehmann, George E. Warren Professor of Business, Columbia Business School) "The title tells a lot about the book's approach—though the cover reads, "database," the content is mostly about customers and that's where the real-world action is. Most enjoyable is the comprehensive story – in case after case – which clearly explains what the analysis and concepts really mean. This is an essential read for those interested in database marketing, customer relationship management and customer optimization." (Richard Hochhauser, President and CEO, Harte-Hanks, Inc.) "In this tour de force of careful scholarship, the authors canvass the ever expanding literature on database marketing. This book will become an invaluable reference or text for anyone practicing, researching, teaching or studying the subject." (Edward C. Malthouse, Theodore R. and Annie Laurie Sills Associate Professor of Integrated Marketing Communications, Northwestern University)