12 February 2009

🛢DBMS: Latency (Definitions)

"The amount of time that elapses between when a change is completed on the Publisher and when it appears in the destination database on the Subscriber." (Microsoft Corporation, "SQL Server 7.0 System Administration Training Kit", 1999)

"The amount of time that elapses between when a data change is completed at one server and when that change appears at another." (Anthony Sequeira & Brian Alderman, "The SQL Server 2000 Book", 2003)

"The amount of time that elapses when a data change is completed at one server and when that change appears at another within a replication architecture (for example, the time between when a change is made at a publisher and when it appears at the subscriber)." (Thomas Moore, "MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005", 2006)

"The delay in time for a data change to be propagated between nodes in a replication topology." (Marilyn Miller-White et al, "MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance 70-444", 2007)

[latency of information:] "Latency is a time delay between the moment something is initiated and the moment one of its effects begins or becomes detectable. Latency of information applies this concept to changes, updates, and deletes of information." (Allen Dreibelbis et al, "Enterprise Master Data Management", 2008)

[data latency:] "Technically, the speed in which data is captured is referred to as data latency. It is a measure of data 'freshness', specifically data that are less than 24 hours old." (Linda Volonino & Efraim Turban, "Information Technology for Management" 8th Ed., 2011)

"The measure of time between two events, such as the initiation and completion of an event, or the read on one system and the write to another system." (DAMA International, "The DAMA Dictionary of Data Management", 2011)

"The delay that occurs while data is processed or delivered." (Microsoft, "SQL Server 2012 Glossary", 2012)

"In replication, part or all of the approximate difference between the time that a source table is changed and the time that the change is applied to the corresponding target table." (Sybase, "Open Server Server-Library/C Reference Manual", 2019)

 "The amount of time that elapses when a data change is completed at one server and when that change appears at another server." (Microsoft Technet)

No comments:

Related Posts Plugin for WordPress, Blogger...

About Me

My photo
Koeln, NRW, Germany
IT Professional with more than 24 years experience in IT in the area of full life-cycle of Web/Desktop/Database Applications Development, Software Engineering, Consultancy, Data Management, Data Quality, Data Migrations, Reporting, ERP implementations & support, Team/Project/IT Management, etc.