| DESCRIPTION | This option can take a few minutes to run. Use it when you have someextra time to explore the sharing relationships among files. With it,though, you can find out which tables are often referenced by others. You will be prompted for a cutoff point. This is used to subset theresulting groups. If you use a high cutoff, like 150, you will get backa fairly short shared table list, including only those files that havemore interconnections that the cutoff, like New Person and Patient. A cutoff around five might give the most useful subdivisions. Thatmight put 200-300 tables in the shared group, leaving all the othertables in fairly small mutually exclusive groups of 30 or so. Thisapproach ends up with a large number of small tables, though, like around700 or more. The purpose of this utility is to give you an idea about how to grouptables when assigning access to users by profile. If you already had auser profile with access to a set of interrelated tables, you could usethe profile for other users who were interested in the same tables. Note that this utility doesn't list tables without any connection toothers (a relatively small set, however!). Also note that the table thathas the most sharing activity compared with other members of the groupis used to identify the group in this option's printout. After entering a cutoff, you are prompted for a table of specialinterest. If you want to see where a particular table ends up in thefinal analysis, enter it here. As a result, after the shared tablesare listed, you will get a special report showing your table and itsgroup. After that, all the groups are listed. Running this option with several cutoff points might show the following: Cutoff Total Shared Number of other Groups Member totals ----------------------------------------------------------------- 50 11 227 3391,32... 10 122 534 275,140,112... 5 284 718 34,33,32,32,26... There isn't any right way; just experiment as you wish! |