1 / 10

Storage & Retrieval 2 : Searching, Selecting & Sorting

Storage & Retrieval 2 : Searching, Selecting & Sorting. CORE 2: Information systems and Databases. Storage and Retrieval. In this part of the topic we said we would look at the following… Types of Storage Hardware Techniques for Data Security Searching, Selecting and Sorting.

chanda-kim
Télécharger la présentation

Storage & Retrieval 2 : Searching, Selecting & Sorting

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Storage & Retrieval 2:Searching, Selecting & Sorting CORE 2: Information systems and Databases

  2. Storage and Retrieval • In this part of the topic we said we would look at the following… • Types of Storage Hardware • Techniques for Data Security • Searching, Selecting and Sorting

  3. Searching, selecting and Sorting • Searching is looking through a collection of data in order to locate required data. Selecting is a combined process used to identify the data needing to be retrieved. eg. Looking for Year 7 students in Currey House • Sortinginvolves arranging a collection of items in some specified order eg. Alphabetical or Numerical. Sorted data is easier for people to understand and as such it becomes information (data with meaning). eg. Ordering Year 7 students in Currey house by alphabetical order A – Z.

  4. Searching, selecting and Sorting Tools for Database Searching and Retrieval - Indexes In a database table the order in which records are stored is entirely irrelevant. When a search is applied to a large database there are potentially thousands of records needing to be examined individually and in an unspecified order. The solution to this is indexes. Indexes are similar to that in a book, in that they give and ordered listing of areas where content can be found. Database indexes describe a particular record order without actually ordering or displaying the records. For example: An attribute of the index may be "sort order" which has cells beneath it specifying the organisational order for the fields listed in the index eg ascending or descending. The index is in order hence it can be used to quickly search through the data for records to be retrieved.

  5. Searching, selecting and Sorting Tools for Database Searching and Retrieval - SQL • QUERYis a search of a database for records that meet a certain condition. It is a question you ask the database. The results are usually displayed in a table but can be used as the basis for a form, report, graph or another query. A query can also update or delete multiple records at the same time and perform calculations on data. Queries are constructed in the form <Field name> <Operator> . The data is often called the criteria. A common method for constructing a query is query by example, which requires a user to enter the criteria against a field. If the search of a database involves two or more entities it is called a relational query.

  6. Searching, selecting and Sorting Tools for Database Searching and Retrieval - SQL • STRUCTURED QUERY LANGUAGE (SQL) is a query language used to access and manipulate data in a relational database. SQL statements contain keywords that are used to perform a particular task. When searching in SQL it is essential to use correct syntax. In most DBMSs keywords are in uppercase, fields are separated by commas, an entity and an attribute in that entity are separated by a fullstop, and the search criteria or data item is enclosed in double quotes. The keyword ORDER BY sorts on a field in ascending (ASC) or descending (DESC) order with ascending as the default.

  7. Searching, selecting and Sorting Tools for Database Searching and Retrieval - SQL SQL – Stands for (Structured Query Language). SQL statements are structured using the following: • SELECT – Attributes to retrieve (e.g. surname) • FROM – Table (database) • WHERE – Search criteria (e.g. client age > 15) • ORDER BY – Alphabetical etc.

  8. Searching, selecting and Sorting Tools for Database Searching and Retrieval - SQL ‘WHERE’ is the SQL statement that declares a criteria to be followed in order to complete the query. The following operators can be utilised as criteria for ‘WHERE’…

  9. Searching, selecting and Sorting Tools for Database Searching and Retrieval - QBE • QBE or Query by Example is a visual technique for specifying a database query. Common search criteria are entered into what appears to be an empty record, thus users do not need to understand the details of SQL. For example a modified QBE is used by most Internet Search engines. • In Access a simple QBE can be initiated using a ‘filter’ whilst more complex QBE can be utilised using the design view .

  10. Searching, selecting and Sorting Tools for Database Searching and Retrieval - QBE

More Related