Data Modeling Essentials, Third Edition provides expert tutelage for data modelers, business analysts and systems designers at all levels. Beginning with the basics, this book provides a thorough grounding in theory before guiding the reader through the various stages of applied data modeling and database design.Показать полностьюData Modeling Essentials, Third Edition provides expert tutelage for data modelers, business analysts and systems designers at all levels. Beginning with the basics, this book provides a thorough grounding in theory before guiding the reader through the various stages of applied data modeling and database design. Later chapters address advanced subjects, including business rules, data warehousing, enterprise-wide modeling and data management. The third edition of this popular book retains its distinctive hallmarks of readability and usefulness, but has been given significantly expanded coverage and reorganized for greater reader comprehension. Authored by two leaders in the field, Data Modeling Essentials, Third Edition is the ideal reference for professionals and students looking for a real-world perspective. Thorough coverage of the fundamentals and relevant theory. Recognition and support for the creative side of the process. Expanded coverage of applied data modeling includes new chapters on logical and physical database design. New material describing a powerful technique for model verification. Unique coverage of the practical and human aspects of modeling, such as working with business specialists, managing change, and resolving conflict. Extensive online component including course notes and other teaching aids (www.mkp.com).

SQL Tuning author Dan Tow outlines a timesaving method he’s developed for finding the optimum execution plan--rapidly and systematically--regardless of the complexity of the SQL or the database platform being used.Показать полностьюSQL Tuning author Dan Tow outlines a timesaving method he’s developed for finding the optimum execution plan--rapidly and systematically--regardless of the complexity of the SQL or the database platform being used. You'll learn how to understand and control SQL execution plans and how to diagram SQL queries to deduce the best execution plan for a query. Key chapters in the book includes exercises to reinforce the concepts you've learned. SQL Tuning concludes by addressing special concerns and unique solutions to “unsolvable” problems.

This book is developed from notes I used in a course at Princeton that attempted to bring database systems into the mainstream of computer science. The course was taught to a mix of seniors and first-year graduate students.Показать полностьюThis book is developed from notes I used in a course at Princeton that attempted to bring database systems into the mainstream of computer science. The course was taught to a mix of seniors and first-year graduate students. In it, I tried to relate database ideas to concepts from other areas, such as programming languages, algorithms, and data structures.. A substantial amount of descriptive material was included, since students, being used to conventional programming languages, may find query languages rather unusual. The data structures relevant to databases are also somewhat different from the kinds of structures used in conventional programming, since the large scale of a database makes practical many structures that would be only of theoretical interest otherwise.

ADO (Active Data Objects) is how the millions of Visual Basic programmers hitch onto Microsoft’s amazing “Universal Database Access” strategy. But power breeds complexity, and using ADO isn't trivial! This book is based on best-selling author Bill Vaughn’s years of experience working with front-line data access developers and the development teams at Microsoft itself.Показать полностьюADO (Active Data Objects) is how the millions of Visual Basic programmers hitch onto Microsoft’s amazing “Universal Database Access” strategy. But power breeds complexity, and using ADO isn't trivial! This book is based on best-selling author Bill Vaughn’s years of experience working with front-line data access developers and the development teams at Microsoft itself. Now, this Microsoft veteran translates his insights and collected wisdom from over a decade at Microsoft into working solutions for the common (and some not so common) data-related problems developers face every day. ADO Examples and Best Practices focuses on addressing data problems at the root — through better designs and better ADO coding practices. These suggestions often yield far better performance — both for the developer (who is able to write better code more quickly), and for the application (it runs faster with fewer resources).

