Using Databases in E3: Chapter 1 – Choosing the Database.

Choosing a database directly depends on its purpose. Next, there is a comparison among the advantages and disadvantages of the available database.

Access

  • Advantages
    • Fast for small databases;
    • Simple configuration.
  • Disadvantages
    • The datafile grows quickly;
    • Unstable when larger than 100 MB.

SQL Server

  • Advantages
    • Excellent performance and stability;
    • Supports large databases (up to 1 TB);
    • Provides a free version (SQL Express) which supports up to 10 GB of data. Can be purchased on Microsoft’s website.
  • Disadvantages
    • Does not have protection against shutdown failures when updating data;
    • Does not perform a consistent backup with an online database, nor if updates are being performed.

Oracle

  • Advantages
    • Fast for huge databases;
    • Robustness, safety, reliability, streamlined organization , and large capacity of system expansion.
  • Disadvantages
    • Requires technical expertise for database administration;
    • High license and hardware costs to run the software.
Este artigo foi útil? Was this post helpful?
Yes0
No0

Deixe seu Comentário

Seu endereço de e-mail não será publicado. Campos marcados com asterisco são obrigatórios *