| Thread | Last Post | Replies |
|
| Overriding derived values | 30 Nov 2005 22:18 GMT | 10 |
A design problem in my organization similar to the following has arisen. (The example below is a bit contrived, as I would prefer not to discuss our exact situation). Say that, once a month, a bowling alley employee enters league players
|
| Database Design problem | 30 Nov 2005 11:21 GMT | 8 |
Could some kind person please help with a little Database Design problem I've come up against? I am in the process of designing a football online management system with which I intend to display results fixtures etc. My dilemma is I
|
| Fast SQL Question | 30 Nov 2005 07:59 GMT | 4 |
If I use like and I want to find all emails in hotmail that have at least one char before the '@' and after the '.' Is this the right command where EmailAddress like '%_@hotmail._%'
|
| Attribute name prefixes, domains, joins, ISO 11179 | 30 Nov 2005 02:31 GMT | 15 |
Some thoughts on attribute names. A common response to inexperienced database developers who post DDL or pseudo-DDL is that they have mixed up the physical model with the logical model, or the logical and conceptual model, because they have
|
| EER Diagram advice | 29 Nov 2005 23:21 GMT | 1 |
Can anyone tell me if I'm going in the right direction with this EER Diagram and point to any improvements I could make? Thanks in advance We have been given this problem to do:
|
| What is the difference between.... | 29 Nov 2005 23:06 GMT | 1 |
Just wondered, what is the difference between a cardinality ratio constraint and a structural constraint? Is, a cardinality ratio like 1-to-many, 1 to 1 etc.. and
|
| Derived column design question | 29 Nov 2005 22:32 GMT | 1 |
A design problem in my organization similar to the following has arisen. (The example below is a bit contrived, as I would prefer not to discuss our exact situation). Say that, once a month, a bowling alley employee enters league players
|
| Should Cache' be on the MV Family Tree? | 29 Nov 2005 02:43 GMT | 1 |
Jim or anyone else involved in PIck for Cache' -- will the Cache' product have functional DataBASIC or multivalue query languages any time soon? When will it make sense for this product to be included in the MV Family Tree? Is there a name for it separate from Cache'? Is
|
| RM and definition of relations/tuples | 28 Nov 2005 14:12 GMT | 26 |
I have a question to the Relational Model and the definition of relations and tuples. I learned the following definitions: A relation schema R is a set of Attributes R={A_1,A_2,...,A_n}
|
| Hierarchy as 'UP' constraint | 25 Nov 2005 13:05 GMT | 5 |
[[[Hierarchy as 'UP' constraint]]] Many articles (in c.d.t. and elsewhere) and even a book (Joe Celko's “Trees and hierarchies in SQL for smarties“) have been written about hierarchies and
|
| Where is the TRM at? | 24 Nov 2005 12:46 GMT | 6 |
With all this nullvel (sic) gazing I got to wondering where the "Trans Relational Model" is these days? Curiously it did seem much like the Sybase IQ product (on a superficial examination only) - accordingly does the "patent" have prior art problem
|
| Oracle licensing for dual core processors | 23 Nov 2005 17:52 GMT | 1 |
Is there a reason why we have to pay more for licensing for a different kind of processor? Why are we not charged for the Hyperthreading on some processors also. If Oracle is really conserned about the low end business market (small
|
| 'with check option' constraint | 23 Nov 2005 08:11 GMT | 8 |
Are you aware of any SQL DBMS in which "with check option" constraints can be deferred ?
|
| How can I proove associtivity of natural in relational algebra? | 22 Nov 2005 19:11 GMT | 8 |
Can someone give me a link for a full proof or something? Thanks
|
| Using the catalogue | 22 Nov 2005 18:19 GMT | 12 |
Suppose a RDBMS has a catalogue with schema Relations (Name) with key (Name) Fields (RelationName,FieldName,FieldType) with key (RelationName,FieldName)
|