要使用的数据库类型 [英] Type of data bases to use

问题描述

我一直在为高中班级聚会的数据库设计一个想法，您可以从中获取参加某些聚会的人数，参加过多少次男女聚会的统计数据.我一直对关系设计保持着头脑，但最近我想到了另一个潜在的问题.我的开发人员系统上装有SQL Server，但是，如果该程序的最终用户没有安装该程序，并且又不想安装它，该怎么办?
有没有一种方法可以创建该数据库，并且仍然能够获得我希望获得的所有可靠统计信息?
我唯一想到的另一件事是将其另存为XML文档，但不确定性能.
当前的植入将至少需要增加350个人.
谢谢您的时间.

I have been working on an idea for a database for high school class reunions where you can pull statistics from it for who attended certain reunions, how many male or females attended and so forth. I keep getting brain lock on the relational design but I recently thought of another potential problem. My developer system has the SQL Server on it but, what if the end user of the program does not have it installed and also does not want to install it?
Is there a way to create this database and still be able to get all of the robust stats I want to be able to get at?
The only other thing I can think of is to save it as a XML document but not sure of the performance.
The current implantation would have at least 350 people that I would need to add.
Thank you for your time.

推荐答案

数据集可以读取XML文件并在内存中使用它.对于350个人或唱​​片来说，这是完全可以的.

关系数据库已被过度使用和推广，您可以用它来做得很好.

尝试查看Sqlite http://sqlite.org/ [ RaptorDB-文档存储 [ ^ ].

还有许多其他嵌入式数据库引擎.

A Dataset can read your XML file and work with it in memory. For 350 people or records it is perfectly fine.

Relational databases have been over used and promoted where you can do perfectly fine with out it.

Try looking at Sqlite http://sqlite.org/[^] if you need a relational database that is embedded and doesn''t require an install.

If you feel adventurous take a look at RaptorDB - the Document Store[^] for a nosql document database engine.

There are numerous other embedded database engines.

SQLite将是您的理想选择.
http://stackoverflow.com/questions/271319/lightweight-sql-database- which-doesnt-require-installation [ ^ ]

SQLite will be a good option for you.
http://stackoverflow.com/questions/271319/lightweight-sql-database-which-doesnt-require-installation[^]

这篇关于要使用的数据库类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！