Search your Topic HERE....

February 19, 2012

Data Base Management Systems (Introduction)

41 comments

sponsored links

Friends, in this post we shall discuss the basics of DBMS (Data Base Management Systems) which will be helpful for you for IBPS Specialist Officers Exam (IT Officers). 

Before going into details, lets have a look at the basic terminology of DBMS.

Data :  Data is the raw material from which Useful Information is derived. The word data is the Plural form of Datum (but nowadays, people commonly using data for both singular and plural). 
               Simply we can say that, data is a collection of unorganized  facts, but can be made organized into useful information.
Some examples of data are Prices, Weights, Costs, Number of items sold or purchased etc.

Information : The data, that have been processed in such a ways so as to increase the knowledge  of the person who uses the data is known as information.  Of-course, now a days these terms data and information are closely related and now a days people often interchanging their meanings. 

Data (or) Information Processing : The process of converting the facts into meaningful information is known as Data processing. It is also known as Information processing.

Meta Data : Simply we can say it as the Data about the Data. In other words, The Data that describes the properties of other data is known as Metadata. I mean, Meta Data keeps the information of the Other Data, i.e., it keeps the information HOW and WHERE the other data is stored. 

Data Base : A database is a collection of data (information) of some given Organization (a company for example), that can be processed through one or more programs by multiple users. 
Some examples are A bank, A hospital, A company etc.....

Data Base Management Systems Now you can define the database management systems easily, A Data Base Management System (simply called as DBMS) is A System that manages the Data Base..... 

Not Satisfied? ok " A Software that manages the collection of Data"

Need a technical Definition? "A software that provides an efficient environment to help us in STORING and RETRIEVING the Data Base of an enterprise. 

Our DBMS, Defines Data, Stores Data, Maintains data and ofcourse, Deletes the Data... Thats it :)

Simply our Database is the CONTAINER for a collection of computerized data files. Our DBMS tells us n helps us in  how to insert, maintain and delete these files. 

Now lets have a look at some advantages of Database Management Systems
  • Reduction of Redundancies : Redundancy means duplicating ( I mean, making the same copy of data again and again). Reduction of Redundancy means, avoiding the duplication of data (Remember the warning message "The file named XYZ.JPG is already exist. do you want to replace it???", yea the same thing
  • Data Independence and Efficient Access : The files stored in Database are independent of their storage details.And the change in one file doesnt effect the other (until and unless they related to each other).
  • Data Integrity : Data Integrity means, that the data values entered in the database must be checked to ensure that they fall within the correct format and range. Confused? lets see an example. Suppose I am entering the students details of a School. what is I entered the age of the student as 55 ??? people will laugh at me. So the value should be less than 17. And ofcourse, the Data Integrity also checks whether the referring field is existing or not. I mean, if i want to enter the marks of a person named shivani sharma, first of all it checks whether the name of that person exists in its database or not...
  • Data Security : All of us knows about Security. So no need to discuss. We shall discuss about this in detail later...
  • Less Application Development Time : With the help of some Predefined functions like Concurrency control, Crash Recovery etc, DBMS helps us to develop applications in very less time.
  • Conflict Resolution : It helps us in resolving the conflicts among various users to access the same data file
  • Data Administration : DBMS provides maintenance and administration of data by providing a common base for the large collection of data being shared by several users. 
  • Concurrent Access : Number of users can access a single file Concurrently (I mean, at the same time).
  • Crash Recovery : The DBMS maintains a continuous record for the changes made to the data, so , if there is any system crash by power failure or something, it can restore the Database...



sponsored links

41 comments:

  1. very helpful information for bank exams.Thankyou very much.

    ReplyDelete
  2. PLZ PROVIDE EACH MATERIAL OF IT OFFICER IN PDF

    ReplyDelete
  3. This is helpful. I have seen a typo mistake in Data's definition there is written wich that can be which. Just a suggestion :)

    ReplyDelete
    Replies
    1. Thank you so much for the correction Daljit.. Corrected it now :)

      Delete
  4. thank you for valuable resources

    ReplyDelete
  5. VERY USEFUL WEBSITE....THANKS FOR CREATING IT

    ReplyDelete
  6. GOOD WORK
    I really appreciate the language. very friendly.

    ReplyDelete
  7. very useful information in this webside thanks

    ReplyDelete
  8. great work.......plz provide virus related study materials.....

    ReplyDelete
  9. plz provide this all it officers materials in PDF format...........that will be more useful........

    nice info great work...........thanQ

    ReplyDelete
  10. pelse send me it officer materials in pdf anjnikumarnandwana@gmail.com

    ReplyDelete
  11. These are really great notes,to study with,Thanks a lot,,Please describe Isolation in some more detail, Thanks

    ReplyDelete
  12. Please explain Isolation in some more detail,

    Really great notes to study with Thanks a lot

    ReplyDelete
  13. Plz provide the study materials in PDF format asap.. It helps a lot..

    ReplyDelete
  14. but in exam questions will be deeper i guess so try to improve the quality which will be more useful to everyone

    ReplyDelete
  15. Do the Technical Section in IBPS SO exam is different for Computer Science and Electronics Students ? Or we get a same paper ?

    ReplyDelete
  16. thankuu :)
    Its very useful..
    But pleasee make it as a downloadable file :(

    ReplyDelete
  17. Is this material is enough to study?

    ReplyDelete
  18. A logical schema is is the entire database.but ans given in other site is is a standard way of organizing information into accessible parts.can u tel which one is correct

    ReplyDelete
  19. i will like to thanks to the admin for the splendid job done here . the study material provided is very helpful for exams ......
    thanks a lot ............

    ReplyDelete
  20. I am on the voyage of your study materials.. Feeling great!! Will comment again once the voyage will over..!! I mean.. after exam..:) Truly appreciate your effort..:)

    ReplyDelete
  21. I am on the voyage of your blogs and found it amazing!! Truly appreciate your hard work:) Will comment again once the exam will over..:) Till then, keep up the good work..:)

    ReplyDelete
  22. The study materials provided here is very useful.. Only thing please make it as downloadable PDF file. Please do this alone for us :)

    ReplyDelete
  23. The study materials provided here is very useful. Please share this as downloadable PDF file. Please do this alone for us. It would be very much helpful for Bank aspirants.

    ReplyDelete
  24. pls upload this inf in pdf file,plsssss........Mam........

    ReplyDelete
  25. how can i download this material...plzz help mee

    ReplyDelete
  26. Very good informations. Thanks.

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...