DB
-
Data Warehouse and Data LakeDB/Nosql 2020. 7. 10. 12:12
1. Overview 1.1 Data Warehouse A data warehouse is a blend of technologies and components which allows the strategic use of data. It is a technique for collecting and managing data from varied sources to provide meaningful business insights. It is the electronic storage of a large amount of information by a business that is designed for query and analysis instead of transaction processing. It is..
-
Stored ProcedureDB/RDB 2020. 4. 11. 22:14
1. Overview A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again. So if you have an SQL query that you write over and over again, save it as a stored procedure, and then just call it to execute it. You can also pass parameters to a stored procedure so that the stored procedure can act based on the parameter value(s) that is passed. 1.1 Define..
-
Comparison between MSSQL, Oracle, PostgreSQL, and MySQLDB/RDB 2020. 4. 11. 01:49
1. Overview Name Microsoft SQL Server Oracle PostgreSQL MySQL Description Microsofts relational DBMS Widely used RDBMS Widely used open-source RDBMS Widely used open-source RDBMS Primary database model Relational DBMS Relational DBMS Relational DBMS Relational DBMS Secondary database models Document store Graph DBMS Document store Graph DBMS RDF store Document store Document store DB-Engines Ran..
-
PostgreSQLDB/RDB 2020. 4. 10. 23:11
1. Overview PostgreSQL is a general-purpose and object-relational database management system, the most advanced open source database system. PostgreSQL was developed based on POSTGRES 4.2 at Berkeley Computer Science Department, University of California. PostgreSQL was designed to run on UNIX-like platforms. However, PostgreSQL was then also designed to be portable so that it could run on variou..
-
MongoDB ArbiterDB/Nosql 2020. 4. 10. 16:13
1. Overview Arbiters are mongod instances that are part of a replica set but do not hold data (i.e. do not provide data redundancy). An arbiter does not store data, but until the arbiter’s mongod process is added to the replica set, the arbiter will act like any other mongod process and start-up with a set of data files and with a full-sized journal. They can, however, participate in elections. ..
-
ElasticsearchDB/Nosql 2020. 3. 3. 19:26
1. Overview Elasticsearch is open-source analytics and full-text search engine. It’s often used for enabling search functionality for applications. For example, you might have a blog or a webshop for which you want users to be able to search for various kinds of data. That could be blog posts, products, categories, or anything you want. You can build complex search functionality with Elasticsear..
-
Database CursorDB/RDB 2020. 2. 24. 01:53
1. Overview In computer science, a database cursor is a control structure that enables traversal over the records in a database. Cursors facilitate subsequent processing in conjunction with the traversal, such as retrieval, addition, and removal of database records. The database cursor characteristic of traversal makes cursors akin to the programming language concept of an iterator. 2. Descripti..
-
TriggerDB/RDB 2020. 2. 24. 01:40
1. Overview A trigger is a stored procedure in a database that automatically invokes whenever a special event in the database occurs. For example, a trigger can be invoked when a row is inserted into a specified table or when certain table columns are being updated. 2. Description 2.1 Usages automatically generate derived column values prevent invalid transactions enforce complex security author..