dbTalk Databases Forums  

Functional Dependency algorithm

comp.databases.theory comp.databases.theory


Discuss Functional Dependency algorithm in the comp.databases.theory forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jeff
 
Posts: n/a

Default Functional Dependency algorithm - 12-29-2007 , 06:02 PM






I am trying to build a tool that calculates the canonical cover of a
set of functional dependencies, and can infer functional dependencies
from an existing database (perhaps other features too, like attribute
closure). First of all, if someone has pointers to tools that already
do this, I'd like to hear about them.

Second, I have not been able to find a very efficient looking
algorithm to calculate the canonical cover. The algorithms that I find
are something like:

let Fc = F+ /* closure of set of FDs */
while (Fc changed) do
apply union rule
remove extraneous attributes on the left
remove extraneous attributes on the right
end while

The union rule is fairly easy and efficient to implement. Is there a
way to determine the extraneous attributes without computing F'+
(closure of functional dependencies after one potentially extraneous
attribute has been removed) for each attribute in each iteration?

What's the best algorithm to remove the extraneous attributes? What's
the best algorithm to calculate F+?

Regards,
Jeff Davis

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.