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 324
- Downloads 0
Architecture of Automated Database Tuning Using SGA Parameters
Business Data always growth from kilo byte, mega byte, giga byte, tera byte, peta byte, and so far. There is no way to avoid this increasing rate of data till business still running. Because of this issue, database...
Integrated Information System for Higher Education Qualifications
In the present article we aim to study thoroughly and detail aspects related to architectures specific for e-learning and management of human resources training interconnected to management of qualifications. In addition...
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...
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...
Perspectives on the Role of Business Rules in Database Design
Business rules are at the foundation of every information system as they drive and offer guidelines for managing and conducting all activities within an organizations. They are important both for operational system...