Compare file system and database system.

Compare file system and database system. 
by

1 Answer

Answer :

File system
Database system 
1. File processing don't contain any self describing feature and neither posses metadata. 
1. Presence of Self-describing nature of a database system and Metadata.
2. In file processing, if any changes to the structure of a file may require changing all programs that access the file
2. In database system, the structure of data files is stored in the DBMS catalog separately from the access program. This is called program-data independence 
3. File processing system don't support multiple views. 
3.Support of multiple views of the data i.e. Each user may see a different view of the database, which describes only the data of interest to that user
4. It is not possible to share data and multi user transaction simultaneously among concurrent users in case of file processing system 
4. Sharing of data and multiuser transaction processing i.e allowing a set of concurrent users to retrieve from and to update the database. 
5. The traditional file approach, each group independently keeps their own file. 
5. Controlling Redundancy is one of most important feature to use DBMS
by

Related questions

Describe centralized database system with example.

Description : Describe centralized database system with example. 

Last Answer : Centralized Database System: 1. A centralized database consists of a single data server into which all data are stored and from which all data are retrieved. All the data reside at a single location and ... is cheaper than other types of databases as it requires less power and maintenance. 

Explain client/server database system.

Description : Explain client/server database system. 

Last Answer : 1. It has two logical parts client and server.  2. Computer networking allows some task to be executed on a server system and some tasks on client system. This leads to development ... as application server to receive and send requests from client machine to database server and vice versa.

Define Database. List advantages of database system.

Description : Define Database. List advantages of database system. 

Last Answer : A database is an organized collection of data so that it can be easily accessed, managed and updated. Advantages of database system are the following:  1. Controlling ... Providing Backup and Recovery facilities is provide by DBMS for recovering from hardware or software failures.

Explain distributed database system with example.

Description : Explain distributed database system with example.

Last Answer : A distributed database is a database that consists of two or more files located in different sites either on the same network or on entirely different networks. Portions of the database ... Ignite, Apache Cassandra, Apache HBase, Couchbase Server, Amazon SimpleDB, Clusterpoint, and FoundationDB

Explain three level architecture of Database

Description : Explain three level architecture of Database

Last Answer : There are following three levels or layers of DBMS architecture: External Level : Describes part of the database that a particular user group is interested in. Conceptual Level: Describes structure of ... is the one that concerns the way the data are physically stored on the hardware.

State characteristics of Database.

Description : State characteristics of Database.

Last Answer : The Characteristics of Database are: 1. Persistent Data 2. Meta Data and Self-describing nature of a DB 3. Insulation between programs and data (Data Independence) 4. Support ... Sharing of data and multiuser transaction processing 6. Access flexibility and Security. 7. Controlled Redundancy

List types of Database languages.

Description : List types of Database languages.

Last Answer : Four types of database languages are: 1. DDL (Data Definition Language) 2. DML (Data Manipulation Language) 3. DDL (Data Control Language) 4. TCL (Transaction control language)

Define the term Database Schema

Description : Define the term Database Schema

Last Answer : The overall design of the database is called the database schema. A schema diagram displays only names of record types (entities) and names of data items (attributes) and does not show the relationships among the various files. 

Distinguish between network database model and relational database model.

Description : Distinguish between network database model and relational database model. 

Last Answer : Network database model Relational database model Relationship between records is expressed in the form of pointers or links Relationship between records is represented by a relation that contains a key for ... logically in the form of rows and columns. Example:  Example: 

Define database model.

Description : Define database model. 

Last Answer : Definition of database model: A database model is a type of data model that determines the logical structure of a database. It also fundamentally determines in which manner data can be stored, organized and manipulated. 

Explain merits and demerits of Object Oriented Database model.

Description : Explain merits and demerits of Object Oriented Database model.

Last Answer : Object oriented models were introduced to overcome the shortcomings of conventional models like Relational, Hierarchical and network model. An object-oriented database is collection of objects whose behavior, state, ... . * There is no view mechanism * There is no adequate security mechanism.

Differentiate between Hierarchical Database model and network database model.

