Database systems form the primary means for
storing data and representing information, therefore a thorough
understanding of the capabilities of database systems is crucial for
the professional development of any software system.
The lectures will focus on several important
aspects concerning the use of databases. In order to gain the best
performance from a database system, it is important to understand
the optimisation concepts (such as indexes, materialized views,
partitioning, database optimizers) as well as the relevant best
practices. The lecture series will also address logging and auditing
of databases as well as usage of XML with databases.
Another issue that data management faces is
the design and development of database-centric interfaces.
The class will compare and contrast several
technologies, some of them being used for rapid application
development (Java – ADF Framework, HTMLDB, PL/SQL web-cartridge,
Oracle Forms). A brief practical example will be shown of using
HTMLDB to develop a simple interface