| Thread | Last Post | Replies |
|
| Date's updatable view rules | 31 Jul 2004 17:47 GMT | 15 |
What do people here think about Date's updatable view rules? http://www.dbdebunk.com/page/page/1270150.htm Marshall
|
| thinking about UPDATE | 29 Jul 2004 19:30 GMT | 47 |
I was thinking about the relationship between operations of the relational algebra and SQL statements. INSERT is a lot like union, but with an odd restriction that the intersection of the new set and the existing set must be empty. (Why?)
|
| Normalizing Every Thing with XDb2 | 29 Jul 2004 07:35 GMT | 27 |
> V Harris wrote: How do you store > Mr. Brown lives on Brown St., > drives a brown car, > has brown hair, |
| Representing Student Activity Score | 26 Jul 2004 16:07 GMT | 15 |
How can one begin to represent the following tuple so that a program could processing it more intelligently: T_StudentActivityScore Student Activity Score
|
| table types | 25 Jul 2004 22:36 GMT | 5 |
From the benchmarks I've seen over the years, it seems like the two most "generally fast" dbms are Oracle and MySQL, where "generally fast" doesn't really mean anything if you look closely but you all know what I mean anyway.
|
| In an RDBMS, what does "Data" mean? | 25 Jul 2004 05:32 GMT | 424 |
In relational theory, everyone seems to be talking about modelling "data", but I've never seen an explanation of what "data" is. As far as I can tell, C&D took this philosophical concept of "data", and then built their relational theory on top of it. That's okay. We have a
|
| What happened to comp.databases.object? | 20 Jul 2004 16:28 GMT | 1 |
I recently visited the comp.databases.object ng, and it has become a virtual ghost town. What happened? Such a contrast to the long-running, vibrant debates so common a year or two ago. I noticed Bob Badour stopped contributing in mid-March and then traffic,
|
| FOL/HOL: is there a middle ground? | 20 Jul 2004 16:25 GMT | 8 |
Lately we've been discussing 1NF and "a question for Mr. Celko." There are clear incompleteness problems associated with allowing the definition of set A to references the definition of set A. What are some of the other problems with using HOL as a basis for
|
| Hopelessly circular relationships | 19 Jul 2004 19:06 GMT | 8 |
I'm building a grade book program in MS-Access but I ran into a dilemma regarding circular relationships. * Courses have Activities. * Activities have SubActivities.
|
| Volume in SQL | 17 Jul 2004 07:47 GMT | 3 |
Given a set of 3D points what is the volume of their convex hull? http://www.math.niu.edu/~rusin/known-math/95/volume.poly gives basic idea how to calculate a volume if we know polyhedron triangulation.
|
| SQL challenge | 15 Jul 2004 22:34 GMT | 16 |
At the last SIGMOD conference I heard an anecdote about how Jim Gray had gained the respect of some of his colleagues by computing the convex hull of a set of three-dimensional points in a table with a single SQL query that used only basic SQL (SQL-89). To be a little more concrete,
|
| Microsoft "Research" | 15 Jul 2004 15:07 GMT | 3 |
What do you think about this? http://research.microsoft.com/Comega/ http://www.cl.cam.ac.uk/~gmb/Papers/vanilla-xml2003.html http://research.microsoft.com/users/schulte/Papers/UnifyingTablesObjectsAndDocum ents(DPCOOL2003).pdf
|
| Record (entity) versions... | 10 Jul 2004 08:02 GMT | 3 |
Database newbie question: My sample database (T-SQL syntax): CREATE DATABASE sample GO
|
| Navigation vs Relational operators | 02 Jul 2004 22:05 GMT | 26 |
In what way is "navigation" different from using relational operators ? -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= *** Usenet.com - The #1 Usenet Newsgroup Service on The Planet! ***
|
| database design question? best practise | 01 Jul 2004 15:07 GMT | 1 |
I've a database for a mulitlanguage news website with three tables: - Languages - NewsCategories - News
|