Results 1 to 13 of 13
  1. #1
    Join Date
    Dec 2010
    Posts
    3

    Thumbs up Unanswered: Database Design and Storage Question

    hi
    I am naive in the amazing field of Database. I am requesting information for my two questions, i do not know if these can be termed as valid questions but i would appreciate help on them. thanks in advance.

    1) How is a database designed? Is a programming Language used to Design a database? What software and OS are used when first designing a database?

    2) When a database is involved it occupies say 50 gb of space in the hard drive.
    But we can store more than 1000's of large records in the same database.
    My question is how is the data stored in the Database? i mean is the data stored in the Hard Drive? does the database use some other storage methods?

    Lastly, how are the records stored in the Database. are they in a binary format? or in some other format.

    Please help!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >1) How is a database designed?
    research Third Normal Form

    > Is a programming Language used to Design a database?
    No

    >What software and OS are used when first designing a database?
    RDBMS database & SQL are Operating System independent
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Dec 2010
    Posts
    3
    Hi
    thank you for the reply.
    Please tell , how is the data stored in the database. Is the data stored inside the Hard Disc or somewhere else on the memory.

    Please help.

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Please tell , how is the data stored in the database.
    Stored in proprietary format.

    > Is the data stored inside the Hard Disc or somewhere else on the memory.
    yes

    Is GOOGLE broken for you?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Dec 2010
    Posts
    3
    Such Proudness is uncalled for.If i had to do google then i would have. I wanted some one with real experience in helping me.

    shame on you .. Not only are you an IDIOT But By Trying to be an Ass you have brought shame on to your Race and Culture.

    With Members like you in i do not mind cancelling my Membership.. ASSHOLE..

  6. #6
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Quote Originally Posted by kashikarr View Post
    Such Proudness is uncalled for.If i had to do google then i would have. I wanted some one with real experience in helping me.

    shame on you .. Not only are you an IDIOT But By Trying to be an Ass you have brought shame on to your Race and Culture.

    With Members like you in i do not mind cancelling my Membership.. ASSHOLE..
    While I agree that anacedent's postings are not very polite, your tone is absolutely not acceptable.
    You are now on my ignore list

  7. #7
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Read the concepts manual, it explains everything about oracle databases.

    Contents
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  8. #8
    Join Date
    Dec 2010
    Posts
    5
    Quote Originally Posted by kashikarr View Post
    Hi
    thank you for the reply.
    Please tell , how is the data stored in the database. Is the data stored inside the Hard Disc or somewhere else on the memory.

    Please help.
    Hi kashikarr,
    data in oracle data base will be stored in sga and pga sga is for shared global area and the data here will be stored tempoary buffers and later the data will be stored to the disk only after performing 'commit' statement .

  9. #9
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >later the data will be stored to the disk only after performing 'commit' statement .
    If have a DML that changes LOTS of data, more than RAM, what happens to this data & where does changed data go prior to any COMMIT being issued?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  10. #10
    Join Date
    Dec 2010
    Posts
    5
    Quote Originally Posted by anacedent View Post
    >later the data will be stored to the disk only after performing 'commit' statement .
    If have a DML that changes LOTS of data, more than RAM, what happens to this data & where does changed data go prior to any COMMIT being issued?
    sir initially every data will be stored in buffer caches like library cache , data dictionary cache, db buffer cahce...etc . so if any changes have done then tht date will be stored in redo logs.let me know if u have any questions

  11. #11
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >sir initially every data will be stored in buffer caches like library cache , data dictionary cache, db buffer cache

    All those reside in RAM.
    The amount of changed data EXCEEDS total RAM, so where does all this changed data exist?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  12. #12
    Join Date
    Dec 2010
    Posts
    5
    Quote Originally Posted by anacedent View Post
    >sir initially every data will be stored in buffer caches like library cache , data dictionary cache, db buffer cache

    All those reside in RAM.
    The amount of changed data EXCEEDS total RAM, so where does all this changed data exist?
    while installing database, we will allocate some memory for sga and pga and for that we will allocate memory with some calculations. if memory is not sufficient then it will throw error msg then we will monitor db to get available free memory. in oracle we have large pool which provides memory for required

  13. #13
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    I'll make the question SIMPLE for you.

    Assume system has 1GB of RAM.
    Can a single INSERT (prior to COMMIT) statement add 1.5GB (or more) of new data to the database?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •