Very Computer

1. Nested Tables for List-to-List cross reference

In light of Oracle's new nested table features, what's the best way to
implement "list to list" processing such as:

  show articles interesting to this user

where an article will have one or more topic areas
(e.g., "finance," "technology", etc.) and a user will have one or more
designated areas of interest

Traditionally you'd implement it as several tables.
   Articles
   Article_areas
   Users
   User_areas

With an SQL statement such as this to "show interesting articles for a
user"     select * from articles
        where article_id in (
                select article_id from article_areas
                where article_area  in
                        ( select interest_area from user_areas where
user_id = :user_id_in)
        )

Note: if you know a better way to do this, please comment.

What are the pro's and con's of implementing these types of list as
nested tables, i.e. where you have only two tables: Article (with a
column listing article areas) and users (with a  column listing of
areas_of-interest)?  What would the SQL look like?

It's not obvious from the examples I've seen that you can do this type
of processing with nested tables, e.g. select an article that had a
discussed an topic-area.

bill milbratz

Sent via Deja.com http://www.deja.com/
Before you buy.

2. F4M certain layout won't print on certain printer

3. Progress Program Where-used / Cross-reference

4. ***** Display Problems--Arghh *****

5. Cross Database Foreign Key Reference

6. Reports 2.5 problem with oracle 8.0.5.0.0

7. Cross-database foreign key references

8. How can i identify what chunk?

9. Cross-reference in SQL2000.

10. Query of Crossed Reference in SQL SERVER

11. Cross-database foreign key references

12. cross reference table to self

13. Cross reference table with self?