I am learning about database systems, and I am reading a book called "Physical Database Design". It gets to a bit about a large sequential access...

Darren

09-05-2008 04:41 PM
DBMS_Plumber

Hello, I have something like: TABLE A a PK TABLE B b PK

philiptaylor51@yahoo.com

09-05-2008 01:08 PM
jefftyzzer

Hi all. This might be off topic for this group; if so please direct me to a more appropriate group. I have 20 years of programming experience...

Rune Allnor

09-05-2008 05:26 AM
Rune Allnor

ok, the book I am reading discusses this type of query: SELECT p.pname FROM P, SH, S WHERE P.pnum = SH.pnum AND SH.snum = S.snum AND S.city =...

Darren

08-22-2008 12:13 AM
Tim X

As one of my first encounters with SQL (The RDBMS used is MySQL 5.1), my colleague and I have designed the following (it's a part of a catalog system...

Adriano Varoli Piazza

08-20-2008 08:12 PM
JOG

Project management resources: templates, samples, articles, software, lecture notes on software & general PM. Project Management Topics to Beginners...

spyder

08-20-2008 07:49 AM
spyder

vadlo (www.vadlo.com) - great search engine and borwser for biology methods and databases.

Rb

08-17-2008 08:25 PM
Bob Badour

Hi, how correct is the following diagram showin g modules of a DBMS ...???? http://i529.photobucket.com/albums/dd339/aarklon/5.jpg

aarklon@gmail.com

08-16-2008 01:09 AM
paul c

Hi all, BCNF the following is the definition is the definition of BCNF , which i saw in a schaum series book 1) The relation is 1 N.F 2) for...

aarklon@gmail.com

08-12-2008 07:44 AM
Brian Selzer

I can not find a definition for "proper superkey". I have found "superkey", but not "proper superkey". Sincerely, Gene Wirchenko Computerese...

Gene Wirchenko

08-04-2008 05:10 PM
-CELKO-

Hi, I have read that data mining is the process used to find new ,hidden or un expected patterns in the data to predict the future of the business &...

aarklon@gmail.com

08-04-2008 09:05 AM
aarklon@gmail.com

I have something like: entity (id, live_version_id NULL, preview_version_id NULL) version (id, parent_entity_id) where version.parent_entity_id must...

Daniel Pitts

08-02-2008 10:44 AM
-CELKO-

On Jul 13, 9:07 am, JOG <j... (AT) cs (DOT) nott.ac.uk> wrote: Hey! You've been complaining about the other side's simplistic analyses, but here...

paul c

08-01-2008 09:35 PM
David BL

PRELIMINARY CALL FOR PAPERS THE ALBERTO MENDELZON WORKSHOP ON FOUNDATIONS OF DATA MANAGEMENT May 12-15, 2009, Arequipa,...

marenas@ing.puc.cl

08-01-2008 09:43 AM
marenas@ing.puc.cl

This is not a theory question by any means, but perhaps there is someone hanging out here who is able to speak with authority on SQL. We are trying...

Roy Hann

07-31-2008 12:18 PM
Roy Hann

Hi all. I have this data: id GroupId DDate Value 1 1 7/31/2008 ...

Lemune

07-30-2008 11:18 PM
Lemune

** Apologies for cross-postings. Please send to interested colleagues and students.** -- CALL FOR PAPERS - Deadline for submissions (2nd call): 1...

natty2006@gmail.com

07-30-2008 08:29 PM
David BL

Hi all, I read the following in a book 1) we can have several non clustered indexes on a table , but we can have only one clustered index per...

aarklon@gmail.com

07-30-2008 11:30 AM
Brian Selzer

To establish a context for this message a reader is referred to http://arxiv.org/pdf/0807.3795 and old...

vadimtro@gmail.com

07-29-2008 05:24 PM
vadimtro@gmail.com

Classified Preview Title: Munifus Landmark Estate ™ House Manufacturing Worldwide Project Contracting City: Stockholm, London, Moscow, Los Angeles,...

rogerkolsson@yahoo.co.uk

07-28-2008 05:28 PM
rogerkolsson@yahoo.co.uk

Hi all, I recently read the following in a book(oracle 9i for dummies by Carol McCullough Dieter) The fastest way to retrieve rows from a table is...

aarklon@gmail.com

07-27-2008 08:47 PM
David BL