Unless you are working at a very advanced level, this is the only SQL book you will ever need. The authors have taken the mystery out of complex queries and explained principles and techniques with such clarity that a “Mere Mortal” will indeed be empowered to perform the superhuman.Показать полностьюUnless you are working at a very advanced level, this is the only SQL book you will ever need. The authors have taken the mystery out of complex queries and explained principles and techniques with such clarity that a “Mere Mortal” will indeed be empowered to perform the superhuman. Do not walk past this book! — Graham Mandeno, Database Consultant SQL Queries for Mere Mortals provides a step-by-step, easy-to-read introduction to writing SQL queries. It includes hundreds of examples with detailed explanations. This book provides the tools you need to understand, modify, and create SQL queries — Keith W. Hare, Convenor, ISO/IEC JTC1 SC32 WG3 — the International SQL Standards Committee I learned SQL primarily from the first edition of this book, and I am pleased to see a second edition of this book so that others can continue to benefit from its organized presentation of the language. Starting from how to design your tables so that SQL can be effective (a common problem for database beginners), and then continuing through the various aspects of SQL construction and capabilities, the reader can become a moderate expert upon completing the book and its samples. Learning how to convert a question in English into a meaningful SQL statement will greatly facilitate your mastery of the language. Numerous examples from real life will help you visualize how to use SQL to answer the questions about the data in your database. Just one of the “watch out for this trap” items will save you more than the cost of the book when you avoid that problem when writing your queries. Ihighly recommend this book if you want to tap the full potential of your database. — Kenneth D. Snell, Ph.D., Database Designer/Programmer I don't think they do this in public schools any more, and it is a shame, but do you remember in the seventh and eighth grades when you learned to diagram a sentence? Those of you who do may no longer remember how you did it, but all of you do write better sentences because of it. John Viescas and Mike Hernandez must have remembered because they take everyday English queries and literally translate them into SQL. This is an important book for all database designers. It takes the complexity of mathematical Set Theory and of First Order Predicate Logic, as outlined in E. F. Codd’s original treatise on relational database design, and makes it easy for anyone to understand. If you want an elementary- through intermediate-level course on SQL, this is the one book that is a requirement, no matter how many others you buy. — Arvin Meyer, MCP, MVP Even in this day of wizards and code generators, successful database developers still require a sound knowledge of Structured Query Language (SQL, the standard language for communicating with most database systems). In this book, John and Mike do a marvelous job of making what’s usually a dry and difficult subject come alive, presenting the material with humor in a logical manner, with plenty of relevant examples. I would say that this book should feature prominently in the collection on the bookshelf of all serious developers, except that I'm sure it'll get so much use that it won't spend much time on the shelf! — Doug Steele, Microsoft Access Developer and author Over the last several decades, SQL has evolved from a language known only to computer specialists to a widely used international standard of the computer industry. The number of new applications deployed each year using SQL now totals in the millions. If you are accessing corporate information from the Internet or from an internal network, you are probably using SQL. This new edition of SQL Queries for Mere Mortals helps new users learn the foundations of SQL queries, and is an essential reference guide for intermediate and advanced users. The accompanying CD contains five sample databases used for the example queries throughout the book in four different formats: Microsoft SQL Server 2000 and later, Microsoft Access 2000 and later, MySQL version 5.0 and later, and SQL scripts that can be used with most other implementations of the language.

If you are accepted by the Association for Computing Machinery (ACM) as a reviewer, you join an elite corps of qualified commentators providing expert critiques of published work in the computing disciplines.Показать полностьюIf you are accepted by the Association for Computing Machinery (ACM) as a reviewer, you join an elite corps of qualified commentators providing expert critiques of published work in the computing disciplines. When you fill out the application, you set your own terms on the frequency of reviewing as well as the subject matter you wish to review. As a reviewer candidate you will be evaluated and approved based on many criteria, including educational background and professional experience. CR has published 40 years’ worth of thought-provoking reviews; the future is up to you. To get started, click on the “Become a Reviewer” link below. You will choose your own User ID and Password; you do not need to enter one above.

