In contrast, tables and rows in an Oracle or SQL Server database may be segregated by time or have individual time stamps, and each application will organize its data differently. Thus, classifying structured data requires a more intimate association between the database schema created by the application and the classification engine.
As a result, database ILM solutions, including EMC's DatabaseXtender, Hewlett-Packard's Reference Information Manager for Databases and Princeton's Optim, come in editions for common applications, like SAP, to simplify the process. Solix similarly has application definitions that it provides to customers of its ArchiveJinni database-archiving software.
In addition to migrating data as it ages through its lifecycle, most vendors have a module as part of their database ILM suites to generate smaller copies of working databases for development or testing purposes. These minidatabases can contain a full set of triggers and stored procedures, with a representative set of data that can be one-tenth the size of the primary database, enabling programmers to test their code without consuming several terabytes of disk space.
Oracle's ILM assistant, available for free download from the company's site, lets a DBA easily define data lifecycles and assign database tables to the lifecycle. It will then, using Oracle's table partitions, move data from a partition in one tablespace to a partition in another tablespace that's stored on a lower-cost tier. Because Oracle partitions are transparent to user applications, users will be blissfully unaware.
What To Do Now
Once you put into place a management policy and get e-mail and databases squared away, it's time for the lifecycle piece of the equation. That means building a three-legged stool: tiered storage; data classification, where through a combination of business processes and an automated classification engine you evaluate each set of data; and a migration engine that moves data to a location commensurate with its current value.
Bob Friday, Chief AI Officer for Juniper Networks, explains how the advanced technology is transforming operations.
Contact center leaders from 8x8, Awaken Intelligence, and 360insight discuss the importance of agent experience.
AI may force enterprises to rewire parts of their data centers so they are fully optimized to run such workloads. The question is do you use Ethernet or InfiniBand?
