(Matthew Hart and Robert Freeman) RMAN actually works pretty well right out of the box, and you generally will find that it requires very little tuning. However, there are a number of other pieces that fit into the RMAN architectural puzzle. When all those pieces come together, you sometimes find th
Author: SSWUG Research
Getting Physical with Subtypes
(Steve Hoberman) Subtyping is a powerful communication tool on the logical data model because it allows the modeler to represent similarities that may exist between distinct business concepts to improve integration and data quality.
Using XML
(J. David Eisenberg) During my second lecture to an XML class at a local community college, I explained how XML lets you define your own markup language with custom tags and attributes. I had finished defining a simple markup language for use with a list of amateur sports clubs, and had displayed a
Content delivery system design mistakes
(Peter Zaitsev) This week I helped dealing with performance problems (part MySQL related and part related to LAMP in general of system which does quite a bit of content delivery, serving file downloads and images – something a lot of web sites need to do these days. There were quite a bit of mistake
Develop a Web application using Ajax with Dojo and DB2
(Leons Petrazickis) Follow this case study for quickly creating an elegant, responsive Web application using IBM DB2 9 for Linux, UNIX, and Windows, XQuery, PHP, and the Dojo Javascript Framework. The case study is based on IOD Planner 2006, a Web application that was used for the IBM Information On
PowerSMO At Work Part I: DBA Scripts and Functions
(Dan Sullivan) In my previous introduction to PowerSMO, I covered the most basic operations of PowerShell, PowerSMO, and WMI. This article will investigate some of the more powerful PowerShell features, in particular scripts and functions, and then use those with PowerSMO to manage the extended prop
Eliminating partition tables during export
(Maria Anderson) We are upgrading our database from Oracle 8i to 10g on a Windows platform. Our production database is in 8i and the upgrade method we are using is imp/exp. The production box contains a lot of partition tables. If we export we will get the “rollback segment too small” error. So we a
What .NET developers need to know about Daylight Saving Time changes
(Tony Patton) One of the most talked about topics in the industry right now is how the U.S. government’s changes to Daylight Saving Time (DST) will affect IT resources. Most of the attention is focused on operating systems, but application developers are raising a number of questions as well. Let’s
Building Workflow Applications with XML and XQuery
(Michael Kay) In my previous articles, I introduced some of the mechanics of coding with XQuery and XSLT 2.0 — in a rapid progression from novice to advanced level I started with a brief ten-minute introduction to XQuery, went on from there to explore FLWOR expressions in some depth, and then expose
MySQL spanning different timezones
(pabloj) So what, if you are planning a centralized MySQL server and many clients all around the world?