Closed

SQL,XML PROJECT

This project was awarded to Alinlish for $132 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
3
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

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online