(Andrew Novick) CRUD: A coating or an incrustation of filth or refuse. That’s the American Heritage dictionary definition but not the database definition. When you are working with databases, CRUD is an acronym for the four essential database operations: Create, Read, Update, and Delete.
Other News
On Using XML Well: Creating a Dynamic XML Menu
(Ben Forta) Not long ago, I started every presentation on XML explaining that it was not a new page markup language and that it did not in and of itself replace HTML. Fortunately, we’ve made some progress of late–developers now understand that XML is nothing more than a data sharing mechanism–simple
Working XML: UML, XMI, and code generation, Part 2
(Benoît Marchal) This column is currently focused on modeling, UML, and XML. More specifically, I am exploring the use of UML modeling for XML development and in particular how XSLT stylesheets can help through automatic derivation. As XML has become a common feature in development projects, many
SVG and Typography: Characters
(Fabio Arciniegas A.) In the second part of our discussion of SVG and typography we explore some time-honored practices of typographic excellence; as we go along, each “type issue” will lead to the discussion of relevant technical aspects of SVG. The typography issues covered are listed below. Besid
So You Want to Become an Oracle DBA? Part 2 – Learning Oracle on your own
(Steve Callan) This is the second of a two-part series about how you can become an Oracle DBA in today’s almost non-existent DBA job market. This article focuses on inexpensive and effective means of learning Oracle. The bad news: short of someone else paying for your education, you can expect t
Maintaining Transactional Replication
(Baya Pavliashvili) Contrary to popular belief, replication is not maintenance-free. As your application and business rules change, so do publications. This article dissects the terms and techniques necessary for maintaining transactional replication and gives you sage advice on fine-tuning your rep
Access heterogeneous data with DB2 Information Integrator: Part 2, Deploy EJBs to a portal environment
(Julien Muller and Martin Klumpp) This is the second tutorial in a series that shows you how to simplify your portal applications by accessing heterogeneous data through EJB components over SQL views. The first tutorial in this series showed you how to set up a database and integration layer, an
Inside SQL Server 2005 Security
(Kalen Delaney) Recently, I’ve been discussing security in SQL Server 2000. In my February column, “Crossing the Line: Ownership Chains” (InstantDoc ID 40963), I talked about the limitations of ownership chaining and the additional security concerns inherent in cross-database ownership chaining.
Oracle Certified Master, Part II
(Gerry Jurrens) The last OCP column (Oracle Magazine, March/April 2004) described the preparation and strategy for the Oracle Certified Master (OCM) practicum. This column provides descriptions of the types of content an OCM candidate is likely to encounter during the test. As mentioned in the l
The Third Way
(Sujit K. Mishra) Federation joins the list of integration options for providing access to heterogeneous data. Mergers and acquisitions are one common cause of information silos within companies. The acquirer’s information management systems usually can’t communicate with each other. So the merge