Active archiving and HSM: best-practices. (Storage Networking).IT executives are looking for Looking for
In the context of general equities, this describing a buy interest in which a dealer is asked to offer stock, often involving a capital commitment. Antithesis of in touch with. ways to improve storage management and maximize their storage investment. Hierarchical Storage Management See HSM. (HSM (1) (Hierarchical Storage Management) The automatic movement of files from hard disk to slower, less-expensive storage media. The typical hierarchy is from magnetic disk to optical disc to tape. ), a common approach in mainframe environments for many years, is now getting attention in client/server environments A networking environment that is made up of clients and servers running applications designed for client/server architecture. See client/server. . In addition to the benefits that can be derived from HSM and other leading storage technologies, active archiving Moving data to a secondary storage medium that can be readily accessed if required. Active archiving enhances the performance of production databases by eliminating records that are not accessed daily, but may be needed for reference from time to time. is recognized as a cost-effective strategy that solves the problem of excessive database growth for the long-term. In fact, active archiving can work within the framework of HSM systems to enable a best-practice "staged" approach to enterprise data management.
What do HSM and Active Archiving Offer?
HSM systems are designed to reduce storage and administration costs while keeping data available. This technology intelligently migrates files along a hierarchy of storage devices ranked in terms of cost per unit of storage, speed for access and retrieval, and available capacity. The HSM solution manages files based on the rules specified by the storage system administrator. Once these rules are defined, the HSM system manages file migration and demigration automatically, moving files of a certain age or type to the near-line storage device.
Although various products differ, HSM generally classifies data according to according to
1. As stated or indicated by; on the authority of: according to historians.
2. In keeping with: according to instructions.
3. a three-tier architecture.
* Level One data (hot data) must be readily available. Hot data is kept on the network server.
* Level Two data (warm data) is accessed periodically. Warm data is migrated to a near-line storage device, such as a low-cost, high-capacity hard drive or an optical disk jukebox A storage device for multiple sets of CD-ROMs, DVDs, tape cartridges or disk modules. Using carousels, robot arms and other methods, a jukebox physically moves the storage medium from its assigned location to an optical or magnetic station for reading and writing. .
* Level Three data (cold data) is infrequently in·fre·quent
1. Not occurring regularly; occasional or rare: an infrequent guest.
2. used, but is kept for business or legal reasons. Cold data is archived in a tape storage library.
Every time HSM migrates a file, it places a "stub A small software routine placed into a program that provides a common function. Stubs are used for a variety of purposes. For example, a stub might be installed in a client machine, and a counterpart installed in a server, where both are required to resolve some protocol, remote procedure " on the network server that points to the file location on the near-line storage device or tape. This pointer system is completely transparent to the user, who can view and access the file as if it were still stored on the server. When a user requests a file that has been migrated, the HSM system "de-migrates" the file by copying it to the appropriate higher level for easy access. The response time for accessing this data depends on which level in the HSM hierarchy the file is stored and the type of medium that is used to store the file.
Active archiving is similar to HSM, providing users the ability to manage rarely accessed data. However, unlike traditional archiving, active archiving is a proven technology that safely archives and removes nonessential non·es·sen·tial
Being a substance required for normal functioning but not needed in the diet because the body can synthesize it. data from complex relational databases relational database
Database in which all data are represented in tabular form. The description of a particular entity is provided by the set of its attribute values, stored as one row or record of the table, called a tuple. with 100 percent accuracy. Going well beyond the traditional definition of archiving, active archiving allows companies to select and remove precise sets of rarely used data or "active reference data" from a production database and save the data to an Archive File See archive. , referentially intact and complete. Archive Files can be saved on the most convenient and cost-effective storage media where the data remains "active" for easy access and possible restoration when needed. These capabilities keep archived data accessible and dramatically reduce database overload, allowing companies to reduce storage requirements, improve application response time and reallocate Verb 1. reallocate - allocate, distribute, or apportion anew; "Congressional seats are reapportioned on the basis of census data"
allocate, apportion - distribute according to a plan or set apart for a special purpose; "I am allocating a loaf of current capacity to support more users and transactions.
It's true that active archiving and HSM both address the problem of explosive data growth by moving data to more cost-effective storage devices. However, active archiving is designed for relational data, while HSM is best suited for other types of data such as document files, bit maps, and video clips A short video presentation. . Although HSM is ideal for managing these types of data, the technology is poorly matched for managing relational database tables, which can be very large.
Safely and Accurately Managing Relational Data
Traditionally, IT organizations have been reluctant to remove relational data from production databases because of inherent difficulties. Accidentally deleting essential data could bring mission-critical systems to a halt. Another major concern is the need to quickly locate and access data once it is archived and removed from the production database. Responding to audits, lawsuits, government or security investigations, as well as answering customer questions, may require access to archived data and possibly restoring it to production.
Active archiving provides a "best practice" strategy for managing relational database growth. This proven technology cleanly clean·ly
adj. clean·li·er, clean·li·est
Habitually and carefully neat and clean. See Synonyms at clean.
In a clean manner.
clean and safely archives and removes precise subsets of relational data accurately and completely, while maintaining the integrity and business context of the data. The active archiving process saves not only the data, but also the metadata describing tables, columns and relationships used to create the archive, ensuring that archived data can always be accessed and restored if needed, even if the data model has changed.
Active archiving technology is unique because it understands and intelligently processes data relationships, regardless of the complexity. This understanding is obtained from a database catalog The database catalog of a database instance consists of metadata in which definitions of database objects such as Basis tables, view tables, synonyms, value ranges, indexes, users, and user groups are stored.
≈°220.227.88. and from supplemental relationships defined to a shared directory. These capabilities makes it easy to define, retrieve and manipulate complex, referentially intact sets of related data from multiple tables, without writing low-level extract routines.
Improving Performance, Availability and ROI (Return On Investment) The monetary benefits derived from having spent money on developing or revising a system. In the IT world, there are more ways to compute ROI than Carter has liver pills (and for those of you who never heard of that expression, it means a lot).
By separating mission-critical data from non-critical data, companies can safely reduce the size of overloaded databases by up to 50 percent or more during the initial archive. Significant improvements in application performance and availability are realized immediately. Response time is faster and access to decision-making information is easier. Service levels improve and productivity is enhanced. Expensive upgrades and maintenance fees can be deferred or eliminated, reducing operating costs operating costs npl → gastos mpl operacionales . Ongoing active archiving (daily, weekly or monthly) helps manage data growth and keeps applications operating at peak performance.
Active archiving keeps databases streamlined, significantly reducing the time and resources needed to rebuild the database when disaster strikes. The recovery process can be staged by recovering mission-critical data first and nonessential data later, if necessary. This strategy enables IT organizations to maintain databases at a manageable size that allows them to meet their disaster recovery service level agreements. Software upgrades routine backup and restore procedures will also take much less time.
Active archiving is database independent, allowing IT organizations to manage archived data across the leading relational database platforms (Oracle, DB2/UDB, Sybase, SQL Server An earlier relational DBMS from Sybase and from Microsoft. Sybase introduced SQL Server in 1988 for various Unix versions. In that same year, with help from IBM, Sybase created an OS/2 version that Microsoft licensed and branded as Microsoft SQL Server. , and Informix). It is possible to archive and restore data from one database platform to another or archive data from multiple relational databases to create one or more enterprise Archive Files. If the DBMS (DataBase Management System) Software that controls the organization, storage, retrieval, security and integrity of data in a database. It accepts requests from the application and instructs the operating system to transfer the appropriate data. platform changes, then active archiving will continue to support the enterprise data management strategy through the transition.
Active Archiving Enhances the Value of HSM Storage
While HSM is file-based, active archiving is row-based. HSM manages relational data at the table or dataset level (a relational database table is physically stored as a file), and active archiving manages relational data at the row or record level. Active archiving works within the framework of HSM technology and serves as a gateway for HSM to manage subsets of rarely accessed relational data at the row level. This capability enhances the value of HSM storage.
Although USM USM
1. United States Mail
2. United States Mint
USM n abbr (= United States Mint) → US-Münzanstalt (= United States Mail) → US-Postbehörde can migrate relational database tables up and down the HSM hierarchy, based on the last reference to any data in a database table or file, the size of the production database does not change. Because it's likely that users may need to access a small part of the database at least once during the period designated by the system administrator, the entire relational database file will probably continue to reside at Level One storage.
For example, a customer database table is usually accessed on a regular basis, which would keep it at Level One. Although only a subset of this data remains "hot" (that is, current customers), the entire dataset must be kept on the network server including historical customer data that is rarely, if ever, needed. This limitation minimizes the potential benefit of HSM, degrades application performance and limits the availability of mission-critical CRM (Customer Relationship Management) An integrated information system that is used to plan, schedule and control the presales and postsales activities in an organization. applications.
Active archiving addresses this problem by safely removing historical customer data from the Level One online database at the row level and storing it in a compressed format in one or more Archive Files, which are then managed by HSM. Immediate benefits include faster customer response time, improved call agent productivity, and the ability to manage larger call volumes while reducing the average cost per call.
Companies that have already deployed HSM understand the benefits of "staged" data management for flat files. The HSM migration rules can be defined to manage "warm" and "cold" Archive Files. By combining HSM and active archiving, IT organizations benefit from both streamlined relational databases and HSM managed Archive Files. Routine active archiving can be implemented across the enterprise, with or without an HSM solution, to achieve a greater return on investment from the existing IT infrastructure.
Jim Lee is Vice President, Product Marketing at Princeton Softech (Princeton, N.J.).