Skip to main content

Database system vs file system-computer world

  Database system vs file system


                  pixabay 

 Data redundancy 

it means duplication of data for more than one place. Like a customer detail like name, account number, address are stored at more than one place. In file system redundancy of data increase which consume more space and more difficult to maintain. By using DBMS we can reduce data duplication and update the data.

 Insert and delete records 

In file system we cannot insert and delete any particular record from data. DBMS provides faculty of deletion and also we can easily insert new record or data.

 Difficult to search the data

 In file system if we want to search popular record for example record of that customer who's minimum balance is 75000 in saving account so it is difficult to retrieve those data. But by using DBMS there are searching options are easily available.

 Security problem

 In file system there is very less or no security DBMS provides high level security mechanism like password,security, bio metric devices.

 Data isolation

 In file system there is no standard format of data, so retrieving data is now difficult.

Concurrent access anomalies 

For speed and faster working, we need to accept more than one data concurrently but it is difficult to access in file system.

                              

                                 File system

 
 pixabay


what is computer worm-computer world

  What is google Search Engine

Logical database model and  Relational database management system

Definition of computer cables and types of cables

Register and type of register in computer Architecture

What is buffering

Definition of computer ports and types of ports

what is computer and what is the meaning of computer

Definition of computer cables and types of cables

Difference between Linux and Unix-computer world

Demand paging-oocomputer world

  What is CSS-computer world

What is internet-computer world

Round-Robin Scheduling in operating system-computer world


Comments

Popular posts from this blog

Aggregation and Functional dependency in DBMS-computer world

  Aggregation and  Functional dependency in  DBMS Aggregation  In aggregation the relation between two entities is treated as a single entity. In aggregation relationship with its corresponding entity is aggregated into higher level entity . It is the process of compiling information on object, there by obstructing a higher level. On limitation of the ER model is that it can not Express relationship among relationships. The aggregation represent a relationship between a whole object and its component in other word we can say that using aggregation we can express relationship main relationships.  For example center entity offer the course entity act as a single entity in the relationship which is in a relationship with another entity visitor. In the real world if a visitor visits a coaching center they will never inquiry about the course or just about the center instead he will ask the inquiry about both. Functional dependency  Functional dependency play an ...

Difference between HTML and DHTML-computer world

     Difference between HTML and DHTML  HTML is a markup language, while DHTML is a collection of Technology.  DHTML creates dynamic web page, whereas HTML create static web page.  DHTML allow including small animations and dynamic menus in web pages but HTML is not able to do so.   HTML used events, methods, properties to insulate dynamism in HTML pages.   HTML is used to describe the web page but DHTML is a collection of JavaScript and style sheet in an HTML page. HTML sites will be show upon client side Technologies, while  DHTML site will be fast enough upon client side Technologies as most of entries are checked on browser itself and not waste time rendering to server for mistake.  HTML creates a plain web page without any style and scripts called as HTML. Whereas,  DHTML creates a page with HTML, CSS,DOM And scripts called as DHTML.  HTML cannot any server side code but XHTML may contain server side code.  ...

Nested relation -oocomputer world

 Nested relation   During the first normal form we require that all attributes have atomic domain a domain is atomic if elements of the domain are considered to be indivisible unit.  For example the set of integer is an atomic domain but the set of all sets of integer is a non atomic domain. We considered set of integer to have subpart the important issue in first normal form not the domain itself but rather the way we use domain element in database. The nested relational model is a extension of the relation model in which domain may be either atomic or relation  valued of a tuple on a attribute may be relation and relation may be stored within relation . A complex objects can be represented by a single tuple of a nested relation if we view a tuple of a nested relation a data item we have a one to one correspondence between data item and objects in the user's view of the database.  Nested relation are just one example of extensions to the basic relational m...