Basic Database Terminology - Revision history

Russ hensel at 15:31, 3 December 2019

2019-12-03T15:31:41Z

Russ hensel: /* Work Flow Overview */

2019-12-02T15:54:18Z

Work Flow Overview

Russ hensel: Created page with "= Work Flow Overview = == Just a bit of theory the may be helpful - Some Definitions == Databases These encode data in a structured and efficiently searchable format. I..."

2019-12-02T15:52:24Z

Created page with "= Work Flow Overview = == Just a bit of theory the may be helpful - Some Definitions == Databases These encode data in a structured and efficiently searchable format. I..."

New page

= Work Flow Overview =

== Just a bit of theory the may be helpful - Some Definitions ==

Databases
These encode data in a structured and efficiently searchable format. It also easily select subsets of
data and can sort those results. There are lots of different kinds, but one fairly standard one is a SQL or
relational database.

Database File
The file ( or one of the files ) where database information is kept. We are using sqllite, which keeps a whole database
in one file. This makes it very easy to move and/or backup a database.

Table, Record, Column
in a SQL data base data is stored in Tables ( many tables may be put in one database ). A table consists of records ( also called rows. ) Each row is information about some "thing". For example if the "thing" is a person a record
might contain the person's first name, last name, date of birth.... The table is much like a spread sheet with
the information on each person in a row. Each of the items ( first name, last name, date of birth.... ) is called a column.

SQL - Structured Query Language
This is the language used by relational databases. Typically the system generated the required SQL and runs
it. The user interface often shows the SQL which is quite a bit easier to read than it is to write.
It may give you useful feedback on what the system is doing.

[[Category:Python Easy DB]]

@@ Line 21: / Line 21: @@
 it.  The user interface often shows the SQL which is quite a bit easier to read than it is to write.
 It may give you useful feedback on what the system is doing.
 [[Category:Python Easy DB]]

@@ Line 1: / Line 1: @@
-Databases
+=  Just a bit of theory the may be helpful - Some Definitions  =
-Database File
+== Databases ==
-    The file ( or one of the files ) where database information is kept.  We are using sqllite, which keeps a whole database
+These encode data in a structured and efficiently searchable format.  It also easily select subsets of
-    in one file.  This makes it very easy to move and/or backup a database.
+data and can sort those results.  There are lots of different kinds, but one fairly standard one is a SQL or
-Table, Record, Column
+== Database File ==
-    in a SQL data base data is stored in Tables ( many tables may be put in one database ).  A table consists of records ( also called rows. )  Each row is information about some "thing".  For example if the "thing" is a person a record
+The file ( or one of the files ) where database information is kept.  We are using sqllite, which keeps a whole database
-    might contain the person's first name, last name, date of birth.... The table is much like a spread sheet with
+in one file.  This makes it very easy to move and/or backup a database.
-SQL - Structured Query Language
+== Table, Record, Column ==
-    This is the language used by relational databases.  Typically the system generated the required SQL and runs
+in a SQL data base data is stored in Tables ( many tables may be put in one database ).  A table consists of records ( also called rows. )  Each row is information about some "thing".  For example if the "thing" is a person a record
-    it.  The user interface often shows the SQL which is quite a bit easier to read than it is to write.
+might contain the person's first name, last name, date of birth.... The table is much like a spread sheet with
-    It may give you useful feedback on what the system is doing.
+the information on each person in a row.  Each of the items ( first name, last name, date of birth.... ) is called a column.
 [[Category:Python Easy DB]]