Starting in SQL 2016, two rivals entered the ring in a professional fight for format supremacy. XML seems too fat to compete with the newcomer JSON but a fight has begun. JSON doesn't seem experienced enough to have real punching power but does it have the speed to win? Who is the pound for pound format champion? Come watch this action-packed bo…
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
Intro to JSON
Intro to XML
.gitignore
1. Create table for and load raw data.sql
1a. Create XML character cleaning function.sql
2. Create tables and transform data.sql
JSONvsXML_SQLSaturday_Indy_2018.pptx
LICENSE
README.md
Round 1 - Size.sql
Round 2 - INSERT.sql
Round 3 - SELECT value.sql
Round 4 - SELECT fragment.sql
Round 5 - INSERT element.sql
Round 6 - UPDATE.sql
Round 7 - DELETE.sql
Round 8 - SELECT w index.sql
Scorecard.txt
review-example-product.txt
review-example.json
review-example.xml

README.md

XMLvsJSON

Starting in SQL 2016, two rivals entered the ring in a professional fight for format supremacy. XML seems too fat to compete with the newcomer JSON but a fight has begun. JSON doesn't seem experienced enough to have real punching power but does it have the speed to win? Who is the pound for pound format champion? Come watch this action-packed bout between two titans of SQL.

This project uses data from Amazon. It is over 600 MBs so just a link is provided.

Index URL: https://s3.amazonaws.com/amazon-reviews-pds/tsv/index.txt

File sizes change over time and are actively changing

Small file (75MB) https://s3.amazonaws.com/amazon-reviews-pds/tsv/amazon_reviews_us_Digital_Video_Games_v1_00.tsv.gz

Large file (over 1 GB) https://s3.amazonaws.com/amazon-reviews-pds/tsv/amazon_reviews_us_Electronics_v1_00.tsv.gz

Instructions on how to use the data are in sql script #1.