Earthweb
Images Events Jobs Premium Services Media Kit Network Map E-mail Offers Vendor Solutions Webcasts
 SUBJECTS:
 FEATURES:
IT Management Webcasts:
The Role of Security in IT Service Management

Preparing for an IT Audit

More Webcasts


Search EarthWeb Network

internet.commerce
Be a Commerce Partner
Web Hosting Directory
Best Price
Logo Design
Memory Upgrades
Prepaid Phone Card
Rackmount LCD Monitor
Online Universities
Domain registration
Dental Insurance
Holiday Gift Ideas
Imprinted Gifts
Televisions
Promotional Products
Auto Insurance Quote

Linked Data Planet Conference & Expo

IT Management : Data Mining & Business Intelligence: Cleaning up Databases to Save Time... and Money

Install What You Need with Windows Server 2008
Windows Server 2008 is Microsoft's most full-featured server operating system yet, so it's ironic that one of its most exciting new features is an install option that cuts out most of the other features. Paul Rubens explores why a Server Core installation makes a great deal of sense in many instances. »

 
Identify Hardware and Software That Meet Microsoft Standards
The "Certified for Windows. Server 2008" logo identifies hardware and software solutions that meet Microsoft standards for compatibility and best practices with the Windows Server 2008 operating system. »

 
Windows Server Catalog: Certified Hardware Devices
Search the Windows Server 2008 catalog to find solutions to deploy with confidence. »

 
Windows Server Catalog: Certfied Servers
Search the Windows Server 2008 catalog to find servers you can deploy with confidence. »

 
Download the Windows Server 2008 Trial
With Windows Server 2008 you can develop, deliver, and manage rich user experiences and applications, provide a secure network infrastructure, and increase technological efficiency and value within your organization. »

- ITSMWatch Newsletter -
Tech Focus: Security

Cybersecurity: Laws Only Go So Far

Mozilla Firefox vs. Internet Explorer: Which is Safer?

Is Your Blog Leaking Trade Secrets?

The Las Vegas Counterfeiting Story: Is Your Privacy Worth More Than a Poker Chip?

Stopping Spammers at The Point of Sale

Product Watch
IOGEAR KVM - Includes Audio/Peripheral Sharing
Coverity Prevent / Coverity Thread Analyzer - Analyze Source Code For Defects, Security Vulnerabilities
USSD Series - SDRAM-Based Solid State Drives to 256 GB
UltraSMS - Send SMS From Your PC
Sentinel Sensors - Wi-Fi Based Temperature Monitoring Especially For Cold Storage

more products >>

Datamation Definitions
data mining
ERP
extranet
grid computing
intranet
network appliance
outsourcing
storage
VPN
virus
FREE Tech Newsletters

Video: Sustainable IT--Good for Business. Learn more about trends in sustainable IT and how Sun is committed to building energy-efficient products that are smarter and more environmentally responsible.

Cleaning up Databases to Save Time... and Money
April 29, 2005
By Kate Stoodley

Before a global consulting firm integrated new software into its 5-terabyte database, the company's IT staff spent so much time cleaning up their information that bigger projects had to take a back seat.

IT workers at Hewitt Associates, a human resources consulting and outsourcing company based in Lincolnshire, Il., had gotten used to spending many tedious hours searching through their IBM Lotus Domino servers and racking through confusing Domino logs to determine which applications weren't being used, costing the company lots of hard drive space and money.

To solve this problem they recently started using DYS Analytics' Control Usage Investigator (CUI) software.

Now, Hewitt's IT staff can work on other projects while the CUI program cleans up their servers, says Scott Pitts, manager of Hewitt's Knowledge Management Infrastructure Group.

''(CUI) is saving us money,'' says Pitts. ''We don't need people to baby-sit the servers anymore.''

The CUI program is DYS' answer to an IT need to make messaging and collaboration applications run more efficiently, says Drew Wolff, vice president of products at DYS. He says CUI software monitors and analyzes application usage, and traffic and performance levels throughout entire networks, allowing organizations to determine which applications were being used and which ones were simply wasting time and money.

Prior to adopting the CUI software, Pitts says his IT staff had to look through Domino logs to figure out which applications and user ID's were no longer needed. This process was time consuming and expensive, he adds.

''It was too much to check through by hand,'' says Pitts. ''The Domino logs were hard to understand. We were not doing it efficiently.''

Matt Cain, a Domino analyst at META Group, Inc., a Stamford, Conn.-based analyst and research firm, says the CUI software solves a business problem created by the excessive amounts of unused Lotus Notes applications running on Domino systems.

''A tech-savvy business person can write his own Domino applications easily, which ends up with lots of applications going unused,'' says Cain. ''Some companies have thousands of Lotus applications with 20 to 30 percent not being used, just taking up space. This creates a liability on the system.''

CUI spots these unused applications and cleans up systems, Cain explains. And Pitt adds that by eliminating such idle applications, the IT staff at Hewitt was able to free up a lot of hard disc space.

''We aren't spending money on adding new disc space to the servers because of databases that aren't being used,'' says Pitt.

