Davidstech’s Weblog

…for intelligent information management

Archive for May, 2009

Optimize application portfolio

Posted by davidstech on May 28, 2009

Application retirement is a viable strategy for eliminating redundant legacy applications, thereby improving operational efficiency and reducing costs. By reducing the number of applications within the IT infrastructure, DBAs can concentrate on maintaining critical business applications with the highest value to the organization, instead of compiling data from disparate sources.

Application retirement allows organizations to implement data migration projects across applications: Legacy, Mainframe, BaaN, JDE, PeopleSoft, Siebel Oracle, SAP, etc. while allowing changes to chart of accounts, organization structure, costing methods, etc.

Data auditing provides enterprises with the tools to classify data based on its sensitivity, define policies at the database level that determine how that data should be managed, and automatically monitors and logs any changes to application data.

Data that has been relocated after classification is protected from redundant searches or data addition. This helps in maintaining integrity and reduces the strain on database servers. When a quarterly or yearly trend analysis is performed it allows for convenient data purging also. Automation of archiving and purging is available as data archiving solutions. They can be used by multiple projects at the same time and data retrieval is very convenient.

Posted in 1 | Tagged: , , , | Leave a Comment »

Efficient test data management process

Posted by davidstech on May 28, 2009

Most enterprise class business applications require multiple copies be made to support test data management processes such as patch, test, QA, etc. Hence 6-8 full size clones are prepared, thereby potentially exposing sensitive application data. To ensure sensitive data remains protected against the largest source of vulnerability, the internal threat; data management suites allow telecom operators to identify data that meets specific security and retention requirements and automate how the data is protected and managed throughout its entire lifecycle.

Data masking is a proven strategy to obscure specific fields that identify an individual, potentially exposing customers or employees to identity theft or other forms of privacy invasion. Utilizing data privacy Pack for Oracle E-Business Suite to scramble, encrypt, shuffle or otherwise mask names, addresses, credit card numbers, salaries, or social security numbers; privacy is ensured and relational integrity is maintained.

Data archiving ensures database performance is optimized for the business need while creating savings in storage and data maintenance activities. Users of Oracle E-Business Suite, Baan, Oracle JD Edwards, Oracle PeopleSoft, Siebel and more benefit a great deal by enterprise data archiving.

Posted in archiving | Tagged: , , , | Leave a Comment »

Management with Effective Database

Posted by davidstech on May 21, 2009

Enterprise data management solutions for managing data holistically, accounting for compliance, cost, and security. With quantifiable improvement across the enterprise, organizations reduce risk, lower costs, and improve performance and operational efficiencies.

It is a common fact that most database applications store company’s confidential details such as employee information, client information, company’s financial details etc. Most often these details need to be shared with developers and others while providing production support for upgrades, training, outsourcing etc. As a result there is a great risk of this data being used for unlawful activities. Data masking helps in protecting data in less secure environments.

Most enterprise class business applications require multiple copies be made to support test data management processes such as patch, test, QA, etc. Hence 6-8 full size clones are prepared, thereby potentially exposing sensitive application data. To ensure sensitive data remains protected against the largest source of vulnerability, the internal threat; data management suites allow telecom operators to identify data that meets specific security and retention requirements and automate how the data is protected and managed throughout its entire lifecycle.

Data privacy pack for Oracle E-Business Suite can be deployed on non-production databases to ensure customer and employee privacy by obscuring sensitive data such as names, addresses, social security numbers and other sensitive data prior to the data being released to the test and development environment.

Posted in archiving | Tagged: , , , | Leave a Comment »

Data Archiving for Enterprise Applications

Posted by davidstech on May 21, 2009

Every kind of storage is bound to overflow sometime or the other; it also applies to software industries. Companies that have large storage data, which would also be needed for future trend analysis, reduce retrieval speed. Such companies can opt for data archiving solutions. Data archiving is built on the concept of preserving data through classification and storage, helps in improving throughput.

Information Lifecycle Management solutions are designed to help enterprises manage data growth by providing the tools classify, archive and migrate data to improve application performance and reduce administrative overhead and infrastructure costs.

Using data archiving reduces overall storage costs while maintaining access through the native application. This provides the complete solution for all enterprise data archiving needs. Data auditing tools allow enterprises to mitigate security risks with real-time event notification and maintain audit logs of all data changes for search and retrieval during an eDiscovery inquiry.

Data migration is a metadata based tool that allows companies to map metadata between applications and create conversion rules for faster and seamless data migration. It acts as an efficient project accelerator for migrations of any nature.

Often many applications, which were yielding good results for the companies, become outmoded when organizations grow, merge or strengthen their operations; since not much attention is paid to maintain these applications. Application retirement is the best solution for doing away with disused applications as they expend a lot of resources, storage etc while benefiting the organization very little.

Posted in archiving | Tagged: , , , , , | Leave a Comment »

Test and Development for Enterprise Applications

Posted by davidstech on May 13, 2009

Enterprise class business applications require multiple copies be made to support test data management processes such as patch, test, QA, and training. Most companies make 6-8 full size clones for every production application, not only wasting storage and time in cloning but potentially exposing sensitive application data to the test environment. Data masking provides companies with a centralized solution to manage the test data management process for clone creation, productivity and data security. Maintaining data privacy in non-production environments is an important step in the IT governance chain that will keep sensitive data private and corporate reputation intact

Enterprise data management solutions for managing data holistically, accounting for compliance, cost, and security. With quantifiable improvement across the enterprise, organizations reduce risk, lower costs, and improve performance and operational efficiencies.

Information Lifecycle Management solutions are designed to help enterprises manage data growth by providing the tools classify, archive and migrate data to improve application performance and reduce administrative overhead and infrastructure costs.

Posted in database management | Tagged: , , , | Leave a Comment »

Enterprise Metadata Manager

Posted by davidstech on May 13, 2009

Data management solutions provide organizations with the tools to mitigate risk, reduce storage costs, enforce consistent security policies, data auditing, and to retire legacy applications. They also help in data archiving so as to support eDiscovery by creating a secure, controlled, and searchable archive for all data – application, email, documents and other files.

Application retirement helps organizations to reduce cost while maintaining access to the data either through the creation of a common data store or by data migration into an existing enterprise application. This helps in operational efficiency and reducing cost.

Application retirement is a growing necessity for many organizations as they grow, merge or consolidate operations. The number of enterprise systems that IT departments support continues to grow. Strategic moves away from proprietary mainframe and applications systems coupled with efforts to reduce IT spending on existing infrastructure are bringing focus on application retirement as a way to fund new projects or make the existing IT budget go farther.

Posted in database management | Tagged: , , , | Leave a Comment »