In a message dated 99-03-12 05:25:28 EST, you write:
The only problem I can envisage is the ‘admin’ of this exercise… can
anyone think of an ‘area’ somewhere online that we can gather this material
together? perhaps we could publish the password of such an area on the list
so that everyone can watch and submit.
I can make our web site available for distributing any final works. In fact, I
have already received Glenn Fredericks’ version of the DB2 universe, which
will be posted on our site later this week. As soon as I do, I will email a
note to the list.
At the moment, however, we don’t have anything on our web server to manage an
ongoing discussion (message board software). We don’t have ftp access set up
either, due to security concerns. I do have some space available via my
America Online account that is eventually going to be dedicated to my personal
web site, but for now I have 2 meg of space that we can use for storing
uploaded material.
I don’t know if we want to use this list for an ongoing discussion of the
development effort. The traffic could be high, and other people on the list
that are not actively participating in the development may only be interested
in the announcement that a final product is available.
Either way, I might be able to help coordinate such an effort. But only with
the understanding that the final product would be public domain, and not
“owned” by any individual or company.
A few ideas:
I have considered creating a true generic universe. One with no outer joins,
and with no specific database functions like Decode() or charindex() or
whatever. I realize that many of the report requirements require outer joins,
so…
Along with the universe would be a set of documents (reports) built on that
universe. As you know, BusObj does an outer join when combining two (or more)
data providers. It might be possible to get the proper reports using just the
BusObj reporting tool. Or perhaps some use of the scripting language to
process data prior to reporting on would work.
The objective would be to create a repository documentation system that anyone
can use “out of the box”, without any modifications other than to set up
appropriate database connections.
Another idea would be to create an Access database that mimics the Repository
structure. A universe to access this stand-alone database would then be built.
Individual sites would be responsible for migrating their data into the Access
database, either on a one-time or an on-going basis. Reports would no longer
be “real time”, but the universe would be the same for everyone.
Access supports “attached tables”, so it would be possible to attach remote
(repository) tables directly if real time data was a requirement.
Unfortunately, these ideas are as far as I have gone so far. No actual work
has been done on either.
Ideas? Comments? Suggestions?
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
Listserv Archives (BOB member since 2002-06-25)