a

903 Words2 Pages
bulb-icon

Recommended: A Debate About The Difference Between Data And Information

DATABASE MANAGEMENT SYSTEM (DBMS) FUNCTIONS
DBMS performs several significant function to assurance the integrity and consistency of the data in the database. Lots of this function is crystal clear to end users, and most can be completed only through the use of DBMS. DBMS include data dictionary management, data storage management, and data transformation security management also multiuser access control.

1. Backup and recovery management. DBMS provides backup and data recovery procedures to make sure the data is safe and assuring the accuracy and consistency of data. Current DBMS provides special functionality that allow the Database Administrator (DBA) to execute special backup and restore procedures. Recovery management handle the recovery of the database after a failure, such as bad sector in the disk or power failure.

2. Security management. DBMS creates a security system that enforces user security and data privacy in the database. Security guideline determine which users are able to access the database, which data item for each user may access, and which data operations such as read, add, delete, or modify that the user may perform.

3. Multiuser access control. DBMS creates complex structures that allow multiuser to access the data. In order to provide data consistency as well as data integrity, DBMS use high degree of algorithms to ensure multiple users can access the database all together without compromising the integrity of the database.

4. Data integrity management. DBMS promotes and enforces integrity rules to wipe out data integrity problems, thus minimising data redundancy and maximising data consistency. The data relationship saved in the data dictionary is used to enforce data integrity. Ensuring data integrit...

... middle of paper ...

...ly structured data” because the data sources do have a structure but all data within a dataset will not contain the same structure.

Example of Unstructured Data:

REFERENCES

Smitha: Distinguih between IRS and DBMS. 2014. smitha: Distinguih between IRS and DBMS. [ONLINE] Available at: http://smithaprahlad.blogspot.com/2006/05/distinguih-between-irs-and-dbms.html. [Accessed 29 April 2014].

Data vs Information - Difference and Comparison | Diffen. 2014. Data vs Information - Difference and Comparison | Diffen. [ONLINE] Available at: http://www.diffen.com/difference/Data_vs_Information. [Accessed 29 April 2014].

Structured Data in a Big Data Environment - For Dummies . 2014. Structured Data in a Big Data Environment - For Dummies. [ONLINE] Available at: http://www.dummies.com/how-to/content/structured-data-in-a-big-data-environment.html. [Accessed 29 April 2014].

