Computer Science Flashcards
Algorithm
A set of steps for a computer program to accomplish a task
Data Base Management System: DBMS
use this software to manage one or more data bases. software such as Oracle or DB2 or….
Database
The database is your data and your rules about that data.
DBMS
The database management system, the DBMS, is the program or the set of programs that surround and manage it, to make sure your rules are applied.
Microsoft SQL Server
is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet).
Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle)
is an object-relational database management system[4] produced and marketed by Oracle Corporation.
MySQL (officially pronounced as /maɪ ˌɛskjuːˈɛl/ “My S-Q-L”,[6])
MySQL (officially pronounced as /maɪ ˌɛskjuːˈɛl/ “My S-Q-L”,[6]) is an open-source relational database management system (RDBMS).[7] Its name is a combination of “My”, the name of co-founder Michael Widenius’s daughter,[8] and “SQL”, the abbreviation for Structured Query Language. The MySQL development project has made its source code available under the terms of the GNU General Public License, as well as under a variety of proprietary agreements. MySQL was owned and sponsored by a single for-profit firm, the Swedish company MySQL AB, now owned by Oracle Corporation.[9] For proprietary use, several paid editions are available, and offer additional functionality.
PostgreSQL, often simply Postgres,
is an object-relational database management system (ORDBMS) with an emphasis on extensibility and standards compliance. As a database server, its primary functions are to store data securely and return that data in response to requests from other software applications. It can handle workloads ranging from small single-machine applications to large Internet-facing applications (or for data warehousing) with many concurrent users; on macOS Server, PostgreSQL is the default database;[11][12][13] and it is also available for Microsoft Windows and Linux (supplied in most distributions).
Apache HBase
is an open-source, non-relational, distributed database modeled after Google’sBigtable and is written in Java. It is developed as part of Apache Software Foundation’s Apache Hadoop project and runs on top of HDFS (Hadoop Distributed File System), providing Bigtable-like capabilities for Hadoop. That is, it provides a fault-tolerant way of storing large quantities of sparse data (small amounts of information caught within a large collection of empty or unimportant data, such as finding the 50 largest items in a group of 2 billion records, or finding the non-zero items representing less than 0.1% of a huge collection).
hierarchical database systems
,
network database systems
object-oriented database systems
NoSQL database systems.
Cassandra
Mongo
CouchDB
Cardinality
the cardinality or fundamental principle of one data aspect with respect to another is a critical feature. The relationship of one to the other must be precise and exact between each other in order to explain how each aspect links together.
In the relational model, tables can be related as any of “one-to-many”, “many-to-many” “one-to-zero-or-one”, etc.. This is said to be the cardinality of a given table in relation to another.
A C I D
A transaction must be
atomic.
consistent,
isolated,
durable
Being atomic, and this is the Greek word atommeaning an indivisible unit. It refers to the core idea that this transaction must completely happen or not at all.
