Majid Khan | SZABIST (szabist.edu.pk) (original) (raw)
Uploads
IJCSIS Papers by Majid Khan
Data is considered as a more valuable asset than the hardware and software. For the efficient ret... more Data is considered as a more valuable asset than the hardware and software. For the efficient retrieval and processing of this data, various database systems have been developed to store it in structured form. Most of the time, we need SQL which returns the retrieved results in the form of pages each consisting of multiple records. Paging Query efficiency of large datasets has a direct impact on application systems performance. The major bottleneck of most of the large databases which affect paging query is the volume of data returned to the database server from storage. When there is a full table scan involved, the transfer time of large data between the storage media and the database servers may affect the efficiency. In this paper, an optimized solution for paging query is presented including the key technologies of paging query efficiency using Oracle 11g platform. Oracle 11g is considered as the most elegant, innovative and high concurrent database system which delivers high quality of services and has raised the pinnacle of the IT world on the other virtues. The proposed model is based on the database optimization, SQL optimization and offloading concept. Apart from the classic database systems, only the data required by the client will be returned to the database instance from storage instead of unnecessary huge volume of data. Moving SQL processing off the database server frees server CPU cycles and eliminates a massive amount of unproductive I/O transfer. All these resources become free to provide better services to the other user requests. In this way, the queries run much faster and more of them can be processed in a shorter span of time. The validation of the proposed solution proves effectiveness and efficiency of the model. The experimental results are also reported in this paper.
Data is considered as a more valuable asset than the hardware and software. For the efficient ret... more Data is considered as a more valuable asset than the hardware and software. For the efficient retrieval and processing of this data, various database systems have been developed to store it in structured form. Most of the time, we need SQL which returns the retrieved results in the form of pages each consisting of multiple records. Paging Query efficiency of large datasets has a direct impact on application systems performance. The major bottleneck of most of the large databases which affect paging query is the volume of data returned to the database server from storage. When there is a full table scan involved, the transfer time of large data between the storage media and the database servers may affect the efficiency. In this paper, an optimized solution for paging query is presented including the key technologies of paging query efficiency using Oracle 11g platform. Oracle 11g is considered as the most elegant, innovative and high concurrent database system which delivers high quality of services and has raised the pinnacle of the IT world on the other virtues. The proposed model is based on the database optimization, SQL optimization and offloading concept. Apart from the classic database systems, only the data required by the client will be returned to the database instance from storage instead of unnecessary huge volume of data. Moving SQL processing off the database server frees server CPU cycles and eliminates a massive amount of unproductive I/O transfer. All these resources become free to provide better services to the other user requests. In this way, the queries run much faster and more of them can be processed in a shorter span of time. The validation of the proposed solution proves effectiveness and efficiency of the model. The experimental results are also reported in this paper.