|
Home / Computers
Your Friendly Neighborhood Database
By:James Monahan
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.
Digg
del.icio.us
Blink
Stumble
Spurl
Reddit
Netscape
Furl
Article keywords: database, data, memory, storage, information, computer, reports
Article Source: http://www.articles2k.com
James Monahan is the owner and Senior Editor of
TopDatabaseSites.com and writes expert
articles about databases.
|
|
| Top Computers Articles |
- 1). The danger behind peer-to-peer file sharing By : Migz Mon
File sharing is very common nowadays. You can get a P2P (peer-to-peer) program for free, and soon start sharing stuff like music, videos and programs. We use these applications freely and most of us don’t know the risks involved when using them.
Questionable reliability of files – Once we get our hands on a P2P program, we download everything we want like crazy.
|
|
|
|
|
- 4). Is The Internet Censored? By : J Schipper
When most people think about Internet censorship, the usual suspects immediately come to mind : Communist China and repressive Islamic countries. Unfortunately, Westerners have an embarrassment all their own : Australia's net censorship law, established in 2000.
Freedom House, a non-profit U.S. organization dedicated to spreading human rights and freedom, undertakes regular surveys on press freedom and censorship.
|
- 5). Toshiba Libertto U100, smaller yet better than you might imagine! By : john
Have you ever wondered how small a laptop can be? Well, utilizing today’s technology Toshiba does a perfect job at demonstrating it; the Libertto U100 is one of the very few laptops that have such a rich feature set fitted altogether within such a small space. Of course, if you believe that a fingerprint authentication system is too much for such a.
|
- 6). Does CCTV Really Reduce Crime? By : Robert Michael
In the UK, home of twenty percent of the world's CCTV cameras, there is mounting concern about its invasion and lack of regulation. "UK Public CCTV Surveillance Regulation Campaign."
The thought-provoking questions they ask are good ones.
They want to know, for instance, why, if television programming and licensing is so heavily regulated in the UK.
|
|
|
- 8). Preparation Tips For Comptia A+ Certification By :
The Industry Standard CompTIA A Plus Certification exam has two parts; approximately 80 questions for each part.
* Core Hardware: $153 - min. passing score 515
* Operating Systems Technology: $153 - min. passing score 505
(CompTIA corporate members can take the exams for $98, employers that require this test are usually corporate members and will inform you of this.
|
- 9). Can Cell Phones Harm Your Health? By : D Ruplinger
It seems like everywhere a person goes there is at least one person in view with a cell phone to their ear whether it is on the road, in a store, in a parking lot, walking down the street, etc. Even in places where cell phone usage is banned such as concert halls or movie theaters there is the occasional offender, or more likely, at least a few people using the text messaging feature on their phone.
|
|
|
| New Computers Articles |
|
|
|
|
|
|
|
|
- 5). If You Want Flexibility And Portability Consider A Laptop By : Gregg Hall
If you are one of those who works with a computer on a daily basis like me you should consider a laptop. I have actually owned three now and I think I would be lost without mine. I still use my desktop PC quite a bit at home but the laptop comes in extremely handy when I am away.
|
|
|
- 7). Becoming A DVD Repair Expert Online By : Maxine Schel
Many conventional colleges and universities are now offering online DVD repair courses, which are the exact same as those taught on a traditional college campus, to distance learners. Online education is generally taught through the use of several different methods, including online satellite feeds, correspondence or online lessons. This technique permits the student to obtain a DVD repair degree without ever having to step inside of a classroom.
|
- 8). Compatible Inkjet Cartridge By : Isabel Rodrigues
Once the printer ink runs dry it has to be replaced with another inkjet cartridge. There are many reputed companies like Canon, Epson, Dell, and Lexmark that provide the necessary cartridges to replace the empty cartridges. Replacing inkjet cartridge can add to a very big cost. It could be worse if you have to replace the empty cartridges frequently every month.
|
- 9). Best Passwords By : Richard Romando
No sane person would ever like someone else reading her email. Or for that matter some other person using her password and breaking into a financial institution. You should, therefore, choose a strong, secure password in such a manner that would be a hard nut to crack for others and easy for you to remember. The more random and mixed-up you make it, the harder it is for others to crack.
|
- 10). Home Printing Machines By : Peter Vermeeren
Home printing machines are available on the market today in many sizes, prices and capabilities. Many different forms of printing can be accomplished in the home. Whether you want to create unique tee-shirts using a home screen printing machine or you want to produce elegant laser printed letters, the equipment is readily available to you for home use.
|
|
|
