모든 공개 기록
IT 위키
IT 위키에서 사용할 수 있는 모든 기록이 표시됩니다. 기록 종류나 사용자 이름(대소문자 구별) 또는 영향을 받는 문서(대소문자 구별)를 선택하여 범위를 좁혀서 살펴볼 수 있습니다.
- 2024년 12월 16일 (월) 03:03 Betripping 토론 기여님이 Distributed Two-Phase Locking 문서를 만들었습니다 (Created page with "'''Distributed Two-Phase Locking (Distributed 2PL)''' is a concurrency control protocol used in distributed database systems to ensure global serializability. In this protocol, each site manages locks independently while coordinating with other sites to maintain consistency across the distributed system. ==Key Concepts== *'''Global Serializability:''' Ensures that the execution of distributed transactions is equivalent to a serial execution. *'''Distributed Lock Manageme...") 태그: 시각 편집
- 2024년 12월 16일 (월) 02:48 Betripping 토론 기여님이 Primary Copy Two-Phase Locking 문서를 만들었습니다 (Created page with "'''Primary Copy Two-Phase Locking (2PL)''' is a concurrency control protocol used in distributed database systems where a primary copy of each data item is designated for lock management. Transactions must obtain locks from the primary copy of the data item to ensure consistency and serializability across the system. ==Key Concepts== *'''Primary Copy:''' A specific node in the distributed system is designated as the authoritative source for managing locks for a particula...") 태그: 시각 편집
- 2024년 12월 16일 (월) 02:36 Betripping 토론 기여님이 Primary Site Two-Phase Locking 문서를 만들었습니다 (Created page with "'''Primary Site Two-Phase Locking (2PL)''' is a variant of the Two-Phase Locking protocol used in distributed databases. In this approach, one node is designated as the primary site for each data item, and it coordinates the locking and transaction processing to ensure serializability across the system. ==Key Concepts== *'''Primary Site:''' A designated node that manages all lock requests for a specific data item. *'''Global Serializability:''' Ensures that all transacti...") 태그: 시각 편집
- 2024년 12월 16일 (월) 02:35 Betripping 토론 기여님이 Distributed Database 문서를 만들었습니다 (Created page with "'''Distributed Database''' is a collection of databases distributed across multiple physical locations that function as a single logical database. Each site can operate independently while participating in a unified database system through communication over a network. ==Key Concepts== *'''Data Distribution:''' Data is distributed across multiple sites based on factors like performance, reliability, and locality. *'''Transparency:''' Users interact with the distributed d...") 태그: 시각 편집
- 2024년 12월 16일 (월) 02:29 Betripping 토론 기여님이 Distributed Computing 문서를 만들었습니다 (Created page with "'''Distributed Computing''' is a field of computer science that involves a collection of independent computers working together as a single cohesive system. These computers, or nodes, communicate over a network to achieve a common goal, such as solving complex problems, processing large datasets, or enabling fault-tolerant services. ==Key Concepts== *'''Distributed System:''' A collection of independent computers that appear to the user as a single system. *'''Concurrenc...") 태그: 시각 편집
- 2024년 12월 16일 (월) 02:27 Betripping 토론 기여님이 Distributed Query Processing 문서를 만들었습니다 (Created page with "'''Distributed Query Processing''' is the process of executing database queries across multiple interconnected nodes in a distributed database system. It involves decomposing a high-level query into sub-queries that are executed on different nodes, combining the results, and presenting a unified output to the user. ==Key Concepts== *'''Distributed Database:''' A collection of interconnected databases located on different physical sites. *'''Query Decomposition:''' Breaki...") 태그: 시각 편집
- 2024년 12월 12일 (목) 07:49 Betripping 토론 기여님이 Serializable (Database) 문서를 만들었습니다 (Created page with "'''Serializable''' is the highest level of isolation in database transaction management, ensuring that the outcome of concurrent transactions is equivalent to some sequential (serial) execution of those transactions. It prevents issues like dirty reads, non-repeatable reads, and phantom reads, guaranteeing the consistency of the database. ==Key Concepts== *'''Isolation Level:''' Serializable is one of the Isolation Levels defined in the SQL standard, providing the st...") 태그: 시각 편집
- 2024년 12월 11일 (수) 06:33 Betripping 토론 기여님이 ARIES (Database) 문서를 만들었습니다 (Redirected page to ARIES) 태그: 새 넘겨주기 시각 편집
- 2024년 12월 11일 (수) 06:23 Betripping 토론 기여님이 Write-Ahead Logging 문서를 만들었습니다 (Created page with "'''Write-Ahead Logging (WAL)''' is a technique used in database management systems (DBMS) to ensure the '''durability''' and '''atomicity''' of transactions. WAL ensures that all changes to the database are recorded in a log before the changes are written to the database itself. This enables reliable crash recovery and consistency in case of a failure. ==Key Concepts== *'''Sequential Logging:''' All modifications are recorded sequentially i...") 태그: 시각 편집
- 2024년 12월 11일 (수) 06:19 Betripping 토론 기여님이 Durability (ACID) 문서를 만들었습니다 (Created page with "'''Durability''' is one of the four key properties in the ACID Properties of database transactions, ensuring that once a transaction has been committed, its changes are permanently saved in the database. This guarantees that data is not lost even in the event of a system crash, power failure, or hardware malfunction. ==Key Concepts== *'''Transaction Commit:''' Durability ensures that when a transaction is committed, its effects are persisted. *'''Non-...") 태그: 시각 편집
- 2024년 12월 11일 (수) 05:39 Betripping 토론 기여님이 분류:Database 문서를 만들었습니다 (Created page with "Database category includes topics related to the design, implementation, and management of databases. It covers various database types, concepts, protocols, and tools that enable efficient storage, retrieval, and manipulation of data. ==Topics in This Category== The following are key areas within the database category: ===Database Concepts=== *Relational Databases *NoSQL Databases *Data Warehousing *Database Normalization *ACID Properties *Database...") 태그: 시각 편집
- 2024년 12월 11일 (수) 05:38 Betripping 토론 기여님이 Multiple Granularity Locking 문서를 만들었습니다 (Created page with "'''Multiple Granularity Locking''' is a concurrency control mechanism used in database systems to improve performance and manage locks at various levels of granularity, such as tuples, pages, tables, or the entire database. By allowing transactions to lock data items at different granular levels, this method optimizes the balance between concurrency and locking overhead. ==Key Concepts== *'''Lock Granularity:''' Refers to the size of the data item on which a lock is appl...") 태그: 시각 편집
- 2024년 12월 11일 (수) 05:34 Betripping 토론 기여님이 Phantom Record 문서를 만들었습니다 (Created page with "'''Phantom Record''' refers to a data entry that appears in a dataset but does not correspond to a real-world entity or valid data point. Phantom records can occur due to system errors, data corruption, improper database handling, or intentional insertion during testing or attacks. ==Causes of Phantom Records== Phantom records can arise from various sources: *'''Data Entry Errors:''' Manual input mistakes resulting in duplicate or incorrect records. *'''System Errors:'''...") 태그: 시각 편집
- 2024년 11월 22일 (금) 12:41 Betripping 토론 기여님이 금 시세 문서를 만들었습니다 (Created page with "'''금 시세'''는 금의 현재 시장 가격을 의미하며, 국제 및 국내 시장에서 실시간으로 변동한다. 금 시세는 투자, 제조, 장신구 제작 및 중앙은행의 정책 결정에 중요한 기준으로 사용되며, 다양한 경제적 요인에 의해 영향을 받는다. 보통 한국에서는 "금값"이라고 한 단어로 쓰기도 한다. ==금 시세의 결정 요인== *'''국제 금 시세''' **금은 국제 시장에서 미국 달...") 태그: 시각 편집
- 2024년 11월 22일 (금) 12:25 Betripping 토론 기여 계정이 생성되었습니다