dvandebrake2002
29.02.2020 •
Computers and Technology
1) What is Meta data and Why Meta data is important and a) What are different types of Meta data in Data Warehousing b) Provide a brief description for each type of Meta data in data warehousing c) How Meta data in data warehousing is differ from Meta data in databases.
Solved
Show answers
More tips
- A Animals and plants Why do cats go crazy over catnip?...
- W Work and Career Everything You Need to Know About MBA Programs...
- S Sport How to Do Push-ups Correctly?...
- S Style and Beauty How to Grow Hair Faster: Real Methods and Advice...
- F Family and Home How to Remove Fading from Clothes: Tips and Tricks...
- F Food and Cooking How to Make Polendwitsa at Home?...
- F Family and Home Parents or Environment: Who Has the Most Influence on a Child s Upbringing?...
- P Philosophy Unbelievable stories of encounters with otherworldly forces...
- L Leisure and Entertainment How to Choose the Perfect Gift for Men on February 23rd?...
- H Health and Medicine How to Treat Whooping Cough in Children?...
Answers on questions: Computers and Technology
- C Computers and Technology Mike is in the process of buying a laptop. Although he has looked at several brands, he refuses to buy a laptop that weighs more than four pounds. Mike is basing...
- C Computers and Technology A computer cooled by a fan contains eight PCBs, each dissipating 10 W power. The cooling air is supplied by a 25-W fan mounted at the inlet. If the temperature rise...
- C Computers and Technology Database question need to create a hierarchy diagram A large business, with several medical practices, contacted your company to create a database design. You received...
- C Computers and Technology Consider the following class, which is intended to serve as a blueprint for objects that encapsulate two pieces of data: an even integer and a non-negative real...
- B Biology Which of the following is not a feature of cardiac muscle? multiple choice they depend almost exclusively on aerobic respiration. they are rich in glycogen. they...
- B Business Shamrock corporation issued 510 shares of $100 par value preferred stock for $57,300. prepare shamrock’s journal entry...
- M Mathematics Which of the following statements are true about derivatives? i. derivatives are securities whose payoff is linked to another security. the payoff is never assured...
- P Physics A5.00 l volume of methane gas is cooled from 298 k to 149 k. if the pressure remains constant, what is the final volume in liters?...
- B Business Which of the following is not part of the procedure for evaluating the pluses and minuses of a diversified company s strategy and deciding what actions to take to...
- B Business Aproject is expected to produce cash flows of $48,000, $39,000, and $15,000 over the next three years, respectively. after three years, the project will be worthless....
Ответ:
Metadata is the data that describes other data, serving as an informative label.
In computing it can be seen as a structured information about a file (date created, creator, software used to create, last modified, file format, file fingerprint, etc)
Explanation:
Why is Metadata Important?
• For to identify unique records
• Aggregating content based on common attributes or types
• Search indexes metadata
• Collate filtered views
• Browse
• Security and permissions
• Workflow and Document lifecycle
Data warehousing.
Warehousing - The act of storing goods in a warehouse.
Metadata can be seen as summarized data that leads us to detailed data. It is a road-map, defines the warehouse objects, acts as a directory.
A data warehouse, is a medium with created metadata for the data names and definitions of a given data warehouse. Data extractions from this warehouse is often time-stamped by other metadata and also show its source.
The description for each type of Meta data in the data warehouse can be seen categorized into Business, Technical and Operational Metadata.
• Business Metadata − this category embodies the ownership information, business definition, and changing policies.
Technical Metadata − It embodies database system names, key attributes and indices (structural information), data types and allowed values, table and column names and sizes.
Operational Metadata − It embodies both the currency of data and data lineage. Currency of data shows whether the data is archived, active, or purged. Lineage of data shows the history of data migrated and transformation applied on it.
Ответ:
Meta data is a set of data that describes and gives information about other data.
Explanation:
A)(i) Meta data is a set of data that describes and gives information about other data.
(ii) Metadata is important because, it acts as a directory which helps the decision support system to locate the contents of the data warehouse. It is also important in loading functions and is a good query, extraction and cleaning tool.
B) - Business Metadata: This has the data ownership information, business definition, and changing policies.
- Technical Metadata: This includes database system names, table and column names and sizes, data types and allowed values. Technical metadata also includes structural information such as primary and foreign key attributes and indices.
- Operational Metadata − This includes currency of data and data lineage. Currency of data means whether the data is active, archived, or purged. Lineage of data means the history of data migrated and transformation applied on it.
C) In a data warehouse, metadata is used for the data names and definitions of a given data warehouse. Along with this metadata, additional metadata is also created for time-stamping any extracted data, the source of extracted data. Whereas, in databases, metadata is created to store data in a structured manner that is organized in tables and columns and extended with primary and unique constraints on the data, foreign keys, check constraints or data types.
Ответ:
The administrator should create a rule to share all price books to sales users.
Explanation:
A network administrator is responsible for configuring and managing network resource access. The administrator creates rules or policies on how information or other services are accessed by different levels of users in a network.