Skip to main content

2021 | Buch

Concise Guide to Databases

A Practical Introduction

insite
SUCHEN

Über dieses Buch

Modern businesses depend on data for their very survival, creating a need for sophisticated databases and database technologies to help store, organise and transport their valuable data.
This updated and expanded, easy-to-read textbook/reference presents a comprehensive introduction to databases, opening with a concise history of databases and of data as an organisational asset. As relational database management systems are no longer the only database solution, the book takes a wider view of database technology, encompassing big data, NoSQL, object and object-relational, and in-memory databases. Presenting both theoretical and practical elements, the new edition also examines the issues of scalability, availability, performance and security encountered when building and running a database in the real world.
Topics and features:
Presents review and discussion questions at the end of each chapter, in addition to skill-building, hands-on exercisesProvides new material on database adaptiveness, integration, and efficiency in relation to data growthIntroduces a range of commercial databases and encourages the reader to experiment with these in an associated learning environmentReviews use of a variety of databases in business environments, including numerous examplesDiscusses areas for further research within this fast-moving domain
With its learning-by-doing approach, supported by both theoretical and practical examples, this clearly-structured textbook will be of great value to advanced undergraduate and postgraduate students of computer science, software engineering, and information technology. Practising database professionals and application developers will also find the book an ideal reference that addresses today's business needs.

Inhaltsverzeichnis

Frontmatter

Databases in Context

Frontmatter
1. Data, An Organisational Asset
Abstract
What the reader will learn.
Konstantinos Domdouzis, Peter Lake, Paul Crowther
2. A History of Databases
Abstract
What the reader will learn.
Konstantinos Domdouzis, Peter Lake, Paul Crowther
3. Physical Storage and Distribution
Abstract
What the reader will learn:
Konstantinos Domdouzis, Peter Lake, Paul Crowther

Database Types

Frontmatter
4. Relational Databases
Abstract
What the reader will learn:
Konstantinos Domdouzis, Peter Lake, Paul Crowther
5. NoSQL Databases
Abstract
What the reader will learn:
Konstantinos Domdouzis, Peter Lake, Paul Crowther
6. Big Data
Abstract
What the reader will learn:
Konstantinos Domdouzis, Peter Lake, Paul Crowther
7. Object and Object Relational Databases
Abstract
What the reader will learn:
Konstantinos Domdouzis, Peter Lake, Paul Crowther
8. In-Memory Databases
Abstract
What the reader will learn:
Konstantinos Domdouzis, Peter Lake, Paul Crowther
9. Hierarchical Databases
Abstract
What the reader will learn:
Konstantinos Domdouzis, Peter Lake, Paul Crowther
10. Distributed Databases
Abstract
The different types of Distributed Databases
Konstantinos Domdouzis, Peter Lake, Paul Crowther
11. Graph Databases
Abstract
The anatomy of Graph Databases.
Konstantinos Domdouzis, Peter Lake, Paul Crowther

What Database Professionals Worry About

Frontmatter
12. Database Scalability
Abstract
That the number of concurrent users is one important aspect of scalability.
Konstantinos Domdouzis, Peter Lake, Paul Crowther
13. Database Availability
Abstract
That we should not expect our databases to be always available.
Konstantinos Domdouzis, Peter Lake, Paul Crowther
14. Database Performance
Abstract
What the reader will learn:
Konstantinos Domdouzis, Peter Lake, Paul Crowther
15. Security
Abstract
The importance of database security.
Konstantinos Domdouzis, Peter Lake, Paul Crowther
16. Database Adaptiveness and Integration
Abstract
What Database Adaptiveness is.
Konstantinos Domdouzis, Peter Lake, Paul Crowther

Advanced Applications of Specialised Databases

Frontmatter
17. Blockchain
Abstract
Blockchain is a digital ledger of economic transactions that is constantly updated by an unlimited number of users and it is considered impossible to corrupt. It is a list of continuous records in blocks. Blocks hold sets of transactions and they connected to the previous blocks. A block is also time stamped (Carlozo 2017). Blocks are chained with each other through hash identifiers. The complete blockchain is copied in a number of places in the network and this makes blockchain a distributed database (Bozic et al. 2016).
Konstantinos Domdouzis, Peter Lake, Paul Crowther
18. Biological Databases
Abstract
Bioinformatics is the application of computing in the storage and analysis of vast amount of biological data. These data are available as sequences and protein and nucleic acid structures. Sequences are represented as single dimensions while a structure includes three-dimensional data of sequences. A biological database organises its data in such a way so that they can be easily accessed and analysed. Biological databases can be classified into sequence and structure databases. Sequence databases are applied to both protein and nucleic acid sequences while protein databases are applied only to proteins. The first database was developed after the insulin protein sequence was made available back in 1956. Insulin was the first protein to be sequenced. During the sixties, the first nucleic acid sequence of Yeast tRNA was developed. There was development of three-dimensional structures of proteins and the Protein Data Bank was established with only 10 entries. This database has evolved to a large database with over 10000 entries. In 1986, the SWISS-PROT protein sequence database was developed and it has about 70000 protein sequences that cover more than 5000 model organisms ((Babu 1997).
Konstantinos Domdouzis, Peter Lake, Paul Crowther
19. GIS Databases
Abstract
Geographical Information Systems apply computer technology for the purpose of capturing, storing, handling, modelling and analysing information related to the surface of the Earth. The purpose of GIS is to help different specialties focused on nature to perform their operations better. Biologists examine the changes in the populations of amphibian species in forests and natural hazard analysts identify the risk areas generated by monsoon-related flooding through the examination of rainfall patterns and terrain features. GISs can help geological engineers to identify the best areas for the construction of buildings in earthquake-prone areas through the examination of the characteristics of the formation of rocks. A mining engineer is interested in the determination of which mines should be selected for further exploration while a geoinformatics engineer may use GISs in order to specify which are the best sites for the placement of a telecommunications company’s relay stations. GIS may be used by geological engineers in order to identify the best locations for the construction of buildings in an area affected by earthquakes. Also, geoinformatics engineers can determine the best locations for a telecommunications company’s relay stations. A forest manager can optimize timber production through the use of data on soil and tree stand distributions while trying to preserve species diversity in the area (Goodchild 2007).
Konstantinos Domdouzis, Peter Lake, Paul Crowther
Backmatter
Metadaten
Titel
Concise Guide to Databases
verfasst von
Dr. Konstantinos Domdouzis
Peter Lake
Dr. Paul Crowther
Copyright-Jahr
2021
Electronic ISBN
978-3-030-42224-0
Print ISBN
978-3-030-42223-3
DOI
https://doi.org/10.1007/978-3-030-42224-0