Description : Differentiate between Hierarchical Database model and network database model.

Last Answer : Hierarchical Database Model  Network Model Network Model represents tree like structure with one root. Network Model represents tree like structure with many roots. Reflects 1:N ( ... the use of pointers Record relationship implementation is complex due to the use of pointers

Explain components of database in detail.

Description : Explain components of database in detail.

Last Answer : A database system involves four major components. 1. Data 2. Hardware 3. Software 4. Users

Explain three tier architecture of database with the help of diagram.

Description : Explain three tier architecture of database with the help of diagram.

Last Answer : Application server or Web server *Adds intermediate layer between client and the database server *Runs application programs and stores business rules Clients contain GUI interfaces and ... GUI format. Thus the user interfaces, application rules and the database acts as three tier. 

Distinguish between file processing system and DBMS.

Description : Distinguish between file processing system and DBMS.

Last Answer : Database Management system File processing system 1. Presence of Self-describing nature of a database system and Metadata. 1. File processing don't contain any self describing feature and ... to use DBMS 5. Controlling Redundancy is one of most important feature to use DBMS

Describe client server system with example.

Description : Describe client server system with example.

Last Answer : Client server system consists of two logical components. One is Client and the other one is Server . Clients are those who send the request to perform a specific task to the server. ... client's CPU and memory. But server runs a database management system which manages the whole database.

Explain various types of Relational constraints.

Description : Explain various types of Relational constraints.

Last Answer : Relational Constraints Relational constraints are a set of rules. It is used to maintain the quality of information. Integrity constraints ensure that the data insertion, updating, and other ... - It establishes parent child relationship between two tables. For example :Foreign key constraints 

Explain advantages of centralized and distributed databases.

Description : Explain advantages of centralized and distributed databases.

Last Answer : Advantage of Centralized databases   * Data integrity is maximized -Data integrity is maximized and data redundancy is minimized because data is stored at a single place.  * Easier Database Administration - ... data is distributed, a group of users can easily share and use data of different sites

Describe the three levels of data abstraction with diagram.

Description : Describe the three levels of data abstraction with diagram. 

Last Answer : Three levels of data abstraction are:  Physical level: This is the lowest level of data abstraction. It describes how data is actually stored in database. The complex data structure details ... highest level of data abstraction. This level describes the user interaction with database system.

Describe object-oriented data models.

Description : Describe object-oriented data models.

Last Answer : Object Oriented Model : Object oriented models were introduced to overcome the shortcomings of conventional models like Relational, Hierarchical and network model. An object-oriented database is collection of objects whose ... with other objects. It is also said to be semantic data model.

Define the term Foreign Key.

Description : Define the term Foreign Key. 

Last Answer : A FOREIGN KEY is a key used to link two tables together. A FOREIGN KEY is a field (or collection of fields) in one table that refers to the PRIMARY KEY in another table. It ... between tables because it references the primary key of another table, thereby establishing a link between them.

Define the term Data Model.

Description : Define the term Data Model.

Last Answer : Underlying structure of the database is called as data model. It is a collection of conceptual tools for describing data, data relationships, data semantics and consistency constraints. Data models define how data is connected to each other and how they are processed and stored inside the system.

Describe enhanced ER model with the help of example.

Description : Describe enhanced ER model with the help of example. 

Last Answer : Enhanced ER is a high-level data model that incorporates the extensions to the original ER model. It is created to design more accurate database schemas. EER reflects data properties and constraints more precisely ... example: Square, Circle, Triangle are the sub class of Shape super class. 

List advantages of Normalization.

Description : List advantages of Normalization. 

Last Answer : List of Advantages of Normalization are the following: 1. More efficient data structure. 2. Avoid redundant fields or columns. 3. More flexible data structure i.e. we should be able to ... 7. Minimizes data duplication. 8. Close modeling of real world entities, processes and their relationships.

Define Constraint.

Description : Define Constraint. 

Last Answer : Constraints are the rules enforced on the data columns of a table. These are used to limit the type of data that can go into a table. This ensures the accuracy and reliability of the data in ... are applied only to one column, whereas the table level constraints are applied to the whole table. 

Define Domain and Attribute.

Description : Define Domain and Attribute. 

Last Answer : * Domain: All permissible values of attributes are called as a domain. * Attribute: is a property or characteristics of an entity set. 

List DBMS softwares.

Description : List DBMS softwares. 

Last Answer : List of DBMS software are the followings: i. Oracle RDBMS ii. IBM DB2 iii, Microsoft SQL Server iv. MySQL v. MS Access vi. SQLite vii. PostgreSQL viii. MongoDB ix. SQL Developer x. SAP Sybase SE 

Explain Codd’s rules.

Description : Explain Codd’s rules.

Last Answer : Codd rules:  Rule 1: The information rule a has to be presented to the user should be in the form of table.  Rule 2: Guaranteed Access Rule Whole data should be available or ... interface cannot be used to subvert the system, for example, bypassing a relational security or integrity constraint

Explain functional dependency with example.

Description : Explain functional dependency with example.

Last Answer : A functional dependency occurs when one attribute in a relation uniquely determines another attribute. OR Consider a relation say R(X,Y), where X and Y are one or more than one attribute, ... sscper. That is, given rollno of a student, the name and sscper can be determined or searched.

Explain different types of attribute with example and their symbols used in ER diagram.

Description : Explain different types of attribute with example and their symbols used in ER diagram.

Last Answer : Different types of attributes are: 1. Simple attribute: A simple attributes are those which cannot be subdivided. Eg:Rollno-  symbol 2. Composite attribute: a composite attribute is ... value can be calculated or determined from another attribute Eg: age from dateofbirth  Symbol

Describe benefits and drawbook of denormalization.

Description : Describe benefits and drawbook of denormalization.

Last Answer : Benefits of denormalization: * Reduce number of relations: It reduce the number of relations because it combines two relations into one new relation. * Reduce number of foreign keys: It reduce number ... : It is always application-specific and needs to be re-evaluated if the application changes. 

Explain Domain constraints with Syntax and example.

Description : Explain Domain constraints with Syntax and example. 

Last Answer : Domain constraints are used to maintain value according to user specification Domain constraints are: 1. Not null-such constraints are applied to an attribute when we have to specify that the ... datatype(size),attr2 datatype(size) constraint nameofconstraint check(attr<value)); or

