henzen

I’ve heard that people say photography can be an addiction. I guess in some ways it’s true, it can be an addiction. Once you get a hold of that SLR camera, once you get the shots and see what the result is like, the your heart starts pumping harder, urging you to take even more shots with your camera.

I’m just a beginner, very amateur on this area, so if you please can comment on my shots, so that I can improve them. I have my shots available on my Portfolio album on the left side of this blog or on flikcr.com

Well, it’s the first time I’m doing any kind of money transaction on the net.
I’m buying a sticker from Jeff Atwood Codinghorror which I think very cool sticker for my laptop. The transaction itself without any transaction fee from Paypal. The sticker cost about $3 = Rp 27000, well I guess I just have to see the bill on my credit card next month.

You
can create your own Oracle Warehouse Builder (OWB) Runtime repository
log to view log of mapping execution. It provides easier access rather
that using OWB Runtime Audit browser, which in my opinion rather slow
and heavy. Using OWB public view API you can create the view using the
following query


CREATE OR REPLACE VIEW DWH_RT_V
(MAP_RUN_ID, EXECUTION_AUDIT_ID, MAP_NAME, START_TIME, END_TIME,
ELAPSE_TIME, RUN_STATUS, NUMBER_RECORDS_SELECTED, NUMBER_RECORDS_INSERTED, NUMBER_RECORDS_UPDATED,
NUMBER_RECORDS_DELETED, NUMBER_RECORDS_DISCARDED, NUMBER_RECORDS_MERGED, EXECUTION_NAME, RETURN_RESULT,
RETURN_RESULT_NUMBER, RETURN_CODE, EXECUTION_AUDIT_STATUS, ELAPSE_TIME_TOTAL, RUN_ERROR_NUMBER,
RUN_ERROR_MESSAGE, TARGET_NAME, TARGET_COLUMN, STATEMENT, MESSAGE_SEVERITY,
MESSAGE_LINE_NUMBER, MESSAGE_TEXT, PROC_ERR_MSG, PROC_STATEMENT)
AS
SELECT a.map_run_id,
    b.execution_audit_id,
    a.map_name,
    a.start_time,
    a.end_time,
    a.elapse_time,
    a.run_status,
a.number_records_selected,
a.number_records_inserted,
a.number_records_updated,
a.number_records_deleted,
a.number_records_discarded,
a.number_records_merged,
    b.execution_name,
    b.return_result,
    b.return_result_number,
    b.return_code,
    b.execution_audit_status,
b.elapse_time elapse_time_total,
c.run_error_number,
c.run_error_message,
c.target_name,
c.target_column,
c.statement,
d.message_severity,
d.message_line_number,
d.message_text,
e.run_error_message proc_err_msg,
e.statement proc_statement
FROM
all_rt_audit_map_runs a, all_rt_audit_executions b,
all_rt_audit_map_run_errors c, all_rt_audit_exec_messages
d,ALL_RT_AUDIT_PROC_RUN_ERRORS e
WHERE  a.execution_audit_id = b.execution_audit_id
and a.map_run_id = c.map_run_id (+)
and b.execution_audit_id = d.execution_audit_id (+)
and a.map_run_id = e.map_run_id (+)

Berapa orang yang bisa query select lebih dari ‘SELECT * FROM
tablename’ ?? How much do you know about database? Kenapa juga jadi
programmer musti tau banyak tentang database? Bukannya itu tugasnya DBA? Well menurut saya pengetahuan tentang database buat programmer itu is a must.
I’m not just talking about connecting to the database and do a simple
select query. I’m talking about the concept behind the database. How to
design the appropriate data structure for your application and what can
we do with it in terms of performance and scalability.

Design
database berangkat dari konsep himpunan. You got an INTERSECTION,
UNION, JOIN, MINUS, CARTESIAN concept on the database. Kalo konsep ini
sudah dikenali dengan baik maka kemungkinan besar apapun pertanyaan
(query) yang ingin diajukan ke data bisa dilakukan dengan dengan benar.
Most programmer don’t really care about their ER
structure for their applications. They just make the data stands by
itself without making any relationship in them. They don’t care about
indexes, data integrity, referential integrity.

