Uses of Class
de.fesenmeyer.dbnormalizer.core.Table

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)