Data Warehousing and Mining (DWM) is the science of managing and analyzing large datasets and discovering novel patterns and in recent years has emerged as a particularly exciting and industrially relevant area of research.Показать полностьюData Warehousing and Mining (DWM) is the science of managing and analyzing large datasets and discovering novel patterns and in recent years has emerged as a particularly exciting and industrially relevant area of research. Prodigious amounts of data are now being generated in domains as diverse as market research, functional genomics and pharmaceuticals; intelligently analyzing these data, with the aim of answering crucial questions and helping make informed decisions, is the challenge that lies ahead. The Encyclopedia of Data Warehousing and Mining provides a comprehensive, critical and descriptive examination of concepts, issues, trends, and challenges in this rapidly expanding field of data warehousing and mining (DWM). In addition, this authoritative publication offers in-depth coverage of evolutions, theories, methodologies, functionalities, and applications of DWM in such interdisciplinary industries as healthcare informatics, artificial intelligence, financial modeling, and applied statistics. Numerous contributions from researchers from all around the world make this encyclopedia a single source of knowledge and latest discoveries in the field of DWM.

Grid Database Design investigates the origin, background, and components of this new computing model. It presents new concepts and analyzes pre-existing ideas in the context of Grid, educating organizations as to how Grid can increase computing power and strengthen operations.Показать полностьюGrid Database Design investigates the origin, background, and components of this new computing model. It presents new concepts and analyzes pre-existing ideas in the context of Grid, educating organizations as to how Grid can increase computing power and strengthen operations. Divided into three sections, the volume begins by laying the groundwork, defining the concepts that led to the model’s emergence. The second section explains what is entailed in building a Grid, focusing on security, hardware, and the forces driving growth. The final section explores details of databases in a Grid environment, illustrating how the Grid environment will shape database evolution.

We investigate the issue of database mining.An approach is suggested based uppon the use of fuzzy lingusitic summaries.

IBM DB2 Universal Database v8.1.2 will help you access any information, from any application, from anywhere in your organization, anytime—and do it all more easily and cost-effectively than you ever thought possible. Now, in DB2 Version 8: The Official Guide, a team of IBM DB2 experts shows experienced DB2 professionals exactly how to make the most of DB2 Version 8 in any environment—Linux(R), UNIX(R), or Windows(R). The authors draw on extensive personal experience helping customers implement state-of-the-art DB2 solutions, and unparalleled access to the IBM DB2 development team.Показать полностьюIBM DB2 Universal Database v8.1.2 will help you access any information, from any application, from anywhere in your organization, anytime—and do it all more easily and cost-effectively than you ever thought possible. Now, in DB2 Version 8: The Official Guide, a team of IBM DB2 experts shows experienced DB2 professionals exactly how to make the most of DB2 Version 8 in any environment—Linux(R), UNIX(R), or Windows(R). The authors draw on extensive personal experience helping customers implement state-of-the-art DB2 solutions, and unparalleled access to the IBM DB2 development team. They offer detailed, never-before-published technical guidance for the key challenges you'll face in delivering high-performance DB2 databases, e-business infrastructure, and enterprise integration solutions.

Книга "Работаем с Oracle" представляет собой быстрое введение в методы и средства распределенной СУБД Oracle. Рассмотрены методологические основы распределенной обработки информации, основные объекты базы данных Oracle, язык SQL — базовое средство взаимодействия с сервером баз данных и его процедурное расширение PL/SQL.Показать полностьюКнига "Работаем с Oracle" представляет собой быстрое введение в методы и средства распределенной СУБД Oracle. Рассмотрены методологические основы распределенной обработки информации, основные объекты базы данных Oracle, язык SQL — базовое средство взаимодействия с сервером баз данных и его процедурное расширение PL/SQL. Представляется возможность получить углубленные знания по использованию SQL для работы с большими базами данных. Особое внимание уделено технологиям Oracle, обеспечивающим безопасность и целостность данных в условиях многопользовательского доступа. В книге также содержится описание средств, предназначенных для создания приложений на языке Java. Книга ориентирована на студентов, молодых специалистов и всех желающих самостоятельно познакомиться с Oracle — распределенной СУБД для эффективной обработки данных.

