DocumentCode :
2597419
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
fYear :
2003
fDate :
11-13 Aug. 2003
Firstpage :
399
Lastpage :
403
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;
fLanguage :
English
Publisher :
ieee
Conference_Titel :
Information Technology: Research and Education, 2003. Proceedings. ITRE2003. International Conference on
Print_ISBN :
0-7803-7724-9
Type :
conf
DOI :
10.1109/ITRE.2003.1270646
Filename :
1270646
Link To Document :
بازگشت