New Oracle tables for MDC

To gain better query performance the MDC tables have been redesigned. Especially the version management has changed completely.

The following two pictures countain the layout of all new tables existing so far. The owner is MDC_ANA. (Not all references are shown.)

The following picture shows all available views.



There are NO public synonyms for these tables and views. Therefore in queries the owner must me included , e.g.
   select * from mdc_ana.mdc_loc_history;

To query the views having names xxx_AT_DATE or xxx_AT_RUN a procedure has to be executed before:
   execute hades_oper.run_query.set_run_id(944451190);
   execute hades_oper.run_query.set_run('n99_089.hld');
or
   execute hades_oper.run_query.set_date(sysdate);