answersLogoWhite

0

A data warehouse architecture is similar to various relational database systems. What makes the best architecture is the organization of the warehouse itself and the data it consist of.

User Avatar

Wiki User

12y ago

What else can I help you with?

Continue Learning about Art & Architecture

Difference between van humann architecture and hardvard architecture?

In the Von Neumann (not "von humann") architecture instructions and data share the same bus and address space, while in the Harvard architecture instructions and data are accessed through separate buses.


What is the best place to look for data center architecture?

Designing data centers is a complex task. Designers have to create plans that efficiently getting power and data to all the servers, and efficiently removing the heat those servers produce. Cisco provides guidelines on best practices for data center design on their website.


What is cut-through architecture?

In a cut-through architecture, the data frame begins to exit the switch almost as soon as it begins to enter the switch.


What is the role of data mart?

A data mart is a subset of a data warehouse, designed to serve the specific needs of a particular business line or department, such as sales, finance, or marketing. It streamlines data access and analysis by providing focused, relevant information tailored to the users' requirements, which enhances decision-making efficiency. By organizing data in a way that is more manageable and understandable, data marts help businesses leverage their data assets effectively. Additionally, they often improve performance and reduce query times compared to accessing a full data warehouse.


Which architecture uses Internet?

The architecture that uses the Internet is commonly referred to as the client-server architecture. In this model, clients (users' devices) connect to servers (remote machines) over the Internet to request and exchange data. Additionally, cloud computing architecture leverages the Internet to provide scalable resources and services on-demand. Both architectures rely on Internet protocols to facilitate communication and data transfer.

Related Questions

What is metadata what is its use in data warehouse architecture?

Metadata is data about data that provides information such as the structure, format, and characteristics of the data stored in a data warehouse. It is used in data warehouse architecture to facilitate data integration, data governance, and data lineage. Metadata helps users understand and manage the data in the data warehouse efficiently.


What is distributed data warehouse?

A distributed data warehouse is a type of data warehouse architecture where data is distributed across multiple servers or nodes in a network. This allows for improved scalability, performance, and fault tolerance compared to a centralized data warehouse. Distributed data warehouses can handle large volumes of data more efficiently by spreading the workload across multiple nodes.


Briefly describe three-tier Data warehouse architecture?

Three-Tier Architecture of Data WarehouseClient:-* GUI/Presentation logic* Query specification* Data Analysis* Report formatting* Data accessApplication/Data Mart Server:-* Summarizing* Filtering* Meta Data* Multidimensional view* Data accessData Warehouse Server:-* Data logic* Data services* Meta data* File services


What is data where housing and mining?

it's data warehouse....data warehouse: it is a collection of multiple databases or it it is repository of data.data mining it is the process of extracting data from data warehouse.


What do you mean by data warehouse?

Data warehouse is a house where current as well as historical data can be stored.


What are the key relationships between data warehouse and data mining?

Data warehouse is the database on which we apply data mining.


How does Data Warehouse differ from Data Mart?

Data marts are combined into a data warehouse cannot be built alone without considering data marts. Both has equal importance to built proper data warehouse.


What is data Warehouse Systems?

A data warehouse system is just a database that provides a single-point of access to multiple ERP systems (ERP = software systems used by companies). The different ERP will be interfaced to the data warehouse so that the data can be stored and shared by multiple ERP in a single point. From a software architecture and a business point of view, it's more convenient to centralize data in one point instead of having this data spread on tens of different software systems. Typically a data warehouse will centralize a given kind of business data in one storage point to make it easier for management / other systems to process and access this data.


Every data structure in data warehouse contains time element?

Every data structure in the data warehouse contains the time element. Why?


What are benefits of data warehouse?

One of the biggest benefits is that you can archive your data to a data warehouse. This can keep your main "production" database smaller which can provide some performance benefits. Also you can use the data warehouse to run complex queries and data-mining without adverse effects on the performance of your "production" application.


What are the advantages of a warehouse?

Data warehouse is the pool of huge amount of data. The data in data ware house can be archived. And when the data is needed you can extract it from the archived files.


What describes contents of a data warehouse?

A data warehouse stores structured data from various sources for analysis and reporting. It typically includes historical data, organized into tables, aimed at supporting decision-making processes. Data warehouses are optimized for complex queries and data aggregation.