Hello,
>Many thanks for your response. Can yo u offer any advice with regards
usage
>of country_codes eg gb and regions, cities etc ? I've been reading up on
>http://en.wikipedia.org/wiki/ISO_3166 etc. Should I be looking to use a
>Surrogate key for countries ? Or the country code like fr for
Many thanks for your response. Can yo u offer any advice with regards
usage of country_codes eg gb and regions, cities etc ? I've been reading
up on http://en.wikipedia.org/wiki/ISO_3166 etc. Should I be looking to
use a Surrogate key for countries ? Or the country code like fr for France
?
Sa
Neil,
Am 21.04.2013 08:47, schrieb Neil Tompkins:
Using joins I can obtain which country each city belongs too. However,
should I consider putting a foreign key in the CITIES table referencing the
countries_id ? Or is it sufficient to access using a join ?
It depends. Adding a reference to
Verify the regulation that a Hotel should submit, read the part of the
occupation reports, information gathering, ask management for their
currents report...
Remember the data output should came from the data stored...
On Mon, Feb 20, 2012 at 4:42 PM, Chaim Rieger wrote:
> On 2/17/2012 4:01 AM
On 2/17/2012 4:01 AM, Tompkins Neil wrote:
Hi,
I'm in the process of starting to design a hotel booking system that will
eventually consist of over 10,000 hotels all with different room types,
rates and availability for different dates. My question is does anyone
have any experience with regard
Hi
I am trying to get some background information with regards the design. I have
a fair idea but would like advice from anyone that has previously worked on
similar projects.
On 20 Feb 2012, at 17:22, Jan Steinman wrote:
> Where are your domain experts? You *are* consulting with them, no
Hi,
Nobody answers because this is a very wide question about software
engineering,
Trust me, It seems like a simple question but it is not.
The only advice I can give you is to try to imagine all possible
scenarios/use-cases before starting the design.
Cheers
Claudio
2012/2/20 Jan Steinman
Where are your domain experts? You *are* consulting with them, no?
If you don't know the answers, and don't have access to domain experts to help
you, I would design for the most general case, and factor out exceptions as
they prove to be so. "Pre-optimization" for exceptions almost always turns
> From: gvim
>
> I have a typical contact database which caters for multiple email addresses
> with a distinct Email table keyed to a foreign key inside the Contact table,
> ie. a 1-to-many relationship. However, I want to prioritise these Email
> entries for a given Contact entry so all I can
>From: gvim [mailto:gvi...@gmail.com]
>Sent: Thursday, December 09, 2010 9:33 AM
>To: MySQL
>Subject: Design: how to prioritise 1-to-many fields
>
>I have a typical contact database which caters for multiple email addresses
>with a distinct Email table keyed to a foreign key inside the Contact tabl
On Thu, Dec 9, 2010 at 3:33 PM, gvim wrote:
> I have a typical contact database which caters for multiple email addresses
> with a distinct Email table keyed to a foreign key inside the Contact table,
> ie. a 1-to-many relationship. However, I want to prioritise these Email
> entries for a given
On 10/8/2010 3:31 PM, Neil Tompkins wrote:
Hi Shawn
Thanks for your response. In your experience do you think I should still
retain the data used to generate the computed totals ? Or just compute
the totals and disregard the data used ?
In my experience, the details matter. Also in my experie
Hi Shawn
Thanks for your response. In your experience do you think I should
still retain the data used to generate the computed totals ? Or just
compute the totals and disregard the data used ?
Regards
Neil
On 8 Oct 2010, at 19:46, "Shawn Green (MySQL)"
wrote:
Hi Neil,
On 10/5/2010
Hi Neil,
On 10/5/2010 5:07 AM, Tompkins Neil wrote:
Hi
I have a number of tables of which I use to compute totals. For example I
have
table : players_master
rec_id
players_name
teams_id
rating
I can easily compute totals for the field rating. However, at the end of a
set period within my ap
I'm not sure why you say 30 or more inserts will take too long. As
long as you do a bulk insert, it's just a single command. 30
individual insert will take it's toll.
You are really looking for a logging system. Your not going to be
querying the table all that much, just a lot of inserts. S
Scott Haneda wrote:
Scott Haneda wrote:
I have an a table of objects, attached to those objects are keywords.
Users submit the keywords to the objects.
Currently, I chose to keep a hit count on the keywords, so if a duplicate
keyword is supplied, a counter is incremented.
I thought this was a
> Scott Haneda wrote:
>> I have an a table of objects, attached to those objects are keywords.
>> Users submit the keywords to the objects.
>>
>> Currently, I chose to keep a hit count on the keywords, so if a duplicate
>> keyword is supplied, a counter is incremented.
>>
>> I thought this was a
Scott Haneda wrote:
I have an a table of objects, attached to those objects are keywords.
Users submit the keywords to the objects.
Currently, I chose to keep a hit count on the keywords, so if a duplicate
keyword is supplied, a counter is incremented.
I thought this was a good idea, as it keep
Because you are a novice to data base design, you have fallen into a common
trap. If you think about an array, you don't want to store multiple users in
a row, you want to store them in a column. In other words, you want to have
one table that stores businesses (once per business, probably) and ano
Hi Sudheer,
First of all there a number of ways to design this database.
You will need to choose the one that you feel suites your needs best.
Here one possible design.
Because you have different type of users/accounts, it looks like
"ACCOUNT_TYPE" table is needed
ACCOUNT_TYPE table
Account_
HI Sudheer,
THIS DESIGN IS BASED ON MY MANY->TO->ONE DIRECTION PATTERN
OF DATABASE NORMALIZATION DESIGN... PLEASE MODIFY/CORRECT IT ACCORDING TO YOUR
TASTE. AS A JAVA DEVELOPER I'M USING HIBERNATE FOR MY CREATE-UPDATE-DELETE(CUD)
AND DIRECT JDBC FOR MY QUERIES(R).
YOU MAY VARY.
HERE, HOPE TH
On Thu, May 24, 2007 2:12, Przemys?aw Klein said:
> Wm Mussatto wrote:
>> Assuming you are using MYISAM table types, each table requires at least
>> three files on the disk. If they are in one database they will all be
>> in
>> one directory (how fast is your OS at finding the files in its directo
Wm Mussatto wrote:
Assuming you are using MYISAM table types, each table requires at least
three files on the disk. If they are in one database they will all be in
one directory (how fast is your OS at finding the files in its directory
structure?).
Are they going to be opened at the same time (
On Tue, May 22, 2007 23:29, PrzemysÅaw Klein said:
> Martijn Tonies wrote:
>> Hi,
>>
>>
>>> I'm working on quite big database. It consists of about 200 tables.
>>> Additionaly about 50 tables are per year (because of annual data). It
>>> means every year new 50 tables will have to appear in applic
Martijn Tonies wrote:
Hi,
I'm working on quite big database. It consists of about 200 tables.
Additionaly about 50 tables are per year (because of annual data). It
means every year new 50 tables will have to appear in application. And
now I have a question. Should I use separate databases fo
Hi,
> I'm working on quite big database. It consists of about 200 tables.
> Additionaly about 50 tables are per year (because of annual data). It
> means every year new 50 tables will have to appear in application. And
> now I have a question. Should I use separate databases for "annual" data
> (i
It seems to me that you are asking about Merge tables. A merge table allows you to "combine" 1 or more tables to appear as a single
"virtual" table. What tables make up the merge table can modified quickly and easily, regardless of size. Then your code only needs
to reference 1 table name.
Ther
Always reply to the lists, others may have better ideas, others insights...
I may have not understand everything in your previous description. Why
would you need an extra software on the remote DB ??
All the steps I've describe should work from the client.
All you want is a kind of cache for the c
I thought this solution but it needs an extra software at the remote
database. I would prefer to contact from the cache database directly to
the remote database using SQL.
But even using those 3 steps there is a problem. The only interface that
I have is JDBC/SQL. That means that the only solu
Hi,
Try in in two fold.
1. Get all the ID you have in your remote DB
2. check those localy with the ones you have in cache
3. Get all the info you need after you remove the ID you already have.
2005/8/14, Kostas Karadamoglou <[EMAIL PROTECTED]>:
> Hello,
>
> I try to create an application for my
image ?
you're modifying row n, node x wants to modify it, you need a rollback segment
for that ! which value node x will read.
i'm considering every DML is a transaction in an RDBMS, so when you say that you
don't use transactions, you miss something.
about load balancing, how do you track long
[EMAIL PROTECTED] wrote:
Hi,
i think that client load-balacer are more Dispatchers than real load balancer.
load balancing in the database side takes care to number of connections, but
also node load. So thisis more real. But this issue is difficult.
No... you're making assumptions. With t
Hi,
i think that client load-balacer are more Dispatchers than real load balancer.
load balancing in the database side takes care to number of connections, but
also node load. So thisis more real. But this issue is difficult.
even for oracle with 9iRAC and 10gRAC, load balancing is not completely
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kevin Burton wrote:
> [EMAIL PROTECTED] wrote:
>
>
>>Wouldn't it make better sense to build on the NDB protocol and keep
>>the native messaging infrastructure than it would be to build a
>>similar wrapper from scratch? I mean to use the NDB commun
> Sent: Wednesday, June 01, 2005 1:21 PM
> To: Kevin Burton
> Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com
> Subject: Re: Design of a Client-side MySQL Java oad Balancer
>
> Kevin Burton <[EMAIL PROTECTED]> wrote on 06/01/2005 02:31:54 PM:
>
> > I'd love to get so
[EMAIL PROTECTED] wrote:
Wouldn't it make better sense to build on the NDB protocol and keep
the native messaging infrastructure than it would be to build a
similar wrapper from scratch? I mean to use the NDB communications on
top of regular MySQL
Biting off an NDB migration would be a L
Kevin Burton <[EMAIL PROTECTED]> wrote on 06/01/2005 02:31:54 PM:
> I'd love to get some feedback here:
>
> > MySQL currently falls down by not providing a solution to transparent
> > MySQL load
> > balancing. There are some hardware solutions but these are expensive
and
> > difficult to config
OK, just to make sure: ALL of the data actually resides within MySQL and
on the same server (regardless of it's original source)? That is good as
MySQL does not permit retrieving data from other servers in a query (yet).
So you have a table for the primary Model information, a second table for
the
"mel list_php" <[EMAIL PROTECTED]> wrote on 04/13/2005 11:07:44 AM:
>
>
> >
> >When you mention external databses, I got curious. Do you mean
"external"
> >as in "not on that MySQL server"? Or, do you mean "external" as in
"same
> >server, different database"?
> >
> >If you are designing your
When you mention external databses, I got curious. Do you mean "external"
as in "not on that MySQL server"? Or, do you mean "external" as in "same
server, different database"?
If you are designing your site correctly, the user should know nothing
about your data storage. That means that the "user"
> wants to look, so the search will be only a query to the dedicated table
> (database2 for ex if the user wants to retrieve articles)
>
> Do you think this kind of schema will be ok for the display of
information?
>
> Thank you very much for your time,
> Melanie
>
>
will be ok for the display of information?
Thank you very much for your time,
Melanie
From: "Gordon" <[EMAIL PROTECTED]>
To: "'mel list_php'" <[EMAIL PROTECTED]>,
Subject: RE: design: table depending on a column
Date: Tue, 12 Apr 2005 10:32:17 -0500
As
As long as articles.annotationID can be made distinct from
names.annotationID why not use 2 left joins.
You may have to test annotationType in the select section to map the fields.
Something like the following.
SELECT elements.annotationID,
CASE annotationType
WHEN 'names' T
>
> To follow your example, I would add these other fields to the
> listings_projects table you defined below, and restructure the query
> around that?
>
> Thanks for your insight!
>
> -Erich-
>
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL P
around that?
Thanks for your insight!
-Erich-
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 04, 2004 11:51 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Design Question
As posted, your data structure supports two one-to-many rela
As posted, your data structure supports two one-to-many relationships, not
the one-to-one relationships as you described. You can have multiple
Listings per Category and multiple Categories per Group. What it sounds
like you have been asked to do is to support a many-to-many relationship.
You
You are right, a comma separated "list" won't work since you won't be
able to do joins on it. To create a one to many relation, you actually
need to create another table to hold the relation.
CREATE TABLE listCatLink (
ListingID bigint(20) unsigned NOT NULL,
CategoryID int(11) NOT NULL
)
On Aug
EB> My thought was to add a new field to the listings table that would
EB> contain a comma-separated list of CategoryIDs, but something doesn't
EB> feel right about this solution.
> This would break the first normalization form and is extremely bad
Okay - I thought something was off...
> First o
> If you are not using 5.0 and don't want to switch to 5.0, then using
> database "view" will also work. This link tells how to create views:
>
http://www.mysql.com/documentation/maxdb/6d/117c44d14811d2a97400a0c9449261/content.htm
What version does this work for? We're using 4.0.14 and it doesn'
tation/maxdb/6d/117c44d14811d2a97400a0c94492
61/content.htm
-Original Message-
From: Ed Lazor [mailto:[EMAIL PROTECTED]
Sent: Friday, February 27, 2004 7:18 AM
To: 'Zhao, Charles'
Subject: RE: Design Advice?
Hi Charles,
Thought of a question... the stored procedure sounds like
Your business requirement is not quite clear. Here are some questions
that you need to answer before you finalize your design:
1. How often will the invoice be viewed (and I assume the viewers must
be your web site users?)
2. What's the approximate traffic volume?
3. Will each time the users vie
Hi Charles,
Answers:
1. Frequent web viewers
2. Medium... internal website
3. An invoice will get frequent views while it's active, but very few
views after it's completed.
4. About 1200 entries a month.
Are there approaches other than what I described?
-Ed
-Original Message-
Your
ry 26, 2004 12:16 PM
To: 'Zhao, Charles'; [EMAIL PROTECTED]
Subject: RE: Design Advice?
Hi Charles,
Answers:
1. Frequent web viewers
2. Medium... internal website
3. An invoice will get frequent views while it's active, but very few
views after it's completed.
4. About 12
erver, or blob data in a separate table. Partitioning your invoice
table based on time periods would also be an idea.
-Original Message-
From: Ed Lazor [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 26, 2004 12:16 PM
To: 'Zhao, Charles'; [EMAIL PROTECTED]
Subject: RE: Desi
> From: Lin Yu [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 28, 2003 9:33 PM
> To: [EMAIL PROTECTED]; 'mysqllist'
> Subject: RE: Design decision
>
>
> Lian,
>
> Between your design solutions (1) and (3), you need to decide,
> from the logical
> business
Lian,
Between your design solutions (1) and (3), you need to decide, from the logical
business requirement, whether the nature of the relationship between user and
group is one-to-many (a group may have many users, and each user may belong to
exactly one group) or many-to-many (a group may have ma
Sent: Tuesday, January 14, 2003 6:18 PM
> To: Ross Davis - DataAnywhere.net
> Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Design feature or bug
>
>
> On Tue, Jan 14, 2003 at 04:41:53PM -0800, Ross Davis -
> DataAnywhere.net wrote:
> >
> >
> &
On Tue, Jan 14, 2003 at 04:41:53PM -0800, Ross Davis - DataAnywhere.net wrote:
>
>
> I stand corrected. In a production environment a stopped server is as
> good as crashed.
Ah, good.
> I know why things work they way they do, but it would be nice to have an
> option to change the replication
> -Original Message-
> From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 14, 2003 4:00 PM
> To: Ross Davis - DataAnywhere.net
> Cc: [EMAIL PROTECTED]
> Subject: Re: Design feature or bug
>
>
> On Tue, Jan 14, 2003 at 0
On Tue, Jan 14, 2003 at 02:43:27PM -0800, Ross Davis - DataAnywhere.net wrote:
> I have a 3.23.53 server that is a slave of another 3.25.52 server.
> Master has 2 databases on it.
>
> On the slave only only one of the databases is replicated.
>
> If I reference the table database that is not on
I don't quite understand the distinction you are drawing between an "image"
and an "image_attrib". To what real-world concept does "image_attrib"
correspond?
I'd suggest that the entities in your system are:
Image: with fields such as title and [film type stuff]
Comment: with a field for the co
Usually I build my queries dynamically.
I store all the values into a hash ( this is in perl mind you.. )
Then do something like this..
my (@fields, @vals);
my ($field_str, $val_str);
foreach $field_name (keys %hash)
{
if ($hash{$field_name})
{
push @fields, $fie
Thank you for the information. Let me please clarify that i am using a
web form. I tried the one solution of converting those values that are
not set to null, but mysql complained:
SQL: INSERT INTO
Development_Event_Show(showID,venueID,description,ageCutoff,ageDelimiter,price1,price2)
VALU
On Friday 12 April 2002 8:10 pm, Carl Schmidt wrote:
> I have a form where a user enters some numbers into text boxes. Some of
> the text boxes can be left blank. The business logic receives all
> variables to all text boxes. Should I :
I'm assuming that you are using an executable file and NO
Hi dn, thanks for replying.
I suspect you're right about my 'problem' - I'm probably misunderstanding
some simple SQL construct :-)
Let's say I have the following tables:
parts (partid int, partname varchar(255))
cats(catid int, catname varchar(255))
parts_cats (id i
On Sat, Nov 03, 2001 at 12:07:03AM +, Manjeet Singh wrote:
> Hi Group,
>
> I am new to mysql, and would like you all to give some time in
> resolving my trouble. I am stuck up with a problem of designing
> stores database for a big company.The company is located in
> different places and want
Andrew Ward wrote:
> As I said, not all organisations were asked the same questions so I can't
> just put the data in directly
>
> The only way I can see of dealing with this is to create tables like
> ID,QUESTION,RESPONSE
> 1,"YEAR",2001
> 1,"SEX",1
>
> This doesn't strik
Andrew Ward writes:
> The only way I can see of dealing with this is to create tables like
> ID,QUESTION,RESPONSE
> 1,"YEAR",2001
> 1,"SEX",1
> 1,"AGE",3
> 1,"RATING A", 7
> 1,"RATING B", 6
> ...
>
> This doesn't strike me as very smart. I would greatly
you should Managing Users with PHP Sessions and MySQL
as per this tutorial:
http://www.webmasterbase.com/article.php?aid=319
then you will always have the $userid or $uid (or whatever you wanna call
it )from LOGIN when you need it as a key to restrict a given mysql user to
access only those rows
Hi Jeff,
If you visit my homepage at:
www.geocities.com/hisiomara
click "Tutorials" and select the first item "Team5.com an ecommerce sample"
you will be able to see the ERD diagram that attends your ecommerce demand.
Actually will will be able to see much more.
The design is there,and I wil
hi.
the easiest way is to have
an order table:
(orderID, customer, address, etc., etc.)
a item table:
(itemID, description, price, etc.etc.)
and an orderItems table:
(orderID, itemID)
this way you can
select i.description, i.price
from order o,
item i,
orderItems oi,
where o.orde
This looks like an order-lineitem situation, which I would imagine would
look like this:
ORDERS
ORDER_ID
CUSTOMER_ID
ORDER_DATE
LINEITEM
ORDER_ID
PRODUCT_ID
LINEITEM_QUANTITY
At 02:00 PM 6/18/2001 -0500, you wrote:
>I have a design problem I was hoping some of you could help me out
>with.
David Allen wrote:
>
> Hi,
>
> Because of various political issues during the development of our web
> site, it has been suggested that the web server and php scripts should
> be connected to the database server via a shared 2Meg WAN connection. As
> I am rather green when it comes to setting up
Hi,
> Because of various political issues during the development of our web
> site, it has been suggested that the web server and php scripts should
> be connected to the database server via a shared 2Meg WAN connection. As
> I am rather green when it comes to setting up internet sites which use
74 matches
Mail list logo
