Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- sort by:
- Relevance
- Date
- Popularity
- Comparing Oracle 10g column masking to relational views
- Thanks to the suggestion of TechRepublic member BrooklynPennyPincher, this Oracle tip compares two approaches to hiding column-level data on a report: the Virtual Private Database and relational views. In a previous tip, I described how a column's data could be masked hidden using Oracle 10g's Virtual Private Database...
- Technical articles 2007-04-02
Additional Resources
- Reasoning About the Updatability of XML Views Over Relational Databases
- XML has become an important medium for data exchange, and is also used as an interface to - i.e. a view of - a relational database. While previous work has considered XML views for the purpose of querying relational databases (e.g. Silkroute), in this paper the problem of updating a...
- White papers 2008-10-22
- Using XQuery to Build Updatable XML Views Over Relational Databases
- XML has become an important medium for data exchange, and is frequently used as an interface to - i.e. a view of - a relational database. Although much attention has been paid to the problem of querying relational databases through XML views, the problem of updating relational databases through XML...
- White papers 2008-10-18
- Relational databases: Defining relationships between database tables
- A hefty part of designing a relational database is dividing the data elements into related tables. Once you're ready to start working with the data, you rely on relationships between the tables to pull the data together in meaningful ways. For instance, order information is useless unless you know which...
- Technical articles 2003-04-30
- How a relational database solves and optimizes your query
- Some people view a relational database as a mystical oracle that answers questions posed to it by the programmer. However, there are a set of rules that a relational database uses to solve your query. Each relational database approaches the process of solving your query slightly differently; however, the fundamental...
- Technical articles 2004-03-05
- Turn XML into relational data with OPENXML
- XML support has been significantly extended for SQL Server 2005. In this article, Tim Chapman takes a look at how you can shred XML data into a relational format with SQL Server's OPENXML function. Starting with SQL Server 2000, Microsoft began to provide support for XML data. This...
- Technical articles 2006-11-28
- Multi-Relational Data Mining, Using UML for ILP
- Although there is a growing need for multi-relational data mining solutions in KDD, the use of obvious candidates from the field of Inductive Logic Programming ILP has been limited. In one's view this is mainly due to the variation in ILP engines, especially with respect to input specification, as well...
- White papers 2008-01-01
- Object orientated over relational
- What is the best way to build a crm application that needs to manipulate data that is stored in a relational database such as MS SQL? This application also needs to be capable of integrating with TAPI in order to be able to make dozens of outbound calls. I am...
- Q&A 2004-10-04
- Comparing Oracle 10g column masking to relational views
- I'm a VPD user, but not quite convinced...Frankly I've done a couple of VPD implementations because they were easy. I mean, it's really simple for database deployment, and painless (unnoticeable!) to app developers.But I'm not sure that you can't really do the same thing with views. After all,...
- Discussion threads 2007-04-04
- Snazzy ways to explain Access relational databases
- Check out this Forum question from TechRepublic reader, Donna, and see whether you can come up with good examples for explaining the relationship between tables in Access to beginning database students.You’re teaching Access for what seems like the hundredth time. All of a sudden, in the middle of explaining the...
- Technical articles 1999-11-02
- Application Development: What's new in ADO.NET version 2.0
- With the first, public alpha version of the coming release of Visual Studio .NET—christened "Whidbey"—now in the hands of developers, it's time to start thinking about your applications and how they might be affected as you move to this new version. Although the move from version 1.0 to 1.1 of...
- Technical articles 2004-03-04
- Clearing the confusion about XML databases
- When developers talk about XML databases, they usually mean two things: the database that stores the XML data and the DBMS that manipulates the XML database. Most major DBMS products allow you to integrate XML data into your application without changing your existing database. Let’s discuss the types of XML...
- Technical articles 2003-05-30
- PATAXO: A Framework to Allow Updates Through XML Views
- XML has become an important medium for data exchange, and is frequently used as an interface to - i.e. a view of - a relational database. Although a lot of work has been done on querying relational databases through XML views, the problem of updating relational databases through XML views...
- White papers 2006-09-01
- Foreign key definition renders primary key irrelevant
- Any discussion on primary keys is bound to stir up a debate. Some developers insist that a primary key’s only purpose is to uniquely identify records. Others believe that as a part of the relational model, its purpose includes relating records. However, it's difficult to stir up this same kind...
- Technical articles 2003-01-06
- Understanding XQuery and its potential
- While still an infant technology, XQuery could likely be the Holy Grail of query languages. Columnist Tim Landgrave explains the power behind XQuery in analyzing XML and non-XML data sources.Although most pundits agree that XML will become the standard for data storage and retrieval in the next decade, they can’t...
- Technical articles 2002-03-21
- Join Minimization in XML-to-SQL Translation: An Algebraic Approach
- Consider an XML view defined over a relational database, and a user query specified over this view. This user XML query is typically processed using the following steps: the translator maps the XML query to one or more SQL queries, the relational engine translates an SQL query to a relational...
- White papers 2008-01-01
- Use this architecture to structure your business intelligence solutions
- Business intelligence gives organizations a tactical advantage by transforming operational data into high-value information and putting it in the hands of the right people at the right time. Read on to learn about how BI solutions are commonly structured.Despite big spending on information systems, many organizations are finding there’s still...
- Technical articles 2001-03-05
- Decision Support: Choosing the best database management system for your client
- Choose the best database management systemAs an IT consultant, I realize the relationship between efficient database management and the success of my client’s business. An organization with poor database management can count on being just as successful as a business whose phone system works half of the time.At least a...
- Technical articles 2001-10-12
- Shred XML data with XQuery in SQL Server 2005
- Tim Chapman discusses new functionality in SQL Server 2005 that allows you to shred XML data into a relational format without the intensive memory operations. He also explains how using XQuery rather than OPENQUERY can lead to performance gains. Last week, I outlined how to shred XML data...
- Technical articles 2006-12-04
- Application integration: Create an ODBC connection to a Lotus Notes database
- On a recent project for a client, I was asked to create a database-driven site where one of the databases involved was a Lotus Notes database. Unlike other databases, such as Oracle and SQL Server, Notes doesn't have a relational database structure. This meant that I couldn't just create an...
- Technical articles 2003-12-22
- << Previous
- page 1 of 1
- Next >>
