Advanced SQL:1999: Understanding Object-Relational and Other by Jim Melton

By Jim Melton

complex SQL:1999 - realizing Object-Relational and different complex beneficial properties is the practitioner's instruction manual to the standard's complicated positive aspects. it isn't a re-presentation of the traditional, yet particularly an authoritative, in-depth consultant to its sensible program. Like its better half, SQL:1999 - figuring out Relational Language parts , which defined the standard's simple gains, this booklet will assist you to make your purposes either potent and standard-compliant.

this useful reference has a modular layout so that you can discover particular themes conveniently. it truly is both important to these upgrading from past types of SQL and people without past event. Written by way of the standard's exceptional editor, complicated SQL:1999 will entire your wisdom and aid your talents like no different booklet can. * Focuses solely at the concerns that topic to programmers who're connecting purposes to databases. * information SQL:1999's item amenities, together with established user-defined kinds, typed tables, user-defined exercises, and regimen invocation. * Examines amenities new to SQL, together with these with regards to online analytical processing (OLAP), administration of exterior information (SQL/MED), and Java help. * Covers the continuing improvement of XML help. * contains appendices that hide the SQL:1999 annexes, a SQL:1999 instance utilizing UDTs, prestige codes, and precious info at the standardization method.

Show description

Read or Download Advanced SQL:1999: Understanding Object-Relational and Other Advanced Features (The Morgan Kaufmann Series in Data Management Systems) PDF

Best sql books

MySQL Cookbook

MySQL Cookbook offers a different problem-and-solution layout that gives useful examples for daily programming dilemmas. for each challenge addressed within the e-book, there's a worked-out answer or "recipe"--short, concentrated items of code so you might insert without delay into your purposes.

Microsoft SQL Server 2005: Database Essentials Step by Step

SQL Server 2005 is Microsoft's next-generation information administration and research answer that promises more suitable scalability, availability, and safety features to firm information and analytical functions whereas making them more straightforward to create, installation, and deal with. you can now train your self crucial recommendations for operating with SQL Server 2005 and begin designing, construction, trying out, and deploying SQL Server databases-one step at a time.

Microsoft SQL Server 2005 developer's guide

Builders will realize the best way to unharness the whole strength of Microsoft SQL Server 2005 with this developer's consultant through best-selling writer, Michael Otey. thoroughly rewritten and reengineered, this ebook will specialise in the recent programming versions and should offer readers with the entire details they should produce most effective advertisement purposes

Additional resources for Advanced SQL:1999: Understanding Object-Relational and Other Advanced Features (The Morgan Kaufmann Series in Data Management Systems)

Example text

The fact that C has long been a popular language for implementing operating system-level programs such as GUIs may have contributed to the development of a major C extension, C++, as an object-oriented programming language (OOPL). While there are many critics of C++ as a language, it nonetheless has many adherents and is arguably one of the most popular OOPLs in use today. However, some critics of C++ have been extremely successful in the creation of another language that shares many characteristics of C: Java.

There are no limits to what these behaviors can be, other than those set by the environm e n t in which you're operating. A type designer typically determines the behaviors supported by, or available to, the types being defined, but some systems permit applications to add new behaviors to existing types. 4, "Inheritance," gave you a brief overview of the topic. In this section, I'll illustrate the concepts to set the stage for the more detailed discussion later in this chapter. In the narrow world of my music and video store, the notion of movie is quite important.

1 Jim Melton and Andrew Eisenberg, UnderstandingSQL and Java Together:A Guide to SQLJ, JDBC, and Related Technologies (San Francisco: Morgan Kaufmann Publishers, 2000). 2, instances of SQL:1999's structured user-defined types are essentially values. Sure, they have m a n y of the characteristics that m a n y object-oriented systems give to their objects (instances of their classes), such as type hierarchies, user-provided behaviors, and so forth. But they're missing an important characteristic of true objects: a unique identity.

Download PDF sample

Rated 4.67 of 5 – based on 47 votes