Editing Basic Database Terminology
Jump to navigation
Jump to search
Warning: You are not logged in. Your IP address will be publicly visible if you make any edits. If you log in or create an account, your edits will be attributed to your username, along with other benefits.
The edit can be undone. Please check the comparison below to verify that this is what you want to do, and then save the changes below to finish undoing the edit.
Latest revision | Your text | ||
Line 1: | Line 1: | ||
+ | = 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 | |
− | in | + | 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. | |
− | |||
− | |||
− | 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. | ||
== Text File == | == Text File == |