Zusammenfassung der Ressource
4d Distributed Databases
- Partitioned Database
- Horizontal Partitioning
- Data is separated based on records.
e.g. all records with one specific
attribute are stored in one place
- Each site can search from it's own
records locally but have to use
global search to find other records
- Vertical Partitioning
- Data is separated based on fields.
e.g. ID and one certain field is
stored in one place.
- Different parts of the data
stored at different sites
- "Sites" can be a server
or computer at a
particular location
- Replicated Databases
- Entire database is copied for each site
- Central databases with
Remote Local Indexes
- One central database is
stored in one location.
- Indexes mean that when the record is
searched for locally a request for the
record is sent to the central data base
- Indexes have the primary key used
to identify records locally and a
foreign key, which is the primary key
in the central database