| Home : Concepts : Data Warehouse |
| Click "Subscribe" if you want to be notified of new or updated links in this category. | Subscribe |
|
|
Data Warehouse Listings
|
|
Total:
105 | Displaying: 71 - 80 | Pages: << 1 2 3 4 5 6 7 8 9 10 >> |
|
|
|
Functional Data warehouse is a warehouse that draws data from nearby operational systems. Each functional warehouse serves a distinct and separate group (such as a division), functional area (such as manufacturing), geographic unit, or product marketing group. Today's business environment is very data driven and more companies are hoping to create competitive advantage over other business organization competitors by creating a system whereby they can assess the current status of their operations any at any given moment and at the same time, they can also analyze trends and patterns within the company operation and its relation to the trends and patterns of the industry in a truly up-to-date fashion.
Price: Free - Updated: 12/19/2007
|
|
|
Operational Database is the database-of-record, consisting of system-specific reference data and event data belonging to a transaction-update system. It may also contain system control data such as indicators, flags, and counters. The operational database is the source of data for the data warehouse. It contains detailed data used to run the day-to-day operations of the business. The data continually changes as updates are made, and reflect the current value of the last transaction. An operational database contains enterprise data which are up to date and modifiable. In an enterprise data management system, an operational database could be said to be an opposite counterpart of a decision support database which contain non-modifiable data that are extracted for the purpose of statistical analysis. An example use of a decision support database is that it provides data so that the average salary of many different kinds of workers can be determined while the operational database contains the same data which would be used to calculate the amount for pay checks of the workers depending on the number of days that they have reported in any given period of time.
Price: Free - Updated: 12/19/2007
|
|
|
An Operational Data Store (ODS) is an integrated database of operational data. Its sources include legacy systems and it contains current or near term data. An ODS may contain 30 to 60 days of information, while a data warehouse typically contains years of data. An operational data store is basically a database that is used for being an interim area for a data warehouse. As such, its primary purpose is for handling data which are progressively in use such as transactions, inventory and collecting data from Point of Sales. It works with a data warehouse but unlike a data warehouse, an operational data store does not contain static data. Instead, an operational data store contains data which are constantly updated through the course of the business operations.
Price: Free - Updated: 12/19/2007
|
|
|
On-Line Analytical Processing is a processing that supports the analysis of business trends and projections. It is also known as decision support processing and OLAP. An OLAP software enables companies to have real-time analysis of data stored in a database. An OLAP server is typically a separate component of an information system which contains specially coded algorithms and indexing tools to efficiently process data mining tasks with minimal impact on database performance. OLAP uses multidimensional view of aggregate data to provide quick access to strategic information for further analysis and with this, a data user can have fast and very efficient view of data analysis as OLAP turns raw data into information that can be understood by users and manipulated in various ways. The multidimensional views of data that OLAP requires also come with packaged calculation-intensive capabilities and time intelligence.
Price: Free - Updated: 12/19/2007
|
|
|
On-Line Transaction Processing is a processing that supports the daily business operations. Also know as operational processing and OLTP. An OLTP is a database which must typically allow the real-time processing of SQL transactions to support traditional retail processes, e-commerce and other time-critical applications. It is also a class of program that helps to manage or facilitate transaction oriented applications such as data entry and retrieval transactions in a number of industries, including banking, airlines, mail order, supermarkets, and manufacturers. With today's business environment, it is impossible to run a business without having to rely on data. Processing online transactions these days increasingly requires support for transactions spanning a large network or even the global internet and may include many companies. Because of this great demand, many new OLTP software implementations use client – server processing and brokering of software applications that can enable transactions to run on various computer platforms within a network.
Price: Free - Updated: 12/19/2007
|
|
|
Operational Metadata are metadata about operational data. Metadata is basically a kind of data that describes another data, content item or another collection of data which includes multiple content items. Its main purpose is to facilitate better understanding, use and management of data. The use and requirement of metadata varied depending on the context where it is being used. For example, when metadata are employed in a library information system, the metadata that will be used would be about description of book contents, title, data of publication, location of the book on the shelf and other related information. If metadata are to be employed in a photography system, the metadata to use would involve information about cameras, camera brand, camera models and other.
Price: Free - Updated: 12/19/2007
|
|
|
A Centralized Data Warehouse is a data warehousing implementation wherein a single data warehouse serves the needs of several separate business unites simultaneously using a single data model that spans the needs of multiple business divisions.
Today, having information means having power. In any a lot of aspects of daily living, having relevant information can give us more ease in daily activities. This is made manifest by the use of the internet. Because of the information that can be obtained everyday, internet users are growing by the day and the time people spend on the internet is getting longer as web services are getting more and more sophisticated with applications that can gather and aggregate billions of disparate data into useful information.
Price: Free - Updated: 12/19/2007
|
|
|
Metadata Warehouse is a database that contains the common metadata and client-friendly search routines to help people fully understand and utilize the data resource. It contains common metadata about the data resource in a single organization or an integrated data resource that crosses multiple disciplines and multiple jurisdictions. It contains a history of the data resource, what the data initially represented, and what they represent now.
Price: Free - Updated: 12/19/2007
|
|
|
Active Data Warehouse is repository of any form of captured transactional data so that they can be used for the purpose of finding trends and patterns to be used for future decision making. According to Bill Inmon, a prominent data warehousing practitioner, data warehouse defined in terms of subject-oriented, time variant, non-volatile and integrated.
Price: Free - Updated: 12/10/2007
|
|
|
A Central Data Warehouse is a repository of company data where a database is created from operational data extracts. This database adheres to a single, consistent enterprise data model to ensure consistency in decision making support across the company. A Central Data Warehouse is a single physical database which contains business data for a specific function area, department, branch, division or the whole enterprise. Choosing the central data warehouse is commonly based on where there is the largest common need for informational data and where the largest numbers of end users are already hooked to a central computer or a network.
Price: Free - Updated: 12/10/2007
|
|
|
Data Warehouse Listings
|
|
Total:
105 | Displaying: 71 - 80 | Pages: << 1 2 3 4 5 6 7 8 9 10 >> |
|
|
