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