MindMap Gallery Data storage and operations
Dama knowledge system, data storage and operation include the design, implementation and support of stored data, maximizing the value of data resources, and running through data creation/acquisition to the entire life cycle of disposal.
Edited at 2024-04-02 15:17:52Avatar 3 centers on the Sully family, showcasing the internal rift caused by the sacrifice of their eldest son, and their alliance with other tribes on Pandora against the external conflict of the Ashbringers, who adhere to the philosophy of fire and are allied with humans. It explores the grand themes of family, faith, and survival.
This article discusses the Easter eggs and homages in Zootopia 2 that you may have discovered. The main content includes: character and archetype Easter eggs, cinematic universe crossover Easter eggs, animal ecology and behavior references, symbol and metaphor Easter eggs, social satire and brand allusions, and emotional storylines and sequel foreshadowing.
[Zootopia Character Relationship Chart] The idealistic rabbit police officer Judy and the cynical fox conman Nick form a charmingly contrasting duo, rising from street hustlers to become Zootopia police officers!
Avatar 3 centers on the Sully family, showcasing the internal rift caused by the sacrifice of their eldest son, and their alliance with other tribes on Pandora against the external conflict of the Ashbringers, who adhere to the philosophy of fire and are allied with humans. It explores the grand themes of family, faith, and survival.
This article discusses the Easter eggs and homages in Zootopia 2 that you may have discovered. The main content includes: character and archetype Easter eggs, cinematic universe crossover Easter eggs, animal ecology and behavior references, symbol and metaphor Easter eggs, social satire and brand allusions, and emotional storylines and sequel foreshadowing.
[Zootopia Character Relationship Chart] The idealistic rabbit police officer Judy and the cynical fox conman Nick form a charmingly contrasting duo, rising from street hustlers to become Zootopia police officers!
Data storage and operations
introduction
Data storage and operations include the design, implementation and support of stored data to maximize the value of data resources throughout the entire life cycle from data creation/acquisition to disposal.
definition
Manage the design, implementation and support activities of data storage to maximize its value
Metrics
Data storage metrics
Performance metrics
operational metrics
Service Metrics
basic concept
Service Level Agreement SLA (Servies Level Assignment)
Common application interface API: (Application Programming Interface)
Open Database Connectivity ODBC: (Open DataBase Connectivity)
Database Administrator DBA: (DataBase Administrator)
Data As a Service Daas: (Data As a Service)
Database schema type
centralized
distributed
federal (autonomous)
Blockchain database: Blockchain database is a federated database used to securely manage financial transactions.
non-federal (non-autonomous)
Data processing type
ACID
1. Atomicity
2. Consistency
3. Isolation
4. Durability
BASE
1. Basically Available
2. Soft State
3. Eventual consistency
CAP: The CAP theorem (also known as "Brewer's theorem") is a theory proposed by centralized systems in the process of developing towards distributed systems. The CAP theorem means that it is impossible for a distributed system to meet all the requirements of ACDI at the same time. The larger the system scale, the fewer requirement points are satisfied.
1. Consistency: The system must always operate as designed and expected.
2. Availability. The system remains available and responds to requests whenever they occur.
3. Partition Tolerance: When occasional data loss occurs or a partial system failure occurs, the system can still continue to operate and provide services.
The CAP theorem points out that in any system that shares data, at most two of these three requirements can be satisfied at the same time. It is usually explained by "choose two from three".
Data storage media: disk, memory, flash memory
Common usage
Disk and Storage Area Networks (SAN: Storage Area Networks)
Memory and Column Compression Solutions
Virtual Storage Area Network (VSAN: Virtual SAN)
Cloud-based storage solutions
Radio frequency identification technology (RFID: Radio Frequency I-dentification)
digital wallet
Data centers and private clouds
Public cloud and hybrid cloud storage
Database environment
Production Environment
non-production environment
development environment
test environment
1. Quality Assurance Testing (QA)
2. Integration testing
3. User Acceptance Testing (UAT)
Data sandbox or experimental environment
Database organization model
1. Hierarchical database
2. Relational database (RDBMS)
1) Multidimensional database
2) Temporal database
1. Validity time
2. Time of things
3. Non-relational database (NoSQL: Not Only SQL)
1) Column database
2) Spatial database (GIS)
3) Object/Multimedia Database
4) Flat file database
5) Key-value pairs
6) Triple storage
Common database procedures
1. Data archiving
2. Capacity and Growth Forecasts
3. Change Data Capture (CDC)
Concept: Change Data Capture (CDC) is the process of detecting changes in data and ensuring that information related to the changes is appropriately recorded
method
1. Data Versioning - Evaluate columns that identify changed rows (e.g., columns with last update timestamp, columns with version numbers, columns with status flags)
2. By reading the log
3. Create a table to store the changed data at the same time
4. Capture through professional software: such as OGG
4. Data clearing
5. Data copy
1) Active replication: There is no master copy, and the same data from other copies can be actively created and stored on each copy.
2) Passive replication: first create and store data on the primary copy, and then transfer the changed status to other copies
6. Resilience and recovery
7. Data retention
8. Data fragmentation