Chapter 7

Most Modern database management programs support a standard language for programming complete queries called SQL
BQ: What does SQL stand for?
Personal information manager (PIM): an electronic organizer
-automates some or all or the following functions: address/phone book, appointmenr calender, to do list, miscellaneous notes
-handheld computers can share information with applications such as iCalender running on PCs and Macintoshes.
File Manager: enables users to work with one file a time
Database management system (DBMS): manipulates data in a large collection of data of files, cross-referencing between files as needed.
 -used interactively or can be controlled by other programs.
To most users, a relational database program is one that allows tables to be related to each other.
-changes in one table are reflected in other tables automatically
To computer scientists, the term relational database has a technical definition related to: the underlying structure of the data and the rules specifying how that data can be manipulated.

Chapter 7: Database Applications and Privacy Settings

Database: collection of information that has been organized in some fashion making it easy to reference and retrieve.
-->based on last name in combination with the first name
-->unique identifier is combination of two fields
BQ: What is a unique identifier?
Database: storage container for data
Google is one of the most successful companies on WWW.
-Search for Web pages, facts, quotes, etc.
-200 million queries
Launched by Sergey Brin and Larry Page
-Stanford PhD students
-new approach in seach technology
-marks a page relevence by the number of times other related web pages link to it, not how often a word appears)
BQ: Discuss Sergey Brin and Larry Page
A database: collection of information stored on computer disks
Database Software:
-application software
-Designed to maintain databases
Advantages offered by computerized databases:
-make it easier to store large quantities of information
-make it easier to retrieve information quickly and flexibly
-make it easy to to organize and reorganize information
Database Anatomy:
-Database programs: a software rool for organizing the storage and retrieval of information
-Database: a collection of information sored in an organized form in a comuter
--> typically composed of one or more tables or a collection of related information and records
 BQ: What is a database program?
A record is the information relating to one person, product, or event
BQ: What is a record?
-Each discrete piece of information in a record is a field.
The type of information a field can hold is determined by its Field Type or Data Type.
Database programs provide tou with more than one way to view data: Form views: show one record at a time or List Views: display several records in lists similar to the way a spreadsheet displays data.
In any view, fields can be rearranged without changing the underlying data
Import: recieve data in the form of text files
Browse: navigate through information
Query: find records that match specific criteria
Sort: rearrange records
Print reports, labels, and form letters: a report is an ordered list of selected records and fields in an easy to read format
1/8/11
-Google is one of the most successful companies on WWW.
--> search for web pages, facts, quotes, etc
--> 200 million queries a day
-Lauched by a Sergey Brin and Larry Page
--> new approach in seach technology
What good is a database:
Database: a collection of information stored on computer disks
Data: pieces of information
-A primary key uniquely identifies a record.
A table is a collection of records of the same type.
Advantages offered by databases:
--> easier to store large quantitites of information, retrieve information quickly and flexibly