- ____ percent of databases are unstructured while _______ are structured 80%
20% - _____ focuses on filtering data as it enters the system to determine which data to keep and which to discard. stream processing
- ______ is keeping the same number of systems, but migrating each system to a larger system. scaling up
- ______ minimizes the number of disk reads necessary to retrieve a row of data. row-centric storage
- ___________ •Requires a fixed schema – you need to create the table and set the data types before you can inset the data. while __________ Does not require a fixed schema, avoids join operations and typically scales horizontally. Can create and update data on the fly. rdbms
nosql - ___________ execls in functionality while ______________ in scalability and performance RDBMS
NOSQL - ___________ stores would work well for shopping cart contents, or individual values like color schemes, a landing page URI, or a default account number. key value
- A column family database is a NoSQL database model that organizes data in key-value pairs with keys mapped to a set of columns in the value component. True
- A query in a graph database is called a ______. traversal
- Add resources within the same logical unit to increase capacity. For example to add CPUs to an existing server, increase memory in the system or expanding storage by adding hard drive. this is called scaling up or vertical scaling better for RBMS
- advantages of distributed computing realitablity
•Scalability
•Sharing of Resources
•Flexibility
•Performance (speed) - cons to distributed computing netwokinf
security
trouble shooting
failures - Data model used in relational database management systems Relational DBMS
- Document databases group documents into logical groups called collections
- Graph theory is a mathematical and computer science field that models relationships, or edges, between objects called ______ nodes
- high availability IS ____________ foucsues and fault tolernce is _________________ software focused
hardware - if you wan to scale out what type of scaling should you use and which database is better horizontal, nosql if
- if you want to Add more nodes to a system, such as adding a new computer to a distributed software application. what is this called horizontal scaling- scaling out
nosql - In a NoSQL configuration, data storage can be much faster as it takes advantage of “________________ ___________” scaling out
- Interest in graph databases can be tied to the area of social networks. True
- Key-value and document databases are structurally similar true
- Key-value and document databases are structurally similar. True
- Modeling and storing data about relationships is the focus of ______ databases. graph database
- Most NoSQL products run only in a Linux or Unix environment true
- Most NoSQL products run only in a Linux or Unix environment. True
- Most NoSQL products run only in a Linux or Unix environment. True
- One of the advantages of NoSQL database is that they are really __________ to scale and they are much ____________ in most types of operations that we perform on RDBMS. easy
faster - RDBMS supports ________and nosql does not support __________ acids
acids - relation databases are ______________ Compliant ACIDS
- To query the value component of the pair when using a key-value database, use get or ______ fetch
- what are some cons to relational databases •Requires substantial hardware and system software overhead – losts of software
•Conceptual simplicity gives untrained people the tools to use a good system poorly- stupid people do dome things
•May promote information problems- info problems - what are some nosql features Flexible schemas
Horizontal scaling
Fast queries
easy to use - what are the 4 types of no SQL •Key-value stores
•Column-oriented
•Graph
•Document oriented - what are the pros to Relational DBMS •Structural independence is promoted using independent tables
•Tabular view improves conceptual simplicity
•Ad hoc query capability is based on SQL
•Isolates the end user from physical-level details
•Improves implementation and management simplicity - what are the two types of scaling •Vertical Scaling
•scaling up
•better suited for RBMS
•Horizontal Scaling
•scaling out
•better suited for NoSQL - what is a column- oriented database •Stores data using a column oriented model.
•Values of a single column are stored contiguously.
•Column stores data in column specific files.
•All data within each column datafile have the same type which makes it ideal for compression.
•Column stores can improve the performance of queries as it can access specific column data. - What is a no-SQL database? non-relational database management system
- WHAT IS nosql better suited for? Better suited to storing unstructured data.
- what is relational dbms type of database mgmt sys that organizes data into series of records held in LINKED tables; aids in data access and transformation due to flexible linkages based on record values
- What is scalability? •Ability of a system to expand to meet the business needs.
- when to use NoSQL over RDBMS Store and retrieve huge amounts of data.
Relationships between data is not important.
Data is not structured and changing over time.
Constraints and join support is not required at database level.
Data is growing continuously, and you need to scale the database regularly to handle the data. - Which of the following is NOT one of the standard NoSQL categories? CHART DATABASES
Other Links:
See other websites for quiz:
Check on QUIZLET