1 / 14

Agenda

Agenda. TMA02 M877 Block 1 - Foundations. Requirements for New Database Technology. Multiple Databases Block 2 - Distributed Data Management Additional Data Requirements Block 3 – Databases with Objects Block 4 – Databases with Multimedia Developments in Using Data

osmond
Download Presentation

Agenda

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. Agenda • TMA02 • M877 Block 1 - Foundations

  2. Requirements for New Database Technology • Multiple Databases • Block 2 - Distributed Data Management • Additional Data Requirements • Block 3 – Databases with Objects • Block 4 – Databases with Multimedia • Developments in Using Data • Block 5 – Decision Support Systems

  3. Why Multiple Databases? • User want direct control of own data • Purchase of third-party software package • An organisation may develop a number of systems with separate databases.

  4. Why Multiple Database? • Off-line/remote access/update of data. • Replicated Database System

  5. Basic Replication

  6. Uses of Basic Replications • Information distribution • Information off-loading

  7. Advanced Replication

  8. Composite Value • Composite value is composed of a number of parts. • For example, address is composed of flat/room, floor, block, building/estate, street and district. • It needs to be a single value in order to be perceived as a unit for updating, and to preserve the relational principle of only having an atomic value for each column in a row. • It needs to be a composite value so that it can have a number of parts, together with functions to extract from that value the parts we need to use in queries.

  9. Complex Data • Document, e.g. txt, doc, pdf etc • Image • Audio • Video

  10. Developments in Using Data • Decision support system • Use data as an information resource rather than just to support the daily operation of an organization • Develop a separate database specially designed to satisfy decision support requirements, which is known as data warehouse/data mart. • Characteristics of data warehouses are:- • Massive data • Queries are mainly concerned with trends and summaries of data over time (OLAP) • Design needs to allow for the specialized usage. • Find 'rules' about certain properties of the data in some table of data – data mining.

  11. Accessing Databases Using the Web – Static Pages

  12. Accessing Databases Using the Web – Dynamic Pages

  13. Using Java • JDBC – Java Database Connectivity • SQLJ • JDO – Java Data Object

  14. Special-purpose Database Systems • Repositories • Temporal databases • Spatial databases • Logic databases • Document databases • Multimedia databases

More Related