Tech Topic Connection: Database Management

-

What is Database Management?

"Information technology (IT) is the use of any computers, storage, networking and other physical devices, infrastructure and processes to create, process, store, secure and exchange all forms of electronic data (Castagna & Bigelow, 2021)".

    Data has become an asset for organizations and it is important for the data that is being stored remain private, secure, and organized - especially when an organization is dealing with very large data. Data is collected using modern software applications and databases are a common way to store and manage data using such applications. Organizations uses database applications to create and administer databases. Database Management Systems (DBMS) are desktop applications that users use for business purpose. The purpose of database management systems is to store and transform data into information to support businesses decision making. Database management systems are in relation to the fundamentals of information technology as they are used to store, retrieve, and run queries on data. DBMS allows users to create, read, update, and delete data in the database. One of the components of a DBMS is the hardware which is the actual computer system used for storing and accessing the database. It consist of secondary storage devices such as hard disks. DBMS backs up the data regularly and recover data if a problem occurs. Most databases have built-in backup and recovery tools. Database administrators use a programming language called structured query language (SQL) to manage databases and query data. Network architecture influences database management by using client/server network. Very large databases are stored on the server, and the client accesses these without copying them onto the local hard drive (Client/Server and Mainframe Systems Used in Telecommunication Systems, 2013). An advantage of Database Management Systems, they are used to increase data security. 

What is the difference between PostgreSQL and MySQL?

    There are number of different types of database management systems (DBMS). DBMS has five models: flat file, hierarchical, network, relational, and object-relational. Today, I will be going over two models in relation to what is the difference between PostgreSQL and MySQL. Although, both PostgreSQL, also known as Postgres, and MySQL rely on the programming language SQL. Postgres is essentially an object-relational DMBS, while MySQL is a relational DBMS. Postgres is the most advance database management system and MySQL is the most popular. MySQL is a common and easy-to-start database with low memory, disk and CPU utilization, managed by a relational database management system (RDMS) (PostgreSQL vs. mysql: What's the difference?). Moreover, Postgres has a deep language support as it can support multiple languages like Python, Java, JavaScript, C/C++ and Ruby. Overall, I have learned that in order for an organization to use one of the two, it just all depends on their enterprises objectives and resources. 


References
Client/Server and Mainframe Systems Used in Telecommunication Systems. (2013, November 13).                     Retrieved from https://study.com/academy/lesson/client-server-and-mainframe-systems-used-in-                telecommunication-systems.html.

AppDynamics. (2020, December 21). What is database management systems (DBMS)? AppDynamics. Retrieved January 29, 2022, from https://www.appdynamics.com/topics/database-management-systems#~1-what-is-dbms

Castagna, R., & Bigelow, S. J. (2021, August 5). What is information technology? definition and examples. SearchDataCenter. Retrieved January 29, 2022, from https://searchdatacenter.techtarget.com/definition/IT#:~:text=Information%20technology%20(IT)%20is%20the,all%20forms%20of%20electronic%20data.&text=The%20commercial%20use%20of%20IT%20encompasses%20both%20computer%20technology%20and%20telecommunications.

Components of a database management system. Data Entry Outsourced Blog RSS. (n.d.). Retrieved January 29, 2022, from https://www.dataentryoutsourced.com/blog/components-of-a-database-management-system/

PostgreSQL vs. mysql: What's the difference? IBM. (n.d.). Retrieved January 29, 2022, from https://www.ibm.com/cloud/blog/postgresql-vs-mysql-whats-the-difference


Comments

Post a Comment

Popular posts from this blog

Computers in the Workplace

-
Image
       The use of computers is essential in the insurance industry.  The  main purpose of insurance is to protect our assets and  in the event  of a loss, we report a claim. Insurance companies must have a database that includes auto claims,  home claims, catastrophe claims and more.  Technology is used in insurance to assist policyholders with filing a claim and for adjusters to handle them as well  quickly and efficiently .        The functions of computers in the insurance industry are to store data or information and processing data/information.  The   employees that are handling claims have their own personal computer. They are required to keep their computers locked when they are away from their desk as there are customer’s personal information stored in a claims database that associates have access too. In order for the data to be processed or stored, the employees will input the data using their...
Read more

Network Security

-
Image
     The type of attack that can be executed using pings commands is commonly known as the ping of death. The ping of death is a form of denial-of-service attack, and this is when attackers crashes or freezes a computer by sending a ping larger than the Internet Protocol packet which is formed of 65,535 bytes. Most legacy computers cannot handle larger packets. When attackers violates the IP rule, it overwhelms the computers memory and causes it to crash, destabilize, or freeze. In order for organizations to avoid this type of attack, they will need to avoid using legacy equipment's and constantly update their software as they are the most vulnerable.  Computers systems are vulnerable to phishing threats because hackers gain access to sensitive data such as passwords or credit card details. Hackers achieve this by pretending to be someone else like a well-known company or authoritative figure via email, text message, or telephone and manipulate user's into giving up ...
Read more