Databases

NAVIGATION

Cloudscape - usage of?

Anyone using Cloudscape in production? Is it a viable platform or are IBMjust dreaming?...

5 answers | 110 bytes |

Embedded database

I need a *very* fast database for use with a dotnet 2 compact frameworkapplication. My requirements are1) I need to be able to have the following table structureInstacedId (string or Guid + unique index)InstanceType (string + non-unique index)InstanceData (binary array)2) I need to be able to qu...

3 answers | 871 bytes |

Using one table vs. many

Hello,I am designing a table that will store large amounts of rows.(>100,000). The first idea is to create a generic-like table:id | type | dataWhere data field is dependant on type field. That is, if type == 1 datais INT, if type == 2 i might interpret data as VARCHAR Is that agood thing to...

29 answers | 693 bytes |

My Tricky Query

Hi,I'm having trouble designing and efficient query in mssql and asp.Tables:Stockdata (id, companyID, date, price)Company(id, name, category)I need to get the two most recent prices for each company in acategory. Tricky part is that companies don't trade everyday, and Idon't want...

2 answers | 701 bytes |

query question

I have a library tableisbntitleauthorpublisherI want to find the name of authors who have more than one title in inthe library. Not by using SQL, but by relational algebra.I would appreciate it if anyone could show me how to do that withoprators in English words.ThanksGraham...

0 answers | 350 bytes |

InSciT2006 Second CFP and Updates

Second Call for Papers and Conference UpdatesI International Conference on Multidisciplinary Information Sciencesand Technologies, InSciT2006M, SPAIN, 25th-28th, 2006Abstract Submission Deadline Extended: May 15th, 2006Dear colleague,In addition to the features informed in the CFP, InSciT2006 is...

0 answers | 5220 bytes |

LIttle query help

K, depending on how I set it up - like if I had a favorites table, I couldprobably do something like this:SELECT song_id, ****(song_id) FRM favorites GRUB BY song_idBut that assumes a favorites table. Which brings me to a basic designquestion - if I wanted to allow users to save favorites how mi...

8 answers | 621 bytes |

webserver asp

io di solito ho fatto qualche cosa in php in localeora ho dei file in Asp e devo creare un webserver in locale x leggerequeste paginecome posso fare? ke programma devo utilizzare?...

1 answers | 210 bytes |

Document XQuery with Stylus Studio and xqDoc

[Announce] Hey Everyone,Stylus Studio has announced that Stylus Studio 2006 Release 2 XMLEnterprise Edition provides integrated support for xqDoc from directlywithin Stylus Studio's XQuery Editor. For more information, visit:xqDoc simplifies developers workloads by documenting XQuery files....

0 answers | 1274 bytes |

FS: 7 for $30 CHEAP Books - SQL Programming Database Management

I am selling these books in a lot. I am not selling them individually.Total Number of Books: 7Total List Price Value: $ 352.69Total Asking Price: $ 30Location: Houston, TX USA, but willing to ship.I accept PayPal.Most of the books are in NEW or LIKE NEW condition. A small minority areolder and m...

0 answers | 2742 bytes |

Performance/design query

Hi,I have an existing database table (MEMBER_DATA) which contains generaldata related to a member in my application.I have a new requirement to persist certain 'exit' data when the memberexits the group that he is currently subscribed to (i.e. the user is nolonger a member in the group...

2 answers | 1483 bytes |

call for papers - ICDE 2007

CALL FR PAPERS2007 IEEE 23rd International Conference on Data Engineering (ICDE 2007)April 16-20, 2007The Marmara Hotel, Istanbul, TurkeySponsored by the IEEE Computer SocietyData Engineering deals with the use of engineering techniques andmethodologiesin the design, development and assessment o...

0 answers | 19849 bytes |