Davidstech’s Weblog

…for intelligent information management

Develop classification strategies for primary and secondary data sets

Posted by davidstech on November 9, 2009

Enterprise Applications and Databases are designed and architected to efficiently record and store the transactional history of the organization. By using application archiving organizations can improve application performance and availability through smaller production database sizes, shorter backup and recovery times, reduced labor costs to maintain the production system and lower storage costs.

Data is the life blood of any organization, but too much data can slow application and reporting performance and tax IT resources. Utilizing database archiving to actively manage the growth of application data is key to managing data for its value to the organization.

Enterprise data management supports all JD Edwards modules. It can be integrated with any module in JD Edwards database through EDMS objects that define the most common JD Edwards business logic.

Enterprise Data Management Suite’s modular and centralized architecture allows companies to securely manage their data management processes. This helps organizations to Increase productivity among application users and reduce IT maintenance associated with large data volumes.

Many organizations have tried alternative approaches to archiving, such as running batch reports during downtime, purchasing faster hardware or purging data by completely removing data from access. None of these strategies fully address the challenges of database growth and the need for long term data retention. To maintain performance of oracle archiving based applications while complying with data retention needs, organizations must develop classification strategies for primary and secondary data sets.

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

Reduce storage footprint of Test and Development

Posted by davidstech on November 9, 2009

Securing sensitive data in database environments is only one piece of the compliance puzzle. Data Auditor 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.

With peoplesoft archiving, organizations can implement policy based schemes for automatically migrating out of Tier 1 production stores into lower cost Tier 2 storage, ensuring application performance, faster back-up and recovery and lower total cost of storage. Most experts conclude up to 80% of production data is no longer mission critical, using enterprise data archiving reduces overall storage costs while maintaining access through the native application.

Test Data Management is a strategy for organizations to manage their test and development processes to meet application development and testing requirements, streamline cloning processes and secure data so organizations are equipped to deliver the clones needed to meet upgrade and patch cycles and maintain data security.

Multiple clones must be configured and managed across applications, databases, servers, and storage devices, all the while exposing sensitive customer data to potential leaks. With identity theft a growing concern among consumers, regulators and law makers, a strategic approach to manage test data is needed.

Organizations can mitigate the impact of data growth by running batch reports during downtime, purchasing faster hardware or utilizing the purge functionality. None of these techniques fully address the reality of database growth and the need for long term data retention. To maintain performance of archive MySQL based applications while ensuring compliance, organizations must Develop classification strategies for primary and secondary data sets.

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

Implement a comprehensive data management strategy

Posted by davidstech on November 3, 2009

Data Archiving allows companies to securely manage their archiving processes. There is no need for multiple installations of database tools or application metadata for each server environment. Application archiving helps organizations to implement a comprehensive data management strategy. Implementing information lifecycle management is the best practices with EDMS, organizations can Secure data throughout the entire data lifecycle.

Data Management Suite’s modular and centralized architecture allows companies to securely manage their data management processes. This helps organizations reduce high cost infrastructure in production systems.

With the help of baan database organizations can create and deploy effective and consistent policies for managing, securing and storing data from a single console. The result is improved application performance and availability through smaller production database sizes, shorter backup and recovery times, reduced labor costs to maintain the production system and lower storage costs.

EDMS supports all JD Edwards modules. It can be integrated with any module in JD Edwards through EDMS objects that define the most common JD Edwards business logic.

In the US, Data Centers release 44 million metric tons of CO2 into the air annually, consuming 61 billion kwH and costing $4.5 billion. Going green in the data center is about reducing power, reducing CO2 and driving energy cost out of the IT infrastructure. A smart data management policy is critical to reducing the cost in power and cooling while fulfilling the needs of data retention.

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

Retail Data Management Solutions

Posted by davidstech on November 3, 2009

By implementing retail data security helps in improving Customer Satisfaction and Sales. Online transaction processing is faster and availability to promise queries are quicker resulting in higher customer satisfaction and higher purchase probability. Enterprise Data Management is a best practice that can be implemented in a retailer’s data center to mitigate risk associated with managing consumer sensitive data.

