read and contribute to the Peer discussion below:
1. A Database Management System (DBMS) is a collection of data that is paired with a set of software tools/programs which can then access, process, and manipulate that same data (Geeks, 2022). Accessing, retrieval, and use of that data for security measures is also possible. A well constructed DBMS can provide users with better data integration and security (Geeks, 2022).
2. Without organization, data is hard to understand, interpret or utilize. It’s unknowable information until it is given a context that allows an organization to use the data it has effectively. Many businesses such as grocery stores, banks, and clothing retailers all use databases. The databases allow businesses to track customers, inventory, and also employee and account information. All of which contribute an organisation’s decision making process (Graham, 2022).
3. A new database system may require significant investment in hardware and software. Significant disk storage and memory are required and can be costly. Flexibility, and scalability must be built into the database systems. The system must also sustain the load of use the database must handle (2022).
4. The advantage NoSQL has over Traditional RDMS is its ability to handle flexible data storage (Johnson, 2021). Traditional RDMS relies on static data structure and changing the database structure later wastes time and is expensive. NoSQL’s ability to handle an ever-changing data model make it ideal for data that is constantly changing and evolving. NoSQL is also the better choice when the data structure is not fully known at the outset of a project (Johnson, 2021).
Geeks, V. K. (2022, April 28). Advantages of Database Management System. GeeksforGeeks. Retrieved August 20, 2022, from https://www.geeksforgeeks.org/advantages-of-databa…
Graham, A. J. (2022). How are databases used in the real world? Techwalla. Retrieved August 20, 2022, from https://www.techwalla.com/articles/how-are-databas…
Johnson, P. (2021, July 29). When to consider a NoSQL vs relational database. Mend. Retrieved August 20, 2022, from https://www.mend.io/resources/blog/when-to-conside…
What Is The Potential Costs Of Implementing A Database. Kimball. (2022). Retrieved August 20, 2022, from https://www.kimball.com/
- My understanding of the readings in the unit one lecture are that a database of information can help an organization to better understand its purpose in the world ot it can become disorganized and damper efforts of the organization to succeed in the world. Michelle Pizzo for the pipeline states there are six benefits to using a database management system and they include: “improved data sharing and date security, effective data integration, consistent reliable data, data that complies with privacy regulations, increased productivity, and better decision making.” (2022, p. 1) The disadvantages include: “cost of hardware and software, cost of staff training, cost of data conversion, complexity of the system, currency maintenance, performance, and frequent upgrades.” (Disadvantages of DBMS, 2021) I believe it boils down to the cost of the system and maintenance as the disadvantages in the long run.
- Cost and profit from the video is the prefect example from the video. Data means that we have useless facts about what our cost is for making a product and what profit we have from the product as well. Information is putting the cost and profit scenario into terms that we can understand and ask relative questions about. Are we really making a profit for producing this item? What can we do to minimize cost but increase profit margins? I believe that information is the better of these two but the whole thing starts with the data produced.
- Small businesses could benefit from having a database system. The cost for design for a small business is $2,000 to $10,000. (How Much Does a Database Cost for a Business, n.d.) The standard server is $899, websites range for $100 to $10,000, hosting can start at $1.39. (How Much Does a Database Cost for a Business, n.d.) These investments into the database management system can help the company run more smoothly, bring more business, and ensure there is a marginal profit each month for expansion projects.
- NonSql is made for larger data bases. NonSQL is preferable for: “The organization works with a huge amount of data, the data is not strongly related, the data is not structured, the database needs to consistently scale.” (AL Mamnun, 2022, para. 9) I would use this when the organization got too large for a system such as oracle.
AL Mamnun, A. M. (2022, January 19). NoSQL Databases: When to Use NoSQL vs SQL. ServerWatch. https://www.serverwatch.com/guides/when-to-use-nosql/#:~:text=NoSQL%20is%20extremely%20useful%20for,MongoDB
Disadvantages of DBMS. (2021, March 5). GeeksforGeeks. https://www.geeksforgeeks.org/disadvantages-of-dbms/
How Much Does A Database Cost For A Business? (n.d.). ICTSD. https://www.ictsd.org/business/how-much-does-a-database-cost-for-a-business/
Pizzo, M. (2022). 6 Benefits of Using Database Management Systems (DBMS). The Pipeline. https://pipeline.zoominfo.com/operations/6-benefits-of-using-database-management-systems-dbms