Write a program that loads the given xml documents

Assignment Help PL-SQL Programming

Reference no: EM132654365

Write a program that parses a given XML document in a file (in next page) using any existing XML parser that supports DOM to do the followings:
a) Extract data from the document and
b) Transforms the data into structured text files in CSV/TBS and/or into tables in a SQL database.

For this task,

1) Check the links given above to learn about DOM and an existing XML parser (ex: DOM parse, MSXML parser, or SAX Parser)

1) Download any available XML parser that supports DOM library (ex: DOM/MSXML into VS or DOM/SAX Parser for Java) to set up

2) Write a program that loads the given XML documents in a file (in next page) as input and parses to extract terminal data to write into an output file.

3) Write Stored Procedures to read data from the files and then store them in the tables in database

4) For this task, you need to have a mapping strategy to carry the relationships in XML to write data into the output files then store them into tables

Use the following XML document as an input file. Assume that you have <bibs> as a root element and you can assume you have a root in the input file as you need.
Automatic database table creation in a SQL Server in your program using JDBC/ODBC is recommended.

This lab is to learn how to handle a multivalued columns, nested and irregular data in semi-structured data to transform them to a correct relational database scheme, which is a common task in real life applications.

There are many ways to transform XML to Table structures. You are to design a correct database scheme to convert the XML data to table structures.

Two common ways could be:
I. One Way:
1) Create a big dirty table in CSV in your program and
2) Create multiple tables in correct scheme reading from the big table in a Stored Procedure in a SQL Server.
II. Another Way
1) Design a scheme (multiple CSV file formats) and create multiple CSV files in your program and
2) Create database tables directly from each CSV in a Stored Procedure in a SQL Server.

Design your CSV file formats. There is no one strict file format as a solution. Think about what would be a good database scheme (structure) to transform those irregular multi valued data or nested data to a table (or connected multiple tables) so that you can retrieve them from a database easily and efficiently without losing information. As long as it is transformed to a correct database scheme without losing data, it would be good for this lab.

Attachment:- LAB-4.rar

Reference no: EM132654365

Questions Cloud

Find and provide the journal entries necessary to account : Provide the journal entries necessary to account for all the above transactions and events up to 1 July 2023, in accordance with AASB 116

How overhead variances useful in non manufacturing setting : How can variance analysis be used in an activity-based costing system? How are overhead variances useful in non manufacturing settings?

What variances can be calculated for fixed overhead costs : What is the most detailed way for a company to reconcile actual overhead incurred with the amount allocated during a period.?

How are budgeted variable overhead and fixed overhead cost : How are budgeted variable overhead and fixed overhead cost rates calculated? What variances can be calculated for variable overhead costs?

Write a program that loads the given xml documents : Write a program that loads the given XML documents in a file (in next page) as input and parses to extract terminal data to write into an output file

Public leadership and public and private goods : Propose two actions that a public leader can take in order to balance human capital and social capital without jeopardizing the culture

Find what is small portion of the net incom : What is Small's portion of the net income? What is Big's portion of the net income? Make the entry for this allocation. The partnership's net income is $100,000

What wachowski industries would be showing : On October 31, before wachowski industries prepared their month end adjusting entries, Before any accounts were adjusted, wachowski industries would be showing

Prepare the debit-credit analysis for each transaction : Prepare the debit-credit analysis for each transaction. (If no entry is required, select "No Entry" for the account titles and enter 0 for the amounts.)

User Account

All Pages