SQL权威指南_英文_4th

Joe Celko’s

SQL for Smarties

Fourth Edition

Joe Celko’s Data, Measurements and

Standards in SQL

Joe Celko

Information Modeling and Relational

Databases, 2

nd

Edition

Gottfried Vossen, Stephan Hagemann

Enterprise Knowledge Management

David Loshin

Business Process Change, 2

nd

Edition

Paul Harmon

IT Manager’s Handbook, 2

nd

Edition

Bill Holtsnider & Brian Jaffe

Joe Celko’s Puzzles and Answers,

Joe Celko

Data Preparation for Data Mining Using

SAS

Mamdouh Refaat

Querying XML: XQuery, XPath, and SQL/

XML in Context

Jim Melton and Stephen Buxton

Data Mining: Concepts and Techniques,

2

nd

Foundations of Multidimensional and

Metric Data Structures

Hanan Samet

Joe Celko’s SQL for Smarties: Advanced

SQL Programming, 4

Joe Celko

Moving Objects Databases

Ralf Hartmut Güting and Markus

Schneider

for Data Mining and Exploration

Earl Cox

Data Modeling Essentials, 3

Edition

Graeme C. Simsion and Graham C. Witt

Location-Based Services

Jochen Schiller and Agnès Voisard

Managing Time in Relational Databases:

How to Design, Update and Query

Temporal Data

®

Terry Halpin, Ken Evans, Patrick Hallock,

Bill Maclean

Designing Data-Intensive Web Applications

Advanced SQL: 1999—Understanding Object-

Relational and Other Advanced Features

Jim Melton

Database Tuning: Principles, Experiments,

and Troubleshooting Techniques

SQL:1999—Understanding Relational

Jim Melton, Alan R. Simon

Information Visualization in Data Mining

and Knowledge Discovery

Edited by Usama Fayyad, Georges G.

Grinstein, Andreas Wierse

Transactional Information Systems

Gerhard Weikum and Gottfried Vossen

Spatial Databases

Philippe Rigaux, Michel Scholl, and Agnes

Understanding SQL and Java Together

Jim Melton and Andrew Eisenberg

Database: Principles, Programming, and

Performance, 2

nd

Edition

Patrick and Elizabeth O’Neil

Machine Learning Tools and Techniques

Joe Celko’s Data and Databases: Concepts

Joe Celko

Developing Time-Oriented Database

Applications in SQL

Richard T. Snodgrass

Web Farming for the Data Warehouse

Richard D. Hackathorn

Management of Heterogeneous and

Autonomous Database Systems

Edited by Ahmed Elmagarmid, Marek

nd

with

Dorothy Moore

Universal Database Management: A Guide

Readings in Database Systems, 3

rd

Understanding SQL’s Stored Procedures:

A Complete Guide to SQL/PSM

Jim Melton

Principles of Multimedia Database Systems

V. S. Subrahmanian

Principles of Database Query Processing

for Advanced Applications

Clement T. Yu, Weiyi Meng

Advanced Database Systems

Faloutsos, Richard T. Snodgrass, V. S.

Subrahmanian, Roberto Zicari

2

Philip A. Bernstein, Eric Newcomer

Relational Database System

Don Chamberlin

Rules For Advanced Database Processing

Edited by Jennifer Widom, Stefano Ceri

Migrating Legacy Systems: Gateways,

Interfaces, & the Incremental Approach

Michael L. Brodie, Michael Stonebraker

Atomic Transactions

Transaction Processing

Database Transaction Models for

Advanced Applications

A Guide to Developing Client/Server SQL

Applications

Setrag Khoshafian, Arvola Chan, Anna

Wong, Harry K. T. Wong

Joe Celko’s

SQL for Smarties

Advanced SQL Programming

Fourth Edition

Development Editor: David Bevans

Project Manager: Sarah Binns

Designer: Joanne Blank

30 Corporate Drive, Suite 400, Burlington, MA 01803, USA

© 2011 Elsevier Inc. All rights reserved.

No part of this publication may be reproduced or transmitted in any form or by any means, electronic or mechanical,

including photocopying, recording, or any information storage and retrieval system, without permission in writing

from the Publisher. Details on how to seek permission, further information about the Publisher’s permissions policies

and our arrangements with organizations such as the Copyright Clearance Center and the Copyright Licensing Agency,

researchers must always rely on their own experience and knowledge in evaluating and using any information or

methods described herein. In using such information or methods they should be mindful of their own safety and

the safety of others, including parties for whom they have a professional responsibility.

To the fullest extent of the law, neither the Publisher nor the authors, contributors, or editors assume any liability for

any injury and/or damage to persons or property as a matter of product liability, negligence or otherwise, or from any

use or operation of any methods, products, instructions, or ideas contained in the material herein.

Application submitted.

A catalogue record for this book is available from the British Library.