Hi, i couldn't find the advantages and disadvantages would you please help me?
thanks.
views:
435answers:
2
+4
A:
A few database advantages:
- Highly optimized (indexing, query optimization)
- Stores many different types of data, generally with type-safety
- Prebuilt abstractions (SQL, database access layers)
- Relational integrity (foreign key constraints, etc)
- ACID (Mostly having to do with data integrity, check Wikipedia...)
- Interactive queries (for debugging, running ad-hoc reporting, etc)
Plain text doesn't have much except for the most dead-simple application
- Can inspect on-disk format
- Extremely simple in every way
- No need for a server or linked library, etc.
Basically, if you are doing anything other than the most simple data manipulation (especially if you ever expect to have concurrent modifications, complex relations, multiple users, or even just a lot of data) it's well worth getting used to using a database. PostgreSQL is my favorite, although I'm sure you'll find conflicting views on that one :)
Steven Schlansker
2010-01-20 08:11:53
You can add concurrency and security to the pros of a database.
Pascal Thivent
2010-01-20 08:16:31
can we say that we can do delete,insert and update and search in DB that we can not do it for plain files?
Johanna
2010-01-20 08:18:00
+1. "No need for a [software] server" can be achieved with (R)DMS as well: http://www.sqlite.org/
Jørn Schou-Rode
2010-01-20 08:20:25
@Johanna: It is most certainly possible to modify a "plain file" - it usually just requires more work.
Jørn Schou-Rode
2010-01-20 08:22:17
Thanks a lot for your answer.
Johanna
2010-01-20 08:37:03
Jørn Schou-Rode: You're completely right, of course. You still have to link with an additional library, though. Give plain text a break, it's not like it had much going for it in the first place ;-)
Steven Schlansker
2010-01-20 18:23:59
A:
Enforcement of standards.
Improved data accessibility and responsiveness.
Increased productivity.
Improved maintenance through data independence.
Increase concurrency.
Improved backup, recovery and data availability.
Control of data redundancy.
Data consistency.
More information from the same amount of data.
- Data Warehousing, Data mining
Sharing of data.
Improved data integrity.
Improved security.
fazlan
2010-03-14 13:22:59