Cover for Advanced SQL:1999

Advanced SQL:1999

Understanding Object-Relational and Other Advanced Features

A volume in The Morgan Kaufmann Series in Data Management Systems

Book2003

Authors:

Jim Melton

Advanced SQL:1999

Understanding Object-Relational and Other Advanced Features

A volume in The Morgan Kaufmann Series in Data Management Systems

Book2003

 

Cover for Advanced SQL:1999

Authors:

Jim Melton

Browse this book

Book description

Advanced SQL:1999 - Understanding Object-Relational and Other Advanced Features is the practitioner's handbook to the standard's advanced features. It is not a re-presentation of t ... read full description

Browse content

Table of contents

Actions for selected chapters

Select all / Deselect all

  1. Full text access
  2. Book chapterAbstract only

    Chapter 1 - Introduction to SQL:1999

    Pages 1-19

  3. Book chapterAbstract only

    Chapter 2 - User-Defined Types

    Pages 21-117

  4. Book chapterAbstract only

    Chapter 3 - Typed Tables

    Pages 119-151

  5. Book chapterAbstract only

    Chapter 4 - Routines and Routine Invocation

    Pages 153-233

  6. Book chapterAbstract only

    Chapter 5 - Foreign Servers and Foreign-Data Wrappers

    Pages 235-278

  7. Book chapterAbstract only

    Chapter 6 - Datalinks

    Pages 279-297

  8. Book chapterAbstract only

    Chapter 7 - OLAP

    Pages 299-349

  9. Book chapterAbstract only

    Chapter 8 - SQL/OLB and SQL/JRT

    Pages 351-374

  10. Book chapterAbstract only

    Chapter 9 - SQL/XML

    Pages 375-409

  11. Book chapterAbstract only

    Chapter 10 - SQL Multimedia and Application Packages

    Pages 411-443

  12. Book chapterAbstract only

    Chapter 11 - A Look to the Future

    Pages 445-448

  13. Book chapterNo access

    Appendix A - An SQL:1999 Example Using UDTs

    Pages 449-470

  14. Book chapterNo access

    Appendix B - The SQL:1999 Annexes

    Pages 471-495

  15. Book chapterNo access

    Appendix C - Relevant Standards Bodies

    Pages 497-504

  16. Book chapterNo access

    Appendix D - Status Codes

    Pages 505-517

  17. Book chapterNo access

    Appendix E - The SQL Standardization Process

    Pages 519-530

  18. Book chapterNo access

    Index

    Pages 531-561

  19. Book chapterNo access

    About the Author

    Page 563

About the book

Description

Advanced SQL:1999 - Understanding Object-Relational and Other Advanced Features is the practitioner's handbook to the standard's advanced features. It is not a re-presentation of the standard, but rather an authoritative, in-depth guide to its practical application. Like its companion, SQL:1999 - Understanding Relational Language Components, which explained the standard's basic features, this book will show you how to make your applications both effective and standard-compliant.

This handy reference has a modular format so you can explore specific topics with ease. It is equally useful to those upgrading from earlier versions of SQL and those with no previous experience. Written by the standard's distinguished editor, Advanced SQL:1999 will complete your knowledge and support your skills like no other book can.

Advanced SQL:1999 - Understanding Object-Relational and Other Advanced Features is the practitioner's handbook to the standard's advanced features. It is not a re-presentation of the standard, but rather an authoritative, in-depth guide to its practical application. Like its companion, SQL:1999 - Understanding Relational Language Components, which explained the standard's basic features, this book will show you how to make your applications both effective and standard-compliant.

This handy reference has a modular format so you can explore specific topics with ease. It is equally useful to those upgrading from earlier versions of SQL and those with no previous experience. Written by the standard's distinguished editor, Advanced SQL:1999 will complete your knowledge and support your skills like no other book can.

Key Features

  • Focuses entirely on the issues that matter to programmers who are connecting applications to databases.
  • Details SQL:1999's object facilities, including structured user-defined types, typed tables, user-defined routines, and routine invocation.
  • Examines facilities new to SQL, including those relating to on-line analytical processing (OLAP), management of external data (SQL/MED), and Java support.
  • Covers the ongoing development of XML support.
  • Includes appendices that cover the SQL:1999 annexes, a SQL:1999 example using UDTs, status codes, and useful information on the standardization process.
  • Focuses entirely on the issues that matter to programmers who are connecting applications to databases.
  • Details SQL:1999's object facilities, including structured user-defined types, typed tables, user-defined routines, and routine invocation.
  • Examines facilities new to SQL, including those relating to on-line analytical processing (OLAP), management of external data (SQL/MED), and Java support.
  • Covers the ongoing development of XML support.
  • Includes appendices that cover the SQL:1999 annexes, a SQL:1999 example using UDTs, status codes, and useful information on the standardization process.

Details

ISBN

978-1-55860-677-7

Language

English

Published

2003

Copyright

Copyright © 2003 Elsevier Inc. All rights reserved

Imprint

Morgan Kaufmann

You currently don’t have access to this book, however you can purchase separate chapters directly from the table of contents or buy the full version.

Purchase the book

Authors

Jim Melton

Oracle Corporation