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'm attempting to perform a SQL query that joins two tables based on the parent's parent but my SQL isn't that good and am looking for assistance....
jeff.lawrence@gmail.com
04-05-2007 10:09 AM
Cimode Go to last post
2 133
Let us consider the choice of characters to use for relational operators. It might be desirable to use different characters for the relational...
Marshall
04-03-2007 08:14 AM
Bob Badour Go to last post
59 690
After programming in other languages for almost 18 years, I learned Pascal. I found Pascal's infix operators easy to write and, more importantly,...
David Cressey
04-01-2007 07:39 PM
Bruce C. Baker Go to last post
1 165
Hi- I've been banging my head over how to represent this theoretical example: in a group of people, trying to keep track of who is friends with...
mlefkon@yahoo.com
04-01-2007 11:14 AM
Marshall Go to last post
51 627
Hi, I need to insert a fixed parameter along with data from a query as part of an insert statement. The statement looks like this. insert into tab...
littldo@gmail.com
04-01-2007 10:35 AM
littldo@yahoo.com Go to last post
3 121
Ed Prochak wrote: Nick
Nicholas King
04-01-2007 01:48 AM
Gene Wirchenko Go to last post
62 823
I need to run a report on numbers in a range of numbers. Each one increments 8 from the last. For example: 10000 10008 10016 etc.
Larry D
03-31-2007 04:17 PM
Jonathan Leffler Go to last post
3 111
The recent threads on possreps and floating point made me think about fixed point arithmetic, again. I'm going to refer you to the Wikipedia entry...
David Cressey
03-31-2007 03:45 PM
Jonathan Leffler Go to last post
11 228
X-No-Archive:yes I see people putting XML documents in databases. Why do they do this, what is the logic behind it? Why not just put the data into...
Karen Hill
03-31-2007 07:11 AM
Cimode Go to last post
110 1,048
Given a relation R(x,y) when does x->y functional dependency holds? Let's try several relational algebra expressions over R. 1. Self join: R /\ R....
Aloha Kakuikanu
03-30-2007 09:20 AM
V.J. Kumar Go to last post
1 118
Over in a neighboring thread, the prospect of XML inside the DBMS is recieving a fairly well deserved bashing. Here, I'm gonna point out one fairly...
DBMS_Plumber
03-29-2007 07:39 PM
JOG Go to last post
6 123
Here's another example of floating point errors, that's even simpler than the 21200 plus 2.5% example. int i; float x = 0; for (i = 1; i < 100;...
David Cressey
03-29-2007 04:46 PM
Bob Badour Go to last post
17 192
This is more of me trying to sort out my confusion about possreps. Lately I have been thinking about numeric types. I find the situation...
Marshall
03-29-2007 04:36 PM
Bob Badour Go to last post
46 440
It seems like there are two ways to implement database replication in a master/slave configuration: replicating DML or replicating insert/delete...
Marshall
03-28-2007 09:54 PM
Bob Badour Go to last post
3 113
On Mar 25, 3:26 am, Joe Thurbon <use... (AT) thurbon (DOT) com> wrote: Yeah, that's a fair point. The column-type storage costs are O(1), vs....
Bob Badour
03-28-2007 07:15 PM
TroyK Go to last post
45 438
Example: suppose I'm storing responses to a diagnostic interview. One of the questions asked of the subject is something like 7. Have you always...
sinister
03-26-2007 07:19 PM
Gene Wirchenko Go to last post
8 123
On Mar 23, 9:18 pm, Joe Thurbon <use... (AT) thurbon (DOT) com> wrote: Difficult to say without knowing the business rules that constrain...
TroyK
03-26-2007 01:51 PM
TroyK Go to last post
6 121
I'm working on a conceptual model (ie 'thinking about' / 'air code') to implement a small operating system (extensible of course) that is built...
christianlott1@yahoo.com
03-25-2007 10:29 AM
Marshall Go to last post
13 243
Joe Thurbon wrote: Joe, I'm guessing that Fabian P meant to say something like "If no trivial multivalued dependencies exist ...". As Date puts...
paul c
03-24-2007 11:59 AM
paul c Go to last post
2 108
Assume that I have the following data: Product, Category (assume all numerals) I need to perform the following queries at various times: 1. For a...
cnlai
03-22-2007 03:46 PM
vldm10 Go to last post
4 108
Any thought's on using negative numbers as surrogate primary keys? Working with some folks who are of the opinion that using ranges such as -1,-2,-3...
Tam OShanter
03-22-2007 11:14 AM
Bob Badour Go to last post
40 416
Hello all, I would like your opinion and experience on the performance of writing large datasets. I am writing in one loop about 3.5 million rows...
jma
03-22-2007 04:07 AM
Cimode Go to last post
19 208
I took a quick peek on my bookshelf, the one that has to do with computing. About half the books should be cleared off, but I probably won't get...
Walt
03-19-2007 12:51 AM
Jonathan Leffler Go to last post
8 145
In the topic about building an OODB from an RDBMS point of view, I may have mistaken the meaning of Dmitry's term "surrogate identifier". I...
Walt
03-16-2007 02:37 PM
Walt Go to last post
12 185
Hi all, I unfortunately have undertaken a clumsy task, however, I was asking for it. I am facing the problem of having a number of remote...
jma
03-16-2007 09:37 AM
Alain Caumes Go to last post
1 90
On Thu, 15 Mar 2007 01:31:26 GMT, Bob Badour wrote: Which is exactly what ANY programming is about = describing tasks to be carried out by a...
Dmitry Shuklin
03-15-2007 03:44 AM
Dmitry A. Kazakov Go to last post
36 323
I was interviewing a guy today, and he had obviously been formally schooled in ERM. Every time I run in to that I feel vaguely left out. I don't have...
Marshall
03-14-2007 07:37 PM
Gene Wirchenko Go to last post
22 267
I have found myself in many times, when talking about (R)DBMS "Worse than MySQL: Just Ms Access". Often I'm challenged, "really? who says...
cesarvegamx@gmail.com
03-14-2007 06:51 PM
JXStern Go to last post
10 203
Hello all, I am facing the following task: I want to benchmark different solutions for storing large amounts of finite element data from different...
jma
03-14-2007 06:18 AM
Cimode Go to last post
3 99
Hello Friends, I would like to know performance of Join. So give me your feedback on following two CASES. which one is good and why? Also explain me...
Mitul
03-13-2007 01:09 PM
kidbomb@gmail.com Go to last post
2 90
Hi, I am trying to get my head around who to best design a couple of tables for performance. The entities are fake so ignore that, I am just...
Timasmith
03-12-2007 02:33 PM
Anne & Lynn Wheeler Go to last post
79 684
It seems to me that, sometimes, relationships in data are discovered by other people than the ones who initially tabulated the data. This...
Walt
03-09-2007 12:53 AM
mountain man Go to last post
29 327
On Feb 28, 6:46 am, "JOG" <j... (AT) cs (DOT) nott.ac.uk> wrote: Since I wasn't able to reply to everything in the last one, I thought I'd return to...
dawn
03-08-2007 10:29 AM
Walt Go to last post
191 1,510
Hi, The following is a part of an empirical effort for designing a computing model for optimizing relation physical represention...
Cimode
03-06-2007 03:57 PM
Cimode Go to last post
2 122
"A typical SQL DBMS requires _drastically_ faster hardware than a hierarchical database to provide even roughly equivalent response time -- to the...
frebe
03-06-2007 02:31 PM
DBMS_Plumber Go to last post
29 287
I hope no one will mind too much if I take a break from our usual sort of discussion and talk about database theory for a bit. I feel like free...
Marshall
03-06-2007 11:02 AM
Bob Badour Go to last post
183 1,709
1 NF (Multi-page thread 1 2 3 4 5 ... Last Page)
Hi, I read an interview with Chris Date (http://www.dbmsmag.com/ int9410.html) which made me a little bit confused. He claims that having an array as...
frebe
03-06-2007 05:19 AM
JOG Go to last post
52 1,209
Okay, we mentioned possreps in passing in a recent thread. I'm still unclear on their value. Thought I'd try to talk it through and see what...
Marshall
03-04-2007 05:19 PM
Bob Badour Go to last post
2 94
Hi, I'm wondering if there is any tip or trick how to find ALL candidate keys (CK) for a relation and its FDs, w/o using kind of "brute...
Mike M
03-03-2007 08:50 PM
mAsterdam Go to last post
1 133
On Feb 16, 4:40 am, Joe Thurbon <use... (AT) thurbon (DOT) com> wrote: No you are pretty much on the money there imo Joe. I am happy to put up with...
David BL
03-03-2007 02:48 PM
vldm10 Go to last post
476 3,023
Is anybody aware of literature about algorithms to remove a range of records from a B-Tree, and doing bulk insertion, or better of a table storage...
laurentoget@gmail.com
03-02-2007 04:35 PM
Walt Go to last post
31 339
A little thread I stumbled onto this morning...A sad sign of our time...
Cimode
02-28-2007 04:34 PM
Bruce C. Baker Go to last post
17 169
Bruce C. Baker wrote: A slightly longer view would recognize that the Brits during the heights of their Empire also got their butts kicked in places...
Bob Badour
02-26-2007 11:21 PM
dawn Go to last post
56 506
I recently finished one of my old college text books that I never read named "An Introduction to Database Systems" by Date. A lot of the concepts in...
jlowery
02-26-2007 08:56 PM
jlowery Go to last post
2 150
Hi all, can any one give me good examples of bcnf, 4nf, 5nf & denormalization
sam
02-22-2007 05:22 AM
nupul Go to last post
2 160
Can an empty set contain an empty set? Is it valid according to set theory? If so, what does it correlate to in the real world? (when last explained...
Neo
02-19-2007 03:27 AM
Cimode Go to last post
81 805
Does anyone know if Zipf's law is still being used in the design of corporate database software?
A E Neumann
02-17-2007 03:27 PM
-CELKO- Go to last post
2 156
On Jan 24, 9:43 am, Joe Thurbon <use... (AT) thurbon (DOT) com> wrote: Thanks for this Joe. Just to clarify this, my limited knowledge of SOL began...
Tonkuma
02-15-2007 07:11 PM
mountain man Go to last post
39 322
Troels Arvin posted a probelm in the DB2 newsgroup in which he had a data source with CHAR (n) data that was supposed to be in ISO-8601 format (i.e...
-CELKO-
02-13-2007 10:57 PM
BobTheDataBaseBoy Go to last post
3 123
Hi all, i have 1st started isqlplus using isqlplusctl start and i gave http://localhost:5560/isqlplus in browser it neither gives the isqlplus nor...
nagur4study
02-12-2007 08:27 AM
Bob Badour Go to last post
1 128
Post New Thread

Display Options
Showing threads 451 to 500 of 1738
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.