A Guide to SQL Standard - Softcover

Date, C. J.; Darwen, Hugh

Softcover

ISBN 10: 0201964260 ISBN 13: 9780201964264

Publisher: Addison Wesley, 1996

Synopsis

The SQL language has established itself as the linqua franca database management; it provides the basis for systems interoperability, application portability, client/server operation, distributed database, and more, and is supported by just about every DBMS on the market today. SQL2 - or, to give it its official name, the International Standard Database language SQL (1992) - represents a major set of extensions to the earlier SQL standard. For a start, the new specification is well over 600 pages, compared with less than 100 for the original version. No database professional can afford to ignore it. Features *Thorough revision of the official ANSI standard for SQL. *Covers all important new SQL2 features including extensive integrity support, powerful new operators, national and international character data support and comprehensive date and time support. *Continues the tradition of careful, clear, and accurate explanations of complex technical material Features New to this Edition *Covers extensive integrity support, powerful new operators, national and international character data support, all features of SQL2; comprehensive date and time support and clear explanation of the complexitites of Dynamic SQL, all features of SQL2. *Provides first tutorial treatment available anywhere of the brand new and dramatically extended version of SQL known informally as SQL2 or SQL/92. 0201964260B04062001

About this title

About the Author

C. J. Date is an independent author, lecturer, researcher, and consultant specializing in relational database systems, a field he helped pioneer. Among other projects, he was involved in technical planning for the IBM products SQL/DS and DB2. He is best known for his books, in particular, An Introduction to Database Systems (7th edition, Addison-Wesley, 2000), the standard text in the field, which has sold well over half a million copies worldwide. Mr. Date is widely acknowledged for his ability to explain complex technical material in a clear and understandable fashion.

Hugh Darwen has been involved in software development since 1967 as an employee of IBM United Kingdom, Ltd. He has been active in the relational database arena since 1978. He was one of the chief architects and developers of an IBM relational product called Business System 12, a product that faithfully embraced the principles of the relational model. He has been an active participant in the development of SQL international standards since 1988.

0201964260AB04062001

From the Back Cover

The SQL language has established itself as the linqua franca database management; it provides the basis for systems interoperability, application portability, client/server operation, distributed database, and more, and is supported by just about every DBMS on the market today. SQL2 - or, to give it its official name, the International Standard Database language SQL (1992) - represents a major set of extensions to the earlier SQL standard. For a start, the new specification is well over 600 pages, compared with less than 100 for the original version. No database professional can afford to ignore it.

Features

• Thorough revision of the official ANSI standard for SQL.
• Covers all important new SQL2 features including extensive integrity support, powerful new operators, national and international character data support and comprehensive date and time support.
• Continues the tradition of careful, clear, and accurate explanations of complex technical material

Features New to this Edition

• Covers extensive integrity support, powerful new operators, national and international character data support, all features of SQL2; comprehensive date and time support and clear explanation of the complexitites of Dynamic SQL, all features of SQL2.
• Provides first tutorial treatment available anywhere of the brand new and dramatically extended version of SQL known informally as SQL2 or SQL/92.

0201964260B04062001

Edition details

• Publisher: Addison Wesley
• Publication date: 1996
• Language: English
• ISBN 10: 0201964260
• ISBN 13: 9780201964264
• Binding: Paperback
• Edition number: 4
• Number of pages: 544