Package org.ujmp.jdbc.matrix
Class JDBCSparseObjectMatrix
- All Implemented Interfaces:
Closeable
,Serializable
,AutoCloseable
,Cloneable
,Comparable<Matrix>
,HasMetaData
,BaseMatrix
,BooleanCalculations
,CanPerformCalculations
,DenseMatrix
,DenseMatrix2D
,DenseMatrixMultiD
,BasicDoubleCalculations
,DoubleCalculations
,BasicEntrywiseDoubleCalculations
,CreatorDoubleCalculations
,EntrywiseDoubleCalculations
,HyperbolicDoubleCalculations
,MiscEntrywiseDoubleCalculations
,RoundingDoubleCalculations
,TrigonometricDoubleCalculations
,DecompositionDoubleCalculations
,DiscretizeCalculations
,GeneralDoubleCalculations
,MiscGeneralDoubleCalculations
,MissingValueDoubleCalculations
,StatisticalDoubleCalculations
,BaseGenericMatrix<Object>
,DenseGenericMatrix<Object>
,DenseGenericMatrix2D<Object>
,DenseGenericMatrixMultiD<Object>
,GenericMatrix<Object>
,GenericMatrix2D<Object>
,GenericMatrixMultiD<Object>
,SparseGenericMatrix<Object>
,SparseGenericMatrix2D<Object>
,SparseGenericMatrixMultiD<Object>
,BaseMatrixProperties
,Clearable
,Conversions
,CoordinateFunctions
,CoreObject
,DistanceMeasures
,Erasable
,ExtendedMatrixProperties
,GettersAndSetters
,HasDescription
,HasGUIObject
,HasId
,HasLabel
,IntCalculations
,Matrix
,Matrix2D
,MatrixMultiD
,BaseObjectMatrix
,ObjectCalculations
,DenseObjectMatrix
,DenseObjectMatrix2D
,DenseObjectMatrixMultiD
,ObjectMatrix
,ObjectMatrix2D
,ObjectMatrixMultiD
,SparseObjectMatrix
,SparseObjectMatrix2D
,SparseObjectMatrixMultiD
,SparseMatrix
,SparseMatrix2D
,SparseMatrixMultiD
,StringCalculations
public class JDBCSparseObjectMatrix
extends AbstractSparseObjectMatrix
implements Closeable, Erasable
- See Also:
-
Field Summary
FieldsModifier and TypeFieldDescriptionprivate final String
private final String[]
private Connection
private PreparedStatement
private PreparedStatement
private PreparedStatement
private String
private PreparedStatement
private static final long
private final String
private PreparedStatement
private final String
private boolean
private final String
Fields inherited from class org.ujmp.core.AbstractMatrix
guiObject, size
Fields inherited from interface org.ujmp.core.BaseMatrix
ALL, COLUMN, LINK, NEW, NONE, ORIG, ROW, X, Y, Z
Fields inherited from interface org.ujmp.core.DenseMatrix
Factory
Fields inherited from interface org.ujmp.core.DenseMatrix2D
Factory
Fields inherited from interface org.ujmp.core.interfaces.HasDescription
DESCRIPTION
Fields inherited from interface org.ujmp.core.annotation.HasMetaData
DIMENSIONMETADATA
Fields inherited from interface org.ujmp.core.Matrix
chol, divideMatrix, divideScalar, eig, Factory, inv, lu, minusMatrix, minusScalar, mtimes, plusMatrix, plusScalar, qr, solve, svd, timesMatrix, timesScalar, transpose
Fields inherited from interface org.ujmp.core.objectmatrix.ObjectMatrix
Factory
Fields inherited from interface org.ujmp.core.SparseMatrix
Factory
Fields inherited from interface org.ujmp.core.SparseMatrix2D
Factory
-
Constructor Summary
ConstructorsConstructorDescriptionJDBCSparseObjectMatrix
(long... size) JDBCSparseObjectMatrix
(long[] size, String url, String username, String password, String tableName, String columnForValue, String... columnsForCoordinates) JDBCSparseObjectMatrix
(long[] size, Connection connection, String tableName, String columnForValue, String... columnsForCoordinates) JDBCSparseObjectMatrix
(Matrix source) -
Method Summary
Modifier and TypeMethodDescriptionIterable<long[]>
Returns an Iterator that only goes over the coordinates in the Matrix that are stored.final void
clear()
void
close()
boolean
containsCoordinates
(long... coordinates) Determines if the given Coordinates are part of the Matrix.private static String[]
createColumnNames
(long... size) private void
private void
deleteObject
(long... coordinates) void
erase()
protected void
finalize()
private PreparedStatement
private PreparedStatement
private PreparedStatement
getObject
(long... coordinates) private PreparedStatement
private PreparedStatement
getUrl()
void
Methods inherited from class org.ujmp.core.objectmatrix.stub.AbstractSparseObjectMatrix
getFactory, isSparse
Methods inherited from class org.ujmp.core.objectmatrix.stub.AbstractObjectMatrix
getAsDouble, getValueType, setAsDouble
Methods inherited from class org.ujmp.core.genericmatrix.stub.AbstractGenericMatrix
getAsObject, getObject, getObject, setAsObject, setObject, setObject
Methods inherited from class org.ujmp.core.AbstractMatrix
abs, addMissing, allCoordinates, allValues, and, and, append, appendHorizontally, appendVertically, atimes, bigDecimalValue, bigIntegerValue, booleanValue, bootstrap, bootstrap, ceil, center, charValue, chebyshevDistanceTo, chol, clone, compareTo, containsBigDecimal, containsBigInteger, containsBoolean, containsByte, containsChar, containsDate, containsDouble, containsFloat, containsInt, containsLong, containsMissingValues, containsNull, containsObject, containsShort, containsString, convert, convertEncoding, corrcoef, cos, cosh, cosineSimilarity, cosineSimilarityTo, countMissing, cov, cumprod, cumsum, dateValue, delete, delete, delete, deleteColumns, deleteColumns, deleteColumnsWithMissingValues, deleteRows, deleteRows, deleteRowsWithMissingValues, det, diag, diff, discretize, discretize, discretizeToBoolean, discretizeToColumns, divide, divide, divide, divide, doubleValue, eig, eigSymm, eq, eq, equals, equalsAnnotation, equalsContent, euklideanDistance, euklideanDistanceTo, exp, exportTo, extractAnnotation, eye, fadeIn, fadeOut, fill, fireValueChanged, fireValueChanged, fireValueChanged, flipdim, floatValue, floor, ge, ge, getAbsoluteValueMean, getAbsoluteValueSum, getAsBigDecimal, getAsBigInteger, getAsBoolean, getAsByte, getAsByteArray, getAsChar, getAsDate, getAsFloat, getAsInt, getAsLong, getAsMatrix, getAsShort, getAsString, getColumnCount, getColumnForLabel, getColumnLabel, getColumnList, getCoordinatesOfMaximum, getCoordinatesOfMinimum, getCoreObjectId, getDescription, getDimensionCount, getDimensionLabel, getDimensionMetaData, getEuklideanValue, getGUIObject, getId, getLabel, getLabelObject, getMaxValue, getMeanValue, getMetaData, getMetaData, getMetaDataDimensionMatrix, getMetaDataDouble, getMetaDataMatrix, getMetaDataString, getMinValue, getPositionForLabel, getPreferredObject, getRMS, getRowCount, getRowForLabel, getRowLabel, getRowList, getSize, getSize, getStdValue, getValueCount, getValueSum, getZCount, ginv, grayScale, gt, gt, importFrom, impute, includeAnnotation, indexOfMax, indexOfMin, intValue, inv, invSPD, invSymm, isColumnVector, isDiagonal, isEmpty, isMultidimensionalMatrix, isReadOnly, isResizable, isRowVector, isScalar, isSingular, isSPD, isSquare, isSymmetric, isTransient, le, le, log, log10, log2, logistic, longValue, lowerCase, lt, lt, lu, manhattenDistance, manhattenDistanceTo, max, mean, min, minkowskiDistance, minkowskiDistanceTo, minus, minus, minus, minus, mtimes, mtimes, mutualInf, nans, ne, ne, nonZeroCoordinates, norm1, norm2, normalize, normF, normInf, not, ones, or, or, pairedTTest, pdet, pinv, pinv, plus, plus, plus, plus, power, power, princomp, prod, qr, rand, randn, rank, removePunctuation, removeWords, replace, replaceMissingBy, replaceRegex, replaceRegex, reshape, round, save, save, select, select, select, selectColumns, selectColumns, selectedCoordinates, selectedCoordinates, selectRows, selectRows, setAsBigDecimal, setAsBigInteger, setAsBoolean, setAsByte, setAsByteArray, setAsChar, setAsDate, setAsFloat, setAsInt, setAsLong, setAsMatrix, setAsShort, setAsString, setColumnLabel, setContent, setDescription, setDimensionLabel, setDimensionMetaData, setId, setLabel, setMetaData, setMetaData, setMetaDataDimensionMatrix, setRowLabel, setSize, share, share, showGUI, shuffle, sign, sin, sinh, solve, solveSPD, solveSymm, sortrows, sqrt, squeeze, standardize, std, stem, stringValue, subMatrix, sum, svd, svd, swap, tan, tanh, tanh, tfIdf, times, times, times, times, toBigDecimalArray, toBigDecimalMatrix, toBigIntegerArray, toBigIntegerMatrix, toBooleanArray, toBooleanMatrix, toByteArray, toByteMatrix, toCharArray, toCharMatrix, toColumnVector, toDateArray, toDoubleArray, toDoubleMatrix, toFloatArray, toFloatMatrix, toHtml, toIntArray, toIntMatrix, toListMatrix, toLongArray, toLongMatrix, toMapMatrix, toObjectArray, toObjectMatrix, toRowVector, toSetMatrix, toShortArray, toShortMatrix, toString, toStringArray, toStringMatrix, trace, translate, transpose, transpose, transpose, tril, triu, unique, uniqueValueCount, upperCase, var, xor, xor, zeros
Methods inherited from class java.lang.Number
byteValue, shortValue
Methods inherited from class java.lang.Object
getClass, hashCode, notify, notifyAll, wait, wait, wait
Methods inherited from interface org.ujmp.core.interfaces.BaseMatrixProperties
allValues, equals, equalsAnnotation, equalsContent, getColumnCount, getColumnList, getDimensionCount, getRowCount, getRowList, getSize, getSize, getValueCount, getValueType, getZCount, isColumnVector, isDiagonal, isEmpty, isMultidimensionalMatrix, isReadOnly, isResizable, isRowVector, isScalar, isSingular, isSquare, isSymmetric, isTransient, setSize, toString
Methods inherited from interface org.ujmp.core.doublematrix.calculation.basic.BasicDoubleCalculations
atimes, divide, divide, divide, divide, minus, minus, minus, minus, mtimes, mtimes, plus, plus, plus, plus, times, times, times, times
Methods inherited from interface org.ujmp.core.doublematrix.calculation.entrywise.basic.BasicEntrywiseDoubleCalculations
abs, exp, log, log10, log2, logistic, power, power, sign, sqrt
Methods inherited from interface org.ujmp.core.booleanmatrix.calculation.BooleanCalculations
and, and, eq, eq, ge, ge, gt, gt, le, le, lt, lt, ne, ne, not, or, or, xor, xor
Methods inherited from interface java.lang.Comparable
compareTo
Methods inherited from interface org.ujmp.core.interfaces.Conversions
toBigDecimalMatrix, toBigIntegerMatrix, toBooleanMatrix, toByteMatrix, toCharMatrix, toDoubleMatrix, toFloatMatrix, toIntMatrix, toListMatrix, toLongMatrix, toMapMatrix, toObjectMatrix, toSetMatrix, toShortMatrix, toStringMatrix
Methods inherited from interface org.ujmp.core.interfaces.CoordinateFunctions
allCoordinates, getCoordinatesOfMaximum, getCoordinatesOfMinimum, nonZeroCoordinates, selectedCoordinates, selectedCoordinates
Methods inherited from interface org.ujmp.core.interfaces.CoreObject
getCoreObjectId
Methods inherited from interface org.ujmp.core.doublematrix.calculation.entrywise.creators.CreatorDoubleCalculations
eye, nans, ones, rand, randn, zeros
Methods inherited from interface org.ujmp.core.doublematrix.calculation.general.decomposition.DecompositionDoubleCalculations
chol, eig, eigSymm, ginv, inv, invSPD, invSymm, lu, pinv, pinv, princomp, qr, solve, solveSPD, solveSymm, svd, svd
Methods inherited from interface org.ujmp.core.doublematrix.calculation.general.discretize.DiscretizeCalculations
discretize, discretize, discretizeToBoolean, discretizeToColumns
Methods inherited from interface org.ujmp.core.interfaces.DistanceMeasures
chebyshevDistanceTo, cosineSimilarity, cosineSimilarityTo, euklideanDistance, euklideanDistanceTo, manhattenDistance, manhattenDistanceTo, minkowskiDistance, minkowskiDistanceTo
Methods inherited from interface org.ujmp.core.interfaces.ExtendedMatrixProperties
bigDecimalValue, bigIntegerValue, booleanValue, byteValue, charValue, containsBigDecimal, containsBigInteger, containsBoolean, containsByte, containsChar, containsDate, containsDouble, containsFloat, containsInt, containsLong, containsMissingValues, containsNull, containsObject, containsShort, containsString, dateValue, det, doubleValue, floatValue, getAbsoluteValueMean, getAbsoluteValueSum, getEuklideanValue, getMaxValue, getMeanValue, getMinValue, getRMS, getStdValue, getValueSum, intValue, isSPD, longValue, norm1, norm2, normF, normInf, pdet, rank, setContent, shortValue, stringValue, trace
Methods inherited from interface org.ujmp.core.interfaces.GettersAndSetters
getAsBigDecimal, getAsBigInteger, getAsBoolean, getAsByte, getAsByteArray, getAsChar, getAsDate, getAsDouble, getAsFloat, getAsInt, getAsLong, getAsMatrix, getAsObject, getAsShort, getAsString, getPreferredObject, setAsBigDecimal, setAsBigInteger, setAsBoolean, setAsByte, setAsByteArray, setAsChar, setAsDate, setAsDouble, setAsFloat, setAsInt, setAsLong, setAsMatrix, setAsObject, setAsShort, setAsString, toBigDecimalArray, toBigIntegerArray, toBooleanArray, toByteArray, toCharArray, toDateArray, toDoubleArray, toFloatArray, toIntArray, toLongArray, toObjectArray, toShortArray, toStringArray
Methods inherited from interface org.ujmp.core.interfaces.HasDescription
getDescription, setDescription
Methods inherited from interface org.ujmp.core.interfaces.HasGUIObject
getGUIObject, showGUI
Methods inherited from interface org.ujmp.core.interfaces.HasLabel
getLabel, getLabelObject, setLabel
Methods inherited from interface org.ujmp.core.annotation.HasMetaData
getColumnForLabel, getColumnLabel, getDimensionLabel, getDimensionMetaData, getMetaData, getMetaData, getMetaDataDimensionMatrix, getMetaDataDouble, getMetaDataMatrix, getMetaDataString, getPositionForLabel, getRowForLabel, getRowLabel, setColumnLabel, setDimensionLabel, setDimensionMetaData, setMetaData, setMetaData, setMetaDataDimensionMatrix, setRowLabel
Methods inherited from interface org.ujmp.core.doublematrix.calculation.entrywise.hyperbolic.HyperbolicDoubleCalculations
cosh, sinh, tanh, tanh
Methods inherited from interface org.ujmp.core.Matrix
clone, exportTo, fireValueChanged, fireValueChanged, fireValueChanged, importFrom, save, save, share, share, toHtml
Methods inherited from interface org.ujmp.core.doublematrix.calculation.entrywise.misc.MiscEntrywiseDoubleCalculations
grayScale
Methods inherited from interface org.ujmp.core.doublematrix.calculation.general.misc.MiscGeneralDoubleCalculations
append, appendHorizontally, appendVertically, center, fadeIn, fadeOut, normalize, replaceMissingBy, standardize
Methods inherited from interface org.ujmp.core.doublematrix.calculation.general.missingvalues.MissingValueDoubleCalculations
addMissing, countMissing, deleteColumnsWithMissingValues, deleteRowsWithMissingValues, impute
Methods inherited from interface org.ujmp.core.objectmatrix.calculation.ObjectCalculations
bootstrap, bootstrap, convert, delete, delete, delete, deleteColumns, deleteColumns, deleteRows, deleteRows, diag, extractAnnotation, fill, flipdim, includeAnnotation, replace, reshape, select, select, select, selectColumns, selectColumns, selectRows, selectRows, shuffle, sortrows, squeeze, subMatrix, swap, toColumnVector, toRowVector, transpose, transpose, transpose, tril, triu, unique, uniqueValueCount
Methods inherited from interface org.ujmp.core.objectmatrix.ObjectMatrix2D
getObject, getObject, setObject, setObject
Methods inherited from interface org.ujmp.core.doublematrix.calculation.entrywise.rounding.RoundingDoubleCalculations
ceil, floor, round
Methods inherited from interface org.ujmp.core.doublematrix.calculation.general.statistical.StatisticalDoubleCalculations
corrcoef, cov, cumprod, cumsum, diff, indexOfMax, indexOfMin, max, mean, min, mutualInf, pairedTTest, prod, std, sum, var
Methods inherited from interface org.ujmp.core.stringmatrix.calculation.StringCalculations
convertEncoding, lowerCase, removePunctuation, removeWords, replaceRegex, replaceRegex, stem, tfIdf, translate, upperCase
Methods inherited from interface org.ujmp.core.doublematrix.calculation.entrywise.trigonometric.TrigonometricDoubleCalculations
cos, sin, tan
-
Field Details
-
serialVersionUID
private static final long serialVersionUID- See Also:
-
useExtendedSQL
private boolean useExtendedSQL -
connection
-
getEntryStatement
-
insertEntryStatement
-
deleteEntryStatement
-
selectAllStatement
-
truncateStatement
-
url
-
username
-
password
-
tableName
-
columnsForCoordinates
-
columnForValue
-
-
Constructor Details
-
JDBCSparseObjectMatrix
public JDBCSparseObjectMatrix(long... size) throws ClassNotFoundException, IOException, SQLException -
JDBCSparseObjectMatrix
public JDBCSparseObjectMatrix(long[] size, String url, String username, String password, String tableName, String columnForValue, String... columnsForCoordinates) throws ClassNotFoundException, SQLException - Throws:
ClassNotFoundException
SQLException
-
JDBCSparseObjectMatrix
public JDBCSparseObjectMatrix(long[] size, Connection connection, String tableName, String columnForValue, String... columnsForCoordinates) throws SQLException - Throws:
SQLException
-
JDBCSparseObjectMatrix
public JDBCSparseObjectMatrix(Matrix source) throws ClassNotFoundException, IOException, SQLException
-
-
Method Details
-
createColumnNames
-
createTableIfNotExists
- Throws:
SQLException
-
getSelectAllStatement
- Throws:
SQLException
-
getGetEntryStatement
- Throws:
SQLException
-
clear
public final void clear() -
getTruncateStatement
- Throws:
SQLException
-
getInsertEntryStatement
- Throws:
SQLException
-
getDeleteEntryStatement
- Throws:
SQLException
-
getObject
- Specified by:
getObject
in interfaceGenericMatrixMultiD<Object>
-
deleteObject
- Throws:
SQLException
-
setObject
- Specified by:
setObject
in interfaceGenericMatrixMultiD<Object>
- Overrides:
setObject
in classAbstractGenericMatrix<Object>
-
close
- Specified by:
close
in interfaceAutoCloseable
- Specified by:
close
in interfaceCloseable
- Throws:
IOException
-
getConnection
- Throws:
SQLException
-
getUrl
-
getUsername
-
getPassword
-
containsCoordinates
public boolean containsCoordinates(long... coordinates) Description copied from interface:CoordinateFunctions
Determines if the given Coordinates are part of the Matrix. If the Matrix is dense, true is returned for all Coordinates smaller than the Matrix's size. For sparse Matrices, this function checks if the coordinates are actually stored in the matrix or not.- Specified by:
containsCoordinates
in interfaceCoordinateFunctions
- Parameters:
coordinates
- The coordinates to check- Returns:
- a boolean stating if the coordinates are part of the Matrix
-
finalize
-
erase
- Specified by:
erase
in interfaceErasable
- Throws:
IOException
-
availableCoordinates
Description copied from interface:CoordinateFunctions
Returns an Iterator that only goes over the coordinates in the Matrix that are stored. For most Matrices, this is the same as allCoordinates(). For sparse Matrices, it iterates only over the entries in it.- Specified by:
availableCoordinates
in interfaceCoordinateFunctions
- Returns:
- Iterable over the saved entries in a Matrix.
-