by Irene Kopaliani 由艾琳Kopaliani
As any person, who remodeled their home, will tell you that “choosing the right tool for the right job” makes all the difference.正如任何人，誰改造他們的家，會告訴你， “選擇正確的工具，就業的權利”使所有的差異。 The same statement applies when choosing the right database for a project.同樣的聲明適用於當選擇合適的數據庫項目。 Some databases are basic, some are “battery operated” and some are “mighty power tools.” Below is a guide on selecting the perfect database for the right project.有些數據庫是基本的，有些是“電池操作” ，一些是“強權的工具。 ”下面是指南選擇完善的數據庫權項目。

When you only need to store a limited amount of data and require a quick and easy development cycle, Microsoft Access is the right tool for you.當你只需要存儲數量有限的數據，並要求快速和輕易的開發週期， Microsoft Access中是正確的工具，你。 It provides a powerful set of database and graphical user interface tools that allows the user to quickly organize, access and share information.它提供了一套強大的數據庫和圖形用戶界面的工具，使用戶能夠迅速組織，獲取和分享信息。 Since Access is part of the Microsoft family of office products, it easily integrates with Excel, Word and SQL Server.由於訪問是微軟系列辦公產品，它很容易集成與Excel ， Word和SQL Server中。 In addition, it supports Open Database Connectivity (ODBC).此外，它支持開放式數據庫連接（ ODBC ） 。 However, if the database is going to hit 1GB threshold, you may encounter various performance issues, including slow response and record corruption.但是，如果該數據庫將達到1GB的門檻，您可能會遇到各種性能問題，包括反應遲緩和記錄腐敗。 Microsoft Access is an equivalent of a Swiss army knife. Microsoft Access是一個相當於瑞士軍刀。 Each part individually is not as impressive; however, when combined together, it produces an appealing solution.每一部分單獨並不給人以深刻印象;然而，當結合在一起，它產生一個有吸引力的解決方案。

My SQL is a viable alternative to Microsoft Access.我的SQL是一個可行的選擇到Microsoft Access 。 Major advantages of My SQL are the low cost (licensing starts below $500) and platform independence (it can be installed on Windows, Linux, Macintosh and UNIX operating systems).主要優點是我的SQL的低成本（授權啟動500美元以下）和平台獨立性（它可以安裝在Windows ， Linux ， Macintosh和UNIX操作系統） 。 My SQL does not, however, come with the development interface tools that Microsoft Access provides and would require the use of a programming language, such as Visual Basic, C, etc., to create user interface and reporting.我的SQL沒有，但是，今後的發展與界面工具， Microsoft Access中規定，將需要使用一種編程語言，如Visual Basic ，丙，等等，以創建用戶界面和報告。 This is your battery-operated power tool!這是您的電池操作電動工具！

Microsoft SQL Server is a powerful alternative to My SQL and Oracle.微軟SQL Server是一個功能強大的替代我的SQL和Oracle 。 It is moderately priced and yet quite powerful and scalable.這是價格適中，但相當強大的和可擴展性。 It provides a user administration module capable of handling user, group and column-level security.它提供了一個用戶管理模塊能夠處理用戶，用戶組和列級的安全性。 Record-retrieval speed of the SQL Server outperforms both Microsoft Access and My SQL.記錄檢索速度的SQL Server優於微軟Access和我國的SQL 。 In addition, Microsoft SQL Server is highly scalable.此外，微軟SQL Server是高度可擴展的。 This is your power tool!這是您的權力的工具！

Oracle is the oldest of the relational database management systems (RDBMS) discussed in this overview and the most powerful.甲骨文是最古老的關係數據庫管理系統（ RDBMS的）討論本概述和最強大的。 However, it is also the most expensive and most difficult to implement.然而，它也是最昂貴的和最難以實施。 Oracle is highly scalable and allows storage of a tremendous amount of records without jeopardizing performance.甲骨文是高度可擴展和可存儲大量的記錄，而不損害性能。 Like Microsoft SQL Server, it has a powerful user administration module.像微軟SQL Server ，它有一個強大的用戶管理模塊。 This is the mighty power tool!這是強權工具！

When selecting the right tool for your next database project, keep in mind the following:當選擇合適的工具，您下次數據庫項目，請記住以下幾點：

* The size of the data to be stored over time; * Budgetary constraints; * Security essentials; * Future growth requirements; * Platform needs; and * Development tools. *大小的數據存儲在一段時間; *預算約束; *安全要點; *未來增長的需求; *平台的需要;和*開發工具。

About the Author作者簡介

Irene Kopaliani is a web designer, author and speaker, as well as a managing director of伊雷娜Kopaliani是一個網頁設計師，作家和一位發言者，以及董事總經理 CxT Group, Inc. CxT集團有限公司 , which provides custom software solutions to mid-size companies.提供定制軟件解決方案，以中等規模企業。 She can be reached at irene@cxtgroup.com她可以達成irene@cxtgroup.com

Save $30 instantly on McAfee Total Protection and Internet Security! 保存30美元即時的McAfee Total Protection和互聯網安全！