Why should we
care about this anyway? Bukannya yang penting aplikasi jalan, user
senang, duit dapet and move on to the next project? IT is a services
based industry. People trust you because the application you build
serve them well. And to build an application that serves user well you
must think on all aspect of things.
Ada banyak hal yang bisa
dikerjakan oleh SQL lebih baik daripada procedural. Most procedural
language bekerja berdasarkan operasi row-based bukan set-based. Untuk
menampilkan ranking 10 penjualan terbesar dari perusahaan misalnya,
bila dengan prosedural data harus diambil kemudian di sort. Bila
memanfaatkan SQL maka cukup dengan query seperti berikut (using Oracle
Analytic Function)

select region,
total_sales,
rank() over (order by total_sales) ranksales
from t_sales
where rownum  < 10
order by total_sales desc

maka
informasi 10 total penjualan terbesar berdasarkan region dapat
didapatkan dengan mudah. Mungkin ada yang berargumen kalau sebenarnya
kan sama saja, toh database juga melakukan sorting berdasarkan
penjualan terbesar.
Memang benar, tapi pada saat programming kita
mengambil lagi data kemudian mensortirnya lagi sendiri, kenapa tidak
langsung mengambil data yang sudah jadi untuk ditampilkan saja.
Database juga sudah dibangung dengan set-based minded untuk memproses
data secara set, sehingga kemungkinan proses dapat dilakukan dengan
lebih cepat.

Masih ragu untuk perlu belajar SQL dan Database? Don’t hesitate, it’ll help to make your life easier.

This tutorial will show you how
to create a simple repository on your local computer for versioning
control purposes using subversion and turtoisesvn.

1.      Install your subversion and turtoiseSvn application

2.      Using windows explorer navigate to the folder your created to store subversion repositories, default was C:\svn\ and create a new directory here with the name you want for your repository MyRepository, use the name of your program or project you wish to store in Subversion.

3.      Right click on the new folder you just created and select the option TortiseSVN and another context menu will appear. Select Create Repository here…..

4.You will be asked about the type of repository you wish to create, select Native File System,it should be the default. See Repository Data-Stores
in the Subversion book regarding information on a comparison of the
various repository types. You should be prompted with a message
indicating that the repository was created successfully and you should
now see that some directories and files were created in C:\svn\MyRepository\.

5.      We now need to create the structure of your repository. It is highly recommended that you read Creating a Repositry Layout
in the Subversion book. This discusses issues like do I use one
repository for all my projects or use individual repositories for each
project. For simplicity in this tutorial we are going to assume you are
creating one repository to hold one project.

6.      Create a directory in your C:\svn\ folder called repos_structure. This directory will contain the template directory structure, used to setup a new repository.

7.      Create 3 directories within repos_structure called trunk, branches and tags.

8.      Right click on the directory repos_structure and select TortiseSVN->Import…. Only the directories within this directory will be imported.

9.      You will be presented with an Import window. For the URL of respository use http://localhost:81/svn/MyRepository
if you have installed subversion as a webdav module on apache, if not
just select browse and select your file directory, for example file:///c:/svn/MyRepository. Type a comment in the Import Message to signify that this is the initial directory import.

10.
Import window successful. You may experience a slight pause and then
you will see a log of what has been imported into Subversion

11.  That’s it, I guess, from now on you can start playin with the repository using turtoiseSvn. Happy subversioning!

So, back to my story on data warehouse, on the last post I’ve given
you my opinion on what data warehouse is. Why don’t we ask people that
are really involved in creating this concept at the first time.

According to Bill Inmon (one of the earliest and most influential practitioners), quoted from wikipedia, defined a datawarehouse as follows:

• Subject-oriented,
  meaning that the data in the database isorganized so that all the data
  elements relating to the same real-worldevent or object are linked
  together;

• Time-variant, meaning
  that the changes to the data in thedatabase are tracked and recorded so
  that reports can be producedshowing changes over time;

• Non-volatile, meaning that data in the database is never over-written or deleted, but retained for future reporting;

• Integrated,
  meaning that the database contains data frommost or all of an
  organization’s operational applications, and thatthis data is made
  consistent.

The main drives behind the creation of data warehouse include (from Mark Rittman):

• Integrating data from various sources thus providing a ‘360′ view of the company
• Providing a trusted set of figures across all areas
• Providing user-friendly graphical view of organization data
• Providing access to insight, forecasts and trends
• Removing reporting overhead from existing application
• Making analysis possible for large amount of data
• Adding metadata, meaning and structure for the data

With
the availability of data warehouse to the end users, then user can
slice, dice, drill, analyze, mine and do other things with large amount
of data. Below is a simple architectural view of a data warehouse and
the process involved in it.

When I come home for last vacation, many of my friends ask me what
my job is. Because IT consultant jobs is not very popular up there,
many of my friends and relatives just couldn’t understand what it is
I’m doing day in day out. The just think that I’m just a computer guy,
you know you could call and say, "Hey dude, looks like I mess something
with my computer can you take a look at it", or "Dude, I spill
something on my keyboard last night, will the computer be dead?", or
more silly things like "Hey don’t get close to the computer it has a
virus in it, you could get infected, can you fixed it hendra?" while
looking desperately to me…arrrggg..

It’s just depressing
sometimes when people home ask me what I’m doing,, so to make the story
short, I’ll tell you what I’m doing. I’m currently developing a
datawarehouse at a mining company. "Stop right there young man. A data
warehouse you said? What is that thing, explain them to me!"

Okay before I start telling more about what I do, first I’ll tell you about what I know of data warehouse.

Company
stores a lot of data these days, even a small company can store up to
hundred thousands of data every day. Thus the question arise, what can
we do with that kind of data? Can we draw conclusions out of it? Can we
make decissions based on it? Can we make predictions out of it?

Because
there’s the need to answer all these question, comes in a concept of
Data Warehouse. It’s a central repository of all the data. It’s a
consolidation data for the foundation of extraction information out of
data. Why the heck do we need to build it anyway? Isn’t the data is
already there? Yes the data is there, but is it consolidated, hows the
performance impact of doing direct analysis to transactional data,

So
basically a datawarehouse is a consolidated central repository
(warehouse) of data, in which the data is stored in a structure that
enables the data to be analyzed without any significant impact on
performance.

So there goes, my own definition of  a datawarehouse. We’ll continue next time.

Agak-agak
gatal untuk tidak berbicara mengenai poligami sekarang-sekarang ini. I
can’t stop my mind in a last few days from thinking about it. Terutama
masalah kedudukan wanita di dalam masyarakat kita. Menurutku gak ada
yang salah dengan poligami kalau dilakukan dengan memenuhi
syarat-syaratnya dengan tetap mengutamakan salah satu pilar utama dalam
Islam yaitu keadilan. It’s a little bit hard not to include religious
believe in this topic, because it’s what trigger almost this entire
topic anyway. Menurutku ada beberapa hal pokok yang mungkin bisa
menjadi jalan keluar dari kekisruhan opini yang sekarang ini berkembang.

Pertama
memperbaiki cara pandang kita terhadap wanita, kedudukannya dan
posisinya di masyarakat. Agak sulit mungkin bagi awalnya untuk menerima
wanita sebagai partner yang setara, karena pandangan patrialkal yang
sudah tertanam sedemikian dalam. Pandangan bahwa wanita hanyalah wadah,
pengikut, second-in-command, wakil komandan dalam strata rumah tangga
ini yang membuat pandangan ini tertanam begitu dalam. Agak sulit untuk
menemukan rumah tangga dimana kedua orang tuanya bertindak satu sama
lain sebagai partner yang setara. Ini bukan berarti mengganti peran
bapak sebagai tulang punggung keluarga, tetapi menurutku malah
melengkapi dengan ibu sebagai otak rumah tangga misalnya. Equal share
of the responsibilty. Kemudian pandangan ini dapat diterapkan di
lingkungan dengan menempatkan wanita sebagai partner yang sejajar tanpa
melecehkan di segala bidang.

Kedua menurutku mengenai masalah
poligami itu sendiri. According to what I believe, poligamy
diperbolehkan. DIPERBOLEHKAN bukan DIANJURKAN. May NOT Must!
Diperbolehkan dengan syarat-syarat, syarat yang paling utama adalah
keadilan. Memang banyak yang berpendapat berbeda mengenai penafsiran
‘Adil’ ini. Tapi anggaplah kita semua orang bodoh yang baru pertama
kali belajar bahasa, take it to our deepest sense, our basic instinct.
Can we ever be fair when it comes to this? Kalo merasa sanggup dan
syarat-syarat kesanggupannya jelas dan ketat, maka silahkan. Jangan
diributkan, jangan dipermasalahkan. Karena biasanya mempermasalahkan
sesuatu itu DAPAT membuat masalah dari ketiadaan. Hal yang penting
untuk diperhatikan adalah syarat-syarat serta perlindungan hukum dari
pernikahan itu sendiri. Harus ada semacam proteksi terhadap perempuan
dari kekerasan rumah tangga dan keterlantaran. Sebab kita tau kita
manusia tidak luput dari kesalahan, maka kita harus dapat membuat
sistem yang dapat melindungi kita dari kesalahan itu bukan? Kalo tidak
buat apa kita dilengkapi dengan akal sehat dan kejeniusan. Perlindungan
ini penting baik untuk istri maupun untuk anak dalam pernikahan.

So
there goes, I think polygamy is a matter which must be handle with
care. Bila diatur dengan benar dapat menghasilkan kebaikan yang besar,
namun bila tidak it’s like a double bladed sword, it can kill you both.

A while ago I read my friend’s blog about her lives choices and about looking at the past. It makes me remember about my journey on IT world. At first I was a system administrator, doing an intern on my campus Lab. As a system administrator, I learn alot about networking, system maintenance, UNIX families, Linux, Shell scripting, unattended installation, well just about anything a system administrator daily job is.

Then after a while somebody offer me a job as a web developer on developing a system which I think is huge (for someone who just started developing web professionally at that time). When working at this project I learn the hard way about frameworks, project management and versioning. Good project management, combine with solid framework and integrated versioning will determine almost 75% of the software we will produce. After that one project, I’m almost 100% in the web development and other application development projects. I’m so into software development that I with some friends build our own startup company. During that time, Joel Spolsky (joelonsoftware.com) was one of my favorites site which I visit daily and follow to the heart.
Not so long after that I got into an economic dilema, I have to got some income because my family couldn’t support me anymore, while this new startup was in an uncertain state. So I desperately apply to one of IT Consultant company in Indonesia as an application developer. But I guess faith has another plan for me, and I got in on a business intelligence project. In the beginning I hope I can do both thing at the same time, but it didn’t work out.  I can’t continue to support our startup company and bail out from my friends. I feel really bad about this, because it has been my dream since I started my college time to start a company, and build my business from bottom up. But I guess circumstances won’t allow it, or I’m not a person who dares take such a risk.
One thing I didn’t regret was that this new experience, this new world of business intelligence is great. I’ve come to love it, now I one to focus on it and be a great business intelligence consultant. It’s great because I think it is the forefront of information technology to business users. Building business intelligence is like building a large machine to answer the business question a lot of business users will ask. It has been one great adventure for me in this world of software building, and I’m ready for some more.

Some say that love blinds us. But is it really true? I believe that love open our eyes,
to see beyond what other people see. We can see the goodness in people that perhaps others can’t see,
we can see greatness when others see weakness, we can see wisdom when others see stupidity
I think and I believe that loving somebody makes us see great thing in them.

We don’t love people just by looking at their physical characteristics right? Although at first it
maybe become our first attraction, but it’s just not enough. We need other quality, other things that
makes her/him attractive to us. Perhaps their generousity, their attitude, their kindness, their ‘macho’
behaviour, and lots of other thing. For me there’s one person that I think is the ‘one’.

She is my soulmate, my other side, my alter ego. She’s the one that complete me (so Jerry McGuire hahaha.. )
I hurts me the most when somebody else say anything bad about her, say that I could find someone better (even if not directly),
but it hurts me…it hurts..
Yes, perhaps I could find someone better,
Yes, perhaps she is not perfect,
But I don’t want anyone else, I want her,
For all she is,
Even if the whole world says I’m wrong, but my heart says I’m right
Even if the whole world disagree with me, but my heart say she’s the one
Can you hear me world? I don’t want anyone but her,
You can scream at me and mock me, You can laugh at me and spit me
But not to her, because I will defend her with all I’ve got

One more thing, the one that can hurt you the most is the one that you love the most,
Why can’t you just accept her like I do, why can’t you stop complaining, are you that perfect,
is your son’s love just another trophy to you, just like every other trophy your son has gave?
I can’t hate you, but can’t just you love her like I do
Just one big unconditional love..
I love her because I choose to love her, I love her because I want to love her, can’t you at least understand that?

Oh, what mumbling have I wrote, but it’s what I really feel right now..my heart like a little boat on a stormy sea