Anyone who interacts with today’s modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information.Показать полностьюAnyone who interacts with today’s modern databases needs to know SQL (Structured Query Language), the standard language for generating, manipulating, and retrieving database information. In recent years, the dramatic rise in the popularity of relational databases and multi-user databases has fueled a healthy demand for application developers and others who can write SQL code efficiently and correctly. If you're new to databases, or need a SQL refresher, Learning SQL on SQL Server 2005 is an ideal step-by-step introduction to this database query tool, with everything you need for programming SQL using Microsoft’s SQL Server 2005-one of the most powerful and popular database engines used today. Plenty of books explain database theory. This guide lets you apply the theory as you learn SQL. You don't need prior database knowledge, or even prior computer knowledge. Based on a popular university-level course designed by authors Sikha Saha Bagui and Richard Walsh Earp, Learning SQL on SQL Server 2005 starts with very simple SQL concepts, and slowly builds into more complex query development. Every topic, concept, and idea comes with examples of code and output, along with exercises to help you gain proficiency in SQL and SQL Server 2005. With this book, you'll learn: Beginning SQL commands, such as how and where to type an SQL query, and how to create, populate, alter and delete tables How to customize SQL Server 2005’s settings and about SQL Server 2005’s functions About joins, a common database mechanism for combining tables Query development, the use of views and other derived structures, and simple set operations Subqueries, aggregate functions and correlated subqueries, as well as indexes and constraints that can be added to tables in SQL Server 2005 Whether you're an undergraduate computer science or MIS student, a self-learner who has access to the new Microsoft database, or work for your company’s IT department, Learning SQL on SQL Server 2005 will get you up to speed on SQL in no time.

This handbook shows how to write faster and more robust stored procedures and functions, learn effective, real-world solutions to problems faced by database developers, designers, and administrators, and master topics such as optimizing and debugging.

Stored procedures are compiled T-SQL statements that reside on the database, and are the cornerstone of successful data manipulation; data-handling operations of any complexity make use of them.Показать полностьюStored procedures are compiled T-SQL statements that reside on the database, and are the cornerstone of successful data manipulation; data-handling operations of any complexity make use of them. This book is an in-depth guide to a key area of database development. This book tackles real-world problems faced by developers when working with stored procedures, showing how to solve these problems, avoid the common pitfalls and work around them, to produce faster, more robust stored procedures. Put simply: if you want to write better stored procedures, then this is the book for you.

Few technologies have been as eagerly anticipated as Microsoft SQL Server 2005 ("Yukon"). Now, three SQL Server insiders deliver the definitive hands-on preview — accurate, comprehensive, and packed with examples.Показать полностьюFew technologies have been as eagerly anticipated as Microsoft SQL Server 2005 ("Yukon"). Now, three SQL Server insiders deliver the definitive hands-on preview — accurate, comprehensive, and packed with examples. A First Look at SQL Server 2005 for Developers starts where Microsoft’s white papers and Web articles leave off, showing working developers how to take full advantage of Yukon’s key innovations. It draws on exceptional cooperation from Microsoft’s Yukon developers and the authors' hands-on access to Yukon since its earliest alpha releases. You'll find practical explanations of Yukon’s new data model, built-in .NET hosting, improved programmability, SQL-99 compliance, and much more. Virtually every key concept is illuminated via sample code tested with Microsoft’s public beta. Key coverage includes: * Yukon as .NET runtime host: enhancing security, reliability, and performance * Writing procedures, functions, and triggers in .NET languages * Leveraging powerful new enhancements to T-SQL * The XML data type and XML query languages * SQL Server 2005 as a Web Services platform * Client-side coding: ADO/ADO.NET enhancements, SQLXML, mapping, ObjectSpaces, and more * Using SQL Server 2005’s built-in application server capabilities

