When / why should I start using the database?

Question

I am currently evaluating the design and the possibility of re-equipping my own application, which our engineers use.

Although the application processes large amounts of data. Only two sets of values ​​(floats) are stored along with a simple name and data description. In my opinion, the current application is located in the overflow area using a normalized access database for storage, which evaluates 7 rows and floating fields.

At what point do you start looking at the transition from a flat file or serialized XML to a relational database, or vice versa?

Answer 1

, ​​ SQLite, .

http://sqlite.org

Answer 2

, .

, - , , .

Answer 3

db - : s ( )

ACID , , clobber . , , RDBMS " ".

Answer 4

. 7 - . 7 , ( 7 ), , .

Answer 5

, .

When you start with many-to-many or many-to-one relationships in your data, it's time to think about using a relational database to maintain relational integrity.