0
Want this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
What is file oriented approach and database oriented approach?
The file is store the data as document type, we don't have give particular data-type of data which will be store in it. But in database system there are specified structure (like in table format) of data store. First we have to make format with particulate data-type for the data, which will store in it. other The file has no record system, while database system store data with record in row, it is easy to maintain.
What factors influence the development of database concept?
Before the intruduction of this database concept many people used Manual Processing and File based systems.But there are some limitations. Manual Processing-Time consuming Does not support large volumes of data File Based System-Data Inconsistency Duplication of data Security problems And to overcome the limitations of these processing this Database processing was intruduced
What are the major disadvantage of file processing system?
File processing system is inconsistent and disintegrared.It is difficult to access and may be present on different platforms which would not allow to integrate data
What is mean by file organization in data structure of c?
File organization is the methodology which is applied to structured computer files. Files contain computer records which can be documents or information which is stored in a certain way for later retrieval. File organization refers primarily to the logical arrangement of data (which can itself be organized in a system of records with correlation between the fields/columns) in a file system
Difference between file processing and dbms?
File based approach can be attributed to two factors: 1. the definition of the data is embedded in the application programs, rather than being stored separately and independently. 2. there is no control over the access and manipulation of data beyond that imposed by the application programs. To become more effective, a new approach was required. What emerged were the database and the DBMS (Database management system).
What are the limitations of a file-based approach?
* Separation and isolation of data * Duplication of data * Data dependence * Incompatibility of files * Fixed queries / proliferation of application programs
What is structural dependence?
A file system exhibits structural dependence, which means that access to a file is dependent on its structure. For example, adding a customer date-of-birth field to the CUSTOMER, Given this change, none of the previous programs will work with the new CUSTOMER file structure. Therefore, all of the file system programs must be modified to conform to the new file structure. In short, because the file system application programs are affected by change in the file structure, they exhibit structural dependence. Conversely, structural independence exists when it is possible to make changes in the file structure without affecting the application program’s ability to access the data.
What is a structural dependence?
A file system exhibits structural dependence, which means that access to a file is dependent on its structure. For example, adding a customer date-of-birth field to the CUSTOMER, Given this change, none of the previous programs will work with the new CUSTOMER file structure. Therefore, all of the file system programs must be modified to conform to the new file structure. In short, because the file system application programs are affected by change in the file structure, they exhibit structural dependence. Conversely, structural independence exists when it is possible to make changes in the file structure without affecting the application program’s ability to access the data.
The data file belonging to the SYSTEM tablespace is corrupted and no backup of the file is availble how do you recover the data file?
The data file cannot be recovered.
What is the limitation of File processing system?
Some limitation of file processing include:1. Data redundancy and inconsistency2. Difficulty in accessing data3. challenges with data security4. Often, time consuming and tedious
What is program data dependence?
Program data dependence refers to the coupling of data stored in files and the specific programs required to update and maintain those files such that changes in programs require changes to the data. In a tradition file environment, any change in a software program could require a change in the data accessed by that program.
What are the advantage of file manage ment system?
Advantage Of file management system is that the data is secured . Also The data is archieved if is not used.
DBMS has replaced the traditional file system?
Yes. Database Management Systems (DBMS) have replaced the traditional file based data storage systems. This is because they are:More powerfulEasier to manangeCan store large volumnes of dataManipulation & fetching of data from a DBMS is many times easier than doing so from a file based data storage systemFaster
What is meant by the file based approach to storing data?
NO
What is drawback traditional file system?
Two of the drawbacks of a traditional file system are that, at the limits, data cannot be found easily (you need to remember the pathname of the file) or quickly (the access time depends on where the data is in the file).
How data was stored before MS access and what were the disadvantages of that mannual file system?
By using file System...
What is a file- based data management approach?
File-based Data Management Approach is a system of storing information by having a separate program to handle a specific type of file only or directory. This kind of system is being used by large companies with several departments to better manage their information separately. The Oregon Trail totaled 2,000 miles and took six to seven months to travel its complete length. Oregon Trail can be explored by land or even by the sea.
