what are the advantages of Database systems over File systems?
594577
Actually, a database system consists of multiple datafiles which are located in one or more filesystem(s)
1108563
First, they will take up storage space in memory that must be allocated and deallocated correctly.  Second, they will run slower if there is any occasion to look up things in two or more tables rather than one.  Third, indexing into the correct table for the correct data type with an inbounds index becomes far more difficult for you and others as changes are made.  Fourth, file saves become more complex as do file loads.\n\nFirst, properly handled, tables in memory are still less time consuming to search and update than files.  Second, when large chunks of data are to be updated, updating table entries in memory and writing them out to a file at once and reading them in once saves a lot of hard disk read/write accesses and time.  Third, storing well thought out data configurations to separate tables allows data to be used from one table to create one report or display rather easily.  \n\nIt boils down to multiple tables are either well thought out and written, complex code that streamlines other functions in the application or they are a tangle of psuedo-organized crap code forming an inefficient Kludge, at best.  So, do them very well or not at all.  I think that about sums it up.
940661
Floppy disc usage is becoming rare. People use CDs instead to store files. I can't think of any advantages right now.
504842
It allows you to separate data into different segments for different things...\n\nFor instance, lets say I have a hard disk of 100 Gigabytes. I can partition that drive into three different pieces (assuming I use NTFS)\n\n1) First  partition is 50GB and will be my drive C:\n2) Second partition is 25GB and will be drive G:\n3) Third partition is just under 25GB (because of structure it never is the full 100 GB) and will be my drive H:\n\nThe first partition I can install a windows operating system on. The second partition (Drive G:) I will put on Linux operating system. The last paritition (Drive H) I will use strictly for games and music. So now my system is a dual boot system (I can run windows or Linux) as well as have a drive dedicated to my entertainment.\n\nParitition just allows you to break up the data into logical sections so that they are seen as different hard disks and treated differently. If you are using the FAT32 file system, you will be forced to parition bigger drives because FAT32 doesn't support bigger gigabyte hard disks.\n\nI hope this clarifies it for you. I have included a link below to Wikipedia that talks a bit more in depth about what you can do with partitions. Enjoy!
853838
faster - cheaper - more options for data manipulation and storage
1005348
in file system we can store data in diffrent formats.so it ts diffcult to fetch that data.\nin database system also we use physical files to store data but in the specific format.\nso that it will be convinent for us to fetch the data.\nit is alwas preferable to use database system than file system while designing a software.\nu can refer to database managment system book for more details.
765039
Hi. It gives you more storage space and allows you to backup important data to both. Useful if you have a failure.
211702
The software vendors that are writing popular ERP and other large business systems have selected Oracle as the background data store that they write their software to use.\n\nFor large data collections Oracle has many attributes that are important, such as ;\nscalability, consistency, concurrency, point-in-time recovery,multi platform availability  and a forward looking adoption policy for new technology.
52543
Linux/Unix stores files in an efficient manor, so your drive doesn't have to keep jumping around to access the information that it needs.
937744
If what you are asking is what you can use to store and manage data (don't know about the 'buy' part) I can take a stab at it. \n\nI am a software engineer that has been writing database applications for 13 years. What I have used are:\nMicrosoft Access (http://office.microsoft.com/en-us/access/default.aspx)\nMySQL (an Open Source, free database) (http://www.mysql.com/)\nMicrosoft SQL Server (http://www.microsoft.com/sql/default.mspx) and \nOracle (http://www.oracle.com/index.html).  \n\nThese are pretty much the viable solutions depending on the application. MS Access is more of a poor-mans solution but certainly capable of handling 100's of thousands of rows of data, MySQL is a bit more complex but has evolved and even has a User Interface to manage the database now and fairly capable in terms of it's data capacity. SQL Server/Oracle are the full-blown Database Management Systems (DBMS) that cost the big bucks to license but are what large enterprises/web sites use to hold all their data.\n\nHope this helps.
729691
1. Field\n2. Retrieval\n3. Flat File\n4. Record\n5. DBMS\n6. Query\n7. Updating\n\nHope that helps!!
1003666
Any application that doesn't need persistent data.  You only use a database if you need to store data between runs of a program, and that data needs to be stored in a way that requires specialized access for searching and/or reporting.  Otherwise, even if a program requires loading/storing data of some sort, simple files might do a better job.\n\nYou don't use a sledgehammer to kill a mosquito.  DBs add a great deal of overhead to a system.  You only use them if they're necessary.
222222
An external hard drive is for data storage, but is not contained in the computer case.  It is connected to the computer by plugging into a port on the outside of the case.  The advantage is that it is portable and can be unplugged and carried with you and plugged in another computer that can also store and retrive data from the drive.
749286
Different discs have different file systems.  One file system may take more or less size to store a file than another one.  Also disc size can make file sizes bigger or smaller.  A small disc of the same file system will store a file using less space than a large disc.  Many get around this factor by using multiple partitions and breaking a big disc down to many virtual small ones.\n\nData is stored in clusters.  If you can imagine having several gallon pitchers and making several kinds of juice.  You would have to use a whole pitcher for each regardless of how much you made.  Much space would go wasted in the pitchers not very full.  Smaller discs have "smaller pitchers" (cluster sizes) and would allow those juices you are only making a little of to use a container closer to their fit leaving you with more unused pitchers.  Like having 20 half gallon pitchers instead of 10 gallon pitchers.
81953
Why a Data Warehouse?\nIt allows for the following benefits to the business and Business Intelligence layer:\n\n1.Speed: The data structure in a Data Warehouse (Star Schema) is the optimal structure for delivering a result set to the Business Intelligence layer; and hence is many times faster then going against Database directly, which has a structure optimized for storing data, not delivering it\n\n2.Pre-Gathered Values: One of the primary challenges in producing reports against Database directly is developing the logical joins and relationships in the data to appropriately deliver reports.  In a Data Warehouse these values are all prepared up front.  This leads to benefit #3\n\n3.Development Speed: If a new report needs to be created against Database today, it will require piecing together the different tables in the database.  Having this work done up front allows reports and universe elements to be created quickly\n\n4.Offloaded Processing:  When the Business Intelligence layer requests data from the database, the database will require processing power to produce the result set.  If Database is being hit directly with this request it will take processing power away from other resources that need the Database database.  Namely the applications themselves\n\n5.Independence:  If the organization ever decides to move away from their application (say a CRM) to another application (another CRM) the Business Intelligence layer can remain in tact as the majority of changes would occur in the Data Warehouse.  However, if Database is being accessed directly by the reports then the organization would be required to rewrite the logic for each and every report individually\n\n6.Singularity:  The Data Warehouse delivers a single location from which the data is extracted giving confidence to the business that there is a single version of the truth.  Additionally, IT benefits from a higher ROI per hour spent producing data relationship logic (in the Data Warehouse), as the logic can be leveraged over and over by the Business Intelligence layer\n\nImportant things to be aware of in a Data Warehouse\nThe benefits of a Data Warehouse are great but they require and awareness of the following items:\n\n1.Scheduled Data:  The data in a Data Warehouse is extracted (from Database), transformed, and then loaded into the Data Warehouse (another database).  This is a scheduled process and thus the data will not be “live” against the database.  This doesn’t mean that values cannot be pulled live for certain report values outside the Data Warehouse; but in general the Business Intelligence implementation will be pulling from data that is a day or half-day old.  This can also become a benefit, as the schedules can be kicked off when other processes finish, thus avoiding the danger of delivering incomplete numbers to the business. (ie. receiving a report that ran before the accounting books closed in the system, producing incompatible results, unbeknownst to the business)\n\n2.Investment:  The implementation of the Data Warehouse needs to be seen as a long term investment.  Inevitably, down the road there will be business processes that change, or business that are added, requiring these results to be reflected in the Data Warehouse.  Hence, best practices, and a strong starting point are critical.
316142
The only advantage is if you find the software useful and trouble free. And that goes for shareware also. Note: there are a lot of freeware programs that are better than their shareware counterparts.
155724
The biggest differences are going to be the size of you database and your security.  Businesses are going to need dedicated storage area and firewalls and/or proxy servers.  Home networks can do most of this through software instead of hardware.