In Progress

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:



Date, Revision Number

Problem to Solve

XML DB or “Big Data DB Design”. (Provide details in an Appendix)


Summary & Conclusions

Acknowledgments, (if any)

References, (if any)


(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, …)


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: MySQL

See more: xml sql, xml services, world learning, world education services, us department of state, us department of energy, us department of education, us army, us air force, UNDP, trees graphs, trees and graphs, toyota of york, toyota canada, the world bank, the department of energy, s.c. department of revenue, s.c. department of education, physics services, one coast, nyc department of education, new york life, new york city department of education, new country toyota, network engineer services

Project ID: #4484925

Awarded to:


I can help you with this project. Thank you.

$132 USD in 6 days
(1 Review)

3 freelancers are bidding on average $186 for this job


I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$204 USD in 2 days
(57 Reviews)

Very Interested .....

$222 USD in 7 days
(0 Reviews)