![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
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 · 1359 阅读 · 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 · 1080 阅读 · 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 · 678 阅读 · 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 · 702 阅读 · 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 · 627 阅读 · 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 · 709 阅读 · 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 · 525 阅读 · 0 评论 -
How to convert CSV into Database Table?
CSV file:COL1;COL2;COL31;2.1;a2;2.2;b3;2.3;cthe first line will be the column names, the rest of the data will be the content.1. recognize data type2. get table columns3. create "create t原创 2012-06-28 23:49:55 · 540 阅读 · 0 评论 -
Profiling in MYSQL
http://dev.mysql.com/doc/refman/5.0/en/show-profiles.html13.7.5.29. SHOW PROFILES SyntaxSHOW PROFILE [type [, type] ... ] [FOR QUERY n] [LIMIT row_count [OFFSET offset]]type:转载 2012-06-29 22:18:31 · 613 阅读 · 0 评论