Explain Generalization with example.

Description : Explain Generalization with example.

Last Answer : Generalization uses bottom-up approach where two or more lower level entities combine together to form a higher level new entity if they have common attributes in common. The new generalized entity can ... Example, STUDENT and FACULTY can be generalized to a higher level entity called PERSON

Define Normalization, list its types.

Description : Define Normalization, list its types.

Last Answer : Normalization is a systematic approach of decomposing tables to eliminate data redundancy(repetition) and undesirable characteristics like Insertion, Update and Deletion Anomalies. It is a multi-step process that ... data from the relation tables. Types of Normalization are: 1NF,2NF,3NF,4NF,5NF

Write Syntax for create table.

Description : Write Syntax for create table.

Last Answer : Syntax of Create table: CREATE TABLE table_name(  column1 datatype (size),  column2 datatype(size),  column3 datatype(size),  ..... columnNdatatype(size)  );

Define Data and instance.

Description : Define Data and instance.

Last Answer : Data: Data can be defined as facts or information that can be recorded and have an implicit meaning.  Instance: The collection of information stored in the database at a particular moment is called an instance of the database.

Define constraints, list types.

Description : Define constraints, list types.

Last Answer : Constraints are used to limit the type of data that can go into a table. Constraints are used to ensure accuracy and consistency of data in a relational database.  Types of Constraints : ... Constraint 3.UNIQUE Constraint 4.CHECK Constraint 5.Primary Key Constraint 6. Foreign Key Constraint

Define primary key and candidate key.

Description : Define primary key and candidate key.

