Search Service Application

System Overview

I developed a Java database application for users to query on Yelp restaurant dataset

create table (create_table.sql)
import both populate.java and hw3.java into java IDE;
add external libraries:
- json.jar // json parsing java library
- ojdbc6.jar // oracle database driver library
- swingx-all-1.6.4.jar // java GUI library
- rs2xml.jar // GUI table generator library
compile populate.java;
pass arguments into populate.class and run (arguments: yelp_business.json, yelp_review.json, yelp_checkin.json, yelp_user.json)
add index to the tables (create_index.sql)
complie and run hw3.java
use java GUI to query
drop table (drop_table.sql)