Abstract
Data loading into RDBMS is a common phenomenon over decades. Over the years RDBMS has dominated in the enterprise world. Conventional file systems are seen to be replaced with popular RDBMS such as Oracle ®, UDB ®, and Sybase ® etc. This has necessitated the need for data loading while migrating from file systems to RDBMS. In some cases data loading is an everyday activity, for example, dataware housing projects involving data gathering, mining and analysis. No matter what type of data loading it may be, the goal is common i.e. how to achieve high speed in data loading for large sized table to minimize the down time. In this paper we are demonstrating how we can achieve high speed data loading into large RDBMS tables.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Loney, K., Koch, G.: Oracle8i: The Complete Reference, pp. 440 – 452 (2000) ISBN 0-07-041167-0
Oracle 9i Database Utilities, SQL *Loader Concept, http://download.oracle.com/docs/cd/B10501_01/server.920/a96652/ch03.htm#1004621 (retrieved on August 2011)
Branimir, P., Zoran, S.: Database Migration Using Standard Data Unload and Load Procedures On z/OS Platform, 259 – 266 (July 2007) 953-184-111-X
Gennick, J., McCullough-Dieter, C., Linker, G.-J.: Oracle8i DBA Bible, ch. 10. John Wiley & Sons (2000)
Schrag, R.: Load Your Data Faster (2005), http://www.dbspecialists.com/files/presentations/load_faster.html
Baer, H.: Partitioning with Oracle Database 11g Release 2 Oracle Corporation, USA (2010), http://www.oracle.com/technetwork/database/focus-areas/bi-datawarehousing/twp-partitioning-11gr2-2010-10-189137.pdf
Wikipedia, Multiprocessing (July 2011), http://en.wikipedia.org/wiki/Multiprocessing
Oracle, SQL*Loader Concepts, http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/ldr_concepts.htm#i1004652 (retrieved on August 2011)
Oracle, Partitioned Tables and Indexes, http://download.oracle.com/docs/cd/B10500_01/server.920/a96524/c12parti.html (retrieved August 2011)
Oracle, Oracle8i Utilities Release 8.1.5, SQL *Loader: Conventional and Direct Path Loads, Chapter 8, http://www.cs.umbc.edu/portal/help/oracle8/server.815/a67792/ch08.htm#1665 (retrieved August 2011)
CentOS, CentOS 5.4 Release Notes, http://wiki.centos.org/Manuals/ReleaseNotes/CentOS5.4 (retrieved August 2011)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 ICST Institute for Computer Science, Social Informatics and Telecommunications Engineering
About this paper
Cite this paper
Sahoo, P.R., Phalak, C. (2012). High Speed Data Loading for Large Sized RDBMS Tables. In: Das, V.V., Ariwa, E., Rahayu, S.B. (eds) Signal Processing and Information Technology. SPIT 2011. Lecture Notes of the Institute for Computer Sciences, Social Informatics and Telecommunications Engineering, vol 62. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-32573-1_48
Download citation
DOI: https://doi.org/10.1007/978-3-642-32573-1_48
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-32572-4
Online ISBN: 978-3-642-32573-1
eBook Packages: Computer ScienceComputer Science (R0)