You searched for subject:(Data Warehouse).
Showing records 1 – 30 of
361 total matches.
◁ [1] [2] [3] [4] [5] … [13] ▶
University of Georgia
1.
Avery, Katherine Liddell.
A study of data warehousing end user training methods, their effectiveness, and challenges.
Degree: MA, Management Information Systems, 2003, University of Georgia
URL: http://purl.galileo.usg.edu/uga_etd/avery_katherine_l_200312_ma 
► Effective end user training is important to data warehousing success. Telephone interviews were conducted with data warehousing managers at Owens&Minor, AT&T Wireless, and Blue Cross…
(more)
▼ Effective end user training is important to
data warehousing success. Telephone interviews were conducted with
data warehousing managers at Owens&Minor, AT&T Wireless, and Blue Cross and Blue Shield of North Carolina. The interviews investigated the specific training methods employed with end users; the success of these efforts; and the problems, issues, and challenges associated with current training methods. Based on the interviews it was learned that organizations use a variety of training methods depending on the nature of the user. The three companies believe that their training methods are either "successful" or "largely successful". Two important challenges were identified as a result of the study. Users need a better understanding of the
data stored in the
data warehouse and how to integrate the
warehouse into their work and business processes. Six best practices were identified which synthesize what companies can do to successfully train their end users.
Advisors/Committee Members: Hugh J. Watson.
Subjects/Keywords: Data warehouse
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Avery, K. L. (2003). A study of data warehousing end user training methods, their effectiveness, and challenges. (Masters Thesis). University of Georgia. Retrieved from http://purl.galileo.usg.edu/uga_etd/avery_katherine_l_200312_ma
Chicago Manual of Style (16th Edition):
Avery, Katherine Liddell. “A study of data warehousing end user training methods, their effectiveness, and challenges.” 2003. Masters Thesis, University of Georgia. Accessed March 23, 2019.
http://purl.galileo.usg.edu/uga_etd/avery_katherine_l_200312_ma.
MLA Handbook (7th Edition):
Avery, Katherine Liddell. “A study of data warehousing end user training methods, their effectiveness, and challenges.” 2003. Web. 23 Mar 2019.
Vancouver:
Avery KL. A study of data warehousing end user training methods, their effectiveness, and challenges. [Internet] [Masters thesis]. University of Georgia; 2003. [cited 2019 Mar 23].
Available from: http://purl.galileo.usg.edu/uga_etd/avery_katherine_l_200312_ma.
Council of Science Editors:
Avery KL. A study of data warehousing end user training methods, their effectiveness, and challenges. [Masters Thesis]. University of Georgia; 2003. Available from: http://purl.galileo.usg.edu/uga_etd/avery_katherine_l_200312_ma
University of Georgia
2.
Ariyachandra, Thilini.
Data warehouse architectures: selection factors and success evaluation.
Degree: PhD, Business Administration, 2004, University of Georgia
URL: http://purl.galileo.usg.edu/uga_etd/ariyachandra_thilini_200412_phd
► There is an ongoing debate about which data warehouse architecture should be used to implement a data warehouse. Using existing theory and interviews with a…
(more)
▼ There is an ongoing debate about which
data warehouse architecture should be used to implement a
data warehouse. Using existing theory and interviews with a panel of experts, this research proposed a model that identifies the various selection factors that affect the choice of
data warehouse architecture. In addition, the research also evaluated the success of the various architectures. Specific hypotheses were created to investigate how organizational factors influence architecture selection and how
data warehouse architectures influence architecture success. An empirical investigation involving an online field survey was conducted to further validate and test the proposed research models on architecture selection and success.
Data collected for the main
data warehouse architectures were used in the statistical analyses. The results suggest that various combinations of organizational factors influence the selection of a
data warehouse architecture. Further, one architecture was identified as the least successful
data warehouse solution while another emerged as the most costly to develop when compared to the rest. Through a carefully designed empirical investigation of
data warehouse architectures, thisresearch sheds light on the
data warehouse design selection in organizations by examining the impact organizational factors on
data warehouse architecture selection and by evaluating
data warehouse architecture success.
Advisors/Committee Members: Hugh J. Watson.
Subjects/Keywords: Data warehouse
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Ariyachandra, T. (2004). Data warehouse architectures: selection factors and success evaluation. (Doctoral Dissertation). University of Georgia. Retrieved from http://purl.galileo.usg.edu/uga_etd/ariyachandra_thilini_200412_phd
Chicago Manual of Style (16th Edition):
Ariyachandra, Thilini. “Data warehouse architectures: selection factors and success evaluation.” 2004. Doctoral Dissertation, University of Georgia. Accessed March 23, 2019.
http://purl.galileo.usg.edu/uga_etd/ariyachandra_thilini_200412_phd.
MLA Handbook (7th Edition):
Ariyachandra, Thilini. “Data warehouse architectures: selection factors and success evaluation.” 2004. Web. 23 Mar 2019.
Vancouver:
Ariyachandra T. Data warehouse architectures: selection factors and success evaluation. [Internet] [Doctoral dissertation]. University of Georgia; 2004. [cited 2019 Mar 23].
Available from: http://purl.galileo.usg.edu/uga_etd/ariyachandra_thilini_200412_phd.
Council of Science Editors:
Ariyachandra T. Data warehouse architectures: selection factors and success evaluation. [Doctoral Dissertation]. University of Georgia; 2004. Available from: http://purl.galileo.usg.edu/uga_etd/ariyachandra_thilini_200412_phd
Universidad Privada del Norte
3.
Rázuri Pastor, José Ignacio; Rázuri Pastor, José Ignacio.
Implementación de una solución de inteligencia de negocios para dar soporte a la gestión del proceso comercial de inversiones y servicios Datasys.
Degree: 2014, Universidad Privada del Norte
URL: http://hdl.handle.net/11537/1311
► El presente trabajo tuvo como objetivo general la Implementación de una Solución de Inteligencia de Negocios para dar Soporte a la Gestión del Proceso Comercial…
(more)
▼ El presente trabajo tuvo como objetivo general la Implementación de una Solución de Inteligencia de Negocios para dar Soporte a la Gestión del Proceso Comercial de INVERSIONES Y SERVICIOS DATASYS.
Para iniciar una solución se centra en el problema principal o problemas principales, se crea uno o varios objetivos para dar solución al problema y se define la solución a utilizar.
Como parte de un proyecto se planifica y se define los requerimientos, al tenerlos se realiza un análisis dimensional, diseño dimensional y la arquitectura a realizar, al tener las 5 fases realizadas se procede al poblamiento y la implementación de cubos, para realizar un trabajo amigable del sistema, se desarrolla las aplicaciones que servirán de interface con los usuarios finales, esta aplicación será muy amigable y sencilla que permita operar al usuario final.
Los resultados que se lograron son:
Reducción del tiempo de respuesta en la entrega de resultados de los análisis de la data requerida.
Reducción del costo debido a menores horas hombre de trabajo que se realizaba al generar reportes de la data requerida.
Generación de reportes adicionales que permiten tener un mayor análisis para la toma de decisiones.
The current job had the implementation of a business intelligence solution as its general objective, in order to provide support to the proposal of the commercial process of services and investments DATASYS.
In order to initiate a solution, one must focus on the main problem, or problems, create multiple objectives to give a solution to the problem and define the solution to be used.
As part of a project, one must plan and define the requirements, and once defined, a dimensional analysis and dimensional design must be carried out, along with the architecture to be constructed. Once the 5 faces are completed, one proceeds to the population and implementation of cubes in order to achieve a friendly system, then; applications that serve as an interface with the final users are developed. This application will be very user friend and simple, which will allow them to easily operate it.
The following results were achieved:
Reply-time reduction in the delivery of required data analysis results.
Cost reduction due to lower human working hours utilized in generating the required data reports.
Additional generation of reports that allow for a greater analysis, that can be implemented in decision-making
Subjects/Keywords: Data Warehouse; DataMart; Proceso analítico
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Rázuri Pastor, José Ignacio; Rázuri Pastor, J. I. (2014). Implementación de una solución de inteligencia de negocios para dar soporte a la gestión del proceso comercial de inversiones y servicios Datasys. (Thesis). Universidad Privada del Norte. Retrieved from http://hdl.handle.net/11537/1311
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Rázuri Pastor, José Ignacio; Rázuri Pastor, José Ignacio. “Implementación de una solución de inteligencia de negocios para dar soporte a la gestión del proceso comercial de inversiones y servicios Datasys.” 2014. Thesis, Universidad Privada del Norte. Accessed March 23, 2019.
http://hdl.handle.net/11537/1311.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Rázuri Pastor, José Ignacio; Rázuri Pastor, José Ignacio. “Implementación de una solución de inteligencia de negocios para dar soporte a la gestión del proceso comercial de inversiones y servicios Datasys.” 2014. Web. 23 Mar 2019.
Vancouver:
Rázuri Pastor, José Ignacio; Rázuri Pastor JI. Implementación de una solución de inteligencia de negocios para dar soporte a la gestión del proceso comercial de inversiones y servicios Datasys. [Internet] [Thesis]. Universidad Privada del Norte; 2014. [cited 2019 Mar 23].
Available from: http://hdl.handle.net/11537/1311.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Rázuri Pastor, José Ignacio; Rázuri Pastor JI. Implementación de una solución de inteligencia de negocios para dar soporte a la gestión del proceso comercial de inversiones y servicios Datasys. [Thesis]. Universidad Privada del Norte; 2014. Available from: http://hdl.handle.net/11537/1311
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
NSYSU
4.
Wu, Guan-Sian.
The Study of Linux Container-based Cluster for Data Warehouse Implementation and Its Network Performance Analysis.
Degree: Master, Computer Science and Engineering, 2014, NSYSU
URL: http://etd.lib.nsysu.edu.tw/ETD-db/ETD-search/view_etd?URN=etd-0630114-101432
► Cloud computing is currently one of the popular topics. Nowadays, the pace of data growth is much faster than before. How to accelerate the speed…
(more)
▼ Cloud computing is currently one of the popular topics. Nowadays, the pace of
data growth is much faster than before. How to accelerate the speed of
data processing has become an important issue.
In this paper, we will discuss and research the degree of structure in the
data, the impact of network transmission on computing, and how to construct the most efficient cloud computing cluster under the same hardware costs.
First, there are two type of input
data, one is structure
data, and the other is unstructured
data. We will discuss how the execution time will be impacted under different programming language between this two type
data.
Second, we will discuss the influence of network transmission. Since all the computing nodes are connected to the same network switching equipment. If this network switching equipment reaches its throughput bottleneck, the execution time will be much longer than the same situation which it does not reach its throughput bottleneck. To avoid this situation happening, we propose a network interconnection approach to reduce the burden of network switching equipment and increase the efficiency of network transmission.
Finally, we build Linux-Container-based
data warehouse to discuss whether Linux Container can get whole the real host hardware resources, in addition, under the case of hardware resources allowance, we increase the number of Linux Container virtual machines to examine under this situation whether the hardware should play better computing performance.
Advisors/Committee Members: Chun-Hung Lin (committee member), Hung-Jen Liao (chair), Cheng-Fu Chou (chair), Chun-I Fan (chair), Jain-Shing Liu (chair).
Subjects/Keywords: Linux Container; Hadoop; Data Warehouse
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Wu, G. (2014). The Study of Linux Container-based Cluster for Data Warehouse Implementation and Its Network Performance Analysis. (Thesis). NSYSU. Retrieved from http://etd.lib.nsysu.edu.tw/ETD-db/ETD-search/view_etd?URN=etd-0630114-101432
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Wu, Guan-Sian. “The Study of Linux Container-based Cluster for Data Warehouse Implementation and Its Network Performance Analysis.” 2014. Thesis, NSYSU. Accessed March 23, 2019.
http://etd.lib.nsysu.edu.tw/ETD-db/ETD-search/view_etd?URN=etd-0630114-101432.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Wu, Guan-Sian. “The Study of Linux Container-based Cluster for Data Warehouse Implementation and Its Network Performance Analysis.” 2014. Web. 23 Mar 2019.
Vancouver:
Wu G. The Study of Linux Container-based Cluster for Data Warehouse Implementation and Its Network Performance Analysis. [Internet] [Thesis]. NSYSU; 2014. [cited 2019 Mar 23].
Available from: http://etd.lib.nsysu.edu.tw/ETD-db/ETD-search/view_etd?URN=etd-0630114-101432.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Wu G. The Study of Linux Container-based Cluster for Data Warehouse Implementation and Its Network Performance Analysis. [Thesis]. NSYSU; 2014. Available from: http://etd.lib.nsysu.edu.tw/ETD-db/ETD-search/view_etd?URN=etd-0630114-101432
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
5.
Leão da Fonseca, Rafael.
Um metamodelo e uma ferramenta case para data warehouse geográfico
.
Degree: 2011, Universidade Federal de Pernambuco
URL: http://repositorio.ufpe.br/handle/123456789/2694
► O processo de tomada de decisões pode envolver o uso de ferramentas como DW (Data Warehouse), OLAP (On-Line Analytical Processing) e SIG (Sistemas de Informações…
(more)
▼ O processo de tomada de decisões pode envolver o uso de ferramentas como DW (
Data
Warehouse), OLAP (On-Line Analytical Processing) e SIG (Sistemas de Informações
Geográficas). Diversos trabalhos têm o objetivo de integrar essas tecnologias. No
entanto, a especificação de modelos dimensionais e geográficos para DWG (
Data
Warehouses Geográficos) ainda é um ponto em aberto. Nesse contexto, este trabalho
propõe o metamodelo GeoDWM (Geographical
Data Warehouse Metamodel) e a
ferramenta GeoDWCASE (Geographical DW CASE) que, respectivamente, especifica e
implementa um conjunto de metadados, regras OCL, estereótipos e pictogramas.
GeoDWM é especificado em UML e se baseia nos padrões do CWM e do OGC e na
proposta de GeoDWFrame para especificar como diferentes tipos de dimensões e de
medidas podem ser organizadas para modelar o esquema dimensional e geográfico de
um DWG. Para validar o metamodelo proposto, e tornar o seu uso mais prático, foi
desenvolvida GeoDWCASE que é uma ferramenta aberta, extensível, independente de
plataforma e que foi implementada sobre a plataforma Eclipse e o framework GMF.
GeoDWCASE ajuda o projetista a construir o esquema dimensional e geográfico do
DWG oferecendo uma rica interface de modelagem e mecanismos para a validação de
consistência do esquema que está sendo desenvolvido. Além disso, é possível gerar
automaticamente o esquema lógico do DWG para implementação em um sistema
gerenciador de banco de dados com extensão espacial. Para demonstrar a aplicabilidade
de GeoDWM e GeoDWCASE, foram realizados dois estudos de caso que contemplam a
modelagem de DWG para dados meteorológicos e dados agrícolas
Advisors/Committee Members: do Nascimento Fidalgo, Robson (advisor).
Subjects/Keywords: Data Warehouse Geográfico;
Metamodelagem
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Leão da Fonseca, R. (2011). Um metamodelo e uma ferramenta case para data warehouse geográfico
. (Thesis). Universidade Federal de Pernambuco. Retrieved from http://repositorio.ufpe.br/handle/123456789/2694
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Leão da Fonseca, Rafael. “Um metamodelo e uma ferramenta case para data warehouse geográfico
.” 2011. Thesis, Universidade Federal de Pernambuco. Accessed March 23, 2019.
http://repositorio.ufpe.br/handle/123456789/2694.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Leão da Fonseca, Rafael. “Um metamodelo e uma ferramenta case para data warehouse geográfico
.” 2011. Web. 23 Mar 2019.
Vancouver:
Leão da Fonseca R. Um metamodelo e uma ferramenta case para data warehouse geográfico
. [Internet] [Thesis]. Universidade Federal de Pernambuco; 2011. [cited 2019 Mar 23].
Available from: http://repositorio.ufpe.br/handle/123456789/2694.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Leão da Fonseca R. Um metamodelo e uma ferramenta case para data warehouse geográfico
. [Thesis]. Universidade Federal de Pernambuco; 2011. Available from: http://repositorio.ufpe.br/handle/123456789/2694
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
6.
Hiléia da Silva Melo, Áurea.
Uma Estratégia de Desenvolvimento de Data Warehouse Geográfico com Integração Híbrida Aplicada ao Monitoramento de Queimadas na Amazônia
.
Degree: 2003, Universidade Federal de Pernambuco
URL: http://repositorio.ufpe.br/handle/123456789/5569
► Os sistemas de suporte à decisão atravessaram as fronteiras dos negócios comerciais e atingiram, atualmente , as mais diversas áreas do conhecimento. Seja em instituições…
(more)
▼ Os sistemas de suporte à decisão atravessaram as fronteiras dos negócios comerciais e atingiram, atualmente , as mais diversas áreas do conhecimento. Seja em instituições de ensino, governamentais, privadas com ou sem fins lucrativos, onde houve um processo decisório, haverá a necessidade de sistemas desse tipo. Nesta categoria destaca-se o
Data Warehouse (DW), que permite a geração de dados integrados e históricos possibilitando que seus usuários tomem decisões com base em fatos e não em especulações e, embora já exista há quase vinte anos, ainda não há uma metodologia formal para sua implementação. Tal fato estende-se também aos DW Geográficos (DWG), ou seja, um ambiente de DW com tratamento e armazenamento de dados geo-referenciados. Nesse contexto, o presente trabalho define uma estratégia de desenvolvimento de DWG, contemplando desde a fase de levantamento até a inserção dos dados, seguindo o método de interação híbrida e tendo como base, as metodologias de Ralph Kimball e Jonh A. Zachman para DW tradicionais. Além disso, é feito um estudo de caso do Sistema de Monitoramento de Queimadas da Amazônia Legal de forma a avaliar e validar cada uma das etapas da estratégia implementada
Advisors/Committee Members: Dueire Lins, Rafael (advisor).
Subjects/Keywords: Data Warehouse;
Data Warehouse Geográfico
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Hiléia da Silva Melo, . (2003). Uma Estratégia de Desenvolvimento de Data Warehouse Geográfico com Integração Híbrida Aplicada ao Monitoramento de Queimadas na Amazônia
. (Thesis). Universidade Federal de Pernambuco. Retrieved from http://repositorio.ufpe.br/handle/123456789/5569
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Hiléia da Silva Melo, Áurea. “Uma Estratégia de Desenvolvimento de Data Warehouse Geográfico com Integração Híbrida Aplicada ao Monitoramento de Queimadas na Amazônia
.” 2003. Thesis, Universidade Federal de Pernambuco. Accessed March 23, 2019.
http://repositorio.ufpe.br/handle/123456789/5569.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Hiléia da Silva Melo, Áurea. “Uma Estratégia de Desenvolvimento de Data Warehouse Geográfico com Integração Híbrida Aplicada ao Monitoramento de Queimadas na Amazônia
.” 2003. Web. 23 Mar 2019.
Vancouver:
Hiléia da Silva Melo . Uma Estratégia de Desenvolvimento de Data Warehouse Geográfico com Integração Híbrida Aplicada ao Monitoramento de Queimadas na Amazônia
. [Internet] [Thesis]. Universidade Federal de Pernambuco; 2003. [cited 2019 Mar 23].
Available from: http://repositorio.ufpe.br/handle/123456789/5569.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Hiléia da Silva Melo . Uma Estratégia de Desenvolvimento de Data Warehouse Geográfico com Integração Híbrida Aplicada ao Monitoramento de Queimadas na Amazônia
. [Thesis]. Universidade Federal de Pernambuco; 2003. Available from: http://repositorio.ufpe.br/handle/123456789/5569
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
California State University – Sacramento
7.
Deshpande, Purva.
A data integration and olap application: university exploration tool for international students.
Degree: MS, Computer Science, 2016, California State University – Sacramento
URL: http://hdl.handle.net/10211.3/181760
► Education has become very important in today???s era. Every year number of students pursuing Higher Education is increasing and United State of America gives these…
(more)
▼ Education has become very important in today???s era. Every year number of students pursuing Higher Education is increasing and United State of America gives these students a good opportunity to pursue their dreams. Students are attracted to America as it provides best education in the world, but there is little they know about the universities, ranking, living condition in America. To research about universities students perform number of ways as researching on Google, posting questions on forums, getting help from consultancy, asking friends, seniors, family. These methods are slow and unreliable. A friend can give biased opinion about a university if he has been there or simply because he does not know other universities well. A consultancy can also give biased opinion regarding a university if they have a tie up with that university. Other sources like Google take long time to research and you only get partial information. There are websites which provide similar functionalities such as www.internationalstudent.com and US news, but they don???t have detailed information as orientation of university, acceptance rate and surrounding conditions of university. This motivated me to provide these international students a way to research about university???s academic & surrounding condition and make the decision accordingly.
This project is implemented using different techniques of
data mining and
data warehouse. It is based on datasets such as university, crime, transit, rent per room and weather which are collected from government official websites. Some research was needed in order to complete the dataset and start the project. The method used for
data mining are
data preprocessing, cleaning
data and for
data warehouse, the methods are
data integration, OLAP operation. Using WEKA tool, a machine learning tool which is used for
data mining and knowledge discovery, the
data was cleaned, unused fields were removed and dealt with missing attributes. Other than this, the missing values were also manually researched and entered into datasets. To integrate all the datasets, snowflake database schema was used creating fact table and dimension tables. This was done using cube query of OLAP operation. This project is implemented using popular tier of LAMP (Linux Apache MySQL and PHP),
data integration and OLAP technology which made application more dynamic and interactive.
In this project, user will be able to search universities on the basis of state, their GRE or TOEFL score, orientation of university such as teaching or research and degree level. After applying filters, result page will display all the universities satisfying search criteria where they can add their favorite universities to wish list by logging in to application. The compare page shows all universities they have added to wish list. On compare page, user can compare universities by academic standing such as tuition fee, orientation, highest degree level and surrounding conditions such as yearly weather report, crime rate, transit facilities and rent per…
Advisors/Committee Members: Lu, Meiliu.
Subjects/Keywords: Data mining; Data warehouse; OLAP application
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Deshpande, P. (2016). A data integration and olap application: university exploration tool for international students. (Masters Thesis). California State University – Sacramento. Retrieved from http://hdl.handle.net/10211.3/181760
Chicago Manual of Style (16th Edition):
Deshpande, Purva. “A data integration and olap application: university exploration tool for international students.” 2016. Masters Thesis, California State University – Sacramento. Accessed March 23, 2019.
http://hdl.handle.net/10211.3/181760.
MLA Handbook (7th Edition):
Deshpande, Purva. “A data integration and olap application: university exploration tool for international students.” 2016. Web. 23 Mar 2019.
Vancouver:
Deshpande P. A data integration and olap application: university exploration tool for international students. [Internet] [Masters thesis]. California State University – Sacramento; 2016. [cited 2019 Mar 23].
Available from: http://hdl.handle.net/10211.3/181760.
Council of Science Editors:
Deshpande P. A data integration and olap application: university exploration tool for international students. [Masters Thesis]. California State University – Sacramento; 2016. Available from: http://hdl.handle.net/10211.3/181760
Universidade Nova
8.
Moura, André Hengeller de.
Criação de um data warehouse empresarial : na direção de planeamento e gestão da TAP Portugal.
Degree: 2018, Universidade Nova
URL: https://www.rcaap.pt/detail.jsp?id=oai:run.unl.pt:10362/32048
► Nos dias de hoje as tecnologias de informação têm um papel fundamental no sucesso das empresas. Um dos pontos chaves para alcançar este sucesso é…
(more)
▼ Nos dias de hoje as tecnologias de informação têm um papel fundamental no sucesso das
empresas. Um dos pontos chaves para alcançar este sucesso é tentar criar uma vantagem
competitiva ao analisar os dados que as próprias organizações criam.
A complexidade da informação apresentada às pessoas que geram estas identidades torna a
gestão de informação um assunto chave a ter em consideração. É portanto necessário
construir mecanismos ou ferramentas que agregam, processam e partilham a informação
obtida permitindo uma tomada de decisão mais rápida e mais eficiente.
O principal objetivo deste estágio foi criar um
Data Warehouse, para um departamento
específico da empresa, com recurso a diversas fontes de informação. Um dos pontos
importantes é a necessidade que as empresas têm em ajustar os próprios sistemas às bases
de dados. Este tipo de aplicação permite ter uma diferente visão dos dados e oferece,
também, a possibilidade da empresa ter uma análise mais forte dos dados de modo a
suportar decisões.
Advisors/Committee Members: Santos, Vitor Manuel Pereira Duarte dos.
Subjects/Keywords: Data warehouse; Data; Databases; Business intelligence
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Moura, A. H. d. (2018). Criação de um data warehouse empresarial : na direção de planeamento e gestão da TAP Portugal. (Thesis). Universidade Nova. Retrieved from https://www.rcaap.pt/detail.jsp?id=oai:run.unl.pt:10362/32048
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Moura, André Hengeller de. “Criação de um data warehouse empresarial : na direção de planeamento e gestão da TAP Portugal.” 2018. Thesis, Universidade Nova. Accessed March 23, 2019.
https://www.rcaap.pt/detail.jsp?id=oai:run.unl.pt:10362/32048.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Moura, André Hengeller de. “Criação de um data warehouse empresarial : na direção de planeamento e gestão da TAP Portugal.” 2018. Web. 23 Mar 2019.
Vancouver:
Moura AHd. Criação de um data warehouse empresarial : na direção de planeamento e gestão da TAP Portugal. [Internet] [Thesis]. Universidade Nova; 2018. [cited 2019 Mar 23].
Available from: https://www.rcaap.pt/detail.jsp?id=oai:run.unl.pt:10362/32048.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Moura AHd. Criação de um data warehouse empresarial : na direção de planeamento e gestão da TAP Portugal. [Thesis]. Universidade Nova; 2018. Available from: https://www.rcaap.pt/detail.jsp?id=oai:run.unl.pt:10362/32048
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Univerzitet u Beogradu
9.
Krneta, Dragoljub.
Automatizacija fizičkog projektovanja skladišta podataka
proširenog Data Vault pristupa.
Degree: Fakultet organizacionih nauka, 2016, Univerzitet u Beogradu
URL: https://fedorabg.bg.ac.rs/fedora/get/o:11777/bdef:Content/get
► Informacioni sistemi i tehnologije - Information systems and technology.
Skladište podataka predstavlja podlogu za implementaciju sistema poslovne inteligencije, integraciju podataka i podršku poslovnom odlučivanju. Za…
(more)
▼ Informacioni sistemi i tehnologije - Information
systems and technology.
Skladište podataka predstavlja podlogu za
implementaciju sistema poslovne inteligencije, integraciju podataka
i podršku poslovnom odlučivanju. Za skladišta podataka uglavnom se
izgrađuje dimenzioni model kojim se dobija bolja mogućnost
vizualizacije podataka. Arhitektura skladišta podataka
podrazumijeva definicije osnovnih elemenata skladišta podataka i
opisuje kako su ti elementi izgrađeni i povezani. Kod arhitekture
skladišta podataka danas postoje dva dominantna pristupa. Jedan
pristup, poznat je pod nazivom CIF (Corporate Information Factory)
arhitektura, zastupa Bill Inmon koji smatra da skladište podataka
treba da bude normalizovano i da sadrži atomske podatke u trećoj
normalnoj formi. Drugi pristup, poznat poda nazivom BUS
arhitektura, zastupa Ralph Kimbal koji tvrdi da i samo skladište
treba da ima višedimenzionalnu strukturu. Data Vault koncept
skladišta podataka koji je osmislio Daniel Linstedt, predstavlja
detaljno orijentisani, istorijski praćen i jedinstveno povezani
skup normalizovanih tabela koji podržavaju jedan ili više
funkcionalnih područja poslovanja. To je hibridni pristup koji
obuhvata najbolje osobine između 3. normalne forme (3NF) i zvijezda
šeme. Data Vault koncept naglašava potrebu da se ostavi trag odakle
i kad su podaci došli u bazu podataka, te omogućuje lake promjene
strukture skladišta podataka u skladu sa promjenama u poslovnom
okruženju. Skladišta podataka se izrađuju različitim metodološkim
pristupima. Međutim, problem je što proces dizajniranja skladišta
podataka i izrade dimenzionog modela nije automatizovan. U
disertaciji je sagledan problem dizajniranja skladišta podataka na
osnovu šire literature, te istražena mogućnost automatizacije
fizičkog projektovanja skladišta podataka baziranog na Data Vault
konceptu uz minimalnu interakciju sa korisnikom...
Advisors/Committee Members: Marjanović, Zoran, 1960-.
Subjects/Keywords: Data warehouse; meta-model; physical model; data
warehouse architecture; dimensional model; Data Vault; design
automation
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Krneta, D. (2016). Automatizacija fizičkog projektovanja skladišta podataka
proširenog Data Vault pristupa. (Thesis). Univerzitet u Beogradu. Retrieved from https://fedorabg.bg.ac.rs/fedora/get/o:11777/bdef:Content/get
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Krneta, Dragoljub. “Automatizacija fizičkog projektovanja skladišta podataka
proširenog Data Vault pristupa.” 2016. Thesis, Univerzitet u Beogradu. Accessed March 23, 2019.
https://fedorabg.bg.ac.rs/fedora/get/o:11777/bdef:Content/get.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Krneta, Dragoljub. “Automatizacija fizičkog projektovanja skladišta podataka
proširenog Data Vault pristupa.” 2016. Web. 23 Mar 2019.
Vancouver:
Krneta D. Automatizacija fizičkog projektovanja skladišta podataka
proširenog Data Vault pristupa. [Internet] [Thesis]. Univerzitet u Beogradu; 2016. [cited 2019 Mar 23].
Available from: https://fedorabg.bg.ac.rs/fedora/get/o:11777/bdef:Content/get.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Krneta D. Automatizacija fizičkog projektovanja skladišta podataka
proširenog Data Vault pristupa. [Thesis]. Univerzitet u Beogradu; 2016. Available from: https://fedorabg.bg.ac.rs/fedora/get/o:11777/bdef:Content/get
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
10.
Renata Miwa Tsuruda.
STB-index : um índice baseado em bitmap para data warehouse espaço-temporal.
Degree: 2012, Universidade Federal de São Carlos
URL: http://www.bdtd.ufscar.br/htdocs/tedeSimplificado//tde_busca/arquivo.php?codArquivo=6245
► A crescente preocupação com o suporte ao processo de tomada de decisão estratégica fez com que as empresas buscassem tecnologias que apoiassem as suas decisões.…
(more)
▼ A crescente preocupação com o suporte ao processo de tomada de decisão estratégica fez com que as empresas buscassem tecnologias que apoiassem as suas decisões. A tecnologia mais utilizada atualmente é a de Data Warehouse (DW), que permite armazenar dados de forma que seja possível produzir informação útil e confiável para auxiliar na tomada de decisão estratégica. Aliando-se os conceitos de Data Warehouse Espacial (DWE), que permite o armazenamento e o gerenciamento de geometrias, e de Data Warehouse Temporal (DWT), que possibilita representar as mudanças nos dados que ocorrem no mundo real, surgiu o tema de pesquisa conhecido por Data Warehouse Espaço-Temporal (DWET), que é próprio para o tratamento de geometrias que se alteram ao longo do tempo. Essas tecnologias, aliadas ao constante crescimento no volume de dados armazenados, evidenciam a necessidade de estruturas de indexação que melhorem o desempenho do processamento de consultas analíticas com predicados espaciais e com variação das geometrias no tempo. Nesse sentido, este trabalho se concentrou na proposta de um índice para DWET denominado Spatio- Temporal Bitmap Index, ou STB-index. O índice proposto foi projetado para o processamento de consultas do tipo drill-down e roll-up considerando a existência de hierarquias espaciais predefinidas, sendo que os atributos espaciais podem variar sua posição e sua forma ao longo do tempo. A validação do STB-index ocorreu por meio da realização de testes experimentais utilizando um DWET criado a partir de dados sintéticos. Os testes avaliaram o tempo e o número de acessos a disco para a construção do índice, a quantidade de espaço para armazenamento do índice e o tempo e número de acessos a disco para o processamento de consultas analíticas. Os resultados obtidos foram comparados com o processamento de consultas utilizando os recursos disponíveis dos sistemas gerenciadores de banco de dados, sendo que o STB-index apresentou um ganho de desempenho entre 98,12% e 99,22% no tempo de resposta das consultas se comparado ao uso de visões materializadas.
The growing concern with the support of the decision-making process has made companies to search technologies that support their decisions. The technology most widely used presently is the Data Warehouse (DW), which allows storing data so it is possible to produce useful and reliable information to assist in strategic decisions. Combining the concepts of Spatial Data Warehouse (SDW), that allows geometry storage and managing, and Temporal Data Warehouse (TDW), which allows storing data changes that occur in the real-world, a research topic known as Spatio-Temporal Data Warehouse (STDW) has emerged. STDW are suitable for the treatment of geometries that change over time. These technologies, combined with the steady growth volume of data, show the necessity of index structures to improve the performance of analytical query processing with spatial predicates and also with geometries that may vary over time. In this sense, this work focused on proposing an index for STDW called…
Advisors/Committee Members: Ricardo Rodrigues Ciferri.
Subjects/Keywords: Banco de dados; Data warehouse; Índice bitmap; Indexação; CIENCIA DA COMPUTACAO; Data Warehouse; Spatio-Temporal Data Warehouse; Indexing; Bitmap Index
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Tsuruda, R. M. (2012). STB-index : um índice baseado em bitmap para data warehouse espaço-temporal. (Thesis). Universidade Federal de São Carlos. Retrieved from http://www.bdtd.ufscar.br/htdocs/tedeSimplificado//tde_busca/arquivo.php?codArquivo=6245
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Tsuruda, Renata Miwa. “STB-index : um índice baseado em bitmap para data warehouse espaço-temporal.” 2012. Thesis, Universidade Federal de São Carlos. Accessed March 23, 2019.
http://www.bdtd.ufscar.br/htdocs/tedeSimplificado//tde_busca/arquivo.php?codArquivo=6245.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Tsuruda, Renata Miwa. “STB-index : um índice baseado em bitmap para data warehouse espaço-temporal.” 2012. Web. 23 Mar 2019.
Vancouver:
Tsuruda RM. STB-index : um índice baseado em bitmap para data warehouse espaço-temporal. [Internet] [Thesis]. Universidade Federal de São Carlos; 2012. [cited 2019 Mar 23].
Available from: http://www.bdtd.ufscar.br/htdocs/tedeSimplificado//tde_busca/arquivo.php?codArquivo=6245.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Tsuruda RM. STB-index : um índice baseado em bitmap para data warehouse espaço-temporal. [Thesis]. Universidade Federal de São Carlos; 2012. Available from: http://www.bdtd.ufscar.br/htdocs/tedeSimplificado//tde_busca/arquivo.php?codArquivo=6245
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
11.
Goar, Vishal Kumar.
Performance tuning stratgies for data warehouse: a
division of Rajasthan state; -.
Degree: Computer Engineering, 2013, Suresh Gyan Vihar University
URL: http://shodhganga.inflibnet.ac.in/handle/10603/10205
► There has been an extensive demand in the use of databases for decision support in these days. This was mainly due to the fact that…
(more)
▼ There has been an extensive demand in the use of
databases for decision support in these days. This was mainly due
to the fact that information, one of the most precious assets of an
organization, can assist in decision making and this way
considerably improves the value of an organization. This phenomenon
is a result of the increased availability of new technologies to
support capable storage and retrieval of large volumes of data,
namely data warehousing. Thus, we could define data warehouse as a
repository of data that has been extracted and integrated from
heterogeneous and autonomous distributed sources [Kimball96]. Data
warehouses usually contain a huge amount of data that must be
analyzed and, provide that analysis, helping in the organizational
decision making process. The success of this kind of support
depends greatly on database systems and correlated analysis tools.
Data warehouses differ significantly from the traditional database
applications. Data warehouses provide a different context in which
huge amounts of data must be processed efficiently and queries are
often complex, but still require interactive response times. In
data warehouse environments the data is used for decision support
and large sets of data are read and analyzed. One of the most
important requirements of a data warehouse server is the query
performance. The principal aspect from the user perspective is how
quickly the server processes a given query: the data warehouse must
be fast . The main focus of our research is finding adequate
solutions to improve query response time of typical data ware house
queries and improve scalability using an environment that takes
advantage of characteristics specific to the data ware house
context. Our propose model provides very good performance and
scalability even on huge data warehouses.
Bibliography p.243-271
Advisors/Committee Members: Sarangdevot, S S, Tanwar, Manish.
Subjects/Keywords: Computer Science; Performance tuning stratgies; data warehouse
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Goar, V. K. (2013). Performance tuning stratgies for data warehouse: a
division of Rajasthan state; -. (Thesis). Suresh Gyan Vihar University. Retrieved from http://shodhganga.inflibnet.ac.in/handle/10603/10205
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Goar, Vishal Kumar. “Performance tuning stratgies for data warehouse: a
division of Rajasthan state; -.” 2013. Thesis, Suresh Gyan Vihar University. Accessed March 23, 2019.
http://shodhganga.inflibnet.ac.in/handle/10603/10205.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Goar, Vishal Kumar. “Performance tuning stratgies for data warehouse: a
division of Rajasthan state; -.” 2013. Web. 23 Mar 2019.
Vancouver:
Goar VK. Performance tuning stratgies for data warehouse: a
division of Rajasthan state; -. [Internet] [Thesis]. Suresh Gyan Vihar University; 2013. [cited 2019 Mar 23].
Available from: http://shodhganga.inflibnet.ac.in/handle/10603/10205.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Goar VK. Performance tuning stratgies for data warehouse: a
division of Rajasthan state; -. [Thesis]. Suresh Gyan Vihar University; 2013. Available from: http://shodhganga.inflibnet.ac.in/handle/10603/10205
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
12.
Mateus, Rodrigo Costa.
CSB-Index: um índice espacial para data warehouses geográficos na nuvem
.
Degree: 2013, Universidade Federal de Pernambuco
URL: http://repositorio.ufpe.br/handle/123456789/12368
► Plataformas de computação em nuvem proveem escalabilidade, elasticidade e tolerância a falhas aos sistemas computacionais. Além disso, elas foram projetadas para lidar com grande volume…
(more)
▼ Plataformas de computação em nuvem proveem escalabilidade, elasticidade e tolerância
a falhas aos sistemas computacionais. Além disso, elas foram projetadas para lidar com grande
volume de dados utilizando recursos computacionais quase ilimitados.
Data Warehouse
Geográfico (DWG) se tornou uma das principais tecnologias de suporte à decisão, pois promove
a integração do
Data Warehouse convencionais, das ferramentas On-Line Analytical Processing
e dos Sistemas de Informações Geográficas. Por esse motivo, um DWG viabiliza a análise no
contexto espacial aliada à execução de consultas multidimensionais envolvendo grande volume
de dados. A combinação da computação em nuvem e dos DWG traz consigo o desafio de prover
análises de dados espaciais em um ambiente distribuído. Além disso, há a preocupação com o
desempenho no processamento de consultas, que utilizam janelas de consultas espaciais ad-hoc e
realizam várias junções entre as tabelas de dimensões e de fatos. Embora existam eficientes
mecanismos para aumentar o desempenho do processamento de consultas em DWG, como as
estruturas de indexação, elas se tornam impróprias aos DWG mantidos em nuvem porque estes
mecanismos não lidam com a recuperação de dados em ambientes distribuídos. Nesta dissertação,
propõe-se um novo índice para DWG mantidos em nuvem chamado CSB-Index (Cloud Spatial-
Bitmap Index). O CSB-Index se baseia no SB-Index e permite a recuperação de dados mantidos
em um ambiente distribuído, pois mantém em sua estrutura referências aos bancos de dados que
compõe o DWG. Além disso, ele introduz o uso do Índice Bitmap de Junção aos DWG
armazenados em nuvem, evitando o processamento das custosas operações de junção estrela. A
viabilidade do CSB-Index foi comprovada por meio de testes experimentais de desempenho e
escalabilidade. Comparações entre diferentes métodos de acesso indicaram que o CSB-Index
diminuiu significativamente o tempo de resposta do processamento de consultas roll-up e drilldown
relacionadas aos predicados espaciais “intersecta”, “está contido” e “contém”,
possibilitando redução no tempo de processamento destas consultas de 58,2% até 99,65%.
Também foi verificado que a escalabilidade dos dados e do número de máquinas que armazenam
o DWG não afetam negativamente o desempenho do CSB-Index. Por fim, este trabalho também
investigou o impacto do uso das federações no processamento das consultas SOLAP e comprovou
que está técnica possibilita maior desempenho ao processamento destas consultas.
Advisors/Committee Members: Times, Valéria Cesário (advisor).
Subjects/Keywords: Data warehouse geográfico;
Indexação;
Computação em nuvem
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Mateus, R. C. (2013). CSB-Index: um índice espacial para data warehouses geográficos na nuvem
. (Thesis). Universidade Federal de Pernambuco. Retrieved from http://repositorio.ufpe.br/handle/123456789/12368
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Mateus, Rodrigo Costa. “CSB-Index: um índice espacial para data warehouses geográficos na nuvem
.” 2013. Thesis, Universidade Federal de Pernambuco. Accessed March 23, 2019.
http://repositorio.ufpe.br/handle/123456789/12368.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Mateus, Rodrigo Costa. “CSB-Index: um índice espacial para data warehouses geográficos na nuvem
.” 2013. Web. 23 Mar 2019.
Vancouver:
Mateus RC. CSB-Index: um índice espacial para data warehouses geográficos na nuvem
. [Internet] [Thesis]. Universidade Federal de Pernambuco; 2013. [cited 2019 Mar 23].
Available from: http://repositorio.ufpe.br/handle/123456789/12368.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Mateus RC. CSB-Index: um índice espacial para data warehouses geográficos na nuvem
. [Thesis]. Universidade Federal de Pernambuco; 2013. Available from: http://repositorio.ufpe.br/handle/123456789/12368
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
13.
da Silva, Joel.
GEOMDQL: Uma Linguagem de Consulta geogr´afica e Multidimensional
.
Degree: 2008, Universidade Federal de Pernambuco
URL: http://repositorio.ufpe.br/handle/123456789/1315
► Existem várias propostas na literatura visando a integração das funcionalidades e características pertinentes aos processamentos de dados analíticos (OLAP) e geográficos (SIG). O principal objetivo…
(more)
▼ Existem várias propostas na literatura visando a integração das funcionalidades e características pertinentes
aos processamentos de dados analíticos (OLAP) e geográficos (SIG). O principal objetivo é
prover um ambiente único, com capacidades de processamento geográfico e multidimensional, para
dar suporte ao processo de tomada de decisões estratégicas. Este tipo de ambiente vem sendo referido
atualmente como SOLAP.
Entretanto, pelo fato destas duas tecnologias terem sido concebidas com propósitos distintos, a integração
entre estes dois ambientes não é uma tarefa fácil, e mesmo com tantas pesquisas sendo desenvolvidas,
temos alguns pontos em aberto que merecem ser explorados. A definição de modelos de
dados para
Data Warehouse Geográficos é um dos items desta integração. Outro ponto inserido neste
contexto é a definição de funções de agregação para medidas geográficas. Estas funções são utilizadas
no momento da especificação dos cubos de dados multidimensionais e geográficos. Conseqüentemente,
também necessitamos de novos modelos de cubos de dados que possibilitem a associação de geometrias
aos fatos e aos membros dos níveis.
Uma das partes mais importantes desse processo de integração é a consulta aos dados. Porém, a
maioria das abordagens que almejam esta integração de processamento, não dispõe de uma linguagem de
consulta que possibilite a utilização simultânea, tanto de operadores multidimensionais como espaciais.
É neste contexto que se insere esta tese, na qual apresentamos: i) um modelo formal para definição de
DWG; ii) um conjunto de funções de agregação para medidas geográficas; iii) um modelo formal para
cubos de dados chamado GeoMDCube; e iv) uma linguagem de consulta geográfica-multidimensional
denominada GeoMDQL (Geographic Multidimensional Query Language). GeoMDQL estende e integra,
em uma única sintaxe, os principais operadores multidimensionais e espaciais presentes na maioria das
ferramentas e em ambientes disponíveis atualmente para processamento multidimensional e geográfico.
GeoMDQL é baseada em padrões bem estabelecidos como ( MDX Multidimensional Expressions) e
OGC Simple Features for SQL.
As idéias propostas foram aplicadas na prática, por meio da implementação de uma arquitetura
SOLAP chamada Golapware e o desenvolvimento de estudo de caso baseado em dados de aplicações
reais. Dessa forma, foi possível demonstrar a utilização dos modelos, das funções e da linguagem de
consulta e operadores SOLAP discutidos nesta tese
Advisors/Committee Members: Cesário Times, Valéria (advisor).
Subjects/Keywords: GeoMDQL;
Data Warehouse Geográfico;
GeoMDCube;
SOLAP
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
da Silva, J. (2008). GEOMDQL: Uma Linguagem de Consulta geogr´afica e Multidimensional
. (Thesis). Universidade Federal de Pernambuco. Retrieved from http://repositorio.ufpe.br/handle/123456789/1315
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
da Silva, Joel. “GEOMDQL: Uma Linguagem de Consulta geogr´afica e Multidimensional
.” 2008. Thesis, Universidade Federal de Pernambuco. Accessed March 23, 2019.
http://repositorio.ufpe.br/handle/123456789/1315.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
da Silva, Joel. “GEOMDQL: Uma Linguagem de Consulta geogr´afica e Multidimensional
.” 2008. Web. 23 Mar 2019.
Vancouver:
da Silva J. GEOMDQL: Uma Linguagem de Consulta geogr´afica e Multidimensional
. [Internet] [Thesis]. Universidade Federal de Pernambuco; 2008. [cited 2019 Mar 23].
Available from: http://repositorio.ufpe.br/handle/123456789/1315.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
da Silva J. GEOMDQL: Uma Linguagem de Consulta geogr´afica e Multidimensional
. [Thesis]. Universidade Federal de Pernambuco; 2008. Available from: http://repositorio.ufpe.br/handle/123456789/1315
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
14.
Rilston Silva Paim, Fabio.
Uma metodologia para definição de requisitos em sistemas Data Warehouse
.
Degree: 2003, Universidade Federal de Pernambuco
URL: http://repositorio.ufpe.br/handle/123456789/2527
► No início da década de 90, a tecnologia de Data Warehouse floresceu como uma solução à necessidade crescente de informações integradas pela gerência estratégica das…
(more)
▼ No início da década de 90, a tecnologia de
Data Warehouse floresceu como uma solução à
necessidade crescente de informações integradas pela gerência estratégica das
organizações, como parte de processos decisórios de alto nível. A partir da análise histórica
de dados operacionais, sistemas
data warehouse possibilitam a descoberta de tendências de
negócio que se traduzem em aumento da vantagem competitiva com a definição de
processos operacionais mais precisos.
Devido à complexidade e o volume de dados processados, o desenvolvimento de aplicações
data warehouse tem sido fortemente influenciado, ao longo dos anos, pela organização
física do banco de dados adotado e por outros aspectos implementacionais que têm como
principal objetivo assegurar performance e integridade à aplicação. Contudo, apesar dos
inegáveis benefícios, essa abordagem tem como conseqüência direta uma especificação de
requisitos pobre, que não reflete de forma completa e adequada as necessidades do usuário.
Em decorrência disso, soluções de suporte à decisão apresentam freqüentemente efeitos
colaterais tais como altos índices de erro, escalabilidade limitada, baixa qualidade da
informação agregada e um distanciamento acentuado entre desenvolvedores e usuários,
contribuindo para o fracasso de inúmeros projetos.
Esse cenário sugere a utilização de técnicas de Engenharia de Requisitos em suporte a uma
especificação de requisitos de alta qualidade em sistemas
data warehouse. Nesse sentido,
uma abordagem metodológica é requerida para garantir (i) a correta identificação dos
requisitos do usuário, (ii) um projeto de sistema afinado e (iii) a definição de um modelo
dimensional que preencha todas as necessidades de análise estratégica dos usuários finais.
Essa dissertação propõe uma metodologia para definição de requisitos em sistemas
data
warehouse. A abordagem adotada está centrada em um modelo de fases que direciona o
processo de especificação dos requisitos, enquanto propõe um conjunto de artefatos para a
coleta dos aspectos funcionais, não-funcionais e multidimensionais que integram a
solicitação de serviço. Aliada a técnicas eficientes para gerenciamento de requisitos, a
metodologia serve como um instrumento para rastrear as mudanças sofridas pelos
requisitos ao longo do projeto, e assim possibilitar que ambas as visões dimensional e de
requisitos estejam sempre ajustadas às necessidades do usuário.
Os princípios que servem como pano de fundo à metodologia foram concebidos ao longo
do desenvolvimento de um projeto
data warehouse de larga escala conduzido pelo
SERPRO, uma empresa do Ministério da Fazenda, em sua maior unidade de negócio, a
SUNAT Superintendência de Negócios e Administração Tributária. Um estudo de caso
ao final da dissertação apresenta as contribuições do uso da metodologia para o referido
projeto
Advisors/Committee Members: Freire Brelaz de Castro, Jaelson (advisor).
Subjects/Keywords: Data Warehouse;
Metodologia
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Rilston Silva Paim, F. (2003). Uma metodologia para definição de requisitos em sistemas Data Warehouse
. (Thesis). Universidade Federal de Pernambuco. Retrieved from http://repositorio.ufpe.br/handle/123456789/2527
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Rilston Silva Paim, Fabio. “Uma metodologia para definição de requisitos em sistemas Data Warehouse
.” 2003. Thesis, Universidade Federal de Pernambuco. Accessed March 23, 2019.
http://repositorio.ufpe.br/handle/123456789/2527.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Rilston Silva Paim, Fabio. “Uma metodologia para definição de requisitos em sistemas Data Warehouse
.” 2003. Web. 23 Mar 2019.
Vancouver:
Rilston Silva Paim F. Uma metodologia para definição de requisitos em sistemas Data Warehouse
. [Internet] [Thesis]. Universidade Federal de Pernambuco; 2003. [cited 2019 Mar 23].
Available from: http://repositorio.ufpe.br/handle/123456789/2527.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Rilston Silva Paim F. Uma metodologia para definição de requisitos em sistemas Data Warehouse
. [Thesis]. Universidade Federal de Pernambuco; 2003. Available from: http://repositorio.ufpe.br/handle/123456789/2527
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Universidade Nova
15.
Correia, André Ramos Jorge.
Dados, informação, conhecimento, o business intelligence e as suas motivações.
Degree: 2011, Universidade Nova
URL: http://www.rcaap.pt/detail.jsp?id=oai:run.unl.pt:10362/6286
► Dissertação para obtenção do Grau de Mestre em Engenharia Informática
O objectivo deste relatório é dar a conhecer, um possível percurso de carreira para um…
(more)
▼ Dissertação para obtenção do Grau de Mestre em
Engenharia Informática
O objectivo deste relatório é dar a conhecer, um possível percurso de carreira para um aluno que na entrada no mundo profissional, se interessou por sistemas de suporte à decisão. Descrevi a minha experiência profissional desde a entrada no curso de Engenharia Informática e as opções que fui tomando durante e depois do curso, que demonstram o interesse e tendência para esta área dentro das TI.
Assim, o facto de após terminar o curso, ter trabalhado em diversas áreas nas três empresas que integrei, desde o desenvolvimento aplicacional em ERP e CRM, na definição de requisitos de arquitecturas de HW e SW, na qualidade e integração de dados em múltiplos sistemas e em modelos analíticos, sempre em metodologias e ambientes diversos. Esta multiplicidade de cenários faz-me pensar que me encontro actualmente na área certa, o Business Intelligence.
O curso na FCT-UNL transmitiu-me entre outras, uma capacidade de adaptação ao nível das mais diversas tecnologias e metodologias, assim como uma grande tolerância à frustração, devido aos inúmeros obstáculos que foram sendo colocados durante o curso. Tudo isto tem permitido ao longo da minha carreira ultrapassar as sempre difíceis tarefas a nível técnico, funcional e de gestão que me foram surgindo.
Dados, Informação, Conhecimento e Inteligência é um fluxo natural e uma motivação para criar soluções de Business Intelligence. O fluxo descrito deve ser seguido em qualquer SI/TIC. Não é profícuo para nenhuma organização ter dados provenientes de inúmeras aplicações, se estes não gerarem informação que se traduza em conhecimento. O fluxo deve ser cumprido, para que o produto final de um projecto de Business Intelligence seja um acréscimo de conhecimento e valor para a organização ao qual pertence.
Espero transmitir claramente como funciona o mundo dos projectos de Business Intelligence, as suas componentes, dificuldades e particularidades.
Advisors/Committee Members: Lopes, Paulo.
Subjects/Keywords: Inteligência; Data Warehouse; Integração; Relatório; Profissional; Painel
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Correia, A. R. J. (2011). Dados, informação, conhecimento, o business intelligence e as suas motivações. (Thesis). Universidade Nova. Retrieved from http://www.rcaap.pt/detail.jsp?id=oai:run.unl.pt:10362/6286
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Correia, André Ramos Jorge. “Dados, informação, conhecimento, o business intelligence e as suas motivações.” 2011. Thesis, Universidade Nova. Accessed March 23, 2019.
http://www.rcaap.pt/detail.jsp?id=oai:run.unl.pt:10362/6286.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Correia, André Ramos Jorge. “Dados, informação, conhecimento, o business intelligence e as suas motivações.” 2011. Web. 23 Mar 2019.
Vancouver:
Correia ARJ. Dados, informação, conhecimento, o business intelligence e as suas motivações. [Internet] [Thesis]. Universidade Nova; 2011. [cited 2019 Mar 23].
Available from: http://www.rcaap.pt/detail.jsp?id=oai:run.unl.pt:10362/6286.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Correia ARJ. Dados, informação, conhecimento, o business intelligence e as suas motivações. [Thesis]. Universidade Nova; 2011. Available from: http://www.rcaap.pt/detail.jsp?id=oai:run.unl.pt:10362/6286
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
16.
Silva, António.
Avaliação da utilização dos Sistemas de Suporte à Decisão nas Pequenas e Médias Empresas do concelho de Paredes.
Degree: 2017, RCAAP
URL: https://www.rcaap.pt/detail.jsp?id=oai:repositorio.ismai.pt:10400.24/774
► As empresas vivem num ambiente competitivo e têm necessidade de ser eficientes e eficazes nos seus objectivos, sendo o tratamento da informação vital para melhorar…
(more)
▼ As empresas vivem num ambiente competitivo e têm necessidade de ser eficientes e eficazes nos seus objectivos, sendo o tratamento da informação vital para melhorar a gestão empresarial. As tomadas de decisões fazem parte do dia-a-dia das organizações, sendo essas decisões suportadas pela informação que tem de ser tratada de uma forma adequada.
N/A
Subjects/Keywords: Sistemas de suporte à decisão; Data warehouse
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Silva, A. (2017). Avaliação da utilização dos Sistemas de Suporte à Decisão nas Pequenas e Médias Empresas do concelho de Paredes. (Thesis). RCAAP. Retrieved from https://www.rcaap.pt/detail.jsp?id=oai:repositorio.ismai.pt:10400.24/774
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Silva, António. “Avaliação da utilização dos Sistemas de Suporte à Decisão nas Pequenas e Médias Empresas do concelho de Paredes.” 2017. Thesis, RCAAP. Accessed March 23, 2019.
https://www.rcaap.pt/detail.jsp?id=oai:repositorio.ismai.pt:10400.24/774.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Silva, António. “Avaliação da utilização dos Sistemas de Suporte à Decisão nas Pequenas e Médias Empresas do concelho de Paredes.” 2017. Web. 23 Mar 2019.
Vancouver:
Silva A. Avaliação da utilização dos Sistemas de Suporte à Decisão nas Pequenas e Médias Empresas do concelho de Paredes. [Internet] [Thesis]. RCAAP; 2017. [cited 2019 Mar 23].
Available from: https://www.rcaap.pt/detail.jsp?id=oai:repositorio.ismai.pt:10400.24/774.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Silva A. Avaliação da utilização dos Sistemas de Suporte à Decisão nas Pequenas e Médias Empresas do concelho de Paredes. [Thesis]. RCAAP; 2017. Available from: https://www.rcaap.pt/detail.jsp?id=oai:repositorio.ismai.pt:10400.24/774
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
17.
Cederberg, Niclas.
Strategic Alignment of Business Intelligence.
Degree: 2010, , School of Management
URL: http://urn.kb.se/resolve?urn=urn:nbn:se:bth-5804
► This thesis is about the concept of strategic alignment of business intelligence. It is based on a theoretical foundation that is used to define…
(more)
▼ This thesis is about the concept of strategic alignment of business intelligence. It is based on a theoretical foundation that is used to define and explain business intelligence, data warehousing and strategic alignment. By combining a number of different methods for strategic alignment a framework for alignment of business intelligence is suggested. This framework addresses all different aspects of business intelligence identified as relevant for strategic alignment of business intelligence: technology, organization, processes, people and strategies. Using the framework to analyze the strategic alignment of business intelligence of an organization will result in the identification of potential alignment gaps. These gaps can be considered as potential areas of improvement. By addressing these areas an organization could improve their alignment and also increase the value of the business intelligence investment
Subjects/Keywords: strategic alignment; business intelligence; data warehouse
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Cederberg, N. (2010). Strategic Alignment of Business Intelligence. (Thesis). , School of Management. Retrieved from http://urn.kb.se/resolve?urn=urn:nbn:se:bth-5804
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Cederberg, Niclas. “Strategic Alignment of Business Intelligence.” 2010. Thesis, , School of Management. Accessed March 23, 2019.
http://urn.kb.se/resolve?urn=urn:nbn:se:bth-5804.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Cederberg, Niclas. “Strategic Alignment of Business Intelligence.” 2010. Web. 23 Mar 2019.
Vancouver:
Cederberg N. Strategic Alignment of Business Intelligence. [Internet] [Thesis]. , School of Management; 2010. [cited 2019 Mar 23].
Available from: http://urn.kb.se/resolve?urn=urn:nbn:se:bth-5804.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Cederberg N. Strategic Alignment of Business Intelligence. [Thesis]. , School of Management; 2010. Available from: http://urn.kb.se/resolve?urn=urn:nbn:se:bth-5804
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
18.
Brito, João Renato Figueiredo.
Business intelligence solution for the economic and financial area
.
Degree: 2018, Universidade de Aveiro
URL: http://hdl.handle.net/10773/25127
► When used properly, the most powerful tool that companies have to understand their business is the data generated by the business. Nowadays every mid-to-large size…
(more)
▼ When used properly, the most powerful tool that companies have to understand
their business is the
data generated by the business.
Nowadays every mid-to-large size company uses an Enterprise Resource
Planning (ERP) system that collects information about the state of all
di erent divisions of the enterprise and stores this information, making it
available to be used by every department of the company. The
data stored
is very valuable to a company and properly analyzed it can help companies
take better business actions. The current Business Intelligence solutions
work great when analyzing
data from a single source, but struggle to collect
data from di erent sources. The objective of this dissertation is to create a
Business Intelligence solution, focused in the nancial and economic eld,
that can extract
data from all the di erent ERPs that currently exist and
store that information in a
Data Warehouse, making it available to further
processing and analyzing. This project was proposed by a portuguese company,
Satbyte, and it was done in a business environment in collaboration
with it to develop a new marketable product for the company.
This document contains the proposed solution to the problem and a implementation
of it. That consisted in the creation of a
Data Warehouse
to store the
data in an integrated way, coming from several ERPs and the
development, in web environment, of several use cases from the economic
and nancial analysis eld. The developed solution proved to be e ective
for the purpose initially formulated and was validated by the company as
having a crucial role for the continuation of the development of the extended
Business Intelligence solution in which they intend to continue to invest.
Advisors/Committee Members: Zagalo, Helder Troca (advisor).
Subjects/Keywords: Business Intelligence;
Data Warehouse;
ETL;
ERP
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Brito, J. R. F. (2018). Business intelligence solution for the economic and financial area
. (Thesis). Universidade de Aveiro. Retrieved from http://hdl.handle.net/10773/25127
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Brito, João Renato Figueiredo. “Business intelligence solution for the economic and financial area
.” 2018. Thesis, Universidade de Aveiro. Accessed March 23, 2019.
http://hdl.handle.net/10773/25127.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Brito, João Renato Figueiredo. “Business intelligence solution for the economic and financial area
.” 2018. Web. 23 Mar 2019.
Vancouver:
Brito JRF. Business intelligence solution for the economic and financial area
. [Internet] [Thesis]. Universidade de Aveiro; 2018. [cited 2019 Mar 23].
Available from: http://hdl.handle.net/10773/25127.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Brito JRF. Business intelligence solution for the economic and financial area
. [Thesis]. Universidade de Aveiro; 2018. Available from: http://hdl.handle.net/10773/25127
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
California State University – Sacramento
19.
Natarajan, Srinivasan.
Enhancing web ETL tool.
Degree: MS, Computer Science, 2011, California State University – Sacramento
URL: http://hdl.handle.net/10211.9/1223
► Extract Transform and Load (ETL) is a process in data warehouse projects to extract data from external sources, transform them according to business needs and…
(more)
▼ Extract Transform and Load (ETL) is a process in
data warehouse projects to extract
data from external sources, transform them according to business needs and load them in target database. The web ETL tool developed by Nithin Vijayendra as part of his master???s project ???A Courseware on ETL process??? has the below features:
??? Extract
data from text files and MySQL tables.
??? Apply
data type transformation and merge from multiple sources with or without duplicates.
??? Loading the
data back to MySQL tables.
I propose to add the below features:
1. Support for Oracle, XML Sources and Oracle Target
Adding functionality to support XML, Oracle Sources, and Oracle target. Commercial tools will have capabilities to extract
data from multiple sources formats like XML and relational database (Oracle). Currently, the tool supports only MySQL as source and target. Enhancing the tool to support Oracle and XML format as source and Oracle as target will provide end users with additional capability of using these source and targets.
2. Additional Transformations
Adding additional commonly used transformation such as joining tables, filtering
data, dropping columns and generating surrogate keys to make it complete. Currently, tool supports transformations like merging from multiple sources (with or without duplicates) and applying
data table transformations.
3. Metadata Repository
Enhance the tool to support metadata repository. When using the tool as an end user if I select my source as flat file, I have to manually enter the meta
data for each and every column in the flat file which is tedious and time consuming; rather I would prefer to have a metadata repository which I can use as template for using it against similar flat file from different sources, so in this way I can modify only the required meta
data according to my needs rather than specifying metadata for each and every field once again.
The above mentioned features will be implemented using Php5, JavaScript and Html. I would be using MySQL and Oracle databases to store the
data. The application will be hosted on the server gaia.ecs.csus.edu.
Advisors/Committee Members: Lu, Meiliu.
Subjects/Keywords: Data warehouse; ETL process; Metadata repository
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Natarajan, S. (2011). Enhancing web ETL tool. (Masters Thesis). California State University – Sacramento. Retrieved from http://hdl.handle.net/10211.9/1223
Chicago Manual of Style (16th Edition):
Natarajan, Srinivasan. “Enhancing web ETL tool.” 2011. Masters Thesis, California State University – Sacramento. Accessed March 23, 2019.
http://hdl.handle.net/10211.9/1223.
MLA Handbook (7th Edition):
Natarajan, Srinivasan. “Enhancing web ETL tool.” 2011. Web. 23 Mar 2019.
Vancouver:
Natarajan S. Enhancing web ETL tool. [Internet] [Masters thesis]. California State University – Sacramento; 2011. [cited 2019 Mar 23].
Available from: http://hdl.handle.net/10211.9/1223.
Council of Science Editors:
Natarajan S. Enhancing web ETL tool. [Masters Thesis]. California State University – Sacramento; 2011. Available from: http://hdl.handle.net/10211.9/1223
University College Cork
20.
Hoerster, Stephan Carlo.
Analysis of building performance data.
Degree: 2018, University College Cork
URL: http://hdl.handle.net/10468/6555
► In recent years, the global trend for digitalisation has also reached buildings and facility management. Due to the roll out of smart meters and the…
(more)
▼ In recent years, the global trend for digitalisation has also reached buildings and facility management. Due to the roll out of smart meters and the retrofitting of buildings with meters and sensors, the amount of
data available for a single building has increased significantly. In addition to
data sets collected by measurement devices, Building Information Modelling has recently seen a strong incline. By maintaining a building model through the whole building life-cycle, the model becomes rich of information describing all major aspects of a building. This work aims to combine these
data sources to gain further valuable information from
data analysis. Better knowledge of the building’s behaviour due to high quality
data available leads to more efficient building operations. Eventually, this may result in a reduction of energy use and therefore less operational costs. In this thesis a concept for holistic
data acquisition from smart meters and a methodology for the integration of further meters in the measurement concept are introduced and validated. Secondly, this thesis presents a novel algorithm designed for cleansing and interpolation of faulty
data. Descriptive
data is extracted from an open meta
data model for buildings which is utilised to further enrich the metered
data. Additionally, this thesis presents a methodology for how to design and manage all information in a unified
Data Warehouse schema. This
Data Warehouse, which has been developed, maintains compatibility with an open meta
data model by adopting the model’s specification into its
data schema. It features the application of building specific Key Performance Indicators (KPI) to measure building performance. In addition a clustering algorithm, based on machine learning technology, is developed to identify behavioural patterns of buildings and their frequency of occurrence. All methodologies introduced in this work are evaluated through installations and
data from three pilot buildings. The pilot buildings were selected to be of diverse types to prove the generic applicability of the above concepts. The outcome of this work successfully demonstrates that the combination of
data sources available for buildings enable advanced
data analysis. This largely increases the understanding of buildings and their behavioural patterns. A more efficient building operation and a reduction of energy usage can be achieved with this knowledge.
Advisors/Committee Members: Menzel, Karsten, Brown, Ken, HEA.
Subjects/Keywords: BIM; IFC; Clustering; Metering; Monitoring; Data warehouse
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Hoerster, S. C. (2018). Analysis of building performance data. (Thesis). University College Cork. Retrieved from http://hdl.handle.net/10468/6555
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Hoerster, Stephan Carlo. “Analysis of building performance data.” 2018. Thesis, University College Cork. Accessed March 23, 2019.
http://hdl.handle.net/10468/6555.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Hoerster, Stephan Carlo. “Analysis of building performance data.” 2018. Web. 23 Mar 2019.
Vancouver:
Hoerster SC. Analysis of building performance data. [Internet] [Thesis]. University College Cork; 2018. [cited 2019 Mar 23].
Available from: http://hdl.handle.net/10468/6555.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Hoerster SC. Analysis of building performance data. [Thesis]. University College Cork; 2018. Available from: http://hdl.handle.net/10468/6555
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
21.
Lúcia Aline Brum Saccomori.
Modelagem e prototipagem de um data warehouse de projetos na visão gerencial das áreas de conhecimento em projetos do PMBOK.
Degree: 2008, Universidade do Vale do Rio do Sinos
URL: http://bdtd.unisinos.br/tde_busca/arquivo.php?codArquivo=1019
► Suprir as necessidades gerenciais com mecanismos computacionais ágeis e de fácil uso são características chaves de sucesso dos processos decisórios. Além disso, torna-se necessário contemplar…
(more)
▼ Suprir as necessidades gerenciais com mecanismos computacionais ágeis e de fácil uso são características chaves de sucesso dos processos decisórios. Além disso, torna-se necessário contemplar aspectos relacionados à transparência organizacional, o que representa um desafio essencial para os sistemas de informação, nas organizações, na busca do equilíbrio entre a gestão e o uso da tecnologia, através do investimento em modelos e metodologias de Governança de Tecnologia da Informação (GTI). A gestão de projetos pode se tornar então, um problema para o desenvolvimento de negócios, pois na maioria dos casos a percepção dos gestores quanto à qualidade dos projetos não é adequada. Esta percepção está relacionada à falta de informações referentes as áreas de conhecimento em gerência de projetos. O presente trabalho insere-se nesta realidade e propõe, através de um estudo de caso em uma empresa de TI, uma solução que proporciona uma visão gerencial para tomada de decisões. Esta solução atende os conceitos de gestão de projetos para Governança de TI e é sustentada por bases de dados de projetos existentes na empresa analisada. A proposta final é a apresentação e análise de uma solução de Data Warehouse (DW) que compatibilize as diversas bases de projetos à luz do PMBOK criando uma base única que provê informações gerenciais de projeto com vistas a GTI. A solução também atende as lacunas teóricas como: aspectos de compatibilidade das várias bases de dados existentes na empresa analisada, padronização dos conceitos de áreas de gerenciamento de projetos, regularidade da atualização das informações, benefício futuro, visibilidade sobre os projetos, provida pelo ambiente de gerência de tempos de projetos, e melhorias nas visões do cubo.
Providing the needs managerial with agile computational mechanisms and easy to use are key characteristics for the success in decision-making process. Moreover, it becomes necessary to contemplate aspects related to the organizational transparency, which is a key challenge for information systems, in the organizations, in the search of balance between management and use of technology through of investment in models and methodologies of Information Technology Governance (IT Governance). The project management can then it to become a problem to the business development, because in the most cases the perception of managers regarding the quality of projects is not appropriate. This perception is related to the lack of information regarding to the knowledgement areas in projects management. The present study is part of this reality and proposed, through a case study in an IT company, a solution that provides a managerial view to the decision-making. This solution deals the project management concepts for the IT Governance and is supported by databases of existing projects in the company analyzed. The final proposal is the presentation and analysis of a Data Warehouse (DW) solution that become compatibles the bases of various projects in the light of the PMBOK creating a unique base that provide…
Advisors/Committee Members: Adolfo Alberto Vanti.
Subjects/Keywords: data warehouse; PMBOK; TI; gestão de projetos; data warehouse; management project; ADMINISTRACAO
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Saccomori, L. A. B. (2008). Modelagem e prototipagem de um data warehouse de projetos na visão gerencial das áreas de conhecimento em projetos do PMBOK. (Thesis). Universidade do Vale do Rio do Sinos. Retrieved from http://bdtd.unisinos.br/tde_busca/arquivo.php?codArquivo=1019
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Saccomori, Lúcia Aline Brum. “Modelagem e prototipagem de um data warehouse de projetos na visão gerencial das áreas de conhecimento em projetos do PMBOK.” 2008. Thesis, Universidade do Vale do Rio do Sinos. Accessed March 23, 2019.
http://bdtd.unisinos.br/tde_busca/arquivo.php?codArquivo=1019.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Saccomori, Lúcia Aline Brum. “Modelagem e prototipagem de um data warehouse de projetos na visão gerencial das áreas de conhecimento em projetos do PMBOK.” 2008. Web. 23 Mar 2019.
Vancouver:
Saccomori LAB. Modelagem e prototipagem de um data warehouse de projetos na visão gerencial das áreas de conhecimento em projetos do PMBOK. [Internet] [Thesis]. Universidade do Vale do Rio do Sinos; 2008. [cited 2019 Mar 23].
Available from: http://bdtd.unisinos.br/tde_busca/arquivo.php?codArquivo=1019.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Saccomori LAB. Modelagem e prototipagem de um data warehouse de projetos na visão gerencial das áreas de conhecimento em projetos do PMBOK. [Thesis]. Universidade do Vale do Rio do Sinos; 2008. Available from: http://bdtd.unisinos.br/tde_busca/arquivo.php?codArquivo=1019
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
22.
Carvalho, Guilherme Tozo de.
Aplicação de práticas ágeis na construção de data warehouse evolutivo.
Degree: Mestrado, Ciência da Computação, 2009, University of São Paulo
URL: http://www.teses.usp.br/teses/disponiveis/45/45134/tde-09062009-002617/
;
► Um Data Warehouse (DW) é um banco de dados centralizado, orientado por assunto, integrado, não volátil e histórico, criado com o objetivo de dar apoio…
(more)
▼ Um Data Warehouse (DW) é um banco de dados centralizado, orientado por assunto, integrado, não volátil e histórico, criado com o objetivo de dar apoio ao processo de tomada de decisão e que estrutura os dados em uma arquitetura analítica bastante distinta da arquitetura relacional utilizada nos bancos de dados transacionais. Construir um DW é um projeto de engenharia bastante complexo pois envolve muitas tecnologias e muitas pessoas, de diferentes equipes, em um grande esforço conjunto para construir esta base central de informações corporativas. O processo tradicional de construção de um DW não utiliza conceitos ágeis e, pelo escopo de desenvolvimento ser grande, pode levar muito tempo até que funcionalidades sejam entregues aos clientes. Os métodos ágeis de engenharia de software são muito usados como uma alternativa aos métodos tradicionais de desenvolvimento e têm diferenciais que trazem muito valor a projetos grandes pois, além de buscar desenvolver versões funcionais em prazos curtos, defendem que todos os sistemas têm a constante necessidade de se adaptar a mudanças. Neste trabalho são aplicadas práticas ágeis no processo tradicional de engenharia de DW para que o desenvolvimento seja realizado em ciclos iterativos curtos, tornando possível o desenvolvimento rápido e evolutivo de um DW com entregas constantes de novas funcionalidades. A contínua evolução deste complexo ambiente analítico é apoiada por conceitos de banco de dados evolutivos e também por fundamentos de métodos ágeis.
A data warehouse (DW) is a central database, subject-oriented, integrated, nonvolatile, and time-variant collection of data in support of management\'s decision making process and that summarize the data in an analytic architecture quite different from the relational one, used in transactional databases. Building a DW is a complex engineering project because it involves many technologies and many people, from different teams, in a huge corporative effort to build a central database with corporative data. The traditional engineering process to build a DW does not use agile concepts and, as its scope is quite big, it might takes a long time until the customer can use its features. Agile methods of software engineering are commonly used as an alternative to the traditional methods and they have some differentials that lead a lot of value to big projects, as the continuous attempt to develop short releases in short periods of time, or the belief that every system needs to be continuously adapted to the changes on its environment. This work applies agile practices in the traditional DW engineering method, so that the development can be done in short iterative cycles, making possible a fast and evolutive DW project, with frequent delivering of new functionalities. The continuous evolution of this complex analytical environment is supported by evolutive database concepts and also for agile methods foundations.
Advisors/Committee Members: Ferreira, João Eduardo.
Subjects/Keywords: Agile Methods; Banco de Dados; Data Warehouse; Data Warehouse; Database.; Métodos Ágeis; Refactoring; Refatoração
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Carvalho, G. T. d. (2009). Aplicação de práticas ágeis na construção de data warehouse evolutivo. (Masters Thesis). University of São Paulo. Retrieved from http://www.teses.usp.br/teses/disponiveis/45/45134/tde-09062009-002617/ ;
Chicago Manual of Style (16th Edition):
Carvalho, Guilherme Tozo de. “Aplicação de práticas ágeis na construção de data warehouse evolutivo.” 2009. Masters Thesis, University of São Paulo. Accessed March 23, 2019.
http://www.teses.usp.br/teses/disponiveis/45/45134/tde-09062009-002617/ ;.
MLA Handbook (7th Edition):
Carvalho, Guilherme Tozo de. “Aplicação de práticas ágeis na construção de data warehouse evolutivo.” 2009. Web. 23 Mar 2019.
Vancouver:
Carvalho GTd. Aplicação de práticas ágeis na construção de data warehouse evolutivo. [Internet] [Masters thesis]. University of São Paulo; 2009. [cited 2019 Mar 23].
Available from: http://www.teses.usp.br/teses/disponiveis/45/45134/tde-09062009-002617/ ;.
Council of Science Editors:
Carvalho GTd. Aplicação de práticas ágeis na construção de data warehouse evolutivo. [Masters Thesis]. University of São Paulo; 2009. Available from: http://www.teses.usp.br/teses/disponiveis/45/45134/tde-09062009-002617/ ;
23.
André Luiz Nascente Ferreira.
GESTÃO DO PROCESSO DE RELIGAÇÃO DE ÁGUA TRATADA NA CIDADE DE GOIÂNIA, UTILIZANDO OLAP E DATA WAREHOUSE.
Degree: 2013, Pontifícia Universidade Católica de Goiás
URL: http://tede.biblioteca.ucg.br/tde_busca/arquivo.php?codArquivo=1323
► Através do saneamento, problemas econômicos, sociais e de saúde pública são amenizados resultando em uma melhoria considerável na qualidade de vida da população. Para que…
(more)
▼ Através do saneamento, problemas econômicos, sociais e de saúde pública são amenizados resultando em uma melhoria considerável na qualidade de vida da população. Para que empresas desse ramo de atividade possam desempenhar cada vez melhor suas atribuições é necessário estabelecer qualidade na gestão dos seus processos internos. Existe um processo específico dessas empresas que são indispensáveis para a manutenção da qualidade de vida e disponibilização do saneamento para a população, que se refere às Religações de Água Tratada, que geralmente ocorrem devido ao corte do seu abastecimento. Este trabalho aborda conceitos de Tecnologia da Informação (TI) na intenção de utilizá-los para melhorar a gestão deste processo, abrangendo teorias específicas de Engenharia de Software, OLAP e Data Warehouse. De maneira geral, o trabalho apresenta o desenvolvimento e implantação de uma ferramenta OLAP específica para auxiliar no controle sobre o tempo gasto na execução das Religações de Água Tratada na cidade de Goiânia, no estado de Goiás, e analisa os resultados obtidos por essa ferramenta, comparando cenários antes e após a implantação da mesma. De acordo com a análise dos resultados obtidos, pôde-se observar melhorias em relação ao tempo de execução das religações após a implantação da ferramenta desenvolvida.
Through sanitation, economic, social and public health problems are minimized resulting in a considerable improvement in quality of life. For companies in this line of work can improve their results by establishing quality in the managment of their internal processes. There is a specific process of these companies dealing with Reconnections of Treated Water, which usually occur due to cutting of their supply. This work discusses the concepts of Information Technology (IT) in the intent to use them to improve the management of this process, covering specific theories of Software Engineering, Data Warehouse and OLAP. Overall, the work presents the development and implementation of an OLAP tool to assist in specific control over the time spent in performing the Reconnections of Treated Water in the city of Goiânia, state of Goiás, and analyzes the results of this tool, comparing scenarios before and after its implementation of the same. According to the analysis of the results, we observed improvements on the times of reconnections after the implementation of the developed tool.
Advisors/Committee Members: Juliano Lopes de Oliveira, Sibelius Lellis Vieira, Solange da Silva.
Subjects/Keywords: Tecnologia da Informação; OLAP; Data Warehouse; ENGENHARIA DE PRODUCAO; Information Technology; OLAP; Data Warehouse
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Ferreira, A. L. N. (2013). GESTÃO DO PROCESSO DE RELIGAÇÃO DE ÁGUA TRATADA NA CIDADE DE GOIÂNIA, UTILIZANDO OLAP E DATA WAREHOUSE. (Thesis). Pontifícia Universidade Católica de Goiás. Retrieved from http://tede.biblioteca.ucg.br/tde_busca/arquivo.php?codArquivo=1323
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Ferreira, André Luiz Nascente. “GESTÃO DO PROCESSO DE RELIGAÇÃO DE ÁGUA TRATADA NA CIDADE DE GOIÂNIA, UTILIZANDO OLAP E DATA WAREHOUSE.” 2013. Thesis, Pontifícia Universidade Católica de Goiás. Accessed March 23, 2019.
http://tede.biblioteca.ucg.br/tde_busca/arquivo.php?codArquivo=1323.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Ferreira, André Luiz Nascente. “GESTÃO DO PROCESSO DE RELIGAÇÃO DE ÁGUA TRATADA NA CIDADE DE GOIÂNIA, UTILIZANDO OLAP E DATA WAREHOUSE.” 2013. Web. 23 Mar 2019.
Vancouver:
Ferreira ALN. GESTÃO DO PROCESSO DE RELIGAÇÃO DE ÁGUA TRATADA NA CIDADE DE GOIÂNIA, UTILIZANDO OLAP E DATA WAREHOUSE. [Internet] [Thesis]. Pontifícia Universidade Católica de Goiás; 2013. [cited 2019 Mar 23].
Available from: http://tede.biblioteca.ucg.br/tde_busca/arquivo.php?codArquivo=1323.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Ferreira ALN. GESTÃO DO PROCESSO DE RELIGAÇÃO DE ÁGUA TRATADA NA CIDADE DE GOIÂNIA, UTILIZANDO OLAP E DATA WAREHOUSE. [Thesis]. Pontifícia Universidade Católica de Goiás; 2013. Available from: http://tede.biblioteca.ucg.br/tde_busca/arquivo.php?codArquivo=1323
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
24.
Veronica Ruiz Castro, Carla.
CSTM: a conceptual spatiotemporal model for data warehouses
.
Degree: 2010, Universidade Federal de Pernambuco
URL: http://repositorio.ufpe.br/handle/123456789/2209
► Estudos abrangentes relacionados a data warehouse temporais e espaciais têm sido conduzidos. Data warehouse temporais permitem lidar com dados variáveis no tempo tanto em tabelas…
(more)
▼ Estudos abrangentes relacionados a
data warehouse temporais e espaciais têm sido
conduzidos.
Data warehouse temporais permitem lidar com dados variáveis no tempo
tanto em tabelas de fatos quanto em tabelas de dimensões. Uma ampla variedade de
aplicações precisa capturar não só características espaciais, mas também temporais das
entidades modeladas. Entretanto, estudos que unam essas duas áreas de pesquisa não
têm sido suficientemente considerados. É neste contexto que o presente trabalho de
dissertação está definido. Ele propõe um modelo conceitual para
data warehouses espaço
temporais. Este modelo permite aos usuários definir níveis, hierarquias e dimensões
tanto com características espaciais como temporais. Como consequência disso, é possível
representar atributos espaciais variáveis no tempo. Além disso, este trabalho define
um conjunto de operadores espaço temporais que poderia ser útil na consulta de
data
warehouses espaço temporais. Diferentemente de propostas existentes, nossos operadores
integram não só operadores multidimensionais e espaciais, mas também espaciais e
temporais (i.e., espaço temporais) em uma única sintaxe. Um esquema taxonômico, o
qual classifica os operadores propostos, também é definido. A importância da taxonomia
proposta é que ajuda no desenvolvimento de tecnologia OLAP espaço temporal. Com
o objetivo de automatizar a modelagem de esquemas espaço temporais, uma ferramenta
CASE foi desenvolvida. Além de permitir a definição de esquemas conformes com o
modelo conceitual proposto, esta ferramenta também permite a geração automática do
esquema lógico correspondente usando uma abordagem objeto relacional. As ideias
propostas são validadas com um estudo de caso na área meteorológica. O estudo
apresenta uma aplicação prática do modelo conceitual espaço temporal e dos operadores
espaço temporais apresentados neste trabalho
Advisors/Committee Members: Cesário Times, Valéria (advisor).
Subjects/Keywords: Taxonomia;
Operadores espaço temporais;
Data
warehouse design;
Modelagem conceitual;
Data warehouse espaço temporal
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Veronica Ruiz Castro, C. (2010). CSTM: a conceptual spatiotemporal model for data warehouses
. (Thesis). Universidade Federal de Pernambuco. Retrieved from http://repositorio.ufpe.br/handle/123456789/2209
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Veronica Ruiz Castro, Carla. “CSTM: a conceptual spatiotemporal model for data warehouses
.” 2010. Thesis, Universidade Federal de Pernambuco. Accessed March 23, 2019.
http://repositorio.ufpe.br/handle/123456789/2209.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Veronica Ruiz Castro, Carla. “CSTM: a conceptual spatiotemporal model for data warehouses
.” 2010. Web. 23 Mar 2019.
Vancouver:
Veronica Ruiz Castro C. CSTM: a conceptual spatiotemporal model for data warehouses
. [Internet] [Thesis]. Universidade Federal de Pernambuco; 2010. [cited 2019 Mar 23].
Available from: http://repositorio.ufpe.br/handle/123456789/2209.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Veronica Ruiz Castro C. CSTM: a conceptual spatiotemporal model for data warehouses
. [Thesis]. Universidade Federal de Pernambuco; 2010. Available from: http://repositorio.ufpe.br/handle/123456789/2209
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
North-West University
25.
Juggath, Shakeel Mitra.
A comparison of maintenance and support challenges within a data warehousing environment to that of a transactional application environment in a South African context / Shakeel Mitra Juggath
.
Degree: 2014, North-West University
URL: http://hdl.handle.net/10394/15322
► In transactional systems development literature, maintenance is reported as being a phase in the software development life cycle. In practice, this phase is often neglected…
(more)
▼ In transactional systems development literature, maintenance is reported as being a phase in the software development life cycle. In practice, this phase is often neglected as it occurs post-deployment and other ongoing projects take a higher priority. In data warehouse (DW) systems development literature, maintenance is not reported as being a phase but an ongoing iteration to the DW development project. It should therefore not be treated as a phase by DW systems professionals.
Although there is this fundamental difference in the approach to maintenance, transaction systems maintenance and DW maintenance share many of the same challenges. DW literature and methodologies inherently contain utilities and methods to assist in alleviating these challenges in a DW system. Transactional systems do not deal with these challenges inherently.
Research aspects were extracted from the literature review conducted. The literature review conducted demonstrates what the challenges in maintenance are, how the challenges of transactional systems compare to the challenges of DW maintenance and how the utilities and methods used in DW methodologies can inherently assist in managing these challenges from DW perspective. These research aspects were used to formulate an interpretive questionnaire.
This research portion of the study explores the use of DW systems development and maintenance methodologies in the industry among DW professionals. This is done by conducting an interpretive study using the interpretive questionnaire developed from the literature review. The interpretive questionnaire focusses on maintenance and dealing with the challenges thereof. Many themes evolved from the analysis of the interpretive study by using the content analysis method.
The final conclusions of this study is drawn by comparing and combining the information gathered from the literature review with the information gathered from the
interpretive study. Gaps are identified between practice and literature and recommendations are made based on these gaps.
Subjects/Keywords: Data warehouse maintenance;
Challenges in maintenance;
Data warehouse methodology;
Transactional system methodology;
Methodology comparison
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Juggath, S. M. (2014). A comparison of maintenance and support challenges within a data warehousing environment to that of a transactional application environment in a South African context / Shakeel Mitra Juggath
. (Thesis). North-West University. Retrieved from http://hdl.handle.net/10394/15322
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Juggath, Shakeel Mitra. “A comparison of maintenance and support challenges within a data warehousing environment to that of a transactional application environment in a South African context / Shakeel Mitra Juggath
.” 2014. Thesis, North-West University. Accessed March 23, 2019.
http://hdl.handle.net/10394/15322.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Juggath, Shakeel Mitra. “A comparison of maintenance and support challenges within a data warehousing environment to that of a transactional application environment in a South African context / Shakeel Mitra Juggath
.” 2014. Web. 23 Mar 2019.
Vancouver:
Juggath SM. A comparison of maintenance and support challenges within a data warehousing environment to that of a transactional application environment in a South African context / Shakeel Mitra Juggath
. [Internet] [Thesis]. North-West University; 2014. [cited 2019 Mar 23].
Available from: http://hdl.handle.net/10394/15322.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Juggath SM. A comparison of maintenance and support challenges within a data warehousing environment to that of a transactional application environment in a South African context / Shakeel Mitra Juggath
. [Thesis]. North-West University; 2014. Available from: http://hdl.handle.net/10394/15322
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
26.
Singh, Jaiteg.
Promulgation of contemporary testing techniques for
effective engineering of data warehouses.
Degree: 2011, Punjabi University; University College of Engineering
URL: http://shodhganga.inflibnet.ac.in/handle/10603/2099
► Testing in data warehouse systems is substantial because it is oriented towards the correctness and validation of data/ information supplied for decision making. Keeping in…
(more)
▼ Testing in data warehouse systems is substantial
because it is oriented towards the correctness and validation of
data/ information supplied for decision making. Keeping in view the
idiosyncratic characteristics of data warehouse testing and the
complexity of data warehouse projects, this research has reviewed
and revised the scope of automated testing in assuring quality data
warehouse solutions. Initially a data set generator has been
developed to generate synthetic but near to real data; followed by
the classification of anomalies in synthesized data with the help
of a hand coded Extraction, Transformation and Loading (ETL)
routine. To ensure quality data for a data warehouse and to
promulgate the importance of Extraction, Transformation and Loading
(ETL) routines some test cases of prime importance were identified.
Later on automated testing procedures were embedded in hand coded
ETL routine to ensure quality data. The statistical analysis
revealed major enhancement in data quality with the introduction of
automated testing procedures.
Bibliography P.167-178
Advisors/Committee Members: Singh, Kawaljeet.
Subjects/Keywords: Data Warehouse; ETL; DSG; Data Extractor; Data
Sharehouse; Testing
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Singh, J. (2011). Promulgation of contemporary testing techniques for
effective engineering of data warehouses. (Thesis). Punjabi University; University College of Engineering. Retrieved from http://shodhganga.inflibnet.ac.in/handle/10603/2099
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
Singh, Jaiteg. “Promulgation of contemporary testing techniques for
effective engineering of data warehouses.” 2011. Thesis, Punjabi University; University College of Engineering. Accessed March 23, 2019.
http://shodhganga.inflibnet.ac.in/handle/10603/2099.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
Singh, Jaiteg. “Promulgation of contemporary testing techniques for
effective engineering of data warehouses.” 2011. Web. 23 Mar 2019.
Vancouver:
Singh J. Promulgation of contemporary testing techniques for
effective engineering of data warehouses. [Internet] [Thesis]. Punjabi University; University College of Engineering; 2011. [cited 2019 Mar 23].
Available from: http://shodhganga.inflibnet.ac.in/handle/10603/2099.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
Singh J. Promulgation of contemporary testing techniques for
effective engineering of data warehouses. [Thesis]. Punjabi University; University College of Engineering; 2011. Available from: http://shodhganga.inflibnet.ac.in/handle/10603/2099
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
27.
PALILOT, Álvaro Alencar Barbosa.
Distribuindo dados e consultas em um ambiente de data warehousing na web
.
Degree: 2010, Universidade Federal de Pernambuco
URL: http://repositorio.ufpe.br/handle/123456789/2168
► Nos dias atuais, uma das ferramentas mais utilizadas de Business Intelligence (BI) para o suporte à decisão da alta gerência de grandes companhias é o…
(more)
▼ Nos dias atuais, uma das ferramentas mais utilizadas de Business Intelligence
(BI) para o suporte à decisão da alta gerência de grandes companhias é o
Data
Warehouse (DW). O DW é um banco de dados que armazena seus dados de uma forma
especial para que se otimizem as consultas orientadas ao negócio, além dos dados
terem como características a não volatilidade, serem históricos e integrados. O
ambiente em que o DW está inserido é o
Data Warehousing que contempla não só o
DW mais outros componentes que o ajudam a desempenhar a sua atividade fim.
O aumento da quantidade de usuários utilizando esse ambiente, o crescimento
exponencial do tamanho do DW, além da necessidade de otimizar as consultas e
atender localmente os interesses da diretoria dos departamentos ou filiais específicas,
fez com que pesquisadores da área de banco de dados buscassem soluções para obter
a distribuição dos dados e consultas de uma forma transparente e segura em um
ambiente de
data warehousing. Atualmente, existem vários trabalhos correlatos nessa
linha de pesquisa, porém nenhum demonstra na prática o resultado efetivo de uma
arquitetura que contemple essas vantagens.
Esse trabalho toma como base a arquitetura do sistema WebD²W (Web
Distributed
Data Warehousing) proposta por Cristina Ciferri para efetivar essa
distribuição. Assim, foram desenvolvidos o componente de distribuição, utilizando o
conceito de grafos de derivação para o desenvolvimento de algoritmos de
fragmentação horizontal e mista, e o componente de consulta do ambiente
distribuído, estendendo o servidor OLAP Mondrian para atender às necessidades
impostas por essa nova arquitetura. Finalmente, um DW de uma rede de locadoras de
DVD foi gerado para ser utilizado como estudo de caso para mostrar a aplicabilidade e
eficiência desses componentes
Advisors/Committee Members: SOUZA, Fernando da Fonseca de (advisor).
Subjects/Keywords: Data warehouse;
Data warehousing;
Data warehousing distribuído;
Grafos de derivação
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
PALILOT, . A. B. (2010). Distribuindo dados e consultas em um ambiente de data warehousing na web
. (Thesis). Universidade Federal de Pernambuco. Retrieved from http://repositorio.ufpe.br/handle/123456789/2168
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Chicago Manual of Style (16th Edition):
PALILOT, Álvaro Alencar Barbosa. “Distribuindo dados e consultas em um ambiente de data warehousing na web
.” 2010. Thesis, Universidade Federal de Pernambuco. Accessed March 23, 2019.
http://repositorio.ufpe.br/handle/123456789/2168.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
MLA Handbook (7th Edition):
PALILOT, Álvaro Alencar Barbosa. “Distribuindo dados e consultas em um ambiente de data warehousing na web
.” 2010. Web. 23 Mar 2019.
Vancouver:
PALILOT AB. Distribuindo dados e consultas em um ambiente de data warehousing na web
. [Internet] [Thesis]. Universidade Federal de Pernambuco; 2010. [cited 2019 Mar 23].
Available from: http://repositorio.ufpe.br/handle/123456789/2168.
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
Council of Science Editors:
PALILOT AB. Distribuindo dados e consultas em um ambiente de data warehousing na web
. [Thesis]. Universidade Federal de Pernambuco; 2010. Available from: http://repositorio.ufpe.br/handle/123456789/2168
Note: this citation may be lacking information needed for this citation format:
Not specified: Masters Thesis or Doctoral Dissertation
University of Bradford
28.
Rifaie, Mohammad.
Strategy and methodology for enterprise data warehouse development : integrating data mining and social networking techniques for identifying different communities within the data warehouse.
Degree: PhD, 2010, University of Bradford
URL: http://hdl.handle.net/10454/4416
► Data warehouse technology has been successfully integrated into the information infrastructure of major organizations as potential solution for eliminating redundancy and providing for comprehensive data…
(more)
▼ Data warehouse technology has been successfully integrated into the information infrastructure of major organizations as potential solution for eliminating redundancy and providing for comprehensive data integration. Realizing the importance of a data warehouse as the main data repository within an organization, this dissertation addresses different aspects related to the data warehouse architecture and performance issues. Many data warehouse architectures have been presented by industry analysts and research organizations. These architectures vary from the independent and physical business unit centric data marts to the centralised two-tier hub-and-spoke data warehouse. The operational data store is a third tier which was offered later to address the business requirements for inter-day data loading. While the industry-available architectures are all valid, I found them to be suboptimal in efficiency (cost) and effectiveness (productivity). In this dissertation, I am advocating a new architecture (The Hybrid Architecture) which encompasses the industry advocated architecture. The hybrid architecture demands the acquisition, loading and consolidation of enterprise atomic and detailed data into a single integrated enterprise data store (The Enterprise Data Warehouse) where businessunit centric Data Marts and Operational Data Stores (ODS) are built in the same instance of the Enterprise Data Warehouse. For the purpose of highlighting the role of data warehouses for different applications, we describe an effort to develop a data warehouse for a geographical information system (GIS). We further study the importance of data practices, quality and governance for financial institutions by commenting on the RBC Financial Group case. v The development and deployment of the Enterprise Data Warehouse based on the Hybrid Architecture spawned its own issues and challenges. Organic data growth and business requirements to load additional new data significantly will increase the amount of stored data. Consequently, the number of users will increase significantly. Enterprise data warehouse obesity, performance degradation and navigation difficulties are chief amongst the issues and challenges. Association rules mining and social networks have been adopted in this thesis to address the above mentioned issues and challenges. We describe an approach that uses frequent pattern mining and social network techniques to discover different communities within the data warehouse. These communities include sets of tables frequently accessed together, sets of tables retrieved together most of the time and sets of attributes that mostly appear together in the queries. We concentrate on tables in the discussion; however, the model is general enough to discover other communities. We first build a frequent pattern mining model by considering each query as a transaction and the tables as items. Then, we mine closed frequent itemsets of tables; these itemsets include tables that are mostly accessed together and hence should be treated as one unit in…
Subjects/Keywords: 005.3; Data warehouse architectures; Data repository; RBC Financial Group; Case study; Enterprise Data Warehouse; Data mining; Social networking; Communities
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Rifaie, M. (2010). Strategy and methodology for enterprise data warehouse development : integrating data mining and social networking techniques for identifying different communities within the data warehouse. (Doctoral Dissertation). University of Bradford. Retrieved from http://hdl.handle.net/10454/4416
Chicago Manual of Style (16th Edition):
Rifaie, Mohammad. “Strategy and methodology for enterprise data warehouse development : integrating data mining and social networking techniques for identifying different communities within the data warehouse.” 2010. Doctoral Dissertation, University of Bradford. Accessed March 23, 2019.
http://hdl.handle.net/10454/4416.
MLA Handbook (7th Edition):
Rifaie, Mohammad. “Strategy and methodology for enterprise data warehouse development : integrating data mining and social networking techniques for identifying different communities within the data warehouse.” 2010. Web. 23 Mar 2019.
Vancouver:
Rifaie M. Strategy and methodology for enterprise data warehouse development : integrating data mining and social networking techniques for identifying different communities within the data warehouse. [Internet] [Doctoral dissertation]. University of Bradford; 2010. [cited 2019 Mar 23].
Available from: http://hdl.handle.net/10454/4416.
Council of Science Editors:
Rifaie M. Strategy and methodology for enterprise data warehouse development : integrating data mining and social networking techniques for identifying different communities within the data warehouse. [Doctoral Dissertation]. University of Bradford; 2010. Available from: http://hdl.handle.net/10454/4416
University of Illinois – Urbana-Champaign
29.
Kim, Yong-Bin.
Database support for top-down proteomics.
Degree: PhD, 0112, 2010, University of Illinois – Urbana-Champaign
URL: http://hdl.handle.net/2142/16720
► Top-down proteomics is a revolutionary application for the identification and characterization of protein, known to be one of the most complicated and challenging issues in…
(more)
▼ Top-down proteomics is a revolutionary application for the identification and characterization of protein, known to be one of the most complicated and challenging issues in biology. In top-down proteomics, the quality and speed of the
data warehouse is very important, as high accuracy results are returned by a database search. ProSight
Warehouse fills the critical role as the
data warehouse for ProSight PTM, the first publicly available top-down proteomics software suite. MySQL, a free relational database, was the base of this
warehouse. Many annotated and predicted protein forms have been successfully incorporated into the organism-specific database and in the integrated database for human strains. To achieve high quality and efficiency, a database schema (Absolute Mass Search),
data annotation methods (Shotgun and Extended Shotgun Annotation),
data population strategies (on-the-fly population, bulk-loading method), and a database integration methodology for human protein were developed. With the successful implementation of ProSight
Warehouse, ProSight PTM achieved its aspiration, highly accurate protein identification and characterization.
Advisors/Committee Members: Belford, Geneva G. (advisor), Belford, Geneva G. (Committee Chair), Kelleher, Neil L. (committee member), Han, Jiawei (committee member), Zhai, ChengXiang (committee member).
Subjects/Keywords: Top-down proteomics; Database support for proteomics; Prosight PTM; Prosight Warehouse; Biological warehouse integration; Data warehouse
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Kim, Y. (2010). Database support for top-down proteomics. (Doctoral Dissertation). University of Illinois – Urbana-Champaign. Retrieved from http://hdl.handle.net/2142/16720
Chicago Manual of Style (16th Edition):
Kim, Yong-Bin. “Database support for top-down proteomics.” 2010. Doctoral Dissertation, University of Illinois – Urbana-Champaign. Accessed March 23, 2019.
http://hdl.handle.net/2142/16720.
MLA Handbook (7th Edition):
Kim, Yong-Bin. “Database support for top-down proteomics.” 2010. Web. 23 Mar 2019.
Vancouver:
Kim Y. Database support for top-down proteomics. [Internet] [Doctoral dissertation]. University of Illinois – Urbana-Champaign; 2010. [cited 2019 Mar 23].
Available from: http://hdl.handle.net/2142/16720.
Council of Science Editors:
Kim Y. Database support for top-down proteomics. [Doctoral Dissertation]. University of Illinois – Urbana-Champaign; 2010. Available from: http://hdl.handle.net/2142/16720
30.
Ruggiero Júnior, Waldemar.
Data Warehouse utilizando processamento paralelo em ambiente distribuído.
Degree: Mestrado, Sistemas Digitais, 2007, University of São Paulo
URL: http://www.teses.usp.br/teses/disponiveis/3/3141/tde-09012008-093830/
;
► Esse trabalho propõe uma solução de um Data Warehouse distribuído para implementação de um sistema de CRM, Customer Relationship Management, com o objetivo de uso…
(more)
▼ Esse trabalho propõe uma solução de um Data Warehouse distribuído para implementação de um sistema de CRM, Customer Relationship Management, com o objetivo de uso no ambiente bancário possibilitando que ações de relacionamento com clientes sejam planejadas e implementadas. É proposta uma arquitetura para implementação de um Data Warehouse em ambiente distribuído, utilizando programação paralela. Com o aumento no volume de dados armazenados nos Data Warehouse, as arquiteturas tradicionais exigem processadores e sistemas de entrada e saída cada vez mais robustos em termos de desempenho. Isso fica mais bem caracterizado quando são executadas procuras complexas (Ad hoc). A utilização de ambientes distribuídos em conjunto com programação paralela é uma alternativa para redução de custo e aumento de desempenho. É apresentada, aqui, uma proposta de arquitetura de Data Warehouse distribuído, integrado ao uso de programação paralela.
This lecture proposes a solution for Data Warehouse in an distributed environment for implementation of a CRM, Customer Relationship Management in a banking system. It\'s possible to create, plan and implement relationship actions with clients. Architecture is proposed for implementation of a Data Warehouse in a distributed environment, using parallel programming. With the increase of volume of data stored in Data Warehouse, the traditional architectures needs high performance in terms of processors and input and output systems. This kind of problem is well characterized when high complex queries (Ad hoc) is performed. Using distributed environment, together with parallel programming is a good choice to increase the performance and reduce cost. It\'s presented, here, a proposal for architecture of distributed Data Warehouse, integrated with the use of parallel programming.
Advisors/Committee Members: Sato, Liria Matsumoto.
Subjects/Keywords: Banco de dados; Customer relationship management; Data bases; Data Warehouse; Data Warehouse; Parallel programming; Programação paralela
Record Details
Similar Records
Cite
Share »
Record Details
Similar Records
Cite
« Share
❌
APA ·
Chicago ·
MLA ·
Vancouver ·
CSE |
Export
to Zotero / EndNote / Reference
Manager
APA (6th Edition):
Ruggiero Júnior, W. (2007). Data Warehouse utilizando processamento paralelo em ambiente distribuído. (Masters Thesis). University of São Paulo. Retrieved from http://www.teses.usp.br/teses/disponiveis/3/3141/tde-09012008-093830/ ;
Chicago Manual of Style (16th Edition):
Ruggiero Júnior, Waldemar. “Data Warehouse utilizando processamento paralelo em ambiente distribuído.” 2007. Masters Thesis, University of São Paulo. Accessed March 23, 2019.
http://www.teses.usp.br/teses/disponiveis/3/3141/tde-09012008-093830/ ;.
MLA Handbook (7th Edition):
Ruggiero Júnior, Waldemar. “Data Warehouse utilizando processamento paralelo em ambiente distribuído.” 2007. Web. 23 Mar 2019.
Vancouver:
Ruggiero Júnior W. Data Warehouse utilizando processamento paralelo em ambiente distribuído. [Internet] [Masters thesis]. University of São Paulo; 2007. [cited 2019 Mar 23].
Available from: http://www.teses.usp.br/teses/disponiveis/3/3141/tde-09012008-093830/ ;.
Council of Science Editors:
Ruggiero Júnior W. Data Warehouse utilizando processamento paralelo em ambiente distribuído. [Masters Thesis]. University of São Paulo; 2007. Available from: http://www.teses.usp.br/teses/disponiveis/3/3141/tde-09012008-093830/ ;
◁ [1] [2] [3] [4] [5] … [13] ▶
. 
Open Access Theses and Dissertations