Skip to content

Data Center Solutions

Data Center Solutions | Server | Storage | Virtualization

Call us : +989338090352

  • Home
  • About Us
  • Products
  • Services
  • Solutions
  • Edu TV
  • Contact Us

Relational Database

Relational Database

Relational Database

A relational database is a collection of data items organized as a set of formally-described tables from which data can be accessed or reassembled in many different ways without having to reorganize the database tables. The relational database was invented by E. F. Codd at IBM in 1970.

The standard user and application program interface to a relational database is the structured query language (SQL). SQL statements are used both for interactive queries for information from a relational database and for gathering data for reports.

In addition to being relatively easy to create and access, a relational database has the important advantage of being easy to extend. After the original database creation, a new data category can be added without requiring that all existing applications be modified.

A relational database is a set of tables containing data fitted into predefined categories. Each table (which is sometimes called a relation) contains one or more data categories in columns. Each row contains a unique instance of data for the categories defined by the columns. For example, a typical business order entry database would include a table that described a customer with columns for name, address, phone number, and so forth. Another table would describe an order: product, customer, date, sales price, and so forth. A user of the database could obtain a view of the database that fitted the user’s needs. For example, a branch office manager might like a view or report on all customers that had bought products after a certain date. A financial services manager in the same company could, from the same tables, obtain a report on accounts that needed to be paid.

When creating a relational database, you can define the domain of possible values in a data column and further constraints that may apply to that data value. For example, a domain of possible customers could allow up to ten possible customer names but be constrained in one table to allowing only three of these customer names to be specifiable.

The definition of a relational database results in a table of metadata or formal descriptions of the tables, columns, domains, and constraints.

Share on Facebook Share
Share on TwitterTweet
Share on Pinterest Share
Share on LinkedIn Share
Share on Digg Share

VMware

11 Oct

PCoIP (PC over IP) Definition

PCoIP (PC over IP) PC over IP (PCoI...
4 Jun

VMware Tools in Kali Linux

VMware Tools in Kali Linux Should you decide ...
4 Jun

How to Install VMware Tools on Ubuntu 16.04 and 16.10

How to Install VMware Tools on Ubuntu 16.04 and ...
View All

HP

no-image
HP Proliant Microserver Gen10 as Router or NAS Introduction In the summer of 2017, HP re...
HP Proliant Microserver Gen10 as Router or NAS
no-image
HP C7000 Enclosure fan location rules The HP BladeSystem c7000 Enclosure ships with fou...
HP C7000 Enclosure fan location rules
no-image
Adjusting UEFI boot order on ProLiant DL580 Gen8 When HP introduced the ProLiant DL580 Ge...
Adjusting UEFI boot order on ProLiant DL580 Gen8
View All

vCenter Group

A DirectNET Company
2655 Crescent Dr. Unit B
Lafayette, CO 80026

Contact 42U Sales
1-800-638-2638
Sales@42u.com

Tags

Application virtualization cloud computing data center Desktop virtualization DRM EMC Ethernet FAST VP FC FCoE Fibre Channel file formats file systems FTP HBA http hypervisor iSCSI ISPs LAN LTE LUN metadata Network virtualization NTFS optical fiber replication SaaS SAN server virtualization storage Storage Virtualization TCP/IP virtualization Virtualization Definition Virtualization Solutions virtual machine VMWare VMware Solutions VMware Tools VMware Workstation VNX VNXe VNXe3300 WAN

Products

Find What You Need

  • HPE
  • NetApp
  • VMware
  • Cisco
  • EMC
  • Microsoft
vCenter Group
WordPress Theme : AccessPress Lite