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.
Print Friendly, PDF & Email

Este artigo foi útil? Was this helpful?

Classificação média - Average rating 0 / 5. Count: 0

Leave a Reply

Your email address will not be published.Required fields are marked *