Question

1. What is an online transaction processing (OLTP) system? What is a business intelligence (BI) system? What is a data warehouse? Explain your answers with examples.
2. Briefly describe the function of a database system in an eCommerce application like Amazon.
3. Briefly describe the function of the DBMS in a database system.
4. How does database address problems with file systems?
5. How can database systems improve data quality and data integrity?

Answer 1

What is an online transaction processing (OLTP) system?

Online transaction processing is database software designed to support transaction-related applications on the Internet. OLTP involves data input, processing the data and then updating existing data to reflect the gathered and processed data. The complexity of the process means most organizations today use database management systems to support OLTP operations.

What is a business intelligence (BI) system?

Business intelligence (BI) combines business analytics, data mining, data visualization, data tools and infrastructure, and best practices to help organizations to make more data-driven decisions.

What is a data warehouse? Explain your answers with examples.

Data warehousing is an electronic method of organizing information. An data warehouse basically joins data from a few sources into one exhaustive information base. For instance, in the business world, an data warehouse may consolidate client data from an organization's retail location frameworks (the sales enlists), its site, its mailing records and its remark cards. Then again, it may consolidate all the data about workers, including time cards, segment information, pay data, and so on.

Briefly describe the function of a database system in an eCommerce application like Amazon.

The principle reason to a database is to store data. Have an inquiry regarding a client request? Check the database. Need to realize an item cost? Check the database.

By utilizing a database, a web application can disregard the genuine information and spotlight more on the introduction and conduct of that information. The outcome is that the measure of code and rationale in the web application is a lot more modest and more obvious.

For instance, in the event that all items have pictures, at that point the web application simply needs to request that information — i.e., a picture — and show it as an item see. It couldn't care less if there is one picture, three pictures, or what the pictures really are appearing. The application just hopes to get back a picture URL, which it at that point shows.

Briefly describe the function of the DBMS in a database system.

DBMS is an assortment of programs that empowers the client to make and keep up an database. All in all, it is broadly useful programming that gives the clients the cycles of characterizing, developing and controlling the information base for different applications.