Bulk Data Extraction, Validation and Processing of Records in a Spreadsheet File Using PL/SQL Constructs

International Journal of Computer Trends and Technology (IJCTT)          
© 2015 by IJCTT Journal
Volume-24 Number-2
Year of Publication : 2015
Authors : Bharath B U, Dr. C N Ravikumar


Bharath B U, Dr. C N Ravikumar "Bulk Data Extraction, Validation and Processing of Records in a Spreadsheet File Using PL/SQL Constructs". International Journal of Computer Trends and Technology (IJCTT) V24(2):54-56, June 2015. ISSN:2231-2803. www.ijcttjournal.org. Published by Seventh Sense Research Group.

Abstract -
Traditionally, many stakeholders keep their information in spreadsheet sheets (.xls or .ods extension). Instead of changing the traditional way of storing the data in excel sheet by these users, the paper presented here, will allow them to store data in the spreadsheets and the API’s written, will directly fetch the data from the excel sheets and store it in the main tables of the database system. This will be friendlier to the users and one Spreadsheet Upload will enter all the valid records into the base tables of their database, thus improving the lead time optimization [8].

[1] Oracle Supply Chain Management: http://www.oracle.com/us/industries/retail/oracle-retail-supply-chainbr- 1596185.pdf
[2] PL/SQL Overview: http://docs.oracle.com/cd/B2835901/appdev.111/b28370/overview.htm #LNPLS00103
[3] Overview of LOB Datatypes: http://docs.oracle.com/cd/B1930601/server.102/b14220/datatype.htm#i 3237
[4] PL/SQL data compression utilities: http://docs.oracle.com/cd/B1930601/appdev.102/b14258/ucompr.htm# BGBBCDDI
[5] PL/SQL XMLType objects: http://docs.oracle.com/cd/B1930601/appdev.102/b14258/d xmldom.htm#i1076719
[6] M. Erwig, “Software Engineering for Spreadsheets”, IEEE Software, vol.29, no. 5, pp. 2530, 2009.
[7] S. DAVIDOFF, “Big data analytics”, https://class.coursera.org/bigdataschool-001
[8] CAI, Yiping; ZHANG, Meng fang; HUANG, Liang: “Safety Stock Management Based on Lead Time Optimization”, Electric Technology and Civil Engineering (ICETCE), Issue Date: 22-24 April 2011.
[9] Oracle Data Sheet: Retail Merchandising System. http://www.oracle.com/us/products/applications/047076.pdf
[10] Oracle Data Sheet: Merchandise Operations Management. http://www.oracle.com/us/products/applications/046458.pdf
[11] Lei Wu, Houari Sahraoui, Petko Valtchev: “Coping with Legacy System Migration Complexity”, 10th IEEE International Conference on Engineering of Complex Computer Systems (ICECCS05).
[12] Jean Henrard and Didier Roland, ReveR S.A; Anthony Cleve and Jean- Luc Hainaut, University of Namur: “An Industrial Experience Report on Legacy Data-Intensive System Migration”, ICSM 2007.
[13] Maulahikmah Galinium, University of Rome Tor Vergata Rome, Italy; Negar Shahbaz, Lund University; HUANG, Liang: “Success Factors Model: Case Studies in the Migration of Legacy Systems to Service Oriented Architecture”, Ninth International Joint Conference on Computer Science and Software Engineering (JCSSE), 2012.
[14] Michael Shapiro & Ethan Miller, University of Maryland at Baltimore County: “Managing Databases with Binary Large Objects”, IEEE’99.
[15] Oracle Database Concepts 11g Release 2 (11.2), April 2015, https://docs.oracle.com/cd/B28359 01/server.111/b28318.pdf
[16] Chandrasekar, Sivansankaran, et al. “Efficient piece-wise updates of binary encoded XML data.” U.S. Patent Application 11/437,512.
[17] Pratima Bhat, Bushra Alam, Shankaraiah, Karamjit Kaur: “Online spreadsheet Editor - A Migration Solution from Oracle Forms to ADF”, International Journal of Computer Trends and Technology (IJCTT) – volume 22 Number 2 – April 2015.

PL/SQL, Bulk Data Upload, Data Extraction, BLOB data type, CRUD operations.