Re: Cognos

--0__=cghX3lRiz1AHUk8arxsCMyOoA2MBrhYnRMYQAZ4zgM0zINEYkYUxYYS6
Content-type: text/plain; charset=us-ascii Content-Disposition: inline

Super-associative ----> my word for a table that has no relationship enforced via the rdms, but instead, contains a field that specified tot he application developer which table to associate this row of data with. The association is enforced within business rules..... totally against the prupose of having a database management system altogether!

ID   TABLE          Arc_ID         Arc_Type
1    Site      34432          Employee
2    Incident       34466          Employee
3    Property  23455          PropertyID

For instance , you want to find an employee associated with the site, go to this table where table = Site and Arc_type = Employee.....

I think of this table like a folding ruler, creating a 3 domensional associative table....but I do not agree with this design!

Actually this is a VERY simple example. Our TABLE usualy represent an OBJECT LEVEL....... but can't go into that without going nuts! Plus there are MANY tables and MANY types of associations......

Hannah

PS. The vendor set it up this way in order to be able to CUSTOMIZE. Giood base idea, but poorly implemented and inconsistent across the design.......

"Tarkanyi Antal" <tantal_at_nagev.hu> on 12/15/2000 09:16:02 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: Re: Cognos

Hi !

I would like to thank you very much for your answers !

Something about my business requirements, medium size database ( 5 - 10 million record max) lot of different table, lots of joins > Hannah's "Super Associative" word ? building cubes at night could be enough.

Thanks again.
  What are your business requirements?

--0__=cghX3lRiz1AHUk8arxsCMyOoA2MBrhYnRMYQAZ4zgM0zINEYkYUxYYS6
Content-type: text/html;

        name="att1.htm"

Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMCBUcmFuc2l0aW9uYWwv L0VOIj4NCjxIVE1MPjxIRUFEPg0KPE1FVEEgY29udGVudD0idGV4dC9odG1sOyBjaGFyc2V0PWlz by04ODU5LTEiIGh0dHAtZXF1aXY9Q29udGVudC1UeXBlPg0KPE1FVEEgY29udGVudD0iTVNIVE1M IDUuMDAuMjYxNC4zNDAxIiBuYW1lPUdFTkVSQVRPUj4NCjxTVFlMRT48L1NUWUxFPg0KPC9IRUFE Pg0KPEJPRFkgYmdDb2xvcj0jZmZmZmZmPg0KPERJVj48Rk9OVCBmYWNlPUFyaWFsIHNpemU9Mj5I aSAhPC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBmYWNlPUFyaWFsIHNpemU9Mj48L0ZPTlQ+Jm5i c3A7PC9ESVY+DQo8RElWPjxGT05UIGZhY2U9QXJpYWwgc2l6ZT0yPkkgd291bGQgbGlrZSB0byB0 aGFuayB5b3UgdmVyeSBtdWNoIGZvciB5b3VyIA0KYW5zd2VycyAhPC9GT05UPjwvRElWPg0KPERJ Vj4mbmJzcDs8L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1BcmlhbCBzaXplPTI+U29tZXRoaW5nIGFi b3V0IG15IGJ1c2luZXNzIA0KcmVxdWlyZW1lbnRzLDwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQg ZmFjZT1BcmlhbCBzaXplPTI+bWVkaXVtIHNpemUgZGF0YWJhc2UgKCA1IC0gMTAgbWlsbGlvbiBy ZWNvcmQgDQptYXgpPC9GT05UPjwvRElWPg0KPERJVj48Rk9OVCBmYWNlPUFyaWFsIHNpemU9Mj5s b3Qgb2YgZGlmZmVyZW50IHRhYmxlLCBsb3RzIG9mIGpvaW5zICZndDsgSGFubmFoJ3MgDQoiU3Vw ZXIgQXNzb2NpYXRpdmUiIHdvcmQgPzwvRk9OVD48L0RJVj4NCjxESVY+PEZPTlQgZmFjZT1Bcmlh bCBzaXplPTI+YnVpbGRpbmcgY3ViZXMgYXQgbmlnaHQgPEZPTlQgZmFjZT1BcmlhbCANCnNpemU9 Mj5jb3VsZCBiZSBlbm91Z2guPC9GT05UPjwvRk9OVD48L0RJVj4NCjxESVY+Jm5ic3A7PC9ESVY+ DQo8RElWPjxGT05UIGZhY2U9QXJpYWwgc2l6ZT0yPlRoYW5rcyBhZ2Fpbi48L0ZPTlQ+PC9ESVY+ DQo8QkxPQ0tRVU9URSANCnN0eWxlPSJCT1JERVItTEVGVDogIzAwMDAwMCAycHggc29saWQ7IE1B UkdJTi1MRUZUOiA1cHg7IE1BUkdJTi1SSUdIVDogMHB4OyBQQURESU5HLUxFRlQ6IDVweDsgUEFE RElORy1SSUdIVDogMHB4Ij4NCiAgPERJVj5XaGF0IGFyZSB5b3VyIGJ1c2luZXNzIHJlcXVpcmVt ZW50cz88L0RJVj4NCiAgPERJVj4mbmJzcDs8L0RJVj48L0JMT0NLUVVPVEU+PC9CT0RZPjwvSFRN Received on Fri Dec 15 2000 - 09:28:53 CST