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 300
- Downloads 0
Management information systems. A case study over the last eight years in the Romanian organizations
The present interest of this paper consists in the powerful impact that IT&C technologies have upon the development of the last 20 years of the Romanian organizations as well as upon the daily life of each individual...
Integrating XML Technology with Object-Relational Databases into Decision Support Systems
This paper presents some informatics technologies, like XML and object-relational databases, and the main motivations for implementing them in Decision Support Systems (DSS). Also, it is proposed and analyzed a con...
Database Access Through Java Technologies
As a high level development environment, the Java technologies offer support to the development of distributed applications, independent of the platform, providing a robust set of methods to access the databases, use...
Solutions for improving data extraction from virtual data warehouses
The data warehousing project’s team is always confronted with low performance in data extraction. In a Business Intelligence environment this problem can be critical because the data displayed are no longer available for...
SOA - An Architecture Which Creates a Flexible Link between Business Processes and IT
To be viable, a company must be adapted continously to the market’s requirements. The adaption of a company to the market’s requirements means also changes in the business processes of the firm. Till several years...