Imagine you are designing a table to store recent transactions for an online shopping platform and...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Imagine you are designing a table to store recent transactions for an online shopping platform and there are 1 trillion transactions. You want to record the following information: • user id • user name • item id • item name • transaction id • amount of money ($) for the transaction (e.g. $4.11, $670.50, etc) Assume there are 1 billion users, and 1 billion items for sale on the platform. The longest string for user and item names contain 64 characters. You should consider proper data types listed below: byte, short, int, long, float, double, boolean, char. Question 4.1 What data type should you use for each column? You need to fill one of the following data types: byte, short, int, long, float, double, boolean, char. You need to select the most suitable data type for each column by considering efficiency. You are not required to add the number of the data types used for the column. For instance, you only need to put char for char[10]. What is the most appropriate data type for the following column: User ID? Question 4.2 What is the most appropriate data type for the following column: User Name? Question 4.3 What is the most appropriate data type for the following column: Item ID? Question 4.4 What is the most appropriate data type for the following column: Item Name? Question 4.5 What is the most appropriate data type for the following column: Transaction ID? Question 4.6 What is the size of each row in bytes, based on the previous parts? Note: Use float for the 'Amount of money' column. Question 4.7 What is the size of the table in TB? Problem 5 This question follows from question 4. Question 5.1 How long in seconds will it take to read the whole table from RAM? Assume that the size of the table is 200 TB. Question 5.2 How long in hours will it take to read the whole table from SSD if each row is randomly stored in the SSD? Assume 1 trillion rows and 200 TB. Question 5.3 How long in hours will it take to read the whole table from SSD if the table is stored in 64MB blocks? Assume that the size of the table is 200 TB. Question 5.4 How long in days (round to nearest integer) will it take to read the whole table from HDD if each row of the table is stored randomly in the HDD? Assume 1 trillion rows and 200 TB. Question 5.5 How long in days (round to nearest integer) will it take to read the whole table from HDD if the table is stored in 4x64MB blocks? Assume that the size of the table is 200 TB. Question 5.6 What is the cost in dollars for saving the table in RAM? Assume RAM costs $100/32GB and the size of the table is 200 TB. Question 5.7 What is the cost in dollars for saving the table in HDD? Assume HDD space costs $25/TB and the size of the table is 200 TB. Imagine you are designing a table to store recent transactions for an online shopping platform and there are 1 trillion transactions. You want to record the following information: • user id • user name • item id • item name • transaction id • amount of money ($) for the transaction (e.g. $4.11, $670.50, etc) Assume there are 1 billion users, and 1 billion items for sale on the platform. The longest string for user and item names contain 64 characters. You should consider proper data types listed below: byte, short, int, long, float, double, boolean, char. Question 4.1 What data type should you use for each column? You need to fill one of the following data types: byte, short, int, long, float, double, boolean, char. You need to select the most suitable data type for each column by considering efficiency. You are not required to add the number of the data types used for the column. For instance, you only need to put char for char[10]. What is the most appropriate data type for the following column: User ID? Question 4.2 What is the most appropriate data type for the following column: User Name? Question 4.3 What is the most appropriate data type for the following column: Item ID? Question 4.4 What is the most appropriate data type for the following column: Item Name? Question 4.5 What is the most appropriate data type for the following column: Transaction ID? Question 4.6 What is the size of each row in bytes, based on the previous parts? Note: Use float for the 'Amount of money' column. Question 4.7 What is the size of the table in TB? Problem 5 This question follows from question 4. Question 5.1 How long in seconds will it take to read the whole table from RAM? Assume that the size of the table is 200 TB. Question 5.2 How long in hours will it take to read the whole table from SSD if each row is randomly stored in the SSD? Assume 1 trillion rows and 200 TB. Question 5.3 How long in hours will it take to read the whole table from SSD if the table is stored in 64MB blocks? Assume that the size of the table is 200 TB. Question 5.4 How long in days (round to nearest integer) will it take to read the whole table from HDD if each row of the table is stored randomly in the HDD? Assume 1 trillion rows and 200 TB. Question 5.5 How long in days (round to nearest integer) will it take to read the whole table from HDD if the table is stored in 4x64MB blocks? Assume that the size of the table is 200 TB. Question 5.6 What is the cost in dollars for saving the table in RAM? Assume RAM costs $100/32GB and the size of the table is 200 TB. Question 5.7 What is the cost in dollars for saving the table in HDD? Assume HDD space costs $25/TB and the size of the table is 200 TB. Imagine you are designing a table to store recent transactions for an online shopping platform and there are 1 trillion transactions. You want to record the following information: • user id • user name • item id • item name • transaction id • amount of money ($) for the transaction (e.g. $4.11, $670.50, etc) Assume there are 1 billion users, and 1 billion items for sale on the platform. The longest string for user and item names contain 64 characters. You should consider proper data types listed below: byte, short, int, long, float, double, boolean, char. Question 4.1 What data type should you use for each column? You need to fill one of the following data types: byte, short, int, long, float, double, boolean, char. You need to select the most suitable data type for each column by considering efficiency. You are not required to add the number of the data types used for the column. For instance, you only need to put char for char[10]. What is the most appropriate data type for the following column: User ID? Question 4.2 What is the most appropriate data type for the following column: User Name? Question 4.3 What is the most appropriate data type for the following column: Item ID? Question 4.4 What is the most appropriate data type for the following column: Item Name? Question 4.5 What is the most appropriate data type for the following column: Transaction ID? Question 4.6 What is the size of each row in bytes, based on the previous parts? Note: Use float for the 'Amount of money' column. Question 4.7 What is the size of the table in TB? Problem 5 This question follows from question 4. Question 5.1 How long in seconds will it take to read the whole table from RAM? Assume that the size of the table is 200 TB. Question 5.2 How long in hours will it take to read the whole table from SSD if each row is randomly stored in the SSD? Assume 1 trillion rows and 200 TB. Question 5.3 How long in hours will it take to read the whole table from SSD if the table is stored in 64MB blocks? Assume that the size of the table is 200 TB. Question 5.4 How long in days (round to nearest integer) will it take to read the whole table from HDD if each row of the table is stored randomly in the HDD? Assume 1 trillion rows and 200 TB. Question 5.5 How long in days (round to nearest integer) will it take to read the whole table from HDD if the table is stored in 4x64MB blocks? Assume that the size of the table is 200 TB. Question 5.6 What is the cost in dollars for saving the table in RAM? Assume RAM costs $100/32GB and the size of the table is 200 TB. Question 5.7 What is the cost in dollars for saving the table in HDD? Assume HDD space costs $25/TB and the size of the table is 200 TB. Imagine you are designing a table to store recent transactions for an online shopping platform and there are 1 trillion transactions. You want to record the following information: • user id • user name • item id • item name • transaction id • amount of money ($) for the transaction (e.g. $4.11, $670.50, etc) Assume there are 1 billion users, and 1 billion items for sale on the platform. The longest string for user and item names contain 64 characters. You should consider proper data types listed below: byte, short, int, long, float, double, boolean, char. Question 4.1 What data type should you use for each column? You need to fill one of the following data types: byte, short, int, long, float, double, boolean, char. You need to select the most suitable data type for each column by considering efficiency. You are not required to add the number of the data types used for the column. For instance, you only need to put char for char[10]. What is the most appropriate data type for the following column: User ID? Question 4.2 What is the most appropriate data type for the following column: User Name? Question 4.3 What is the most appropriate data type for the following column: Item ID? Question 4.4 What is the most appropriate data type for the following column: Item Name? Question 4.5 What is the most appropriate data type for the following column: Transaction ID? Question 4.6 What is the size of each row in bytes, based on the previous parts? Note: Use float for the 'Amount of money' column. Question 4.7 What is the size of the table in TB? Problem 5 This question follows from question 4. Question 5.1 How long in seconds will it take to read the whole table from RAM? Assume that the size of the table is 200 TB. Question 5.2 How long in hours will it take to read the whole table from SSD if each row is randomly stored in the SSD? Assume 1 trillion rows and 200 TB. Question 5.3 How long in hours will it take to read the whole table from SSD if the table is stored in 64MB blocks? Assume that the size of the table is 200 TB. Question 5.4 How long in days (round to nearest integer) will it take to read the whole table from HDD if each row of the table is stored randomly in the HDD? Assume 1 trillion rows and 200 TB. Question 5.5 How long in days (round to nearest integer) will it take to read the whole table from HDD if the table is stored in 4x64MB blocks? Assume that the size of the table is 200 TB. Question 5.6 What is the cost in dollars for saving the table in RAM? Assume RAM costs $100/32GB and the size of the table is 200 TB. Question 5.7 What is the cost in dollars for saving the table in HDD? Assume HDD space costs $25/TB and the size of the table is 200 TB. Imagine you are designing a table to store recent transactions for an online shopping platform and there are 1 trillion transactions. You want to record the following information: • user id • user name • item id • item name • transaction id • amount of money ($) for the transaction (e.g. $4.11, $670.50, etc) Assume there are 1 billion users, and 1 billion items for sale on the platform. The longest string for user and item names contain 64 characters. You should consider proper data types listed below: byte, short, int, long, float, double, boolean, char. Question 4.1 What data type should you use for each column? You need to fill one of the following data types: byte, short, int, long, float, double, boolean, char. You need to select the most suitable data type for each column by considering efficiency. You are not required to add the number of the data types used for the column. For instance, you only need to put char for char[10]. What is the most appropriate data type for the following column: User ID? Question 4.2 What is the most appropriate data type for the following column: User Name? Question 4.3 What is the most appropriate data type for the following column: Item ID? Question 4.4 What is the most appropriate data type for the following column: Item Name? Question 4.5 What is the most appropriate data type for the following column: Transaction ID? Question 4.6 What is the size of each row in bytes, based on the previous parts? Note: Use float for the 'Amount of money' column. Question 4.7 What is the size of the table in TB? Problem 5 This question follows from question 4. Question 5.1 How long in seconds will it take to read the whole table from RAM? Assume that the size of the table is 200 TB. Question 5.2 How long in hours will it take to read the whole table from SSD if each row is randomly stored in the SSD? Assume 1 trillion rows and 200 TB. Question 5.3 How long in hours will it take to read the whole table from SSD if the table is stored in 64MB blocks? Assume that the size of the table is 200 TB. Question 5.4 How long in days (round to nearest integer) will it take to read the whole table from HDD if each row of the table is stored randomly in the HDD? Assume 1 trillion rows and 200 TB. Question 5.5 How long in days (round to nearest integer) will it take to read the whole table from HDD if the table is stored in 4x64MB blocks? Assume that the size of the table is 200 TB. Question 5.6 What is the cost in dollars for saving the table in RAM? Assume RAM costs $100/32GB and the size of the table is 200 TB. Question 5.7 What is the cost in dollars for saving the table in HDD? Assume HDD space costs $25/TB and the size of the table is 200 TB. Imagine you are designing a table to store recent transactions for an online shopping platform and there are 1 trillion transactions. You want to record the following information: • user id • user name • item id • item name • transaction id • amount of money ($) for the transaction (e.g. $4.11, $670.50, etc) Assume there are 1 billion users, and 1 billion items for sale on the platform. The longest string for user and item names contain 64 characters. You should consider proper data types listed below: byte, short, int, long, float, double, boolean, char. Question 4.1 What data type should you use for each column? You need to fill one of the following data types: byte, short, int, long, float, double, boolean, char. You need to select the most suitable data type for each column by considering efficiency. You are not required to add the number of the data types used for the column. For instance, you only need to put char for char[10]. What is the most appropriate data type for the following column: User ID? Question 4.2 What is the most appropriate data type for the following column: User Name? Question 4.3 What is the most appropriate data type for the following column: Item ID? Question 4.4 What is the most appropriate data type for the following column: Item Name? Question 4.5 What is the most appropriate data type for the following column: Transaction ID? Question 4.6 What is the size of each row in bytes, based on the previous parts? Note: Use float for the 'Amount of money' column. Question 4.7 What is the size of the table in TB? Problem 5 This question follows from question 4. Question 5.1 How long in seconds will it take to read the whole table from RAM? Assume that the size of the table is 200 TB. Question 5.2 How long in hours will it take to read the whole table from SSD if each row is randomly stored in the SSD? Assume 1 trillion rows and 200 TB. Question 5.3 How long in hours will it take to read the whole table from SSD if the table is stored in 64MB blocks? Assume that the size of the table is 200 TB. Question 5.4 How long in days (round to nearest integer) will it take to read the whole table from HDD if each row of the table is stored randomly in the HDD? Assume 1 trillion rows and 200 TB. Question 5.5 How long in days (round to nearest integer) will it take to read the whole table from HDD if the table is stored in 4x64MB blocks? Assume that the size of the table is 200 TB. Question 5.6 What is the cost in dollars for saving the table in RAM? Assume RAM costs $100/32GB and the size of the table is 200 TB. Question 5.7 What is the cost in dollars for saving the table in HDD? Assume HDD space costs $25/TB and the size of the table is 200 TB.
Expert Answer:
Answer rating: 100% (QA)
Lets analyze each column and determine the most appropriate data type for each one Question 41 User ID Number of users 1 billion Suitable data type int 4 bytes Explanation An int can easily accommodat... View the full answer
Related Book For
Systems Analysis And Design
ISBN: 978-1119496489
7th Edition
Authors: Alan Dennis, Barbara Wixom, Roberta M. Roth
Posted Date:
Students also viewed these databases questions
-
What engineering problems can be associated with foundations on limestone? Give two alternatives when a foundation excavation encounters a clay pocket in limestone.
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Beverage Buddy (BB) is a diabetes-friendly mobile app to track and share beverage information with friends. BB tracks data about teas, coffees, and other drinks to help individuals with diabetes...
-
In this exercise, we prove that for all x, y 0: a + b 1 1.40 y B where a 1 and 1 are numbers such that a +B- = 1. To do this, we prove that the function f(x,y) = ax + _xy xy satisfies f(x, y) 0 for...
-
A refrigerator with R-12 as the working fluid has a minimum temperature of 10C and a maximum pressure of 1 MPa. The actual adiabatic compressor exit temperature is 60C. Assume...
-
Can you delineate the role of central banks as key stakeholders in the financial ecosystem, elucidating their functions as monetary authorities responsible for price stability, lender of last resort...
-
Suppose at time 0 you have arranged to be paid at time \(T\) the amount \(\int_{0}^{T} S(t) \mathrm{d} t\), where \(S(t)\) is the spot price at \(t\) of a commodity that can be shorted and has zero...
-
You own a portfolio that has $2,950 invested in Stock A and $3,700 invested in Stock B. If the expected returns on these stocks are 8 percent and 11 percent, respectively, what is the expected return...
-
A diet-conscious housewife wishes to ensure her family' daily intake of vitamins A, B and C does not fall below certain levels, say 24 units, 30 units and 18 units, respectively. For this she relies...
-
On December 1, 2020, Papadopoulos Seasonings had the following account balances. During December, the company completed the following transactions. Dec. 7 Received 3,600 cash from customers in...
-
Pete Corp purchased 60% of the shares of Spidey Corp on January 1, 2021. The fair values of all the assets and liabilities of Spidey on that date were equal to their book values, except Spidey had...
-
Limits on takeovers of locals by national unions and a listing of the financial responsibilities of union officials were provisions of the _________Act. a) National Labor Relations b) Taft-Hartley c)...
-
Which statement is true? a) In good economic times, employers demand more givebacks from labor unions than in bad economic times. b) We have not had a major strike in over 10 years. c) The United...
-
Under a(n) __________shop, an employer may hire only union members. a) closed b) union c) open
-
Which statement is the most accurate? a) Public employee unions can engage in collective bargaining in all 50 states. b) Public employee unions cannot engage in collective bargaining in any state. c)...
-
A monopsony is __________________.
-
k When a rectangular beam is loaded transversely, the maximum compressive stress is developed on the A top layer B. bottom layer C.neutral axis Devery cross-section 8. The bending moment in the...
-
Bonus shares can be issued out of revenue reserves. True/False?
-
Explain what is meant by a functional requirement. What are the two types of functional requirements?
-
What is the breakeven point?
-
List the seven types of cohesion. Why do the various types of cohesion range from good to bad? Give an example of good coupling and an example of bad coupling.
-
Explain why budgets are important to all organizations. Expand this discussion by illustrating how different types of budgets are used.
-
Compare and contrast licensure and credentialing.
-
Describe the steps in attaining state licensure for nurses.
Study smarter with the SolutionInn App