hello,
im trying to make a DB for a message system.
the best way i have made is this:
*TABLE conversations* (informacion de cada conversacion)
.
i*d_conversation (bigint)
count(smallint) updated every time a new message is
adde
Baron Schwartz wrote:
Hi,
This is a fine place to ask such questions.
(In general you can just ask first, and people will tell you if you're
off-topic).
OK, thanks - I've posted the details to a new subject earlier today but
it doesn't seem to have showed up yet.
--
Richard Jones
--
My
Hi,
On Wed, Apr 2, 2008 at 5:10 PM, Richard Jones <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a complex legacy application with around 30 tables which is in need
> of re-factoring, as there are tables with lots of nulls. I've partially
> managed to achieve this so that my queries mostly return co
Hi,
I have a complex legacy application with around 30 tables which is in
need of re-factoring, as there are tables with lots of nulls. I've
partially managed to achieve this so that my queries mostly return
correct information. But there are some circumstances where duplicate
data is returne
Brett Harvey schrieb:
which method is better to do.
I have 5 tables. They represent sections/parts of a companies
standards. There are 13 main categories, each of those categories has
subsections (some with 3, some with 10 or more), those subsections have
subsections, etc.
Which table des
which method is better to do.
I have 5 tables. They represent sections/parts of a companies
standards. There are 13 main categories, each of those categories
has subsections (some with 3, some with 10 or more), those
subsections have subsections, etc.
Which table design is better to do.
T
Scott Klarenbach wrote:
These are the tables in question:
RFQ (Request for Quote)
Part
Inventory
Inventory items ALWAYS have a partID.
RFQ items ALWAYS have a partID.
However, sometimes, RFQ items have an inventoryID as well. Now, we have a
redundancy problem. Because, in those instances w
Scott,
>I'm sure this type of problem is run up against all the time, and I'm
>wondering what the best practice methodology is from experienced DBA's.
It looks like the kind of problem database schemas are meant to
_avoid_.
>From your description it seems you have ...
part (
partID PRIM
These are the tables in question:
RFQ (Request for Quote)
Part
Inventory
Inventory items ALWAYS have a partID.
RFQ items ALWAYS have a partID.
However, sometimes, RFQ items have an inventoryID as well. Now, we have a
redundancy problem. Because, in those instances when the RFQ has an
invento
"Tommy Svensson \(InfoGrafix\)" <[EMAIL PROTECTED]> wrote on 06/07/2005
04:49:09 PM:
> Hi all you mysql gurus,
> I have 400 000 unique strings where each and every one of these strings
are
> associated with 1 - 50 (appr.) integer values.
> Now, pretty simple for you guys I guess, but how will
s are going to give MySQL a hard time, unless you
have poor hardware. Still, I'd recommend considering the above example as a
model for your solution.
- Original Message -
From: "Tommy Svensson (InfoGrafix)" <[EMAIL PROTECTED]>
To:
Sent: Tuesday, June 07, 2005 1:49
Hi all you mysql gurus,
I have 400 000 unique strings where each and every one of these strings are
associated with 1 - 50 (appr.) integer values.
Now, pretty simple for you guys I guess, but how will I design my
database to make a search interface against this data as rapid as possible?
My fir
Shawn,
I agree with you that the tables can have different info with regard to
the requirements.
But for storing only addresses for specific students, this 4 table design
seems weirdish to me... I think it makes more sense to keep a
student_id in the Addresses table...
With regards,
Martijn Ton
"Martijn Tonies" <[EMAIL PROTECTED]> wrote on 05/24/2005 02:32:05 PM:
>
>
>
> > Something like this would make more sense to me and provide greater
> flexibility;
>
> It doesn't to me...
>
> > student
> >
> > student_id
> > name
> > age
> >
> > address
> > ---
> >
nal Message-
From: Koon Yue Lam [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 24, 2005 12:34 PM
To: mysql@lists.mysql.com
Subject: DB design question
Hi, here is the case:
one student may have more than one address, and one student may have more
than one phone number
so the db would be:
stu
> Something like this would make more sense to me and provide greater
flexibility;
It doesn't to me...
> student
>
> student_id
> name
> age
>
> address
> ---
> address_id
> street_name
> city
> state
> zip
What addresses are these? Random addresses where a studen
reporting and may I ask what
> > is the better way of design to handle the above case ?
>
> It's good DB design, but you need to not `select *' but the specific
> fields you'd like.
>
> An example of might be:
>
> SELECT s.name, s.age, a.street_name
repeated in certain rows
> The output is not suitable for reporting and may I ask what
> is the better way of design to handle the above case ?
It's good DB design, but you need to not `select *' but the specific
fields you'd like.
An example of might be:
SELECT s.na
PROTECTED]
Sent: Tuesday, May 24, 2005 1:34 PM
To: mysql@lists.mysql.com
Subject: DB design question
Hi, here is the case:
one student may have more than one address, and one student may have
more than one phone number
so the db would be:
student
student_id
name
age
address
esday, May 24, 2005 1:34 PM
To: mysql@lists.mysql.com
Subject: DB design question
Hi, here is the case:
one student may have more than one address, and one student may have more
than one phone number
so the db would be:
student
student_id
name
age
address
---
addre
Hi, here is the case:
one student may have more than one address, and one student may have more
than one phone number
so the db would be:
student
student_id
name
age
address
---
address_id
student_id
street_name
phone_num
--
student_id
num
extensio
Ok thanks a bunch, I'll take this information and see what I can come up
with.
Chris
[EMAIL PROTECTED] wrote:
Your system sounds more like BNF (Backus-Naur Form) expression evaluator
than a regular expression evaluator. Both are similar in that you can
specify sequences of things (letters or wo
Your system sounds more like BNF (Backus-Naur Form) expression evaluator
than a regular expression evaluator. Both are similar in that you can
specify sequences of things (letters or words or symbols) to appear in
certain orders and in certain quantities. Once a BNF or regex expression
is parse
Heh, I don't think you're being dense. I can barely understand what I
meant. I'll try to clarify I bit more.
What I have is a sequence of entities (for this example the entities
will be letters). I'm trying to use MySQL to hold the possible
combinations of entities.
The unique entities in a s
Maybe I am just being dense this morning but I am confused why you think
that your nodes are different things depending on how many children they
have (nodes, groups, entities, ahhh!)...
If you have two sets of hierarchies that share the same nodes, you may
want to build two trees rath
Hi all,
I'm designing a small database, it's essentially a tree-structure. I'm
probably going to use a Modified Preorder Tree Traversal (On a side
note, how is it different than an Unmodified Preorder Tree Traversal?).
Each node will have children etc, and those will have children, etc.
But I
Timothy Luoma <[EMAIL PROTECTED]> wrote on 10/19/2004 11:11:12 AM:
>
> On Oct 19, 2004, at 10:17 AM, [EMAIL PROTECTED] wrote:
>
> > You have already gone a long way to describing your table structure by
> > describing your data elements and their relationships to each other.
> > Let me try t
On Oct 19, 2004, at 10:17 AM, [EMAIL PROTECTED] wrote:
You have already gone a long way to describing your table structure by
describing your data elements and their relationships to each other.
Let me try to summarize you descriptions and see if I can show you
how to translate your text descri
You have already gone a long way to describing your table structure by
describing your data elements and their relationships to each other. Let
me try to summarize you descriptions and see if I can show you how to
translate your text descriptions into table descriptions.
1. There are things ca
On Mon, 18 Oct 2004 17:49:22 -0400, Timothy Luoma <[EMAIL PROTECTED]> wrote:
>
> Ok, this makes a lot of sense now. (As usual, what seems like more
> work initially pays off in the end.)
>
> Here's a specific question.
>
> The parent project is called "TiM". We will, at times, want to pull
> o
Ok, this makes a lot of sense now. (As usual, what seems like more
work initially pays off in the end.)
Here's a specific question.
The parent project is called "TiM". We will, at times, want to pull
out information for *everyone*. But more often we will want to pull
out information just fro
Timothy,
Definately follow the advice that Shawn gave you. Doing it this way
will make it easy to have any number of emails per person without have
to know how many beforehand
. Here's an example below:
Table USERS:
userid=15
fname='Timothy'
lname='Luoma'
Table EMAILS:
userid=15
email='[EMAIL
There are numerous advantages to going with the "multiple" table database
you described. That is what we call a "normalized" data structure. Try
searching again for terms like "normalized", "normalizing", and "normal
form" for additional background. Add the terms "tutorial", or "overview"
to fi
I have been tinkering with MySQL long enough to suit what modest needs
I have had, but now I need to setup a new DB that is going to have more
information in it, and I want to make sure that I am doing it the most
efficient way for the long term.
Surprisingly, I have not been able to find a goo
I'm sure this is a common and simple situation: say I have a title, url,
description fields, assume they makeup a record in one table named
book_info. Say for each of this table's records I also need a keywords
field (of type text) and I'll use a fulltext index on this field. Great,
now the user do
I've got a history table that performs a similar function. except in my
case I can have more than 1 active row. I put in an "is_active" column
and defined the type as a bool. an enum is actually a String in mysql,
which i didn't want to deal with. This table has only a few thousand
rows, so per
I have some data that is stored by the year it is related to. So I have one
table that stores the Year the data is related to, among other things. At any
given time, 1 year is considered the 'active year', and the rest are
considered inactive.
The table is something like:
CREATE TABLE Data_Inf
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Martijn, et al --
...and then Martijn Tonies said...
%
% > Since I want the ability to mirror, it seems that I'll probably want one
...
% > really don't want to keep the files in the DB itself). I'm open to ideas
% > of why I wouldn't, though.
%
%
gt; if the 'pictures' table (or the like) gets to be a million rows, but what
> I don't know about DB design would fill a book :-)
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.up
t's a DB it shouldn't matter
if the 'pictures' table (or the like) gets to be a million rows, but what
I don't know about DB design would fill a book :-)
This is a talkative list and I wouldn't be surprised to find lots of
chatter back and forth on the matter, but I
Fax to:
06/15/2004 1
Hi everybody, I'm newly subscribed so please be gentle :)
I have a design problem whose solution seems to be directly linked to
the MySQL way of handling joints.
I created a table USER which manages all entities allowed to connect to
the system.
|---| |---|
|PERSON | |C
Hello,
I have a db(logs) that I have been working on. This db has tables that are
created every month, they are Nov03,Dec03,Jan04, etc..
Each month/table has about 480,000,000 records. Data file is about 80GB the
index file is about 40GB.
Mysql/apache run on a Dell 2550 4gb ram 2cpu's OS - RH 9. I
That worked like a charm, thanks so much! I don't know why I didn't try
that before!
Julian
At 02:46 PM 11/21/2003 -0600, Paul DuBois wrote:
At 10:56 -0500 11/21/03, Julian Zottl wrote:
Andy,
Thanks for responding. I think that I am going to go with the idea of
creating a tale for each day. M
ql List
Subject: RE: DB design question - shell scripting...
At 10:56 -0500 11/21/03, Julian Zottl wrote:
Andy,
Thanks for responding. I think that I am going to go with the idea
of creating a tale for each day. My thoughts were to write a shell
script to do this for me, but I am running into a pr
Wouldn't this also work?:
mysql -u root -p -e "CREATE TABLE t$date(...)" yourdatabase
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Friday, November 21, 2003 12:46 PM
To: Julian Zottl; Andy Eastham; Mysql List
Subject: RE: DB design question -
At 10:56 -0500 11/21/03, Julian Zottl wrote:
Andy,
Thanks for responding. I think that I am going to go with the idea
of creating a tale for each day. My thoughts were to write a shell
script to do this for me, but I am running into a problem: I wrote
the following:
#!/bin/sh
date=`date "+%m%
[EMAIL PROTECTED]>
To: "Andy Eastham" <[EMAIL PROTECTED]>; "Mysql List"
<[EMAIL PROTECTED]>
Sent: Friday, November 21, 2003 7:56 AM
Subject: RE: DB design question - shell scripting...
> Andy,
> Thanks for responding. I think that I am going to go with the ide
o check that you're not searching the earliest or
latest available table, and if so, modify the union so that you don't try to
search a non-existent table.
Hope this helps,
Andy
> -Original Message-
> From: Julian Zottl [mailto:[EMAIL PROTECTED]
> Sent: 21 November 200
12:03
> To: [EMAIL PROTECTED]
> Subject: DB design question
>
>
> Hello all,
> I am designing a database right now that will have between
> 300-400k inserts
> per day. I need to keep this information for approximately 3 months and
> will probably do 5-10 reads on the data s
Hello all,
I am designing a database right now that will have between 300-400k inserts
per day. I need to keep this information for approximately 3 months and
will probably do 5-10 reads on the data set per day. I've been storing it
in one table up to now (only col.), but the searches are beco
ahesh Tailor [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 15, 2003 5:05 PM
To: [EMAIL PROTECTED]
Subject: DB Design
New to the list . . .
Running MySQL Server 3.23.58-1.72 on RedHat Enterprise AS. System has
four 3GHz processors and 6GB RAM.
I need some advise on what would be best way to app
Whats the goal with the Data? If it is graphing it then go with MRTG
with RRDtool, which will keep about 550 days of SNMP data and produce
graphs
displaying a daily, weekly, monthly and yearly timeframe... Could do
1500 devices with probably less than 10 Gigs of space...
You could then load the
ly 2gb or so)
My $0.02
Dan G
> -Original Message-
> From: Mahesh Tailor [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, October 15, 2003 5:05 PM
> To: [EMAIL PROTECTED]
> Subject: DB Design
>
>
> New to the list . . .
>
> Running MySQL Server 3.23.58-1.72 on Red
New to the list . . .
Running MySQL Server 3.23.58-1.72 on RedHat Enterprise AS. System has
four 3GHz processors and 6GB RAM.
I need some advise on what would be best way to approach this problem.
This system is using snmpcollect to collect network statistics from
about 1500 devices. The coll
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sunday 20 July 2003 09:03, Andreas wrote:
> Hi folks,
>
> how would you design a 1:1 relation ?
>
>
> I'd like to split an entities's attributes because they won't get
> equally frequently requested. So I can save memory and disk access time.
> The
al beeings that live only between the dusty
covers of db-design textbooks or - more likely - am I just ignorant ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
r Brawley
> [mailto:[EMAIL PROTECTED]
> >Sent: 19 July 2003 17:50
> >To: MySQL-Lista
> >Subject: Re: DB Design
> >
> >
> >You probably don't mean the $Nk tools
> (PowerDesigner, ERWin, Rational Rose
> >&c). MS Visio does it, but Dezign
>
this is exactly what I am looking for :) Is there a free one of these guys
hanging around somewhere?
Andrew
>-Original Message-
>From: Peter Brawley [mailto:[EMAIL PROTECTED]
>Sent: 19 July 2003 17:50
>To: MySQL-Lista
>Subject: Re: DB Design
>
>
>You probably
Saturday, July 19, 2003 11:47 AM
Subject: DB Design
is there a tool to view a schematic of a MySQL DB I don't mean the .sql
file I
mean a pretty chart type schematic :)
Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
is there a tool to view a schematic of a MySQL DB I don't mean the .sql file I
mean a pretty chart type schematic :)
Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Can anyone suggest free database desiging tool that supports mySQL.
Case studio 2.9 demo version supports mySQL but it does not allow more than
6 Tables to be designed.
Moreover demo version does not give option for referential integrity
constraints. i.e. scripts are generated without Foreign keys
Hello to all,
I would like to set up a MySql database that will
store trip information for a milage lookup
program. The user will enter the origin city/st and
the destination city/st for some predefined trips.
Then the query will need to return the milage broken
down by state. For example, for
I would like to set up a MySql database that will
store distance information for a milage lookup
program. The user will enter the origin city and the
destination city for some predefined trips. Then the
query will need to return the milage broken down by
state. For example, for an origin city i
> So you're saying like this...?
>
> Albums
> --
> ID,Artist,Title,Label
>
> Tracks
> --
> Title,Length,TrackNumber,AlbumID
>
> Where there is one album table and one track table, and each
> track references back to the album that it is a member of?
> I'm liking that... It doesn't
When you are designing a database and you are thinking about creating a
comma delimted list, this is a good sign that you need to rethink your
design. Bitfields are a good option, however if you ever need to add
elements to the bitfield (ie bitfield A can signify the presence of 4
elements, but no
On 28-Jul-2001 Ben Bleything wrote:
> Hello all!
>
> I have a question for all of you... I would very much appreciate your
> input.
>
> I'm building a database for a radio station. The database must allow
> the DJ to enter what they play and when, and allow the program director
> to create wee
Ben Bleything wrote:
>
> Hello all!
>
> I have a question for all of you... I would very much appreciate your
> input.
>
> I'm building a database for a radio station. The database must allow
> the DJ to enter what they play and when, and allow the program director
> to create weekly reports f
The rule of normaliztation is (usually) if you have data repeated in a table,
you need another table. So here's how *I* would do it.
A table for each: DJ's, Albums, Artists, Genres (a category table of sorts),
and Tracks. You might even want a table for record companies, so that's not
repeat
bject: Re: Sort-of theoretical db design question
> I'm building a database for a radio station. The database must allow
> the DJ to enter what they play and when, and allow the program
director
> to create weekly reports for the record labels.
[snip]
> First, to maintain a sing
> I'm building a database for a radio station. The database must allow
> the DJ to enter what they play and when, and allow the program director
> to create weekly reports for the record labels.
[snip]
> First, to maintain a single table with every bit of track data there is
> (ie, title, artist,
Hello all!
I have a question for all of you... I would very much appreciate your
input.
I'm building a database for a radio station. The database must allow
the DJ to enter what they play and when, and allow the program director
to create weekly reports for the record labels.
I'm wrestling wit
inetly agree specially if you consider that the number of
interests in table may increase at anytime.
Siomara
>
>Hope that wasn't too long winded. :)
>
>Roger
>
>- Original Message -
>From: "Siomara Pantarotto" <[EMAIL PROTECTED]>
>To: <[EMAI
asn't too long winded. :)
Roger
- Original Message -
From: "Siomara Pantarotto" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, July 06, 2001 5:07 PM
Subject: Re: db design questions
> Hi,
>
> Try to keep the simple
sorry I typed my website wrong. The right url is:
www.geocities.com/hisiomara
>From: "Siomara Pantarotto" <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED], [EMAIL PROTECTED]
>Subject: Re: db design questions
>Date: Fri, 06 Jul 2001 18:07:36 -0300
>
>Hi,
>
>
eam5.com ecommerce sample.
good luck
Siomara
>From: "Ed Peddycoart" <[EMAIL PROTECTED]>
>To: "MySQL" <[EMAIL PROTECTED]>
>Subject: db design questions
>Date: Fri, 6 Jul 2001 10:25:42 -0700
>
>I am working on a website which will make use of
,
Address, Phone, Email, Marital Status, Spouse, kids, things like that and a
field for comments submitted from the various people. Right now I have a
single table with a record for each item I want to store. Is that an
acceptable way?
What are some websites which contain some basic information on DB
Hi
I'm making a db design tool for the web, and would like some feedback.
Please try it out at http://dbd.aktieprat.nu/ (this domain will probably
change
later on).
TIA
/ah
-
Before posting, please check:
78 matches
Mail list logo