Our new project aims to use a very...very large database. Basicly ~one million of new records have to be stored per month. This requirement gives to the enterprise application a very big pressure under the thousands or millions of users.
I'm aware of some techniques like horizontal/vertical partitioning and caching. But still the question remains: How to partition the data and where to implement the logic which handles the queries.
Also would be interesting if you guys can share your experiences about which database framework would be the best choice for that task.
So I'm looking for the best or common practices/architectures to handle millions of records of databases.
Thanks your time.
Hey guys. Sorry for the late response. Actually we are in a really early state of the planning phase. So basicly we want a good start point about databasehandling. Which framework or practice would be a best choise for us. Anyway this system will be a datawarehouse system which holds relations and data between doctors and patients. This means clinical informations or forms between patient and doctor or other large amount of data.
Update 2: Also would be interested in which database framework would be a best choice for partitioning: PostgreSQL, DB2 or Oracle's one? Give me your experince please.