If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Help with databse system

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-09-10, 12:45
xendeer xendeer is offline
Registered User
 
Join Date: Oct 2010
Posts: 3
question about databse system, structure

Hello,
I'm newbie in this branch(I worked shortly with mysql,postgresql) and I really don't know where begin .I started read a few books but I haven't seen table structure what I need.
Is it multidimensional structure on this picture?
application will be written in php and I don't know how database system choose.
Can you help me please ?
name of this table structure or name of db system which work with php(support structure what is on pict) will be suffice.

Regards,
Xendeer
Attached Thumbnails
Help with databse system-database.png  

Last edited by xendeer; 10-09-10 at 13:06.
Reply With Quote
  #2 (permalink)  
Old 10-09-10, 13:09
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
That is a very, very generic picture. There is no way to tell what you want to store, much less how you ought to store it.

Once you figure out what the data is, I'd use a table or multiple tables to store that kind of data.

After you have a better idea of what you want to store so you can give us some specific examples, then we can probably give you more specific suggestions.

-PatP
__________________
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
Reply With Quote
  #3 (permalink)  
Old 10-09-10, 14:18
xendeer xendeer is offline
Registered User
 
Join Date: Oct 2010
Posts: 3
thank you for reply,
It will be bigger database and data are mostly numbers.maybe Max. 40 character.
users will search these numbers.User select what he want search(select table) and which column.And then he can search.
Reply With Quote
  #4 (permalink)  
Old 10-09-10, 16:55
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
I would definitely use tables to store numbers, tables work really well for that.

-PatP
__________________
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
Reply With Quote
  #5 (permalink)  
Old 10-10-10, 13:20
xendeer xendeer is offline
Registered User
 
Join Date: Oct 2010
Posts: 3
ok great,
and it's possible create table design(structure) something like on picture, in mysql, postgresql or else?

Last edited by xendeer; 10-10-10 at 13:24.
Reply With Quote
  #6 (permalink)  
Old 10-10-10, 14:54
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
Using PHP or a similar programming tool you can make a table look like almost anything you can imagine.

-PatP
__________________
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On