Concept of schema, a) Given a particular blog post, what

Concept of schema

Assignment Help Database Management System

Reference no: EM13725847

Consider the following HBase table design for blogs. On the website, logged in users (who all have a unique, integer user ID may comment on blog posts.

		Cf: meta			Cf: comments
post11356	user: 3		content: …	1: <uid, comment>		2: <uid, comment>
post11357	user: 7		content: …
post11358	user: 5		content: …	1: <uid, comment>
post11359	user: 3		content: …	1: <uid, comment>		2: <uid, comment>

For each query below, state either YES or NO the schema is optimal for that query. If you state NO, re-design the schema (copy the table above and modify it, then explain in English what is different with the new schema) so it is optimal for that specific query.

a) Given a particular blog post, what are all of the comments associated with it?yes
b) What are the blog posts for a particular user?
c) What comments has a particular user posted?
d) Deleting a particular blog post and all related data.

Reference no: EM13725847

Questions Cloud

What impact on their profitability and customer satisfaction : It has been suggested that marketing has evolved from the early days of the production orientation to today's societal marketing concept. what impact might this have on their profitability and customer satisfaction/retention

Compare across individuals at difierent points in time : Compare across individuals at difierent points in time. Include the data for GDP - Compare thc results collected about your parent to the onc about yourself by constructing three graphs using Excel

Lmx theory leadership maanagement exchange : As a supervisor how would you explain the LMX theory leadership maanagement exchange? In terms of job responsibility.

Cost of non-core responsibilities : If it is true that business is a profit making enterprise, then how do we weigh the cost of non-core responsibilities, such as those termed "corporate social responsibility," with the loss of profit that those activities entail?

Concept of schema : a) Given a particular blog post, what are all of the comments associated with it?yes b) What are the blog posts for a particular user?

Analyze the buying process for an online product : The Buying Process: Every product or service has a buying process, even digital products and services. In this assignment, you will research and analyze the buying process for an online product or service

Difference between phi and the privacy act : Discuss three examples how HIPAA is taught, practiced, and enforced in a health care organization. What is HIPAA and why it should be followed? Determine if there is a difference between PHI and the Privacy Act.

Explain the concept of aggregate demand management : Explain the concept of aggregate demand management and give a description of how it is used - aggregate demand management to help close gaps in the economy

Advantages and disadvantages of using these social networks : For targeting new customers, examine the advantages and disadvantages of using these social networks compared to search engine advertising

User Account

All Pages