Abstract
At EDF, a leading energy company, process data produced in power stations are archived both to comply with legal archiving requirements and to perform various analysis applications. Such data consist of timestamped measurements, retrieved for the most part from process data acquisition systems. After archival, past and current values are used for various applications, including device monitoring, maintenance assistance, decision support, statistics publication, etc.
Large amounts of data are generated in these power stations, and aggregated in soft real-time – without operational deadlines – at the plant level by local servers. For this long-term data archiving, EDF relies on data historians – like InfoPlus.21, PI or Wonderware Historian – for years. This is also true for other energy companies worldwide and, in general, industry based on automated processes.
In this paper, we aim at answering a simple, yet not so easy, question: how can data historians be placed in the data management landscape, from classical RDBMSs to NoSQL systems? To answer this question, we first give an overview of data historians, then discuss benchmarking these particular systems. Although many benchmarks are defined for conventional database management systems, none of them are appropriate for data historians. To establish a first objective basis for comparison, we therefore propose a simple benchmark inspired by EDF use cases, and give experimental results for data historians and DBMSs.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Arasu, A., Babcock, B., Babu, S., Datar, M., Ito, K., Motwani, R., Nishizawa, I., Srivastava, U., Thomas, D., Varma, R., Widom, J.: STREAM: The Stanford Stream Data Manager. IEEE Data Engineering Bulletin 26(1), 19–26 (2003)
Arasu, A., Cherniack, M., Galvez, E., Maier, D., Maskey, A.S., Ryvkina, E., Stonebraker, M., Tibbetts, R.: Linear Road: A Stream Data Management Benchmark. In: VLDB 2004: Proceedings of the Thirtieth International Conference on Very Large Data Bases, pp. 480–491 (2004)
Aspen Technology. Database Developer’s Manual (2007)
Golab, L., Johnson, T.: Consistency in a Stream Warehouse. In: CIDR 2011: Proceedings of the Fifth Biennial Conference on Innovative Data Systems Research, pp. 114–122 (2011)
Invensys Systems. Wonderware Historian 9.0 High-Performance Historian Database and Information Server (2007)
Olson, M.A., Bostic, K., Seltzer, M.I.: Berkeley DB. In: Proceedings of the FREENIX Track: 1999 USENIX Annual Technical Conference, pp. 183–191 (1999)
OPC Foundation. Data Access Custom Interface Standard (2003)
OSIsoft. PI Server System Management Guide (2009)
Transaction Processing Performance Council. TPC Benchmark C Standard Specification (2007)
Transaction Processing Performance Council. TPC Benchmark H Standard Specification (2008)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2013 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Chardin, B., Lacombe, JM., Petit, JM. (2013). Data Historians in the Data Management Landscape. In: Nambiar, R., Poess, M. (eds) Selected Topics in Performance Evaluation and Benchmarking. TPCTC 2012. Lecture Notes in Computer Science, vol 7755. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-36727-4_9
Download citation
DOI: https://doi.org/10.1007/978-3-642-36727-4_9
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-36726-7
Online ISBN: 978-3-642-36727-4
eBook Packages: Computer ScienceComputer Science (R0)