Different Enterprise Organizations are using Data Warehousing techniques to handle their business. Data warehouse technique is applied according to size and nature of the transaction of the organization.A data mart contains a subset of corporate-wide data that is of value to a specific group of users.Depending on the source of data, data marts can be categorized as independent or dependent.
Different Enterprise Organizations are using Data Warehousing techniques to handle their business. Data warehouse technique is applied according to size and nature of the transaction of the organization. The diverse data warehouse are listed below
Enterprise Warehouse
An enterprise warehouse collects all of information about the subject spamming the entire organization. It provides corporate-wide data integration, usually from one or more operational systems or external information providers, and is cross-functional in scope. It typically contains detailed data as well as well as summarized data, and can range in size from few gigabytes to hundreds of gigabytes, terabytes or beyond. An enterprise data warehouse may be implemented on traditional mainframes, UNIX super servers or parallel architecture platforms. It requires extensive business modeling and may take years to design and build.
Data Mart
A data mart contains a subset of corporate-wide data that is of value to a specific group of users. The scope is confined to specific selected subjects. For example , marketing data mart may confine its subject to custom to customer, item, and sales. The data contained in data mart tends to be summarized.
Data marts are usually implemented on low cost department servers that are UNIX or Windows/NT based. The implementation cycle of a data mart is more likely to be measured in weeks rather than months or years. However, it may involve complex integration in the long run if its design and planning were not enterprise-wide
Depending on the source of data, data marts can be categorized as independent or dependent. Independent data marts are sourced from data captured from one or more operational systems or external information providers, or from data generated locally within a particular department or geographic area. Depending data marts are sourced directly from enterprise data warehouse.
Virtual Warehouse
A virtual warehouse is set of views over operational databases. For efficient query processing , only some of the possible summary views may be materialized. A virtual warehouse is easy to build but requires excess capacity on operational database servers.
The top-down development of an enterprise warehouse serves as a systematic solution and minimum integration problems. However, it is expensive, takes a long time to develop, and lacks flexibility due to the difficulty in achieving consistency and consensus for a common data model for the entire organization. The bottom-up approach to design, development, and deployment of independent data marts provides flexibility, low cost, and rapid return of investment. It however, can lead to problems when integration various disparate data marts into a consistent enterprise.
Computer Software Training for your life
With the advent of IT in every field of life, it has become unavoidable for everyone to learn computer technology to some extent. Learning computer software education through online courses is a very simple task.Give a serious thought on what you exactly want to learn and then select the best software provider with reasonable rates.
An Overview of Data Mining
Extracting the predictive patterns and relevant information from a huge data is termed as Data Mining. It helps in acquiring patterns that contribute to decision making.There are various information mining (DM) methods and the kind of information being analyzed firmly impacts the sort of information mining system utilized. Bunching alludes to the arrangement of information bunches that are gathered together by some kind of relationship that recognizes that information as being comparative.
General Ledger Accounting in SAP FICO
General ledger accounting is normally used for comprehensive picture of external financial report. It a known fact that from general ledger every financial statement of an organization is prepared.All definitions of general ledger are placed in charts of accounts in an organized array and every general ledger is organized and prepared according to charts of accounts.While we work world wide we have to follow the rules of that country in which we are working. It means that country specific charts of account are country dependent. It is optional part depending upon the business you have.
