120 likes | 368 Views
INFORMATION SYSTEM AND ELECTRONIC COMMERCE GST-5083. Case Title : LEGO, EMBRACING CHANGE BY COMBINING BI WITH A FLEXIBLE INFORMATION SYSTEM. Group Members:. INFORMATION SYSTEM AND ELECTRONIC COMMERCE GST-5083. INFORMATION SYSTEM AND ELECTRONIC COMMERCE GST-5083.
E N D
INFORMATION SYSTEM AND ELECTRONIC COMMERCEGST-5083 Case Title : LEGO, EMBRACING CHANGE BY COMBINING BI WITH A FLEXIBLE INFORMATION SYSTEM Group Members:
INFORMATION SYSTEM AND ELECTRONIC COMMERCEGST-5083 Explain the role of the database in SAP's three-tier system
INFORMATION SYSTEM AND ELECTRONIC COMMERCEGST-5083 • SAP’s business suite is based on a flexible three-tier client-server architecture that can easily be adapted to the new Service-Oriented Architecture (SOA) available in the latest versions of the software. • In the first tier, a client interface-a browser-type graphical user interface (GUI) running on either a laptop, desktop, or mobile device-submits users’ requests to the application servers. The applications servers send the processed requests to the database system-receive and process clients’ requests to the database system-the third tier-which consists of one or more relational databases • The main role of the database is as an information storage system. The relational database contains the tables that store data on LEGO’s products, daily operations, the supply chain, and thousands of employees. • Using the SAP query tool, users are able to toggle and tabulate data and extract reports from the database. Therefore the database’s role is also as a reports generator.
INFORMATION SYSTEM AND ELECTRONIC COMMERCEGST-5083 Explain why distributed architectures are flexible
INFORMATION SYSTEM AND ELECTRONIC COMMERCEGST-5083 • A distributed database can reside on network servers on the Internet, on corporate intranets or extranets, or on other company networks. • Because they store data across multiple computers, distributed databases can improve performance at end-user worksites by allowing transactions to be processed on many machines, instead of being limited to one. • Users from different parts of the world may access the same data. Therefore they are more flexible in terms of availability to users.
INFORMATION SYSTEM AND ELECTRONIC COMMERCEGST-5083 Identify some of the business intelligence features included in SAP's business software suite.
INFORMATION SYSTEM AND ELECTRONIC COMMERCEGST-5083 • Supply Chain Management (SCM) : Supply chain monitoring and analysis as well as forecasting, planning and inventory optimization. • Product Lifecycle Management (PLM) : Enable managers to optimize development process and system. • Enterprise Resources Planning (ERP): Include Human Capital Management (HCM) application for personnel administration and development.
INFORMATION SYSTEM AND ELECTRONIC COMMERCEGST-5083 What are the main advantages and disadvantages of having multiple databases in a distributed architecture? Explain.
INFORMATION SYSTEM AND ELECTRONIC COMMERCEGST-5083 Advantages • Multiple database contains the tables that store data on product, daily operation, supply chain and thousands of employees • Managers can easily use the SAP query tool to obtain reports from the database because it does not require any technical skills • Distributed architecture enables authorized personnel to have direct access to database system from the company’s various location including in Europe, North America and Asia
INFORMATION SYSTEM &ELECTRONIC COMMERCEGST-5083 Disadvantages • The additional overhead of these transactions can be a performance penalty when the total amount of data in the network is small. Users also see slower performance when accessing data that is not local • Increased the use of database space. Every table must exist in every database. When the number of tables is very large, the amount of space used can be significant. Administrators must use database storage parameters to size tables and reduce database space consumption. • Administrators must keep the schemas of all database synchronized and ensure that the network is configured to take optimal advantage of the distributed-database environment in term of availability and performance. Although database backups are more flexible in a distributed-database environment, multiple databases add complexity to the backup process.