Member-only story
IBM DB2 Cloud Database and SQL : PART 1
In non-technical terms, one can infer Database as, the place where data is stored or found after being collected from various data sources. Oracle defines database as an organized collection of structured information, or data, typically stored electronically in a computer system. In general, the primary objective of database, is to store the data such a way that it can be accessed, managed and updated with an ease, and the process of doing so with software, built for the stated purpose is known as Database Management System (DBMS). There are various types of databases available to store the data according to its characteristics and application needs. Some of them are listed below-
- Relational databases
- Hierarchical databases
- Network databases
- Object-oriented databases
- NoSQL databases and so on.
Visit the link to know more about database types: Types of Databases
In this blog, we will be discussing about Relational databases, which is one of popular databases used worldwide. A survey conducted in 2019, upon ‘SQL vs NOSQL’ suggests that about 60% of the all the organizations in the world are still using Relational databases. Relational database stores the data in the form tables, with rows containing data and columns representing data attributes. In technical terms, rows are also known as records/tuples and columns are referred to as fields, and when the data is stored in the rows and…
