如何在MySQL中创建一个时间点架构 [英] How to create a point in time architecture in MySQL
问题描述
我阅读了此文章为您的数据库构建一个时间点架构。它看起来像一个优雅的解决方案,但文章已经从一段时间以前(2007)。我在想:
1.还有其他的方法来解决吗?
2.这个和其他方法的亲和关系是什么?
3.是否有可用于这些方法的mysql实现,我可以重复使用?
I read this article on building a point in time architecture for your database. It looks to me as an elegant solution, but the article is allready from some time ago (2007). I was wondering: 1. Are there any other methods to solve this? 2. What are the pro's and con's of this and other methods? 3. Is there a mysql implementation available for these methods that I can re-use?
推荐答案
该文章,但它看起来像作者重新创造了双向数据库轮。我没有信心他做得很好,但我没有仔细阅读。
I just skimmed the article, but it looks like the author's reinventing the bi-temporal database wheel. I'm not confident he did a good job of it, but I didn't read it closely.
在你深入之前,花点时间去看Richard Snodgrass的旧书在SQL中开发面向时间的数据库应用程序。它可以从他的网页获得PDF。
Before you get too deep into this, take some time to skim Richard Snodgrass's old book Developing Time-Oriented Database Applications in SQL. It's available as a PDF from his web page.
我认为MySQL缺乏对CHECK约束的支持和GROUP BY的独特实现,将使他的方法难以实现。如果您有自由选择,PostgreSQL可能是一个更好的平台。
I think MySQL's lack of support for CHECK constraints and peculiar implementation of GROUP BY will make his approach hard to implement. If you have freedom of choice, PostgreSQL might be a better platform for this.
这篇关于如何在MySQL中创建一个时间点架构的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!