event thumbnail image
The 7th International Symposium on Intelligent Data Analysis

Relational Algebra for Ranked Tables with Similarities: Properties and Implementation

coauthor: Stanislav Opichal, PIKE ELECTRONIC

Description

The paper presents new developments in an extension of Codd’s relational model of data. The extension consists in equipping domains of attribute values with a similarity relation and adding ranks to rows of a database table. This way, the concept of a table over domains (i.e., relation over a relation scheme) of the classical Codd’s model extends to the concept of a ranked table over domains with similarities. When all similarities are ordinary identity relations and all ranks are set to 1, our extension becomes the ordinary Codd’s model. The main contribution of our paper is twofold. First, we present an outline of a relational algebra for our extension. Second, we deal with implementation issues of our extension. In addition to that, we also comment on related approaches presented in the literature.

You might be experiencing some problems with Your Video player.
Slides
0:00 Relational model of data over domains with similarities
0:29 Outline
1:33 Problem setting pt 1
3:23 Problem setting pt 2
4:20 Problem setting pt 3
5:20 Problem setting pt 4
5:46 Preliminaries from fuzzy logic
6:20 Preliminaries: structures of truth degrees
7:21 Problem setting pt 2 (a)
8:16 Preliminaries: structures of truth degrees (a)
8:34 Our extension of Codd’s model
11:11 Functional dependencies
12:28 Recalling functional dependencies (FDs)
13:04 Fuzzy functional dependencies: syntax
14:32 Semantics of FFDs
14:41 Semantics of FFD: models, entailment
14:50 Relational algebra and calculus
16:18 Example I: select power production of countries with large population
16:29 Implementation of ranked table in ORDBMS pt 1
16:44 Implementation of ranked table in ORDBMS pt 2
16:45 Implementation of ranked table in ORDBMS pt 3
16:46 Implementation of ranked table in ORDBMS pt 4
16:48 Future research

Lecture rating

People found this lecture:
Worth seeing
because it is:
 Valuable and informative
Well presented
Easily understandable
Acceptably recorded
You need to login to cast your vote.

Report a problem or upload files

If you have found a problem with this lecture or would like to send us extra material, articles, exercises, etc., please use our ticket system to describe your request and upload the data.
Enter your e-mail into the 'Cc' field, and we will keep you updated with your request's status.

Link this page

Would you like to put a link to this lecture on your homepage?
Go ahead! Copy the HTML snippet !

Write your own review or comment: