Thursday, March 27, 2008

Oracle for Beginner: ORDB with Oracle (I)

If you want to learn about object relational database in Oracle, the first thing that you have to understand is object oriented concept itself. By the way, in what level of your understanding, let we learn about how to implement a simple Oracle's ORBMS.
In Oracle, there are object schema, .i.e., User Define Type (UDT). With this object, we can create any customize type, specially object type. Here is a example:

create or replace type pengajar_t as object (
pengajar_id char(5),
nama varchar(30)
)
/

With customize object type, we can use that as a attribute type for a table.

create table kursus (
kursus_id char(5) primary key,
nama_kursus varchar(50),
pengajar pengajar_t
);

If you want to insert or update for that table, here are an example for how to do that:

insert into kursus values ('K01', 'Air Blender', pengajar_t('X-01','Avatar'));
insert into kursus values ('K02', 'Kamehameha', pengajar_t('X-02','Goku'));
update kursus k set k.pengajar.nama = 'Gohan' where k.pengajar.pengajar_id ='X-02';

Sunday, March 23, 2008

OpenSource style for marketing

As you know, Open Source movement have changed the world to make their policies, either for organization or ourself. With this movement, everyone can became a programmer, a documentation maintainer, a tester, or may be only as a end user. I interested about how to make community, like Open Source, to make a marketing more powerful. With involving our customers, I believe that they will give their ideas (like wish list) to make our organization can give services better. I talk this with my client that one important thing to make their business can get the trust from their customers or partners is to make a good relationship with them. This is why CRM or PRM (Partner Relationship Management) concept arise on the surface.
How to build a customer community for our organization? Of course the most important thing to realize that is we have to give the best of our service to our partners. After that, we can use the Internet service to capture our customer requirements or needs. Indirectly, if our partner community is strong, they will promote our organization to others. This is a good strategy. And I believe that almost marketing manager had realize this way. But in Indonesia, specially for small-medium enterprise, still don't figure out about this. The big problem is the Internet penetration still low. Based on the APJII data, the Internet users in Indonesia at the end of 2005 was estimated around 1.6 million (I thing from 200 million population :D). I thing, we have to build and maintain many communities to develop their local small-business enterprise area to realize the Internet. Many names have arisen , like Internet goes to Village. I still figure out about the cheaper Internet access from villages. May be we can use mess wireless protocol to build local wireless communication with WiFi. Who knows...