Also, in the past, the CSP experts on developments noticed often high manual effort in the archiving run. The use of a standard solution such as the software Chronos can be considered best-practice solution. Open archive formats allow the structuring in XML files. A consistent container is created from farm animals and metadata. An incremental archive allows an archive without redundancies. Access to a single archived database entry is possible without having the entire archive must be restored.
Furthermore, external job control and monitoring tools can connect and automatically take into account structural changes of the database. Why just leaves you not all data in the existing database? In the white paper, it is checked whether the known under the keyword ACID (Atomicity = A, C = consistency, I = insulation, durability = D) Requirements for databases on historical data apply. Brandl comes to the conclusion that this is not the case. Only the durability is a fundamental requirement for both active and inactive data is valid. Relational databases are not suitable for the storage of historical data. Because most functionalities like consistency when inserting data, isolation of transactions or high availability and historical data is not required, this type of data storage represents a high and at the same time unnecessary business expense. After all, about 85 percent of the data in databases as historical can be classified after analysis of Forrester research.
The growth increases significantly. This shows the high potential of energy savings in the storage”Stefan Brandl explains the basic idea. Tags: databases, database archiving, archiving and compliance via CSP GmbH & co. KG: CSP GmbH & co. KG was founded in 1991 and specializes in innovative software solutions for manufacturing companies Specialized. The company provides to its customers as well as the implementation and customization of standard solutions also comprehensive advice and support. CSP has numerous international reference customers in the industry. Including trust group BMW, Audi, Daimler, MAN, General Motors, Volvo, Chrysler, Renault, VW, Porsche and Bosch on the solutions of the company. Contact address: CSP GmbH & co. KG wife Heike Johannes mens Qamar Street 11 94431 Grosskollnbach Tel: + 49 (0) 9953/3006-0 fax: + 49 (0) 9953 / 3006-50 E-mail: Internet: PR Agency: Walter Visual PR GmbH Mr. Markus Walter Rheinstrasse 99 65185 Wiesbaden Tel.: 06 11 / 2 38 78 – 0 fax: 06 11 / 2 38 78 – 23 E-mail: Internet: