\"Data Information Decision\" Please respond to the following: With the obvious
ID: 3768628 • Letter: #
Question
"Data Information Decision" Please respond to the following:
With the obvious pace of current technology development, data continues to grow daily. Imagine that you are a Database Administrator for a large organization. Identify the primary decisions a Database Administrator must make in order to manage such data, maintain data integrity, and maintain a database at its most ideal level. Provide a rationale for your response.
Suppose you are also in charge of securing your organization’s data. Identify at least two (2) data security measures that you believe are necessary to prevent data security issues. Justify your response.
Explanation / Answer
The primary decisions a Database Administrator must make in order to manage such data, maintain data integrity, and maintain a database at its most ideal level include:
1)Monitoring and optimizing the performance of the database
2) Managing Data Integrity
Integrity controls protects data from unauthorized use
Data consistency
Maintaining data relationship
Domains- sets allowable values
Assertions- enforce database conditions
3)Data backup
We must assume that a database will eventually fail
Establishment procedures
how often should the data be back-up?
what data should be backed up more frequently?
who is responsible for the back ups?
Back up facilities
4) Database recovery
Yes
5) Managing data security and privacy
Answer 2) The two data decurity measure to prevent data security issues are:
a)1. Establish strong passwords
Implementing strong passwords is the easiest thing you can do to strengthen your security.
Cloutier shares his tip for crafting a hard-to-crack password: use a combination of capital and lower-case letters, numbers and symbols and make it 8 to 12 characters long.
According to Microsoft, you should definitely avoid using: any personal data (such as your birthdate), common words spelled backwards and sequences of characters or numbers, or those that are close together on the keyboard.
Use their convenient password checker to see how strong yours is.
As for how often you should change your password, Cloutier says that the industry standard is "every 90 days," but don't hesitate to do it more frequently if your data is highly-sensitive.
b) Put up a strong firewall
In order to have a properly protected network, "firewalls are a must
automatic dump- facility that produces backup copy of the entire database
periodic backup- done on periodic basis such as nightly or weekly
cold backup- database is shut down during backup
hot backup- a selected portion of the database is shut down and backed up at a given time
backups stored in a secure, off-site location
Application of proven strategies for reinstallation of database after crash
Recovery facilities include backup, journalizing, checkpoint, and recovery manager
Journalizing facilities include:
audit trail of transactions and database updates
transaction log which records essential data for each transaction processed against the database
database change log shows images of updated data. The log stores a copy of the image before and after modification.
Checkpoint facilities:
when the DBMS refuses to accept a new transaction, the system is in a quiet state
database and transactions are synchronized
allows the recovery manager to resume processing from a short period instead of repeating the entire day
Recovery and Restart Procedures
switch- mirrored databases
restore/rerun- reprocess transactions against the backup
->transaction integrity- commit or abort all transaction changes
Protection of data against accidental or intentional loss, destruction, or misuse
Firewalls
Establishment of user privileges
Complicated by use of distributed systems such as internet access and client/ server technology.
A firewall protects your network by controlling internet traffic coming into and flowing out of your business. They're pretty standard across the board ..
c). Backup regularly
Scheduling regular backups to an external hard drive, or in the cloud, is a painless way to ensure that all your data is stored safely
d)Encrypt the information to prevent unauthorised access.
These measures are extremely important to make sur the data is kept confidential and only the people of the company have the right to access it. it ensures data integrity and secrecy which is very important to make sure that people work according to the laws and help the company in the best possible way without any problems,
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.