Mindmap
Lesson 11 - Data Storage
Inhalt der Mindmap
Lesson 11 - Data Storage
All the ways in which data is held, holding data on a computer system using databases (a simple collection of data organized)
Database structure is made up of data about customers/products that are stored in a table. Every row in the table holds information about a single item (called a record). Every column holds information about a property of the items in the table, such as the customer's name or an item's price (called fields)
Databases
- Table
- A representation of data in a database
- Record
- A group of selected data which are associated in some way
- Field
- A single piece of data within a record
- Relationship
- The link using a foreign key - a benefit of databases where the information they hold can be assessed.
- Data Type
- Each field in a set up to hold certain types of data
- Table
Data types that are used in databases
- Number (price)
- Text (someone's name)
- Date/time
- Logical (true/false)
Primary Key
- A single unique key used to identify each record in a table
Foreign Key
- A field which can be used to cross-reference and access associated information across many tables
Online databases are databases which are accessible using a network, including the internet. They are very different to local databases as they have to be accessed, and possibility updated, by millions of users. Normally, these databases will have thousands of rows of information. Usually information is found in online databases by using a search engine.
Database Management Systems (DBMS)
- Programs which allow you to create any database that you need and to use the databases you have created. The DBMS allows you to create, maintain, search and sort data on a database. It allows different users to access the database at the same time, and can provide different levels of access to the data.
Common database management systems
- Structured Query Language (SQL)
- High level language used to undertake this management activity.
- Data Definition Language (DDL)
- Used to define the database structure.
- Data Manipulation Language (DML)
- Used to add, delete, change, and query the data which is held in the database structure.
- Structured Query Language (SQL)
Informationen
- Beschreibung
- Mindmap am Lesson 11 - Data Storage, erstellt von Ellen Greenough am 21/06/2014.
- Erstellt von
- Ellen Greenough
- Aufrufe
- 22
- Bewertung