WebSphere Strategies: Make your database easy to read

[Search400.com]

Title: WebSphere Strategies

October 07, 2004 Published by  Search400.com    WebSphere Strategies Issue Sponsored By:   > Featured Resource: ExpertAnswerCenter.com IN THIS ISSUE:   >  Make your database easy to read   >  Can SQL Views be indexed?   >  Poor response time when running an SQL select statement   >  Seven steps to a Java Web database application   >  How to update iSeries databases using JDBC, SQL   >  Get answers to your questions fast   >  Accepting nominations now   >  User poll -- Vote now Make your database easy to read [Search400.com] by Jim Mason Let's take a quick look at making your database easier for users to read. By creating simple data marts and using SQL views, you can make your production data understandable for user reporting.   Featured Resource: ExpertAnswerCenter.com Visit the ExpertAnswerCenter.com and pose your most difficult questions to our experts. Topics change regularly, and answered questions are placed in an archive for easy access. Also, you can read the expert's blog, register for an upcoming webcast, or find helpful information in the site's Resource Center. Visit today!   Can SQL Views be indexed? [Search400.com] A user asks, "Traditionally, we can create a logical file that does not only select, but indexes. How can I do this in SQL?" Unfortunately, DB2 expert Kent Milligan say's it isn't possible. Find out what you can do instead. Poor response time when running an SQL select statement [Search400.com] A user was getting a significant variance in response time when running an SQL select statement over a view. What was going on? DB2 expert Kent Milligan offers some advice. Seven steps to a Java Web database application [Search400.com] It would be great if iSeries programmers knew how to use Java to create e-business applications, but programmers can still forge ahead if they aren't trained in Java yet. How to update iSeries databases using JDBC, SQL [Search400.com] Web development expert Jim Mason provides common JDBC examples to create, write, read and update data in normal iSeries data files using JDBC and SQL and how to efficiently update iSeries databases using JDBC. ITKNOWLEDGE EXCHANGE:  Get answers to your questions fast Now you can ask any one of your fellow TechTarget members -- 1.2 million strong -- specific questions on technology, best practices or other IT issues. Just tell us who you are and the subjects you're interested in (iSeries, RPG, DB2, WebSphere, etc.) and then ask your questions or offer advice to other IT professionals. Our ITKnowledge Exchange brings members from all 22 TechTarget Web sites together to share information and experiences. ISERIES PRODUCT OF THE YEAR AWARDS:  Accepting nominations now Have a great product or tool? In January, Search400.com will present its Second Annual Product of the Year awards. The awards will highlight and celebrate those entries in the market that are deemed outstanding examples of new and innovative technological advancement for users. Submit an application to have your product considered. But act fast: The deadline to submit nominations is Monday, Oct. 25. SURVEY:  User poll -- Vote now Now that the DOJ won't appeal the Oracle ruling, do you believe an Oracle takeover of PeopleSoft is imminent?   Contact Us Sales For sales inquiries, please contact us at: [EMAIL PROTECTED] Editorial For feedback about any of our articles or to send us your article ideas, please contact us at: [EMAIL PROTECTED]     Free E-Newsletters! Select e-newsletters you would like to receive via e-mail!  Search400: Administrator Tips  Search400: Programmer Tips  Search400: Today's News Not a Member? We?ll activate your membership with your subscription.   This e-newsletter is published by Search400.com, a targeted Web site from TechTarget, the most targeted IT media and events company. To unsubscribe from "WebSphere Strategies": Go to unsubscribe: http://search400.techtarget.com/unsubscribe?track=NL-182&ad=493352 Please note, unsubscribe requests may take up to 24 hours to process; you may receive additional mailings during that time. A confirmation e-mail will be sent when your request has been successfully processed. Contact Us: Search400 Member Services 117 Kendrick Street, Suite 800 Needham, MA 02494