Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    san jose, CA
    Posts
    68

    Unanswered: questions regarding oracle performance, security and architecture

    Dear Oracle group members:

    I have 3 questions regrading Oracle database, Please take a look and give me some suggestions.

    The scenario is based on a database designed for a class. The database keep track of students' name, grade, SSN etc.

    By the end of semester, this database is ued by whole school system.

    a) what kind of database design will improve the query performance when using average function to query the average score for students.

    b) This database is available for the whole shcool, students are granted permission to access their infromation, what kind of security measure need to be used to insure student's privacy.

    c) suppose this dababase system is implemented on a two tier architecture, what kind of software need to be installed to better sever the interaction between client and server.

    I appreciate your help
    sjgrad03
    2-09-04

  2. #2
    Join Date
    Aug 2003
    Location
    san jose, CA
    Posts
    68

    no one knows the answer:)

    sorry, guys this question won't be answered!

  3. #3
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    Hi sjgrad03,

    There is not any fixed answer for your questions. I need more information regarding this topic. Please call me on weekend, I will definately help you out.
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

Posting Permissions

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