Abstract
An approach for archiving time-based data is presented. The basic idea is to split data intelligently into separate time-dependent areas having different logical and physical properties. It is especially useful and sustainable when dealing with just a few but very big data tables, when all-time availability becomes a principal issue or when it is necessary to have a fast restore in case of a disaster recovery—even if the database reaches sizes over one TB.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Niu CL, Yu XN, Li JQ, Sun W (2005) The application of operation optimization decision support systems based on data mining in power plant. In: Proceedings of 2005 international conference on machine learning and cybernetics
Rastogi UJ, Srinivas VK, Guptan RG (2010) Databases and their analysis for applications in quantitative risk analysis of NPP. In: 2nd international conference on reliability, safety and hazard (ICRESH), 2010
Oracle Database, http://www.oracle.com/technetwork/database/enterprise-edition/overview/index.html
Oracle Partitioning, http://www.oracle.com/technetwork/database/options/partitioning/index.html
Oracle Scheduler Concepts, http://download.oracle.com/docs/cd/E11882_01/server.112/e17120/schedover.htm#i1106753
Oracle Scheduler: Scheduling of Jobs and Administration, http://download.oracle.com/docs/cd/E11882_01/server.112/e17120/scheduse.htm#i1033533. http://download.oracle.com/docs/cd/E11882_01/server.112/e17120/schedadmin.htm#i1007589
Oracle Data Pump, http://download.oracle.com/docs/cd/E11882_01/server.112/e16536/part_dp.htm#i436481
Oracle Data Pump PL/SQL Interface, http://download.oracle.com/docs/cd/E11882_01/appdev.112/e16760/d_datpmp.htm#i1007277
Oracle Backup and Recovery User’s Guide, http://www.oracle.com/pls/db112/to_pdf?pathname=backup.112/e10642.pdf
Oracle Backup and Recovery Reference, http://www.oracle.com/pls/db112/to_pdf?pathname=backup.112/e10643.pdf
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer Science+Business Media B.V.
About this paper
Cite this paper
Haag, T., Meier, T., Dzafic, I. (2012). High Availability Archive for Time-Based Data. In: J. (Jong Hyuk) Park, J., Chao, HC., S. Obaidat, M., Kim, J. (eds) Computer Science and Convergence. Lecture Notes in Electrical Engineering, vol 114. Springer, Dordrecht. https://doi.org/10.1007/978-94-007-2792-2_20
Download citation
DOI: https://doi.org/10.1007/978-94-007-2792-2_20
Published:
Publisher Name: Springer, Dordrecht
Print ISBN: 978-94-007-2791-5
Online ISBN: 978-94-007-2792-2
eBook Packages: EngineeringEngineering (R0)