0
What are the advantages of a data based system over a file based system?
Wiki User
∙ 16y ago
Advantages of DBMS (Database Management Systems) are followings:
A true DBMS offers several advantages over file processing. The principal advantages of a DBMS are the followings:
• Flexibility: Because programs and data are independent, programs do not have to be modified when types of unrelated data are added to or deleted from the database, or when physical storage changes.
• Fast response to information requests: Because data are integrated into a single database, complex requests can be handled much more rapidly then if the data were located in separate, non-integrated files. In many businesses, faster response means better customer service.
• Multiple access: Database software allows data to be accessed in a variety of ways (such as through various key fields) and often, by using several programming languages (both 3GL and nonprocedural 4GL programs).
• Lower user training costs: Users often find it easier to learn such systems and training costs may be reduced. Also, the total time taken to process requests may be shorter, which would increase user productivity.
• Less storage: Theoretically, all occurrences of data items need be stored only once, thereby eliminating the storage of redundant data. System developers and database designers often use data normalization to minimize data redundancy.
Wiki User
∙ 14y ago
Wiki User
∙ 16y agoA database system allows multiple table with separate entities to be created. This improves organisation and relationships between tables can be formed. This allows queries and reports to be made for comparison. A file based system is bad as every time you enter a new record or data is changed e.g. someone gets married, changes address, then every record previously will need to be changed. This makes redundant data (uses up a lot of RAM) and is time consuming
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 various file-accessing techniques in data management system?
Explain the various file-accessing techniques in data management system. Also state the advantages and limitations of each technique
What are the advantages of a file management system?
Some of the advantages are: 1. A file management system will allow user to create and store Meta data. Meta data is data about the files. 2. A file is indexed for faster and easier retrieval. Gives structure to all your info. You will be able to manage all your information much easier.
Advantages of filing system?
advantage of filing system is this that we can easily find our files
File management system advantages and disadvantages?
Some of the advantages are: 1. A file management system will allow user to create and store Meta data. Meta data is data about the files. 2. A file is indexed for faster and easier retrieval. Gives structure to all your info. You will be able to manage all your information much easier. some disadvantages of file management system.:- 1.minimal security of data 2.there is data redundancy 3.it cannot generate queries
What are the advantages and dis advantages of file?
file is data storage structure it is collection of record
What are the advantages and disadvantages of file based systems?
File-based systems are low cost and do not need external storage or somebody that is extremely knowledgeable in technology. Disadvantages include data duplication, lack of flexibility, and a lack of security.
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 the difference between database and file system?
A database is a structured collection of data organized for efficient retrieval, storage, and manipulation, while a file system is a method used by operating systems to store, organize, and access files on a computer. Databases provide features like data integrity, relationships, and query capabilities, whereas file systems primarily focus on storing and managing individual files.
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.
Advantages n disadvantages of traditional file system?
A disadvantage of a traditional file system is human error. When a file is filed in the wrong place it can be a long time before the file is located. Another disadvantage is the possibility of fire destroying the records. An advantage to this type of filing system is that there is a hard copy of everything that is filed. A file can be copied for several users of the file.
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
