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 338
- Downloads 0
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...
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...
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...
Spatial Operations
This paper contains a brief description of the most important operations that can be performed on spatial data such as spatial queries, create, update, insert, delete operations, conversions, operations on the map or...
Security Aspects for Business Solution Development on Portal Technology
In the scope of portal development, in order to talk about security issues, concerns, and solutions, it is necessary to define a few terms: authentication, authorization, Single Sign-On (SSO), confidentiality, integrity,...