PL/SQL and Bind Variable: the two ways to increase the efficiency of Network Databases
Journal Title: Database Systems Journal - Year 2011, Vol 2, Issue 4
Abstract
Modern data analysis applications are driven by the Network databases. They are pushing traditional database and data warehousing technologies beyond their limits due to their massively increasing data volumes and demands for low latency. There are three major challenges in working with network databases: interoperability due to heterogeneous data repositories, proactively due to autonomy of data sources and high efficiency to meet the application demand. This paper provides the two ways to meet the third challenge of network databases. This goal can be achieved by network database administrator with the usage of PL/SQL blocks and bind variable. The paper will explain the effect of PL/SQL block and bind variable on Network database efficiency to meet the modern data analysis application demand.
Authors and Affiliations
Hitesh KUMAR SHARMA, Ranjit BISWAS, Faridabad Aditya SHASTRI
Keywords
Related Articles
- EP ID EP135570
- DOI -
- Views 337
- Downloads 0
Clustering Analysis for Credit Default Probabilities in a Retail Bank Portfolio
Methods underlying cluster analysis are very useful in data analysis, especially when the processed volume of data is very large, so that it becomes impossible to extract essential information, unless specific instrument...
A Framework for Semi-Automated Implementation of Multidimensional Data Models
Data warehousing solution development represents a challenging task which requires the employment of considerable resources on behalf of enterprises and sustained commitment from the stakeholders. Costs derive mostly fro...
PL/SQL and Bind Variable: the two ways to increase the efficiency of Network Databases
Modern data analysis applications are driven by the Network databases. They are pushing traditional database and data warehousing technologies beyond their limits due to their massively increasing data volumes and...
Database Replication
For someone who has worked in an environment in which the same database is used for data entry and reporting, or perhaps managed a single database server that was utilized by too many users, the advantages brought by dat...
Commercially Available Data Mining Tools used in the Economic Environment
This paper presents some of the most common commercially available data mining tools, with their most important features, side by side, and some considerations regarding the evaluation of data mining tools by companies t...