Relational Algebra for Ranked Tables with Similarities: Properties and Implementation
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.
| 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 !




