ILM FAQ
Answers
How do I prove that data has not been changed
Oracle can generate a cryptographic signature to show that the contents of a record have not been altered. This signature can then be generated weeks or months later and if the signatures are the same then the contents of the record have not been altered. From Oracle Database 10g Release 2 , there is the ability to generate a cryptographic signature based on the results of a SQL query.
It is the responsibility of the user to manitain their cryptographic signatures in a safe location.
Will Performance improve by implementing ILM
ILM is not a solution for improving database performance, which is best achieved by tuning the database. Sometimes users report that the application performance has improved when data is removed from the database. Normally this occurs because the data hasn't been well indexed or even partitioned. A well tuned database will easily handle terrabytes of data as shown in the 2005 Winter Corporation survey of large databases http://www.wintercorp.com/VLDB/2005_TopTen_Survey/2005TopTenWinners.pdf where #1 is Yahoo's 100TB database which runs on Oracle.
Is the Partitioning option required for Oracle ILM
Although it is possible to build an ILM solution based on the Oracle Database without using the partitioning option, it will not be possible to take advantage of all the features if partitioning is unavailable.
Which Options are Required for Oracle ILM
The options you require will depend on the features used in your ILM implementation. You will most likely need the Partitioning option and maybe some of the options listed at http://www.oracle.com/database/db_options.html
How do you deal with schema changes during the lifetime of the data
Many changes can be made to the schema without affecting the existing data. However, if the change applies to all data then online redefinition can be used to modify the existing data whilst still providing access to current data.
What types of Partitioning are supported
Oracle ILM supports all the partitioning options available in the Oracle Database. However, the Oracle ILM Assistant only supports tables range partitioned by date.
Where do I go for additional Oracle ILM information
Visit the ILM OTN web site at http://www.oracle.com/technology/deploy/ilm/index.html
Are changes to the Application required to Implement Oracle ILM
It should be possible to implement your ILM solution using the Oracle Database without the need to change your application because all the changes are specified within the database.
How many Tiers of Storage are needed for Oracle ILM
Oracle ILM allows you to define as many tiers of storage as is required by your implementation. However, 2 or 3 storage tiers are most commonly used.
If I set a tablespace read-only in say Oracle 9.2 will it be still readable by a future version of Oracle
If the tablespace is kept online then it will always be accessable by Oracle.
Does Oracle ILM require ASM
No, it is possible to implement an Oracle ILM solution without using ASM. However, there are some advantages of building storage tiers using ASM diskgroups.
Is it necessary to archive data
There can be a number of reasons why it might be necessary to archive data, for example, regulatory compliance or business rules. Archives today no longer need to be the traditional tape archive, what about an online database archive where the information is always available, but seperate from the production systems.
How is data integrity maintained during archiving
Maintaining data integrity when archiving will probably involve archiving the primary data as well, such as the customer or products table. If these tables are not too large, it may be easier to archive the entire primary data rather than try and find only those primary records which are in the data to be archived.
If I keep all my data online, how do I prevent a user accessing all the data
Create a policy using VPD (Virtual Private Database) to only allow access to all of the data to specified users
Can I use transportable tablespaces to archive data
This is a good approach for archiving data because the tablespace can be easily plugged back into the database. Consider placing an XML descriptor around the tablespace for documenting its attributes.
How do I perform Data Classification
Data Classification involves understanding how the data is used and accessed and determining a suitable classification criteria. This can then be described using the Oracle ILM Assistant
Is Fine-Grained Auditing part of Oracle ILM
Fine-Grained Auditing is one of the features that can be used in an Oracle ILM implementation to show who has been accessing data
If I export data out of the Oracle Database will I be able to import it back into an Oracle Database in the future
Yes, we have always ensured that old dump files can be read by the import utilities
Can we implement Oracle ILM on Oracle EBS and Siebel CRM
Oracle ILM is a set of policies and techniques for managing data. Therefore you can use the techniques on any system where partitioning is available and if you haven't yet partitioned your data, then the ILM Assistant can provide advice on a suitable partitioning strategy.
Although Oracle ILM is focused on partitioning, it is possible to take advantage of the compliance aspects of ILM, such as securing data from unauthorised access and auditing access by using features in the Oracle Database, such as VPD, which do not require partitioning.
Is Partitioning supported for Oracle EBS
Yes, refer to this
article for more information
What are the press saying about Oracle ILM and the Oracle ILM Assistant
Press coverage has been extensive and positive (below is
just a sample):
What versions of Oracle Enterprise Edition can I use to implement an ILM solution
Any version from 8i onwards, however the ILM Assistant has only been tested against version 9i and upwards.
Are there any references for Oracle ILM
Refer to these articles
Nasdaq http://www.oracle.com/customers/snapshots/nasdaq.pdf
Starwood Hotels http://www.oracle.com/corporate/press/2006_jun/060806-starwood-finalsite.html
|
|
|
Bookmark
