Please enable JavaScript.
Coggle requires JavaScript to display documents.
Data (Databases (Relational database (Relationships (One-to-many (Musk -…
Data
Databases
-
-
-
-
Foreign key
Attributes that joins two tables (Primary is one, foreign in another)
Networking
Transmitting data
Circuit switching
-
-
All on same route, intercepted
-
-
-
Data packets
Header
IP addressees, protocol, number of packets, Time To Live
Trailer section, checksum (CRC)
Detect errors, attaches hash from data and verified on other side
-
-
-
Protocols
TCP/IP stack
-
Transport
TCP for end-to-end with recipient, split into packets w/number and port number
Network
Adds IP from both ends. Port number and IP form socket, specifies device and app the packet is sent to.
-
When received:
MAC, IP, port num stripped to reassemble in correct order
FTP
High level protocol, in application layer
File management screen, dragging and dropping
-
Security
Firewalls
Prevent unauthorised access to network, blocking connections
Packet filtering
Look at IPS from header, must be in "permitted list" for access.
-
-
Threats
Viruses and worms
Viruses, needs to be executed to replicate/damage
-
Exploit "buffer overflow", writes to small locations and overwrites incorrect areas.
Trojan
Hidden in file until executed, exploit backdoor, no replicate
-
-
Compression
-
-
-
Loss-less
Records patterns in data, reverse changes
Structures
Queues
-
Added in rear, removed from front
Pointers (front, back) move, not data
Dynamic
-
-
-
Append, remove, length, insert, search, pop
-
Linear Queue
-
Variable with number of data items, and front and rear pointers, creates space at front
-
DeQueue()
Remove item from front, return it
-
-
Circular
When full, rear points points to last
-