Overview of database systems Flashcards
What does DBMS ?
Software or technology used to manage data from database.
What does Hierarchical database do ?
Follows the progression of data being categorised in ranks or levels, where in data is categorized by a common point of linkage.
What do DBMS do ?
Store, organise and access data
How the ranking in a Hierarchical database work ?
Two entities of data will be lower in rank, and the commonality would assume a higher rank.
What is the disadvantage of Hierarchical database ?
Not easily salable
Why is Hierarchical database not easily salable ?
because the addition of data elements requires lengthy traversal through the database.
What kind of records are allowed in Network Database?
Multiple parent and child records
Which database allow for more natural relationship between records and entities ?
Network Database
What form for relationships represents Network database ?
net-like form where a single element can point to multiple data elements and can itself be pointed to by multiple data elements.
What are the capabilities of Information in Object-Oriented database?
database is capable of being represented as an object which response as an instance of the database model.
What is Berkeley DB Software library ?
embedded database software library for key/value data
How is information in the Relational database connected ?
Every piece of information has a relationship with every other piece of information
In what database every value has a unique identity in a form of a record?
Relational database
What is Primary key
a unique identifier assigned to each record within a database table
How are rows in relational database linked?
every row of data in the database is linked with another row using a primary key
How are tables connected in relational database?
Every table is linked with another table using a foreign key
What is foreign key ?
column that refers to the primary key/unique key of another table).
Where and why are relational databases widely integrated ?
web app interfaces to serve as ideal repositories for user data
What the elements in relational database represents ?
Rows represent the records and columns represent attributes for each record.
How is data in relational database inserted, manipulated and retrieved ?
By using SQL
What are them most common DBMS for relational databases
MySQL, SQLite, Oracle and Microsoft SQL Server
Where Cloud Databases are used ?
where data requires a virtual environment for storing and executing over the cloud platforms. (SaaS,PaaS,etc.)
What are the most common DBMS for Cloud databases?
Amazon Web Services(AWS), Google Cloud Platform(GCP), Microsoft Azure, Science Soft
What databases are stored, located and maintained at a single location?
Centralized databases
Advantages of Centralized databases
Data security, reduced redundancy, consistency, more secure for fetching data
Disadvantages of centralized databases
Size is too large-increasing response and retrieval time, Not easy to manipulate
Who are personal databases designed for ?
A single user
Where do personal databases collect and store data ?
On its own system
Advantages of Personal databases
Easy to handle, Less space needed
Which database is used for creating, updating and deleting the database in a real-time.
Operational database
What are operational databases designed for ?
executing and handling the daily data operation in organizations and for business purposes.
Advantages pf operational databases
- Easy to fetch
- Structured data
- Real-time processing
What does No SQL database do ?
provides a mechanism for storage and retrieval of data
How is data modeled in no SQL database
in means other than the tabular relations used in a relational database.
Which database makes some operations faster by different structures than in relational database?
No SQL databases
On what depends the suitability of no SQL database ?
The kind of problem to be solved
What are the attributes of no SQL databases?
Simplicity of design, simpler horizontal scaling to clusters or machines (addition of extra nodes or machines to infrastructure in response to a change in demand).
What is a machine ?
a device whose basic function is managing access to a database. Provides faster application processing through the offloading of the database access to this dedicated device.
Advantages of no SQL databases
Scalability and high availability
Disadvantages of no SQL databases
- Open-source database
- GUI is not available
- Backup is a weak point
- Large document size
How do Flat file databases store their records?
Usually contains a single row or record per line
Disadvantages of Flat file databases
Text-based, lacks indexes and explicit information about relationships between data
Examples of flat file databases
/etc/passwd file on UNIX, describing one user account per line
Comma-separated value (CSV) files, which are common data exchange format, with commas used as delimiters (character separating columnar data).
Some no SQL databases utilize flat files to store data in JSON (JavaScript Object Notation) format.
What is JSON
Standard text-based format for representing structured data based on JavaScript Object syntax.
Commonly used for transmitting data in web applications.
Can be used independently from JavaScript.