The CUI software also allows Hewitt IT staff to work on other important projects, instead of manually searching through the servers for these unnecessary applications.

''We used to have to do about 20 percent of this work by hand,'' says Pitts. ''If there were less than five people using a database, it was hard to tell that when reading a log.''

DYS' CUI is designed to solve such problems.

The Wellesley, Mass.-based provider of application performance software released the CUI product as part of its CONTROL! family of application performance management solutions for collaboration environments this past January. While DYS currently offers solutions for Microsoft Exchange, IBM Lotus Domino, IBM Instant Messaging and Web Conferencing (formerly Sametime), and IBM Team Workplace, the CUI is used solely with IBM Lotus Domino.

''CUI provides analysis reports of what's happening with the collaboration of an application so IT can 'efficientize' this (process), reduce the cost of ownership and increase the quality of service,'' says Wolff.

He also notes that beside its database-clean-up capabilities, CUI also picks out which user profiles are not needed. Employees frequently come and go in organizations for a variety of reasons. CUI determines when an employee has left the company, or is on a leave of absence.

''Instead of having to go out and buy new user licences from platform vendors, IT can recycle or retire the ID for the next employee,'' says Wolff. ''This also saves on maintenance fees.''

Wolff also says CUI's Application Rationalization abilities are aimed at organizations with remote offices. The software determines which applications should be placed on the remote offices' networks, as well as where it's not efficient to install them.

Pitts says Hewitt has about 87 worldwide remote offices, and about 300 global Domino servers, with more than 20,000 desktops accessing Domino applications. He says these networks are much easier to monitor with the CUI software.

''We get monthly reports which help us keep track of what is being replicated... and what replicated data is really needed,'' says Pitts. ''CUI goes through and cleans up everything for us.''

Wolff adds the CUI software has a ''work flow process'' designed to assure that databases aren't deleted before they need to be. A company may only need an application at the end of the year, or a user ID may simply be unused while the employee is out on a leave-of-absence. CUI is designed to detect these special situations.

''As the company grows, people put stuff on the databases and it grows,'' says Pitts. ''Usually if you need to add (an application), you can delete one too.''

CUI has security benefits, as well. The software looks at who is using which database and which users are trying to gain access to certain information, as well as who shouldn't be accessing a database, Wolff says.

Tools:
Add itmanagement.earthweb.com to your favorites
Add itmanagement.earthweb.com to your browser search box
IE 7 | Firefox 2.0 | Firefox 1.5.x
Receive news via our XML/RSS feed

Data Mining & Business Intelligence Archives



JupiterOnlineMedia

internet.comearthweb.comDevx.commediabistro.comGraphics.com

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info


Legal Notices, Licensing, Reprints, & Permissions, Privacy Policy.

Advertise | Newsletters | Tech Jobs | Shopping | E-mail Offers

Solutions
Whitepapers and eBooks
Microsoft Article: HyperV-The Killer Feature in WinServer ‘08
Avaya Article: How to Feed Data into the Avaya Event Processor
Microsoft Article: Install What You Need with Win Server ‘08
HP eBook: Putting the Green into IT
Whitepaper: HP Integrated Citrix XenServer for HP ProLiant Servers
Intel Go Parallel Portal: Interview with C++ Guru Herb Sutter, Part 1
Intel Go Parallel Portal: Interview with C++ Guru Herb Sutter, Part 2--The Future of Concurrency
Avaya Article: Setting Up a SIP A/S Development Environment
IBM Article: How Cool Is Your Data Center?
Microsoft Article: Managing Virtual Machines with Microsoft System Center
HP eBook: Storage Networking , Part 1
Microsoft Article: Solving Data Center Complexity with Microsoft System Center Configuration Manager 2007
MORE WHITEPAPERS, EBOOKS, AND ARTICLES
Webcasts
Intel Video: Are Multi-core Processors Here to Stay?
On-Demand Webcast: Five Virtualization Trends to Watch
HP Video: Page Cost Calculator
Intel Video: APIs for Parallel Programming
HP Webcast: Storage Is Changing Fast - Be Ready or Be Left Behind
Microsoft Silverlight Video: Creating Fading Controls with Expression Design and Expression Blend 2
MORE WEBCASTS, PODCASTS, AND VIDEOS
Downloads and eKits
Sun Download: Solaris 8 Migration Assistant
Sybase Download: SQL Anywhere Developer Edition
Red Gate Download: SQL Backup Pro and free DBA Best Practices eBook
Red Gate Download: SQL Compare Pro 6
Iron Speed Designer Application Generator
MORE DOWNLOADS, EKITS, AND FREE TRIALS
Tutorials and Demos
How-to-Article: Preparing for Hyper-Threading Technology and Dual Core Technology
eTouch PDF: Conquering the Tyranny of E-Mail and Word Processors
IBM Article: Collaborating in the High-Performance Workplace
HP Demo: StorageWorks EVA4400
Intel Featured Algorhythm: Intel Threading Building Blocks--The Pipeline Class
Microsoft How-to Article: Get Going with Silverlight and Windows Live
MORE TUTORIALS, DEMOS AND STEP-BY-STEP GUIDES