Client-Server Database Question...
Results 1 to 4 of 4

Thread: Client-Server Database Question...

  1. #1
    Junior Member
    Join Date
    Jan 2002
    Posts
    9

    Client-Server Database Question...

    Is it possible that there would be conflict in server-side database when 2 or more clients send data at the same time??? is this situation possible??? should i make a code to schedule incoming data??? PLeaase HELP!!!!!
    \"We Jammin\'\"

  2. #2
    Yes, that's my CC number! 576869746568617's Avatar
    Join Date
    Dec 2003
    Location
    Earth
    Posts
    397
    What database engine? I don't know of any database issues. However, depending on the way the network is setup (repeating devices, switching fabric, transmission speed) you could be experiencing data collisions.
    Windows 9x: n. A collection of 32 bit extensions and a graphical shell for a 16 bit patch to an 8 bit operating system originally coded for a 4 bit microprocessor. Written by a 2 bit company that can\'t stand 1 bit of competition.


  3. #3
    Super Moderator: GMT Zone nihil's Avatar
    Join Date
    Jul 2003
    Location
    United Kingdom: Bridlington
    Posts
    17,192
    Hi this might be irrelevant, but it is the systems design/development view (applications software & database design) I will now put on my systems architect's hat.

    There are two issues that I am aware of:

    1. Object locking
    2. Record locking

    Any database worthy of the name will allow multiple users to access records in read only mode. Microsoft Access (hardly the strongest growth in the vinyard ) for example will warn you if someone has opened a record in "edit" mode and asks you if you want to make a copy of the record as it stands. By and large I would say that opening records should not be a problem.

    The issue is in creation, updating and deleting? (remember the CRUD matrix )

    Two people must not be allowed to create or update the same record at the same time, otherwise you have anarchy.

    Deletion is a slightly different problem? If someone is trying to update a record at the same time as someone is trying to delete it, then there is a serious flaw in your business process!

    So my basic conclusion is that if a record is being accessed in "edit" mode it should be locked from anything other than read only, and in some cases totally locked.

    Object locking is a different matter. Here the entire database or a table in it is locked. It can be a total lock, where all access is denied (other than the user working on it), or a partial lock.generally to allow people to read records not being edited.

    Your database engine should handle data entry such that each item gets a unique key.

    You need to set rules for CRUD, but your database should handle arrival sequencing on its own.

    Without more details of your requirements that is about all I can suggest.

    Cheers
    If you cannot do someone any good: don't do them any harm....
    As long as you did this to one of these, the least of my little ones............you did it unto Me.
    What profiteth a man if he gains the entire World at the expense of his immortal soul?

  4. #4
    Junior Member
    Join Date
    Jan 2002
    Posts
    9

    Smile ThanX Guys...

    Thanx for your insights....

    So Data collision is really possible ?
    And database engines does not automatically correct this possible errorsS?

    OK thnX again.....
    \"We Jammin\'\"

Posting Permissions

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

 Security News

     Patches

       Security Trends

         How-To

           Buying Guides