Write about your understanding of databases. Explore the database advantages and write about database concepts such as primary and foreign keys

-

 Definition 

"A database is an organized collection of structured information, or data, tipycally stored electronically in a computer system. A database is usually controlled by a database managment system also called DBMS. Together the data and the DMBS alonf with the applicacions associated with them are referred to as a data system often shortened to just data base" acording to (Oracle, 2022)

A very typical used modeled in rows and columns which make a table this is used to make the process of data and querying much efficient, the data can be managed and organized, most of this databases are structured on query language SQL for writing information.


source: https://www.freepik.com/free-vector/server-room-cloud-storage-icon-datacenter-database-concept-data-exchange-process_3628676.


Differences between a spreadsheet and a database

  • How the information is stored
  • who can access the information 
  • and how much of the data can be stored
Databases are desing to store a much longer collection of information, massive amounts, sometimes databases allow different users at the same time to secure the acces and query the information using complex language, however spreadsheets were designed for just one user at the time, they are great for single user or small number or users who do not need to do a data manipulation.

Types of databases 

  • relational databases 
  • object oriented databases 
  • distributed databases 
  • data warehouses 
  • noSQL databases
  • graph databases 
  • open source database 
  • cloud database 
  • multimodel database 
  • document database
  • self driving database

references:

Free vector: Server room, cloud storage icon, datacenter and database concept, data exchange process (2018) Freepik. Available at: https://www.freepik.com/free-vector/server-room-cloud-storage-icon-datacenter-database-concept-data-exchange-process_3628676.htm#query=databases&position=3&from_view=search&track=sph (Accessed: 07 September 2023).

What is a database? (no date) What Is a Database | Oracle United Kingdom. Available at: https://www.oracle.com/uk/database/what-is-database/ (Accessed: 07 September 2023). 

Comments

Post a Comment

Popular posts from this blog

Explore the computing definition of an E-commerce websites

-
Image
DEFINITION OF E-CCOMERCE It is also called 'Electronic Commerce' , it is the trade of services or goods on the internet, there are many  companies that sells products every day to different parts of the world, but there are also people that use ecommerce as their main strategy to engage with people they can use physical stores or other type of channel to sell their products. (Source: https://www.freepik.com/free-vector/ecommerce-web-page-concept-illustration) The huge advantage of ecommerce is that allows small business , or even well known companies to sell and to reach their costumers across the world just by using a webpage and of course having internet connection, also the second advantage is that you can use their service 24 hours every day without the need to go out and try the product by your own which for some people could be a very important disadvantage.  "A sales channel that crosses all industries that sell or promote brand awareness online and is considered...
Read more

Types of E-Commerce

-
Image
 Business to Consumer (B2C) E-commerce is the use of web pages as a form of marketing where Business can promoted their own products to their consumers, Thanks to the modern internet business transactions has become more easy providing consumers the ease to purchase and explore virtually from every part 24 hours a day. Business to Business (B2B) It is basically the sales of goods between two Business via an online platform, B2B is growing so much during the last few years, some estimates the global market value is over 12 trillion. This B2B sellers must work with a wide range of sectors such as wholesalers, large retailers, organizations like schools and resellers.   Consumer to Consumer (C2C) I would like to talk about the most common is between costumers where they trade each other through out an online environment, this could be using eBay as the main platform, the good thing about this is that consumers benefit from the competition and often a third party.  Consu...
Read more