×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Good Structure for Gantt chart ?

Good Structure for Gantt chart ?

Good Structure for Gantt chart ?

(OP)
Hi,

I've got some data, which is a list of events that occur at different times, for different durations.

The key is, these events chain up together creating a tree like structure. Any tips on how I should store this ?

I thought about:
EventKey, ParentEvent, Start , End

... but that makes it pretty hard to trace back the tree... so then I was thinking like:
Parent1, parent2, parent3, parent4, parent5, event, key, start , end

.... but that wont scale very well for different depths... I was then thinking about building an XML file, but that wont fit into a traditional Oracle table very well...

Any ideas ?

RE: Good Structure for Gantt chart ?

Your first idea is the typical method for storage.  And you are correct, it does make retreiving the data challanging.

To fully retrieve the data you'll have to cursor through to build the data into a cross tab table of sorts when you want to see it.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible.  All it takes is a little research. (Me)
noevil
http://www.mrdenny.com

RE: Good Structure for Gantt chart ?

(OP)
Thanks, ok, I've got the data in that format, Any tips/examples on how to chart it ?

... my data only covers 2 days, but has hours, minutes and seconds in it, so it will need to be a fairly detailed time frame.

I was thinking about trying to use something like this:
http://live.gnome.org/Planner

... which looks like it now has some DB support... not sure how it works though ... <shrug>

RE: Good Structure for Gantt chart ?

Check in the Oracle Forums.  I'm a SQL DBA so I don't remember much of my PL/SQL.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible.  All it takes is a little research. (Me)
noevil
http://www.mrdenny.com

RE: Good Structure for Gantt chart ?

You might want to have a look at the 'connect by' syntax for heirarchical retrieval in Oracle (9i). It'll extract the data very well for you

Jim

RE: Good Structure for Gantt chart ?


Hi,

"Any tips/examples on how to chart it ?"

Are you going to use a charting tool or drawing shapes?

I've done it both ways.  The charting tool is easier but you may have more conrol using shapes.

For each row of data, from left to right, you have and OFFSET, Bar1, Offset, BAR2....

Each offset has no fill or outline.  Each bar has it's own fill and outline characteristics.

Skip,

glasses
tongue

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close