How are a file and a database different? Name five types of files and describe t
ID: 3915206 • Letter: H
Question
How are a file and a database different? Name five types of files and describe the primary purpose of each type. Name two types of legacy databases and the main problems associated with each type. Provide two examples of products that use relational database technology, why is this database type most commonly used? What is the biggest strength of the object database; describe two of its weaknesses. How does the multidimensional database store data, provide an example of when a multidimensional database would be used.
Explanation / Answer
File
Database
It is a collection of similar records stored in a hard disk or any storage medium
It is a collection of data framed in a organized manner used to retrieve, update, delete, edit the content in it.
Types of files:
.txt
It is text file used to enter data in a text format.
.mp3
It is one of the audio file format.
.c
It is the source code file for the c and c++ language
.cs
It is the source code file for the c# language
.csv
It is a comma separated value file, in which the values in a record are separated by a common delimiter like comma.
Types of legacy datatypes:
Problems associated with it:
MYSQL was used by the following companies:
Purpose:
It has very good data security.
On demand data scalability
Low cost and complete ownership
Good workflow control
Strength of object database:
It Reduce the maintenance of the data.
It Improve the reliability and flexibility.
Code re-usability is possible.
Weakness are:
How multidimensional database stores data?
Each value of a data in the multidimensional database will be stored in a particular one cell.
Need:
If there is a higher complexity.
If the performance speed is to be increased.
If the above solution is helpful to you in any way please rate it Or if you have any concerns please comment it, I will help you through
File
Database
It is a collection of similar records stored in a hard disk or any storage medium
It is a collection of data framed in a organized manner used to retrieve, update, delete, edit the content in it.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.