On Jul 25, 7:30*am, JOG <j... (AT) cs (DOT) nott.ac.uk> wrote: Could you please be more specific? All SQL datatypes I know (well, those that I'm...

JOG

07-25-2008 08:58 PM
JOG

Hi all, the following is the algorithm which i saw in schaum series book(fundamentals of relational databases) satisfies algorithm this algorithm...

aarklon@gmail.com

07-25-2008 08:41 AM
aarklon@gmail.com

Hi, i have a question about two parallel transactions which insert the same key. Assume that key A does not yet exist. T1 Begin T2 Begin T1 Insert...

Christoph Rupp

07-23-2008 03:42 AM
Christoph Rupp

Hi all I am designing a database for my charity (we are a local special needs charity) to replace our existing one, and my main goals are to...

Rainboy

07-21-2008 02:35 PM
Ed Prochak

Hi, I'm trying to create pivot, my data are area, sub area, member code. On Pivot/Crosstab data area i want to calculate how many member that access...

Lemune

07-17-2008 03:42 PM
TroyK

Find the latest updates in SQL server tools and techniques. More details on database management, software testing, flow chart prepartation and many...

surana

07-15-2008 09:53 PM
Bob Badour

In the following I’m using the definitions of value, variable and type described by C.Date. Values are eternal and immutable. Variables are...

David BL

07-14-2008 10:36 PM
David BL

Hi all! It is often stated that relational calculus (tuple domain calculus) is a subset of first order logic. In the dbforum, wikipedia, wapedia...

tbeer

07-11-2008 09:54 AM
tbeer

Find the latest updates in database management and SQL server tools and techniques. More details about software testing, flowchart preparation and...

surana

07-06-2008 08:57 PM
surana

I'e been tring to develop a workable implementation of nested interval tree encoding using continued...

Eric DeCosta

07-03-2008 06:58 PM
Tegiri Nenashi

** Apologies for cross-postings. Please send to interested colleagues and students.** -- CALL FOR PAPERS - Deadline for submissions (extended): 25...

natty2006@gmail.com

07-02-2008 11:27 AM
natty2006@gmail.com

I have an Access database with two tables "Main" and "Rafflenumbers", also a main form (for names etc) and a subform (for numbers assigned). I put...

Joe

06-30-2008 05:45 AM
Philipp Post

Hi everyone; I want to write a report about database model, and i plan to write 3 models which are Network Model,Hierarchical Model, and relational...

dingchi88@gmail.com

06-25-2008 05:48 PM
jefftyzzer

Dear all, I have read the literature on fuzzy/approximate search for strings keys in large databases, but I could not find a clear answer on what is...

walid.saba@gmail.com

06-20-2008 12:47 PM
jefftyzzer

Suppose there are N parties. Each party has R records, each of which has D dimensions. For example, N=3, parties are P1, P2, P3. D=4, dimensions are...

simon

06-16-2008 12:42 PM
-CELKO-

Hi all, I am currently designing my first database. The complexity is manageable. However in the future I might want to expand the domain...

ben@cosmoi.de

06-16-2008 11:13 AM
-CELKO-

Does the Unique Name Assumption apply only to individuals, or does it apply also to relations? Under an interpretation where constant symbols...

Brian Selzer

06-14-2008 04:35 PM
Brian Selzer

What the hell is objectivied relational mapping? Can anyone point me to references? I've Googled, but nothing. My client insists that the db act...

Evan Keel

06-12-2008 12:11 PM
paul c

goanna wrote: So, the pensioners whose pensions hold most of the shares are parasites? Are you suggesting it's a myth that a lifetime of toil means...

sinister

06-04-2008 10:24 AM
Evan Keel

"Rookie" <rookie (AT) hates (DOT) spam> wrote A bit dry, but thorough: http://tinyurl.com/5ql6qg

Evan Keel

06-04-2008 10:05 AM
Evan Keel

I was just looking at Codd's RM 2 book again (the rather short chapter on views from acm.org) and it seemed to me that what he wrote took it...

paul c

06-03-2008 10:53 PM
paul c

Lately I found the following additional language extension libraries (making a new language called SQL sharp) running on T-SQL (the SQL version of...

Cimode

05-28-2008 06:04 AM
Cimode

SAN Database Management Discounted IP SAN solutions. Switch to SAN, get offer...

gaojihuiyuan

05-23-2008 09:31 AM
gaojihuiyuan

Hi This is a recurring question here, but I have read through the archive and failed to find a answer so here goes. Consider the following use...

Lars Tackmann

05-23-2008 07:39 AM
David Cressey

Have you heard of Postel's Law? "Be liberal in what you accept, and conservative in what you send." I can imagine it being applied to many things. ...

David BL

05-23-2008 01:28 AM
David BL

WinDBPro. Ver 2.0 Works with any Windows Version Complete DB one exe file only One file : (88KB) 12 billion Record Capacity Search / Sort /Find Built...

Scott

05-19-2008 02:35 AM
Scott

Very late in the day I have been handed the task of finding a keynote speaker for a database user association conference to be held in London...

Roy Hann

05-18-2008 07:55 AM
Roy Hann

Stefan Ram wrote: I apologize for replying this late (busy life). Your rule is very close to my intuitive understanding of 'value'. I am thinking...

Victor Porton

05-15-2008 05:06 PM
TroyK

It would be interesting to hear your comments and opinions on the following. Essentially, I'm struggling with the problem that when we want to...

Dr Quite Evil

05-14-2008 07:35 AM
Brian Selzer