The person in charge of the company's data resources is called database manager (database administrator) - DBA. The DBA has four areas of responsibility related to the database, ie planning, appraisal, operation, and security. Some DBAs are led by a DBA manager.
Large database users can engage in knowledge discovery activities in databases (KDD) such as data warehouses, data marts, and data mining. Data mining based on verification begins with a user hypothesis of what he believes to be a query database parameter. Data mining based on the invention develops the user's capabilities by identifying the data patterns normally expected by the user. The process of discovery development in the database is repeatable, which repeats steps such as data acquisition, data cleansing, search models, and prediction models, until user requirements are achieved.
An information specialist in charge of a database is called a database manager (DataBase Administrator, DBA). DBA has the main task, namely planning, implementation, operation and security.
KNOWLEDGE IN DATABASE
Knowledge Discovery in Database (KDD) is a term that describes all activities on data stored in a database that includes:
KDD and the integral concepts of data warehousing and data mining illustrate an innovative way of using computers to provide data that is not normally identified by users as a solution to problem solving. There are seven steps in KDD:
PLACE DATABASE AND DBMS IN PERSPECTIVE.
The DBMS makes it possible to create a database in direct computer access storage to maintain its contents and provide such content to users without expensive, expensive programming.
Benefits of DBMS:
a. Reduce data repetition.
b. Achieve data independence.
c. Integrate data from multiple files.
d. Retrieve data and information quickly.
e. Improve security.
Disadvantages of DBMS:
a. Getting expensive software.
b. Obtain a large hardware configuration.
c. Hire and retain DBA staff.
Computerized database or DBMS is not an absolute prerequisite for problem solving. But they provide the basics of computer use as an information system for information and user specialists.
Large database users can engage in knowledge discovery activities in databases (KDD) such as data warehouses, data marts, and data mining. Data mining based on verification begins with a user hypothesis of what he believes to be a query database parameter. Data mining based on the invention develops the user's capabilities by identifying the data patterns normally expected by the user. The process of discovery development in the database is repeatable, which repeats steps such as data acquisition, data cleansing, search models, and prediction models, until user requirements are achieved.
An information specialist in charge of a database is called a database manager (DataBase Administrator, DBA). DBA has the main task, namely planning, implementation, operation and security.
- Database planning involves managers to define schemes and sub-schemes. DBAs play an important role in choosing DBMS.
- The application of the database consists of creating a database that conforms to the selected DBMS specification as well as establishing and enforcing database usage policies and procedures.
- Database operations include offering educational programs to database users and providing assistance when needed.
- Database security includes monitoring of database activity using statistics provided by DBMS. In addition, the DBA ensures that the database remains secure.
KNOWLEDGE IN DATABASE
Knowledge Discovery in Database (KDD) is a term that describes all activities on data stored in a database that includes:
- Data Warehousing, is the development of database concepts that provide better data resources to users and enable users to manipulate and use the data intuitively.
- Warhouse data is generally done on the mainframe.
- Data Mart, is a database that contains data that describes one segment operation company, such as data marketing mart, data mart human resources and so on.
- Data Mining, is the process of finding relationships in data unknown to the user. Data mining helps the user by expressing relationships and presenting them with understandable ones so that they can form the basis of decision making.
KDD and the integral concepts of data warehousing and data mining illustrate an innovative way of using computers to provide data that is not normally identified by users as a solution to problem solving. There are seven steps in KDD:
- Defines data and tasks.
- Getting data
- Clear data.
- Develop a hypothetical and search model.
- Digging data, searching for new patterns and new knowledge.
- Test and verify how far the selected data can be used.
- Interpret and use in interpreting data and making decisions in problem solving.
PLACE DATABASE AND DBMS IN PERSPECTIVE.
The DBMS makes it possible to create a database in direct computer access storage to maintain its contents and provide such content to users without expensive, expensive programming.
Benefits of DBMS:
a. Reduce data repetition.
b. Achieve data independence.
c. Integrate data from multiple files.
d. Retrieve data and information quickly.
e. Improve security.
Disadvantages of DBMS:
a. Getting expensive software.
b. Obtain a large hardware configuration.
c. Hire and retain DBA staff.
Computerized database or DBMS is not an absolute prerequisite for problem solving. But they provide the basics of computer use as an information system for information and user specialists.
Advertisement
No comments