| <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> |
| <!-- NewPage --> |
| <html lang="en"> |
| <head> |
| <!-- Generated by javadoc (1.8.0_121) on Fri Apr 14 22:12:45 PDT 2017 --> |
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> |
| <title>MySQLJDBCDataModel (Mahout Integration 0.13.0 API)</title> |
| <meta name="date" content="2017-04-14"> |
| <link rel="stylesheet" type="text/css" href="../../../../../../../../stylesheet.css" title="Style"> |
| <script type="text/javascript" src="../../../../../../../../script.js"></script> |
| </head> |
| <body> |
| <script type="text/javascript"><!-- |
| try { |
| if (location.href.indexOf('is-external=true') == -1) { |
| parent.document.title="MySQLJDBCDataModel (Mahout Integration 0.13.0 API)"; |
| } |
| } |
| catch(err) { |
| } |
| //--> |
| var methods = {"i0":10}; |
| var tabs = {65535:["t0","All Methods"],2:["t2","Instance Methods"],8:["t4","Concrete Methods"]}; |
| var altColor = "altColor"; |
| var rowColor = "rowColor"; |
| var tableTab = "tableTab"; |
| var activeTableTab = "activeTableTab"; |
| </script> |
| <noscript> |
| <div>JavaScript is disabled on your browser.</div> |
| </noscript> |
| <!-- ========= START OF TOP NAVBAR ======= --> |
| <div class="topNav"><a name="navbar.top"> |
| <!-- --> |
| </a> |
| <div class="skipNav"><a href="#skip.navbar.top" title="Skip navigation links">Skip navigation links</a></div> |
| <a name="navbar.top.firstrow"> |
| <!-- --> |
| </a> |
| <ul class="navList" title="Navigation"> |
| <li><a href="../../../../../../../../overview-summary.html">Overview</a></li> |
| <li><a href="package-summary.html">Package</a></li> |
| <li class="navBarCell1Rev">Class</li> |
| <li><a href="class-use/MySQLJDBCDataModel.html">Use</a></li> |
| <li><a href="package-tree.html">Tree</a></li> |
| <li><a href="../../../../../../../../deprecated-list.html">Deprecated</a></li> |
| <li><a href="../../../../../../../../index-all.html">Index</a></li> |
| <li><a href="../../../../../../../../help-doc.html">Help</a></li> |
| </ul> |
| </div> |
| <div class="subNav"> |
| <ul class="navList"> |
| <li><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/MySQLBooleanPrefJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc"><span class="typeNameLink">Prev Class</span></a></li> |
| <li><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/PostgreSQLBooleanPrefJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc"><span class="typeNameLink">Next Class</span></a></li> |
| </ul> |
| <ul class="navList"> |
| <li><a href="../../../../../../../../index.html?org/apache/mahout/cf/taste/impl/model/jdbc/MySQLJDBCDataModel.html" target="_top">Frames</a></li> |
| <li><a href="MySQLJDBCDataModel.html" target="_top">No Frames</a></li> |
| </ul> |
| <ul class="navList" id="allclasses_navbar_top"> |
| <li><a href="../../../../../../../../allclasses-noframe.html">All Classes</a></li> |
| </ul> |
| <div> |
| <script type="text/javascript"><!-- |
| allClassesLink = document.getElementById("allclasses_navbar_top"); |
| if(window==top) { |
| allClassesLink.style.display = "block"; |
| } |
| else { |
| allClassesLink.style.display = "none"; |
| } |
| //--> |
| </script> |
| </div> |
| <div> |
| <ul class="subNavList"> |
| <li>Summary: </li> |
| <li>Nested | </li> |
| <li><a href="#fields.inherited.from.class.org.apache.mahout.cf.taste.impl.model.jdbc.AbstractJDBCDataModel">Field</a> | </li> |
| <li><a href="#constructor.summary">Constr</a> | </li> |
| <li><a href="#method.summary">Method</a></li> |
| </ul> |
| <ul class="subNavList"> |
| <li>Detail: </li> |
| <li>Field | </li> |
| <li><a href="#constructor.detail">Constr</a> | </li> |
| <li><a href="#method.detail">Method</a></li> |
| </ul> |
| </div> |
| <a name="skip.navbar.top"> |
| <!-- --> |
| </a></div> |
| <!-- ========= END OF TOP NAVBAR ========= --> |
| <!-- ======== START OF CLASS DATA ======== --> |
| <div class="header"> |
| <div class="subTitle">org.apache.mahout.cf.taste.impl.model.jdbc</div> |
| <h2 title="Class MySQLJDBCDataModel" class="title">Class MySQLJDBCDataModel</h2> |
| </div> |
| <div class="contentContainer"> |
| <ul class="inheritance"> |
| <li><a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">java.lang.Object</a></li> |
| <li> |
| <ul class="inheritance"> |
| <li><a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc">org.apache.mahout.cf.taste.impl.common.jdbc.AbstractJDBCComponent</a></li> |
| <li> |
| <ul class="inheritance"> |
| <li><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc">org.apache.mahout.cf.taste.impl.model.jdbc.AbstractJDBCDataModel</a></li> |
| <li> |
| <ul class="inheritance"> |
| <li>org.apache.mahout.cf.taste.impl.model.jdbc.MySQLJDBCDataModel</li> |
| </ul> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| <div class="description"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <dl> |
| <dt>All Implemented Interfaces:</dt> |
| <dd><a href="http://docs.oracle.com/javase/7/docs/api/java/io/Serializable.html?is-external=true" title="class or interface in java.io">Serializable</a>, <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/common/Refreshable.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.common">Refreshable</a>, <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/model/DataModel.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.model">DataModel</a>, <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/model/JDBCDataModel.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.model">JDBCDataModel</a></dd> |
| </dl> |
| <hr> |
| <br> |
| <pre>public class <span class="typeNameLabel">MySQLJDBCDataModel</span> |
| extends <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc">AbstractJDBCDataModel</a></pre> |
| <div class="block"><p> |
| A <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/model/JDBCDataModel.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.model"><code>JDBCDataModel</code></a> backed by a MySQL database and |
| accessed via JDBC. It may work with other JDBC databases. By default, this class |
| assumes that there is a <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> available under the JNDI name |
| "jdbc/taste", which gives access to a database with a "taste_preferences" table with the following schema: |
| </p> |
| |
| <table> |
| <tr> |
| <th>user_id</th> |
| <th>item_id</th> |
| <th>preference</th> |
| </tr> |
| <tr> |
| <td>987</td> |
| <td>123</td> |
| <td>0.9</td> |
| </tr> |
| <tr> |
| <td>987</td> |
| <td>456</td> |
| <td>0.1</td> |
| </tr> |
| <tr> |
| <td>654</td> |
| <td>123</td> |
| <td>0.2</td> |
| </tr> |
| <tr> |
| <td>654</td> |
| <td>789</td> |
| <td>0.3</td> |
| </tr> |
| </table> |
| |
| <p> |
| <code>preference</code> must have a type compatible with the Java <code>float</code> type. |
| <code>user_id</code> and <code>item_id</code> should be compatible with long type (BIGINT). For example, |
| the following command sets up a suitable table in MySQL, complete with primary key and indexes: |
| </p> |
| |
| <p> |
| |
| <pre> |
| CREATE TABLE taste_preferences ( |
| user_id BIGINT NOT NULL, |
| item_id BIGINT NOT NULL, |
| preference FLOAT NOT NULL, |
| PRIMARY KEY (user_id, item_id), |
| INDEX (user_id), |
| INDEX (item_id) |
| ) |
| </pre> |
| |
| </p> |
| |
| <p>The table may optionally have a <code>timestamp</code> column whose type is compatible with Java |
| <code>long</code>.</p> |
| |
| <h3>Performance Notes</h3> |
| |
| <p> |
| See the notes in <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc"><code>AbstractJDBCDataModel</code></a> regarding using connection pooling. It's pretty vital to |
| performance. |
| </p> |
| |
| <p> |
| Some experimentation suggests that MySQL's InnoDB engine is faster than MyISAM for these kinds of |
| applications. While MyISAM is the default and, I believe, generally considered the lighter-weight and |
| faster of the two engines, my guess is the row-level locking of InnoDB helps here. Your mileage may vary. |
| </p> |
| |
| <p> |
| Here are some key settings that can be tuned for MySQL, and suggested size for a data set of around 1 |
| million elements: |
| </p> |
| |
| <ul> |
| <li>innodb_buffer_pool_size=64M</li> |
| <li>myisam_sort_buffer_size=64M</li> |
| <li>query_cache_limit=64M</li> |
| <li>query_cache_min_res_unit=512K</li> |
| <li>query_cache_type=1</li> |
| <li>query_cache_size=64M</li> |
| </ul> |
| |
| <p> |
| Also consider setting some parameters on the MySQL Connector/J driver: |
| </p> |
| |
| <pre> |
| cachePreparedStatements = true |
| cachePrepStmts = true |
| cacheResultSetMetadata = true |
| alwaysSendSetIsolation = false |
| elideSetAutoCommits = true |
| </pre> |
| |
| <p> |
| Thanks to Amila Jayasooriya for contributing MySQL notes above as part of Google Summer of Code 2007. |
| </p></div> |
| <dl> |
| <dt><span class="seeLabel">See Also:</span></dt> |
| <dd><a href="../../../../../../../../serialized-form.html#org.apache.mahout.cf.taste.impl.model.jdbc.MySQLJDBCDataModel">Serialized Form</a></dd> |
| </dl> |
| </li> |
| </ul> |
| </div> |
| <div class="summary"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <!-- =========== FIELD SUMMARY =========== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="field.summary"> |
| <!-- --> |
| </a> |
| <h3>Field Summary</h3> |
| <ul class="blockList"> |
| <li class="blockList"><a name="fields.inherited.from.class.org.apache.mahout.cf.taste.impl.model.jdbc.AbstractJDBCDataModel"> |
| <!-- --> |
| </a> |
| <h3>Fields inherited from class org.apache.mahout.cf.taste.impl.model.jdbc.<a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc">AbstractJDBCDataModel</a></h3> |
| <code><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#DEFAULT_ITEM_ID_COLUMN">DEFAULT_ITEM_ID_COLUMN</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#DEFAULT_PREFERENCE_COLUMN">DEFAULT_PREFERENCE_COLUMN</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#DEFAULT_PREFERENCE_TABLE">DEFAULT_PREFERENCE_TABLE</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#DEFAULT_PREFERENCE_TIME_COLUMN">DEFAULT_PREFERENCE_TIME_COLUMN</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#DEFAULT_USER_ID_COLUMN">DEFAULT_USER_ID_COLUMN</a></code></li> |
| </ul> |
| <ul class="blockList"> |
| <li class="blockList"><a name="fields.inherited.from.class.org.apache.mahout.cf.taste.impl.common.jdbc.AbstractJDBCComponent"> |
| <!-- --> |
| </a> |
| <h3>Fields inherited from class org.apache.mahout.cf.taste.impl.common.jdbc.<a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc">AbstractJDBCComponent</a></h3> |
| <code><a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true#DEFAULT_DATASOURCE_NAME" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc">DEFAULT_DATASOURCE_NAME</a></code></li> |
| </ul> |
| </li> |
| </ul> |
| <!-- ======== CONSTRUCTOR SUMMARY ======== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="constructor.summary"> |
| <!-- --> |
| </a> |
| <h3>Constructor Summary</h3> |
| <table class="memberSummary" border="0" cellpadding="3" cellspacing="0" summary="Constructor Summary table, listing constructors, and an explanation"> |
| <caption><span>Constructors</span><span class="tabEnd"> </span></caption> |
| <tr> |
| <th class="colOne" scope="col">Constructor and Description</th> |
| </tr> |
| <tr class="altColor"> |
| <td class="colOne"><code><span class="memberNameLink"><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/MySQLJDBCDataModel.html#MySQLJDBCDataModel--">MySQLJDBCDataModel</a></span>()</code> |
| <div class="block"> |
| Creates a <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/MySQLJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc"><code>MySQLJDBCDataModel</code></a> using the default <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> (named |
| <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true#DEFAULT_DATASOURCE_NAME" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc"><code>AbstractJDBCComponent.DEFAULT_DATASOURCE_NAME</code></a> and default table/column names.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colOne"><code><span class="memberNameLink"><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/MySQLJDBCDataModel.html#MySQLJDBCDataModel-javax.sql.DataSource-">MySQLJDBCDataModel</a></span>(<a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql">DataSource</a> dataSource)</code> |
| <div class="block"> |
| Creates a <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/MySQLJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc"><code>MySQLJDBCDataModel</code></a> using the given <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> and default table/column names.</div> |
| </td> |
| </tr> |
| <tr class="altColor"> |
| <td class="colOne"><code><span class="memberNameLink"><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/MySQLJDBCDataModel.html#MySQLJDBCDataModel-javax.sql.DataSource-java.lang.String-java.lang.String-java.lang.String-java.lang.String-java.lang.String-">MySQLJDBCDataModel</a></span>(<a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql">DataSource</a> dataSource, |
| <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> preferenceTable, |
| <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> userIDColumn, |
| <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> itemIDColumn, |
| <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> preferenceColumn, |
| <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> timestampColumn)</code> |
| <div class="block"> |
| Creates a <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/MySQLJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc"><code>MySQLJDBCDataModel</code></a> using the given <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> and default table/column names.</div> |
| </td> |
| </tr> |
| <tr class="rowColor"> |
| <td class="colOne"><code><span class="memberNameLink"><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/MySQLJDBCDataModel.html#MySQLJDBCDataModel-java.lang.String-">MySQLJDBCDataModel</a></span>(<a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> dataSourceName)</code> |
| <div class="block"> |
| Creates a <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/MySQLJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc"><code>MySQLJDBCDataModel</code></a> using the default <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> found under the given name, and |
| using default table/column names.</div> |
| </td> |
| </tr> |
| </table> |
| </li> |
| </ul> |
| <!-- ========== METHOD SUMMARY =========== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="method.summary"> |
| <!-- --> |
| </a> |
| <h3>Method Summary</h3> |
| <table class="memberSummary" border="0" cellpadding="3" cellspacing="0" summary="Method Summary table, listing methods, and an explanation"> |
| <caption><span id="t0" class="activeTableTab"><span>All Methods</span><span class="tabEnd"> </span></span><span id="t2" class="tableTab"><span><a href="javascript:show(2);">Instance Methods</a></span><span class="tabEnd"> </span></span><span id="t4" class="tableTab"><span><a href="javascript:show(8);">Concrete Methods</a></span><span class="tabEnd"> </span></span></caption> |
| <tr> |
| <th class="colFirst" scope="col">Modifier and Type</th> |
| <th class="colLast" scope="col">Method and Description</th> |
| </tr> |
| <tr id="i0" class="altColor"> |
| <td class="colFirst"><code>protected int</code></td> |
| <td class="colLast"><code><span class="memberNameLink"><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/MySQLJDBCDataModel.html#getFetchSize--">getFetchSize</a></span>()</code> </td> |
| </tr> |
| </table> |
| <ul class="blockList"> |
| <li class="blockList"><a name="methods.inherited.from.class.org.apache.mahout.cf.taste.impl.model.jdbc.AbstractJDBCDataModel"> |
| <!-- --> |
| </a> |
| <h3>Methods inherited from class org.apache.mahout.cf.taste.impl.model.jdbc.<a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc">AbstractJDBCDataModel</a></h3> |
| <code><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#buildPreference-java.sql.ResultSet-">buildPreference</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#doGetPreferencesForItem-long-">doGetPreferencesForItem</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#exportWithIDsOnly--">exportWithIDsOnly</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#exportWithPrefs--">exportWithPrefs</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getDataSource--">getDataSource</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getItemIDColumn--">getItemIDColumn</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getItemIDs--">getItemIDs</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getItemIDsFromUser-long-">getItemIDsFromUser</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getLongColumn-java.sql.ResultSet-int-">getLongColumn</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getMaxPreference--">getMaxPreference</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getMinPreference--">getMinPreference</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getNumItems--">getNumItems</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getNumUsers--">getNumUsers</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getNumUsersWithPreferenceFor-long-">getNumUsersWithPreferenceFor</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getNumUsersWithPreferenceFor-long-long-">getNumUsersWithPreferenceFor</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getPreferenceColumn--">getPreferenceColumn</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getPreferencesForItem-long-">getPreferencesForItem</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getPreferencesFromUser-long-">getPreferencesFromUser</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getPreferenceTable--">getPreferenceTable</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getPreferenceTime-long-long-">getPreferenceTime</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getPreferenceValue-long-long-">getPreferenceValue</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getUserIDColumn--">getUserIDColumn</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#getUserIDs--">getUserIDs</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#hasPreferenceValues--">hasPreferenceValues</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#refresh-java.util.Collection-">refresh</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#removePreference-long-long-">removePreference</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#setLongParameter-java.sql.PreparedStatement-int-long-">setLongParameter</a>, <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/AbstractJDBCDataModel.html#setPreference-long-long-float-">setPreference</a></code></li> |
| </ul> |
| <ul class="blockList"> |
| <li class="blockList"><a name="methods.inherited.from.class.org.apache.mahout.cf.taste.impl.common.jdbc.AbstractJDBCComponent"> |
| <!-- --> |
| </a> |
| <h3>Methods inherited from class org.apache.mahout.cf.taste.impl.common.jdbc.<a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc">AbstractJDBCComponent</a></h3> |
| <code><a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true#checkNotNullAndLog-java.lang.String-java.lang.Object-" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc">checkNotNullAndLog</a>, <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true#checkNotNullAndLog-java.lang.String-java.lang.Object:A-" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc">checkNotNullAndLog</a>, <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true#lookupDataSource-java.lang.String-" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc">lookupDataSource</a></code></li> |
| </ul> |
| <ul class="blockList"> |
| <li class="blockList"><a name="methods.inherited.from.class.java.lang.Object"> |
| <!-- --> |
| </a> |
| <h3>Methods inherited from class java.lang.<a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true" title="class or interface in java.lang">Object</a></h3> |
| <code><a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#clone--" title="class or interface in java.lang">clone</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#equals-java.lang.Object-" title="class or interface in java.lang">equals</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#finalize--" title="class or interface in java.lang">finalize</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#getClass--" title="class or interface in java.lang">getClass</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#hashCode--" title="class or interface in java.lang">hashCode</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#notify--" title="class or interface in java.lang">notify</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#notifyAll--" title="class or interface in java.lang">notifyAll</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#toString--" title="class or interface in java.lang">toString</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#wait--" title="class or interface in java.lang">wait</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#wait-long-" title="class or interface in java.lang">wait</a>, <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/Object.html?is-external=true#wait-long-int-" title="class or interface in java.lang">wait</a></code></li> |
| </ul> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </div> |
| <div class="details"> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <!-- ========= CONSTRUCTOR DETAIL ======== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="constructor.detail"> |
| <!-- --> |
| </a> |
| <h3>Constructor Detail</h3> |
| <a name="MySQLJDBCDataModel--"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>MySQLJDBCDataModel</h4> |
| <pre>public MySQLJDBCDataModel() |
| throws <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/common/TasteException.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.common">TasteException</a></pre> |
| <div class="block"><p> |
| Creates a <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/MySQLJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc"><code>MySQLJDBCDataModel</code></a> using the default <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> (named |
| <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true#DEFAULT_DATASOURCE_NAME" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc"><code>AbstractJDBCComponent.DEFAULT_DATASOURCE_NAME</code></a> and default table/column names. |
| </p></div> |
| <dl> |
| <dt><span class="throwsLabel">Throws:</span></dt> |
| <dd><code><a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/common/TasteException.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.common">TasteException</a></code> - if <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> can't be found</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="MySQLJDBCDataModel-java.lang.String-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>MySQLJDBCDataModel</h4> |
| <pre>public MySQLJDBCDataModel(<a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> dataSourceName) |
| throws <a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/common/TasteException.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.common">TasteException</a></pre> |
| <div class="block"><p> |
| Creates a <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/MySQLJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc"><code>MySQLJDBCDataModel</code></a> using the default <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> found under the given name, and |
| using default table/column names. |
| </p></div> |
| <dl> |
| <dt><span class="paramLabel">Parameters:</span></dt> |
| <dd><code>dataSourceName</code> - name of <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> to look up</dd> |
| <dt><span class="throwsLabel">Throws:</span></dt> |
| <dd><code><a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/common/TasteException.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.common">TasteException</a></code> - if <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> can't be found</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="MySQLJDBCDataModel-javax.sql.DataSource-"> |
| <!-- --> |
| </a> |
| <ul class="blockList"> |
| <li class="blockList"> |
| <h4>MySQLJDBCDataModel</h4> |
| <pre>public MySQLJDBCDataModel(<a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql">DataSource</a> dataSource)</pre> |
| <div class="block"><p> |
| Creates a <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/MySQLJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc"><code>MySQLJDBCDataModel</code></a> using the given <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> and default table/column names. |
| </p></div> |
| <dl> |
| <dt><span class="paramLabel">Parameters:</span></dt> |
| <dd><code>dataSource</code> - <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> to use</dd> |
| </dl> |
| </li> |
| </ul> |
| <a name="MySQLJDBCDataModel-javax.sql.DataSource-java.lang.String-java.lang.String-java.lang.String-java.lang.String-java.lang.String-"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>MySQLJDBCDataModel</h4> |
| <pre>public MySQLJDBCDataModel(<a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql">DataSource</a> dataSource, |
| <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> preferenceTable, |
| <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> userIDColumn, |
| <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> itemIDColumn, |
| <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> preferenceColumn, |
| <a href="http://docs.oracle.com/javase/7/docs/api/java/lang/String.html?is-external=true" title="class or interface in java.lang">String</a> timestampColumn)</pre> |
| <div class="block"><p> |
| Creates a <a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/MySQLJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc"><code>MySQLJDBCDataModel</code></a> using the given <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> and default table/column names. |
| </p></div> |
| <dl> |
| <dt><span class="paramLabel">Parameters:</span></dt> |
| <dd><code>dataSource</code> - <a href="http://docs.oracle.com/javase/7/docs/api/javax/sql/DataSource.html?is-external=true" title="class or interface in javax.sql"><code>DataSource</code></a> to use</dd> |
| <dd><code>preferenceTable</code> - name of table containing preference data</dd> |
| <dd><code>userIDColumn</code> - user ID column name</dd> |
| <dd><code>itemIDColumn</code> - item ID column name</dd> |
| <dd><code>preferenceColumn</code> - preference column name</dd> |
| <dd><code>timestampColumn</code> - timestamp column name (may be null)</dd> |
| </dl> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| <!-- ============ METHOD DETAIL ========== --> |
| <ul class="blockList"> |
| <li class="blockList"><a name="method.detail"> |
| <!-- --> |
| </a> |
| <h3>Method Detail</h3> |
| <a name="getFetchSize--"> |
| <!-- --> |
| </a> |
| <ul class="blockListLast"> |
| <li class="blockList"> |
| <h4>getFetchSize</h4> |
| <pre>protected int getFetchSize()</pre> |
| <dl> |
| <dt><span class="overrideSpecifyLabel">Overrides:</span></dt> |
| <dd><code><a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true#getFetchSize--" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc">getFetchSize</a></code> in class <code><a href="http://mahout.apache.org/mahout-mr/apidocs/org/apache/mahout/cf/taste/impl/common/jdbc/AbstractJDBCComponent.html?is-external=true" title="class or interface in org.apache.mahout.cf.taste.impl.common.jdbc">AbstractJDBCComponent</a></code></dd> |
| </dl> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </li> |
| </ul> |
| </div> |
| </div> |
| <!-- ========= END OF CLASS DATA ========= --> |
| <!-- ======= START OF BOTTOM NAVBAR ====== --> |
| <div class="bottomNav"><a name="navbar.bottom"> |
| <!-- --> |
| </a> |
| <div class="skipNav"><a href="#skip.navbar.bottom" title="Skip navigation links">Skip navigation links</a></div> |
| <a name="navbar.bottom.firstrow"> |
| <!-- --> |
| </a> |
| <ul class="navList" title="Navigation"> |
| <li><a href="../../../../../../../../overview-summary.html">Overview</a></li> |
| <li><a href="package-summary.html">Package</a></li> |
| <li class="navBarCell1Rev">Class</li> |
| <li><a href="class-use/MySQLJDBCDataModel.html">Use</a></li> |
| <li><a href="package-tree.html">Tree</a></li> |
| <li><a href="../../../../../../../../deprecated-list.html">Deprecated</a></li> |
| <li><a href="../../../../../../../../index-all.html">Index</a></li> |
| <li><a href="../../../../../../../../help-doc.html">Help</a></li> |
| </ul> |
| </div> |
| <div class="subNav"> |
| <ul class="navList"> |
| <li><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/MySQLBooleanPrefJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc"><span class="typeNameLink">Prev Class</span></a></li> |
| <li><a href="../../../../../../../../org/apache/mahout/cf/taste/impl/model/jdbc/PostgreSQLBooleanPrefJDBCDataModel.html" title="class in org.apache.mahout.cf.taste.impl.model.jdbc"><span class="typeNameLink">Next Class</span></a></li> |
| </ul> |
| <ul class="navList"> |
| <li><a href="../../../../../../../../index.html?org/apache/mahout/cf/taste/impl/model/jdbc/MySQLJDBCDataModel.html" target="_top">Frames</a></li> |
| <li><a href="MySQLJDBCDataModel.html" target="_top">No Frames</a></li> |
| </ul> |
| <ul class="navList" id="allclasses_navbar_bottom"> |
| <li><a href="../../../../../../../../allclasses-noframe.html">All Classes</a></li> |
| </ul> |
| <div> |
| <script type="text/javascript"><!-- |
| allClassesLink = document.getElementById("allclasses_navbar_bottom"); |
| if(window==top) { |
| allClassesLink.style.display = "block"; |
| } |
| else { |
| allClassesLink.style.display = "none"; |
| } |
| //--> |
| </script> |
| </div> |
| <div> |
| <ul class="subNavList"> |
| <li>Summary: </li> |
| <li>Nested | </li> |
| <li><a href="#fields.inherited.from.class.org.apache.mahout.cf.taste.impl.model.jdbc.AbstractJDBCDataModel">Field</a> | </li> |
| <li><a href="#constructor.summary">Constr</a> | </li> |
| <li><a href="#method.summary">Method</a></li> |
| </ul> |
| <ul class="subNavList"> |
| <li>Detail: </li> |
| <li>Field | </li> |
| <li><a href="#constructor.detail">Constr</a> | </li> |
| <li><a href="#method.detail">Method</a></li> |
| </ul> |
| </div> |
| <a name="skip.navbar.bottom"> |
| <!-- --> |
| </a></div> |
| <!-- ======== END OF BOTTOM NAVBAR ======= --> |
| <p class="legalCopy"><small>Copyright © 2008–2017 <a href="http://www.apache.org/">The Apache Software Foundation</a>. All rights reserved.</small></p> |
| </body> |
| </html> |