Forum Moderators: DixonJones

Message Too Old, No Replies

Path analysis tool that sits on a pre-existing db table

         

cfx211

7:47 pm on Nov 12, 2003 (gmt 0)

10+ Year Member



I need a path analysis tool that can sit on top of an oracle database table that we use to log traffic and events to sections of our site.

All the pathing tools I have seen out there are end to end systems meaning that they collect the data, store it, and analyze it all in their own package. While nice, these are expensive, and we do not need to do duplicate data collection.

Does anyone know of a pathing tool that can read a pre-existing database table? I don't need it to be the fancy at all, I just need to get basic paths that lead to certain events.

I am only looking for a tool because I don't believe that you can write SQL to do path analysis because of the numerous possibilities that exist. If there is a way to do this with SQL or code, I'd appreciate getting pointed in that direction too.

Nikosaki

1:57 pm on Nov 13, 2003 (gmt 0)

10+ Year Member



Hi,

What is your operating system, database format? How much would be unexpensive? Please send an example log data with colum names/description.

Greetings

cfx211

5:57 pm on Nov 13, 2003 (gmt 0)

10+ Year Member



We are running oracle on linux. The log format would be something like

guid,
obj_create_date,
user_cookie,
session_cookie,
user_uid,
url,
referring_url,
page/section code,
custom response code

There is other stuff on the table, but this is all that is really important for pathing. Plus I am going to be building a lot of custom tables that I will want to do pathing for where I will restrict down the dataset. So ideally any tool could just be pointed at a table, told what columns to pay attention to, and then go to work.

In terms of cost, I would expect to pay between $200-$2000 for it depending on features. That's probably not enough to get someone to go out and build this for me, but it should it be built that is what I think it is worth depending on features.

Nikosaki

7:16 am on Nov 17, 2003 (gmt 0)

10+ Year Member



I am trying to send you sticky mail but I am not very sure what happens, so please tell me if you have received it or not.

cfx211

1:22 am on Nov 21, 2003 (gmt 0)

10+ Year Member



I have figured out how to do this using Oracle's SYS_CONNECT_BY_PATH command.