Title :
Managing reference tables using Oracle Dynamic SQL and metadata
Author :
Bhowmik, Rekha ; Ramanapudi, Surendra
Author_Institution :
Dept. of Comput. Sci., Winona State Univ., MN, USA
Abstract :
Reference tables are designed to support applications using a relational database management system like Oracle or Sybase. The information in these tables changes over the time. Although a separate user interface can be designed to make changes to these reference tables, many software applications allow the DBA to make changes to these tables. We present a metadata and Oracle Dynamic SQL (MODSQL) based database to manage reference tables. Each table is analyzed and stored as metadata. Changes to each reference table are performed by executing Oracle dynamic SQL passed with corresponding metadata parameters dynamically. Basic codes for Insert, Delete and Update are written once in Oracle Dynamic SQL in PL/SQL and packaged into the Oracle stored procedures.
Keywords :
SQL; meta data; relational databases; user interfaces; Oracle dynamic SQL; Sybase; metadata; reference table management; relational database management system; user interface; Access control; Application software; Clouds; Computer architecture; Computer science; History; Insurance; Packaging; Relational databases; User interfaces;
Conference_Titel :
Information Technology: Research and Education, 2003. Proceedings. ITRE2003. International Conference on
Print_ISBN :
0-7803-7724-9
DOI :
10.1109/ITRE.2003.1270646