|
||||||||||
PREV NEXT | FRAMES NO FRAMES |
Packages that use Table | |
---|---|
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.core.dbaccess | Package containing database access code and utility methods. |
de.fesenmeyer.dbnormalizer.core.util | Package containing utility classes for commonly needed operations. |
de.fesenmeyer.dbnormalizer.gui | The top-level package of the GUI, which is implemented in Swing. |
Uses of Table in de.fesenmeyer.dbnormalizer.core |
---|
Fields in de.fesenmeyer.dbnormalizer.core with type parameters of type Table | |
---|---|
private TreeMap<TableContainer,Set<Table>> |
DBNormalizerSession.tables2normalize
A Map containing sets of tables to be normalized. |
Methods in de.fesenmeyer.dbnormalizer.core that return Table | |
---|---|
private Table |
DBNormalizerSession.findTableFromDB(Table table)
Helper Method for retrieving table information from the database. |
Methods in de.fesenmeyer.dbnormalizer.core that return types with arguments of type Table | |
---|---|
Set<Table> |
DBNormalizerSession.getTables2Normalize(TableContainer tableContainer)
Gets all tables which are in the set of tables to be normalized and are contained in the TableContainer specified by argument tableContainer. |
Methods in de.fesenmeyer.dbnormalizer.core with parameters of type Table | |
---|---|
boolean |
DBNormalizerSession.addTable2Normalize(TableContainer tableContainer,
Table table)
Adds a table to the set of tables to be normalized. |
int |
Table.compareTo(Table table)
Compares this table to another table based on the qualified names of the tables. |
private Table |
DBNormalizerSession.findTableFromDB(Table table)
Helper Method for retrieving table information from the database. |
Uses of Table in de.fesenmeyer.dbnormalizer.core.algorithms |
---|
Fields in de.fesenmeyer.dbnormalizer.core.algorithms declared as Table | |
---|---|
private Table |
NormalizationProposal.oldTable
The old table (the table for which the normalization proposal has been generated). |
private Table |
NFDeterminationResult.table
The table. |
private Table |
NFDetermination.table
The table for which the normal form should be determined. |
Fields in de.fesenmeyer.dbnormalizer.core.algorithms with type parameters of type Table | |
---|---|
private SortedSet<Table> |
NormalizationProposal.createdTables
The tables to be created due to the normalization proposal. |
Methods in de.fesenmeyer.dbnormalizer.core.algorithms that return Table | |
---|---|
Table |
NormalizationProposal.getOldTable()
Gets the old table (the table for which the normalization proposal has been generated). |
Table |
NFDeterminationResult.getTable()
Gets the table. |
Methods in de.fesenmeyer.dbnormalizer.core.algorithms that return types with arguments of type Table | |
---|---|
SortedSet<Table> |
NormalizationProposal.getCreatedTables()
Gets the tables to be created due to the normalization proposal. |
Methods in de.fesenmeyer.dbnormalizer.core.algorithms with parameters of type Table | |
---|---|
void |
NormalizationProposal.addCreatedTable(Table table)
Adds a table to the tables to be created due to the normalization proposal. |
private StringBuffer |
NormalizationScriptBuilder.buildCreateTableScript(Table table)
Builds a SQL statement to create the table (without foreign keys) given by the table argument |
private StringBuffer |
NormalizationScriptBuilder.buildCreateView(Collection<Table> createdTables,
Table oldTable)
Builds a CREATE VIEW statement for creating a view
which constructs the old table's data from the new (created) tables. |
private StringBuffer |
NormalizationScriptBuilder.buildDataMigrationScript(Collection<Table> createdTables,
Table oldTable)
Builds a data migration script which copies the data from the old table to the new tables. |
private StringBuffer |
NormalizationScriptBuilder.buildDataMigrationScript(Table createdTable,
Table oldTable)
Builds a data migration script which copies the appropriate data from the old table to one of the new (created) tables. |
private StringBuffer |
NormalizationScriptBuilder.buildDropOldTableScript(Table oldTable)
Builds a statement which drops the old table with the CASCADE CONSTRAINTS option. |
private StringBuffer |
NormalizationScriptBuilder.buildTableColumnDef(Table table,
TableColumn col)
Builds a table column definition for the column given by argument col |
protected NormalizationProposal |
ThreeNFSynthesisAlgorithmKemper.doNormalize(Table oldTable)
The actual normalization algorithm based on [Datenbanksysteme, Kemper/Eickler, 5th Ed., 2004, p. 181]. |
private void |
NFDetermination.initialize(Table table)
Helper method for initialization of the member variables of this class. |
NormalizationProposal |
ThreeNFSynthesisAlgorithmKemper.normalize(Table oldTable)
|
abstract NormalizationProposal |
AbstractNormalizationAlgorithm.normalize(Table oldTable)
Creates a normalization proposal for the Table specified by the argument oldTable. |
static void |
FDAlgorithms.setKeysForTable(Table table,
Table oldTable)
Computes and sets the candidate keys for a table and sets the PK (and where required, DB-PK) which is considered to be the best. |
Method parameters in de.fesenmeyer.dbnormalizer.core.algorithms with type arguments of type Table | |
---|---|
private void |
NormalizationFKsDetermination.addExportedKeysToTables(Collection<FK> fks,
Collection<Table> tables)
Helper method which adds each FK given by the fks argument as exported key to the appropriate table contained in the collection given by the tables argument, if possible. |
private void |
NormalizationFKsDetermination.addImportedKeysToTables(Collection<FK> fks,
Collection<Table> tables)
Helper method which adds each FK given by the fks argument as imported key to the appropriate table contained in the collection given by the tables argument, if possible. |
private StringBuffer |
NormalizationScriptBuilder.buildCreateTablesScript(Collection<Table> createdTables)
Builds SQL statements to create the tables (without foreign keys) given by the createdTables argument. |
private StringBuffer |
NormalizationScriptBuilder.buildCreateView(Collection<Table> createdTables,
Table oldTable)
Builds a CREATE VIEW statement for creating a view
which constructs the old table's data from the new (created) tables. |
private StringBuffer |
NormalizationScriptBuilder.buildDataMigrationScript(Collection<Table> createdTables,
Table oldTable)
Builds a data migration script which copies the data from the old table to the new tables. |
Constructors in de.fesenmeyer.dbnormalizer.core.algorithms with parameters of type Table | |
---|---|
NFDetermination(Table table)
Class Constructor specifying the table for which the normal form should be determined. |
|
NFDeterminationResult(Set<AttributeStringSet> candidateKeys,
Table table,
Set<FD> fds,
NormalForm nf,
Map<NormalForm,Set<FD>> violatingFDs)
Class constructor. |
|
NormalizationProposal(Table oldTable)
Class Constructor specifying the old table (the table for which the normalization proposal has been generated). |
Uses of Table in de.fesenmeyer.dbnormalizer.core.dbaccess |
---|
Methods in de.fesenmeyer.dbnormalizer.core.dbaccess that return Table | |
---|---|
private static Table |
DatabaseMetadataUtil.createTableFromTableInfo(net.sourceforge.squirrel_sql.fw.sql.ITableInfo tableInfo)
Helper method which converts from SQuirreL's ITableInfo object to DBNormalizer's Table object. |
static Table |
DatabaseMetadataUtil.getTableInfo(DBNormalizerSession session,
String catalogName,
String schemaName,
String tableName,
boolean complete)
Gets the table with the specified name, catalog and schema. |
Methods in de.fesenmeyer.dbnormalizer.core.dbaccess that return types with arguments of type Table | |
---|---|
static Collection<Table> |
DatabaseMetadataUtil.getTableInfos(DBNormalizerSession session,
String catalogName,
String schemaName)
Gets all tables from the specified catalog or schema. |
static Collection<Table> |
DatabaseMetadataUtil.getTableInfos(DBNormalizerSession session,
String catalogName,
String schemaName,
boolean complete)
Gets all tables from the specified catalog or schema. |
static Collection<Table> |
DatabaseMetadataUtil.getTableInfos(DBNormalizerSession session,
TableContainer tableContainer,
boolean complete)
Gets all tables from the specified TableContainer. |
Methods in de.fesenmeyer.dbnormalizer.core.dbaccess with parameters of type Table | |
---|---|
private static void |
DatabaseMetadataUtil.retrieveCompleteTableInfo(DBNormalizerSession session,
Table table)
Helper method which fills the given table object with further information (Column, PK and FK information). |
Uses of Table in de.fesenmeyer.dbnormalizer.core.util |
---|
Methods in de.fesenmeyer.dbnormalizer.core.util with parameters of type Table | |
---|---|
static AttributeStringSet |
MiscUtil.parseAttributeStringSet(String attributeSetString,
Table table)
Parses a set of attribute names from a string. |
Uses of Table in de.fesenmeyer.dbnormalizer.gui |
---|
Fields in de.fesenmeyer.dbnormalizer.gui declared as Table | |
---|---|
private Table |
ApplicationFrame.currentTable
|
private Table |
TableMainPanel.table
|
private Table |
TableInformationPanel.table
|
(package private) Table |
FDModificationPanel.FDModTableModel.table
|
private Table |
FDAnalysisPanel.FDAnalysisTableModel.table
|
Methods in de.fesenmeyer.dbnormalizer.gui that return Table | |
---|---|
Table |
TableInformationPanel.getTable()
|
Table |
FDModificationPanel.FDModTableModel.getTable()
|
Table |
FDAnalysisPanel.FDAnalysisTableModel.getTable()
|
Methods in de.fesenmeyer.dbnormalizer.gui with parameters of type Table | |
---|---|
private void |
TableTree.createAttributeNodes(DBNormalizerTreeNode tableNode,
Table table)
|
private void |
TableTree.createNormProposalAttributeNodes(DBNormalizerTreeNode normProposalTableNode,
Table table)
|
private DBNormalizerTreeNode |
TableTree.findTableNode(Table table)
|
void |
NormPropTablePanel.setKeysForTable(Table table)
|
void |
TableTabbedPanel.setTable(Table table)
|
void |
TableMainPanel.setTable(Table table)
|
void |
TableInformationPanel.setTable(Table table)
|
void |
SimpleFDPanel.setTable(Table table)
|
void |
SimpleFDPanel.SimpleFDTableModel.setTable(Table table)
|
void |
NormPropTablePanel.setTable(Table table)
|
void |
FDModificationPanel.setTable(Table table)
|
void |
FDModificationPanel.FDModTableModel.setTable(Table table)
|
void |
FDAnalysisPanel.setTable(Table table)
|
void |
FDAnalysisPanel.FDAnalysisTableModel.setTable(Table table)
|
Constructors in de.fesenmeyer.dbnormalizer.gui with parameters of type Table | |
---|---|
FDAnalysisPanel.FDAnalysisTableModel(Table table)
|
|
FDModificationPanel.FDModTableModel(Table table)
|
|
||||||||||
PREV NEXT | FRAMES NO FRAMES |