Few technologies have been as eagerly anticipated as Microsoft SQL Server 2005. Now, two SQL Server insiders deliver the definitive hands-on guide—accurate, comprehensive, and packed with examples.Показать полностьюFew technologies have been as eagerly anticipated as Microsoft SQL Server 2005. Now, two SQL Server insiders deliver the definitive hands-on guide—accurate, comprehensive, and packed with examples. ADeveloper’s Guide to SQL Server 2005 starts where Microsoft’s documentation, white papers, and Web articles leave off, showing developers how to take full advantage of SQL Server 2005’s key innovations. It draws on exceptional cooperation from Microsoft’s SQL Server developers and the authors' extensive access to SQL Server 2005 since its earliest alpha releases. You'll find practical explanations of the new SQL Server 2005 data model, built-in .NET hosting, improved programmability, SQL: 1999 compliance, and much more. Virtually every key concept is illuminated via sample code that has been fully updated for and tested with the shipping version of the product. Key coverage includes • Using SQL Server 2005 as a .NET runtime host: extending the server while enhancing security, reliability, and performance • Writing procedures, functions, triggers, and types in .NET languages • Exploiting enhancements to T-SQL for robust error-handling, efficient queries, and improved syntax • Effectively using the XML data type and XML queries • Implementing native SQL Server 2005 Web Services • Writing efficient, robust clients for SQL Server 2005 using ADO.NET, classic ADO, and other APIs • Taking full advantage of user-defined types (UDTs), query notifications, promotable transactions, and multiple active result sets (MARS) • Using SQL Management Objects (SMO), SQL Service Broker, and SQL Server Notification Services to build integrated applications

This cookbook contains a wealth of solutions to problems that SQL programmers face all the time. Recipes inside range from how to perform simple tasks, like importing external data, to ways of handling issues that are more complicated, like set algebra.Показать полностьюThis cookbook contains a wealth of solutions to problems that SQL programmers face all the time. Recipes inside range from how to perform simple tasks, like importing external data, to ways of handling issues that are more complicated, like set algebra. Each recipe includes a discussion that explains the logic and concepts underlying the solution. The book covers audit logging, hierarchies, importing data, sets, statistics, temporal data, and data structures.

A major software release, SQL 2000 is tailor-made for the multitude of programmers working in the Windows 2000 Active Directory environment, which allows administrators and others to manage and share data.Показать полностьюA major software release, SQL 2000 is tailor-made for the multitude of programmers working in the Windows 2000 Active Directory environment, which allows administrators and others to manage and share data. This thorough guide is written for users switching from SQL 7 under Windows NT, as well as those starting from scratch. Clear, concise, and packed with examples, it includes: A migration-path chapter for users who are upgrading; configuration techniques using new data warehousing and XML capacities; case studies depicting large-scale deployments of applications and databases built with SQL 2000; a "fast-track" chapter at the end summarizing the entire book; a “secrets” appendix giving information on the least-known, but most powerful features of Microsoft SQL Server 2000; detailing new features of Windows and SQL 2000 and designed for easy reference, this is the professional’s step-by-step, fully illustrated introduction to an exciting new data management system.

MySQL MaxDB is a mature and reliable database system that combines extremely high levels of performance and availability with a low cost of ownership. It offers absolute ease of use and almost unsupervised operation. MaxDB can handle a wide range of different types of information, which makes it a suitable server for diverse application scenarios. MaxDB works with all SAP applications.

With more than 4 million active installations, MySQL is the world’s most popular open-source database. Known for its speed, high reliability, and ease of use, MySQL is rapidly becoming a low-cost alternative to high-priced, high-maintenance database systems from Oracle, IMB and Microsoft-and it already has more users than any of these more established proprietary databases.Показать полностьюWith more than 4 million active installations, MySQL is the world’s most popular open-source database. Known for its speed, high reliability, and ease of use, MySQL is rapidly becoming a low-cost alternative to high-priced, high-maintenance database systems from Oracle, IMB and Microsoft-and it already has more users than any of these more established proprietary databases. The MySQL User’s Guide is the only official guide to installing MySQL, to setting up and administering databases, and to storing and retrieving data in these databases. Written by the creators of MySQL, and edited by the highly respected MySQL authors, the MySQL User’s Guide is designed for a broad audience. Non-programmers and programmers alike will be able to quickly get up-to-speed with MySQL using the clear instructions, examples, and tips provided in the book.