Course: Database Systems Discussion 1 (Chapter 1): Give examples of systems in which it may make sense to use traditional file processing instead of a database approach. Instructions: Your resp
Reply to the below posts:
Post 1:
Vinay Kumar
Discussion 2
COLLAPSE
Top of Form
The database approach is widely used as it offers effective usage of data and information simultaneously. The database management systems (DBMS) ensure that the database is safe, secure, and fast to be used. The architectures of DBMS studied in section 2.5 include centralized DBMS architecture, basic client/server architecture, two-tier client/server architecture, and three-tier client/server architecture. For making a web system for an airline, I would choose the three-tier client/ server architecture as it is most popular, and separate modules are used to develop and maintain user interface, data access, data storage, logic, and functional processes, etc. The database approach has taken over the traditional file processing system as it fast and reliable and numerous users can access the data or information at a time. This architecture helps to separate the physical database and the user applications (Hellerstein et al., 2007). DBMS characteristics are supported by this architecture. Data’s multiple views are supported in this architecture that ensures swift work. Also, there is program-data independence in this architecture. For these reasons, this architecture is a better choice than other ones. Companies having huge consumers and handling huge customers online use this architecture. There are three layers in three-tier DBMS architecture. The first layer is called the presentation layer that includes PC, Mobile, etc. Then comes the application layer that serves as a server. The last one is the database server. Websites on the internet that must host millions of users and entertain them at a time can use this architecture effectively that minimizes problems for the users (guru99, 2021).
References
Guru99 (2021). Database Architecture in DBMS: 1-Tier, 2-Tier, and 3-Tier. Retrieved March 3, 2021, from https://www.guru99.com/dbms-architecture.html#:~:text=using%20MS%2D%20Access.-,3%2DTier%20Architecture,done%20independently%20as%20separate%20modules...
Joseph M. Hellerstein, Michael Stonebraker, and James Hamilton (2007). Architecture of a Database System. Retrieved March 3, 2021, from http://mperdikeas.github.io/architecture-of-a-database-system.pdf.
Bottom of Form
Post 2:
Sravankumar
Week2:Discussion2
COLLAPSE
Top of Form
Hello All-
There are 4 architectures discussed in section 2.5 they are centralized DBMS architecture, Basic Client/Server Architecture, Two-Tier Client/Server Architecture and Three-Tier Client/Server Architecture. For designing web based applications to make airline reservations and sell airline tickets, Three-Tier client/server architecture will be the good choice for this airlines ticketing. A web based user interface is necessary as different types of users such as naïve users or casual users will interact with the system. Web user interface is placed in client system. User can interact with user interface and submit the transactions that they buy. Web server handles all these transactions validate data and change database records accordingly. Web server will handle all the application logic of the system. This database server contains the DBMS of any type that the application support.
In centralized DBMS architecture user interface and DBMS functionality is performed on the same system but a web based system must be on the other system. Hence this is not a appropriate for web based system applications. In three tier client/server architecture this business logic is placed in web or application server. Basic client/server architecture or two tier client/server architecture can be considered appropriate for web based server if the business logic is placed on a database server or client. If the business logic is placed on database server it will be burden. Hence basic client/server architecture and two tier client/server architecture are not appropriate for web based system.
References:
Teorey, T.J., Lightstone, S.S., et al., (2009). Database Design: Know it all.1st ed. Burlington, MA.: Morgan Kaufmann Publishers
Eckerson, Wayne W. "Three Tier Client/Server Architecture: Achieving Scalability, Performance, and Efficiency in Client Server Applications." Open Information Systems 10, 1 (January 1995): 3(20)
Bottom of Form
