如何为我的数据库应用程序选择数据库类型? [英] How to choose database type for my database application?

问题描述

亲爱的所有人，

我正在编写一个数据库应用程序.当我创建新的数据库项目时，可以从列表中选择数据库的类型，其中包括Microsoft Access数据库文件，Microsoft SQL Server，Oracle数据库等.我的问题是我不知道该选择哪个.

我想在数据库中存储一些字符串，数字和日期/时间数据，以及一些图像和视频.我的应用程序应该能够创建新表并编辑现有表并创建新数据库.但是我想通过尽可能小的和独立的应用程序来实现.例如，如果没有安装Microsoft SQL Server就无法正常运行的应用程序是不令人满意的.

有人可以帮我选择数据库类型吗?

在此先感谢您.

Dear all,

I''m writing a database application. When I create new database project I can choose type of my database, from the list, among whose items are Microsoft Access Database File, Microsoft SQL Server, Oracle Database, and so on. My problem is that I don''t know which to choose.

I would like to store some string, numeric and date/time data and also some images and videos in my database. My application should be able to create new and edit existing tables and create new databases. But I would like to achieve this with as small and as independent application as possible. For example application which can not work properly without Microsoft SQL Server being installed is not satisfactory.

Can someone please help me choose database type?

Thanks in advance.

推荐答案

不要使用访问权限-永远！

如果您正在考虑使用Sql CE，请查看 SQLite [ Firebird [ ^ ]可以部署为服务器或嵌入式模式.

Oracle非常强大-但是部署起来可能会很昂贵.

图像和视频需要blob数据，MS SQL Server和oracle都能够智能地处理这些数据. MS SQL具有文件流 [

Don''t use access - ever!

If you are considering Sql CE - take a look at SQLite[^] - and don''t use either if you can avoid it, go for a "real" RDBMS like:

SQL Server 2008 - you are free to deploy SQL Server 2008 Express with your projects.

Firebird[^] can be deployed as a server or in embedded mode.

Oracle is extremly robust - but it will probably be expensive to deploy.

images and videos requires blob data, both MS SQL server and oracle are able to handle this intelligently. MS SQL has FILESTREAM[^], and oracle has something similar.

Regards
Espen Harlinn

绝对不是oracle，您可能需要使用带有sqlserver express或access的sql.

definitely not the oracle, you might need to go with sql with sqlserver express or access.

如果是可移植性，我会选择SQLCE(MS SQL Server Compact Edition).
它不具有完整版的所有功能，但不需要安装.

我不会使用Access:没有视图，没有存储过程.

干杯

If portability is the issue, I would choose SQLCE (MS SQL Server Compact Edition).
It does not have all the features of the full edition, but it doesn''t require installation.

I wouldn''t use Access : No views, no stored procedures.

Cheers

这篇关于如何为我的数据库应用程序选择数据库类型?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！