Useful Terms To Understand Databases

62
rate or flag this page

By Ayesha08



We live in an era where computer and oriented things come to us naturally! Let it be the latest version of Microsoft Office or Adobe Photoshop, we automatically indulge ourselves exploring these things and then depending on our interest and requirement, we further pass on our knowledge to those who ask for. But, did you ever come across a situation where you know something pretty well practically, and when it comes to theory, you look for words and ways to describle some particular term? DATABASE is one of those things which can get you thinking theoretically and I am going to define some of the important terms related to Databases in order to simplify the task:

1) DATABASE: It is a huge collection of things and the connections between those things permitting some of the data to be accessed by various programs. We can say that a database collects data!

2) DATA MODEL: It is a figure for a database. It represents the entities in a database and then attributes/information about those entities.

3) DATABASE MANAGEMENT SYSTEM (DBMS): DBMS is basically a software which helps in locating data in a database, as well as adding and editing data.

4) DATA DICTIONARY: It is also known as data directory and is a file which comprises of information and structure of data.

5) FLAT FILE: It holds database in form of a table and keep it in just one file.

6) RELATIONAL DATABASE: It is a multifaceted database structure which consists of various kind of distinguished data.

7) SCHEMA: It shows the exact description of the data items which are kept in a database and also shows the links among the data in a database.

8) NORMAL FORM: It is a method of configuring the data used in relational database with respect to certain rules that helps in avoiding troubles.

9)DATA FILTER: It chooses the bunch of data which is needed for display.

10) DATA WAREHOUSE: This term talks about the big amount of data which is put together in one place for additional processing.

Print   —   Rate it:  up  down  flag this hub

Comments

RSS for comments on this Hub

hardesh profile image

hardesh  says:
2 years ago

I think some one has got too Technical here. Kia baat hai how has this drastic change occured.

But to tell you the truth, the article is quite nice. Many to terms mentioned have been heard first time.

Submit a Comment
Members and Guests

Sign in or sign up and post using a hubpages account.


optional


  • No HTML is allowed in comments, but URLs will be hyperlinked
  • Comments are not for promoting your hubs or other sites

working