The KIPHS team would like to provide its current users and potential buyers with the best information and support we can.

What's a Database?

You can think of a database as a bunch of spreadsheets (like Excel) combined into one huge file.  Each of those spreadsheets (called tables in the database) contains information about a certain area.  For example, there might be one table for client information, one for addresses, one for services, etc...

Now, what does that table look like?  Here's an example:

CLIENT table

LAST NAME

FIRST NAME

MIDDLE INITIAL

SSN

BIRTHDATE

HAT SIZE

SHOE SIZE

Smith

John

C

111-11-1111

01/10/1969

7

13

Public

John

Q

222-22-2222

02/10/1961

8

11

Brown

John

C

333-33-3333

03/10/1989

5

10

Stevens

Jane

R

444-44-4444

04/10/1968

6

9

Each row (or record in the database) is about one person.  It has a column (or field in the database) for each bit of information about those people.

What is source code?

Source code, or programming language, is what we geeks use to access the information in the database (that thing up above).  Let's say I want to see the Last Name, Hat Size and Shoe Size of each person named John born after 1965.  This would be the code to do it:

FOR EACH client

  WHERE first-name = "John"

        AND birthdate > 12/31/1964:

  DISPLAY last-name hat-size shoe-size.

END.

 

Here's what we would see:

 

Smith        7    13

Brown       5    10

 

 

What this means, in English, is simple.  It will look at the above table (the client table), and go through all of the records that have the first-name of "John", and that have a birth date later than the last day of 1964, and it will display the hat size of the records it finds.

 

Now, the above is 5 lines of code.  Well, guess what...KIPHS has over 330,000 lines of code in it.  Now do you feel sorry for the programmers?  Didn't think so.

 

Well, I hope you enjoyed the little explanation, or at least you got a good laugh about it.  Enjoy the software!

 

kiphs@kiphs.com

p. 1.877.905.4747 or 1.877.90KIPHS

f. 316.682.0905

 

400 N. Woodlawn Suite 1

Wichita, KS 67208