or
Sign in to turn on 1-Click ordering.
or
Amazon Prime Free Trial required. Sign up when you check out. Learn More
Kindle Edition
Read instantly on your iPad, PC or Mac, no Kindle required
Buy Price: $55.29
Rent From: $30.09
 
 
   
More Buying Choices
Have one to sell? Sell yours here
Advanced SQL:1999: Understanding Object-Relational and Other Advanced Features (The Morgan Kaufmann Series in Data Management Systems)
 
 

Advanced SQL:1999: Understanding Object-Relational and Other Advanced Features (The Morgan Kaufmann Series in Data Management Systems) [Paperback]

Jim Melton (Author)

Price: $81.95 & this item ships for FREE with Super Saver Shipping. Details
  Special Offers Available
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
Want it delivered Thursday, February 2? Choose One-Day Shipping at checkout. Details
Textbook Student FREE Two-Day Shipping for students on millions of items. Learn more

Formats

Amazon Price New from Used from
Kindle Edition
Rent from
$55.29
$30.09
 
Paperback $81.95  

Book Description

1558606777 978-1558606777 September 23, 2002 1


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.

* 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.


Special Offers and Product Promotions

  • Buy $50 in qualifying physical textbooks, get $5 in Amazon MP3 Credit. Here's how (restrictions apply)

Editorial Reviews

From the Back Cover


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.


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.

About the Author

Jim Melton is editor of all parts of ISO/IEC 9075 (SQL) and is a representative for database standards at Oracle Corporation. Since 1986, he has been his company's representative to ANSI INCITS Technical Committee H2 for Database and a US representative to ISO/IEC JTC1/SC32/WG3 (Database Languages). In addition, Jim has participated in the W3C's XML Query Working Group since 1998 and is currently co-Chair of that Working Group. He is also Chair of the WG's Full-Text Task Force, co-Chair of the Update Language Task Force, and co-editor of two XQuery-related specifications. He is the author of several SQL books.


Product Details


More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews


There are no customer reviews yet.
Video reviews
Video reviews
Amazon now allows customers to upload product video reviews. Use a webcam or video camera to record and upload reviews to Amazon.



Inside This Book (learn more)
First Sentence:
The decade of the 1990s was notable for many significant events in multiple areas of information technology: client/server computing; the evolution of the Internet from an academic and research network into the foundation of e-commerce and e-business; the growth of business intelligence and data warehousing; the emergence of the World Wide Web as a medium for commerce; widespread adoption of packaged software for enterprise applications, call center management, sales force automation, and customer relationship management (CRM); and many other advances that have made information technology, circa the turn of the century, exponentially more pervasive in business and society than a mere decade earlier. Read the first page
Key Phrases - Statistically Improbable Phrases (SIPs): (learn more)
datalink value, invocable routines, invocable name, routine invocation algorithm, column whose data type, alter type statement, discount proc, given structured type, maximal supertype, foreign server, structured type definition, total dvd sales, maximal supertable, structured type values, dynamic result sets, facet xsd, from movie table, type definers, typed tables, func dec, datalink column, function invocation syntax, datalink type, specific structured type, authorization identifier
Key Phrases - Capitalized Phrases (CAPs): (learn more)
Dolby Digital, San Francisco, Morgan Kaufmann Publishers, Serial Mom, The Bone Collector, Related Technologies, Bone Daddy, Denzel Washington, Information Schema, Lunch Lady, Management of External Data, Understanding Relational Language Components, United States, Wrapper Routine Purpose, Peter Sellers, Picture Show, Rocky Horror, World Wide Web, Honeysuckle Rose, Left Branch, New York, Persistent Stored Modules, Result of Query Using, Right Branch, Sample Type Hierarchy
New!
Books on Related Topics | Concordance | Text Stats
Browse Sample Pages:
Front Cover | Table of Contents | First Pages | Index | Surprise Me!
Search Inside This Book:





Tag this product

 (What's this?)
Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items.
Your tags: Add your first tag
 

Customer Discussions

This product's forum
Discussion Replies Latest Post
No discussions yet

Ask questions, Share opinions, Gain insight
Start a new discussion
Topic:
First post:
Prompts for sign-in
 


Active discussions in related forums
Search Customer Discussions
Search all Amazon discussions
   
Related forums


Listmania!


Create a Listmania! list

So You'd Like to...


Create a guide


Look for Similar Items by Category


Look for Similar Items by Subject