Author Archives: davidand

About davidand

Hi, welcome to my blogs. My name is David Andriansyah. I am currently working as an independent Cognos Business Intelligence consultant, and I also as Freelance Web Developer.

DNAstudio Web

Tempat training  DNAstudio telah membuka kelas kursus membuat web, paket materi web design, web programming dan web master.

Peserta tanpa latar belakang IT pun bisa mengikuti kursus membuat web di DNAstudio.Web.ID Dengan Garansi sampai bisa membuat website serta gratis konsultasi terkait materi ataupun pengetahuan lain seputar IT selamanya (alias seumur hidup).

Semua peserta kursus web disini mendapatkan Gratis Sub Domain


Cognos Training

DNAstudio membuka kelas training 3hari IBM Cognos dengan materi pembahasan:

#Hari pertama:
-Overview Business Intelligence
-Komponen IBM Cognos
-Framework Manager Workflow
-Operasional dan Reporting Database
-Membuat Star Schema
-Fakta dan Dimensi
-Double Counting
-Instalasi dan Konfigurasi IBM Cognos

Continue reading

Business Card


Posted from WordPress for Android

WhatsApp Messenger: Android

Hey, I just downloaded WhatsApp Messenger on my Android. It is a Smartphone Messenger which replaces SMS. This app even lets me send pictures, video and other multi-media! WhatsApp Messenger is available for Android, iPhone, Nokia and BlackBerry and there is no PIN or username to remember – it works just like SMS and uses your internet data plan. Get it now from and say good-bye to SMS.

Partition table MyISAM vs InnoDB

Benchmark partition table with MyISAM & InnoDB engine

Partitions table with MyISAM:
Load data 1.000.000 rows
mysql> call load_test_part_myisam();
Query OK, 1 row affected (57.69 sec)

mysql> select count(*) from test_part_myisam where c3 > date ‘2000-01-01’ and c3 < date '2000-12-31';
| count(*) |
| 99681 |
1 row in set (0.10 sec)

Partitions table with InnoDB:
Load data 1.000.000 rows
mysql> call load_test_part_innodb();
Query OK, 1 row affected (1 hour 11 min 25.19 sec)

mysql> select count(*) from test_part_innodb where c3 > date ‘2000-01-01’ and c3 < date '2000-12-31';
| count(*) |
| 99681 |
1 row in set (0.22 sec)

Continue reading

Export & Load some table in DB2

How can I export / Import some table in DB2 on command prompt

C:\Program Files\IBM\SQLLIB\BIN>db2
(c) Copyright IBM Corporation 1993,2002
Command Line Processor for DB2 ADCL 9.1.0

You can issue database manager commands and SQL statements from the command
prompt. For example:
db2 => connect to sample
db2 => bind sample.bnd

Continue reading

exp / imp some table in Oracle

How can I export / Import some table in Oracle on command prompt

C:\Documents and Settings\david>exp ods0_mart_postpaid/ods0_mart_postpaid@cognos file=dim_region.dmp tables=dim_region log=dim_region.log

Export: Release – Production on Mon Jul 5 17:12:42 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.

Continue reading