Data warehousing and on-line analytical processing (OLAP)
are essential elements of decision support, which has
increasingly become a focus of the database industry. Many
commercial products and services are now available, and all
of the principal database management system vendors now
have offerings in these areas. Decision support places some
rather different requirements on database technology
compared to traditional on-line transaction processing
applications. This paper provides an overview of data
warehousing and OLAP technologies, with an emphasis on
their new requirements. We describe back end tools for
extracting, cleaning and loading data into a data warehouse;
multidimensional data models typical of OLAP; front end
client tools for querying and data analysis; server extensions
for efficient query processing; and tools for metadata
management and for managing the warehouse. In addition to
surveying the state of the art, this paper also identifies some
promising research issues, some of which are related to
problems that the database research community has worked
on for years, but others are only just beginning to be
addressed. This overview is based on a tutorial that the
authors presented at the VLDB Conference, 1996.
Data warehousing and on-line analytical processing (OLAP)are essential elements of decision support, which hasincreasingly become a focus of the database industry. Manycommercial products and services are now available, and allof the principal database management system vendors nowhave offerings in these areas. Decision support places somerather different requirements on database technologycompared to traditional on-line transaction processingapplications. This paper provides an overview of datawarehousing and OLAP technologies, with an emphasis ontheir new requirements. We describe back end tools forextracting, cleaning and loading data into a data warehouse;multidimensional data models typical of OLAP; front endclient tools for querying and data analysis; server extensionsfor efficient query processing; and tools for metadatamanagement and for managing the warehouse. In addition tosurveying the state of the art, this paper also identifies somepromising research issues, some of which are related toproblems that the database research community has workedon for years, but others are only just beginning to beaddressed. This overview is based on a tutorial that theauthors presented at the VLDB Conference, 1996.
การแปล กรุณารอสักครู่..
Data warehousing and on-line analytical Processing (OLAP)
are Essential Elements of Support decision, which has
increasingly become a Focus of the Database Industry. Many
are now Available Commercial products and Services, and all
of the Principal Database Management System vendors now
have Offerings in these areas. Support decision Places Some
rather different requirements on Database Technology
compared to traditional on-line Transaction Processing
Applications. This Paper provides an Overview of Data
warehousing and OLAP Technologies, with an emphasis on
their New requirements. We describe Back End Tools for
extracting, Cleaning and Loading Data into a Data Warehouse;
multidimensional models typical of OLAP Data; Front End
Client Tools for querying and Data Analysis; Server extensions
for efficient Query Processing; and Tools for metadata
and for Managing the Warehouse Management. In addition to
the State of the Art Surveying, this Paper also identifies Some
promising Research issues, which are Related to Some of
the problems that Research Database Community has worked
on for years, but others are only just Beginning to be
addressed. This is based on a Tutorial Overview that the
Authors Presented at the VLDB Conference, 1996th.
การแปล กรุณารอสักครู่..
Data warehousing and on-line analytical processing (OLAP)
are essential elements of, decision support which has
increasingly. Become a focus of the database industry. Many
commercial products and services are, now available and all
of the principal. Database management system vendors now
have offerings in these areas. Decision support places some
.Rather different requirements on database technology
compared to traditional on-line transaction processing
applications.? This paper provides an overview of data
warehousing and, OLAP technologies with an emphasis on
their new requirements. We. Describe back end tools for
extracting cleaning and, loading data into a data warehouse;
multidimensional data models typical. Of OLAP; front end
.Client tools for querying and data analysis; server extensions
for efficient query processing; and tools for metadata
management. And for managing the warehouse. In addition to
surveying the state of the art this paper, also identifies some
promising. Research issues some of, which are related to
problems that the database research community has worked
on, for yearsBut others are only just beginning to be
addressed. This overview is based on a tutorial that the
authors presented at. The, VLDB Conference 1996.
การแปล กรุณารอสักครู่..