Database
关注
分享
扫一扫
magic_dreamer
这个作者很懒，什么都没留下…
展开
专栏收录文章
- 默认排序
- 最新发布
- 最早发布
- 最多阅读
- 最少阅读
-
SOLR Performance and SolrJ(1)Client Compare Java VS PHP
SOLR Performance and SolrJ(1)Client Compare Java VS PHPRecently, I am using PHP and SolrJ to connect to SOLR indexer and search.At first I am using PHP driver Solarium. The code is similar to th...原创 2017-03-15 06:10:26 · 934 阅读 · 0 评论 -
neo4j(3)Setup neo4j Server and Know Concepts
neo4j(3)Setup neo4j Server and Know Concepts1. InstallationFetch and unzip the latest files>wget http://dist.neo4j.org/neo4j-community-2.1.3-unix.tar.gzFollow the README.txt file and place the zip ...原创 2014-08-20 01:08:33 · 105 阅读 · 0 评论 -
PostgreSQL(1)Setup PostgreSQL DB
PostgreSQL(1)Setup PostgreSQL DBI know the related things as follow:cassandra DB, mongo DB, redis DBKafka, zookeeper, rabbitMQ, spark.I begin to learn to know about the PostgreSQL.1. InstallationInsta...原创 2014-03-25 06:37:31 · 410 阅读 · 1 评论 -
HBase(2)JAVA Client
HBase(2)JAVA ClientFirst of all, how to run jar based on maven plugin.pom.xml<build> <plugins> <plugin> <groupId>org.apache.maven.plugins</groupId>...原创 2014-08-07 05:38:51 · 189 阅读 · 0 评论 -
HBase(1)Introduction and Installation
HBase(1)Introduction and Installation1. HBase IntroductionHadoop Database ——> Hadoop HDFSHadoop Database ——>Hadoop MapReduceHadoop Database ——> Hadoop ZookeeperFundamentally Distributed — ...原创 2014-08-05 05:02:01 · 131 阅读 · 0 评论 -
Mysql Scalability(7)amoeba Design and Sources
Mysql Scalability(7)amoeba Design and SourcesIt is java source codes. I import that to my eclipse and read some of that.Import Project amoebaamoeba-mysqlFind the class AmoebaProxyServer.Add these prop...原创 2014-08-02 03:57:52 · 121 阅读 · 0 评论 -
Mysql Scalability(6)Mysql Trouble Shooting
Mysql Scalability(6)Mysql Trouble ShootingError MessageERROR 2013 (HY000): Lost connection to MySQL server during queryRemove and reinstall the mysql again.>sudo apt-get autoremove --purge mysql-se...原创 2014-08-02 03:53:14 · 155 阅读 · 0 评论 -
Mysql Scalability(5)benchmark
Mysql Scalability(5)benchmark>bin/benchmark -P 3306 -c 50 -f ./benchmark/query.xml -h ubuntu-master -n 100000 -u root -p kaishiPrepare 1000000Here is the initData.xml<?xml version="1.0" encoding...原创 2014-08-02 03:51:18 · 171 阅读 · 0 评论 -
Mysql Scalability(4)Amoeba - Separate Reads and Writes
Mysql Scalability(4)Amoeba - Separate Reads and WritesSeparate Reads and Writes by RulesComments out the MysqlQueryRouter Configuration<property name="sqlFunctionFile">${amoeba.home}/conf/funct...原创 2014-08-02 03:45:34 · 117 阅读 · 0 评论 -
Redis(5)Upgrade and HA Solution
Redis(5)Upgrade and HA Solution1. Install it on my MACDownload the software from here http://redis.googlecode.com/files/redis-2.6.14.tar.gz>tar zxvf redis-2.6.14.tar.gz>cd redis-2.6.14>make&g...原创 2014-03-08 07:37:10 · 177 阅读 · 0 评论 -
Mysql Scalability(3)Amoeba - Proxy - Reads and Writes
Mysql Scalability(3)Amoeba - Proxy - Reads and WritesOh, seem that the Amoeba is working with version 2.2.0. I will try this version with source codes.Find the start script file bin/amoeba, find the...原创 2014-07-30 00:21:55 · 116 阅读 · 0 评论 -
Mysql Trouble Shooting
Mysql Trouble ShootingCheck CPU Info>nproc44 cores CPU on the serverMore information for the CPU>lscpuArchitecture: x86_64 CPU op-mode(s): 32-bit, 64-bit Byte Order: L...原创 2014-07-29 02:33:23 · 161 阅读 · 0 评论 -
neo4j(4)Java Sample/Scala Client and Routing
neo4j(4)Java Sample/Scala Client and Routing1. Java SampleHere is the dependencies for neo4j-java in pom.xml<dependencies> <dependency> <groupId>commons-logg...原创 2014-08-21 23:15:44 · 151 阅读 · 0 评论 -
Kafka(6)How to Monitor Kafka
Kafka(6)How to Monitor Kafka1. KafkaOffsetMonitorThis project is good.https://github.com/quantifind/KafkaOffsetMonitorbuild and run it>sbt clean update>sbt assembly>java -cp target/scala-2.10...原创 2014-08-23 04:19:18 · 119 阅读 · 0 评论 -
PostgreSQL 2018(2)Dump the Data to CSV
PostgreSQL 2018(2)Dump the Data to CSVMy data is pretty simple>select * from usertable;name signupdatesillycat 2018-05-03This Dump command will dump all the data to one csv file>copy...原创 2018-05-05 23:09:16 · 175 阅读 · 0 评论 -
PostgreSQL 2018(1)Installation and Introduction
PostgreSQL 2018(1)Installation and IntroductionFirst of all, I plan to install the current latest version on my MAC. PostgreSQL-10.3-1-osx64-bigsql.dmgI download it from here https://www.postg...原创 2018-05-04 01:45:21 · 155 阅读 · 0 评论 -
Regis Memory and Cleanup
Regis Memory and CleanupGet total key> dbSize(integer) 73857708Get random key> randomkey"job_12_02d5b44de7a4af119504abbed239b6f4"Check the type of the key> type job_budget_431341...原创 2017-02-22 06:44:48 · 226 阅读 · 0 评论 -
Mysql Database Backup and Dump
Mysql Database Backup and DumpFix the replica error on the slave for RDS on AWS>CALL mysql.rds_skip_repl_error;For clean one huge history table.I am doing>delete from table_name where ...原创 2016-12-22 06:06:26 · 128 阅读 · 0 评论 -
Mysql Database Event and Procedure(3)Stored Procedure
Mysql Database Event and Procedure(3)Stored ProcedureGrammarcreate procedure Name()([in|out|inout] variable datatype)begin mysql statements;end;examples:CREATE procedure p2...原创 2016-12-07 03:54:20 · 118 阅读 · 0 评论 -
Mysql Database Event and Procedure(2)Store Procedure
Mysql Database Event and Procedure(2)Store ProcedureF.Y.I mysqldump command>mysqldump -h localhost -u root -P 7778 -ppassword databasename table name --where "click_time >= '2016-12-01'" > affil...原创 2016-12-07 03:38:34 · 117 阅读 · 0 评论 -
Mysql Fails on MAC
Mysql Fails on MACToday, I plan to use mysql database. But I find it does not start. I am facing the Error Message as follow:Error Message:sudo /usr/local/mysql/support-files/mysql.server st...原创 2015-10-20 03:06:12 · 94 阅读 · 0 评论 -
FIPS and County Code Lookup
FIPS and County Code LookupThere is a mapping EXCEL from here http://www.schooldata.com/pdfs/US_FIPS_Codes.xlsI found the content from here http://www.huduser.gov/portal/datasets/usps_crosswal...原创 2015-10-13 05:19:29 · 672 阅读 · 0 评论 -
Mysql on MAC
Mysql on MAC1. Check the Version of MySQLMy mysql version is as follow when I logon on.Server version: 5.1.65 MySQL Community Server (GPL)mysql>show variables like "%version%";| protocol_version ...原创 2013-11-02 05:17:25 · 104 阅读 · 0 评论 -
mongodb(5)Clients -Scala - Scala Casbah
mongodb(5)Clients -Scala - Scala Casbah4. ClientsCasbah is wrappers and extensions to the Java Driver. It is a layer on top of the official mongo-java-driver.Using CasbahAdd this to build.sbt file."or...原创 2013-10-29 05:42:22 · 223 阅读 · 0 评论 -
mongodb(4)Latest Version on MAC and Setup Replication
mongodb(4)Latest Version on MAC and Setup Replication1. Installation on MACGet the latest file from here: http://fastdl.mongodb.org/osx/mongodb-osx-x86_64-2.4.7.tgzunzip the file and find a right pl...原创 2013-10-28 22:38:28 · 170 阅读 · 0 评论 -
Mysql Scalability(2)Sharding - Thoughts
Mysql Scalability(2)Sharding - Thoughts1. AmoebaBuild Codes and Installation>svn checkout http://amoeba.googlecode.com/svn/trunk amoeba-svnInstall ant on MAC to build that.>ant -versionApache An...原创 2014-07-25 22:21:31 · 116 阅读 · 0 评论 -
MAC OS with Latest Mysql
MAC OS with Latest Mysql Command to start the mysql database>sudo /usr/local/mysql/support-files/mysql.server start Command to check status>sudo /usr/local/mysql/support-files/mysq...原创 2015-01-07 12:35:14 · 109 阅读 · 0 评论 -
Flyway for DB
Flyway for DB1. Command Tool1.1 Command Tool with H2 DB demoFind and download the flyway-commandline-2.3.zip, unzip and put it in the working directory.>cd /opt/flyway>cd jars>wget http://rep...原创 2014-02-26 00:51:45 · 132 阅读 · 0 评论 -
SQL server数据库移植到ORACLE
SQL server数据库移植到ORACLE1.SQL DEVELOPER安装Oracle SQL Developer下载地址http://www.oracle.com/technology/software/products/sql/index.html下载得到文件sqldeveloper-1.5.4.59.40-no-jre.zip解开压缩运行可执行文件，选...原创 2010-01-06 14:31:51 · 132 阅读 · 0 评论 -
SQL Explorer插件安装
SQL Explorer插件安装1.得到插件首页http://eclipsesql.sourceforge.net下载得到文件sqlexplorer_plugin-3.5.0.RC7.zip2.安装插件采用linck的方式安装eclipse插件解开压缩文件，得到features和plugins两个文件夹新增eclipse文件夹，放置在如下位置（我本机...原创 2010-01-06 14:29:33 · 144 阅读 · 0 评论 -
PowerDesigner技巧小结
PowerDesigner技巧小结同事总结的PD使用注意事项，记录一下。由pdm生成建表脚本时，字段超过15字符就发生错误（oracle）解决办法是打开PDM后，会出现Database的菜单栏，进入Database － Edit Current DBMS －script－objects－column－maxlen，把value值调大(原为30)，比如改成60。出现表或者其它对象的长度也...原创 2010-01-06 14:03:06 · 117 阅读 · 0 评论 -
Oracle数据库的导出和备份
Oracle数据库的导出和备份最近开发任务有点紧急，所以常常需要回家了或者周末还要弄弄程序。所以就把测试数据库导出回家咯。本机安装的是ORACLE的一个简单版本XE。XE版本默认安装出来是UTF-8的，公司的数据库是GBK的。所以直接导出导入自动转字符集会导致很多字段超长。所以先将默认安装的XE的字符集改正过来：1.更改XE的字符集为GBK修改字符集不过在安...原创 2010-01-06 13:58:29 · 363 阅读 · 0 评论 -
纯JAVA数据库derby简介
derby简介1. 安装首页http://db.apache.org/derby/index.html下载http://db.apache.org/derby/derby_downloads.html文件db-derby-10.4.2.0-bin.zipThe Apache Derby plug-ins for Eclipse provide a s...原创 2010-01-06 11:59:33 · 121 阅读 · 0 评论 -
初试DB4O
初试DB4O面向对象的数据库，大致照着例子用了一下。要用好还要继续研究咯。下载地址是：http://www.db4o.com/写了一个DEMO，DB4OService.java:package com.sillycat.plugin.db4o;import java.util.List;import com.db4o.Db4o;import com.db...原创 2010-01-06 10:46:23 · 111 阅读 · 0 评论 -
Java嵌入式数据库berkeleyDB(三)
Java嵌入式数据库berkeleyDB(三)修改了每次存放一个对象，同时增加了对key的范围搜索和范围删除参考了同事的部分代码，优化了配置，同时修复了以下问题：1、取数据没有数据时报nullpoint的错误2、搜索数据没有关闭transaction的错误package com.sillycat.plugin.berkeley.impl;import jav...原创 2010-01-06 10:25:54 · 128 阅读 · 0 评论 -
hsql DB配置
hsql DB配置以前使用过。不过没有写什么介绍。今天发现一个项目下面用了这个数据库，竟然启动不起来。所以又去下载了一个来配置一下。官方地址：http://hsqldb.sourceforge.net/下载了最新版本：hsqldb_1_8_0_10.zip拷贝DEMO里面的runManager.bat和runServer.bat到data目录下面，修...原创 2010-01-06 10:24:25 · 205 阅读 · 0 评论 -
Java嵌入式数据库berkeleyDB(二)
整理之后得类。难道只能放String，那不是比较不爽。有空再仔细研究研究，BerkeleyDBService.java如下：package com.sillycat.plugin.berkeley;import java.io.File;import java.io.UnsupportedEncodingException;import com.sleepyca...原创 2010-01-06 10:23:53 · 100 阅读 · 0 评论 -
Java嵌入式数据库berkeleyDB(一)
Java嵌入式数据库berkeleyDB(一)官方主页http://www.oracle.com/technology/software/products/berkeley-db/je/index.html下载地址：http://download.oracle.com/berkeley-db/je-3.3.62.ziphttp://download.oracle.com...原创 2010-01-06 10:23:22 · 118 阅读 · 0 评论 -
PowerDesigner逆向生成pdm图
PowerDesigner逆向生成pdm图1、新建Physical Data ModelFile -> New ->Physical Data Model 选择Microsoft Access 20002、菜单选择Database->configure connections,转到system dsn标签由于我的SQL SERVER安装在本机。所以在标签上已经有了一个loc...原创 2010-01-06 10:21:46 · 203 阅读 · 0 评论 -
利用TOAD实现EXCEL数据在oracle的导入导出
利用TOAD实现EXCEL数据在oracle的导入导出1.从ORACLE数据库导出成为EXCEL文件利用TOAD连接上数据库，访问某个表，我本机是选中表“OA_USER”右键“Save as...”为了解决中文乱码问题，所以选择类型为"XLS Instance"，如果存在长数字型字符串被改变的问题，请选中“String Fields as Strings”选...原创 2010-01-06 14:33:27 · 189 阅读 · 0 评论