I used Oracle CASE at the time, it had a "data dictionary" where you defined the database schema in terms of the business terms and you could match it to the physical elements in the tables.

I think there was also a tool that you could make business logic in and maybe map to SQL*Forms (the user screen painter). There was an idea of being able to join these together somehow, but I don't recall the mechanics.