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     
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 09:35 AM
littldo@yahoo.com Go to last post
3 115
Ed Prochak wrote: Nick
Nicholas King
04-01-2007 12:48 AM
Gene Wirchenko Go to last post
62 801
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 03:17 PM
Jonathan Leffler Go to last post
3 109
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 02:45 PM
Jonathan Leffler Go to last post
11 222
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 06:11 AM
Cimode Go to last post
110 975
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 08:20 AM
V.J. Kumar Go to last post
1 114
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 06:39 PM
JOG Go to last post
6 122
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 03:46 PM
Bob Badour Go to last post
17 188
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 03:36 PM
Bob Badour Go to last post
46 415
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 08:54 PM
Bob Badour Go to last post
3 110
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 06:15 PM
TroyK Go to last post
45 414
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 06:19 PM
Gene Wirchenko Go to last post
8 122
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 12:51 PM
TroyK Go to last post
6 120
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 09:29 AM
Marshall Go to last post
13 239
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 10:59 AM
paul c Go to last post
2 104
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 02:46 PM
vldm10 Go to last post
4 106
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 10:14 AM
Bob Badour Go to last post
40 400
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 03:07 AM
Cimode Go to last post
19 204
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-18-2007 11:51 PM
Jonathan Leffler Go to last post
8 143
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 01:37 PM
Walt Go to last post
12 183
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 08:37 AM
Alain Caumes Go to last post
1 89
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 02:44 AM
Dmitry A. Kazakov Go to last post
36 305
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 06:37 PM
Gene Wirchenko Go to last post
22 264
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 05:51 PM
JXStern Go to last post
10 192
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 05:18 AM
Cimode Go to last post
3 97
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 12:09 PM
kidbomb@gmail.com Go to last post
2 86
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 01:33 PM
Anne & Lynn Wheeler Go to last post
79 646
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-08-2007 11:53 PM
mountain man Go to last post
29 321
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 09:29 AM
Walt Go to last post
191 1,482
Hi, The following is a part of an empirical effort for designing a computing model for optimizing relation physical represention...
Cimode
03-06-2007 02:57 PM
Cimode Go to last post
2 119
"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 01:31 PM
DBMS_Plumber Go to last post
29 278
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 10:02 AM
Bob Badour Go to last post
183 1,607
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 04:19 AM
JOG Go to last post
52 1,198
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 04:19 PM
Bob Badour Go to last post
2 92
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 07:50 PM
mAsterdam Go to last post
1 130
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 01:48 PM
vldm10 Go to last post
476 2,870
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 03:35 PM
Walt Go to last post
31 323
A little thread I stumbled onto this morning...A sad sign of our time...
Cimode
02-28-2007 03:34 PM
Bruce C. Baker Go to last post
17 162
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 10:21 PM
dawn Go to last post
56 497
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 07:56 PM
jlowery Go to last post
2 148
Hi all, can any one give me good examples of bcnf, 4nf, 5nf & denormalization
sam
02-22-2007 04:22 AM
nupul Go to last post
2 153
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 02:27 AM
Cimode Go to last post
81 754
Does anyone know if Zipf's law is still being used in the design of corporate database software?
A E Neumann
02-17-2007 02:27 PM
-CELKO- Go to last post
2 150
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 06:11 PM
mountain man Go to last post
39 309
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 09:57 PM
BobTheDataBaseBoy Go to last post
3 121
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 07:27 AM
Bob Badour Go to last post
1 124
Just ran across this: "Inspired by The Third Manifesto, a book by Chris Date and Hugh Darwen, we're putting forward an implementation of a truly...
Marshall
02-12-2007 06:32 AM
Cimode Go to last post
8 107
Hello, I have a relational database design question that I cannot seem to solve in an aesthatically pleasingly way; I was hoping someone could help...
chezball@gmail.com
02-11-2007 04:14 PM
Walt Go to last post
15 182
Vague thoughts: Choice isn't all its cracked up to be. Often times people don't want a lot of different ways of doing things to sort though, even if...
Marshall
02-10-2007 06:59 AM
Walt Go to last post
7 101
Can anyone direct me to the latest database archival strategies that are used in the market these days? I have a db which is underperforming bcz of...
rachitm@gmail.com
02-08-2007 01:41 PM
Doug Morse Go to last post
3 118
Post New Thread

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