EasyPHPand MYSQL Setup
Adatabase is information arranged in a simple and organized manner foreasy access and analysis. A Database Management System (DBMS)connects the users and other applications that rely on theinformation in the database (Aveda, 2015). A DBMS enables one toadminister a database. This paper examines various aspects ofDatabase Management Systems.
Roleof Databases and DBMS
Thetwo make it possible to manage different types of information used bya business in an efficient manner centrally. A company can keepemployee records, payroll information, and financial information allin one place (Aveda, 2015).
Databasesand DBMS automate data (Aveda, 2015).A business with the two systems does not need to have volumes ofpaper files. Information rests in a central server and is retrievableat any time. It is possible to modify data in real time and generaterelevant reports or forecasts essential for managerial decisionmaking (Aveda, 2015).
Databaseand DBMS make it possible to safeguard information. They allow one toset passwords for different users of the organization’s data.Passwords ensure that only authorized personnel access storedinformation (Aveda, 2015).One can also easily track changes to a database made by various users(Aveda, 2015).Different users of such a system access only what they need (e.g.Human Resource department staff can only access personnel data andnot financial information) for performing daily tasks because theyhave varying levels of authorizations. Also, multiple users canaccess information at the same time (Aveda, 2015).Databases and DBMS make and organization run smoothly andefficiently.
TheHistorical Development of DBMS and Logical Data Models.
Logicaldata models try to assess and map data needs necessary to support anorganization’s processes. DBMS and logical data models have changedsignificantly over the years. Initial DBMS employed a hierarchysystem. The system titled Information Management System had child andparent records only. It was a secure system, but it lacked setimplementation standards presenting a lot of challenges during itsimplementation (Maier et al., 2012).
Innovationled to the subsequent development of the network DBMS. It was betterthan the hierarchical DBMS because a record could have multipleparents and sets of relationships between data could be made. Thissystem was hard to maintain due to its complexity.
Around1990, more advancement in technology led to the development ofrelational DBMS. It is at this time that the idea of using linkedtables to manage data came up. Current databases and logical datamodels employ this technique of data management.
Issuesin Database Systems
Databasesand DBMS have become very crucial to organizations. Businesses investa lot of money in them and anticipate that the systems will lead toefficiency and increased profits.
Anotherissue when it comes to this kind of systems is the quality of data.Data put into the database should be complete and accurate (Siau,2010).Whenthe data is incorrect, the output will also be wrong.
Onlytrained professionals should manage databases. Those using a databasealso should be trained so that they only input correct data.
Datamanagement policy is also an important issue when it comes todatabase systems. An organization needs to have clear policiesgoverning data management. All staffs have to adhere to anorganization’s database systems policy.
Anymodern firm cannot ignore the power of a good database managementsystem. Databases and DBMS have changed considerably with time. Theyare now faster and more accurate than before (Aveda, 2015). With acomprehensive data management policy in place, a business will ensurethat its data is well kept, accurate and helpful when makingimportant decisions. A company should invest in a database and DBMSthat suits its needs.
Aveda,S. (2015).What is the importance of a database management system? Retrievedfromhttps://www.linkedin.com/pulse/what-importance-database-management-system-scott-aveda
Maier,R., Hädrich, T., & Peinl, R. (2012). Enterpriseknowledge infrastructures. Berlin: Springe.
Siau,K. (2012). Contemporaryissues in database design and information systems development.Hershey, PA: IGI Pub