TAILIEUCHUNG - Fuzzy improvement of the SQL

Structured Query Language (SQL) is used to obtain data from relational databases. Fuzzy improvement of SQL queries has advantages in cases when the user cannot unambiguously define selection criteria or when the user wants to examine data that almost meet the given criteria. In this paper we examine a realisation of the fuzzy querying concept. For this purposes the fuzzy generalized logical condition for the WHERE part of the SQL is created. | Yugoslav Journal of Operations Research 21 (2011), Number 2, 239-251 DOI: FUZZY IMPROVEMENT OF THE SQL Miroslav HUDEC Institute of Informatics and Statistics, Bratislava, Slovakia hudec@ Received: December 2007 / Accepted: July 2011 Abstract: Structured Query Language (SQL) is used to obtain data from relational databases. Fuzzy improvement of SQL queries has advantages in cases when the user cannot unambiguously define selection criteria or when the user wants to examine data that almost meet the given criteria. In this paper we examine a realisation of the fuzzy querying concept. For this purposes the fuzzy generalized logical condition for the WHERE part of the SQL is created. It allows users to create queries by linguistic terms. The proposed model is an extension of the SQL so that no modification inside databases has to be undertaken. Keywords: SQL, fuzzy query, generalized logical condition, database. MSC: 94D05, 68P99, 90B99. 1. INTRODUCTION SQL is a standard query language for relational databases. The SQL was initially presented by Chamberlin and Boyce [3]. Since then, it has been used for data selection in many relational databases and information systems. SQL is one of the key factors for accepting relational databases and for their use in storing and retrieving vast amount of data. Its advantages among others are: optimised work with relational database management systems and understandable interpretation for users. The SQL uses two-valued logic (crisp logic) in querying process. It means that a small error in data values or in cases when user cannot unambiguously define the criteria by crisp values, may involve some inadequately selected data. This limitation of the SQL can be avoided by fuzzy logic. The fuzzy set theory was initiated by Zadeh [12]. Since then, many researches and applications have been published. Fuzzy queries have appeared in the last 30 years to cope with the necessity to 240 M. Hudec / Fuzzy .

• Kỹ thuật lập trình
• Structured Query Language
• Fuzzy query
• Generalized logical condition
• Fuzzy improvement
• Relational databases
• SQL Structured Query Language
• Bài giảng SQL Structured Query Language
• Ngôn ngữ thao tác dữ liệu
• Câu truy vấn đơn giản
• Truy vấn lồng
• Hàm thống kê
• Lecture Database Systems
• Database systems
• Data definition language
• Data manipulation language
• Data control language
• Lecture Database System
• Database System
• SQL (Structured Query Language)
• Object oriented data management
• XML Query Language
• Relational database schema
• SQL development
• programming language
• database management system
• hệ quản trị cơ sở dữ liệu
• sự cố cơ sở dữ liệu
• SQL
• Bài giảng Cơ sở dữ liệu
• Cơ sở dữ liệu
• Môi trường SQL Server
• Định nghĩa khung nhìn
• Lecture Web technologies and e services
• Bài giảng Công nghệ web và dịch vụ điện tử
• Structured query language (SQL)
• SQL database tables
• SQL data languages
• Data manipulation language (DML)
• ngôn ngữ cơ sở dữ liệu
• data management
• data programming
• computer skills
• Oracle
• SQL Tutorial
• Database
• Oracle Data Dictionary
• Application Programming
• information technology
• curriculum
• database administrators
• Oracle Database
• Relational Features
• Object Programming
• Oracle XML
• Mastering CSharp
• Connecting to a Database
• ADONET Classes Database Programming
• lập trình CSDL
• ngôn ngữ SQL
• quản trị dữ liệu
• dữ liệu máy tính
• xuất nhập dữ liệu
• truy vấn dữ liệu
• Lý thuyết cơ sở dữ liệu
• Bài giảng Lý thuyết Cơ sở dữ liệu
• Ngôn ngữ truy vấn SQL
• Truy vấn con
• The COMPANY Database
• SQL developments
• Overview SQL
• Defining the COMPANY DB schema
• Cập nhật dữ liệu
• Lệnh xóa bảng
• Các loại mệnh đề
• Cập nhập dữ liệu
• Mệnh đề Group by
• Mệnh đề Order By
• Database processing
• The relational model
• Database design using normalization
• The entity relationship model
• Transforming data models
• Lecture Database management systems
• Bài giảng Hệ quản trị cơ sở dữ liệu
• Database management systems
• Vertical partitioning
• Cross system communication
• Định nghĩa dữ liệu
• Entity relationship model
• Relational model
• Database design theory