Implementation of Timesten in Oracle Database. Case Study of Admission Office - Sudan

Abstract

Timesten is an in-memory relational database software product from Oracle Corporation. Timesten is designed for low latency, high-volume data, event and transaction management. Unlike disk-optimized relational databases such as the Oracle database, DB2, Informix, and SQL Server, Timesten’s data is located entirely in memory; no disk I/O is required for query operations. As memory is faster than hard disk, Timesten is used in applications where Service level agreements require very fast and predictable response time, such as network equipment, telecommunication, real-time financial services trading applications, and large web applications. Unlike custom-built memory structures such as Hash tables, Timesten is a relational database that is accessed with standard ODBC and JDBC, providing the rich functionality of the SQL query language. This study is to help the public administration of acceptance and evaluation and documentation to improve the database performance, reducing the memory and CPU requirements and to eliminate the response time of the query. The result of implementing Timesten in oracle database, is bringing the admission data closer to the application, and processing queries in an in-memory Relational Database Management System (RDBMS), which reduces response time significantly. By offloading some of the data processing work from the database server, it improves overall throughput.