Home » Computers » Databases

Your Friendly Neighborhood Database

Aug 17, 2007
For the lay person, the term database is just another geek word that is just so prevalent in today's society. From the office, to the home, and to just about any industry, people refer to their information as being kept in a 'database'.

So somehow, we all get this idea that the database is some cabinet that holds all the data for a given organization.

But what is a database, anyway?

A database is any collection of data organized for storage in a computer memory and designed for easy access by authorized users. The data may be in the form of text, numbers, dates, or encoded graphics.

Since databases made their debut 1950s, they have become mightily important in the everyday operations of every major and even minor industry.

Databases make the output of needed data and reports easy, convenient, and almost instantaneous. This is a far cry from the 'barbaric' methods once employed by every industry.

Those outdated methods included collating data from paper files whenever a report was needed. That process wasted a lot of time and effort. With the help of databases, these manual methods quickly found their demise.

Small databases were first developed or funded by the U.S. government for agency or professional use. But in the 1960s, databases became commercially available to the public.

However, their use was channeled through a few so-called research centers that collected information inquiries and performed them in batches. Online databases-that is, databases available to anyone who could link up to them by computer-first appeared in the 1970's.

Computer programs that manage and query a database are known as database management systems (DBMS). Database systems are actively studied in information science.

The overriding concept of databases is the idea of a collection of facts, or pieces of information. Databases may be structured in a number of ways, known as database models.

Database Models
Flat Model

The flat (or table) model consists of a single, two-dimensional array of data elements. All members of a given column are assumed to be similar values, and all members of a row are assumed to be related to one another. For instance, columns for name and password might be used as a part of a system security database.

Each row would have the specific password associated with a specific user. Columns of the table often have a type associated with them, defining them as character data, date or time information, integers, or floating point numbers.

This model is the basis spreadsheet systems such as Lotus 123 or Microsoft Excel. However, these applications are not typically thought of as databases per se.

Network Model

The network model allows multiple datasets to be used together through the use of pointers (or references). Some columns contain pointers to different tables instead of data. Many major industries adopted this model in the past few decades.

Relational Model

The relational model is the most popular of the database models today. This model is the basis for such database systems as Oracle, mySQL, and even Microsoft Access.

In this model, logically related data is kept in tables not unlike the flat model. However, unlike the network model in which tables are connected via pointers, the relational model is interconnected using keys or values within data rows in tables that point to other tables.

The SQL or Structured Query Language is used to manipulate and derive data from such databases.
About the Author
James Monahan is the owner and Senior Editor of TopDatabaseSites.com and writes expert articles about databases .
Rating:
Please Rate:
(Average: Not rated)
Views: 378
Print Email Report Share
Article Categories
    • Artists
    • Gambling
    • Humanities
    • Humor
    • Movies
    • Music
    • Photography
    • Tattoos
    • Television
    • Classic Cars
    • Motorcycles
    • Recreational Vehicles
    • SUVs
    • Trucks
    • Vans
    • Branding
    • Business Opportunities
    • Careers and Jobs
    • Corporate
    • Customer Service
    • Direct Mail
    • Entrepreneurship
    • Ethics
    • Financing
    • Franchising
    • Home-Based Business
    • Human Resources
    • Import and Export
    • Leadership
    • Management
    • Market Research
    • Marketing and Advertising
    • Negotiation
    • Network Marketing
    • Networking
    • Organizational
    • Presentation
    • Project Management
    • Public Relations
    • Small Business
    • Strategic Planning
    • Team Building
    • Telemarketing
    • Training
    • Ask an Expert
    • College and University
    • Home Schooling
    • K-12
    • Languages
    • Online Education
    • Psychology
    • Accounting
    • Credit
    • Currency Trading
    • Debt Consolidation
    • Insurance
    • Investing
    • Leasing
    • Loans
    • Mortgage
    • Mutual Funds
    • Personal Finance
    • Stock Market
    • Structured Settlements
    • Taxes
    • Wealth Building
    • Coffee
    • Cooking
    • Gourmet
    • Recipes
    • Wine and Spirits
    • Acne
    • Aerobics
    • Alternative Medicine
    • Beauty
    • Cancer
    • Cosmetics
    • Depression
    • Diabetes
    • Diseases and Conditions
    • Fitness Equipment
    • Fitness
    • Hair Loss
    • Heart Disease
    • Medicine
    • Men's Health
    • Muscle Building
    • Nutrition
    • Skin Care
    • Supplements and Vitamins
    • Weight Loss
    • Women's Health
    • Yoga
    • Arts and Crafts
    • Babies
    • Collecting
    • Elderly Care
    • Genealogy
    • Hobbies
    • Parenting
    • Pets
    • Pregnancy
    • Woodworking
    • Feng Shui
    • Gardening
    • Home Appliances
    • Home Security
    • Interior Design
    • Landscaping
    • Affiliate Programs
    • Article Marketing
    • Auctions
    • Audio
    • Banner Advertising
    • Blogging
    • Broadband
    • Domain Names
    • E-Books
    • E-Commerce
    • Email Marketing
    • Ezines and Newsletters
    • Forums
    • Internet Marketing
    • Link Popularity
    • Pay-Per-Click
    • Podcasting
    • RSS
    • Search Engine Marketing
    • Search Engine Optimization
    • Security
    • Social Media
    • Spam
    • Video
    • Viral Marketing
    • Web Design
    • Web Development
    • Web Hosting
    • Copyright
    • Cyber Law
    • Intellectual Property
    • National, State, Local
    • Patents
    • Regulatory Compliance
    • Trademarks
    • Buying
    • Selling
    • Baseball
    • Basketball
    • Boating
    • Cycling
    • Extreme Sports
    • Fishing
    • Football
    • Golf
    • Hockey
    • Hunting
    • Martial Arts
    • Running
    • Scuba Diving
    • Soccer
    • Swimming
    • Tennis
    • Dating
    • Divorce
    • Marriage
    • Weddings
    • Astrology
    • Buddhism
    • Christianity
    • Faith
    • Hinduism
    • Islam
    • Judaism
    • Meditation
    • Metaphysical
    • New Age
    • Cable and Satellite TV
    • Cell Phones
    • Communication
    • Gadgets and Gizmos
    • GPS
    • Satellite Radio
    • Video Conferencing
    • VoIP
    • Addictions
    • Coaching
    • Goal Setting
    • Motivational
    • Stress Management
    • Time Management
    • Clothing
    • Electronics
    • Fashion
    • Gifts
    • Jewelry
    • Causes and Organizations
    • Environment
    • History
    • Holidays
    • Men's Issues
    • Nature
    • Philosophy
    • Politics
    • Women's Issues
    • World Affairs
    • Air Travel
    • Camping
    • Cruises
    • Destinations
    • Outdoors
    • Article Writing
    • Book Reviews
    • Copywriting
    • Fiction
    • Non-Fiction
    • Poetry
    • Quotes
    • Screenplay
    • Tools and Resources