SQL Server Database Recovery

Exactly what is a database? A database is an organized collection of information arranged so that it is easy to obtain information. It is a program that lets you add, delete, and change data in the database. A database is stored on a computer; it is not a combination of written paper records and computer records. An example of a database you may find in the library is ProQuest.

A database is made up of records and fields. Each record represents a single source. A record is made up of a set of fields that have the individual elements of information. For example, a record in ProQuest will have the title of an article or book, the name of the author, the date, and so on.

Every field is made up of words and numbers. When searching in a database, you have the option of controlling searches by looking for words in a specific field.

Examples of databases:

• phonebook
• library search engines like ProQuest
• list of company equipment and where it’s located
• CD collection

Types of databases:

Relational databases: this is a collection of data organized as a set of formally described tables where data can be accessed or reassembled in different ways without having to re-organize the database tables.

Object databases: this database stores large amounts of structured data that is accessed quickly and easily.

Network databases: each record in this database system can have multiple owners, i.e. orders are owned by both customers and products.

Hierarchical databases: in this database system, records are linked together like on a family tree so that each record type has only one owner (the opposite of network databases).