Results 211 to 220 of about 19,545 (258)
Some of the next articles are maybe not open access.
Integrating Star and Snowflake Schemas in Data Warehouses
International Journal of Data Warehousing and Mining, 2012A fundamental issue encountered by the research community of data warehouses (DWs) is the modeling of data. In this paper, a new design is proposed, named the starnest schema, for the logical modeling of DWs. Using nested methodology, data semantics can be explicitly represented.
Georgia Garani, Sven Helmer
openaire +1 more source
Columnar NoSQL Star Schema Benchmark
2014Benchmarking data warehouses is a means to evaluate the performance of systems and the impacts of different technical choices. Developed on relational models which have been for a few years the most used to support classical data warehousing applications such as Star Schema Benchmark (SSB).
Dehdouh, Khaled +2 more
openaire +2 more sources
Building a star join schema using SQL Server
Proceedings. Eleventh International Conference on Scientific and Statistical Database Management, 2003We construct a star join schema and show how this schema can be created using the basic tools delivered with SQL Server 7.0. The major objectives are to keep the operational database unchanged so that data loading can be done without disturbing the business logic of the operational database.
J.O. Sorensen, K. Alnor
openaire +1 more source
Mining multi-relational high utility itemsets from star schemas
Intelligent Data Analysis, 2018Mining high utility itemsets is an interesting research problem in data mining and knowledge discovery. Most high utility itemset discovery algorithms seek patterns in a single table, but few are dedicated to processing data stored using a multi-dimensional model.
Song, Wei, Jiang, Beisi, Qiao, Yangyang
openaire +1 more source
Efficient execution of joins in a star schema
Proceedings of the 2002 ACM SIGMOD international conference on Management of data, 2002A star schema is very popular for modeling data warehouses and data marts. Therefore, it is important that a database system which is used for implementing such a data warehouse or data mart is able to efficiently handle operations on such a schema. In this paper we will describe how one of these operations, the join operation --- probably the most ...
openaire +1 more source
Towards the Integration of Constrained Mining with Star Schemas
2013 IEEE 13th International Conference on Data Mining Workshops, 2013A growing challenge in data mining is the ability to deal with complex, voluminous and dynamic data. In many real world applications, complex data is organized in multiple inter-related database tables, which makes their analysis as a whole more difficult and challenging.
Andreia Silva, Claudia Antunes
openaire +1 more source
Implementasi Star Schema Dalam Perancangan Datawarehouse Akademik Perguruan Tinggi
Cakrawala Repositori IMWI, 2021Data akademik merupakan data yang penting bagi perguruan tinggi. Data ini menjadi rekam jejak aktifitas KBM di perguruan tinggi, yang menjelaskan kegiatan yang berawal dari penerimaan mahasiswa, proses pembelajaran, evaluasi, hingga kelulusan mahasiswa.
openaire +1 more source
The translation of star schema into entity-relationship diagrams
Database and Expert Systems Applications. 8th International Conference, DEXA '97. Proceedings, 2002The star schema is widely accepted as an appropriate underlying table structure for data warehouses, but enterprise data is frequently defined in terms of entity-relationship diagrams. A key issue for data warehouse designers is how to move from legacy OLTP designs into the star schema.
M. Krippendorf, null Il-Yeol Song
openaire +1 more source
The Star Schema Benchmark and Augmented Fact Table Indexing
2009We provide a benchmark measuring star schema queries retrieving data from a fact table with Where clause column restrictions on dimension tables. Clustering is crucial to performance with modern disk technology, since retrievals with filter factors down to 0.0005 are now performed most efficiently by sequential table search rather than by indexed ...
Patrick O’Neil +3 more
openaire +1 more source