What is Data Collection Frequency and the Bi-Directional Extract?

Asked By 40 points N/A Posted on -
qa-featured

Hi,

I am a bit confused and mixing the concepts of data collection frequency. What is Data Collection Frequency? What is Bi-directional Extract? Please solve my problem as soon as possible.

Thanks in advance.

SHARE
Best Answer by Roadstriker1987
Answered By 25 points N/A #128345

What is Data Collection Frequency and the Bi-Directional Extract?

qa-featured

Data collection frequency is the rate at which data is collected. However, the data is not just collected and stored. It goes through various stages of processing like extracting from various sources, cleansing, transforming and then storing in useful patterns. It is important to have a record of the rate at which data is collected because of various reasons: Companies can use these records to keep a track of the transactions that have occurred.

Based on these records the company can know if any invalid transactions ever occurred. In scenarios where the market changes rapidly, companies need very frequently updated data to enable them make decisions based on the state of the market and then invest appropriately.

A few companies keep launching new products and keep updating their records so that their customers can see them which would in turn increase their business. When data warehouses face technical problems, the logs as well as the data collection frequency can be used to determine the time and cause of the problem.

Due to real time data collection, database managers and data warehouse specialists can make more room for recording data collection frequency.

Bi-directional Extract, In hierarchical, networked or relational databases, the data can be extracted, cleansed and transferred in two directions. The ability of a system to do this is referred to as bidirectional extracts.

Answered By 0 points N/A #128346

What is Data Collection Frequency and the Bi-Directional Extract?

qa-featured

Data Collection Frequency refers to the time frequency at which data is collected, this process is done after regular intervals. It refers to the time of the day or year in a given period.

DCF (Data Collection Frequency) is important in recording inventory transactions as they are used record inflows (receipts) and outflows (shipments) of inventory at loading stocks.

DCF is particular a great help in advertising and marketing by determining media exposure of. As it is used in calculating the number of prospects which have been reached with different media vehicles at different levels of frequency of exposure.

Best Answer
Best Answer
Answered By 0 points N/A #128347

What is Data Collection Frequency and the Bi-Directional Extract?

qa-featured

Hi I Am Adrian,

Here is my explanation regarding your question about the Data Collection Frequency.

Data Collection Frequency, just as the name suggests refers to the time frequency at which data is collected at regular intervals. This often refers to whatever time of the day or the year in any given length of period.

In a data warehouse, the relational database management systems continually gather, extract, transform and load data onto the storage system. Along with these processes, there could be a potentially large number of data consumers simultaneously accessing data warehouses getting aggregated data reports for statistical analysis of both company and industry trends. Having a log of the data collection frequency of a data warehouse is very important for a lot of reasons.

For one, having knowledge about data collection frequency is extremely important in recording inventory transactions. A company can take a physical inventory to be used later in reconciling quantities recorded in stocks. The inventory transaction records can be used to record inflows (receipts) and outflows (shipments) of inventory at loading stocks.

At the final stage, the data of inventory transactions will be batch updated along with implementing extensive and intensive error checking for quantities, negative inventories validated warehouse amounts and valid serial numbers. All these activities are monitored by the data warehouse system and data collection frequency will be useful in analyzing so many things like if the transactions were legal or illegal and many other related useful information.

In a company data warehouse, data collection solutions are important because they enable the business organization to have real time information and visibility in supply chain. This can greatly improve decision making processes, accuracy in customer information and products or services sales and material availability and reporting data warehouse operations. The data collection frequency can also help increase return of investments (ROI) through improved equipment and labor productivity.

Data collection frequency is particular a great help in advertising and marketing by determining media exposure of, say, an e-commerce website. And e-commerce website needs to have intensive media exposure. In the internet where e-commerce takes place, there are thousands of other competitors. There competitors will do all they can to get top exposure to internet users and buyers. One way to do this is to get top ranks in search engines.

Data collection frequency record is a good determinant for media exposure of the e-commerce site and the products and services it offers. The record for frequency of data collected could be used in calculating the number of prospects which have been reached with different media vehicles at different levels of frequency of exposure.

Sometime, data warehouses can experience problems both hard and software in nature. To troubleshoot problems, IT professionally generally look at the logs to see which point the system encountered such problems. Having a record for data collection frequency can give the troubleshooter some hints about problem. For instance, at some point, data collection was so heavy that it could cause processing to be intensive to the point of hardware breakdown.

Business intelligence is fast evolving and has long been a critical component of a company's daily operations. As it continues to evolve, the need for real time data warehouse which can provide data consumers with rapid updates becomes even more demanding.

Many companies are finding that they need to refresh their data warehouses on more frequent basis because tools in business intelligence are being used more and more often for decision making in operations. According to may data warehouse specialists, data warehouse is not just about loading data for business analyst to forecast; it is more about daily decisions.

With real time data collection, for sure database managers and data warehouse specialists will surely make more room for recording data collection frequency.

Regards,

Adrian G.

Answered By 0 points N/A #128348

What is Data Collection Frequency and the Bi-Directional Extract?

qa-featured

Data Collection Frequency, just as the same suggests refers to the time frequency at which data is collected at regulars intervals. This often refers to whatever time of the day or the year in any given length of period.

Bi-directional extracts refers to the ability of a system to extract, cleanse and transfer data in two directions among diff rent database types which include hierarchical,networked, and relational databases.

This functionality is extremely useful in data warehousing projects. Data warehouse extraction is the process of retrieving all sorts of data including unstructured and badly constructed from various data sourced. This data will be furthered processed and migrated to other storage locations.

Related Questions