Category: Top » View » Code-91483

Use the html code provided below to reprint the article: "File-systems Vs Databases - A Technological Comparision" on your website
You can adapt the code to fit the style of your pages but you need to respect our Terms of Service

Title

Author

HTML code

article only

<h1>File-systems Vs Databases - A Technological Comparision</h1> by druvaa It's interesting to see how databases have come a long way and have clearly out-shadowed file-systems for storing structured or unstructured information.
Technically, both of them support the basic features necessary for data access. For example both of them ensure -
 * Data is managed to ensure its integrity and quality * Allow shared access by a community of users * Use of well defined schema for data-access * Support a query language
But, file-systems seriously lack some of the critical features necessary for managing data. Lets take a look at some of these feature.
Transaction support Atomic transactions guarantee complete failure or success of an operation. This is especially needed when there is concurrent access to same data-set. This is one of the basic features provided by all databases.
But, most file-systems don't have this features. Only the lesser known file-systems - Transactional NTFS(TxF), Sun ZFS, Veritas VxFS support this feature. Most of the popular opensource file-systems (including ext3, xfs, reiserfs) are not even POSIX compliant.
Fast Indexing Databases allow indexing based on any attribute or data-property (i.e. SQL columns). This helps fast retrieval of data, based on the indexed attribute. This functionality is not offered by most file-systems i.e. you can't quickly access "all files created after 2PM today".
The desktop search tools like Google desktop or MAC spotlight offer this functionality. But for this, they have to scan and index the complete file-system and store the information in a internal relational-database.
Snapshots Snapshot is a point-in-time copy/view of the data. Snapshots are needed for backup applications, which need consistent point-in-time copies of data.
The transactional and journaling capabilities enable most of the databases to offer snapshots without shopping access to the data. Most file-systems however, don't provide this feature (ZFS and VxFS being only exceptions). The backup softwares have to either depend on running application or underlying storage for snapshots.
Clustering Advanced databases like Oracle (and now MySQL) also offer clustering capabilities. The "g" in "Oracle 11g" actually stands for "grid" or clustering capability. MySQL offers shared-nothing clusters using synchronous replication. This helps the databases scale up and support larger &amp; more-fault tolerant production environments.
File systems still don't support this option :( The only exceptions are Veritas CFS and GFS (Open Source).
Replication Replication is commodity with databases and form the basis for disaster-recovery plans. File-systems still have to evolve to handle it.
Relational View of Data File systems store files and other objects only as a stream of bytes, and have little or no information about the data stored in the files. Such file systems also provide only a single way of organizing the files, namely via directories and file names. The associated attributes are also limited in number e.g. - type, size, author, creation time etc. This does not help in managing related data, as disparate items do not have any relationships defined.
Databases on the other hand offer easy means to relate stored data. It also offers a flexible query language (SQL) to retrieve the data. For example, it is possible to query a database for "contacts of all persons who live in Acapulco and sent emails yesterday", but impossible in case of a file system.
File-systems need to evolve and provide capabilities to relate different data-sets. This will help the application writers to make use of native file-system capabilities to relate data. A good effort in this direction was Microsoft WinFS.
Conclusion The only disadvantage with using the databases as primary storage option, seems to be the additional cost associated. But, I see no reason why file-systems in future will borrow features from databases.
 <h2>About the Author</h2>Jaspreet Singh is product evangelist at <a href="http://www.druvaa.com/">Druvaa Software</a>. 
Disclosure 
Druvaa inSync uses an embedded PostgreSQL database to store and index the backed up data. This helps in - 
 1. Data deduplication - saves storage 
 2. Temporal File-system - This enables faster time-based restores.
Read Original Post at - <a href="http://blog.druvaa.com/2009/01/25/file-systems-vs-databases/" title="blog.druvaa.com/2009/01/25/file-systems-vs-databases/">http://blog.druvaa.com/2009/01/25/file-systems-vs-databases/</a>
 <h3><a href="http://www.content4reprint.com/computers/databases/file-systems-vs-databases-a-technological-comparision.htm" title="File-systems Vs Databases - A Technological Comparision">Article Source:</a> <a href="http://www.content4reprint.com" title="Free high quality articles">Content for Reprint</a></h3>

Tags/keywords