Database Archiving for health data management solutions is part of the Enterprise Data Management Suite that enables centralized management of data classification and security policies. At the core of the EDMS is the Enterprise Metadata Manager, which manages multiple applications and data types across all hardware platforms through a unified policy manager.

Financial services data management allows financial services companies to identify data that meets specific data security and retention requirements and automate how data is protected and managed throughout its entire lifecycle. This solution allow enterprises to deploy tiered storage with enterprise data archiving, and significantly reduce the size of the entire application environment with the data masking solution while ensuring sensitive data remains secure.

Test data management allows companies to securely manage test data and development processes with a single tool.  There is no need for multiple installations of database tools for each server environment.

Organizations face a critical challenge; they don’t know what data they have, how many copies of data exist, what data is in production databases and which are in non-production such as Test and Development, QA, etc. With ediscovery compliance, companies can understand all their Enterprise Data (Applications, Email & Documents) for eDisovery.

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

Enterprise Data Archiving Solution for JD Edwards

Posted by davidstech on October 27, 2009

Organizations can mitigate the impact of data growth by running batch reports during downtime, purchasing faster hardware or utilizing the purge functionality. SQL server archiving modular and centralized architecture allows companies to securely manage their archiving processes. There is no need for multiple installations of database tools or application metadata for each server environment.


With health data management solutions, organizations can create and deploy effective and consistent policies for managing, securing and storing data from a single console. The result is improved application performance and availability through smaller production database sizes, shorter backup and recovery times, reduced labor costs to maintain the production system and lower storage costs.

EDMS supports peoplesoft archiving for all modules. It can be integrated with any module in PeopleSoft through EDMS objects that define the most common PeopleSoft business objects. EDMS enables users having functional knowledge to build configurations around related objects in PeopleSoft.


With the help of application archiving organizations can save storage, improve database and reporting performance and lesson the burden on IT resources for data back-up, disaster recovery and cloning. Additionally, under-utilized data can be moved to lower cost Tier-2 storage while seamless data access is maintained.


Jd Edwards database has a long history of delivering ERP systems to mid-market companies, capturing, storing and delivering mission critical information. Over time, the load from millions of financial and operational transactions added to the system daily weighs heavily on the application servers, impacting performance and report response rates.

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

Data Privacy for Oracle E-Business Suite

Posted by davidstech on October 27, 2009

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 Oracle data masking 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.


Enterprise data auditing ensures that you are alerted when unusual activity is occurring and keeping a secure and searchable audit log of database changes is critical to maintaining compliance with regulatory requirements as well as ensuring adherence to corporate information governance policies.


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.


Enterprise database archiving for PeopleSoft, organizations can implement policy based schemes for automatically migrating out of Tier 1 production stores into lower cost Tier 2 storage, ensuring application performance, faster back-up and recovery and lower total cost of storage. Test data management helps organizations to achieve faster cloning times through rapid application and database cloning processes.

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

Planned Migration

Posted by davidstech on October 21, 2009

Baan database helps organizations to create and deploy effective and consistent policies for managing, securing and storing data from a single console. The result is improved application performance and availability through smaller production database sizes, shorter backup and recovery times, reduced labor costs to maintain the production system and lower storage costs.

Archive mysql technology is used by some of the world’s largest and fastest-growing organizations to save time and money powering their high-volume Web sites, business-critical systems and commercial software. Enterprise data management is a proven strategy to manage growth in application and custom databases by reallocating data out of production systems into secondary, lower cost storage systems while maintaining seamless data access through the native application or BI layer.

With sql server archiving, organizations can create and deploy effective and consistent policies for managing, securing and storing data from a single console. 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 Management Suite’s modular and centralized architecture allows companies to securely manage their data management processes. This helps organizations to reduce high cost infrastructure in production systems. Jd edwards database solution, organizations can create and deploy effective and consistent policies for managing, securing and storing data from a single console. The result is improved application performance and availability through smaller production database sizes, shorter backup and recovery times, reduced labor costs to maintain the production system and lower storage costs.

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

Financial Data Management Solutions

Posted by davidstech on October 21, 2009

Ensure sensitive data remains protected against the largest security threat: internal resources. Financial services data management allows financial services companies to identify data that meets specific data security and retention requirements and automate how data is protected and managed throughout its entire lifecycle.

Retailers are taking measures to improve retail data security around consumer data, but more can be done.  When retailer IT data centers make copies of their production database systems, the copies contain the same customer sensitive information as the production environment.  Audit controls and data security policies need to be extended to the non-production systems to ensure customer data is safe at all stages of the application development 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 oracle data masking 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.

Manage test data is a strategy for organizations to manage their test and development processes to meet application development and testing requirements, streamline cloning processes and secure data so organizations are equipped to deliver the clones needed to meet upgrade and patch cycles and maintain data security.

Health data management solutions enable centralized management of data classification and security policies. At the core of the EDMS is the Enterprise Metadata Manager, which manages multiple applications and data types across all hardware platforms through a unified policy manager.

Organizations can create and deploy consistent policies for managing, securing and storing data from a single console with the help of application archiving. The result is improved application performance and availability through smaller production database sizes, shorter backup and recovery times, reduced labor costs to maintain the production system and lower storage costs.

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

Preserve the essential metadata for future executions

Posted by davidstech on October 16, 2009

With the JD Edwards database solution, organizations can create and deploy effective and consistent policies for managing, securing and storing data from a single console. The result is improved application performance and availability through smaller production database sizes, shorter backup and recovery times, reduced labor costs to maintain the production system and lower storage costs.

Application archiving allows companies to securely manage their archiving processes. There is no need for multiple installations of database tools or application metadata for each server environment. It helps organizations to Increase productivity among application and database users and reduce IT maintenance associated with large data sets.

Oracle archiving is the most widely deployed RDBMS system in the world supporting more than 300,000 installations. In addition to the growing number of implementations, current installed Oracle databases are experiencing incredible growth due to the amount of data enterprises are keeping online. Enterprise data management is a proven strategy to manage growth in custom and packaged applications running on Oracle databases by archiving data out of production infrastructure systems onto secondary, lower cost infrastructure while maintaining seamless data access through the native application or BI layer.

With health data management solutions organizations can create and deploy effective and consistent policies for managing, securing and storing data from a single console. The result is improved application performance and availability through smaller production database sizes, shorter backup and recovery times, reduced labor costs to maintain the production system and lower storage costs.

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.

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

Leverage your IT investments

Posted by davidstech on October 16, 2009

Peoplesoft archiving provides organizations to implement policy based schemes for automatically migrating out of Tier 1 production stores into lower cost Tier 2 storage, ensuring application performance, faster back-up and recovery and lower total cost of storage. Data Management Suite’s modular and centralized architecture allows companies to securely manage their data management processes. It helps organizations to increase productivity among application users and reduce high cost infrastructure in production systems.

Test data management allows companies to securely manage test data and development processes with a single tool. There is no need for multiple installations of database tools for each server environment. Test data management helps organizations to achieve faster cloning times through rapid application and database cloning processes. Data Auditor 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.

Organizations can mitigate the impact of data growth by running batch reports during downtime, purchasing faster hardware or utilizing the purge functionality. None of these techniques fully address the reality of database growth and the need for long term data retention. To maintain performance of archive mysql based applications while ensuring compliance, organizations must actively manage transactional data stores to optimize application performance.

By incorporating database archiving strategies with mission critical business, organizations are able to address and mitigate performance, storage and data management concerns. As one of the original ERPs, there are thousands of customer’s worldwide running baan database modules for manufacturing, financial, project estimating and management and distribution. Over time, the load from millions of transactions added daily to the system weighs heavily on application servers impacting performance and report response rates

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