In a large company, with large databases or large systems for separate functions, such as manufacturing, sales, and accounting, special capabilities and tools are required for analyzing vast quantities of data and for accessing data from multiple systems. These capabilities include data warehousing, data mining, and tools for accessing internal databases through the Web. Show
Data WarehouseA data warehouse is a repository of multiple heterogeneous data sources organized under a unified schema at a single site to facilitate management decision making. A data warehouse is a subject-oriented, integrated, time-variant and nonvolatile collection of data in support of management‘s decision-making process.
A data warehouse is a repository of current and historical data of an organization that are organized to facilitate reporting and analysis. The data originate in many core operational transaction systems, such as systems for sales, customer accounts, and manufacturing, and may include data from Web site transactions. The data warehouse consolidates and standardizes information from different operational databases so that the information can be used across the enterprise for management analysis and decision making. Figure below illustrates how a data warehouse works. The data warehouse makes the data available for anyone to access as needed, but it cannot be altered. A data warehouse system also provides a range of ad hoc and standardized query tools, analytical tools, and graphical reporting facilities. Many firms use intranet portals to make the data warehouse information widely available throughout the firm. Data warehouseHow does a data warehouse differ from a database?There are a number of fundamental differences which separate a data warehouse from a database. The biggest difference between them is that most database place an emphasis on a single application, and this application will generally be one that is based on transaction. If the data is analyzed, it will be done within a single domain. In contrast, data warehouses deal with multiple domains simultaneously. Because data warehouse deals with multiple subject areas, the data warehouse finds connections between them. This allows the data warehouse to show how the company is performing as a whole, rather than in individual areas. Another powerful aspect of data warehouse is their ability to support the analysis of trends. They are not volatile, and the information stored in them doesn‘t change as much as it would in a common database. Some of the major differences between them are listed below:
Data MartsData mart is a database that contains a subset of data present in a data warehouse. We can divide a data warehouse into data marts after the data warehouse has been created. A data mart is a subset of a data warehouse in which a summarized or highly focused portion of the organization‘s data is placed in a separate database for a specific population of users. For example, a company might develop marketing and sales data marts to deal with customer information. A data mart typically focuses on a single subject area or line of business, so it usually can be constructed more rapidly and at lower cost than an enterprise-wide data warehouse. Reasons for creating a data mart
What are the principle tools and technologies for accessing information from database to improve business performance and decision making?Business intelligence (BI) tools: Data analysis tools used for consolidating, analyzing, and accessing vast stores of data to help in decision making, such as software for database query and reporting, tools for multidimensional data analysis (online analytical processing), and data mining.
How database can be used to improve business performance and decision making?A good database can help improve business performance by simplifying inventory management and tracking. It is common knowledge that managing your inventory properly often comes as a difficult challenge especially when your company starts growing rapidly. Having too much or little inventory is always a risk.
How can a database system help improve a business?Databases are collections of organised information that can easily be accessed, managed, and updated. Database systems are essential to your business because they communicate information related to your sales transactions, product inventory, customer profiles, and marketing activities.
What are the technologies used in database?SQL: The language of database access. NoSQL databases: Non-relational and distributed data.. Server-side scripting.. HTML and CSS.. SQL, a database language.. A database management system (DBMS). |