SQL,XML PROJECT

IN PROGRESS
Bids
3
Avg Bid (USD)
$186
Project Budget (USD)
$30 - $250

Project Description:
Learning Objectives: The purpose of Project 4 is to enable the students to gain experience with new wave of NOSQL (Not Only SQL) technologies for designing and querying (“Big Data”) databases. After completing Project 3, a student is expected to become competent in using XML for DB design; as well as gain elementary understanding of such NOSQL techniques and underlying ideas, such as MapReduce, Hadoop, PageRank, Hash Tables, B-trees, KVP DBs, Document Stores, etc.



2. Do one of the following projects.

3. Choose one of the 2 databases (DBs) you implemented in Project 1 – Project 3, (using ER model, RM model, SQL model: MySQL or SQLite), and re-design or re-engineer it into an XML database. Choose either DTD or XML Schema to specify the DB’s document schema.

4. Provide a DB Architecture that could potentially support the “Big Data” needs of a real-life institution or corporation. (Some suggestions are provided in Appendix A). Your design and architecture should include the following aspects, which will demonstrate that you have deeply thought about the issues involved and generated some insights:





5. Document and present your design as a report in the following form:
Title
Author
Date, Revision Number
Problem to Solve
XML DB or “Big Data DB Design”. (Provide details in an Appendix)
Discussion
Summary & Conclusions
Acknowledgments, (if any)
References, (if any)
Appendix:
(a) XML DB
Cross-reference ER and RM DB design
Semi-structured Model design
Document schemas (DTD or XML)
XML DB details: graphs or networks, tables

(b) “Big Data” DB


Appendix: Industry and Institutional Sectors and Organizations that can be used for “Big Data” DB design


US Department of Homeland Security
US INS (Immigration and Naturalization Service)
US IRS (Internal Revenue Service)
US FBI (Federal Bureau of Investigation)
US National Health Record Initiative
US DOD / Services (Army, Navy, Air Force, Coast Guard, or Marine)
A US CDC (Disaster or Disease) Early Warning Network
A US Federal Department (Health, Human Services, Education, Agriculture, Energy, State, …)
NATO
World Bank
UN Institution: (WHO, UNESCO, UNDP, etc.)
A UN (Disaster or Disease) Early Warning Network
Multinational Corporation (GE, ExxonMobil, GM, Toyota, WalMart, Boeing, AT&T, Verizon, Sony, Time Warner, American Airline, HSBC, American Express, …)
New York Stock Exchange
New York City (NYC) Government
US, any of the 50 states
Canada, any province
A populous country: China, India, Bangladesh, Japan, Brazil, Nigeria, Russia
A Bioinformatics DB
A Neuro-informatics Project
An Astronomy Informatics Project
A High-Energy Physics Project (LHC, …)
2013. Project 4: Spring 2013. CS 292. York College, CUNY Prof. Amenyo 3 / 3

Skills required:
MySQL
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 204
in 2 days
$ 132
in 6 days
$ 222
in 7 days