Extensibility in ORDBMS databases : an exploration of the data cartridge mechanism in Oracle9i
- Authors: Ndakunda, Tulimevava Kaunapawa
- Date: 2013-06-18
- Subjects: Database management , Oracle (Computer file)
- Language: English
- Type: Thesis , Masters , MSc
- Identifier: vital:4686 , http://hdl.handle.net/10962/d1008098 , Database management , Oracle (Computer file)
- Description: To support current and emerging database applications, Object-Relational Database Management Systems (ORDBMS) provide mechanisms to extend the data storage capabilities and the functionality of the database with application-specific types and methods. Using these mechanisms, the database may contain user-defined data types, large objects (LOBs), external procedures, extensible indexing, query optimisation techniques and other features that are treated in the same way as built-in database features . The many extensibility options provided by the ORDBMS, however, raise several implementation challenges that are not always obvious. This thesis examines a few of the key challenges that arise when extending Oracle database with new functionality. To realise the potential of extensibility in Oracle, the thesis used the problem area of image retrieval as the main test domain. Current research efforts in image retrieval are lagging behind the required retrieval, but are continuously improving. As better retrieval techniques become available, it is important that they are integrated into the available database systems to facilitate improved retrieval. The thesis also reports on the practical experiences gained from integrating an extensible indexing scenario. Sample scenarios are integrated in Oracle9i database using the data cartridge mechanism, which allows Oracle database functionality to be extended with new functional components. The integration demonstrates how additional functionality may be effectively applied to both general and specialised domains in the database. It also reveals alternative design options that allow data cartridge developers, most of who are not database server experts, to extend the database. The thesis is concluded with some of the key observations and options that designers must consider when extending the database with new functionality. The main challenges for developers are the learning curve required to understand the data cartridge framework and the ability to adapt already developed code within the constraints of the data cartridge using the provided extensibility APls. Maximum reusability relies on making good choices for the basic functions, out of which specialised functions can be built. , KMBT_363 , Adobe Acrobat 9.54 Paper Capture Plug-in
- Full Text:
A comparison of web-based technologies to serve images from an Oracle9i database
- Authors: Swales, Dylan
- Date: 2004 , 2013-06-18
- Subjects: Active server pages , Microsoft .NET , JavaServer pages , Oracle (Computer file) , Internet searching , Web site development--Computer programs , World Wide Web , Online information services
- Language: English
- Type: Thesis , Masters , MSc
- Identifier: vital:4583 , http://hdl.handle.net/10962/d1004380 , Active server pages , Microsoft .NET , JavaServer pages , Oracle (Computer file) , Internet searching , Web site development--Computer programs , World Wide Web , Online information services
- Description: The nature of Internet and Intranet Web applications has changed from a static content-distribution medium into an interactive, dynamic medium, often used to serve multimedia from back-end object-relational databases to Web-enabled clients. Consequently, developers need to make an informed technological choice for developing software that supports a Web-based application for distributing multimedia over networks. This decision is based on several factors. Among the factors are ease of programming, richness of features, scalability, and performance. The research focuses on these key factors when distributing images from an Oracle9i database using Java Servlets, JSP, ASP, and ASP.NET as the server-side development technologies. Prototype applications are developed and tested within each technology: one for single image serving and the other for multiple image serving. A matrix of recommendations is provided to distinguish which technology, or combination of technologies, provides the best performance and development platform for image serving within the studied envirorunent. , KMBT_363 , Adobe Acrobat 9.54 Paper Capture Plug-in
- Full Text:
- Date Issued: 2004
Design of a performance evaluation tool for multimedia databases with special reference to Oracle
- Authors: Stakemire, Tonia
- Date: 2004
- Subjects: Oracle (Computer file) , Application software -- Evaluation , Database management -- Evaluation
- Language: English
- Type: Thesis , Masters , MSc
- Identifier: vital:4705 , http://hdl.handle.net/10962/d1015975
- Description: Increased production and use of multimedia data has led to the development of a more advanced Database Management System (DBMS), like an Object Relational Database Management System (ORDBMS). These advanced databases are necessitated by the complexity in structure and the functionality required by multimedia data. Unfortunately, no suitable benchmarks exist with which to test the performance of databases when handling multimedia data. This thesis describes the design of a benchmark to measure the performance of basic functionality found in multimedia databases. The benchmark, called MORD (Multimedia Object Relational Databases), targets Oracle, a well known commercial Object Relational Database Management System (ORDBMS) that can handle multimedia data. Although MORD targets Oracle, it can easily be applied to other Multimedia Database Management System (MMDBMS) as a result of a design that stressed its portability, and simplicity. MORD consists of a database schema, test data, and code to simulate representative queries on multimedia databases. A number of experiments are described that validate MORD and ensure its correct design and that its objectives are met. A by-product of these experiments is an initial understanding of the performance of multimedia databases. The experiments show that with multimedia data the buffer cache should be at least large enough to hold the largest dataset, a bigger block size improves the performance, and turning off logging and caching for bulk loading improves the performance. MORD can be used to compare different ORDBMS or to assist in the configuration of a specific database.
- Full Text:
- Date Issued: 2004