I read this term a lot. What exactly is a legacy database? I ask because I had thought it meant an old database like dbase or rdb, but I don't think I'm right.
我读了很多这个词。什么是遗留数据库?我问,因为我认为它意味着像dbase或rdb这样的旧数据库,但我不认为我是对的。
When looking at RoR or Django and "legacy database" integration, what does legacy database really mean? Is it different than a generic term "legacy database"?
在查看RoR或Django以及“遗留数据库”集成时,遗留数据库真正意味着什么?它是否与通用术语“遗留数据库”不同?
11 个解决方案
#1
In the general context, it can refer to any of the older database technologies.
在一般上下文中,它可以指任何较旧的数据库技术。
In a more specific context, it can refer to a database system that was inherited by a team from previous project owners.
在更具体的上下文中,它可以指团队从以前的项目所有者继承的数据库系统。
#2
legacy: anything from the past that keeps coming around to haunt you.
遗产:过去一直困扰着你的东西。
#3
A legacy database is generally something that you will have to inherit and base some of your design decisions around. Most companies that put out work may already have some other (usually horrible) solution and you need to give them a bigger and better product...
遗留数据库通常是您必须继承并基于您的一些设计决策的东西。大多数推出工作的公司可能已经有其他(通常是可怕的)解决方案,你需要给他们一个更大更好的产品......
BUT
It has to work with all of their old legacy data. The company is not going to want to manage two different applications just so they can keep all their old records. You will need to develop your solution to be able to migrate the data from the legacy system over into your system. This can have a massive impact on the overall design of the new database, because it cannot stray too far from the previous without introducing a lot of problems in terms of data integrity.
它必须与所有旧的遗留数据一起使用。该公司不希望管理两个不同的应用程序,因此他们可以保留所有旧记录。您需要开发解决方案,以便能够将遗留系统中的数据迁移到系统中。这可能会对新数据库的整体设计产生巨大影响,因为它不会偏离以前太远而不会在数据完整性方面引入很多问题。
#4
We mostly use the term 'legacy database' as a db schema we can not 'easily' modify without breaking other software/systems using this schema.
我们主要使用术语“遗留数据库”作为数据库模式,如果不破坏使用此模式的其他软件/系统,我们无法“轻松”修改。
#5
It's usually derogatory in my experience:
在我的经历中,这通常是贬义的:
- Something no-one wants to touch in case it breaks
- Databases that can't be maintained (say that SQL 6.5 box lying around)
- Someone else's badly designed and implemented database
- Something that someone is trying to replace
- Supported by the 93 year old wierdo
没有人想要接触的东西以防它破裂
无法维护的数据库(假设SQL 6.5框位于其周围)
其他人设计和实施的数据库设计不当
某人试图取代的东西
由93岁的维尔多提供支持
If it's in-use but still has maintenance or development activities, it can't be legacy...
如果它在使用中但仍然有维护或开发活动,那么它不可能是传统的......
Edit: Given the age of the SQL language and the RDBMS, everything is legacy (including my new system due next year) compared to the software listed. At what point does Ruby turn legacy from the database perspective..?
编辑:鉴于SQL语言和RDBMS的时代,与列出的软件相比,一切都是遗留的(包括我明年到期的新系统)。 Ruby在什么时候从数据库角度转变遗留问题?
#6
this sums it up pretty well.
这总结得很好。
[edit] Broken link. Here's the quote from FOLDOC:
Legacy System -- A computer system or application program which continues to be used because of the cost of replacing or redesigning it and often despite its poor competitiveness and compatibility with modern equivalents. The implication is that the system is large, monolithic and difficult to modify.
[编辑]断开的链接。以下是FOLDOC的报价:遗留系统 - 计算机系统或应用程序由于更换或重新设计的成本而继续使用,并且通常尽管其竞争力差并且与现代等同物兼容。这意味着系统庞大,单片且难以修改。
If legacy software only runs on antiquated hardware the cost of maintaining this may eventually outweigh the cost of replacing both the software and hardware unless some form of emulation or backward compatibility allows the software to run on new hardware.
如果传统软件仅在陈旧的硬件上运行,维护它的成本最终可能超过更换软件和硬件的成本,除非某种形式的仿真或向后兼容性允许软件在新硬件上运行。
#7
I bet they are referring to the schema of the database, rather than the database system itself.
我敢打赌,他们指的是数据库的架构,而不是数据库系统本身。
#8
Flat file, hierarchy, and network databases are usually referred as legacy databases. They represent the ways people used to organize information in prehistoric times — about 30 years ago.
平面文件,层次结构和网络数据库通常称为旧数据库。它们代表了人们在史前时代用来组织信息的方式 - 大约30年前。
#9
Legacy is used to denote the old thing. legacy database is something which continues to be used because of it cost of replacing and redesigning it.
遗产用于表示旧事物。遗留数据库是一种继续被使用的东西,因为它需要更换和重新设计它。
#10
In general context refers to old code inherited. Tipycally cobol code. It is used for code which it is still used for historcal reasons. It applies also for DB schemas
通常,上下文是指继承的旧代码。 Tipycally cobol代码。它用于代码,它仍然用于历史原因。它也适用于DB模式
#11
Basically, it's legacy when newer techniques have been developed yet for whatever reasons, the old system/database/technique is still used. Age of the database system doesn't matter, really. Legacy means that it can be replaced by a better technique, yet it hasn't been replaced yet.
基本上,无论出于何种原因开发出更新的技术,它仍然是遗留问题,旧的系统/数据库/技术仍在使用。真的,数据库系统的年龄并不重要。遗留意味着它可以被更好的技术取代,但尚未被替换。
#1
In the general context, it can refer to any of the older database technologies.
在一般上下文中,它可以指任何较旧的数据库技术。
In a more specific context, it can refer to a database system that was inherited by a team from previous project owners.
在更具体的上下文中,它可以指团队从以前的项目所有者继承的数据库系统。
#2
legacy: anything from the past that keeps coming around to haunt you.
遗产:过去一直困扰着你的东西。
#3
A legacy database is generally something that you will have to inherit and base some of your design decisions around. Most companies that put out work may already have some other (usually horrible) solution and you need to give them a bigger and better product...
遗留数据库通常是您必须继承并基于您的一些设计决策的东西。大多数推出工作的公司可能已经有其他(通常是可怕的)解决方案,你需要给他们一个更大更好的产品......
BUT
It has to work with all of their old legacy data. The company is not going to want to manage two different applications just so they can keep all their old records. You will need to develop your solution to be able to migrate the data from the legacy system over into your system. This can have a massive impact on the overall design of the new database, because it cannot stray too far from the previous without introducing a lot of problems in terms of data integrity.
它必须与所有旧的遗留数据一起使用。该公司不希望管理两个不同的应用程序,因此他们可以保留所有旧记录。您需要开发解决方案,以便能够将遗留系统中的数据迁移到系统中。这可能会对新数据库的整体设计产生巨大影响,因为它不会偏离以前太远而不会在数据完整性方面引入很多问题。
#4
We mostly use the term 'legacy database' as a db schema we can not 'easily' modify without breaking other software/systems using this schema.
我们主要使用术语“遗留数据库”作为数据库模式,如果不破坏使用此模式的其他软件/系统,我们无法“轻松”修改。
#5
It's usually derogatory in my experience:
在我的经历中,这通常是贬义的:
- Something no-one wants to touch in case it breaks
- Databases that can't be maintained (say that SQL 6.5 box lying around)
- Someone else's badly designed and implemented database
- Something that someone is trying to replace
- Supported by the 93 year old wierdo
没有人想要接触的东西以防它破裂
无法维护的数据库(假设SQL 6.5框位于其周围)
其他人设计和实施的数据库设计不当
某人试图取代的东西
由93岁的维尔多提供支持
If it's in-use but still has maintenance or development activities, it can't be legacy...
如果它在使用中但仍然有维护或开发活动,那么它不可能是传统的......
Edit: Given the age of the SQL language and the RDBMS, everything is legacy (including my new system due next year) compared to the software listed. At what point does Ruby turn legacy from the database perspective..?
编辑:鉴于SQL语言和RDBMS的时代,与列出的软件相比,一切都是遗留的(包括我明年到期的新系统)。 Ruby在什么时候从数据库角度转变遗留问题?
#6
this sums it up pretty well.
这总结得很好。
[edit] Broken link. Here's the quote from FOLDOC:
Legacy System -- A computer system or application program which continues to be used because of the cost of replacing or redesigning it and often despite its poor competitiveness and compatibility with modern equivalents. The implication is that the system is large, monolithic and difficult to modify.
[编辑]断开的链接。以下是FOLDOC的报价:遗留系统 - 计算机系统或应用程序由于更换或重新设计的成本而继续使用,并且通常尽管其竞争力差并且与现代等同物兼容。这意味着系统庞大,单片且难以修改。
If legacy software only runs on antiquated hardware the cost of maintaining this may eventually outweigh the cost of replacing both the software and hardware unless some form of emulation or backward compatibility allows the software to run on new hardware.
如果传统软件仅在陈旧的硬件上运行,维护它的成本最终可能超过更换软件和硬件的成本,除非某种形式的仿真或向后兼容性允许软件在新硬件上运行。
#7
I bet they are referring to the schema of the database, rather than the database system itself.
我敢打赌,他们指的是数据库的架构,而不是数据库系统本身。
#8
Flat file, hierarchy, and network databases are usually referred as legacy databases. They represent the ways people used to organize information in prehistoric times — about 30 years ago.
平面文件,层次结构和网络数据库通常称为旧数据库。它们代表了人们在史前时代用来组织信息的方式 - 大约30年前。
#9
Legacy is used to denote the old thing. legacy database is something which continues to be used because of it cost of replacing and redesigning it.
遗产用于表示旧事物。遗留数据库是一种继续被使用的东西,因为它需要更换和重新设计它。
#10
In general context refers to old code inherited. Tipycally cobol code. It is used for code which it is still used for historcal reasons. It applies also for DB schemas
通常,上下文是指继承的旧代码。 Tipycally cobol代码。它用于代码,它仍然用于历史原因。它也适用于DB模式
#11
Basically, it's legacy when newer techniques have been developed yet for whatever reasons, the old system/database/technique is still used. Age of the database system doesn't matter, really. Legacy means that it can be replaced by a better technique, yet it hasn't been replaced yet.
基本上,无论出于何种原因开发出更新的技术,它仍然是遗留问题,旧的系统/数据库/技术仍在使用。真的,数据库系统的年龄并不重要。遗留意味着它可以被更好的技术取代,但尚未被替换。