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:52This Valentine's Day brand marketing handbook provides businesses with five practical models, covering everything from creating offline experiences to driving online engagement. Whether you're a shopping mall, restaurant, or online brand, you'll find a suitable strategy: each model includes clear objectives and industry-specific guidelines, helping brands transform traffic into real sales and lasting emotional connections during this romantic season.
This Valentine's Day map illustrates love through 30 romantic possibilities, from the vintage charm of "handwritten love letters" to the urban landscape of "rooftop sunsets," from the tactile experience of a "pottery workshop" to the leisurely moments of "wine tasting at a vineyard"—offering a unique sense of occasion for every couple. Whether it's cozy, experiential, or luxurious, love always finds the most fitting expression. May you all find the perfect atmosphere for your love story.
The ice hockey schedule for the Milano Cortina 2026 Winter Olympics, featuring preliminary rounds, quarterfinals, and medal matches for both men's and women's tournaments from February 5–22. All game times are listed in Eastern Standard Time (EST).
This Valentine's Day brand marketing handbook provides businesses with five practical models, covering everything from creating offline experiences to driving online engagement. Whether you're a shopping mall, restaurant, or online brand, you'll find a suitable strategy: each model includes clear objectives and industry-specific guidelines, helping brands transform traffic into real sales and lasting emotional connections during this romantic season.
This Valentine's Day map illustrates love through 30 romantic possibilities, from the vintage charm of "handwritten love letters" to the urban landscape of "rooftop sunsets," from the tactile experience of a "pottery workshop" to the leisurely moments of "wine tasting at a vineyard"—offering a unique sense of occasion for every couple. Whether it's cozy, experiential, or luxurious, love always finds the most fitting expression. May you all find the perfect atmosphere for your love story.
The ice hockey schedule for the Milano Cortina 2026 Winter Olympics, featuring preliminary rounds, quarterfinals, and medal matches for both men's and women's tournaments from February 5–22. All game times are listed in Eastern Standard Time (EST).
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