2009年3月25日随笔档案 - donnie's life

Hadoop Core, our flagship sub-project, provides a distributed filesystem (HDFS) and support for the MapReduce distributed computing metaphor.
HBase builds on Hadoop Core to provide a scalable, distributed database.
Pig is a high-level data-flow language and execution framework for parallel computation. It is built on top of Hadoop Core.
ZooKeeper is a highly available and reliable coordination system. Distributed applications use ZooKeeper to store and mediate updates for critical shared state.
Hive is a data warehouse infrastructure built on Hadoop Core that provides data summarization, adhoc querying and analysis of datasets.

posted @ 2009-04-17 15:20 donnie 阅读(139) | 评论 (0) | 编辑收藏

DKT DBSync

摘要: 阅读全文

posted @ 2009-04-17 11:02 donnie 阅读(355) | 评论 (0) | 编辑收藏

Hadoop Introduction

http://www.hadoop.org/
The Apache Hadoop project develops open-source software for reliable, scalable, distributed computing, including:

Hadoop Core, our flagship sub-project, provides a distributed filesystem (HDFS) and support for the MapReduce distributed computing metaphor.
HBase builds on Hadoop Core to provide a scalable, distributed database.
Pig is a high-level data-flow language and execution framework for parallel computation. It is built on top of Hadoop Core.
ZooKeeper is a highly available and reliable coordination system. Distributed applications use ZooKeeper to store and mediate updates for critical shared state.
Hive is a data warehouse infrastructure built on Hadoop Core that provides data summarization, adhoc querying and analysis of datasets.

posted @ 2009-04-17 10:32 donnie 阅读(134) | 评论 (0) | 编辑收藏

CloudBase 1.2 ,Hadoop 0.19.1 综合配置功能测试 (淘宝)

http://rdc.taobao.com/blog/dw/archives/286

posted @ 2009-04-17 10:27 donnie 阅读(170) | 评论 (0) | 编辑收藏

hadoop

http://www.hadoop.org/
http://cn.hadoop.org/

posted @ 2009-04-17 10:26 donnie 阅读(152) | 评论 (0) | 编辑收藏

办公室接吻 flash游戏

摘要: 阅读全文

posted @ 2009-04-13 21:15 donnie 阅读(132) | 评论 (0) | 编辑收藏

A SQL Joke

A SQL query walks into a bar and sees two tables. He walks up to them and says 'Can I join you?'

from: http://tkyte.blogspot.com/

posted @ 2009-04-06 17:03 donnie 阅读(114) | 评论 (0) | 编辑收藏

Ora-01846: not a valid day of the week

select to_date('Mon Jan 21 13:25:47 2008', 'dy mon dd hh24:mi:ss yyyy') from dual
Ora-01846: not a valid day of the week
出现的是中文的字符日期，如下：星期五 12月 19 13:53:15 2008
是字符集的问题，解决：
alter session set nls_date_language = 'American'

posted @ 2009-04-06 16:00 donnie 阅读(1133) | 评论 (0) | 编辑收藏

trace session

摘要: 阅读全文

posted @ 2009-04-06 11:50 donnie 阅读(154) | 评论 (0) | 编辑收藏

羽毛球教学视频

http://v.youku.com/v_playlist/f2076316o1p28.html

posted @ 2009-04-04 18:26 donnie 阅读(115) | 评论 (0) | 编辑收藏

利用Oracle数据库存储和分析Unix操作系统的性能

http://edu.136z.com/DataBase/32042.html

目录

一、       前言... 4

二、       思路... 4

三、       vmstat脚本及步骤... 4

1.       安装statspack. 4

2.       创建stats$vmstat表... 4

3.       创建vmstat目录... 6

4.       创建get_vmstat.ksh脚本... 6

5.       创建run_vmstat.ksh脚本... 8

6.       创建crontab作业，定时执行run_vmstat.ksh脚本... 9

7.       分析数据... 9

1)    异常报告... 9

2)    每小时趋势报告... 13

3)    周趋势报告... 14

4)    长期趋势报告... 14

四、       使用Excel生成趋势图... 15

五、       参考资料... 15

posted @ 2009-04-02 10:46 donnie 阅读(130) | 评论 (0) | 编辑收藏

oracle spfile损坏，如何启动

改用传统的pfile方式启动，具体pfile的内容可从spfile文件中copy，或者从数据库的警告日志文件中获取。

posted @ 2009-03-30 22:32 donnie 阅读(221) | 评论 (0) | 编辑收藏

oracle的NULL

在oracle中，NULL与NULL既不相等，也不完全不相等。SQL Server与Sybase中，NULL等于NULL.
--REF: oracle expert....

scott@ORCL> select * from dual where null=null;

未选定行

scott@ORCL> select * from dual where null <> null;

未选定行

scott@ORCL> select * from dual where null is null;

posted @ 2009-03-27 22:47 donnie 阅读(115) | 评论 (0) | 编辑收藏

oracle 多版本一个简单的例子（在其他数据库结果可能不同）

scott@ORCL> select count(*) from t;

COUNT(*)

----------

scott@ORCL> begin

2 for x in (select * from t)

3 loop

4 insert into t values (x.username,x.user_id,x.created);

5 end loop;

6 end;

7 /

PL/SQL 过程已成功完成。

scott@ORCL> select count(*) from t;

COUNT(*)

----------

posted @ 2009-03-26 23:18 donnie 阅读(119) | 评论 (0) | 编辑收藏

plsql error handling

SET SERVEROUTPUT ON;

DECLARE

stock_price NUMBER := 9.73;

net_earnings NUMBER := 0;

pe_ratio NUMBER;

BEGIN

-- Calculation might cause division-by-zero error.

pe_ratio := stock_price / net_earnings;

dbms_output.put_line('Price/earnings ratio = ' || pe_ratio);

EXCEPTION -- exception handlers begin

-- Only one of the WHEN blocks is executed.

WHEN ZERO_DIVIDE THEN -- handles 'division by zero' error

dbms_output.put_line('Company must have had zero earnings.');

pe_ratio := null;

WHEN OTHERS THEN -- handles all other errors

dbms_output.put_line('Some other kind of error occurred.');

pe_ratio := null;

END; -- exception handlers and block end here

ref : http://www.sc.ehu.es/siwebso/KZCC/Oracle_10g_Documentacion/appdev.101/b10807/07_errs.htm

posted @ 2009-03-25 10:52 donnie 阅读(97) | 评论 (0) | 编辑收藏

常用链接

留言簿

随笔分类(66)

随笔档案(79)

相册

收藏夹(11)

搜索

积分与排名

最新随笔

最新评论

阅读排行榜