3,834 Hits in 7.5 sec

OLAP and statistical databases

Arie Shoshani
1997 Proceedings of the sixteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems - PODS '97  
We start, in section 2, with a couple of illustrative example of SDBs and OLAP databases, and expose the conceptual similarity between them.  ...  Tn section 3, we describe typical PODS ' 97 Tucson Arizona USA O-89791-910-6/97/05 application areas in SDBs and OLAP, and discuss similarities as well as differences in such applications.  ...  From the examples above it is clear that SDBs and OLAP databases have very similar problems. However, each area has emphasized different aspects.  ... 
doi:10.1145/263661.263682 dblp:conf/pods/Shoshani97 fatcat:nnwnpitmufdazda7yjhdk3pl4y

Topic modeling for OLAP on multidimensional text databases: topic cube and its applications

Duo Zhang, ChengXiang Zhai, Jiawei Han, Ashok Srivastava, Nikunj Oza
2009 Statistical analysis and data mining  
In this paper, we propose a new data model called topic cube to combine OLAP with probabilistic topic modeling and enable OLAP on the dimension of text data in a multidimensional text database.  ...  While online analytical processing (OLAP) techniques have been proven very useful for analyzing and mining structured data, they face challenges in handling text data.  ...  National Science Foundation grants IIS-0842769, IIS-0713571 and IIS-0713581, and the Air Force Office of Scientific Research MURI award FA9550-08-1-0265.  ... 
doi:10.1002/sam.10059 fatcat:b7mpn3tahrg4dna4y7yymeo56y

OLAPS: Online load-balancing in range-partitioned main memory database with approximate partition statistics

Djahida Belayadi, Khaled-Walid Hidouci, Ladjel Bellatreche
2018 Computer Science and Information Systems  
Unfortunately, data skew is one of the main problems faced during parallel processing in a parallel main memory database.  ...  Modern database systems can achieve high throughput main-memory query execution by being aware of the dynamics of highly parallel hardware.  ...  The main feature of our OLAPS system is the PST . Each client or node has its own and potentially imperfect partition statistics table.  ... 
doi:10.2298/csis170320007b fatcat:mzc2qaun2bbypk2f3xtjzchkjq

Exploration and visualization of OLAP cubes with statistical tests

Carlos Ordonez, Zhibo Chen
2009 Proceedings of the ACM SIGKDD Workshop on Visual Analytics and Knowledge Discovery Integrating Automated Analysis with Interactive Exploration - KDD '09  
In this work, we propose to combine OLAP dimension lattice traversal and statistical tests to discover significant metric differences between highly similar groups.  ...  In On-Line Analytical Processing (OLAP), users explore a database cube with roll-up and drill-down operations in order to find interesting results.  ...  In contrast, our work relies on statistical tests to explore OLAP cubes and can automatically detect significant metric differences between highly similar groups.  ... 
doi:10.1145/1562849.1562855 dblp:conf/kdd/OrdonezC09 fatcat:4b3kk6mkm5fdjmmtonpsstl7sq

Statistical Databases [chapter]

Claus Boyens, Oliver Günther, Hans-J. Lenz
2011 Handbook of Computational Statistics  
Especially for this reason, classifying statistical disclosure control methods as presented here on an absolute scale is almost an impossible task.  ...  Duncan and Keller-McNulty (2001) present a formal framework to measure this trade-off between disclosure risk and data utility, the Risk-Utility (R-U) map.  ...  Views (Virtual Tables) Statistical databases are often accessed by different users with different intentions and different access rights.  ... 
doi:10.1007/978-3-642-21551-3_10 fatcat:2g6zipba3rfbpptyjzfpnaoequ

Multidimensionality in Statistical, OLAP and Scientific Databases [chapter]

Arie Shoshani
Multidimensional Databases  
., 1996) , which is an extension to the relational model to support OLAP databases. It was not apparent initially that both the statistical database and OLAP areas are addressing a similar problem.  ...  Multidimensionality in Statistical, OLAP, and Scientific Databases 53Copyright © 2003, Idea Group Inc.  ... 
doi:10.4018/978-1-59140-053-0.ch002 fatcat:uiocaiikb5gbxje3oj2fbhtzoe

Multidimensional Databases [chapter]

Torben Bach Pedersen, Christian Jensen
2004 Industrial Electronics  
Multidimensional databases differ from previous technologies by viewing data specifically as multidimensional cubes, which have proven to be particularly well suited for data analyses.  ...  Multidimensional databases is a key technology in the enabling of interactive analyses of large amounts of data for decision-making purposes.  ...  and statistical data models.  ... 
doi:10.1201/9781420036336.ch12 fatcat:kqinkzwdmjbpbnawpw2k6su6ju

Database Learning

