1) Identify which type of database/data processing system you would choose (Key-Value store,Column-oriented store, Document-oriented store, Graph database, Relational database,Streaming engine) in each scenario below.2)a) Highly structured multi-table data that requires enforcing data constraints.b) Stock market data ticker with decisions that must be made in real time.c) LinkedIn type data with interconnected nodes where much of the information resides inthe links between nodes.d)e)f)An image storage system that allows lookup images by file name.A collection of JSON objects (e.g., tweets).Data that is stored in large sparse tables that are continuously growing (newrows/columns).a) Consider the following graphBCompute the page rank for the nodes in this graph. If you are multiplying matrices manually,you may stop computing after 6 steps. If you use a tool (e.g., Matlab, python) for matrixmultiplication, you should get your answer to converge.b) Now consider a graph with dead-end nodes Q and Z:What is the page rank of Q?What is the page rank of Z?XZZ c) Exercise 5.1.6 from Mining of Massive Datasets...Figure 5.9: A chain of dead endsExercise 5.1.6: Suppose we recursively eliminate dead ends from the graph,solve the remaining graph, and estimate the PageRank for the dead-end pagesas described in Section 5.1.4. Suppose the graph is a chain of dead ends, headedby a node with a self-loop, as suggested in Fig. 5.9. What would be the Page-Rank assigned to each of the nodes?3) Given the input data [(1pm, $8), (2pm, $16), (3pm, $17), (4pm, $26), (5pm, $12), (6pm,$22), (7pm, $23), (8pm, $22), (9pm, $24), (10pm, $28), (11pm, $26), (12am, $30)].a) What will the Hive query "compute average price" return? (yes, this question is asobvious as it seems, it is asked for comparison with part-b and part-c)b) What will a Storm streaming query "compute average price per each 3 hour window"return? (tumbling, i.e., non-overlapping window of tuples). For example, the first windowwould 1pm-4pm. Second window would be 4pm-7pm. If you are wondering aboutoverlap, I recommend defaulting to [1pm-4pm) [4pm-7pm). (i.e., including first but notlast part of the time range).c) What will a Storm query "compute average price per each 3 hour window" return?(sliding, i.e. overlapping window of tuples, moving the window forward 2 hours eachtime). First window is 1pm-4pm, second window is 3pm-6pm and so on.NOTE: when Storm does not have a full window, you cannot output anything until thewindow fills with data.

“Since you have posted multiple questions, we will provide the solution only to the first question…

1) Identify which type of database/data processing system you would choose (Key-Value store, Column-oriented store, Document-oriented store, Graph database, Relational database, Streaming engine) in each scenario below. a) Highly structured multi-table data that requires enforcing data constraints. b) Stock market data ticker with decisions that must be made in real time. c) LinkedIn type data with interconnected nodes where much of the information resides in the links between nodes. d) An image storage system that allows lookup images by file name. e) A collection of JSON objects (e.g., tweets). f) Data that is stored in large sparse tables that are continuously growing (new rows/columns).

1) Identify which type of database/data processing system you would choose (Key-Value store, Column-oriented store, Document-oriented store, Graph database, Relational database, Streaming engine) in each scenario below. a) Highly structured multi-table data that requires enforcing data constraints. b) Stock market data ticker with decisions that must be made in real time. c) LinkedIn type data with interconnected nodes where much of the information resides in the links between nodes. d) An image storage system that allows lookup images by file name. e) A collection of JSON objects (e.g., tweets). f) Data that is stored in large sparse tables that are continuously growing (new rows/columns).

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

I need the answer as soon as possible
Logical data flow diagrams demonstrate data flow logically, unlike physically organized ones. MetaData—a data warehouse's most important component? What's so crucial?
Explore the concept of a multi-model database architecture and provide examples of scenarios where it is beneficial.
Describe the advantages of sharding in a distributed database system and the challenges associated with maintaining data consistency across shards.
TRUE OR FALSE. 1. In a flat-file model, data are stored in a a common data repository and are shared by other users in the organization. 2. In database system, data redundancy is eliminated, as data elements are stored only once. 3. A single change in all data attributes is automatically made available to all users who are using a traditional distributed data processing system 4. REA system models are highly structured and are created to suit the needs of the users. For accounting, it is structured to comply with the requirements of GAAP. 5. Bolt-ins is an additional software application connected to the ERP systems to handle unique business functions. 6. The primary key of one database table becomes the primary key of another database table. The REA model requires that accounting phenomena be characterized in a manner consistent with the development of multiple user views. 8. In flat-file or non-REA database systems, the two events would be recorded in a set of 7. classic accounts. 9.…
Identify and determine when it is appropriate to utilize a 1:M and a M:M relationship in a database
Define ETL (Extract, Transform, Load) in the context of data warehousing and its significance.
1b)By using a scenario, explain program-data dependence issue found in previous database technologies such as file-oriented database before relational database model was introduced.
Assume that your task is creating a data warehouse for a mailing Post office which consists of different dimensions (at least 4 dimensions). a) Design a multidimensional database using a star schema for a mailing post office data warehouse. b) What type of information could that data warehouse produce. Give 3 different examples of information.
Provide one advantage and one disadvantage for each of the database models.
Explain the concept of "stream chaining" and provide examples of scenarios where it can be beneficial in data processing.
Use of a single data model for conceptual and logical design has many benefits versus utilizing two separate models. E-R and relational database models, for instance....