Alpha Video Training
Results 1 to 10 of 10

Thread: Database Concepts

  1. #1
    "Certified" Alphaholic Charles Hoens's Avatar
    Real Name
    Charles Hoens
    Join Date
    Sep 2000
    Location
    Princeton, NJ
    Posts
    1,170

    Default Database Concepts

    Hello all!

    I've been with Alpha for a very long time now and I seem to remember discussion way back when about general database design. Specifically, there were some discussion about file locking, how users saved, the order they were saved for input, etc.

    I'm helping some students on this matter with some general background. Can anyone point me in the right direction as to where these threads might be? Are they archived or is there a general paper out there?

    Any help is greatly appreciated.

    Charlie

  2. #2
    "Certified" Alphaholic Ronald Anusiewicz's Avatar
    Real Name
    Ronald Anusiewicz
    Join Date
    Oct 2000
    Location
    Southampton, MA
    Posts
    1,565

    Default Re: Database Concepts

    You may find what you are looking for here.

    http://www.csda1.com/csda_codeutilit...lity_Tips.html
    Alpha Anywhere v3.5
    Version 12.3, Build 2999
    MySql56 & DBF's

    Alpha 4, 5, Anywhere

    Ron Anusiewicz

  3. #3
    "Certified" Alphaholic Charles Hoens's Avatar
    Real Name
    Charles Hoens
    Join Date
    Sep 2000
    Location
    Princeton, NJ
    Posts
    1,170

    Default Re: Database Concepts

    Thanks Ron. Still can't seem to find the "theory" part of dbf locking.

    Charlie

  4. #4
    "Certified" Alphaholic Ronald Anusiewicz's Avatar
    Real Name
    Ronald Anusiewicz
    Join Date
    Oct 2000
    Location
    Southampton, MA
    Posts
    1,565

    Default Re: Database Concepts

    Alpha Anywhere v3.5
    Version 12.3, Build 2999
    MySql56 & DBF's

    Alpha 4, 5, Anywhere

    Ron Anusiewicz

  5. #5
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,316

    Default Re: Database Concepts

    Look at the description of "optimistic" and "pesimistic" locking.
    Imho. Any record in change mode needs locking. This doesn't however overcome the problem of a LAN with a record being viewed.
    Example. 2 sales people, 1 sales item.
    Both look at the item while on the phone to a customer, one grabs it but the other users screen still shows one available. When he goes to grab it, it's gone.
    Updating continuously is problematic, so a refresh on data entry could assist.
    It's always been a problem in multi user environments.
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

  6. #6
    "Certified" Alphaholic Charles Hoens's Avatar
    Real Name
    Charles Hoens
    Join Date
    Sep 2000
    Location
    Princeton, NJ
    Posts
    1,170

    Default Re: Database Concepts

    Thanks Ron. This is good!

    Charlie

  7. #7
    "Certified" Alphaholic Ted Giles's Avatar
    Real Name
    Ted Giles
    Join Date
    Aug 2000
    Location
    In the Wolds, Louth, Lincolnshire, UK
    Posts
    4,316

    Default Re: Database Concepts

    You might want to look at the dates when Ira's article was published.
    I suspect this has been overtaken by technological events.
    Still, it's Alpha V4 and V5 specific so good luck with it.
    Ted Giles
    Example Consulting - UK
    .

    http://ec12.example-software.com//
    See our site for Alpha Support, Conversion and Upgrade.

  8. #8
    "Certified" Alphaholic
    Real Name
    Tom Cone Jr
    Join Date
    Apr 2000
    Location
    Florida
    Posts
    23,307

    Default Re: Database Concepts

    Charles, here's an excellent easy to read book on the subject.

    Data entry using DBF tables is old-school and relies on file locks behaving correctly on the machine acting as server.

    SQL data entry takes different approach entirely, relying on a client-server paradigm (sp?).
    Last edited by Lenny Forziati; 01-02-2019 at 11:16 AM.

  9. #9
    Member
    Real Name
    Sean OKelly
    Join Date
    Sep 2015
    Location
    Charleston, WV
    Posts
    216

    Default Re: Database Concepts

    Cut your losses. Get away from DBF and use a DB Server (such as mysql, sqlserver, oracle, etc.). In today's environments there are just to many issues with file based db's.

  10. #10
    "Certified" Alphaholic kkfin's Avatar
    Real Name
    Kenneth
    Join Date
    Dec 2006
    Location
    EU
    Posts
    1,525

    Default Re: Database Concepts

    Many times DB server (such as mysql, sqlserver, oracle, etc.) is not an option or is just an overkill. Then SQLite walks in.

Similar Threads

  1. Copying tables/sts Forms or code from database A to database B
    By DonWalton in forum Windows Desktop Applications
    Replies: 3
    Last Post: 02-12-2018, 11:42 AM
  2. Replies: 3
    Last Post: 09-30-2014, 01:42 PM
  3. connection string for creating a database from imported data (Mysql database)
    By mdadvice in forum Alpha Five Version 10 - Desktop Applications
    Replies: 2
    Last Post: 02-27-2012, 05:22 PM
  4. Process for incorporating sample database into my test database?
    By ken doucet in forum Alpha Five Version 7
    Replies: 2
    Last Post: 07-08-2006, 11:20 AM
  5. Database concepts
    By ddavidc3 in forum Alpha Five Version 4
    Replies: 2
    Last Post: 01-26-2001, 09:26 PM

Bookmarks

Posting Permissions

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