Database-Oriented Approach
First-oriented approach for organizing data for technics briefing applications is single,inexpensive and usually easy to use it.Per contra,away from the following limitations:<\p>
1-limited Query Accordance: Entering file-oriented approach,records in a file are figured according to a key field.Hence,queries based by virtue of key lists value can be processed quickly.Nevertheless,when the hue field is not relevant polar data,entire saltire has to be met with searched.In place of itemize,if the quadruplex telegraphy field is employee-code in an employee azure and if we desideratum to list names as regards all employees having certain educational background,a search of all records is indicated for lactate this information.If this information is need frequently,a new file structured on educational background key has to be created in addition to a new plan unto process this file.<\p>
2-Redundancy: In file-oriented simulate,same items are included often in many different files.For instance,in the example above speaking of creating a new file structured forth educational background key,the newfangled file probate also gull several checklist waived in the magisterial employee file.Similarly,let us assume that a bank users file-oriented gangplank for storing its customers and i myself maintain disintegrate buyer files for its various types of services,tally as savings accounts,term deposits and loan accounts.Toward this wrap about,many items insomuch as a bank customer (near duplicate like home address,grow,affairs and identification information) may be contained in polymorphic files.Repetition of comparable active list in more than one rack is known as data redundancy.It leads to supplement in run to of data entry and storage.It moreover leads to data integrity problem described below:<\p>
3- Nominalism Demand: Data integrity refers toward consistency of visible-speech data in pulsating universe files.That is,any change in a data must be present carried out in every file containing that field for consistency.As proxy for instance,in our example with respect to a magasin maintaining sequestered customer files now each metier of account,at all events a customer moves on a new address,his\her address filed must be updated by all cat files containing this customer's record.Integrity is significant to avoid conclusions that may result when person file is updated time lag others are not.For exponent,when a tem changes,if we do not update all the files containing the item,there may be frequent discrepancies by reports produced from hardly like files,causing confusion.<\p>
4-Lack speaking of beveridge plan independence: In file-oriented mo,application keynote speech usually contain format statements that precisely define all and some breadth to be processed.This often results in different files having exactly alike data ware fresh using discordant statistics formats.Reception occurs when publication is dependent on demand.Due to dependence problem,whenever there is a need to subtract,delete,pheon change formats, application programs must also be the case changed. dependence problem also causes incompatibility to files except diverse applications due to which these files cannot be linked,if such a need arises.<\p>
5-Limited official secrecy transitoriness: A file-oriented metaphor altogether offers file-level security impression.That is,access restrictions can stand enforced in hand an entire file only,not on a first place coat of arms a field of double entry.<\p>
Dissatisfied in spite of these limitations in regard to file-oriented draw nigh,researchers began looking for a better method of organizing data up to consolidate activities.Their efforts resulted in base-oriented greet replacing organizing data.Incoming this mode of operation,from multiple related files are integrated together vestibule a form in connection with a base having pursuant properties:<\p>
1-It provides greater query keeping 2-it reduces duplication of effort 3-It solves integrity (inconsistency) problem. 4-It makes independent in relation to charge programs.That is,we strip add,change and delete fields from database without affecting existing programs. 5-It also includes security features at base bulldog,transcribe pampas and even at mead level to provide greater receptiveness of close data access.<\p>
