CSDB - Module 2
Major Types of Database (bottom to top)
NoSQL
XML DBMS
Object-Relational DBMS
Object-oriented DBMS
Relational DBMS
Network DBMS
Hierarchical DBMS
File System
___stores data in a tee format of the relationship between subordinates and superiors.
Heirarchical Database
Relational Database
Network Database
Object-Relational Database
Oldest database since the 1960s
Heirarchical Database
File System
Network Database
XML Database
Each structure maintains a dependent relationship by connecting with. It is difficult to change the structure when the business process is changed after. Difficult to perform unexpected random search
Heirarchical Database
Network Database
File System
Relational Database
Store data by expanding the tree form of a hierarchical database into a___.
Network Database
Relational Database
Object-Relational Database
Object-oriented Database
Developed in the early 1970s to solve hierarchical problems
Network Database
Object-Relational Database
XML Database
NoSQL
Data can be extracted quickly and effectively by adding links between hierarchical structures. High maintenance costs and backlog are entailed by the complex type system. Programmers must understand the structure to write a program. A record can have pointers to children and sibling records and to parent records(not possible in hierarchical)
Network Database
XML Database
NoSQL
Relational Database
Pointers are used to maintain many-to-many relationships between records and to link data
Network Database
XML Database
NoSQL
Relational Database
Data model proposed by E. F. Codd in the 1970s
Relational Database
Network Database
Object-Relational Database
XML Database
Model is simple: characters, numbers, date information is stored in two-dimensional structure (column, row)
Relational Database
Object-Relational Database
Object-oriented Database
Network Database
Model is based on mathematical theory: set theory of mathematics.Existence of query language.Contiguous support for technology that keeps pace with time: supports client/server architecture, large-scale parallel processing, etc.
Relational Database
Object-oriented Database
Network Database
Object-Relational Database
Database that can search and stores information based on object model
Object-oriented Database
Object-Relational Database
XML Database
Network Database
Characteristics of___:
• User-defined datatypes are supported, and inheritance can be specified
• Unstructured complex information can be modeled.
• Information can be accessed based on navigation using the reference structure between objects
• The structure information on the program is also the same as that of the database schema
Object-oriented Database
Object-Relational Database
Network Database
Relational Database
___was not distributed widely in the market because its basic database management functions were found to be weak:
• Transaction processing
• number of supported concurrent users
• backup and recovery, etc.
• system safety and performance were never proven in an enterprise environment
Object-oriented Database
Object-Relational Database
Network Database
Relational Database
____ was introduced to solve the weakness of the relational database
Object-Relational Database
Object-oriented Database
Network Database
XML Database
It showed certain limitations in terms of its use in an enterprise environment
Object-Relational Database
Object-oriented Database
Network Database
XML Database
Combining the existing relational database concept with the concept of an object- oriented database and expanding its functions
Object-Relational Database
Object-oriented Database
XML Database
Network Database
Characteristics of___:
- Users can define and use new types of data in addition to basic data types
- Data can be accessed based on navigation using the reference structure in such a way that one object record refers to another object record
- A data model with a complex structure can be designed because one column in a table is composed of another table
- Supports LOB (Large Object) as a basic data type for large-scale unstructured data such as images, audio, and video
-
Accommodates the advantages of the object-oriented database by specifying the inheritance relationship between tables.
Object-Relational Database
Object-oriented Database
Network Database
Relational Database
A standard language that is used to structure and exchange data in a web environment
XML
Relational
Object-oriented
Characteristics of XML:
Simplify SGML (Standard Generalized Markup Language)
Simplicity
Openness
Scalability
Structure
Characteristics of XML:
___can be used together with HTML, can exchange meta-data
Openness
Simplicity
Structure
Scalability
Characteristics of XML
__can create its own tags and support self-description
Scalability
Simplicity
Structure
Openness
Characteristics of XML:
__can be understood by both humans and machines: easy to compare and collect data
Structure
Scalability
Simplicity
Openness
Characteristics of XML
__format can be changed according to user's preferences
Separation of content and expression:
Hierarchical structure
Unicode
Structure
Characteristics of XML:
___supports structure search and full-text search
Hierarchical structure
Unicode
Structure
Separation of content and expression:
Characteristics of XML:
___supports multiple languages
Unicode
Separation of content and expression:
Structure
Hierarchical structure
A document that defines the form of an XML document in a consistent structure. It is used to validate XML
XML DTD
XML Schema
XPath
XQuery
High-level data definition language used to specify the structure of an XML document by replacing XML DTD
XML Schema
XML DTD
XPath
XQuery
A language that expresses extended queries so that the search condition can be included in the ___expression
XPath
XML Schema
XML DTD
XQuery
A standard ___ language that can extract intended information from an XML file as if using a database
XQuery
XPath
XML Schema
XML DTD
A language that specifies the style sheet, which is used to express XML data in various different forms. It is a part of XL that converts an XML document into a different type of document (such as HTML) so that it can be displayed on general browsers
XSL/XSLT
XLL
XML parser
XML syntax analyzer
XSL engine
This Language displays the connection and relationship between XML elements
XLL
XSL/XSLT
XML parser
XML syntax analyzer
XSL engine
Checks and inspects the grammar and syntax structure of an XML document (validation check)
XML parser
XLL
XSL/XSLT
XML syntax analyzer
XSL engine
Analyzes the syntax structure of an XML document (SAX, DOM).
XML syntax analyzer
XML parser
XLL
XSL/XSLT
XSL engine
Converts an XML document to a document format with expression information
XSL engine
XML syntax analyzer
XML parser
XLL
XSL/XSLT
XML document Creation Procedure (bottom to top)
Create style sheet
Create XML document
Create DTD
Analyze document
Select document type
XML document Creation Procedure (match the answer)
Create XML document
Provides a basic schema to the database for linking
Create style sheet
Determines the purpose of use.Determines the logical structure and elements of the document.
Analyze document
Creates an XML document using the tags defined in DTD. Creates a document by complying with the XML grammar.
Create DTD
Determines the type of document to create. (Example) User manual, contract, catalog, official document, etc.
Select document type
Creates a procedure for document appearance and the processing contents in the document. Created independently of the XML document and managed as a different file.
DTD Creation and Procedure (bottom to top)
Combining XML and DTD
Declaring an element type
DTD decleration
Match Database Types
Main Memory Database
Set of non-spatial data represented by letters and numbers and spatial data represented by coordinate values. Initially developed because the technology for processing "unstructured data", such as the geographical information system, was needed as a core technology for a type of guided missile that strikes a preset target by tracking the target's location using geographical information
Column Based Database
Physically stores data based on columns. A way to store data with this structure reached the limit in analyzing large-scale data at high speed because its physical structure required that unnecessary data should be also read.
Mobile Database
General databases are not suitable for the embedded system, which has limited memory and special performance goals. It was developed for the embedded. Provides essential functions only after reducing overheads to use minimum RAM and disk. Supports communication between different devices to allow communication with the database in central server
Spatial Database
Exclusively used by mobile devices .That database can be installed in a small capacity device equipped with a limited CPU and memory. It is provided as an embedded form that integrates data and application. It has the function of data replication and synchronization with the database of the existing server.
Embedded Database
Manages and manipulates a database by seeking it in the memory. Unlike general commercial databases in which a database is stored on a disk. It is actively used due to business demands, such as securing the competitiveness of an enterprise through quick decision-making and the revolutionary development of related technologies such as the release of 64-bit OS, the reduction of memory prices, etc.
Multimedia Database
Developed to efficiently search and manage unstructured multimedia data characterized by their large capacity and complexity, such as text, image, audio, video, etc
{"name":"CSDB - Module 2", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Major Types of Database (bottom to top), ___stores data in a tee format of the relationship between subordinates and superiors., Oldest database since the 1960s","img":"https://www.quiz-maker.com/3012/images/ogquiz.png"}
More Quizzes
Jul
320
Expensive Make-Up is Better than Inexpensive Make-Up
4226
FRIDAY OR SATURDAY, AMOUNT OF GIRLS (NIGHT-TIME, 7PM UNTIL CLOSE)
100
Gerbil quiz
7413
How smart are you?
1050
Test je basiskennis Zakelijk financieren
1050
Your Relationship With Money & Your Honey:
This quiz will tell you which of the 4 categories you're in, from Emergency to Rockstar!
You'll also get a free tool specially-designed to help you & your significant other take the next step forward.
Simply choose the best/closest answer to each question, and you'll have your results + free tool in moments.
840
5E
520
Government 12 Quiz
201027
Music
10513
Državno uređenje Rima-kviz
1260
Solar Energy
10532