Explain relational databases with it's advantanges.

-

 RELATIONAL DATABASES

A relational database is a form of database that stores and allows access to data elements that are connected. Relational databases are based on the relational model, which is an easy-to-understand method of expressing data in tables. In a relational database, each row in the table is a record with a unique ID called the key. The columns of the table carry data attributes, and each record generally includes a value for each attribute, making it simple to construct links between data points.

In a relational database, each table, also known as a relation, includes one or more data categories in columns, also known as attributes. Each row, also known as a record or tuple, includes a unique instance of data, or key, for the columns' stated categories. Each table has a unique primary key that identifies the data in the table. The relationship between tables may then be defined using foreign keys, which are fields in one table that are linked to the primary key of another table.

A normal business order entry database, for example, might have a table that identifies a client, with columns for name, address, phone number, and so on. Another table would explain an order: the product, the client, the date, the sales price, and so on. A user of a relational database can then acquire a view of the database that is tailored to their requirements. A branch office manager, for example, would want a view or report on all clients who purchased items after a given date. A financial services manager in the same organization may acquire a report on accounts that needed to be paid using the same tables.


Types of Databases

  • There are several database types, ranging from non-relational flat files to NoSQL to emerging graph databases that are regarded as even more relational than traditional relational databases.
  • A flat-file database is made up of a single table of data with no interrelationships - commonly text files.
  • Users can provide data properties such as columns and data types in this type of file. Users may manage preset data relationships across various databases using standard relational databases. Microsoft SQL Server, Oracle Database, MySQL, and IBM DB2 are examples of popular relational databases. Cloud-based relational databases, also known as database as a service (DBaaS), are also popular because they allow businesses to outsource database maintenance, patching, and infrastructure support. Amazon Relational Database Service (RDS), Google Cloud SQL, IBM DB2 on Cloud, Microsoft Azure SQL Database, and Oracle Database Cloud Service are examples of cloud relational databases.
  • A NoSQL database is a relational database alternative that is especially suitable for working with massive volumes of dispersed data. These databases can accommodate a wide range of data structures, including key-value, document, columnar, and graph formats.A graph database goes beyond typical column and row-based relational data models; this NoSQL database employs nodes and edges to express connections between data relationships and can find new ones. Because graph databases are more intelligent than relational databases, their applications include fraud detection and online recommendation engines.

Advantages of Relational Databases

The primary benefits of relational databases are that they allow users to quickly classify and store data, which can then be searched and filtered to retrieve particular information for reports. Relational databases are extremely simple to expand and do not require physical organization. After the first database is created, a new data category can be added without modifying all current apps.

Advantages of Relational Database 

Accurate: Data is stored just once, which eliminates data duplication.

Flexible: Complex queries are easy for users to carry out.

 Collaborative: Multiple users can access the same database.

Trusted: Relational database models are mature and well-understood. Secure: Data in tables within relational database management systems can be limited to allow access by only particular users.



Comments

Post a Comment

Popular posts from this blog

What are different steps used in JDBC? Write down a small program showing all steps.

-
 T he fundamental steps involved in the process of connecting to a database and executing a query consist of the following: Import JDBC packages. Load and register the JDBC driver. Open a connection to the database. Create a statement object to perform a query. Execute the statement object and return a query resultset. Process the resultset. Close the resultset and statement objects. Close the connection. These steps are described in detail in the sections that follow. 1. Import JDBC Packages This is for making the JDBC API classes immediately available to the application program. The following import statement should be included in the program irrespective of the JDBC driver being used: import java.sql.*; Additionally, depending on the features being used, Oracle-supplied JDBC packages might need to be imported. For example, the following packages might need to be imported while using the Oracle extensions to JDBC such as using advanced data types such as BLOB, and so on. import o...
Read more

Discuss classification or taxonomy of virtualization at different levels.

-
Image
Taxonomy of virtualization Virtualization is mainly used to emulate the execution environment, storage, and networks. The execution environment is classified into two: – Process-level – implemented on top of an existing operating system.  – System-level – implemented directly on hardware and does not or minimum requirement of the existing operating system. OR,  Virtualization covers a wide range of emulation techniques that are applied to different areas of computing. A classification of these techniques helps us better understand their characteristics and use  V irtualization is mainly used to emulate  ● Execution Environments: To provide support for the execution of the programs eg. OS, and Application.  ○ Process Level: Implemented on top of an existing OS that has full control of the hardware  ○ System Level: Implemented directly on Hardware and do not require support from existing OS.  ● Storage: Storage vi...
Read more

Pure Versus Partial EC

-
Image
Pure Versus Partial EC EC takes several forms depending on the degree of digitization (the transformation from physical to digital). Companies utilizing pure EC conduct all of their business online. Businesses utilizing partial EC conduct a portion of their business online and a portion of their business off-line OR,    Pure E-electronic commerce refers to a situation where a business transacts its business activities PURELY online. that is, the goods or services sold do not have any physical presence. take a business that sells software, for example, you just pay and download, or one that sells music files online. Partial E-Commerce on the other hand refers to a slightly opposite situation where a business has an online presence, but still has a physical location for the goods and services it sells. For example, Amazon, Walmart, and any other you can think of. you buy the goods online but receive them physically.                   ...
Read more