|
||||||||||
PREV NEXT | FRAMES NO FRAMES |
Packages that use FD | |
---|---|
de.fesenmeyer.dbnormalizer.core | The top-level package of the core logic, which contains the fundamental classes of DBNormalizer. |
de.fesenmeyer.dbnormalizer.core.algorithms | Package which provides the several algorithms implemented by DBNormalizer. |
de.fesenmeyer.dbnormalizer.gui | The top-level package of the GUI, which is implemented in Swing. |
Uses of FD in de.fesenmeyer.dbnormalizer.core |
---|
Fields in de.fesenmeyer.dbnormalizer.core with type parameters of type FD | |
---|---|
private Set<FD> |
Table.FDMinCover
A minimal cover of the functional dependencies (FDs) contained in Table.FDs . |
private Set<FD> |
Table.FDs
The set of functional dependencies (FDs) for this table, just as it has been specified by the user or imported from a file. |
Methods in de.fesenmeyer.dbnormalizer.core that return FD | |
---|---|
FD |
FD.copy()
Makes a deep copy of this FD. |
Methods in de.fesenmeyer.dbnormalizer.core that return types with arguments of type FD | |
---|---|
Set<FD> |
Table.getFDMinCover()
Gets the minimal cover of FDs for this table. |
Set<FD> |
Table.getFDs()
Gets the FDs for this table. |
Methods in de.fesenmeyer.dbnormalizer.core with parameters of type FD | |
---|---|
int |
FDAlphabeticalComparator.compare(FD o1,
FD o2)
|
int |
FD.compareTo(FD fd)
Compares this FD to another FD, based on the toString() method. |
Method parameters in de.fesenmeyer.dbnormalizer.core with type arguments of type FD | |
---|---|
void |
Table.setFDMinCover(Set<FD> minCover)
Sets the minimal cover of FDs for this table. |
void |
Table.setFDs(Set<FD> fds)
Sets the FDs for this table. |
Uses of FD in de.fesenmeyer.dbnormalizer.core.algorithms |
---|
Fields in de.fesenmeyer.dbnormalizer.core.algorithms with type parameters of type FD | |
---|---|
private Set<FD> |
NFDeterminationResult.fds
The FDs used for normal form determination. |
private Set<FD> |
NFDetermination.fds
The FDs of the table. |
private Map<NormalForm,Set<FD>> |
NFDeterminationResult.violatingFDs
The determined violating FDs, grouped by normal form. |
private Map<NormalForm,Set<FD>> |
NFDetermination.violatingFDs
Map, which holds for each key (normal form) the FDs which violate this normal form |
Methods in de.fesenmeyer.dbnormalizer.core.algorithms that return types with arguments of type FD | |
---|---|
static SortedSet<FD> |
FDAlgorithms.calculateMinCover(Set<FD> fds)
Calculates the minimal cover of the set of FDs specified by the fds argument. |
private static ArrayList<FD> |
FDAlgorithms.calculateReducedCover(Set<FD> fds)
Calculates a reduced cover for the set of FDs specified by the fds argument. |
Set<FD> |
NFDeterminationResult.getFds()
Gets the FDs used for normal form determination. |
Map<NormalForm,Set<FD>> |
NFDeterminationResult.getViolatingFDs()
Gets the determined violating FDs, grouped by normal form. |
static SortedSet<FD> |
FDAlgorithms.mergeFDs(Collection<FD> fds)
Merges FDs using the union inference rule, e.g.: {a -> b, a -> c} => {a -> bc} One can also say that the FDs are grouped by equal LHS. |
static SortedSet<FD> |
FDAlgorithms.splitFDs(Collection<FD> fds)
Splits the FDs specified by argument fds by using the augmentation inference rule, e.g.: {a -> bc} => {a -> b, a -> c} |
Methods in de.fesenmeyer.dbnormalizer.core.algorithms with parameters of type FD | |
---|---|
private void |
NFDetermination.addToViolatingFDs(NormalForm nf,
FD fd)
Helper method which adds a FD to the map of violating FDs. |
FDCheckState |
FDChecker.checkFD(String qualifiedTableName,
FD fd)
Checks if the FD specified by argument fd is satisfied in the table specified by argument qualifiedTableName. |
private String |
FDChecker.getCheckFDStatement(String qualifiedTableName,
FD fd)
Creates an SQL Statement, which can be used to check if the FD specified by the fd argument is satisfied by the Table specified by the qualifiedTableName argument. |
DataSet |
FDChecker.getNotSatisfiedTupels(String qualifiedTableName,
FD fd)
Returns the tuples returned by the SQL query used for checking FDs. |
static boolean |
FDAlgorithms.isMember(FD fd,
Set<FD> fds)
The Membership algorithm checks if the FD specified by argument fd is member of the set of FDs specified by argument fds, that means if it can be derived from this set. |
static boolean |
FDAlgorithms.isRedundant(FD fd,
Set<FD> fds)
This algorithm checks if an FD is redundant by using the Membership algorithm FDAlgorithms.isMember(FD, Set) . |
private boolean |
NFDetermination.violates2NF(FD fd)
Checks if a FD violates 2NF. |
private boolean |
NFDetermination.violates3NF(FD fd)
Checks if a FD violates 3NF. |
private boolean |
NFDetermination.violatesBCNF(FD fd)
Checks if a FD violates BCNF. |
Method parameters in de.fesenmeyer.dbnormalizer.core.algorithms with type arguments of type FD | |||
---|---|---|---|
static AttributeStringSet |
FDAlgorithms.calculateAttributeClosure(Collection<FD> fds,
AttributeStringSet attributes)
Calculates the Attribute-Closure for the set of attributes given by argument attributes regarding the set of FDs given by argument fds. |
||
static SortedSet<FD> |
FDAlgorithms.calculateMinCover(Set<FD> fds)
Calculates the minimal cover of the set of FDs specified by the fds argument. |
||
private static ArrayList<FD> |
FDAlgorithms.calculateReducedCover(Set<FD> fds)
Calculates a reduced cover for the set of FDs specified by the fds argument. |
||
static SortedSet<AttributeStringSet> |
FDAlgorithms.determineCandidateKeys(AttributeStringSet allAttributes,
Set<FD> minCover)
Algorithm for determination of candidate keys for a table. |
||
static SortedSet<AttributeStringSet> |
FDAlgorithms.determineCandidateKeysGeneral(AttributeStringSet allAttributes,
Set<FD> minCover)
Algorithm for determination of candidate keys from |
static boolean |
FDAlgorithms.isMember(FD fd,
Set<FD> fds)
The Membership algorithm checks if the FD specified by argument fd is member of the set of FDs specified by argument fds, that means if it can be derived from this set. |
static boolean |
FDAlgorithms.isRedundant(FD fd,
Set<FD> fds)
This algorithm checks if an FD is redundant by using the Membership algorithm FDAlgorithms.isMember(FD, Set) . |
||
static SortedSet<FD> |
FDAlgorithms.mergeFDs(Collection<FD> fds)
Merges FDs using the union inference rule, e.g.: {a -> b, a -> c} => {a -> bc} One can also say that the FDs are grouped by equal LHS. |
||
static SortedSet<FD> |
FDAlgorithms.splitFDs(Collection<FD> fds)
Splits the FDs specified by argument fds by using the augmentation inference rule, e.g.: {a -> bc} => {a -> b, a -> c} |
Constructor parameters in de.fesenmeyer.dbnormalizer.core.algorithms with type arguments of type FD | |
---|---|
NFDeterminationResult(Set<AttributeStringSet> candidateKeys,
Table table,
Set<FD> fds,
NormalForm nf,
Map<NormalForm,Set<FD>> violatingFDs)
Class constructor. |
|
NFDeterminationResult(Set<AttributeStringSet> candidateKeys,
Table table,
Set<FD> fds,
NormalForm nf,
Map<NormalForm,Set<FD>> violatingFDs)
Class constructor. |
Uses of FD in de.fesenmeyer.dbnormalizer.gui |
---|
Fields in de.fesenmeyer.dbnormalizer.gui with type parameters of type FD | |
---|---|
private List<FD> |
SimpleFDPanel.SimpleFDTableModel.fdList
|
(package private) List<FD> |
FDModificationPanel.FDModTableModel.fdList
|
private List<FD> |
FDAnalysisPanel.FDAnalysisTableModel.fdList
|
private Map<FD,NormalForm> |
SimpleFDPanel.SimpleFDTableModel.violatingFDs
|
private Map<FD,NormalForm> |
FDAnalysisPanel.FDAnalysisTableModel.violatingFDs
|
Methods in de.fesenmeyer.dbnormalizer.gui that return types with arguments of type FD | |
---|---|
List<FD> |
FDModificationPanel.FDModTableModel.getFdList()
|
List<FD> |
FDAnalysisPanel.FDAnalysisTableModel.getFdList()
|
Constructors in de.fesenmeyer.dbnormalizer.gui with parameters of type FD | |
---|---|
FDCheckInfoFrame(FD fd,
DataSet dataSet)
|
|
||||||||||
PREV NEXT | FRAMES NO FRAMES |