Last Answer : Primary Key: A primary key is an attribute in Relation that uniquely identifies the rows in relation. A Primary key does not hold NULL values and duplicate values.  OR A key which is selected by the ... , Name) can be a candidate key if and only if Name and Rollno individually are not unique. 

Define the term tuple and domain.

Description : Define the term tuple and domain.

Last Answer : tuple: A row is called a Tuple. domain:A domain is a set of all possible (or permissible) values in an attribute. OR  A Domain is defined as a kind of data represented by an attribute.

Define (i) Data Abstraction, (ii) Data Redundancy.

Description : Define (i) Data Abstraction, (ii) Data Redundancy.

Last Answer : Data abstraction is defined as  *Suppression of details of data organization and storage  *Highlighting of the essential features for an improved understanding of data  *The characteristic that allow ... of data abstraction. This level describes the user interaction with database system. 

Java Embedded Database for Global File System?

Description : Java Embedded Database for Global File System?

Last Answer : answer:Perhaps something like SQLite? I believe if shared on a GFS the application will lock the database during writing. And of course SQLite an embedded database, and can be used by Java as well as C++.

A collection of interrelated records is called a 1) Management Information System 2) Spread Sheet 3) Database 4) Text file

Description : A collection of interrelated records is called a 1) Management Information System 2) Spread Sheet 3) Database 4) Text file

Last Answer : 3) Database

Which of the following genres does Hadoop produce? a) Distributed file system b) JAX-RS c) Java Message Service d) Relational Database Management System

Description : Which of the following genres does Hadoop produce? a) Distributed file system b) JAX-RS c) Java Message Service d) Relational Database Management System

Last Answer : Distributed file system

Database applications were built directly on top of file system to overcome the following drawbacks of using file-systems (a) Data redundancy and inconsistency (b) Difficulty in accessing Data (c) Data isolation (d) Integrity problems (A) (a) (B) (a) and (d) (C) (a), (b) and (c) (D) (a), (b), (c) and (d)

Description : Database applications were built directly on top of file system to overcome the following drawbacks of using file-systems (a) Data redundancy and inconsistency (b) Difficulty in accessing Data (c) Data isolation (d) Integrity problems (A) (a) (B) ... d) (C) (a), (b) and (c) (D) (a), (b), (c) and (d)

Last Answer : (D) (a), (b), (c) and (d) 

Use the new system as the same time as the old system to compare the results. This is known as … A) Procedure Writing B) Simultaneous processing C) Parallel Operation D) File Conversion

Description : Use the new system as the same time as the old system to compare the results. This is known as … A) Procedure Writing B) Simultaneous processing C) Parallel Operation D) File Conversion

Last Answer : C) Parallel Operation

Developers: Does a database of Mac OS X file extensions exist? Or do you just cross your fingers when choosing and hope nobody else uses it?

Description : Developers: Does a database of Mac OS X file extensions exist? Or do you just cross your fingers when choosing and hope nobody else uses it?

Last Answer : answer:At minimum there's always filext.com Seems like it would be useful to know what you might be mistaken for in a windows environment too (especially if you are creating exchangeable document file ... extensions are definitely present, though I'm not sure how comprehensive it is on the Mac side.

All the information about a thing or a person is known as a (a) database (b) file -Technology

Description : All the information about a thing or a person is known as a (a) database (b) file -Technology

Last Answer : (d) A record refers to a raw of data, which represents a complete set of information in a table.

A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology

Description : A database that contains tables linked by common fields is called a (a) Centralized database (b) Flat file database -Technology

Last Answer : (c) Relational database stores data in the form of tables which are linked by common fields.

The index file in the database is updated automatically - explain. ?

Description : The index file in the database is updated automatically - explain. ?

Last Answer : The data is arranged in a special order so that the user can quickly find any data from the database. Indexing is the process of arranging the records in a database table in such a logical ... to the database file, the index files are automatically updated. This does not change the original file.

A collection of related instructions organized for a common purpose is referred to as A) File B) Database C) Program D) None of above

Description : A collection of related instructions organized for a common purpose is referred to as A) File B) Database C) Program D) None of above

Last Answer : Answer : C