Davidstech’s Weblog

…for intelligent information management

Archive for October, 2009

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 »

Manage test and development processes to meet application development and testing requirements

Posted by davidstech on October 8, 2009

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.

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. 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.

Information lifecycle management solutions are designed to help enterprises manage data growth by providing the tools to classify, archive and migrate data to improve application performance and reduce administrative overhead and infrastructure costs. Users of Oracle E-Business Suite, Baan, Oracle JD Edwards, Oracle PeopleSoft, Siebel and more are benefit a great deal by data archiving.

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

Data archiving for enterprise application

Posted by davidstech on October 8, 2009

Thousands of customers worldwide are running BaaN modules for manufacturing, financial, project estimating, management and distribution. Too much of load on databases over a span of time slows down the application performance. Also, database table size limitations make enterprise data management an important data management strategy for Baan customers. With the Enterprise data archiving solution for Baan, organizations can create and deploy effective and consistent policies for managing, securing and storing data from a single console.

Archiving in peoplesoft enables management solutions for performance, security and information access. This provides a complete solution for all data archiving needs. Database Archiving for PeopleSoft, 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. Database administrators who vouch for speed and usability will definitely benefit from this kind of solution. When profits and budgets are more often analyzed, application retirement is the best option to go for.

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

Multiple methods for securing data in an organization

Posted by davidstech on October 1, 2009

Database cloning creates a database template and restores or inserts only the transactions or modules needed. The Insert Method for database cloning allows IT organizations to create subsets much faster as only the data needed for the test is cloned, resulting in a faster cloning process and reduced storage requirement. Whichever subset method is used, referential integrity is maintained.

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.

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. Data archiving is an efficient solution to enhance application performance through smaller production database sizes, shorter backup and recovery times, reduced labor costs to maintain the production system and lower storage costs.

Every kind of storage is bound to overflow sometime or the other. It applies very much 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.

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.

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

Data management needs to meet the unique need of ILM and compliance

Posted by davidstech on October 1, 2009

Information lifecycle management (ILM) is a holistic approach to managing data in Enterprise Applications from creation and storage to its disposal. ILM goes beyond storage, by including facets of managing data at every stage of its lifecycle – creation, protection, migration, security, archiving and eventual disposal of data. It’s a comprehensive strategy for profit management, for risk reduction and for maximizing your enterprise-wide information assets.

MySQL technology has been saving time and money for the several large organizations by powering their high-volume websites, business-critical systems and commercial software. Enterprise data management is a proven solution 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.

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. Enterprise data management application provides companies with a centralized solution to manage the test data management process for clone creation, productivity and data security.

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.

Archiving in peoplesoft reduces IT maintenance otherwise associated with large data volumes. It also maintains seamless data access to archive data through native PeopleSoft Application interfaces.

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