Friday, March 7 -- Quarterly Meeting

Here is where we post UNYOUG events. The latest three entries show up on the right side of the main page for registration.
Post Reply
sam
Site Admin
Posts: 499
Joined: Mon Apr 09, 2007 11:56 am
Location: Rochester, NY

Friday, March 7 -- Quarterly Meeting

Post by sam »

Friday, March 7, 2008
Monroe Community College - Brighton Campus
R. Thomas Flynn Campus Center
Empire Room 3-209

Click here for area map.

Parking: Free passes will be emailed to you if you pre-register. Otherwise you will get one when you register onsite.  Please park in Lot M.

Presentations:

Controlling The Growth of Your Database Through Database Archiving
    Princeton Softech (IBM)
Managing Test Data Effectively, While Ensuring Data Privacy in the Testing Environment
    Princeton Softech (IBM)
What's New With Oracle 11G Utilities
    NEON Enterprise Software, Inc.
Oracle Archiving - Best Practices
    NEON Enterprise Software, Inc.

Agenda:

  8:30   -   9:00   Registration and Networking, Continental Breakfast

  9:00   -   9:15   Member introductions, Q&A

  9:15   -  10:15   Controlling Database Growth

10:15   -  10:30   Break

10:30   -  11:30   Managing Test Data

11:30   -  12:30   Lunch

12:30   -    1:00   UNYOUG Business

  1:00   -    2:00   What's New With Oracle 11G Utilities

  2:00   -    2:15   Break

  2:15   -    3:15   Oracle Archiving - Best Practices

  3:15   -    3:30   Raffles, wrap-up

Registration:

A continental breakfast and lunch will be provided. We will need a count of persons planning to attend to properly plan for these. If you are planning to attend, please register here.

Membership & Fees:

The event fee for non-members is $10.00 ($5.00 for students).
Last edited by sam on Wed Feb 27, 2008 4:06 pm, edited 4 times in total.
sam
Site Admin
Posts: 499
Joined: Mon Apr 09, 2007 11:56 am
Location: Rochester, NY

Controlling Database Growth

Post by sam »

Controlling The Growth of Your Database Through Database Archiving
Princeton Softech (IBM)

Information is the most valuable asset in business today.  Information is required for all revenue generating transactions.  As businesses expand, the number of data transactions subsequently grows as well.   A best practice for controlling this data growth is to implement database archiving, a key component of enterprise data management.  Database archiving enables you to archive and remove historical, inactive data from the production database, and save that data to more cost-effective and appropriate storage media. This reduces the amount of data on your Tier 1 production environment, improving performance immediately as well as reducing the cost of purchasing additional expensive storage.  Database archiving maintains the “business and technical context” of the archived data, so that the company can easily research and retrieve the required for responding to a customer inquiry or audit request.  Further, disaster recovery as well as upgrades and migrations can all be performed quicker and more efficiently.
sam
Site Admin
Posts: 499
Joined: Mon Apr 09, 2007 11:56 am
Location: Rochester, NY

Managing Test Data Effectively

Post by sam »

Managing Test Data Effectively, While Ensuring Data Privacy in the Testing Environment
Princeton Softech (IBM)

Reliable applications come from reliable testing – and realistic test data plays a key role. Many organizations clone or copy production environments to create test data – a time consuming and expensive approach. Subsetting data enables you to extract the business objects or transactions you need to create targeted test scenarios. You can extract data from a single database or across multiple related databases and platforms. After migrating data into the target environment, you can view multiple related tables in a single display. Then you can easily edit your test data to force error and boundary conditions needed to verify exception handling. Reusable processing definitions help you speed iterative testing tasks and ensure complete coverage.

Finally, learn how to sufficiently validate results.   You can compare results from a single database table or across sets of multiple related tables. Make it easy to identify and resolve application problems cost-effectively – before they impact your customers.

Gartner suggests that 70 percent of data breaches are internal to corporations.  Many organizations today focus only on implementing strategies to protect data in the production environment, while leaving the testing environment vulnerable.   In this session, learn about appropriate strategies for removing, masking and transforming data that can be used to identify individuals in your testing environment.  Understand how you can create contextually accurate but fictionalized data to produce accurate test results and support compliance with local, state, national, international and industry-based privacy regulations.
sam
Site Admin
Posts: 499
Joined: Mon Apr 09, 2007 11:56 am
Location: Rochester, NY

Oracle Performance - Making Sense of All the New Tools

Post by sam »

What's New With Oracle 11G Utilities
Bill Baker, NEON Enterprise Software

Explore the new features in Oracle's 11g utilities. Not only will you learn "what's new" but attendees will learn how to use these new features to solve real world problems.

Agenda:
- Data Pump
- SecureFiles
- Database Workloads
- ADR
- DBMS_COMPARISON
Last edited by sam on Wed Feb 27, 2008 4:03 pm, edited 1 time in total.
sam
Site Admin
Posts: 499
Joined: Mon Apr 09, 2007 11:56 am
Location: Rochester, NY

Oracle Archiving - Best Practices

Post by sam »

Oracle Archiving - Best Practices
Bill Baker, NEON Enterprise Software

Data volumes are growing ... Space is at a premium... Backups take forever ... Query response is dragging... Unused data can be moved out of the active database ...

The subject of data archiving is never addressed until the data retention problem is serious. Requirements for archiving range from legal obligations for data retention (Sarbanes Oxley, HIPAA, and so on), to operational performance, to internal business requirements. What data should you archive? How often? How should you do it? And what needs to be done inside of Oracle to regain operational efficiency?  Whatever needs are driving your business archive initiatives, join Bill Baker to determine archiving best practices. This informative session will describe how you can meet your Oracle database archiving requirements while simultaneously optimizing database performance.
Post Reply