Ads by TechWords

See your link here
Subscribe to our e-mail newsletters
For more info on a specific newsletter, click the title. Details will be displayed in a new window.
Computerworld Daily News (First Look and Wrap-Up)
Computerworld Blogs Newsletter
The Weekly Top 10
More E-Mail Newsletters 
 

Sidebar: Users Split on Wisdom of Logic in Database

December 12, 2005 12:00 PM ET

Computerworld - Although the deeply integrated .Net technologies in SQL Server 2005 will give Microsoft users new options for programming business logic into their databases, it's unclear to what degree that will inspire IT shops to modify their current development strategies.
The 35 IT managers polled by Computerworld were split about evenly on the topic. Some respondents insisted that logic has no business being in the database. Others said they plan to take advantage of the new capabilities.
"The more business logic that we can integrate directly into the database, the better," said David Buzzell, CIO at The Sedona Group, a staffing services and IT consulting firm in Moline, Ill. "This helps to ensure all data within the system is following established business logic. If the data isn't adhering to our business rules and isn't properly structured, then the data won't help us in the long run."
An IT manager at a major national retail chain said SQL Server 2005 will make it easier for internal developers to follow the IT department's strategic-directions document. That plan advocates moving business logic closer to the data in order to make it easier to provide standard and consistent ways to access information. "We have been attempting to get our development teams to think in this way for a while," he said.
Not everyone shares that view. For example, Rick Stuller, CIO at Hawaiian Electric Co. in Honolulu, said the power company makes only limited use of stored procedures in order to ensure database independence. Switching databases can be hard work for an IT shop that uses a database vendor's SQL extension to write stored procedures.
Scalability concerns are the main reason why First American Title Insurance Co. tries to keep business logic in the business services tier, according to Sue Binks, vice president of IT strategic product development at the Santa Ana, Calif.-based company. "We can always throw more servers into the pool to process the logic," Binks said.
Tyson Hartman, chief technology officer for the Americas region at Avanade Inc., a Seattle-based consultancy that is a joint venture between Accenture Ltd. and Microsoft, said it's easy to scale out application servers, whereas it can be challenging to do the same thing with database servers. "If you have a solution that requires significant scale, putting all the logic in the database has its limits," he said.
Sundial Software Corp. tries to maintain all of its business logic in the application layer, said Ethan Roberts, a software architect at the Madison, Wis.-based IT consulting firm. Butdatabase stored procedures built with .Net technologies could minimize network traffic for repetitive operations against a large number of data records, Roberts said. He noted that with the logic in a middle tier, the data would have to cross the network.



Additional Resources

Xerox
By using solid ink technology only from Xerox, you could save up to 65% by printing color for the cost of black and white. Enter for a chance to WIN a PhaserTM 8860 network color printer!
Microsoft
Save time and mitigate security risk. Deploy it now.
Sybase
In this white paper, IDC analyzes the role of next-generation mobile enterprise platforms as organizations seek a more strategic deployment of mobile solutions.

Learn the important issues you must consider before starting your next mobility initiative. Get your mobility white paper from IDC now, compliments of Sybase.

White Papers & Webcasts

Keep it Clean: Maintaining the Integrity of your CMDB through Change Detection
Learn how configuration drift can challenge configuration management database (CMDB) integrity and how a configuration audit tool and an effective change management process...  

Improving Quality of Service for Oracle Database with My Oracle Support
(Source: Oracle) Oracle's Willie Hardie and Oracle Support Expert Sean Bingham discuss how My Oracle Support optimizes the quality of support provided to...

Tapping the Full Potential of Sales and Marketing Data for Pharmaceuticals
As pharmaceutical manufacturers face an era of sharply reduced sales and marketing budgets, increasingly complex and restrictive regulations, and rapidly changing demand patterns...  

Usability Is Everything
Learn what sets Workday's HR and Payroll solutions apart from the competition....

Bloor Research: Netezza and the HP Oracle Database Machine
HP and Oracle have recently announced the HP Oracle Database Machine. This has been positioned by Oracle as a competitor to Netezza and...  

The Value of Real SaaS at Workday
Cost savings, speed to value, and innovation brought to the enterprise by Workday's software-as-a-service solutions for HR and Payroll....

Risk Readiness and Redundancy: PCI Compliance Automation
(Source: Symantec) This paper examines compliance regulations surrounding the Payment Card Industry Data Security Standards, the challenges it puts on IT Security and...  

SaaS at Flextronics, Inc.
Dave Smoley, CIO of Flextronics, discusses the real value of software-as-a-service and why he chose Workday for his HR solution....

How to Populate Your CMDB in Four Steps
Generally, CMDBs populated by discovery tools alone simply aren't usable. They fail because they contain massive amounts of irrelevant information. You avoid this...  

Why Compliance Pays
This OnDemand webcast explores the relationship that firms with best compliance records have higher revenue, greater customer retention, lower financial losses from data...

 

SAS Information Management Kit

SAS is the leader in business intelligence and analytical software and services. Only SAS offers leading data integration, storage, analytics and business intelligence applications within a comprehensive enterprise intelligence platform. SAS gives 97 of the top 100 companies in the 2007 Fortune 500 THE POWER TO KNOW®.

Webcast: The Information Management Roadmap
Imagine high-quality data, cleansed, analyzed and delivered throughout your organization. Join Computerworld, IT visionary Thornton May and a panel of experts to learn how SAS® can help you make it happen.

View this webcast 
Research Report: Information Management Initiatives at Midsize and Large Organizations
See the top-line results of this Computerworld sponsored survey to see how IT and business leaders are handling information management implementation.

Download this report 
White Paper: Information Management: Better Information for Winning Decisions.
This white paper explains how the SAS Information Evolution Model aids companies in assessing how they use this information to make strategic decisions and drive business.

Download this white paper