Data Integration and Relational Databases

img1

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.

Everything around us is organized by relational databases, from your social networks to your phone banking application. Relational databases have become part of our daily life without our knowledge. In this same way your organization can benefit by capturing as much information as possibly from your daily operations by creating databases and integrating information across all your departments – the efficient integration of data can result in:

  • minimazation of redundancy
  • processes optimization
  • reduction in overhead cost
  • fast access to real-time data
  • aid descision making