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 07:19 PM
JOG Go to last post
4 146
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 02:33 PM
Tonkuma Go to last post
3 155
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 06:49 PM
DBMS_Plumber Go to last post
5 200
(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 12:45 AM
Bob Stearns Go to last post
5 205
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 02:55 PM
Beowulf Go to last post
8 192
"paul c" <toledobythesea (AT) oohay (DOT) ac> wrote That's only if you are adding digitally!
Evan Keel
09-11-2007 09:04 PM
cleveridea Go to last post
13 275
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 12: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 12: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 04: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 04:40 PM
David Cressey Go to last post
8 136
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 03:14 PM
David Portas Go to last post
2 172
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 01:02 PM
Keith H Duggar Go to last post
189 1,538
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 07:17 AM
David Cressey Go to last post
91 837
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 12:29 PM
landonkelsey via DBMonster.com Go to last post
28 358
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 05: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 01:36 AM
Mudit Go to last post
3 132
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 11:33 AM
Gene Wirchenko Go to last post
13 247
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 06:53 PM
Jan Hidders Go to last post
6 154
"Nis Jørgensen" <nis (AT) superlativ (DOT) dk> wrote Are they?
Cimode
08-15-2007 10:45 PM
Brian Selzer Go to last post
156 1,324
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 07:22 AM
Cimode Go to last post
2 117
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-11-2007 11:02 PM
Christopher Browne Go to last post
10 172
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 04:55 PM
Hugo Kornelis Go to last post
6 91
paul c wrote: I always did like a good exploding BOM.
paul c
08-08-2007 10:33 PM
Brian Selzer Go to last post
20 329
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 06:08 PM
Marshall Go to last post
3 146
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 11:54 AM
-CELKO- Go to last post
3 167
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-29-2007 11:05 PM
Gilles Ganault Go to last post
2 108
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 04:44 AM
Jan Hidders Go to last post
3 98
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 11:15 AM
Zorro Go to last post
17 209
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 01:06 AM
Frank Hamersley Go to last post
24 299
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 10:07 PM
Bob Badour Go to last post
33 435
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 01:40 AM
Martin T. Go to last post
4 127
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 01:02 PM
paul c Go to last post
12 217
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 02:32 PM
paul c Go to last post
26 316
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 08:52 AM
Cimode Go to last post
36 442
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 05:30 PM
paul c Go to last post
10 224
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 04:18 PM
Jonathan Leffler Go to last post
3 113
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 09:18 PM
Vadim Tropashko Go to last post
1 124
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 03:08 PM
David Portas Go to last post
1 81
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 11:47 AM
David Cressey Go to last post
1 93
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 11:43 AM
TroyK Go to last post
16 159
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 12:25 PM
David Cressey Go to last post
6 92
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 03:18 PM
Bob Badour Go to last post
19 148
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 01:28 PM
DBMS_Plumber Go to last post
7 101
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 12:58 PM
DBMS_Plumber Go to last post
4 165
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 10:13 AM
Jan Hidders Go to last post
38 397
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 07:28 PM
Neil Go to last post
159 1,311
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 10:39 AM
Jan Hidders Go to last post
6 153
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 12:18 PM
Anne & Lynn Wheeler Go to last post
4 128
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 05:34 AM
Jan Hidders Go to last post
65 555
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 03:13 PM
Anne & Lynn Wheeler Go to last post
14 190
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 - 2015, Jelsoft Enterprises Ltd.