J. Melton. Understanding the New SQL: A Complete Guide. Morgan Kaufmann, 2 edition, 2000. Home/Search Document Not in Database Summary Related Articles Check |
This paper is cited in the following contexts:
First 50 documents Next 50
On Database Support for Multilingual Environments - Kumaran Jayant Haritsa (Correct)
....encodings. It should be noted that the UTF 8 encoding preserves ASCII encoding, while tripling the size of Indic strings from their proprietary ISCII encoding. The UTF 16 encoding doubles the size of data for both ASCII and ISCII strings. 3. 2 What does the SQL Standard offer Until the SQL 92 [12] standard, there was not much support specified in relational databases for languages other than English, which was assumed as a default. However, in late eighties the need for supporting multiple character sets was recognized and specifications were introduced in the standard to overcome this ....
J. Melton and A. R. Simon. Understanding the New SQL: A Complete Guide. Morgan Kaufmann, San Francisco, California, 1993.
Managing Large Multidimensional Datasets Inside A Database System - Chakrabarti (2001) (Correct)
....The purpose of the various lock modes are shown alongside. Serializability Concepts and the Phantom Problem Transactions, locking and serializability concepts are well documented in the literature [112, 113, 55] The phantom problem is defined as follows (from the ANSI ISO SQL 92 specifications [93, 7]) Transaction T1 reads a set of data items satisfying some search condition . Transaction T2 then creates data items that satisfy T1 s search condition and commits. If T1 then repeats its scan with the same search condition , it gets a set of data items (known as phantoms ) different from ....
J. Melton and A. R. Simon. Understanding the new sql: A complete guide. Morgan Kauffman, 1993.
On XML Integrity Constraints in the Presence of DTDs - Fan, Libkin (2001) (13 citations) (Correct)
....and inclusion dependencies are the ones used most often. More precisely, only two subclasses of functional and inclusion dependencies, namely, keys and foreign keys, are commonly found in practice. Both are fundamental to conceptual database design, and are supported by the SQL standard [30]. They provide a mechanism by which one can uniquely identify a tuple in a relation and refer to a tuple from another relation. They have proved useful in update anomaly prevention, query optimization and index design [1; 37] XML (eXtensible Markup Language [6] has become the prime standard for ....
J. Melton and A. Simon. Understanding the New SQL: A Complete Guide. Morgan Kaufman, 1993.
Semantics of Time-Varying Information - Christian Jensen And (1996) (6 citations) (Correct)
....temporal databases (cf. OS95] spatiotemporal databases (cf. Wor94] and active temporal databases. Finally, the ideas presented here and the methodology that will follow should be transitioned to existing implementation platforms, including non temporal query languages such as SQL 92 [MS93] In the short and perhaps even medium term, it is unrealistic to assume that applications will be designed using a temporal data model, implemented using novel temporal query languages, and run on as yet nonexistent temporal DBMSs. 43 5 Acknowledgments We would like to thank Jim Clifford, ....
J. Melton and A. R. Simon. Understanding the New SQL: A Complete Guide. Morgan Kaufmann Publishers, Inc., San Mateo, CA, 1993.
On XML Integrity - Fan, Libkin (Correct)
....functional and inclusion dependencies are the ones used most often. More precisely, only two subclasses of functional and inclusion dependencies, namely, keys and foreign keys, are commonly found in practice. Both are fundamental to conceptual database design, and are supported by the SQL standard [30]. They provide a mechanism by which one can uniquely identify a tuple in a relation and refer to a tuple from another relation. They have proved useful in update anomaly prevention, query optimization and index design [1; 37] XML (eXtensible Markup Language [6] has become the prime standard for ....
J. Melton and A. Simon. Understanding the New SQL: A Complete Guide. Morgan Kaufman, 1993.
Querying Hierarchical Data in Very Large Databases - Kachai (Correct)
....data structures is the Partially Ordered Set (POSET) 6] which is used in applications such as livestock, corporate management, company divisions, manufacturing, literature, ideas, evolution, scientific research and theory. Unfortunately, SQL (Structured Query Language) and its numerous extensions [7, 8] do not effectively support hierarchical data structures in relational databases. In Oracle, hierarchical data is represented as the collection of relational tables. We are able to query POSET data using the CONNECT BY clause of SQL [9] to search for hierarchical relationships presented by the ....
J. Melton and A.R. Simon, "Understanding the New SQL: A Complete Guide",Morgan Kaufmann, San Francisco, CA, 1993.
Optimizing Queries with Universal Quantification.. - Claussen, Kemper, .. (1997) (6 citations) (Correct)
....(20) 3.3 Null Values In this subsection, we will revisit our equivalences under the aspect of unknown attribute values. The ODMG standard [Cat96] addresses null values only for object references (nil references) Since null values are, however, integral part of SQL, we will assume SQL semantics [MS93] for null values, i.e. we use a three valued logic with a third value unknown. In this three valued logic the truth value of (trueunknown) is unknown, of (falseunknown) is false, of (trueunknown) is true, of (falseunknown) is unknown, and ( unknown) is unknown. An object qualifies for a subquery ....
J. Melton and A. R. Simon. Understanding the new SQL: a complete guide. Morgan-Kaufmann Publishers, San Mateo, CA, USA, 1993.
Constraints for Semistructured Data and XML - Buneman, Fan, Siméon.. (2001) (4 citations) (Correct)
....[16, 13, 21] It appears, therefore, that the distinction between types and constraints is dictated largely by what conventional programming languages treat as types. That there is a non trivial interaction between types and constraints is evident from consideration of the following SQL [20] specification: create table students ( SSN char(9) name char(20) primary key (SSN) create table courses ( cno char(7) 1 r courses name SSN cno title SSN DB 234 Kate CS 331 234 123 Greg 123 CS 331 ( a ) r students students courses CS 331 DB 123 Greg ....
J. Melton and A. Simon. Understanding the New SQL: A Complete Guide. Morgan Kaufman, 1993.
A Critique of ANSI SQL Isolation Levels - Berenson, Bernstein, Gray.. (1995) (39 citations) Self-citation (Melton) (Correct)
No context found.
J. Melton and A. R. Simon, "Understanding The New SQL: A Complete Guide," Morgan Kaufmann 1993.
A Wakeup Call for Internet Monitoring Systems: - The Case For (Correct)
No context found.
J. Melton. Understanding the New SQL: A Complete Guide. Morgan Kaufmann, 2 edition, 2000.
INVITED PAPER Special Issue on New Generation Database.. - Revisiting The.. (Correct)
No context found.
J. Melton and A. R. Simon. Understanding the new SQL: A complete guide. Morgan Kaufmann, San Francisco, CA, 1993.
Business Process Query Language - a Way to Make Workflow.. - Momotko, Subieta (2004) (Correct)
No context found.
Melton, J., Simon, A., Understanding the New SQL: A Complete Guide. Morgan Kaufmann, 1993
Resource-Based Scripting to Stitch Distributed Components - Andreoli, Arregui.. (2002) (Correct)
No context found.
J. Melton and A. R. Simon. Understanding the New SQL: A Complete Guide. Morgan Kaufmann Publishers, Inc., San Mateo, CA, 1993.
Business Process Query Language - a Way to Make Workflow.. - Momotko, Subieta (2004) (Correct)
No context found.
Melton, J., Simon, A.: Understanding the New SQL: A Complete Guide. Morgan Kaufmann, 1993 13 Melton, J., Simon, A., R., Gray, J.: SQL:1999 - Understanding Relational Language Components. Morgan Kaufmann Publishers, 2001 14 Momotko, M., Subieta. K.: Dynamic change of Workflow Participant Assignment, ADBIS'2002, Bratislava, Slovakia
On Database Support for Multilingual Environments - Kumaran Jayant Haritsa (Correct)
No context found.
J. Melton and A. R. Simon. Understanding the New SQL: A Complete Guide. Morgan Kaufmann, San Francisco, California, 1993.
Point- Versus Interval-based Temporal Data Models - Bohlen Busatto Jensen (1998) (6 citations) (Correct)
No context found.
J. Melton and A. R. Simon. Understanding the new SQL: A Complete Guide. Morgan Kaufmann, 1993.
Multidimensional Data Modeling for Complex Data - Pedersen, Jensen (1999) (19 citations) (Correct)
No context found.
J. Melton and A. R. Simon. Understanding the new SQL - A Complete Guide. Morgan Kaufmann, 1993.
Point- Versus Interval-based Temporal Data Models - Bohlen, Busatto, Jensen (1998) (6 citations) (Correct)
No context found.
J. Melton and A. R. Simon. Understanding the new SQL: A Complete Guide. Morgan Kaufmann, 1993.
Analysis of the Metamodeling Semantics for OCL - Tchertchago (2002) (Correct)
No context found.
Jim Melton, Alan R. Simon. Understanding the New SQL: A Complete Guide. Morgan Kaufmann Publishers, Inc., 1994.
Consistency of XML Specifications - Arenas, Fan, Libkin (Correct)
No context found.
J. Melton and A. Simon. Understanding the New SQL: A Complete Guide. Morgan Kaufman, 1993.
Unknown - Alvaro Fernandes Norman (Correct)
No context found.
J. Melton and A. R. Simon. Understanding the New SQL: A Complete Guide. Morgan Kaufman, 1993. ISBN 1-55860-245-3.
INVITED PAPER Special Issue on New Generation Database.. - Revisiting The.. (Correct)
No context found.
J. Melton and A. R. Simon. Understanding the new SQL: A complete guide. Morgan Kaufmann, San Francisco, CA, 1993.
Unknown - Anuradha Shenoy Of (Correct)
No context found.
Melton, Jim, & Alan, Simon R. "Understanding the New SQL: A Complete Guide," Morgan Kaufmann Publishers, San Francisco, CA, 1993. 53
Data Cube: A Relational Aggregation Operator - Generalizing Group-By Cross-Tab (Correct)
No context found.
Jim Melton and Alan Simon, Understanding the New SQL: A Complete Guide, Morgan Kaufmann, San Francisco, CA, 1993.
Unknown - Computer Ieee Vol (Correct)
No context found.
J. Melton, and A.R. Simon, Understanding the New SQL: A Complete Guide, Morgan Kaufmann, San Francisco, 1993.
First 50 documents Next 50
Online articles have much greater impact More about CiteSeer.IST Add search form to your site Submit documents Feedback
CiteSeer.IST - Copyright Penn State and NEC