Database
solaris_navi
https://www.linkedin.com/in/deytian/
展开
-
Reverse Engineer in Mysql Workbench
如果你需要将一个数据库中的数据表全部转移到另一个数据库里面,不包括数据 这个时候可以使用 Mysql Workbench 里面的反向工程。 Database >> Reverse Engineer. 这个时候,workbench 会将授权的目的数据库中的数据表分析出来,并生成 EER Diagram 然后,选择 Database >> Synchronize Model ,然后选择要转移的数原创 2011-11-12 04:58:17 · 1390 阅读 · 0 评论 -
D3, Bubble Sample
var svggraph; var divgraph; var svgwidth = 960; var svgheight = 960; function init() { svggraph= d3.select("#graphdiv") .append("svg") .attr("width", svgwidth) .attr("height", svgheight); d原创 2012-04-18 23:47:16 · 1103 阅读 · 0 评论 -
REST - GET Parameter
@Path("/jsoncg") @GET @Produces({MediaType.APPLICATION_JSON, MediaType.TEXT_PLAIN, MediaType.TEXT_HTML}) public String getQueryDataByStatementGet(@QueryParam("sqlstmt") String sqlstmt) { DBHana原创 2012-04-19 22:37:28 · 705 阅读 · 0 评论 -
Get Data from Database without definited Structure
package tianye.test.rest.controller; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import原创 2012-04-19 17:25:33 · 729 阅读 · 0 评论 -
Increasing performance of inserting large amount of data simutaneously.
String sql; PreparedStatement ps; System.out.println("please wait..."); Date dt1 = new Date(); sql = "INSERT INTO TABLE(COLUMNS) VALUES (?,?,?,?,?,?,?,?,?)"; ps = conn.prepareStatement(sql); for原创 2012-06-08 23:19:08 · 653 阅读 · 0 评论 -
Calculate Information Entropy
public double iEntropyDS(int[][] dataSource, int from, int to) { double e = 0.0; double col = dataSource.length; double row = dataSource[0].length; double totalElement = col * row;原创 2012-06-19 01:33:27 · 734 阅读 · 0 评论 -
How to get the tables of one schema?
public ArrayList doGetDBTable(String schemaName) throws Exception { java.sql.DatabaseMetaData meta = conn.getMetaData(); java.sql.ResultSet schemas = meta.getTables(null, schemaName.toUpperCas原创 2012-06-28 23:43:41 · 529 阅读 · 0 评论 -
How to convert CSV into Database Table?
CSV file: COL1;COL2;COL3 1;2.1;a 2;2.2;b 3;2.3;c the first line will be the column names, the rest of the data will be the content. 1. recognize data type 2. get table columns 3. create "create t原创 2012-06-28 23:49:55 · 546 阅读 · 0 评论 -
Profiling in MYSQL
http://dev.mysql.com/doc/refman/5.0/en/show-profiles.html 13.7.5.29. SHOW PROFILES Syntax SHOW PROFILE [type [, type] ... ] [FOR QUERY n] [LIMIT row_count [OFFSET offset]] type:转载 2012-06-29 22:18:31 · 617 阅读 · 0 评论