Show More
Related

  • Nt1330 Unit 3 Data Control System

    1146 Words  | 3 Pages

    In order to prevent both intentional and unintentional alteration, and destruction of information, any software application needs controls to ensure the reliability of data. Here are two specific controls per each one of the three data control categories, and how each control contributes to ensuring the data reliability in the format requested.

    Read More

  • A

    1749 Words  | 4 Pages

    Celtic Gaul and Capetian/Valois France were similar in many different ways. Both, for the most part, occupied a large part of modern-day France. Both Gaul and the Capetians/Valois were very involved with foreign relations and were actively involved in invasions: both as invaders and invades. In this research paper, the political, social, economic and religious aspects of life in Celtic Gaul and Capetian/Valois France will be examined. In addition, notable leaders in each system will be examined, including many of the kings of the Capetian Dynasty and the House of Valois. The first half of this paper will cover the life and times of Celtic Gaul, which will include topics such as the Druids, civitates, the Romans and the religious aspects of the period. The second half of this paper will include the lineage and dynasties of the Capetian and Valois dynasties, as well as topics such as feudalism, the economics of the ruling classes, Catholicism, the Pope, and the church as a whole.

    Read More

  • Big Data Essay

    861 Words  | 2 Pages

    There are two types of data. They are unstructured and multi-structured. Unstructured data comes from information that isn’t organized or easily interpreted by traditional databases or data models. This is usually in text format.

    Read More

  • a

    656 Words  | 2 Pages

    It is the job of a supervisor in the Army to preserve the force in many different ways. One of those is with The Army Body Fat Composition Program. Every soldier in the Army follows the same weight standards and goes into the program if they are overweight. Not many people know about Army has a program in place for soldiers who do not meet the weight and height requirements. . As we are in different time it is harder to recruit for the Army. It was said by Stew Smith (n.d.), “A shocking 20 percent of all male recruits and 40 percent of female recruits are too heavy to enter into the military ranks.” As a new supervisor it is your job to know about the Army’s overweight program. If a new supervisor does not know the process, it can be really bad for him and the soldier that is over weight.

    Read More

  • a

    1792 Words  | 4 Pages

    In Canada, child protection is basically a responsibility of the provincial and territorial governments through various activities such as investigating child protection concerns. As part of their responsibilities to promote child protection, the provincial and territorial governments may place children or young under care. This involves placing them in varying living arrangements such as group home, foster home, independent living program, receiving homes, and relatives’ home. Placing children in foster care seems to be the most common way used by various governments in Canada to address child protection concerns. However, this type of care has had significant challenges in the recent past, particularly in light of children or young people who age out of foster care. These challenges are attributed to the lack of legislative and policy initiatives taken to address children who age out of foster care in Canada. As a result of lack of such provisions, these children end up having lack of further education as they are forced into adulthood. In some cases, children who age out of foster care in Canada get involved in criminal activities. As the number of children who age out foster care increases, Canadian government should enact appropriate measures, especially legislation and policy to promote the well-being of these children as they grow into adulthood.

    Read More

  • a

    763 Words  | 2 Pages

    Did you know humans had the power create a mass extinction event? For 12,000 years, the Holocene extinction has been devastating life on earth; it branches into nearly all taxonomic groups: birds, mammals, amphibians, reptiles, and arthropods. Only 875 extinctions have been documented between the year 1500 and 2010, but, according to International Union for Conservation of Nature and Natural Resources, there is approximately 140,000 extinctions per year. In the last 12,000 years, all over the globe, a large variety of animals have been wiped out because of human activity.

    Read More

  • a

    889 Words  | 2 Pages

    Security is defined in three main areas: confidentiality, integrity, and availability. Each definition takes a corner of a triangle, which is supposed to emulate a perfect security design called the CIA triad. I will refer to these elements in the recent Target breach.

    Read More

  • a

    1419 Words  | 3 Pages

    Addiction is a term that has traditionally been used to refer to psychiatric syndrome that is caused by illicit drug use. Actually, addition is the only psychiatric condition whose symptoms are regarded as an illegal activity. In most cases, this term is described on the basis of drug use, which is the main focus of many research and treatment programs. Generally, drug addiction has significant negative effects on individuals using the drug and those around them such as family and friends. Family and friends are usually forced to watch their loved ones wilt away in illicit drug use. While addiction has traditionally been regarded as a psychiatric condition, there are numerous debates that have emerged on whether it’s a disease or merely an immoral act by a selfish individual. My standpoint is that addiction is actually a disease because of the observations I have made on how illicit drug use takes control of the addict. I have watched my brother battle prescription drug addiction and eventually passed away from an overdose at the age of thirty-two years. As a result, I believe that addiction is a disease because it changes the functioning of the addict’s brain. In essence, studies have demonstrated the effects of chemical substances on the brain and how addiction affects feelings, thoughts, and actions.

    Read More

  • Oracle Databases

    1555 Words  | 4 Pages

    A database management system, or DBMS, gives the user access to their data and helps them transform the data into information. Such database management systems include dBase, Paradox, IMS, and Oracle. These systems allow users to create, update, and extract information from their databases. Compared to a manual filing system, the biggest advantages to a computerized database system are speed, accuracy, and accessibility.

    Read More

  • Icloud Breach

    743 Words  | 2 Pages

    Substantially, to fundamentally elucidate an information system, it is essentially a connected set of elements produced by people and managed through computers which allows the collection and distribution of data, to summarise the term it is generally a database. Data is a plural for datum which are elementary recognisable facts, information is datas that has been correlated so that context is formulated. To interpret data security, it is an assortment of facts which is translated to information secure on an encrypted server due to its personal state. In addition, the majority of security systems within modern technology are encrypted with pass-codes. However, database management systems (DBMS) can be breached in several ways including weak

    Read More

  • Essay On Career Options In Information System

    1001 Words  | 3 Pages

    DBA deals with all of this by finding user needs, set the database, and test the system. DBA should enable editing any system he or she created. At the same time DBA should ensure the security of the data and guarantee data integrity and backup. Moreover, DBAs should know the database management systems (DBMS) that include the knowledge of Oracle, IBM DB2, and Microsoft SQL server (“Database Administrator,” 2010). Oracle is one of the most important platforms that DBA must know and have experience with. According to Kanaracus “The database experience we look for most of the time is Oracle”, says Tom Hart, executive vice president of the operations and technology group at Veritude. “SQL Server is more of a nice-to-have"

    Read More

  • Privacy and Security Issues in Data Mining

    1885 Words  | 4 Pages

    [7] Elmasri & Navathe. Fundamentals of database systems, 4th edition. Addison-Wesley, Redwood City, CA. 2004.

    Read More

  • Normalization and Integrity

    1055 Words  | 3 Pages

    Normalization, Integrity and Security are the important role for a DBA, Normalization helps to avoid data redundancy by reviewing data base structure at certain level. It helps to build an effective data model. Data Integrity provide some level of assurance over the information getting store and retrieved from database, DBA has to understand all DBMS features use them correctly for Data Integrity. Data Security is toughest part for DBA, auditing and multiple level security can protect data but none of them provide complete security, security can also be managed by encrypting and masking the organization data.

    Read More

  • The Database Management System (DBMS)

    1438 Words  | 3 Pages

    The DBMS function is it has recovery services. It means that if the database is damaged, the database management system will recover the records and all the information. The data and the records need to recover and backup so that it will not be permanently lost. The regular backup is needed because the user doesn’t know what will happen to computer and the data may be loss.

    Read More

  • The Importance Of Database Management Systems

    1411 Words  | 3 Pages

    In our world, people rely heavily on the power of technology every day. Kids are learning how to operate an iPad before they can even say their first word. School assignments have become virtual, making it possible to do anywhere in the world. We can receive information from across the world in less than a second with the touch of a button. Technology is a big part of our lives, and without it life just becomes a lot harder. Just like our phones have such an importance to us in our daily lives, database management systems are the same for businesses. Without this important software, it would be almost impossible for companies to complete simple daily tasks with such ease.

    Read More

More about a

Open Document