Relational Database (RDB)
A relational database (RDB) is a collective set of multiple data sets organized by tables, records and columns. It was invented by E.F. Codd at IBM in 1970. RDBs established a well defined relationship between database tables. Tables communicate and share information, which facilitates data search ability, organization and reporting. RDBs organize data in different ways. Each table is known as a relation, which contains one or more data category columns. Each table record (or two) contains a unique data or record characteristics relate to one or many records to form functional dependencies. RDBs have many other advantages, including:
- Easy extendability, as new data may be added without modifying existing records. This is also known as scalability.
- New technology performance, power and flexibility with multiple data requirement capabilities.
- Data security, which is critical when data sharing is based on privacy. For example, management may share certain data privileges and access and block employees from other data, such as confidential salary or benefit information.
The software that manages ( creation, modification, deletion, addition of data) relational database is called relational database management system (RDBMS) software. Some popular RDBMS software are Oracle, SQL server, etc. A relational database management system (RDBMS) is a database system based on the relational model specified by Edgar F. Codd–the father of modern relational database design–in 1970.
Most modern commercial and open source database applications are relational in nature. The most important relational database features include an ability to use tables for data storage while maintaining and enforcing certain data relationships.
DBMS: Commonly heard term by IT and business students. Main concern is what database really is? Today, we’re going to learn about DBMS. To understand the term DBMS we have to understand how DBMS is formed. The term DBMS stands for Database management System. Let’s separate DBMS into possible pieces. Database, Management and System are the core terms to understand DBMS.
Let’s talk about Database. Database is also the combined term which includes Data & Information. Data is a collection of raw form of facts and figures, unarranged, unorganized unrelated. For eg: L, E, N, I, A are four alphabets, they only mean alphabets only; a single L means character only without any meaning. Now the term information is so much related to the word Data because, information is the advanced and collective form of data. For eg: characters L, E, N, I, A when arranged it gives the word ALIEN, which has a meaning with it. Therefore, scattered pieces of information is data, arranged and collective form of data is information.
After you’ve understood the terms Data and Information, now it’s time to understand about database. Database can be defined simply as, related form of information. In other words, A database is a collection of interrelated data of certain place or things in such a way that it can be easily accessed by programs like DBMS.
Thank You for visiting us.
Visit again for daily updates and more tech related information.
You May Also Like: