;) |
|
|
In this Issue |
|
|
|
From the Editor: |
|
by Tim DiChiara, Site Editor
This week, I'd like to highlight an 11-page white paper that Bill Inmon, "the father of data warehousing," recently wrote for SearchDatabase.com. It's called "Analytics: Ten critical success factors" and it's available only to our members, free of charge. Click here to download it.
The article begins with a brief history of data warehousing and analytics--"the direct payoff of the data warehouse"--then delves into the factors that are essential to implement a successful analytics environment. For example, in the #2 factor, Bill describes the very predictable infrastructure required by analytics: above all, it needs integrated, complete, historical, and easily accessible data. In #3, he highlights the important point that analytics needs to be developed in an iterative manner, with lots of user feedback between development phases.
Bill Inmon has almost 30 years of experience in database technology management and data warehouse design. He has written 39 books and over 500 articles in every major trade journal and is known globally for his seminars on developing data warehouses. He also consults with a large number of Fortune 1000 clients, offering data warehouse design and database management services. This white paper is a solid, high-level overview of an increasingly essential part of modern information technology. With analytics systems costing hundreds of thousands of dollars, ignore these success factors at your own peril!
Have a good week, Tim
|
|
|
Featured Topic: |
|
500 free tips and scripts
by Tim DiChiara, Site Editor
Looking for that perfect script that will make your life as a DBA or database developer just a tad easier? Well, you've come to the right place. We now offer over 500 Oracle, DB2, SQL Server, and SQL tips, free for the taking. Enjoy!
Read more about this topic
|
|
|
Expert Technical Advice: |
|
Featured Expert Jason Law,
Senior Database Architect, PowerQuest Corp.
Category: SQL
Jason is an Oracle Certified Professional and a seasoned Systems Architect with more than twelve years experience in information technology. He has experience in data design, web applications, data warehousing, system integration, and project management. Ask him your tough SQL questions!
View all Jason's answers
|
|
This Week: In the forums
|
| >> |
DB2 UDB load pending tablespace status
Member "JJ" added a new disk controller and new drives, but now data on two devices is missing and the associated tablespaces (one for data and the other for related indexes) is in load pending. What to do? Go to our "DBA Water Cooler" forum if you can offer any advice.
|
| >> |
DECODE instead of UNION
Member "mhamilton" has a view using a UNION between the SELECTS. He thinks he can do better with a DECODE function, but is not getting the same results. Go to our "Data warehousing and data analysis" forum if you can help "mhamilton" figure out the problem. |
| Tip of the Week: |
| Have you been wondering how you might use Java stored procedures instead of Oracle's native PL/SQL stored procedures? This article discusses the pros and cons of Java stored procedures, guidelines on how to build them, database vs. app server Java, performance considerations, troubleshooting, and rollout/security aspects. The final section of this paper includes a Java stored procedure example that allows you to send AOL instant messages from the database. |
| >> |
Using Java stored procedures: AOL instant messaging from Oracle |
|
|
Site Highlights |
|
|
|
| Free conference |
| What will you do with all that data as it continues to grow? Learn about the emerging technologies that will be useful -- attend the free Storage Decisions conference. |
|
Click here
|
|
| DW & BI Education |
| TDWI World Conference, Orlando, 11/3-11/8. Features more than 40 courses, peer networking and a two-day Business Intelligence Strategies Program. |
|
Register Today
|
|
| IT Salary Survey |
| Do you think you're being paid what you're worth? Take the new SearchDatabase.com Salary Survey today to find out how your salary and job satisfaction stack up. |
|
Take the survey
|
|
|
|
