dbTalk Databases Forums  

Sponsored Links


comp.databases.theory comp.databases.theory


Discuss in the comp.databases.theory forum.



Post New Thread
Threads in Forum : comp.databases.theory Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
I am developing a database design course for young PHP programmers. Here is why: CREATE TABLE tblShoes( charSKU as Char(10) //first 3 characters...
Evan Keel
10-03-2007 08:19 PM
JOG Go to last post
4 138
Hi, I'm wondering whether it's possible to query time based inventory status/quantity. basically there are buying in (quantity increased), selling...
john_woo@canada.com
10-03-2007 03:33 PM
Tonkuma Go to last post
3 147
It depends... I don't know of any "good" methods using ANSI SQL, but there are methods that can be used depending on what type of SQL you are...
Jason Lepack
09-20-2007 07:49 PM
DBMS_Plumber Go to last post
5 188
(also posted in sql group but got no replies, apolgies if that's bad etiquette) Hi, Google released a corpus of n-grams collected from the...
bobterwillinger@gmail.com
09-16-2007 01:45 AM
Bob Stearns Go to last post
5 201
On Aug 22, 5:07 am, paul c <toledobythe... (AT) oohay (DOT) ac> wrote: This may be a useful link. It is the killfile I use for google...
Rob
09-12-2007 03:55 PM
Beowulf Go to last post
8 189
"paul c" <toledobythesea (AT) oohay (DOT) ac> wrote That's only if you are adding digitally!
Evan Keel
09-11-2007 10:04 PM
cleveridea Go to last post
13 272
Hi all, I want to protect the result of a query. That means every database update which change the result of the quer must be discovered. For...
agileball@gmail.com
09-11-2007 01:43 PM
Ed Prochak Go to last post
1 103
Hey, I have to design following system and am quite stuck on what the best way would be to solve the problem: There are several of the same...
Nikolai Onken
09-11-2007 01:38 PM
Ed Prochak Go to last post
1 103
On Sep 8, 2:22 am, paul c <toledobythe... (AT) oohay (DOT) ac> wrote: believe that neither transitive closure nor unordered set nature could be...
Cimode
09-10-2007 05:08 AM
Cimode Go to last post
1 166
"David Portas" <REMOVE_BEFORE_REPLYING_dportas (AT) acm (DOT) org> wrote I'm not entirely comfortable with it myself, and I had found some of...
David Cressey
09-07-2007 05:40 PM
David Cressey Go to last post
8 135
I couldn't read the article (site was down) which is supposed to claim that RDBMSs "should be considered legacy technology."; I don't see how the...
mAsterdam
09-07-2007 04:14 PM
David Portas Go to last post
2 170
paul c wrote: It's much better if they justify their existence catching the occasional embezzler or lost receipt than meeting with the C-levels to...
sinister
09-01-2007 02:02 PM
Keith H Duggar Go to last post
189 1,517
On Aug 28, 5:27 pm, paul c <toledobythe... (AT) oohay (DOT) ac> wrote: And I guess that's why colour-blind people don't become bike mechanics ;)
JOG
09-01-2007 08:17 AM
David Cressey Go to last post
91 831
What normal form is violated here? What could fix the problem? A telephone call is uniquely identified by telephone number and time of call. These...
landonkelsey
08-30-2007 01:29 PM
landonkelsey via DBMonster.com Go to last post
28 356
Below dbd script models above and queries for B's biological siblings. (new 'male 'gender) (new 'female 'gender) (new 'arnold 'person) (set arnold...
woger151@jqpx37.cotse.net
08-23-2007 06:33 PM
-CELKO- Go to last post
8 114
Hello I realize that the following questions might seem totally irrelevant to most of you, but I'm still hoping someone will take the time to answer...
beginner16
08-23-2007 02:36 AM
Mudit Go to last post
3 131
paul c <toledobythesea (AT) oohay (DOT) ac> wrote: Bah! It is not that easy. The mystics et al would have just found another way of expressing...
beginner16
08-17-2007 12:33 PM
Gene Wirchenko Go to last post
13 244
hello I would really need some help with the following questions. And apologies for so many of them 1) a) In hierarchical model parent class can...
beginner16
08-16-2007 07:53 PM
Jan Hidders Go to last post
6 153
"Nis Jørgensen" <nis (AT) superlativ (DOT) dk> wrote Are they?
Cimode
08-15-2007 11:45 PM
Brian Selzer Go to last post
156 1,321
Hi, I am working on a project that intends to investigate the implementation of a modern heuristic (e.g. simulated annealing, genetic algorithms or...
Shah
08-13-2007 08:22 AM
Cimode Go to last post
2 116
On Aug 10, 8:58 am, paul c <toledobythe... (AT) oohay (DOT) ac> wrote: Sure. One more point in case it's not obvious, there's a subtle difference...
sinister
08-12-2007 12:02 AM
Christopher Browne Go to last post
10 169
hello I would really need some help here Some time ago I made a thread about cardinality and thought I understood it , but today I noticed that I...
beginner16
08-09-2007 05:55 PM
Hugo Kornelis Go to last post
6 90
paul c wrote: I always did like a good exploding BOM.
paul c
08-08-2007 11:33 PM
Brian Selzer Go to last post
20 327
hello, can someone tell me (or point me in the right direction) of what the right way of finding duplicates in dirty data (caused by typo's) ? is...
tom
08-06-2007 07:08 PM
Marshall Go to last post
3 145
hello When we execute SELECT statement, the following steps are taken: 1) temporary table ( call it T ) is created 2) the number of rows T has...
beginner16
08-02-2007 12:54 PM
-CELKO- Go to last post
3 166
On Sun, 29 Jul 2007 07:36:57 -0700, -CELKO- <jcelko212 (AT) earthlink (DOT) net> wrote: (snip) Thanks guys for the pointers.
Gilles Ganault
07-30-2007 12:05 AM
Gilles Ganault Go to last post
2 107
Have not found an active data mining forum yet so asking here. I'm new to data mining but since I have the most theoretical comp. sci. background at...
max
07-29-2007 05:44 AM
Jan Hidders Go to last post
3 95
On Jul 23, 7:43 am, Nis Jørgensen <n... (AT) superlativ (DOT) dk> wrote: LOL Skimmed over it. It doesn't support joins. You can only query...
Zorro
07-27-2007 12:15 PM
Zorro Go to last post
17 208
I miss Fabian Pascal's criticism of the database industry, and contributions to clear thinking on the relational model, as dbdebunk.com has been...
Paul Mansour
07-27-2007 02:06 AM
Frank Hamersley Go to last post
24 297
hello 1) The following quote ( well I shortened it a bit ) is from a chapter briefly describing MARTIN E-R notation "Say we have entities ORDER...
beginner16
07-26-2007 11:07 PM
Bob Badour Go to last post
33 428
Hi, We are currently in the process of attempting to come up with a solution to redesign our database. I am not going to use real examples, but I...
paulwragg2323@hotmail.com
07-26-2007 02:40 AM
Martin T. Go to last post
4 126
hello 1) Before I ask the question I must point out that I understand the difference between logical and conceptual level. Thus, conceptual model...
beginner16
07-25-2007 02:02 PM
paul c Go to last post
12 211
No big reason for wondering about this, the uses may seem obscure but also seem interesting to me, David C and his notation thread has sent me off on...
paul c
07-24-2007 03:32 PM
paul c Go to last post
26 312
Using the notation for <NOT> (A <AND> B <AND> C), etc. The following ] means "A implies B" for Boolean algebra. What is the corresponding...
David Cressey
07-24-2007 09:52 AM
Cimode Go to last post
36 429
hello I just started learning about databases and already I'm totally lost 1) When you use,for example, SQL statements to create tables...
kaja_love160@yahoo.com
07-22-2007 06:30 PM
paul c Go to last post
10 216
I am looking for solution (technique) that will allow me, while using traditional B+ tree, to obtain key from value without creating "reversed"...
Dimitry
07-22-2007 05:18 PM
Jonathan Leffler Go to last post
3 105
D&D algebra defines the OR operator as R(x,y) <OR> S(y,z) = {(x,y,z) | (x,y) in R & z in Z} union {(x,y,z) | (y,z) in S & x in X} since application...
Vadim Tropashko
07-20-2007 10:18 PM
Vadim Tropashko Go to last post
1 121
hello 1) I still don't understand whether term data model (or data model instance) refers to mechanism ( implemented as software ) that defines what...
kaja_love160@yahoo.com
07-19-2007 04:08 PM
David Portas Go to last post
1 78
Which relational operation perform faster in general, JOINs or SELECT subqueries? Suppose we have these tables: create table departments ( dept_id...
perryv@gmail.com
07-19-2007 12:47 PM
David Cressey Go to last post
1 91
I'm having trouble with a query concept. I know that: select max(order_date) from orders; will return the date of the newest order, and...
Mia
07-19-2007 12:43 PM
TroyK Go to last post
16 155
tables: 1. publication(pubid, title) 2. book(pubid, date) 3. journal(pubid, date) purpose: find all publication titles for books or...
Mike
07-11-2007 01:25 PM
David Cressey Go to last post
6 91
tables: 1. publication(pubid, title) 2. book(pubid, date) 3. journal(pubid, date) purpose: find all publication titles for books or...
Mike
07-10-2007 04:18 PM
Bob Badour Go to last post
19 147
Hi all! I'm looking into designing an in-memory DB. Before I start, there are several things I must have figured out. Among those things is...
Sune
07-10-2007 02:28 PM
DBMS_Plumber Go to last post
7 97
Hi all, I'm curious as to what happened to Dali/Datablitz. If I look for it on the net I don't find what I expect, such as manuals, product pages...
Sune
07-10-2007 01:58 PM
DBMS_Plumber Go to last post
4 162
In Boolean algebra, you could, if you wanted to, express everything by just using brackets, as follows: means NOT (A AND B) This notation can be...
David Cressey
07-10-2007 11:13 AM
Jan Hidders Go to last post
38 375
Hello, I'm considering a career switch to a more database-related job, but need help on a few questions and issues. I'm a Computer...
dreamznatcher
07-04-2007 08:28 PM
Neil Go to last post
159 1,274
hi list, i know about the basic distiction of data modelling as i heard it in my db couse: * semantic model --> ERM * logical model ...
Senges
07-03-2007 11:39 AM
Jan Hidders Go to last post
6 139
Hi, I'm looking into designing an in-memory DB and I wonder: How to flush data most efficiently when I checkpoint? Say I have a page size of 8K...
Sune
07-01-2007 01:18 PM
Anne & Lynn Wheeler Go to last post
4 127
Hello Vadim, Marshall and others, The discussion seems to warrant it's own thread, so here goes. There seems to be some disagreement on what...
Jan Hidders
06-30-2007 06:34 AM
Jan Hidders Go to last post
65 536
Hi, Lately, I came to put a version of Microsoft Vista on my desktop. As I am accustomed to with Microsoft OS's, I am bracing for the impact of how...
Cimode
06-28-2007 04:13 PM
Anne & Lynn Wheeler Go to last post
14 187
Post New Thread

Display Options
Showing threads 351 to 400 of 1742
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.