|
More site info...
Database Concepts & Design | Forum profile
|
|
Forum profile page for Database Concepts & Design on http://www.dbforums.com.
This report page is the aggregated overview from a single forum: Database Concepts & Design, located on the Message Board at http://www.dbforums.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Database Concepts & Design" on the Message Board at http://www.dbforums.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Database Concepts & Design:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
28
|
113
|
277
|
|
Post:
|
63
|
381
|
1,022
|
|
|
Database Concepts & Design Posting activity graph:
|
Top authors during last week:
user's latest post:
Erd..n stuff
Published (2009-11-30 17:33:00)
To answer your question properly would require about 20 hours of work. I charge $125 an hour for my time, and my guess is you don't have the $2,500 to cover my effort. Five minute questions I answer for free, beyond that you pay.
user's latest post:
Designing a dB, looking for any...
Published (2009-11-27 05:29:00)
Hi, Laurent, thanks for the reply. So what you are basically saying is that there is no nautural key in the customer table. But what about a userId that the user enters. Is that a natural key or not? We must have things that distinguish one customer from the other, that makes them unique. But maybe it is as Mark said earlier. It's up to the user or constratints in the application that will sort out things like customers being named same...
user's latest post:
2 Syncronized databases
Published (2009-11-29 12:08:00)
Nearly every database server offers some feature like what you've described. Microsoft also offers clustering, mirroring, and merge replication. Oracle offers RAC. DB2 offers clustering. Sybase offers several solutions, based on which database engine you're using. My experiences with MySQL clustering haven't been very good. I'd suggest that you at least review your other options before you make a commitment. -PatP
user's latest post:
More columns <-> more joins
Published (2009-11-29 02:30:00)
Quote: Originally Posted by verellen Hey all, I have the following question: When designing a database, qua performance, which is the best senario: Having a table with lots of columns, so you do not have to use many joins. Or storing your data in seperated tables, which is more clarifying and flexible, but when you need to gather the data, you'll have to use more joins. When does having a lot of joins have affect on the performance?...
user's latest post:
Designing a dB, looking for any...
Published (2009-11-27 12:58:00)
Not a natural key ? Well, if you want, but I am very uneasy with this vocabulary. Because, this concept, as many others, is formally defined on a finite set of things and properties you've defined before, so to speak, the abstract picture of some reality you want to manage. As all abstract models, our softwares don't reflect exactly reality and all its features. We have to simplify things to manage them. How much ? There's no...
user's latest post:
difference between some relation
Published (2009-11-30 09:25:00)
Nobody expects perfection. However I do think it's reasonable to ask database software vendors to show some improvement in basic features after more than 30 years! Especially when you consider the outstanding innovations in other fields of IT during that same period. Commercial DBMS technology has stagnated and shown very little improvement in core features during the last three decades. Part of the reason is of course the cosy vested...
user's latest post:
Commitment ordering
Published (2009-12-01 01:35:00)
By googling, the name Commit ordering is almost equally used for Commitment ordering .
user's latest post:
Erd..n stuff
Published (2009-12-01 00:39:00)
Robbery. I will do your homework for you for $120 per hour. Spell-checking would be extra, though.
user's latest post:
2 Syncronized databases
Published (2009-11-29 15:48:00)
Ok, thanks for you reply! It will be kind if you can maybe answer my second question: What about working offline, If I would like to work offline with some SQL server, and when i get online, my application will execute all INSERT Queries. Do you know about any API that do that? virtual server on the client that can do that? or any buffer that can help? Thanks in advance!
|
|
|
|
Latest active threads on Database Concepts & Design::
Started 1 week, 3 days ago (2009-11-24 08:02:00)
by andrewst
Haven't a clue what you are talking about. Want to post that Wikipedia link?
Started 4 days, 4 hours ago (2009-11-30 14:50:00)
by blindman
I'm assuming you are not doing well in your English class either.
Started 6 days, 21 hours ago (2009-11-27 22:25:00)
by Pat Phelan
Depending on which tools you are using, this can be normal. Not all tools recognize or enforce cardinality rule differences like that.
-PatP
Started 5 days, 13 hours ago (2009-11-29 06:04:00)
by liorm
Ok, MySQL Cluster is what I was looking for.
Hope also helped other
Started 1 week ago (2009-11-27 09:17:00)
by gvee
Moving to Database Concepts & Design - dBforums
Started 1 week, 2 days ago (2009-11-25 09:39:00)
by MarkATrombley
I am not familiar with the term mediated virtual database, but have done what you describe using a database that contains nothing but views to other databases. In SQL-Server you define a set of linked servers (connections to the other servers and databases) then build a view that selects from the linked servers. If the databases are all on the same server it is even easier, you just define views ...
Started 6 days, 15 hours ago (2009-11-28 04:16:00)
by Pat Phelan
OLTP is for transactional systems, such as you would find on a baseball coach's "play sheet". It shows every pitch, swing, etc. because the coach needs to look at that level of detail... They need to know which players bat well agains left handed pitchers and whne an opposing left fielder frequently fails to catch balls hit by right handed batters.
OLAP is for analytical systems, such as ...
Started 1 month, 2 weeks ago (2009-10-15 18:14:00)
by newbie_dev
Hi Mark,
If you are still available for any help, could you tell me if this is the right start? Or if there is anything you would suggest changing.
Thank you sir,
Jason
Code:
/*
** -------------------------------------------------- --------------------------
** script to create the region table
** -------------------------------------------------- ------------------------*/
DROP...
Started 1 week, 3 days ago (2009-11-24 05:04:00)
by MarkATrombley
Yes, it makes sense. You are also going to want a Supplier table and add Supplier_ID to the Price_Table.
Started 1 week, 1 day ago (2009-11-25 20:43:00)
by sco08y
What's the difference between random seek time (the time it takes for the drive head to move halfway across the platter, plus rotation time) vs. sequential seek time (the time it takes the head to move one track)?
Probably a lot less than the capacity of this person to imagine that his system is running slower.
Quote:
My thinking is that when the files are ...
|
|
Hot threads for last week on Database Concepts & Design::
Started 6 days, 21 hours ago (2009-11-27 22:25:00)
by Pat Phelan
Depending on which tools you are using, this can be normal. Not all tools recognize or enforce cardinality rule differences like that.
-PatP
Started 1 week, 2 days ago (2009-11-25 09:39:00)
by MarkATrombley
I am not familiar with the term mediated virtual database, but have done what you describe using a database that contains nothing but views to other databases. In SQL-Server you define a set of linked servers (connections to the other servers and databases) then build a view that selects from the linked servers. If the databases are all on the same server it is even easier, you just define views ...
Started 1 month, 2 weeks ago (2009-10-15 18:14:00)
by newbie_dev
Hi Mark,
If you are still available for any help, could you tell me if this is the right start? Or if there is anything you would suggest changing.
Thank you sir,
Jason
Code:
/*
** -------------------------------------------------- --------------------------
** script to create the region table
** -------------------------------------------------- ------------------------*/
DROP...
Started 1 week ago (2009-11-27 09:17:00)
by gvee
Moving to Database Concepts & Design - dBforums
Started 4 days, 4 hours ago (2009-11-30 14:50:00)
by blindman
I'm assuming you are not doing well in your English class either.
Started 5 days, 13 hours ago (2009-11-29 06:04:00)
by liorm
Ok, MySQL Cluster is what I was looking for.
Hope also helped other
Started 6 days, 15 hours ago (2009-11-28 04:16:00)
by Pat Phelan
OLTP is for transactional systems, such as you would find on a baseball coach's "play sheet". It shows every pitch, swing, etc. because the coach needs to look at that level of detail... They need to know which players bat well agains left handed pitchers and whne an opposing left fielder frequently fails to catch balls hit by right handed batters.
OLAP is for analytical systems, such as ...
Started 1 week, 3 days ago (2009-11-24 05:04:00)
by MarkATrombley
Yes, it makes sense. You are also going to want a Supplier table and add Supplier_ID to the Price_Table.
Started 1 week, 1 day ago (2009-11-25 20:43:00)
by sco08y
What's the difference between random seek time (the time it takes for the drive head to move halfway across the platter, plus rotation time) vs. sequential seek time (the time it takes the head to move one track)?
Probably a lot less than the capacity of this person to imagine that his system is running slower.
Quote:
My thinking is that when the files are ...
Started 1 week, 3 days ago (2009-11-24 08:02:00)
by andrewst
Haven't a clue what you are talking about. Want to post that Wikipedia link?
|
|