Yongjoo Park, Ahmad Shahab Tajik, Michael Cafarella, Barzan Mozafari
2017 Proceedings of the 2017 ACM International Conference on Management of Data - SIGMOD '17  
In today's databases, previous query answers rarely benefit answering future queries.  ...  We call this novel idea---learning from past query answers---Database Learning.  ...  We believe ADL can be a primary OLAP technique in AQP context, as an advance over the popular materialized views for (more traditional) existing database systems.  ... 
doi:10.1145/3035918.3064013 dblp:conf/sigmod/ParkTCM17 fatcat:uqawl5n2qzhmllgkongmehxklu

Mining knowledge from databases

Jiawei Han, Yizhou Sun, Xifeng Yan, Philip S. Yu
2010 Proceedings of the 2010 international conference on Management of data - SIGMOD '10  
, and data qualify improvement, how to discover various kinds of knowledge from information networks, how to perform OLAP in information networks, and how to transform database data into knowledge by information  ...  Most people consider a database is merely a data repository that supports data storage and retrieval.  ...  For example, different research areas and ranks for authors and conferences can be discovered by such analysis in a bibliographic database, which will be useful for users to better understand the data  ... 
doi:10.1145/1807167.1807333 dblp:conf/sigmod/HanSYY10 fatcat:y3ozzuynxfb3rdtrbf3jldjkci

Data and Databases [chapter]

Alan Julian Izenman
2013 Springer Texts in Statistics  
Statistical Packages and DBMSs Some statistical analysis packages (e.g., SAS, SPSS) and Matlab can run their complete libraries of statistical routines against their OLAP database servers.  ...  database statistics.  ... 
doi:10.1007/978-0-387-78189-1_2 fatcat:kmpl4bzbovg5zg3chuovpzsp2u

Database technology for decision support systems

S. Chaudhuri, U. Dayal, V. Ganti
2001 Computer  
Typically, the data warehouse is maintained separately from the organization's operational databases because analytical applications' functional and performance requirements are quite different from those  ...  of operational databases.  ...  Many of the techniques devised for statistical databases are relevant for MOLAP servers.  ... 
doi:10.1109/2.970575 fatcat:2il3danygbhxnanzwt33kfnpie

A Storage Advisor for Hybrid-Store Databases [article]

Philipp Rösch, Lars Dannecker, Gregor Hackenbroich, Franz Faerber
2012 arXiv   pre-print
Hybrid-store databases---that is, databases supporting row- and column-oriented data management---are getting more and more prominent.  ...  Besides a per-table decision, our tool also considers to horizontally and vertically partition the data and manage the partitions on different stores.  ...  For this table, we generated a workload consisting of different OLAP and OLTP queries.  ... 
arXiv:1208.4169v1 fatcat:jwi2l3v4wbhvvf73xqbtl3feme

A storage advisor for hybrid-store databases

Philipp Rösch, Lars Dannecker, Franz Färber, Gregor Hackenbroich
2012 Proceedings of the VLDB Endowment  
Hybrid-store databases-that is, databases supporting row-and column-oriented data management-are getting more and more prominent.  ...  Besides a per-table decision, our tool also considers to horizontally and vertically partition the data and manage the partitions on different stores.  ...  For this table, we generated a workload consisting of different OLAP and OLTP queries.  ... 
doi:10.14778/2367502.2367514 fatcat:nni7j36evzd6fi7v3kdessbc2q

Engineering high-performance database engines

Thomas Neumann
2014 Proceedings of the VLDB Endowment  
Database engines are very complex software artifacts that have to scale to large data sizes and large hardware configurations, and developing such systems usually means choosing between different trade-offs  ...  This papers gives a survey over two different database engines, the disk-based SPARQL-processing engine RDF-3X, and the relational main-memory engine HyPer.  ...  This is not an issue for the more common read-only OLAP queries, but if OLAP transactions decide to modify the data, the database can use a similar mechanism to decide if changes can be safely merged back  ... 
doi:10.14778/2733004.2733076 fatcat:67gulifelbd37p2xe3qaiwdu5m

The multidimensional database system RasDaMan

P. Baumann, A. Dehmel, P. Furtado, R. Ritsch, N. Widmann
1998 SIGMOD record  
Efficient serverbased query evaluation is enabled by an intelligent optimizer and a streamlined storage architecture based on flexible array tiling and compression.  ...  ., domain-independent -array DBMS for multidimensional arrays of arbitrary size and structure. A declarative, SQL-based array query language offers flexible retrieval and manipulation.  ...  MDD appear in a host of database applications: OLAP, statistics, earth and space sciences, medical imagery, wind channels, simulations, and multimedia comprise but a few representatives.  ... 
doi:10.1145/276305.276386 fatcat:yyj6ntyogfdchbxhdissz76hgm
« Previous Showing results 1 — 15 out of 3,834 results