Re: Implementing a pivot table / cross table
Re: Implementing a pivot table / cross table
- Subject: Re: Implementing a pivot table / cross table
- From: "Jerry W. Walker" <email@hidden>
- Date: Fri, 17 Mar 2006 06:19:15 -0500
Hi, Rico,
I've never implemented a cross table in WO (or in any other
environment, for that matter), but if, by cross table, you mean a
table used to statistically derive information about the
relationships between the row and column elements, then I question
doing it in WO at all.
If it's a statistical cross table, then the focus is on a table which
is easily implemented in an relational database. I'm presuming, as
well, that there are a number of statistical tools available to allow
you to do regression analysis and such on the table directly. I don't
see a great deal of benefit in abstracting the information to an
object graph, unless you intend to do the analyses yourself on the
resulting object graph.
If the latter is the case, then you can simply focus on the object
graph and shouldn't need any particularly close control of the SQL.
If, however, you're intending to use tabular tools that just work on
the tables of a relational database, then I think WO would get in
your/their way.
Finally, if you are intending to create and maintain the table in WO,
but use external relational database tools for analysis, let them
remain separate with independent access to the table. When in WO,
focus on the object graph. When using the statistical tools, let them
do their thing independently on the table with SQL (or however they
choose to access the table).
Whether this advice is particularly helpful or not, perhaps it will
trigger comments by others who have worked on cross tables in WO.
Good luck.
Regards,
Jerry
On Mar 17, 2006, at 3:44 AM, Rico Landefeld wrote:
hi all,
'll have to implement an cross table. is there anyone out there who
did this with wo before? any suggestions ? i think i'll need much
more controll over the sql. is it better to implement it completely
with jdbc or should i use raw sql.
regards,
rico
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40gmail.com
This email sent to email@hidden
--
__ Jerry W. Walker,
WebObjects Developer/Instructor for High Performance Industrial
Strength Internet Enabled Systems
email@hidden
203 278-4085 office
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden