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
Dear Class, Please be aware of the subject matter requirements for ALL work produced for this course, and you must follow the APA format. I would like to take this time to remind you about the APA compliance requirement for academic writing purposes with our University.Follow the link below to the APA Formatting and Style Guide by Purdue University. This is free to use and a great guide. I would encourage to use this guide.  https://owl.purdue.edu/owl/research_and_citation/apa_style/apa_formatting_and_style_guide/general_format.html https://sites.umuc.edu/library/libhow/apa_examples.cfm  Below are some helpful tips to keep in mind as you write your papers in this course. For in-text citations, the citation needs to go inside the end of the sentence. For example: This is my sentence on APA formatting (APA, 2016). For references, this list should start on a new page at the end of your document with a hanging indent (the title of the page should be References). You do not need to include the retrieved date. Here are some examples: Start your paragraph with an indent (tab). Smyth, A. M., Parker, A. L., & Pease, D. L. (2002). A study of enjoyment of peas. Journal of Abnormal Eating, 8(3), 120-125. Retrieved from http://www.articlehomepage.com/full/url/ Bernstein, M. (2002). 10 tips on writing the living Web. A List Apart: For People Who Make Websites, 149. Retrieved from http://www.alistapart.com/articles/writeliving De Huff, E. W. (n.d.). Taytay’s tales: Traditional Pueblo  Indian tales. Retrieved from  http://digital.library.upenn.edu/women/dehuff/taytay/taytay.html Dear Class, One of the greatest things about online learning is how we can use the world-wide-web to increase our learning potential. The amount of information on the internet is exponential! I highly recommend that you learn to tap this information source, but in doing so, I ask that you use good business and educational practices in quoting and citing your sources. Here are some IMPORTANT rules and considerations to use when using web-research in your thread posts in my class! DO include the URL (web address) that you took the information from. (Hit enter after pasting in the URL and it will become a hyperlink to the source for other students). DO include quotation marks or “ ” around quoted (i.e. copied and pasted) material. DO introduce the quoted material with YOUR OWN WORDS about why you are providing that quotation. DO limit the quoted material to a paragraph or less (a snippet ) to entice the reader into following the URL (link) you then provide. DO use an 80/20 rule of thumb for posting. That is, for every sentence of quoted material you should give us at least four sentences from you. Good practice is that you AT LEAST give us a few sentences to orient us to why this quote is appropriately contained in your post. Worst case: use a 50/50 rule but in no event should you simply copy and paste in paragraphs from a website with no orienting material from you. As the % of your words to quoted material decreases, so too will the value of the post decrease. What will I do if you “copy and paste” from a book or website, in contradiction of the above guidelines? If the problem is simply that you have “too much” copy and paste, but you have included the URL, this will affect the “quality” of your post—and your post will likely be a “low quality” post. Avoid this problem by only providing a “snippet” — i.e. 2-3 sentences of quoted material…and then provide YOUR OWN WORDS about why that is important. INCLUDE the URL! If you do not include a cite to the website or book from which your post information came, OR if you do not use quotation marks or some other method to show that the material was not written by you, then the issue will become one of Academic Integrity and I am required to turn it into the Committee, subject to the rules on Academic Integrity in the student handbook. Please let me know if you have questions about this class policy. Take care everyone and please let me know if you have any questions.
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
Replies needed for the below posts: Post 1: 15 hours ago Naveen Discussion-1-Week COLLAPSE Top of Form In general, it is ok to implement an implementation of file processing in their database system. However, if they still have problems with their data-model implementation, it is essential to investigate the database system. In some databases, it may be easier to perform database transaction processing in the database. Then the query-ability of their database may be improved. However, if they continue to find that they cannot handle complex queries, they should consider using another database system. If the system is not very powerful, the DB-integration may be broken, and the DB-integration will not work as expected. A more general approach is to create a table called the database or database instance. The database is required to be implemented in a database-framework to have no problems using that database for other purposes. However, they may be able to write an application that uses it to process data-types (McGill et al., 2020). The primary advantages are simplicity, performance, and reliability because they can use SQL queries. No transaction and no locks are used, and there are no conflicts. They can execute their queries quickly. The primary disadvantages are performance and reliability. They cannot get good performance or reliability from traditional databases, so they are better off using traditional file processing. Their file processing process might suffer from deadlock or lock problems or some lag because of file processing. They cannot take advantage of the transaction and lock support because of database constraints, so they might not get much efficiency. So, there is no practical advantage to using a relational database (Chuang et al., 2020). A file system can be implemented using any database. Besides, it can be implemented in any operating system. Database implementation may differ by file system design. While MySQL default may be ideal for specific problems, some people prefer the alternative approach of using PostgreSQL or Redis. The most popular database for application development. It has several advantages over other databases. However, it is still slower to load compared to databases that are built with Python. Source Code: Even if they are not familiar with software development, read the source code. There is a way to write files that are not executable and has a minimal requirement on the processor hardware. In the real-life, they cannot control how things go in the application, so they have to be cautious of the application’s behavitheir (Chuang et al., 2020).                                                                                                                                                                   References  Chuang, Y. Y., Vollmer, M. L., Shafaei-Bajestan, E., Gahl, S., Hendrix, P., & Baayen, R. H. (2020). The processing of pseudoword form and meaning in production and comprehension: A computational modeling approach using linear discriminative learning. Behavior research methods, 1-32. McGill, E., Marks, D., Er, V., Penney, T., Petticrew, M., & Egan, M. (2020). Qualitative process evaluation from a complex systems perspective: A systematic review and framework for public health evaluators. PLoS medicine, 17(11), e1003368. Bottom of Form Post 2: Sravankumar week1:Discussion1 COLLAPSE Top of Form Hello All- The advantages of using a database approach there are some situations in which a database management system involve unnecessary more costs that would not be included in traditional file processing. The following are the examples for in which it may make sense to use traditional file processing instead of a database approach. Many computer aided designs (CAD) used by the chemical and Civil engineers have a proprietary of file and data management software that is geared for the internal manipulations or drawings and 3D objects. Small internal utility to locate files. Single user applications that does not require security such as a customized calculator or a personal address or a phone book.  Real time navigation system which requires less data to manage. This GIS implementation often implement their own data organization schemes for efficiently implementing functions related to processing maps, physical details, lines, polygons and so on. In this case general purpose of DBMS is in adequate.             There are still file systems in use in organizations. Some of the organizations see no need to change what is already they are working for them to turn into DBMS. Looking into this file systems there are some limitations will help you to understand the database systems developed and the reasons for their development. There will be limitations for traditional file processing data duplication, poor data control, inadequate data and data manipulation, limited data sharing and program maintenance.   References: Arpaci-Dusseau, Remzi H.; Arpaci-Dusseau, Andrea C. (2014), File System Implementation (PDF), Arpaci-Dusseau Books Beynon-Davies, Paul (2003). Database Systems (3rd ed.). Palgrave Macmillan. ISBN 978-1403916013. Bottom of Form
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