Question

• Discuss the use of datafile systems associated with data marts/data warehouses in a RDBMS platform.
• Write a minimum of three well-formed scholarly paragraphs that include a topic sentence, several body sentences (aim for three to five), and a closing, summary, or transition sentenc
  

Answer 1

Data Mining:

Data mining is the most used technique for enhancing the versions of an organization when it comes to analyzing things for the organization in order to make decisions, assumptions, etc. It is the best technique, now we will list down some of the ways it helps organizations with. Here is the list:

• It helps organizations in making better decisions.
• It improves the security risk posture for the organizations.
• It also helps in improved planning and forecasting.
• It also makes the improvement in competitive advantages.
• It reduces the costing of the organization.
• It also helps in getting new customer acquisitions.
• It also helps in the development of new products.
• It plays a major role in the development of customer relationships.

Hence, these are the ways in which data mining helps organizations.

Example of using data mining techniques:

• The most known example of these techniques such as clustering, classification, etc are been used in E-commerce websites where the user's actions are being noted and results are been shown accordingly.
• Suppose, if a user has viewed a pair of shoes which are from an "XYZ" company then he will start to have suggestions of similar shoes from the same company.

Hence, this is how data mining techniques are been commonly used in organizations.

Example of Anomaly Detection:

• Suppose for an example, if there are a certain number of transactions made for a particular product is 900$ and one or two transactions made for the products is relatively low such as 100$ then we know that whether there is something fraudulent going on or some other measures to buy this product has been done.

Hence, this is one of the examples of anomaly detection.

One of the major advantages of using data warehouses in the RDBMS platform is data security and consistency which we will discuss in the following paragraph.

Database Security:

The data classification is one of the most important things that should be done in order to gain somethings which are fruitful from data and must also be managed but what if the data classification is not done properly.

• There are many classifications of data being practiced in the world in which we can find out many possible outcomes for the classification of the data. There is been some certain classification such as :
  • Top Secret
  • Secret
  • Confidential
• The most important is to be able to classify all the data according to the given classification but if the classification is not being done properly there can be many issues such as files can be misplaced in any of the sections and later on it can deal problems.
• If the data is been misplaced to any of the other sectors of data in which it should not be then what will happen. The security must be strong for that. Hence, we can start by implementing certain things in our security plans. They are as follows:
  • We will develop a good data classification scheme if the old one is not been able to classify the data appropriately.
  • We will let us understand what is achievable through the data realistically and then classify the data
  • We can classify the data strategy as soon as the data is approved to any one of the sectors.
  • Each of the sectors will consist of various security provisions so that it won't be easy at all to break into its security.
  • Aligning the data with the best frameworks will also be the best practice to save the data.
  • The classification of the network is required instead of the data.

Hence, these are some of the security implications in case of the data warehouse and how data mining has been an advantage to the organization.