English 中文(简体)
XML 统一档案与关系数据库链接
原标题:XML flat file vs. relational database backend

大多数项目现在需要某种形式的数据库。 当有人说数据库时,我通常想的是关系数据库,但我仍然听说的是普通档案XML数据库。

在决定“real”数据库和普通XML数据库时,你会考虑哪些参数。 当有人被利用时,以及在什么情况下,我从不考虑使用一个统一档案(或反之关系)数据库?

最佳回答

没有Xml平线文档数据库。 板xml文档是非数据库,因为它们没有像指数这样的更高功能,在没有指数的情况下有较大的数据集、搜索或分析查询。

XML数据库是另一个专题,可能具有其需要(洲际管理、文件储存——从数据库的角度来看,复杂化图示你过于谨慎)。

固定档案对8个小档案等物品进行罚款,但真正的数据库是真实的数据库。 合作与发展协会的条件难以保证统一档案。

问题回答

补充雷切尔的答复。

  • concurrency
  • read vs. write

如果你有某种简单易懂之处,而且不会发生很大变化,那么使用统一档案和节省间接费用可能更为理想。

另一方面,如果你必须支持将增加和更新数据的多种联系,那么你希望使用一个数据库。

需要考虑的参数很少

  1. Amount of Data
  2. Complexity of Data
  3. Relationship between Data

如果我们拥有的复杂程度低且与人们相比没有相互关系的数据数量较少,但实际应用情况很少,因此,你将经常找到相关数据库。

XML文档不是数据库。 阅读Joel s“基本面”,看看差异。





相关问题
SQL SubQuery getting particular column

I noticed that there were some threads with similar questions, and I did look through them but did not really get a convincing answer. Here s my question: The subquery below returns a Table with 3 ...

please can anyone check this while loop and if condition

<?php $con=mysql_connect("localhost","mts","mts"); if(!con) { die( unable to connect . mysql_error()); } mysql_select_db("mts",$con); /* date_default_timezone_set ("Asia/Calcutta"); $date = ...

php return a specific row from query

Is it possible in php to return a specific row of data from a mysql query? None of the fetch statements that I ve found return a 2 dimensional array to access specific rows. I want to be able to ...

Character Encodings in PHP and MySQL

Our website was developed with a meta tag set to... <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> This works fine for M-dashes and special quotes, etc. However, I ...

Pagination Strategies for Complex (slow) Datasets

What are some of the strategies being used for pagination of data sets that involve complex queries? count(*) takes ~1.5 sec so we don t want to hit the DB for every page view. Currently there are ~...

Averaging a total in mySQL

My table looks like person_id | car_id | miles ------------------------------ 1 | 1 | 100 1 | 2 | 200 2 | 3 | 1000 2 | 4 | 500 I need to ...

热门标签