What are the administration duties for maintaining an embedded database environment?
These are minimal because the application is usually the administrator. Q. What are the tuning opportunities of an embedded database? Is there much a DBA can do for such a small footprint? It depends on the functionality of the database. In our case, tuning can come through cache management (performance), using SQL or Native API (performance), user-defined procedures and functions. Q. How exactly do embedded databases speed time to delivery of applications and cut development costs? Every software application manages data. In most cases, the data is managed in a flat file — and this is fine for these applications as long as they have a short life cycle and their data is stagnant. If the application is going to have a long life cycle and/or going to grow in its use, having a database management system is 100 times cheaper to buy than to build and in many years quicker to develop. Q. How robust is the availability, reliability, and recoverability of embedded databases? Very robust — beca
