Aim
The main intention of the application is to evaluate the Object and Relational features of Oracle. Existing concept model of a current application is considered and the same is implemented in Oracle 9 and the extended SQL features are explored and compared with the standard SQL. The Oracle extensions to SQL can then be compared to the SQL standard’s extensions.
Changed Aim
To evaluate the Object and Relational features of Oracle by developing an application with extended SQL features and comparing with any standard SQL application.
Deliverable
Following aspects are derived while performing the research on the application.
- A running application that demonstrated the comparative aspects of SQL with Oracle 9 with standard extension of SQL.
- A database concept model with both the Object and Relational features of Oracle 9.
- A rich user interface to explore the advanced features of Oracle 9.
- A report to analyze the comparative results of Oracle 9 with standard SQL features.
Research question(s) These are weak and need to be changed
- What are the extended SQL features of Oracle 9 and how they play an important role in deciding the Object and Relational model of the database?
- How to develop a concept model that explains the comparative differences between SQL extensions of Oracle with standard SQL extensions?
Modified Research questions
- 1. What are the extended features of Oracle SQL and how they are related to Object and Relational model of a database?
- 2. How to use the conceptual model of a database to develop an application?
- 3. What are the object and relational model of oracle database?
- 4. How to create an application that integrates with multiple database?
Literature Review
In a typical data model, a pattern can be considered as set of objects or entities and their relationship and attributes. Proper customization of these entities could solve many design problems of many conceptual or logical databases .
A conceptual model represents the primary objects or entities of a database. Conceptual Data model of a database is initiated at the design phase of the project. A typical conceptual data model holds up to 10 to 20 data entities and their relationships .
Oracle 9 has many object and relational models like user defined data types. It has introduced a special data type known as abstract or user defined data type, where user has a choice in creating the required data type and these data types behaves like simple objects. Below example demonstrate a typical example of abstract data type .
Create or replace type person_address as Object (Streetnumber NUMBER, Streename VARCHAR(30), City VARCHAR(20), State VARCHAR(20));
Oracle 9 SQL has many added features that can query the database in an efficient manner when compared to standard SQL (Naney Greenberg, 2001). OR model of Oracle can be found in PLSQL implementation.
In any typical object-oriented database management system (OODBMS), the modelling and creation of data is treated in terms of objects and thus this typical modelling of database management system is known as Object oriented database management system. This object oriented implementation includes the instances of the objects formally know as classes of the corresponding objects. All sorts of class properties like methods, subclasses, inheritance, polymorphism and abstraction. Relational database can make use of these object oriented concepts. An object-oriented database interface standard is being developed by an industry group, the Object Data Management Group (ODMG). Any object-oriented database system must satisfy few considerations as below.
The first and foremost criteria should satisfy the five features like persistence, storage management activities consistency and recovery, concurrency, ad hoc query management and query processing techniques.
Object-relational mapping can be used to map the corresponding object-oriented programming objects to the relational databases managed by any of the typical database management systems like Oracle, SQL server, Sybase and some other relational database managers (RDBMS). Typical aspects like problem solving over the object and relational model can be easily resolved by using this implementation and thus process can be used to evaluate the performance of different products and their related comparison aspects.
All the famous programming languages like C#, C++ and java can be used to implement these object oriented features of database and these OR features can be integrated with these programming languages. Database objects appear as programming language objects. Interface of any typical object oriented database can be directly imported to these types of object-relational mapping products.
Object-relational mapping can be used in variety of cases like implementing a database across the large enterprise databases and this can be used to measure the persistence of the database. Following are few transparent aspects where the RDMS is used widely.
- Maintaining consistency across one or more Relational Databases.
- RDMS can be used for both the technical and political reasons across the enterprise database.
Programming code can be reduced across any business logic by using this object-relational mapping model and this is accomplished by caching and introduction of embedded SQL features or JDBC-ODBC interface. Even the cost performance can be easily evaluated by using these object relational models by using the transparent features of the database .
Research Method (Quantitative and qualitative methods need to be more specific)
Both qualitative and quantitative methods are adopted to implement the research method. All the latest features of Oracle 9i are scientifically investigated by a proper quantitative methodology. Large data sets are considered and queried based on the quantitative statistics. Behaviour of the database with the introduction of Oracle 9i SQL can be studied by the qualitative techniques and few issues related to why the conceptual model should be done with Oracle DBMS can be studied. A front end application is developed with proper database design and the performance of the application is measured with respective to the query processing speed.
A multiple set of queries are introduced on the database to typical database operations like data insertions and data retrieval. A statistical analysis is done on the query processing performance of a basic SQL queries and extended SQL features of Oracle 9 and the comparison results are used to evaluate the performance of the application.
Following research methods are used to develop the application with the help of conceptual model of database and extended features of SQL of Oracle 9i
- Developing simple database application with extended Oracle SQL and comparing with another simple database application
- Preparing a standard questioner to compare the features of standard SQL and extended SQL features of Oracle 9i
- Number of articles and journals are referred to understand the Object and Relational model of a database and to create a conceptual model of a database
- Online articles and case studies of Oracle corporation are referred to create the database application with the extended SQL features
- Metadata of different database are compared and analysed to list out all the comparison factors.
- Technical aspects of the application like compression and hiding of the data and image processing techniques are evaluated with the help of online research.
Evaluation
Evaluation can be done by considering a typical conceptual model developed in standard SQL and thus enhancing the same with introduction of Object/Relational model of Oracle 9. The results are tested across and query performance is evaluated. SQL extensions like user defined or abstract data types are applied on the existing conceptual model and thus evaluating the performance of the Database management system. These results can be compared across the standard SQL. The front end design of the application can be done with any of the popular programming languages like java and the backend can take multiple forms. A simple database application with standard SQL features like create, insert, modify and delete operations is developed with all the possible database operation like insertion, updating and deletion and at the same time the performance of the application is evaluated against the query processing speed and for achieving this any database with standard SQL operations like Oracle 8 or SQL server can be used.
To evaluate the performance of the application with introduction to the extended SQL operations of Oracle 9, the same application is modified such that all the extended Object and Relational features of oracle are integrated to the application and thus a comparison methodology is developed. The design of the application should be in a manner such that there should be a scope to implement all these features. Extended features of SQL are best evaluated at the conceptual model level and the same are implemented across the application and even XML features of Oracle can be best evaluated with this implementation. The comparison and evaluation process can be initiated at the conceptual database level and backend database design level.
Hardware/software needed
Software Requirements
Operating System : Windows XP or 2000 advanced server
Front-end : Java
Editors : Edit Plus or Net beans
Hardware Requirements
Processor : Pentium 80386 microprocessor or higher
Main Memory : 128 MB or higher
Hard Disk : 40 GB or higher