sharmasapna / pubmed_datawarehousing

Data Warehouse creation using MySQL and R

Pubmed_datawarehousing

Steps involved:

1. Parsing the XMl data

2. Studying the various tabs

3. Making an ERD for the proposed realational database schema ERD:

   

4. Creating SQL tables in database

5. Extacting data from XML file in R data frames using Xpath

6. Inserting the data into SQL table with R command

7. Creaing the Snowflake Schema (Creation of Fact table and dimension tables)

8. Making the ERD of the snowflake schema ERD:

   

9. 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