Steps involved:
-
Parsing the XMl data
-
Studying the various tabs
-
Making an ERD for the proposed realational database schema ERD:
-
Creating SQL tables in database
-
Extacting data from XML file in R data frames using Xpath
-
Inserting the data into SQL table with R command
-
Creaing the Snowflake Schema (Creation of Fact table and dimension tables)
-
Making the ERD of the snowflake schema ERD:
-
Data Mining and Visualization
9.1 Creating Summary Fact Tables ERD:
9.2 Visualising the Data for seasonal Patterns in Journal Publication Some visualizations are here