read the original article: http://www.content4reprint.com/computers/databases/file-systems-vs-databases-a-technological-comparision.htm

sample HTML code

full page

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<meta name="keywords" content="Druvaa, File System, Database" />
<meta name="robots" content="index, follow" />
<title>File-systems Vs Databases - A Technological Comparision</title>
</head>
<body><h1>File-systems Vs Databases - A Technological Comparision</h1> by druvaa It's interesting to see how databases have come a long way and have clearly out-shadowed file-systems for storing structured or unstructured information.
Technically, both of them support the basic features necessary for data access. For example both of them ensure -
 * Data is managed to ensure its integrity and quality * Allow shared access by a community of users * Use of well defined schema for data-access * Support a query language
But, file-systems seriously lack some of the critical features necessary for managing data. Lets take a look at some of these feature.
Transaction support Atomic transactions guarantee complete failure or success of an operation. This is especially needed when there is concurrent access to same data-set. This is one of the basic features provided by all databases.
But, most file-systems don't have this features. Only the lesser known file-systems - Transactional NTFS(TxF), Sun ZFS, Veritas VxFS support this feature. Most of the popular opensource file-systems (including ext3, xfs, reiserfs) are not even POSIX compliant.
Fast Indexing Databases allow indexing based on any attribute or data-property (i.e. SQL columns). This helps fast retrieval of data, based on the indexed attribute. This functionality is not offered by most file-systems i.e. you can't quickly access "all files created after 2PM today".
The desktop search tools like Google desktop or MAC spotlight offer this functionality. But for this, they have to scan and index the complete file-system and store the information in a internal relational-database.
Snapshots Snapshot is a point-in-time copy/view of the data. Snapshots are needed for backup applications, which need consistent point-in-time copies of data.
The transactional and journaling capabilities enable most of the databases to offer snapshots without shopping access to the data. Most file-systems however, don't provide this feature (ZFS and VxFS being only exceptions). The backup softwares have to either depend on running application or underlying storage for snapshots.
Clustering Advanced databases like Oracle (and now MySQL) also offer clustering capabilities. The "g" in "Oracle 11g" actually stands for "grid" or clustering capability. MySQL offers shared-nothing clusters using synchronous replication. This helps the databases scale up and support larger &amp; more-fault tolerant production environments.
File systems still don't support this option :( The only exceptions are Veritas CFS and GFS (Open Source).
Replication Replication is commodity with databases and form the basis for disaster-recovery plans. File-systems still have to evolve to handle it.
Relational View of Data File systems store files and other objects only as a stream of bytes, and have little or no information about the data stored in the files. Such file systems also provide only a single way of organizing the files, namely via directories and file names. The associated attributes are also limited in number e.g. - type, size, author, creation time etc. This does not help in managing related data, as disparate items do not have any relationships defined.
Databases on the other hand offer easy means to relate stored data. It also offers a flexible query language (SQL) to retrieve the data. For example, it is possible to query a database for "contacts of all persons who live in Acapulco and sent emails yesterday", but impossible in case of a file system.
File-systems need to evolve and provide capabilities to relate different data-sets. This will help the application writers to make use of native file-system capabilities to relate data. A good effort in this direction was Microsoft WinFS.
Conclusion The only disadvantage with using the databases as primary storage option, seems to be the additional cost associated. But, I see no reason why file-systems in future will borrow features from databases.
 <h2>About the Author</h2>Jaspreet Singh is product evangelist at <a href="http://www.druvaa.com/">Druvaa Software</a>. 
Disclosure 
Druvaa inSync uses an embedded PostgreSQL database to store and index the backed up data. This helps in - 
 1. Data deduplication - saves storage 
 2. Temporal File-system - This enables faster time-based restores.
Read Original Post at - <a href="http://blog.druvaa.com/2009/01/25/file-systems-vs-databases/" title="blog.druvaa.com/2009/01/25/file-systems-vs-databases/">http://blog.druvaa.com/2009/01/25/file-systems-vs-databases/</a>
 <h3><a href="http://www.content4reprint.com/computers/databases/file-systems-vs-databases-a-technological-comparision.htm" title="File-systems Vs Databases - A Technological Comparision">Article Source:</a> <a href="http://www.content4reprint.com" title="Free high quality articles">Content for Reprint</a></h3></body></html>