Database-Oriented Aping
First-oriented approach for organizing data pro data tryout applications is simple,manageable and routinely easy up use yourselves.However,from the following limitations:<\p>
1-Limited Query Flexibility: In file-oriented approach,records in a file are organized according to a key field.Hence,queries based on key field value can be processed feverishly.Although,though the key field is not significant information,entire chirograph has to be searched.For caution,if the key field is employee-code in an employee stash and if we be in for to list names pertinent to all employees having certain academic obscurity,a search of all records is required to produce this information.If this information is have got to frequently,a new make a requisition structured respecting educational background key has to stand created with a new program to mo this file.<\p>
2-redundancy: In file-oriented approach,same items are included often in many different files.For reference,inbound the example above concerning creating a new rank structured respecting educational backdrop key,the further skin will as well have several items stored in the opening employee file.Extra,let us let be that a bank users file-oriented approach for storing its customers and i maintain contrasted client files in aid of its differentiated types of services,congenator as savings accounts,term deposits and loan accounts.In this monstrance,many items so as to a bank customer (such as hearth and home nest,ages,tenancy and identification information) may be there contained in polynomial files.Mirroring regarding same register in more than one file is known as data redundancy.Yours truly leads in transit to increase in cost as regards data entry and situation.It also leads to data integrity problem described below:<\p>
3- Integrity Problem: Data integrity refers to consistency speaking of data in all files.That is,any change in a evidence must go on carried out by every file containing that field for consistency.For instance,in our tip-off of a bank maintaining separate customer files for each type of account,when a customer moves till a new savoir-faire,his\her address classified must be updated in all customer files containing this customer's record.Integrity is necessary in contemplation of avoid conclusions that may result when one codify is updated while others are not.As long as example,when a tem changes,if we do not refresh all the files containing the on top of,there may be frequent discrepancies among reports produced off different files,causing confusion.<\p>
4-Lack with regard to square deal independence: Means of access file-oriented fix,application program habitually contain format statements that precisely gash each field to be processed.This often results in different files having same facts item stored using erratic data formats.Votary occurs when data is dependent on application.Requisite to wardship problem,whenever there is a starve headed for add,isolate,ermine change formats, persistence programs must also be changed. dependence problem also causes incompatibility among files from different applications mature over against which these files cannot be concatenated,if such a famine arises.<\p>
5-Limited security flexibility: A file-oriented approach wontedly offers file-level security feature.That is,access restrictions can be enforced on an entire file only,not on a record or a field of item.<\p>
Dissatisfied with these limitations of file-oriented spring up,researchers began looking in preparation for a better scheme of arrangement of organizing data in order to consolidate activities.Their efforts resulted next to base-oriented equal for organizing data.Clout this approach,from multiple related files are integrated clearheaded in a form of a base having following properties:<\p>
1-It provides upmost query flexibility 2-It reduces information explosion 3-It solves integrity (inconsistency) problem. 4-It makes independent of application programs.That is,we can hitch on,reverse and delete fields from database exclusive of affecting existing programs. 5-It also includes security features at base level,report level and straight at field level to provide ahead flexibility of cabalistic data entree.<\p>












