FSQL: A Fuzzy SQL for Fuzzy Databases

FSQL: A Fuzzy SQL for Fuzzy Databases

Jose Galindo (Universidad de Málaga, Spain), Angelica Urrutia (Universidad Católica del Maule, Chile) and Mario Piattini (Universidad de Castilla-La Mancha, Spain)
Copyright: © 2006 |Pages: 80
DOI: 10.4018/978-1-59140-324-1.ch007
OnDemand PDF Download:
$37.50

Abstract

The SQL language was essentially developed by Chamberlin and Boyce (1974) and Chamberlin et al. (1976). In 1986, the American National Standard Institute (ANSI) and the International Standards Organization (ISO) published the standard SQL-86 or SQL1 (ANSI, 1986). In 1989, an extension of the SQL standard, called SQL-89, was published, and SQL2 or SQL-92 was published in 1992 (ANSI, 1992). SQL2 basically provided new types, constraints (such as checks or unique predicates), it supported subqueries in UPDATE and DELETE operations, and in the FROM clause, operator IN, ANY and ALL, CASE constructor, JOIN, UNION, INTERSECT and EXCEPT operators and the modification of base table through views. In the latest version of SQL standard, SQL 2003, major improvements have been made in a number of key areas. Firstly, it has additional object-relational features, which were first introduced in SQL-1999. Secondly, SQL 2003 standard revolutionizes SQL with comprehensive OLAP features and data-mining applications. Thirdly, SQL 2003 integrates popular XML standards into SQL (SQL/XML). Finally, numerous improvements have been made throughout the SQL 2003 standard to refine existing features.

Complete Chapter List

Search this Book:
Reset
Dedication
José Galindo, Angelica Urrutia , Mario Piattini
Table of Contents
Foreword
Juan M. Medina
Preface
Leoncio Jiménez
Acknowledgments
Chapter 1
Jose Galindo, Angelica Urrutia, Mario Piattini
This book mixes concepts of different areas of knowledge or technologies, such as databases, system architecture design, SQL language, programming... Sample PDF
Introduction to Fuzzy Logic
$37.50
Chapter 2
Jose Galindo, Angelica Urrutia, Mario Piattini
Both the problem of representation and the treatment of imprecise information have been widely discussed. Many references can be found in the... Sample PDF
Fuzzy Database Approaches
$37.50
Chapter 3
Jose Galindo, Angelica Urrutia, Mario Piattini
On occasion, the term imprecision embraces several meanings that we should differentiate. For example, as you saw in Chapter II, the information you... Sample PDF
State of the Art in Fuzzy Database Modeling
$37.50
Chapter 4
Jose Galindo, Angelica Urrutia, Mario Piattini
In this chapter we present the FuzzyEER Model, which is an extension of the EER Model with fuzzy semantics and notations. The Entity-Relationship... Sample PDF
FuzzyEER: Main Characteristics of a Fuzzy Conceptual Modeling Tool
$37.50
Chapter 5
Jose Galindo, Angelica Urrutia, Mario Piattini
The Relational Model was developed by E.F. Codd of IBM and published in 1970. It is currently the most used and has been a milestone in the history... Sample PDF
Representation of Fuzzy Knowledge in Relational Databases: FIRST-2
$37.50
Chapter 6
Jose Galindo, Angelica Urrutia, Mario Piattini
This chapter shows the transformation of the FuzzyEER model to a logical design by using relational databases. The FuzzyEER-to-Relational mapping... Sample PDF
Mapping Fuzzy EER Model Concepts to Relations
$37.50
Chapter 7
Jose Galindo, Angelica Urrutia, Mario Piattini
The SQL language was essentially developed by Chamberlin and Boyce (1974) and Chamberlin et al. (1976). In 1986, the American National Standard... Sample PDF
FSQL: A Fuzzy SQL for Fuzzy Databases
$37.50
Chapter 8
Jose Galindo, Angelica Urrutia, Mario Piattini
The applications of databases are immense. In almost all of them, the advantages of the fuzzy databases can be applied, exploiting their innovative... Sample PDF
Some Applications of Fuzzy Databases With FSQL
$37.50
Chapter 9
Jose Galindo, Angelica Urrutia, Mario Piattini
Fuzzy logic (Chapter I) allows us to bring the operation of information systems closer to the working methods of humans. People frequently deal with... Sample PDF
Brief Summary and Future Trends
$37.50
Summary of FuzzyEER Model
FRDB Architecture: The FSQL Server
Acronyms and the Greek Alphabet
About the Authors