Hi, last week, you could identify the requirements of a typical OLTP system, and you have proposed a relational database to have security, concurrency, and IC properties. Are you ready for the next use case? Remember to take into account the response time, amount, and type of information, and it's processing. This will give you the tips to know what kind of information system is, and with what architecture and technologies it is better to implement. Your proposal must conform with what this requested, no more no less. Let us start with the use case of this week. An online book shopping is a very active e-commerce area. A large amount of customer orders is produced every day, and the company you're best readings can manage book sales across different stores, bookstock on several warehouse, and books deliveries. The CEO wants to know why it would be better to open a new bookstore to provide a better service to his customers, or to open a new book data warehouse to reduce time book delivery. In addition, the bookshop manager may also integrate discount book information from his competitors. He wants to compare pricing schemes and allies market trends, and make new business plans. Suppose already mentioned applications have all the required information to make decisions, but they were independently developed as a transactional information systems within relational databases. As we have learned in course two, first, define an integrated data model for the cooperation. Second, define the scope of the data warehouse. Third, produce a multidimensional data model to serve as a basis for the warehouse scheme. The CEO and the bookshop's manager would like to ask the following queries. One. Obtain the total daily sales by book and sub-region. Two. Obtain annual sales per book. Three. Obtain which region had the most transactions within October 2017. Four. Obtain the average sales per ticket, or invoice per month in each region. Five. Get which books are bought together more frequently. Remember that the analytical systems use information generated in the transactional systems to analyze data and make decisions. For example, based on the ticket of your purchase in the supermarket and all other peoples tickets for months and years, you can analyze which supermarket items are sold together during a certain season, that allows store managers to know what products can be placed on the shelves together, or what product should be put on sale depending on their inventory and season. What solution would you bring to the company? The students should submit this proposal and justification of the following elements. One. Typical architecture according to the type of information system. Two. Kind of database to implement and it's design. Three. Answers to the queries required. Four. According to the proposed solution, how to implement, that as books are sold, the inventory is registered and the amount of this sale corresponds to the merchandise sold? Five. How does it support scalability? Six. How does it support maintainability? Seven. How does it support security and reliability? Well, that's all for today. See you next week.
