Package org.ujmp.jdbc.matrix
Class AbstractDenseJDBCMatrix2D
- java.lang.Object
-
- java.lang.Number
-
- org.ujmp.core.AbstractMatrix
-
- org.ujmp.core.genericmatrix.stub.AbstractGenericMatrix<java.lang.Object>
-
- org.ujmp.core.objectmatrix.stub.AbstractObjectMatrix
-
- org.ujmp.core.objectmatrix.stub.AbstractDenseObjectMatrix
-
- org.ujmp.core.objectmatrix.stub.AbstractDenseObjectMatrix2D
-
- org.ujmp.jdbc.matrix.AbstractDenseJDBCMatrix2D
-
- All Implemented Interfaces:
java.io.Closeable
,java.io.Serializable
,java.lang.AutoCloseable
,java.lang.Cloneable
,java.lang.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<java.lang.Object>
,DenseGenericMatrix<java.lang.Object>
,DenseGenericMatrix2D<java.lang.Object>
,DenseGenericMatrixMultiD<java.lang.Object>
,GenericMatrix<java.lang.Object>
,GenericMatrix2D<java.lang.Object>
,GenericMatrixMultiD<java.lang.Object>
,SparseGenericMatrix<java.lang.Object>
,SparseGenericMatrix2D<java.lang.Object>
,SparseGenericMatrixMultiD<java.lang.Object>
,BaseMatrixProperties
,Clearable
,Conversions
,CoordinateFunctions
,CoreObject
,DistanceMeasures
,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
- Direct Known Subclasses:
DenseDerbyMatrix2D
,DenseHSQLDBMatrix2D
,DenseMySQLMatrix2D
,DensePostgreSQLMatrix2D
public abstract class AbstractDenseJDBCMatrix2D extends AbstractDenseObjectMatrix2D implements java.io.Closeable
- See Also:
- Serialized Form
-
-
Field Summary
Fields Modifier and Type Field Description private int
chunkSize
private java.sql.Connection
connection
private java.util.Map<java.lang.Long,DenseObjectMatrix2D>
dataCache
private java.lang.String
password
private static long
serialVersionUID
private java.lang.String
sqlStatement
private java.lang.String
url
private java.lang.String
username
-
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.objectmatrix.DenseObjectMatrix2D
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
Constructors Constructor Description AbstractDenseJDBCMatrix2D(java.lang.String url, java.lang.String sqlStatement, java.lang.String username, java.lang.String password)
AbstractDenseJDBCMatrix2D(java.sql.Connection connection, java.lang.String sqlStatement)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description void
close()
java.sql.Connection
getConnection()
java.lang.Object
getObject(int row, int column)
java.lang.Object
getObject(long row, long column)
java.lang.String
getPassword()
java.lang.String
getSelectString()
long[]
getSize()
java.lang.String
getSQLStatement()
java.lang.String
getUrl()
java.lang.String
getUsername()
void
setObject(java.lang.Object value, int row, int column)
void
setObject(java.lang.Object value, long row, long column)
-
Methods inherited from class org.ujmp.core.objectmatrix.stub.AbstractDenseObjectMatrix2D
getDimensionCount, getObject, setObject
-
Methods inherited from class org.ujmp.core.objectmatrix.stub.AbstractDenseObjectMatrix
availableCoordinates, clear, containsCoordinates, 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, setAsObject
-
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, getDimensionLabel, getDimensionMetaData, getEuklideanValue, getFactory, getGUIObject, getId, getLabel, getLabelObject, getMaxValue, getMeanValue, getMetaData, getMetaData, getMetaDataDimensionMatrix, getMetaDataDouble, getMetaDataMatrix, getMetaDataString, getMinValue, getPositionForLabel, getPreferredObject, getRMS, getRowCount, getRowForLabel, getRowLabel, getRowList, 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.Object
finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
-
Methods inherited from interface org.ujmp.core.BaseMatrix
getFactory
-
Methods inherited from interface org.ujmp.core.interfaces.BaseMatrixProperties
allValues, equals, equalsAnnotation, equalsContent, getColumnCount, getColumnList, getRowCount, getRowList, getSize, getValueCount, getValueType, getZCount, isColumnVector, isDiagonal, isEmpty, isMultidimensionalMatrix, isReadOnly, isResizable, isRowVector, isScalar, isSingular, isSparse, 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 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, availableCoordinates, containsCoordinates, 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.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 Detail
-
serialVersionUID
private static final long serialVersionUID
- See Also:
- Constant Field Values
-
chunkSize
private int chunkSize
-
dataCache
private java.util.Map<java.lang.Long,DenseObjectMatrix2D> dataCache
-
url
private java.lang.String url
-
username
private java.lang.String username
-
password
private java.lang.String password
-
sqlStatement
private java.lang.String sqlStatement
-
connection
private java.sql.Connection connection
-
-
Constructor Detail
-
AbstractDenseJDBCMatrix2D
public AbstractDenseJDBCMatrix2D(java.lang.String url, java.lang.String sqlStatement, java.lang.String username, java.lang.String password)
-
AbstractDenseJDBCMatrix2D
public AbstractDenseJDBCMatrix2D(java.sql.Connection connection, java.lang.String sqlStatement)
-
-
Method Detail
-
getSQLStatement
public java.lang.String getSQLStatement()
-
getObject
public java.lang.Object getObject(int row, int column)
- Specified by:
getObject
in interfaceGenericMatrix2D<java.lang.Object>
- Specified by:
getObject
in interfaceObjectMatrix2D
- Overrides:
getObject
in classAbstractGenericMatrix<java.lang.Object>
-
getObject
public java.lang.Object getObject(long row, long column)
- Specified by:
getObject
in interfaceGenericMatrix2D<java.lang.Object>
- Specified by:
getObject
in interfaceObjectMatrix2D
- Specified by:
getObject
in classAbstractDenseObjectMatrix2D
-
getSelectString
public final java.lang.String getSelectString()
-
setObject
public void setObject(java.lang.Object value, long row, long column)
- Specified by:
setObject
in interfaceGenericMatrix2D<java.lang.Object>
- Specified by:
setObject
in interfaceObjectMatrix2D
- Specified by:
setObject
in classAbstractDenseObjectMatrix2D
-
setObject
public void setObject(java.lang.Object value, int row, int column)
- Specified by:
setObject
in interfaceGenericMatrix2D<java.lang.Object>
- Specified by:
setObject
in interfaceObjectMatrix2D
- Overrides:
setObject
in classAbstractGenericMatrix<java.lang.Object>
-
getSize
public long[] getSize()
- Specified by:
getSize
in interfaceBaseMatrixProperties
- Overrides:
getSize
in classAbstractMatrix
-
close
public void close() throws java.io.IOException
- Specified by:
close
in interfacejava.lang.AutoCloseable
- Specified by:
close
in interfacejava.io.Closeable
- Throws:
java.io.IOException
-
getConnection
public java.sql.Connection getConnection() throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
getUrl
public java.lang.String getUrl()
-
getUsername
public java.lang.String getUsername()
-
getPassword
public java.lang.String getPassword()
-
-