Dissertations / Theses: 'Warehouses Design'

1

Romero, Moral Óscar. "Automating the multidimensional design of data warehouses." Doctoral thesis, Universitat Politècnica de Catalunya, 2010. http://hdl.handle.net/10803/6670.

Full text

Abstract:

Les experiències prèvies en l'àmbit dels magatzems de dades (o data warehouse), mostren que l'esquema multidimensional del data warehouse ha de ser fruit d'un enfocament híbrid; això és, una proposta que consideri tant els requeriments d'usuari com les fonts de dades durant el procés de disseny.
Com a qualsevol altre sistema, els requeriments són necessaris per garantir que el sistema desenvolupat satisfà les necessitats de l'usuari. A més, essent aquest un procés de reenginyeria, les fonts de dades s'han de tenir en compte per: (i) garantir que el magatzem de dades resultant pot ésser poblat amb dades de l'organització, i, a més, (ii) descobrir capacitats d'anàlisis no evidents o no conegudes per l'usuari.

Actualment, a la literatura s'han presentat diversos mètodes per donar suport al procés de modelatge del magatzem de dades. No obstant això, les propostes basades en un anàlisi dels requeriments assumeixen que aquestos són exhaustius, i no consideren que pot haver-hi informació rellevant amagada a les fonts de dades. Contràriament, les propostes basades en un anàlisi exhaustiu de les fonts de dades maximitzen aquest enfocament, i proposen tot el coneixement multidimensional que es pot derivar des de les fonts de dades i, conseqüentment, generen massa resultats. En aquest escenari, l'automatització del disseny del magatzem de dades és essencial per evitar que tot el pes de la tasca recaigui en el dissenyador (d'aquesta forma, no hem de confiar únicament en la seva habilitat i coneixement per aplicar el mètode de disseny elegit). A més, l'automatització de la tasca allibera al dissenyador del sempre complex i costós anàlisi de les fonts de dades (que pot arribar a ser inviable per grans fonts de dades).
Avui dia, els mètodes automatitzables analitzen en detall les fonts de dades i passen per alt els requeriments. En canvi, els mètodes basats en l'anàlisi dels requeriments no consideren l'automatització del procés, ja que treballen amb requeriments expressats en llenguatges d'alt nivell que un ordenador no pot manegar. Aquesta mateixa situació es dona en els mètodes híbrids actual, que proposen un enfocament seqüencial, on l'anàlisi de les dades es complementa amb l'anàlisi dels requeriments, ja que totes dues tasques pateixen els mateixos problemes que els enfocament purs.

En aquesta tesi proposem dos mètodes per donar suport a la tasca de modelatge del magatzem de dades: MDBE (Multidimensional Design Based on Examples) and AMDO (Automating the Multidimensional Design from Ontologies). Totes dues consideren els requeriments i les fonts de dades per portar a terme la tasca de modelatge i a més, van ser pensades per superar les limitacions dels enfocaments actuals.

1. MDBE segueix un enfocament clàssic, en el que els requeriments d'usuari són coneguts d'avantmà. Aquest mètode es beneficia del coneixement capturat a les fonts de dades, però guia el procés des dels requeriments i, conseqüentment, és capaç de treballar sobre fonts de dades semànticament pobres. És a dir, explotant el fet que amb uns requeriments de qualitat, podem superar els inconvenients de disposar de fonts de dades que no capturen apropiadament el nostre domini de treball.
2. A diferència d'MDBE, AMDO assumeix un escenari on es disposa de fonts de dades semànticament riques. Per aquest motiu, dirigeix el procés de modelatge des de les fonts de dades, i empra els requeriments per donar forma i adaptar els resultats generats a les necessitats de l'usuari. En aquest context, a diferència de l'anterior, unes fonts de dades semànticament riques esmorteeixen el fet de no tenir clars els requeriments d'usuari d'avantmà.

Cal notar que els nostres mètodes estableixen un marc de treball combinat que es pot emprar per decidir, donat un escenari concret, quin enfocament és més adient. Per exemple, no es pot seguir el mateix enfocament en un escenari on els requeriments són ben coneguts d'avantmà i en un escenari on aquestos encara no estan clars (un cas recorrent d'aquesta situació és quan l'usuari no té clares les capacitats d'anàlisi del seu propi sistema). De fet, disposar d'uns bons requeriments d'avantmà esmorteeix la necessitat de disposar de fonts de dades semànticament riques, mentre que a l'inversa, si disposem de fonts de dades que capturen adequadament el nostre domini de treball, els requeriments no són necessaris d'avantmà. Per aquests motius, en aquesta tesi aportem un marc de treball combinat que cobreix tots els possibles escenaris que podem trobar durant la tasca de modelatge del magatzem de dades.
Previous experiences in the data warehouse field have shown that the data warehouse multidimensional conceptual schema must be derived from a hybrid approach: i.e., by considering both the end-user requirements and the data sources, as first-class citizens. Like in any other system, requirements guarantee that the system devised meets the end-user necessities. In addition, since the data warehouse design task is a reengineering process, it must consider the underlying data sources of the organization: (i) to guarantee that the data warehouse must be populated from data available within the organization, and (ii) to allow the end-user discover unknown additional analysis capabilities.

Currently, several methods for supporting the data warehouse modeling task have been provided. However, they suffer from some significant drawbacks. In short, requirement-driven approaches assume that requirements are exhaustive (and therefore, do not consider the data sources to contain alternative interesting evidences of analysis), whereas data-driven approaches (i.e., those leading the design task from a thorough analysis of the data sources) rely on discovering as much multidimensional knowledge as possible from the data sources. As a consequence, data-driven approaches generate too many results, which mislead the user. Furthermore, the design task automation is essential in this scenario, as it removes the dependency on an expert's ability to properly apply the method chosen, and the need to analyze the data sources, which is a tedious and timeconsuming task (which can be unfeasible when working with large databases). In this sense, current automatable methods follow a data-driven approach, whereas current requirement-driven approaches overlook the process automation, since they tend to work with requirements at a high level of abstraction. Indeed, this scenario is repeated regarding data-driven and requirement-driven stages within current hybrid approaches, which suffer from the same drawbacks than pure data-driven or requirement-driven approaches.
In this thesis we introduce two different approaches for automating the multidimensional design of the data warehouse: MDBE (Multidimensional Design Based on Examples) and AMDO (Automating the Multidimensional Design from Ontologies). Both approaches were devised to overcome the limitations from which current approaches suffer. Importantly, our approaches consider opposite initial assumptions, but both consider the end-user requirements and the data sources as first-class citizens.

1. MDBE follows a classical approach, in which the end-user requirements are well-known beforehand. This approach benefits from the knowledge captured in the data sources, but guides the design task according to requirements and consequently, it is able to work and handle semantically poorer data sources. In other words, providing high-quality end-user requirements, we can guide the process from the knowledge they contain, and overcome the fact of disposing of bad quality (from a semantical point of view) data sources.
2. AMDO, as counterpart, assumes a scenario in which the data sources available are semantically richer. Thus, the approach proposed is guided by a thorough analysis of the data sources, which is properly adapted to shape the output result according to the end-user requirements. In this context, disposing of high-quality data sources, we can overcome the fact of lacking of expressive end-user requirements.

Importantly, our methods establish a combined and comprehensive framework that can be used to decide, according to the inputs provided in each scenario, which is the best approach to follow. For example, we cannot follow the same approach in a scenario where the end-user requirements are clear and well-known, and in a scenario in which the end-user requirements are not evident or cannot be easily elicited (e.g., this may happen when the users are not aware of the analysis capabilities of their own sources). Interestingly, the need to dispose of requirements beforehand is smoothed by the fact of having semantically rich data sources. In lack of that, requirements gain relevance to extract the multidimensional knowledge from the sources.
So that, we claim to provide two approaches whose combination turns up to be exhaustive with regard to the scenarios discussed in the literature

APA, Harvard, Vancouver, ISO, and other styles

2

Romero, Moral Oscar. "Automating the multidimensional design of data warehouses." Doctoral thesis, Universitat Politècnica de Catalunya, 2010. http://hdl.handle.net/10803/6670.

Full text

Abstract:

Les experiències prèvies en l'àmbit dels magatzems de dades (o data warehouse), mostren que l'esquema multidimensional del data warehouse ha de ser fruit d'un enfocament híbrid; això és, una proposta que consideri tant els requeriments d'usuari com les fonts de dades durant el procés de disseny.Com a qualsevol altre sistema, els requeriments són necessaris per garantir que el sistema desenvolupat satisfà les necessitats de l'usuari. A més, essent aquest un procés de reenginyeria, les fonts de dades s'han de tenir en compte per: (i) garantir que el magatzem de dades resultant pot ésser poblat amb dades de l'organització, i, a més, (ii) descobrir capacitats d'anàlisis no evidents o no conegudes per l'usuari.Actualment, a la literatura s'han presentat diversos mètodes per donar suport al procés de modelatge del magatzem de dades. No obstant això, les propostes basades en un anàlisi dels requeriments assumeixen que aquestos són exhaustius, i no consideren que pot haver-hi informació rellevant amagada a les fonts de dades. Contràriament, les propostes basades en un anàlisi exhaustiu de les fonts de dades maximitzen aquest enfocament, i proposen tot el coneixement multidimensional que es pot derivar des de les fonts de dades i, conseqüentment, generen massa resultats. En aquest escenari, l'automatització del disseny del magatzem de dades és essencial per evitar que tot el pes de la tasca recaigui en el dissenyador (d'aquesta forma, no hem de confiar únicament en la seva habilitat i coneixement per aplicar el mètode de disseny elegit). A més, l'automatització de la tasca allibera al dissenyador del sempre complex i costós anàlisi de les fonts de dades (que pot arribar a ser inviable per grans fonts de dades).Avui dia, els mètodes automatitzables analitzen en detall les fonts de dades i passen per alt els requeriments. En canvi, els mètodes basats en l'anàlisi dels requeriments no consideren l'automatització del procés, ja que treballen amb requeriments expressats en llenguatges d'alt nivell que un ordenador no pot manegar. Aquesta mateixa situació es dona en els mètodes híbrids actual, que proposen un enfocament seqüencial, on l'anàlisi de les dades es complementa amb l'anàlisi dels requeriments, ja que totes dues tasques pateixen els mateixos problemes que els enfocament purs.En aquesta tesi proposem dos mètodes per donar suport a la tasca de modelatge del magatzem de dades: MDBE (Multidimensional Design Based on Examples) and AMDO (Automating the Multidimensional Design from Ontologies). Totes dues consideren els requeriments i les fonts de dades per portar a terme la tasca de modelatge i a més, van ser pensades per superar les limitacions dels enfocaments actuals.1. MDBE segueix un enfocament clàssic, en el que els requeriments d'usuari són coneguts d'avantmà. Aquest mètode es beneficia del coneixement capturat a les fonts de dades, però guia el procés des dels requeriments i, conseqüentment, és capaç de treballar sobre fonts de dades semànticament pobres. És a dir, explotant el fet que amb uns requeriments de qualitat, podem superar els inconvenients de disposar de fonts de dades que no capturen apropiadament el nostre domini de treball.2. A diferència d'MDBE, AMDO assumeix un escenari on es disposa de fonts de dades semànticament riques. Per aquest motiu, dirigeix el procés de modelatge des de les fonts de dades, i empra els requeriments per donar forma i adaptar els resultats generats a les necessitats de l'usuari. En aquest context, a diferència de l'anterior, unes fonts de dades semànticament riques esmorteeixen el fet de no tenir clars els requeriments d'usuari d'avantmà.Cal notar que els nostres mètodes estableixen un marc de treball combinat que es pot emprar per decidir, donat un escenari concret, quin enfocament és més adient. Per exemple, no es pot seguir el mateix enfocament en un escenari on els requeriments són ben coneguts d'avantmà i en un escenari on aquestos encara no estan clars (un cas recorrent d'aquesta situació és quan l'usuari no té clares les capacitats d'anàlisi del seu propi sistema). De fet, disposar d'uns bons requeriments d'avantmà esmorteeix la necessitat de disposar de fonts de dades semànticament riques, mentre que a l'inversa, si disposem de fonts de dades que capturen adequadament el nostre domini de treball, els requeriments no són necessaris d'avantmà. Per aquests motius, en aquesta tesi aportem un marc de treball combinat que cobreix tots els possibles escenaris que podem trobar durant la tasca de modelatge del magatzem de dades.
Previous experiences in the data warehouse field have shown that the data warehouse multidimensional conceptual schema must be derived from a hybrid approach: i.e., by considering both the end-user requirements and the data sources, as first-class citizens. Like in any other system, requirements guarantee that the system devised meets the end-user necessities. In addition, since the data warehouse design task is a reengineering process, it must consider the underlying data sources of the organization: (i) to guarantee that the data warehouse must be populated from data available within the organization, and (ii) to allow the end-user discover unknown additional analysis capabilities.Currently, several methods for supporting the data warehouse modeling task have been provided. However, they suffer from some significant drawbacks. In short, requirement-driven approaches assume that requirements are exhaustive (and therefore, do not consider the data sources to contain alternative interesting evidences of analysis), whereas data-driven approaches (i.e., those leading the design task from a thorough analysis of the data sources) rely on discovering as much multidimensional knowledge as possible from the data sources. As a consequence, data-driven approaches generate too many results, which mislead the user. Furthermore, the design task automation is essential in this scenario, as it removes the dependency on an expert's ability to properly apply the method chosen, and the need to analyze the data sources, which is a tedious and timeconsuming task (which can be unfeasible when working with large databases). In this sense, current automatable methods follow a data-driven approach, whereas current requirement-driven approaches overlook the process automation, since they tend to work with requirements at a high level of abstraction. Indeed, this scenario is repeated regarding data-driven and requirement-driven stages within current hybrid approaches, which suffer from the same drawbacks than pure data-driven or requirement-driven approaches.In this thesis we introduce two different approaches for automating the multidimensional design of the data warehouse: MDBE (Multidimensional Design Based on Examples) and AMDO (Automating the Multidimensional Design from Ontologies). Both approaches were devised to overcome the limitations from which current approaches suffer. Importantly, our approaches consider opposite initial assumptions, but both consider the end-user requirements and the data sources as first-class citizens.1. MDBE follows a classical approach, in which the end-user requirements are well-known beforehand. This approach benefits from the knowledge captured in the data sources, but guides the design task according to requirements and consequently, it is able to work and handle semantically poorer data sources. In other words, providing high-quality end-user requirements, we can guide the process from the knowledge they contain, and overcome the fact of disposing of bad quality (from a semantical point of view) data sources.2. AMDO, as counterpart, assumes a scenario in which the data sources available are semantically richer. Thus, the approach proposed is guided by a thorough analysis of the data sources, which is properly adapted to shape the output result according to the end-user requirements. In this context, disposing of high-quality data sources, we can overcome the fact of lacking of expressive end-user requirements.Importantly, our methods establish a combined and comprehensive framework that can be used to decide, according to the inputs provided in each scenario, which is the best approach to follow. For example, we cannot follow the same approach in a scenario where the end-user requirements are clear and well-known, and in a scenario in which the end-user requirements are not evident or cannot be easily elicited (e.g., this may happen when the users are not aware of the analysis capabilities of their own sources). Interestingly, the need to dispose of requirements beforehand is smoothed by the fact of having semantically rich data sources. In lack of that, requirements gain relevance to extract the multidimensional knowledge from the sources.So that, we claim to provide two approaches whose combination turns up to be exhaustive with regard to the scenarios discussed in the literature

APA, Harvard, Vancouver, ISO, and other styles

3

Jürgens, Marcus. "Index structures for data warehouses /." Berlin [u.a.] : Springer, 2002. http://www.loc.gov/catdir/enhancements/fy0817/2002021075-d.html.

Full text

APA, Harvard, Vancouver, ISO, and other styles

4

Siqueira, Thiago Luís Lopes. "The design of vague spatial data warehouses." Universidade Federal de São Carlos, 2015. https://repositorio.ufscar.br/handle/ufscar/298.

Full text

Abstract:

Made available in DSpace on 2016-06-02T19:04:00Z (GMT). No. of bitstreams: 1 6824.pdf: 22060515 bytes, checksum: bde19feb7a6e296214aebe081f2d09de (MD5) Previous issue date: 2015-12-07
Universidade Federal de Minas Gerais
O data warehouse espacial (DWE) é um banco de dados multidimensional integrado e volumoso que armazena dados espaciais e dados convencionais. Já o processamento analítico espacial online (SOLAP) permite consultar o DWE, tanto pela seleção de dados espaciais que satisfazem um relacionamento topológico, quanto pela agregação dos dados espaciais. Deste modo, DWE e SOLAP beneficiam o suporte a tomada de decisão. As aplicações de DWE e SOLAP abordam majoritarimente fenômenos representados por dados espaciais exatos, ou seja, que assumem localizações e fronteiras bem definidas. Contudo, tais aplicações negligenciam dados espaciais afetados por imperfeições, tais como a vagueza espacial, a qual interfere na identificação precisa de um objeto e de seus vizinhos. Um objeto espacial vago não tem sua fronteira ou seu interior precisamente definidos. Além disso, é composto por partes que certamente pertencem a ele e partes que possivelmente pertencem a ele. Apesar de inúmeros fenômenos do mundo real serem caracterizados pela vagueza espacial, na literatura consultada não se identificaram trabalhos que considerassem a vagueza espacial no projeto de DWE e nem para consultar o DWE. Tal limitação motivou a elaboração desta tese de doutorado, a qual introduz os conceitos de DWE vago e de SOLAP vago. Um DWE vago é um DWE que armazena dados espaciais vagos, enquanto que SOLAP vago provê os meios para consultar o DWE vago. Nesta tese, o projeto de DWE vago é abordado e as principais contribuições providas são: (i) o modelo conceitual VSCube que viabiliza a criação de um cubos de dados multidimensional para representar o esquema conceitual de um DWE vago; (ii) o modelo conceitual VSMultiDim que permite criar um diagrama para representar o esquema conceitual de um DWE vago; (iii) diretrizes para o projeto lógico do DWE vago e de suas restrições de integridade, e para estender a linguagem SQL visando processar as consultas de SOLAP vago no DWE vago; e (iv) o índice VSB-index que aprimora o desempenho do processamento de consultas no DWE vago. A aplicabilidade dessas contribuições é demonstrada em dois estudos de caso no domínio da agricultura, por meio da criação de esquemas conceituais de DWE vago, da transformação dos esquemas conceituais em esquemas lógicos de DWE vago, e do processamento de consultas envolvendo as regiões vagas do DWE vago.
Spatial data warehouses (SDW) and spatial online analytical processing (SOLAP) enhance decision making by enabling spatial analysis combined with multidimensional analytical queries. A SDW is an integrated and voluminous multidimensional database containing both conventional and spatial data. SOLAP allows querying SDWs with multidimensional queries that select spatial data that satisfy a given topological relationship and that aggregate spatial data. Existing SDW and SOLAP applications mostly consider phenomena represented by spatial data having exact locations and sharp boundaries. They neglect the fact that spatial data may be affected by imperfections, such as spatial vagueness, which prevents distinguishing an object from its neighborhood. A vague spatial object does not have a precisely defined boundary and/or interior. Thus, it may have a broad boundary and a blurred interior, and is composed of parts that certainly belong to it and parts that possibly belong to it. Although several real-world phenomena are characterized by spatial vagueness, no approach in the literature addresses both spatial vagueness and the design of SDWs nor provides multidimensional analysis over vague spatial data. These shortcomings motivated the elaboration of this doctoral thesis, which addresses both vague spatial data warehouses (vague SDWs) and vague spatial online analytical processing (vague SOLAP). A vague SDW is a SDW that comprises vague spatial data, while vague SOLAP allows querying vague SDWs. The major contributions of this doctoral thesis are: (i) the Vague Spatial Cube (VSCube) conceptual model, which enables the creation of conceptual schemata for vague SDWs using data cubes; (ii) the Vague Spatial MultiDim (VSMultiDim) conceptual model, which enables the creation of conceptual schemata for vague SDWs using diagrams; (iii) guidelines for designing relational schemata and integrity constraints for vague SDWs, and for extending the SQL language to enable vague SOLAP; (iv) the Vague Spatial Bitmap Index (VSB-index), which improves the performance to process queries against vague SDWs. The applicability of these contributions is demonstrated in two applications of the agricultural domain, by creating conceptual schemata for vague SDWs, transforming these conceptual schemata into logical schemata for vague SDWs, and efficiently processing queries over vague SDWs.

APA, Harvard, Vancouver, ISO, and other styles

5

Lopes, Siqueira Thiago Luis. "The Design of Vague Spatial Data Warehouses." Doctoral thesis, Universite Libre de Bruxelles, 2015. http://hdl.handle.net/2013/ULB-DIPOT:oai:dipot.ulb.ac.be:2013/221701.

Full text

Abstract:

Spatial data warehouses (SDW) and spatial online analytical processing (SOLAP) enhance decision making by enabling spatial analysis combined with multidimensional analytical queries. A SDW is an integrated and voluminous multidimensional database containing both conventional and spatial data. SOLAP allows querying SDWs with multidimensional queries that select spatial data that satisfy a given topological relationship and that aggregate spatial data. Existing SDW and SOLAP applications mostly consider phenomena represented by spatial data having exact locations and sharp boundaries. They neglect the fact that spatial data may be affected by imperfections, such as spatial vagueness, which prevents distinguishing an object from its neighborhood. A vague spatial object does not have a precisely defined boundary and/or interior. Thus, it may have a broad boundary and a blurred interior, and is composed of parts that certainly belong to it and parts that possibly belong to it. Although several real-world phenomena are characterized by spatial vagueness, no approach in the literature addresses both spatial vagueness and the design of SDWs nor provides multidimensional analysis over vague spatial data. These shortcomings motivated the elaboration of this doctoral thesis, which addresses both vague spatial data warehouses (vague SDWs) and vague spatial online analytical processing (vague SOLAP). A vague SDW is a SDW that comprises vague spatial data, while vague SOLAP allows querying vague SDWs. The major contributions of this doctoral thesis are: (i) the Vague Spatial Cube (VSCube) conceptual model, which enables the creation of conceptual schemata for vague SDWs using data cubes; (ii) the Vague Spatial MultiDim (VSMultiDim) conceptual model, which enables the creation of conceptual schemata for vague SDWs using diagrams; (iii) guidelines for designing relational schemata and integrity constraints for vague SDWs, and for extending the SQL language to enable vague SOLAP; (iv) the Vague Spatial Bitmap Index (VSB-index), which improves the performance to process queries against vague SDWs. The applicability of these contributions is demonstrated in two applications of the agricultural domain, by creating conceptual schemata for vague SDWs, transforming these conceptual schemata into logical schemata for vague SDWs, and efficiently processing queries over vague SDWs.
Les entrepôts de données spatiales (EDS) et l'analyse en ligne spatiale (ALS) améliorent la prise de décision en permettant l'analyse spatiale combinée avec des requêtes analytiques multidimensionnelles. Un EDS est une base de données multidimensionnelle intégrée et volumineuse qui contient des données classiques et des données spatiales. L'ALS permet l'interrogation des EDS avec des requêtes multidimensionnelles qui sélectionnent des données spatiales qui satisfont une relation topologique donnée et qui agrègent les données spatiales. Les EDS et l'ALS considèrent essentiellement des phénomènes représentés par des données spatiales ayant une localisation exacte et des frontières précises. Ils négligent que les données spatiales peuvent être affectées par des imperfections, comme l'imprécision spatiale, ce qui empêche de distinguer précisément un objet de son entourage. Un objet spatial vague n'a pas de frontière et/ou un intérieur précisément définis. Ainsi, il peut avoir une frontière large et un intérieur flou, et est composé de parties qui lui appartiennent certainement et des parties qui lui appartiennent éventuellement. Bien que plusieurs phénomènes du monde réel sont caractérisés par l'imprécision spatiale, il n'y a pas dans la littérature des approches qui adressent en même temps l'imprécision spatiale et la conception d'EDS ni qui fournissent une analyse multidimensionnelle des données spatiales vagues. Ces lacunes ont motivé l'élaboration de cette thèse de doctorat, qui adresse à la fois les entrepôts de données spatiales vagues (EDS vagues) et l'analyse en ligne spatiale vague (ALS vague). Un EDS vague est un EDS qui comprend des données spatiales vagues, tandis que l'ALS vague permet d'interroger des EDS vagues. Les contributions majeures de cette thèse de doctorat sont: (i) le modèle conceptuel Vague Spatial Cube (VSCube), qui permet la création de schémas conceptuels pour des EDS vagues à l'aide de cubes de données; (ii) le modèle conceptuel Vague Spatial MultiDim (VSMultiDim), qui permet la création de schémas conceptuels pour des EDS vagues à l'aide de diagrammes; (iii) des directives pour la conception de schémas relationnels et des contraintes d'intégrité pour des EDS vagues, et pour l'extension du langage SQL pour permettre l'ALS vague; (iv) l'indice Vague Spatial Bitmap (VSB-index) qui améliore la performance pour traiter les requêtes adressées à des EDS vagues. L'applicabilité de ces contributions est démontrée dans deux applications dans le domaine agricole, en créant des schémas conceptuels des EDS vagues, la transformation de ces schémas conceptuels en schémas logiques pour des EDS vagues, et le traitement efficace des requêtes sur des EDS vagues.
O data warehouse espacial (DWE) é um banco de dados multidimensional integrado e volumoso que armazena dados espaciais e dados convencionais. Já o processamento analítico-espacial online (SOLAP) permite consultar o DWE, tanto pela seleção de dados espaciais que satisfazem um relacionamento topológico, quanto pela agregação dos dados espaciais. Deste modo, DWE e SOLAP beneficiam o suporte a tomada de decisão. As aplicações de DWE e SOLAP abordam majoritarimente fenômenos representados por dados espaciais exatos, ou seja, que assumem localizações e fronteiras bem definidas. Contudo, tais aplicações negligenciam dados espaciais afetados por imperfeições, tais como a vagueza espacial, a qual interfere na identificação precisa de um objeto e de seus vizinhos. Um objeto espacial vago não tem sua fronteira ou seu interior precisamente definidos. Além disso, é composto por partes que certamente pertencem a ele e partes que possivelmente pertencem a ele. Apesar de inúmeros fenômenos do mundo real serem caracterizados pela vagueza espacial, na literatura consultada não se identificaram trabalhos que considerassem a vagueza espacial no projeto de DWE e nem para consultar o DWE. Tal limitação motivou a elaboração desta tese de doutorado, a qual introduz os conceitos de DWE vago e de SOLAP vago. Um DWE vago é um DWE que armazena dados espaciais vagos, enquanto que SOLAP vago provê os meios para consultar o DWE vago. Nesta tese, o projeto de DWE vago é abordado e as principais contribuições providas são: (i) o modelo conceitual VSCube que viabiliza a criação de um cubos de dados multidimensional para representar o esquema conceitual de um DWE vago; (ii) o modelo conceitual VSMultiDim que permite criar um diagrama para representar o esquema conceitual de um DWE vago; (iii) diretrizes para o projeto lógico do DWE vago e de suas restrições de integridade, e para estender a linguagem SQL visando processar as consultas de SOLAP vago no DWE vago; e (iv) o índice VSB-index que aprimora o desempenho do processamento de consultas no DWE vago. A aplicabilidade dessas contribuições é demonstrada em dois estudos de caso no domínio da agricultura, por meio da criação de esquemas conceituais de DWE vago, da transformação dos esquemas conceituais em esquemas lógicos de DWE vago, e do processamento de consultas envolvendo as regiões vagas do DWE vago.
Doctorat en Sciences de l'ingénieur et technologie
Location of the public defense: Universidade Federal de São Carlos, São Carlos, SP, Brazil.
info:eu-repo/semantics/nonPublished

APA, Harvard, Vancouver, ISO, and other styles

6

Dunkin, Ann Elizabeth. "Analysis and design of storage and retrieval systems for tote sized loads." Thesis, Georgia Institute of Technology, 1988. http://hdl.handle.net/1853/25525.

Full text

APA, Harvard, Vancouver, ISO, and other styles

7

Vetencourt, Stull Rolando Jose. "Re-design warehouse plant layout for a food company." Online version, 2004. http://www.uwstout.edu/lib/thesis/2004/2004vetencourtr.pdf.

Full text

APA, Harvard, Vancouver, ISO, and other styles

8

Zerangue, Natalie Frances. "Modeling expertise in the design of warehousing and distribution systems." Thesis, Georgia Institute of Technology, 2001. http://hdl.handle.net/1853/21737.

Full text

APA, Harvard, Vancouver, ISO, and other styles

9

Schilling, Benjamin Fritz. "Robotic vacuum cleaner design to mitigate slip errors in warehouses." Thesis, Massachusetts Institute of Technology, 2017. http://hdl.handle.net/1721.1/114052.

Full text

Abstract:

Thesis: M. Eng. in Advanced Manufacturing and Design, Massachusetts Institute of Technology, Department of Mechanical Engineering, 2017.
This electronic version was submitted by the student author. The certified thesis is available in the Institute Archives and Special Collections.
Cataloged from student-submitted PDF version of thesis.
Includes bibliographical references (pages 83-84).
Warehouses are extremely dusty environments due to the concrete and cardboard dust generated. This is problematic in automated warehouses that use robots to move items from one location to another. If the robot slips, it can collide with other robots or lose track of where it is located. Currently, to reduce the amount of dust on the floor, warehouses use industrial scrubbers that users walk behind or ride. This requires manual labor and a regular scheduled maintenance plan that needs to be followed to mitigate the dust accumulation. Therefore, an industrial robotic vacuum cleaner that can continuously clean the warehouse floors is proposed. The five key parts to a vacuum are inlet duct, brush roller, filtration, storage, and suction. This thesis will discuss in detail the design and development of the filtration, storage, and suction of the robotic vacuums that were developed in this project. The thesis will go through design considerations and computational fluid dynamics that were conducted to validate and improve the design. Then, it will discuss the experimental results of the robotic vacuum cleaners.
by Benjamin Fritz Schilling.
M. Eng. in Advanced Manufacturing and Design

APA, Harvard, Vancouver, ISO, and other styles

10

Veronica, Ruiz Castro Carla. "CSTM: a conceptual spatiotemporal model for data warehouses." Universidade Federal de Pernambuco, 2010. https://repositorio.ufpe.br/handle/123456789/2209.

Full text

Abstract:

Made available in DSpace on 2014-06-12T15:55:27Z (GMT). No. of bitstreams: 2 arquivo2237_1.pdf: 2502933 bytes, checksum: d37d2a43704ed90dc4402e107f41af53 (MD5) license.txt: 1748 bytes, checksum: 8a4605be74aa9ea9d79846c1fba20a33 (MD5) Previous issue date: 2010
Conselho Nacional de Desenvolvimento Científico e Tecnológico
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

APA, Harvard, Vancouver, ISO, and other styles

11

Yoon, Chang S. "A structured procedure for order pick system analysis and design." Diss., Georgia Institute of Technology, 1991. http://hdl.handle.net/1853/21708.

Full text

APA, Harvard, Vancouver, ISO, and other styles

12

Anderson, Rebecca. "Design and justification of an automated palletizing line." Online version, 2008. http://www.uwstout.edu/lib/thesis/2008/2008andersonr.pdf.

Full text

APA, Harvard, Vancouver, ISO, and other styles

13

Malinowski, Gajda Elzbieta. "Designing conventional, spatial, and temporal data warehouses: concepts and methodological framework." Doctoral thesis, Universite Libre de Bruxelles, 2006. http://hdl.handle.net/2013/ULB-DIPOT:oai:dipot.ulb.ac.be:2013/210837.

Full text

Abstract:

Decision support systems are interactive, computer-based information systems that provide data and analysis tools in order to better assist managers on different levels of organization in the process of decision making. Data warehouses (DWs) have been developed and deployed as an integral part of decision support systems.

A data warehouse is a database that allows to store high volume of historical data required for analytical purposes. This data is extracted from operational databases, transformed into a coherent whole, and loaded into a DW during the extraction-transformation-loading (ETL) process.

DW data can be dynamically manipulated using on-line analytical processing (OLAP) systems. DW and OLAP systems rely on a multidimensional model that includes measures, dimensions, and hierarchies. Measures are usually numeric additive values that are used for quantitative evaluation of different aspects about organization. Dimensions provide different analysis perspectives while hierarchies allow to analyze measures on different levels of detail.

Nevertheless, currently, designers as well as users find difficult to specify multidimensional elements required for analysis. One reason for that is the lack of conceptual models for DW and OLAP system design, which would allow to express data requirements on an abstract level without considering implementation details. Another problem is that many kinds of complex hierarchies arising in real-world situations are not addressed by current DW and OLAP systems.

In order to help designers to build conceptual models for decision-support systems and to help users in better understanding the data to be analyzed, in this thesis we propose the MultiDimER model - a conceptual model used for representing multidimensional data for DW and OLAP applications. Our model is mainly based on the existing ER constructs, for example, entity types, attributes, relationship types with their usual semantics, allowing to represent the common concepts of dimensions, hierarchies, and measures. It also includes a conceptual classification of different kinds of hierarchies existing in real-world situations and proposes graphical notations for them.

On the other hand, currently users of DW and OLAP systems demand also the inclusion of spatial data, visualization of which allows to reveal patterns that are difficult to discover otherwise. The advantage of using spatial data in the analysis process is widely recognized since it allows to reveal patterns that are difficult to discover otherwise.

However, although DWs typically include a spatial or a location dimension, this dimension is usually represented in an alphanumeric format. Furthermore, there is still a lack of a systematic study that analyze the inclusion as well as the management of hierarchies and measures that are represented using spatial data.

With the aim of satisfying the growing requirements of decision-making users, we extend the MultiDimER model by allowing to include spatial data in the different elements composing the multidimensional model. The novelty of our contribution lays in the fact that a multidimensional model is seldom used for representing spatial data. To succeed with our proposal, we applied the research achievements in the field of spatial databases to the specific features of a multidimensional model. The spatial extension of a multidimensional model raises several issues, to which we refer in this thesis, such as the influence of different topological relationships between spatial objects forming a hierarchy on the procedures required for measure aggregations, aggregations of spatial measures, the inclusion of spatial measures without the presence of spatial dimensions, among others.

Moreover, one of the important characteristics of multidimensional models is the presence of a time dimension for keeping track of changes in measures. However, this dimension cannot be used to model changes in other dimensions.

Therefore, usual multidimensional models are not symmetric in the way of representing changes for measures and dimensions. Further, there is still a lack of analysis indicating which concepts already developed for providing temporal support in conventional databases can be applied and be useful for different elements composing a multidimensional model.

In order to handle in a similar manner temporal changes to all elements of a multidimensional model, we introduce a temporal extension for the MultiDimER model. This extension is based on the research in the area of temporal databases, which have been successfully used for modeling time-varying information for several decades. We propose the inclusion of different temporal types, such as valid and transaction time, which are obtained from source systems, in addition to the DW loading time generated in DWs. We use this temporal support for a conceptual representation of time-varying dimensions, hierarchies, and measures. We also refer to specific constraints that should be imposed on time-varying hierarchies and to the problem of handling multiple time granularities between source systems and DWs.

Furthermore, the design of DWs is not an easy task. It requires to consider all phases from the requirements specification to the final implementation including the ETL process. It should also take into account that the inclusion of different data items in a DW depends on both, users' needs and data availability in source systems. However, currently, designers must rely on their experience due to the lack of a methodological framework that considers above-mentioned aspects.

In order to assist developers during the DW design process, we propose a methodology for the design of conventional, spatial, and temporal DWs. We refer to different phases, such as requirements specification, conceptual, logical, and physical modeling. We include three different methods for requirements specification depending on whether users, operational data sources, or both are the driving force in the process of requirement gathering. We show how each method leads to the creation of a conceptual multidimensional model. We also present logical and physical design phases that refer to DW structures and the ETL process.

To ensure the correctness of the proposed conceptual models, i.e. with conventional data, with the spatial data, and with time-varying data, we formally define them providing their syntax and semantics. With the aim of assessing the usability of our conceptual model including representation of different kinds of hierarchies as well as spatial and temporal support, we present real-world examples. Pursuing the goal that the proposed conceptual solutions can be implemented, we include their logical representations using relational and object-relational databases.

Doctorat en sciences appliquées
info:eu-repo/semantics/nonPublished

APA, Harvard, Vancouver, ISO, and other styles

14

Ma, Kai Michael. "Revitalization of urban industrial waterfront area : the redevelopment of Taikoo Warehouses area of Guangzhou /." View the Table of Contents & Abstract, 2009. http://sunzi.lib.hku.hk/hkuto/record/B42927547.

Full text

APA, Harvard, Vancouver, ISO, and other styles

15

Pudleiner, David Burl. "Using uncertainty and sensitivity analysis to inform the design of net-zero energy vaccine warehouses." Thesis, Georgia Institute of Technology, 2014. http://hdl.handle.net/1853/52232.

Full text

Abstract:

The vaccine cold chain is an integral part of the process of storing and distributing vaccines prior to administration. A key component of this cold chain for developing countries is the primary vaccine storage warehouse. As the starting point for the distribution of vaccines throughout the country, these buildings have a significant amount of refrigerated space and therefore consume large amounts of energy. Therefore, this thesis focuses on analyzing the relative importance of parameters for the design of an energy efficient primary vaccine storage warehouse with the end goal of achieving Net-Zero Energy operation. A total of 31 architectural design parameters, such as roof insulation U-Value and external wall thermal mass, along with 14 building control parameters, including evaporator coil defrost termination and thermostat set points, are examined. The analysis is conducted across five locations in the developing world with significant variations in climate conditions: Buenos Aires, Argentina; Tunis, Tunisia; Asuncion, Paraguay; Mombasa, Kenya; and Bangkok, Thailand. Variations in the parameters are examined through the implementation of a Monte Carlo-based global uncertainty and sensitivity analysis to a case study building layout. A regression-based sensitivity analysis is used to analyze both the main effects of each parameter as well as the interactions between parameter pairs. The results of this research indicate that for all climates examined, the building control parameters have a larger relative importance than the architectural design parameters in determining the warehouse energy consumption. This is due to the dominance of the most influential building control parameter examined, the Chilled Storage evaporator fan control strategy. The importance of building control parameters across all climates examined emphasizes the need for an integrated design method to ensure the delivery of an energy efficient primary vaccine warehouse.

APA, Harvard, Vancouver, ISO, and other styles

16

Mandke, Yashodhan Vikas. "Using Haptics and Vibro-Tactile Technology to Assist Hard-of-Hearing Warehouse Employees." Miami University / OhioLINK, 2018. http://rave.ohiolink.edu/etdc/view?acc_num=miami1524672552749124.

Full text

APA, Harvard, Vancouver, ISO, and other styles

17

Ma, Kai Michael, and 馬愷. "Revitalization of urban industrial waterfront area: the redevelopment of Taikoo Warehouses area ofGuangzhou." Thesis, The University of Hong Kong (Pokfulam, Hong Kong), 2009. http://hub.hku.hk/bib/B45009843.

Full text

APA, Harvard, Vancouver, ISO, and other styles

18

Khan, Muhammad Aqib. "Design and control of a robotic system based on mobile robots and manipulator arms for picking in logistics warehouses." Thesis, Normandie, 2020. http://www.theses.fr/2020NORMLH31.

Full text

Abstract:

La logistique consiste à stocker, déplacer et expédier des marchandises à des détaillants ou clients finaux tant en garantissant une gestion efficace des flux d’information sous-jacents. Les travaux menés durant cette thèse visent à automatiser le processus de préparation de commande sur palette en introduisant des robots manipulateurs mobiles dans les entrepôts logistiques, avec un double objectif : diminuer la pénibilité du travail et augmenter la productivité face à la croissance des volumes traités.Après un état de l’art exhaustif sur les robots manipulateurs mobiles, l’auteur met en œuvre un ensemble de procédés et processus afin de prélever des colis sur des palettes disposées sous des racks et cela en toute autonomie. Des blocs fonctionnels sont ainsi constitués pour réaliser l’ensemble des tâches pour la base mobile (cartographie, localisation, planification, navigation) ainsi que pour le bras manipulateur. Une disposition originale et inédite des capteurs sur le manipulateur mobile ainsi que la mise en place d’ARtag sur les éléments d’infrastructures permettent de récupérer des « smart data » plutôt que du « big data », permettant de conjuguer la complexité du problème avec les contraintes temps réel de l’application.Un algorithme de suivi d’un « mur virtuel » est proposé utilisant une transformée de Hough rendue plus robuste grâce à plusieurs niveaux de filtrage. La synchronisation et la commande de ces deux systèmes est assurée par des réseaux de Pétri. Enfin le prototype développé durant cette thèse CIFRE a été non seulement testé au laboratoire mais aussi dans les conditions réelles d’un entrepôt logistique
Logistics involves the storage and displacement of goods. These goods are stored in warehouses and shipped to retailers in pallets. Pallets are produced on a customer’s order. Order picking for a pallet is a fatigue induced process resulting in poor performance of the workers, decreasing the productivity and inducing delays in supply chain. Flexibility is introduced to increase productivity by commissioning robots for process automation. These robots consist of autonomous ground vehicles for transporting freight and static manipulators for pick and place. A static robot has limited workspace and the capability of a manipulator is significantly enhanced by adding a mobile base. Mobile manipulation is now being exploited for pick & place and pallet production. This thesis presents a first attempt to achieve autonomous palletization using mobile manipulation. To acquire palletization by mobile manipulation requires the identification of functional blocks, to conceive a framework to achieve this task. A thorough state of the art has been prepared in this thesis corresponding to each element of the global framework. To realize the proof of concept, a prototype has been developed by leveraging existing technologies, by integrating a mobile base with manipulator and a grasping system with a gripping element. For each functional block of the global framework, control execution strategies have been developed and tested in industrial environment. Specifically, localization is acquired by the use of synthetic landmarks, a motion planning and control strategy is employed for global navigation and a rack tracking motion control has been developed for moving inside the racks. To combine and execute all the elements without deadlocks a coordination framework is used as a global supervisor. The path planner for global navigation is based on the shortest distance between two points, and rack tracking is developed by applying the conventional Hough transform to the lidar data and using the output in a nonlinear controller, while the motion planner for manipulation is based on linear trajectories. The framework for supervisory control is based on discrete event systems topology and state machines corresponding to each element have been modelized using Petri nets. Finally, the framework has been tested for a complete picking task on the mobile manipulator to validate the selection of strategies and performance of each functional element. The successful demonstration has been concluded as a first step towards the evolution of autonomous palletization

APA, Harvard, Vancouver, ISO, and other styles

19

Habibulla, Murtuza. "Analyzing the performance of an order accumulation and sortation system using simulation a design of experiments approach." Ohio : Ohio University, 2001. http://www.ohiolink.edu/etd/view.cgi?ohiou1173895842.

Full text

APA, Harvard, Vancouver, ISO, and other styles

20

Mangotra, Divya. "Integrated Decisions for Supply Chain Design and Inventory Allocation Problem." Diss., Georgia Institute of Technology, 2007. http://hdl.handle.net/1853/19814.

Full text

Abstract:

Manufacturing outsourcing in the U.S. has never been stronger than it is today. Increased outsourcing has led to significant changes in the design of the retail distribution network. While the traditional distribution network had the manufacturing plants supplying goods to the retail stores directly, the off-shore manufacturing has increased the network's demand for transportation and warehousing to deliver the goods. Thus, most companies have a complex distribution network with several import and regional distribution centers (RDC). In this thesis, we study an integrated facility location and inventory allocation problem for designing a distribution network with multiple national (import) distribution centers (NDC) and retailers. The key decisions are where to locate the RDCs and how much inventory to hold at the different locations such that the total network cost is minimized under a pre-defined operational rule for the distribution of goods. In particular, the inventory cost analysis is based on the continuous review batch ordering policy and the base-stock policy. Both Type-I (probability of stock-outs) and Type-II (fill-rate) service level measures are used in the analysis. Two different models are presented in this thesis for solving the integrated facility location-inventory allocation problem. The first model, continuous approximation (CA), assumes the distribution network to be located in a continuous region and replaces the discrete store locations with a store density function. The second model is a discrete representation of the problem as a mixed integer programming problem. Both the models take a nonlinear form and solution techniques are developed using the theory of nonlinear programming and linear reformulation of nonlinear problems. The goal of the first part of the thesis is to model the problem using a modified CA approach and an iterative solution scheme is presented to solve it. The main contribution of this work lies in developing a refined CA modeling technique when the discrete data cannot be modeled by a continuous function. In addition, the numerical analysis suggests that the total network cost is significantly lower in the case of the integrated model as compared with the non-integrated model. It is also shown that the regular CA approach leads to a solution which is inferior to the solution obtained by the modified CA approach. Our analysis shows that the type of service measure used affects the network design. In the second part of the thesis, the problem is modeled as a nonlinear mixed integer program and a linear reformulation solution technique is proposed to obtain a lower bound on the original problem. Computational results are presented for small problem instances. We conclude this part of the thesis by presenting an integrated model when a base stock inventory policy is used. A drop-decomposition heuristic is proposed to solve this problem.

APA, Harvard, Vancouver, ISO, and other styles

21

Medin, Robin. "Gesture-Driven Interaction in Head-Mounted Display AR: Guidelines for Design Within the Context of the Order Picking Process in Logistic Warehouses." Thesis, Malmö universitet, Fakulteten för kultur och samhälle (KS), 2018. http://urn.kb.se/resolve?urn=urn:nbn:se:mau:diva-23677.

Full text

Abstract:

This thesis investigates how gesture-driven interfaces, integrated in HMD- based (Head-Mounted Display) Augmented Reality (AR) devices can be used in the context of order picking processes in logistic warehouses as a substitute to existing solutions for visualisation and interaction with order picking lists: which hand gestures should be used? What qualities are essential for designing a successful substitute? By applying an User-Centered Design approach, generative ideation methodologies, prototyping and usability testing this research results in a contribution to a framework of design guidelines for designing gesture-driven AR in the order picking process, as well as a proposition of a gestural interaction language grounded in both earlier research and empirical findings. The empirical findings include details of the end users’ gestural interaction preferences and content-related considerations, which was implemented in a low fidelity prototype and evaluated in the contextual domain of the end users.

APA, Harvard, Vancouver, ISO, and other styles

22

Cheok, Tuan Sun. "Design and implementation of a micro-computer based bar coding data collection system for improving warehouse information handling and cost control." Ohio : Ohio University, 1990. http://www.ohiolink.edu/etd/view.cgi?ohiou1183488025.

Full text

APA, Harvard, Vancouver, ISO, and other styles

23

Devis, Gallego Sergio. "Una metodología para el diseño estratégico de almacenes de reserva basada en la selección de tecnologías y políticas de gestión." Doctoral thesis, Universitat Politècnica de València, 2016. http://hdl.handle.net/10251/61444.

Full text

Abstract:

[EN] The objective pursued with this work has been to develop a methodology for designing storage systems, also offering the necessary mathematical tools for decision -making. It is for these reasons that this thesis has achieved the following purposes: 1- Define a series of steps in the design of storage systems. 2- In each of the steps, establish the criteria to be taken into account in making decisions that improve the design. 3- Determine the variables to consider and the relationship between these that defines the possible solutions reached, so that all possible combinations in the design of stores, some are discarded by physical impossibilities. 4- Develop mathematical tools such as experimental algorithm defined in this paper that allow the choice of the best possible solutions. 5- Determining procedures for verifying that the solution adopted corresponds to the objectives and followed the established restrictions. 6- Validate the methodology and experimental algorithm defined with the application to a real case study , which has helped define the best posible design constrainted to some objectives and real restrictions with the goal of satisfying the needs expressed . Thus, the gap in the literature related to the design of storage systems can be covered with the contribution made by this work that may enable those experts in this field, relying on the use of it to continue advancing in the complex world of designing storage systems.
[ES] El objetivo perseguido con el presente trabajo ha sido el de desarrollar una metodología de diseño de sistemas almacenamiento, ofreciendo igualmente las herramientas matemáticas necesarias para la toma de decisiones. Es por todo ello que con la presente tesis se han conseguido alcanzar los siguientes propósitos: 1- Definir una serie de pasos a seguir en el diseño de sistemas de almacenamiento. 2- En cada uno de los pasos descritos, establecer los criterios a tener a en cuenta para la toma de decisiones que permiten avanzar en el diseño del mismo. 3- Determinar las variables a tener en cuenta y como la relación entre estas mismas define las soluciones posibles alcanzadas, de forma que de todas las posibles combinaciones posibles en el diseño de almacenes, algunas se descartan por imposibilidades físicas. 4- Desarrollar herramientas matemáticas como el algoritmo de experimentación definido en el presente trabajo que permitan la elección de las mejores soluciones posibles. 5- Determinación de procedimientos de comprobación de que la solución adoptada corresponde con los objetivos perseguidos y se ajusta a las restricciones establecidas. 6- Validar la metodología y el algoritmo de experimentación definidos con la aplicación a un caso práctico real, que ha permitido definir el mejor diseño posible ajustado a unos objetivos y restricciones reales para satisfacer las necesidades planteadas. De esta forma, el vacío existente en la literatura relacionada con el diseño de sistemas de almacenamiento puede ser cubierto con la aportación realizada por el presente trabajo que pueda permitir a los expertos en este campo, apoyarse en la utilización de la misma para seguir avanzando en el complejo mundo del diseño de sistemas de almacenamiento.
[CAT] L'objectiu perseguit amb el present treball ha sigut el de desenvolupar una metodologia de disseny de sistemes emmagatzematge, oferint igualment les eines matemàtiques necessàries per a la presa de decisions. És per tot això que amb la present tesi s'han aconseguit assolir els següents propòsits : 1- Definir una sèrie de passos a seguir en el disseny de sistemes de emmagatzematge. 2- En cada un dels passos descrits, establir els criteris a tindre en compte per a la pressa de decisions que permeten avançar en el disseny del mateix. 3- Determinar les variables a tenir en compte i com la relació entre aquestes mateixes defineix les solucions possibles aconseguides, de manera que de totes les possibles combinacions possibles en el disseny de magatzems, algunes es descarten per impossibilitats físiques. 4- Desenvolupar eines matemàtiques com l'algoritme d'experimentació definit en el present treball que permetin l'elecció de les millors solucions possibles. 5- Determinació de procediments de comprovació que la solució adoptada correspon amb els objectius perseguits i s'ajusta a les restriccions establertes. 6- Validar la metodologia i l'algoritme d'experimentació definits amb l'aplicació a un cas pràctic real , que ha permès definir un el millor disseny posible ajustat a uns objectius i restriccions reals per satisfer les necessitats plantejades . D'aquesta manera , el buit existent en la literatura relacionada amb el disseny de sistemes d'emmagatzematge pot ser cobert amb l'aportació realitzada pel present treball que pugui permetre als experts en aquest camp , recolzar-se en la utilització de la mateixa per seguir avançant en el complex món del disseny de sistemes d'emmagatzematge.
Devis Gallego, S. (2016). Una metodología para el diseño estratégico de almacenes de reserva basada en la selección de tecnologías y políticas de gestión [Tesis doctoral no publicada]. Universitat Politècnica de València. https://doi.org/10.4995/Thesis/10251/61444
TESIS

APA, Harvard, Vancouver, ISO, and other styles

24

Brand, Adele. "DiD Warehouse." Diss., University of Pretoria, 2003. http://hdl.handle.net/2263/29811.

Full text

Abstract:

The warehouse will be seen as an outlet of décor elements and designer furniture as well as of South African and international décor shops and designs. A showroom of designer furniture (of well-known designers like Rietveld, Graves, Gehry, etc.) for the public and interested and affected parties will be provided. All the different functions must be integrated and the interaction between various designers and different décor elements will form an important aspect of the warehouse. DiD Warehouse must facilitate innovation and welcome new talents among collaborators along with the "design consumer", an informed and sensitive buyer who, by setting in motion a buying project of his own, is transforming distribution. Even retailers will have to change their attitude, and get rid of the "museum store" concept, that is, a space where the objects on display cannot be touched. The warehouse should be seen as an event place, which has a give-and-take relationship with the life and culture of the city and which attracts the visitor, plying him with emotions and services over and above a simple exchange of merchandise and money over a counter. Growth of any kind brings with it an ability to keep changing, doing away with moldy prejudices to make room for the new. Transformation, movement and lightness are, in the end, the words that best sum up the character of what the designer warehouse must be in the future. Time, scale and functional differences must be solved through the design and planning of spaces. The building will be seen as a "container". South African and international influences, as well as space perceptions of the Post-Modernist era, must be incorporated to set a precedent for the warehouse. A true South African influence and modern style will be reflected through the architecture. The furniture and décor elements will form part of the building and architecture, and must complement each other. DiD Warehouse will house historical and current designer furniture and décor elements, to ensure prospects, possibilities and opportunities for designers of the future. Local designers will get exposure to the international design industry, and a standard for each design and designer will be set. Differences versus similarities must positively reflect the diversity of South African and international design. Import and export of designer furniture and décor are going to be very important aspects in the administration and economical management of the warehouse. The architecture and interior design of the warehouse will complement each other and create the same feeling, that of inspiration, creativity, modern design, imagination, reality and exclusivity. a designer masterpiece as well. Every well-known architect has designed a piece of furniture in his/her life The building will reflect its function and the activities within the façade and architecture, and will aim to be time and the relationship between architecture and designer furniture is very important and dynamic. One of the most important functions of the building will be to launch careers and test ideas. The exterior (architecture and façade) will set a standard for what is inside the building and the warehouse will aim to set a precedent for future furniture development in South Africa. The building will strive to be a very important catalyst in generating designer décor and furniture. There is a demand for steady retail, which will revive the industrial and export sector. South Africa remains the powerhouse of the continent and medium to long-term prospects are good. This means that deals that can be successful today will become that much more attractive in the future. The warehouse must encourage other designers to make conscious use of design as a factor in the competitive process. Precedents will be the platform of the final product. The building must be adaptable and flexible to accommodate continuous changes in technology, fashion and the changing environment and way of living of each person. It must be flexible in terms of more possibilities, greater prospects and better investments. Young entrepreneurs must have the opportunity to show their designs. The warehouse will be educational in a theoretical, practical and visual way. Furniture design courses will be held from time to time as well as exhibitions held by entrepreneurs and "young-up-and-coming" designers. That will create contrasts in price and experience. The aim of the thesis is to design a modern designer furniture and décor warehouse (situated in a security business park) to fulfill the needs of the community and industry; to investigate well-known architects and furniture designers theoretical approaches and philosophy towards design; to ensure that DiD Warehouse will be one of its kind in South Africa; to set a market for our local talent and to reflect diversity in today's modern designer furniture and décor; to showcase local and international design for the public and to give everyone easy access to and from the building; and finally, to create a place (warehouse) from another century, not of the past but of the future - based on human relationships, master intelligence, respect and loyalty; which will hold the key to our future in design - the rediscovery of compassion.
Dissertation (MArch (Prof))--University of Pretoria, 2003.
Architecture
unrestricted

APA, Harvard, Vancouver, ISO, and other styles

25

Yu, Ka-wah Janet, and 余嘉華. "Visual arts warehouses, Yau Tong." Thesis, The University of Hong Kong (Pokfulam, Hong Kong), 2001. http://hub.hku.hk/bib/B31986237.

Full text

APA, Harvard, Vancouver, ISO, and other styles

26

Noaman, Amin Yousef. "Distributed data warehouse architecture and design." Thesis, National Library of Canada = Bibliothèque nationale du Canada, 2000. http://www.collectionscanada.ca/obj/s4/f2/dsk1/tape3/PQDD_0027/NQ51662.pdf.

Full text

APA, Harvard, Vancouver, ISO, and other styles

27

COSTA, NAYARA NOGUEIRA DA. "WAREHOUSE DESIGN: A SYSTEMATIC LITERATURE REVIEW." PONTIFÍCIA UNIVERSIDADE CATÓLICA DO RIO DE JANEIRO, 2012. http://www.maxwell.vrac.puc-rio.br/Busca_etds.php?strSecao=resultado&nrSeq=21401@1.

Full text

Abstract:

PONTIFÍCIA UNIVERSIDADE CATÓLICA DO RIO DE JANEIRO
COORDENAÇÃO DE APERFEIÇOAMENTO DO PESSOAL DE ENSINO SUPERIOR
PROGRAMA DE SUPORTE À PÓS-GRADUAÇÃO DE INSTS. DE ENSINO
A implantação de instalações de armazenagem é vista como uma fonte de aumento do nível de serviço e redução de custos ao longo da cadeia de suprimentos. A presente dissertação busca analisar o estado do arte a respeito de design de armazéns utilizando a metodologia de revisão sistemática de literatura. O período de publicações levantado foi do ano de 1999 até 2011 e a base de dados eletrônica explorada foi a Science Direct. Para guiar a revisão foi elaborado um modelo conceitual contemplando as decisões que fazem parte do escopo do design de armazéns, o qual foi chamado de framework. O framework está dividido em três grandes partes. A primeira parte, input, representa as decisões que precedem ao desenho e implantação das operações de armazenagem em uma instalação e que impactam diretamente nesta fase. A segunda parte é desenho e implantação, e traz as decisões mais relevantes para instalar um armazém e quais as métricas usadas para acompanhar a performance das operações do armazém. E por fim, tem-se a última parte, output que representa o objetivo final do design de armazém para a empresa. A forma como o framework está estruturado sugere que os níveis de decisões são interativos, não podendo ser analisados separadamente, fato comprovado pela análise dos trabalhos encontrados. Por fim, pretende-se que esta dissertação sirva com uma ferramenta para profissionais de design de armazéns, bem como suporte a pesquisas futuras sobre o tema.
The deployment of warehousing facilities is seen as a source of increased level of service and reducing costs along the supply chain. This master thesis aims to analyze the state of the art regarding the design of warehouses using the methodology of systematic literature review. The period of publication raised ranges from 1999 until 2011 and Science Direct was the electronic database explored. To guide the review a conceptual model was developed considering the decisions that are beyond the scope of the design of warehouses, which was called a framework. The framework is divided into three major parts. The first part, input, represents the decisions that precede the design and deployment of warehousing operations in a facility and which directly impact at this stage. The second part is the design and deployment, and brings the most important decisions to install a warehouse and what metrics are used to evaluate the performance of warehouse operations. Finally, the last part, output, representes the the final goal of designing a warehouse for the company. The way the framework is structured suggests that levels of decisions are interactive and can not be analyzed separately, a fact corroborated by the analysis of the studies found. Finally, it is expected that the present master thesis becomes a tool to warehouse design professionals, as well as support for future research on the subject.

APA, Harvard, Vancouver, ISO, and other styles

28

Gomes, Daniel. "Web Modelling for Web Warehouse Design." Doctoral thesis, Department of Informatics, University of Lisbon, 2007. http://hdl.handle.net/10451/14294.

Full text

Abstract:

Users require applications to help them obtaining knowledge from the web. However, the specific characteristics of web data make it difficult to create these applications. One possible solution to facilitate this task is to extract information from the web, transform and load it to a Web Warehouse, which provides uniform access methods for automatic processing of the data. Web Warehousing is conceptually similar to Data Warehousing approaches used to integrate relational information from databases. However, the structure of the web is very dynamic and cannot be controlled by the Warehouse designers. Web models frequently do not reflect the current state of the web. Thus, Web Warehouses must be redesigned at a late stage of development. These changes have high costs and may jeopardize entire projects. This thesis addresses the problem of modelling the web and its influence in the design of Web Warehouses. A model of a web portion was derived and based on it, a Web Warehouse prototype was designed. The prototype was validated in several real-usage scenarios. The obtained results show that web modelling is a fundamental step of the web data integration process

APA, Harvard, Vancouver, ISO, and other styles

29

Ozturk, Aybuke. "Design, Implementation and Analysis of a Description Model for Complex Archaeological Objects." Thesis, Lyon, 2018. http://www.theses.fr/2018LYSE2048/document.

Full text

Abstract:

La céramique est l'un des matériaux archéologiques les plus importants pour aider à la reconstruction des civilisations passées. Les informations à propos des objets céramiques complexes incluent des données textuelles, numériques et multimédias qui posent plusieurs défis de recherche abordés dans cette thèse. D'un point de vue technique, les bases de données de céramiques présentent différents formats de fichiers, protocoles d'accès et langages d'interrogation. Du point de vue des données, il existe une grande hétérogénéité et les experts ont différentes façons de représenter et de stocker les données. Il n'existe pas de contenu et de terminologie standard, surtout en ce qui concerne la description des céramiques. De plus, la navigation et l'observation des données sont difficiles. L'intégration des données est également complexe en raison de laprésence de différentes dimensions provenant de bases de données distantes, qui décrivent les mêmes catégories d'objets de manières différentes.En conséquence, ce projet de thèse vise à apporter aux archéologues et aux archéomètres des outils qui leur permettent d'enrichir leurs connaissances en combinant différentes informations sur les céramiques. Nous divisons notre travail en deux parties complémentaires : (1) Modélisation de données archéologiques complexes, et (2) Partitionnement de données (clustering) archéologiques complexes. La première partie de cette thèse est consacrée à la conception d'un modèle de données archéologiques complexes pour le stockage des données céramiques. Cette base de donnée alimente également un entrepôt de données permettant des analyses en ligne (OLAP). La deuxième partie de la thèse est consacrée au clustering (catégorisation) des objets céramiques. Pour ce faire, nous proposons une approche floue, dans laquelle un objet céramique peut appartenir à plus d'un cluster (d'une catégorie). Ce type d'approche convient bien à la collaboration avec des experts, enouvrant de nouvelles discussions basées sur les résultats du clustering.Nous contribuons au clustering flou (fuzzy clustering) au sein de trois sous-tâches : (i) une nouvelle méthode d'initialisation des clusters flous qui maintient linéaire la complexité de l'approche ; (ii) un indice de qualité innovant qui permet de trouver le nombre optimal de clusters ; et (iii) l'approche Multiple Clustering Analysis qui établit des liens intelligents entre les données visuelles, textuelles et numériques, ce qui permet de combiner tous les types d'informations sur les céramiques. Par ailleurs, les méthodes que nous proposons pourraient également être adaptées à d'autres domaines d'application tels que l'économie ou la médecine
Ceramics are one of the most important archaeological materials to help in the reconstruction of past civilizations. Information about complex ceramic objects is composed of textual, numerical and multimedia data, which induce several research challenges addressed in this thesis. From a technical perspective, ceramic databases have different file formats, access protocols and query languages. From a data perspective, ceramic data are heterogeneous and experts have differentways of representing and storing data. There is no standardized content and terminology, especially in terms of description of ceramics. Moreover, data navigation and observation are difficult. Data integration is also difficult due to the presence of various dimensions from distant databases, which describe the same categories of objects in different ways.Therefore, the research project presented in this thesis aims to provide archaeologists and archaeological scientists with tools for enriching their knowledge by combining different information on ceramics. We divide our work into two complementary parts: (1) Modeling of Complex Archaeological Data and (2) Clustering Analysis of Complex Archaeological Data. The first part of this thesis is dedicated to the design of a complex archaeological database model for the storage of ceramic data. This database is also used to source a data warehouse for doing online analytical processing (OLAP). The second part of the thesis is dedicated to an in-depth clustering (categorization) analysis of ceramic objects. To do this, we propose a fuzzy approach, where ceramic objects may belong to more than one cluster (category). Such a fuzzy approach is well suited for collaborating with experts, by opening new discussions based on clustering results.We contribute to fuzzy clustering in three sub-tasks: (i) a novel fuzzy clustering initialization method that keeps the fuzzy approach linear; (ii) an innovative quality index that allows finding the optimal number of clusters; and (iii) the Multiple Clustering Analysis approach that builds smart links between visual, textual and numerical data, which assists in combining all types ofceramic information. Moreover, the methods we propose could also be adapted to other application domains such as economy or medicine

APA, Harvard, Vancouver, ISO, and other styles

30

Munir, Wahab. "Optimization of Data Warehouse Design and Architecture." Thesis, KTH, Skolan för informations- och kommunikationsteknik (ICT), 2011. http://urn.kb.se/resolve?urn=urn:nbn:se:kth:diva-37233.

Full text

Abstract:

A huge number of SCANIA trucks and busses are running on the roads. Unlike the trucks and buses of the past, they are hi-tech vehicles, carrying a lot of technical and operational information that pertains to different aspects like load statistics, driving time, engine-speed over time and much more. This information is fed into an analysis system where it is organized to support analytical questions. Over the period of time this system has become overloaded and needs to be optimized. There are a number of areas identified that can be considered for improvement. However, it is not possible to analyze the whole system within the given constraints. A subset is picked which has been thought of to be sufficient for the purpose of the thesis. The system takes a lot of time to load new data. Data loading is not incremental. There is a lot of redundancy in the storage structure. Query execution takes a lot of time in some parts of the database. The methods chosen for this thesis includes data warehouse design and architecture analysis, end user queries review, and code analysis. A potential solution is presented to reduce the storage space requirements and maintenance time taken by the databases. This is achieved by presenting a solution to reduce the number of databases maintained in parallel and contains duplicated data. Some optimizations have been made in the storage structure and design to improve the query processing time for the end users. An example incremental loading strategy is also implemented to demonstrate the working and idea. This helps in the reduction of loading time. Moreover, An investigation has been made into a commercially available Data warehouse management System. The investigation is mostly based on hardware architecture and how it can contributes to better performance. This portion is only theoretical. Based on the analysis recommendations are made regarding the architecture and design of the data warehouse.

APA, Harvard, Vancouver, ISO, and other styles

31

Daraei, Maryam. "Warehouse Redesign Process: A case study at Enics Sweden AB." Thesis, Mälardalens högskola, Akademin för innovation, design och teknik, 2013. http://urn.kb.se/resolve?urn=urn:nbn:se:mdh:diva-19508.

Full text

Abstract:

Nowadays warehousing became one of the most important and critical part in supply chain systems due to the fact that it consumes a considerable part of logistic cost. Designing phase of warehousing system is the most important part in warehousing since most of the strategic and tactical decisions should be taken in this phase. Majority of academic papers are primarily analysis oriented and does not give a systematic method and techniques as a basis for warehouse redesign. So there is a need to develop a structured procedure that can be applied for different type of warehouses. Therefore the purpose of this thesis is to develop a process for redesigning production warehouses, and analyzing major problems during redesign steps. The thesis is designed as a case study, and a mix of quantitative and qualitative methods were used for data collection and data analysis. The methodology focuses around the warehousing process and redesign steps as described in the literature. Results of the thesis develop a seven steps procedure for redesigning of the production warehouse, also different problems and challenges are faced during redesign steps. It was tried to choose the best redesigning method which fit with the characteristics of the warehouse, in order to cover the space reduction of the warehouse with the consideration of existing facilities and reducing of cost. In addition, the performance of the current warehouse system was evaluated based on current design of the warehouse in order to avoid repeating of same mistake in redesign process. Storage assignment policy as one of the redesign steps was discussed and a framework for storage system of the components were suggested. The findings of the thesis to some extent can be applicable to other production warehouses. Further research is suggested for more specific results and new developed redesign methods for all types of warehouses.

APA, Harvard, Vancouver, ISO, and other styles

32

Tse, Ka-kwan Charmaine, and 謝鎵君. ""Click-and-Mortar" Bookstore + Distribution Warehouse." Thesis, The University of Hong Kong (Pokfulam, Hong Kong), 2002. http://hub.hku.hk/bib/B31986808.

Full text

APA, Harvard, Vancouver, ISO, and other styles

33

Pornnoparat, Dangfun. "Warehouse network design for a commodity chemicals manufacturer." Thesis, Massachusetts Institute of Technology, 2016. http://hdl.handle.net/1721.1/107512.

Full text

Abstract:

Thesis: M. Eng. in Logistics, Massachusetts Institute of Technology, Supply Chain Management Program, 2016.
Cataloged from PDF version of thesis.
Includes bibliographical references (page 31).
The choice of the location and number of warehouses is a strategic-level decision that can have a long- lasting impact on a firm's performance. Warehouse locations and their capacities determine how products flow within a firm's supply chain, which directly influences a firm's performance in terms of cost and service level. This research applies a mixed integer linear programming method to evaluate factors that drive existing inefficiencies in a warehouse network belonging to a Thai commodity chemicals manufacturer. The objective is to determine an optimal warehouse network configuration that minimizes the firm's total transportation and warehousing cost. Inventory turns and storage capacity constraints are found to be the key drivers of inefficiencies. The optimal solution suggests that the company should retain fewer warehouses and expand capacities at these locations. As the company continues to grow, the potential benefit from expansion becomes greater.
by Dangfun Pornnoparat.
M. Eng. in Logistics

APA, Harvard, Vancouver, ISO, and other styles

34

Agrawal, Vikas R. "Data warehouse operational design : view selection and performance simulation." Toledo, Ohio : University of Toledo, 2005. http://rave.ohiolink.edu/etdc/view?acc%5Fnum=toledo1104773641.

Full text

Abstract:

Dissertation (Ph.D.)--University of Toledo, 2005.
Typescript. "Submitted as partial fulfillment of the requirements for the Doctor of Philosophy degree in Manufacturing Management and Engineering. " "A dissertation entitled"--at head of title. Title from title page of PDF document. Bibliography: p. 113-118.

APA, Harvard, Vancouver, ISO, and other styles

35

AGRAWAL, VIKAS R. "Data Warehouse Operational Design: View Selection and Performance Simulation." University of Toledo / OhioLINK, 2005. http://rave.ohiolink.edu/etdc/view?acc_num=toledo1104773641.

Full text

APA, Harvard, Vancouver, ISO, and other styles

36

Nayyar, Raghu. "Visualising Autonomous Warehouse Data Streams Through User-Centered Design." Thesis, KTH, Medieteknik och interaktionsdesign, MID, 2018. http://urn.kb.se/resolve?urn=urn:nbn:se:kth:diva-233195.

Full text

Abstract:

This thesis aims to develop and evaluate a dashboard design that visualizes a stream of data from the different entities involved in autonomous warehouses, a subset of cyber-physical systems. I created this dashboard through User-Centered Design (UCD) methodologies based on two feedback iterations with the stakeholders employing semi-structured expert opinion interviews. This thesis also discusses the different stages involved in building this dashboard design, the design decisions, the technical aspects of the libraries used, and the feedback session towards the end of the project. It also presents the implemented dashboard as a proof of development efforts and explains its different functionalities. The project concludes with evaluating the dashboard through a semi-structured interview with the respective stakeholders and suggests features for further development.
Denna studie ämnar att utveckla och utvärdera en design för ett dashboard som visualiserar dataströmmar från olika enheter som kan hittas i autonoma lager. Detta dashboard har utvecklats genom att använda metoder inom användarcentrerad design, som baserades på två iterationer med intressenter som är experter inom området, där semistrukturerade intervjuer gjordes. Denna studie diskuterar också de olika steg som är involverade i att bygga designen av detta dashboard, de olika beslut som togs i designprocessen, de tekniska aspekterna av de bibliotek som används och resultatet från de sessioner som hölls för att få feedback i slutet av projektet. Studien presenterar också det dashboard som utvecklades samt förklarar dess funktionalitet. Slutsatser dras från de semistrukturerade intervjuerna med respektive intressent och föreslår framtida funktioner som skulle vara möjliga att implementera.

APA, Harvard, Vancouver, ISO, and other styles

37

Naviroj, Natachai. "A Warehouse Managed Inventory System for Multiple Retailers and Multiple Product." Case Western Reserve University School of Graduate Studies / OhioLINK, 2016. http://rave.ohiolink.edu/etdc/view?acc_num=case1467052082.

Full text

APA, Harvard, Vancouver, ISO, and other styles

38

Ivanović, Goran Gue Kevin R. "Aisle designs for unit-load warehouses with multiple pickup and deposit points." Auburn, Ala., 2007. http://repo.lib.auburn.edu/2007%20Fall%20Theses/Ivanovic_Goran_16.pdf.

Full text

APA, Harvard, Vancouver, ISO, and other styles

39

Lester, Margaret C. "Factors in the design and development of a data warehouse for academic data." [Johnson City, Tenn. : East Tennessee State University], 2003. http://etd-submit.etsu.edu/etd/theses/available/etd-0328103-154549/unrestricted/Lester041403f.pdf.

Full text

Abstract:

Thesis (M.S.)--East Tennessee State University, 2003.
Title from electronic submission form. ETSU ETD database URN: etd-0328103-154549. Includes bibliographical references. Also available via Internet at the UMI web site.

APA, Harvard, Vancouver, ISO, and other styles

40

Naik, Vaibhav C. "Fuzzy C-means clustering approach to design a warehouse layout." [Tampa, Fla.] : University of South Florida, 2004. http://purl.fcla.edu/fcla/etd/SFE0000437.

Full text

APA, Harvard, Vancouver, ISO, and other styles

41

Issa, Carla Mounir. "Data warehouse applications in modern day business." CSUSB ScholarWorks, 2002. https://scholarworks.lib.csusb.edu/etd-project/2148.

Full text

Abstract:

Data warehousing provides organizations with strategic tools to achieve the competitive advantage that organazations are constantly seeking. The use of tools such as data mining, indexing and summaries enables management to retrieve information and perform thorough analysis, planning and forcasting to meet the changes in the market environment. in addition, The data warehouse is providing security measures that, if properly implemented and planned, are helping organizations ensure that their data quality and validity remain intact.

APA, Harvard, Vancouver, ISO, and other styles

42

Rösch, Philipp. "Design von Stichproben in analytischen Datenbanken." Doctoral thesis, Saechsische Landesbibliothek- Staats- und Universitaetsbibliothek Dresden, 2009. http://nbn-resolving.de/urn:nbn:de:bsz:14-qucosa-22916.

Full text

Abstract:

Aktuelle Studien belegen ein rasantes, mehrdimensionales Wachstum in analytischen Datenbanken: Das Datenvolumen verzehnfachte sich in den letzten vier Jahren, die Anzahl der Nutzer wuchs um durchschnittlich 25% pro Jahr und die Anzahl der Anfragen verdoppelte sich seit 2004 jährlich. Bei den Anfragen handelt es sich zunehmend um komplexe Verbundanfragen mit Aggregationen; sie sind häufig explorativer Natur und werden interaktiv an das System gestellt. Eine Möglichkeit, der Forderung nach Interaktivität bei diesem starken, mehrdimensionalen Wachstum nachzukommen, stellen Stichproben und eine darauf aufsetzende näherungsweise Anfrageverarbeitung dar. Diese Lösung bietet signifikant kürzere Antwortzeiten sowie Schätzungen mit probabilistischen Fehlergrenzen. Mit den Operationen Verbund, Gruppierung und Aggregation als Hauptbestandteile analytischer Anfragen ergeben sich folgende Anforderungen an das Design von Stichproben in analytischen Datenbanken: Zwischen den Stichproben fremdschlüsselverbundener Relationen ist die referenzielle Integrität zu gewährleisten, sämtliche Gruppen sind angemessen zu repräsentieren und Aggregationsattribute sind auf extreme Werte zu untersuchen. In dieser Dissertation wird für jedes dieser Teilprobleme ein Stichprobenverfahren vorgestellt, das sich durch speicherplatzbeschränkte Stichproben und geringe Schätzfehler auszeichnet. Im ersten der vorgestellten Verfahren wird durch eine korrelierte Stichprobenerhebung die referenzielle Integrität bei minimalem zusätzlichen Speicherplatz gewährleistet. Das zweite vorgestellte Stichprobenverfahren hat durch eine Berücksichtigung der Streuung der Daten eine angemessene Repräsentation sämtlicher Gruppen zur Folge und unterstützt damit beliebige Gruppierungen, und im dritten Verfahren ermöglicht eine mehrdimensionale Ausreißerbehandlung geringe Schätzfehler für beliebig viele Aggregationsattribute. Für jedes dieser Verfahren wird die Qualität der resultierenden Stichprobe diskutiert und bei der Berechnung speicherplatzbeschränkter Stichproben berücksichtigt. Um den Berechnungsaufwand und damit die Systembelastung gering zu halten, werden für jeden Algorithmus Heuristiken vorgestellt, deren Kennzeichen hohe Effizienz und eine geringe Beeinflussung der Stichprobenqualität sind. Weiterhin werden alle möglichen Kombinationen der vorgestellten Stichprobenverfahren betrachtet; diese Kombinationen ermöglichen eine zusätzliche Verringerung der Schätzfehler und vergrößern gleichzeitig das Anwendungsspektrum der resultierenden Stichproben. Mit der Kombination aller drei Techniken wird ein Stichprobenverfahren vorgestellt, das alle Anforderungen an das Design von Stichproben in analytischen Datenbanken erfüllt und die Vorteile der Einzellösungen vereint. Damit ist es möglich, ein breites Spektrum an Anfragen mit hoher Genauigkeit näherungsweise zu beantworten
Recent studies have shown the fast and multi-dimensional growth in analytical databases: Over the last four years, the data volume has risen by a factor of 10; the number of users has increased by an average of 25% per year; and the number of queries has been doubling every year since 2004. These queries have increasingly become complex join queries with aggregations; they are often of an explorative nature and interactively submitted to the system. One option to address the need for interactivity in the context of this strong, multi-dimensional growth is the use of samples and an approximate query processing approach based on those samples. Such a solution offers significantly shorter response times as well as estimates with probabilistic error bounds. Given that joins, groupings and aggregations are the main components of analytical queries, the following requirements for the design of samples in analytical databases arise: 1) The foreign-key integrity between the samples of foreign-key related tables has to be preserved. 2) Any existing groups have to be represented appropriately. 3) Aggregation attributes have to be checked for extreme values. For each of these sub-problems, this dissertation presents sampling techniques that are characterized by memory-bounded samples and low estimation errors. In the first of these presented approaches, a correlated sampling process guarantees the referential integrity while only using up a minimum of additional memory. The second illustrated sampling technique considers the data distribution, and as a result, any arbitrary grouping is supported; all groups are appropriately represented. In the third approach, the multi-column outlier handling leads to low estimation errors for any number of aggregation attributes. For all three approaches, the quality of the resulting samples is discussed and considered when computing memory-bounded samples. In order to keep the computation effort - and thus the system load - at a low level, heuristics are provided for each algorithm; these are marked by high efficiency and minimal effects on the sampling quality. Furthermore, the dissertation examines all possible combinations of the presented sampling techniques; such combinations allow to additionally reduce estimation errors while increasing the range of applicability for the resulting samples at the same time. With the combination of all three techniques, a sampling technique is introduced that meets all requirements for the design of samples in analytical databases and that merges the advantages of the individual techniques. Thereby, the approximate but very precise answering of a wide range of queries becomes a true possibility

APA, Harvard, Vancouver, ISO, and other styles

43

Brito, A. E. S. C. "Configuring Simulation Models Using CAD Techniques: A New Approach to Warehouse Design." Thesis, Cranfield University, 1992. http://dspace.lib.cranfield.ac.uk/handle/1826/4640.

Full text

Abstract:

The research reported in this thesis is related to the development and use of software tools for supporting warehouse design and management. Computer Aided Design and Simulation techniques are used to develop a software system that forms the basis of a Decision Support System for warehouse design. The current position of simulation software is reviewed. It is investigated how appropriate current simulation software is for warehouse modelling. Special attention is given to Visual Interactive Simulation, graphics, animation and user interfaces. The warehouse design process is described and common difficulties are highlighted. A Decision Support System (DSS) framework is proposed to give support during all the warehouse design phases. The use of simulation in warehouse design is identified as being essential for evaluating different warehouse configurations. Several simulation models are used to show that the warehouse systems special characteristics require a new way of defining the simulation model and new modelling elements to represent the complex logic of a warehouse system. AWARD (Advanced WARehouse Design) is a data-driven generic model, developed to build warehouse simulation models. It uses Computer Aided Design (CAD) techniques for drawing the warehouse layout and configuring the simulation model. The user has no need for programming skills and a user-friendly interface makes it easy to use. High resolution colour graphics and a scale drawing of the warehouse makest he dynamic display of the model a good representationo f the real system. Several examples illustrate the use of the AWARD system. The experience and advantages of the AWARD approach is discussed and the extension of this approach to other areas is explored.

APA, Harvard, Vancouver, ISO, and other styles

44

Lindahl, Mattias, Erik Sundin, Tomohiko Sakao, and Yoshiki Shimomura. "An application of a service design tool at a global warehouse provider." Linköpings universitet, Institutionen för konstruktions- och produktionsteknik, 2005. http://urn.kb.se/resolve?urn=urn:nbn:se:liu:diva-29932.

Full text

Abstract:

The concept of 'sustainable development', introduced for the first time in the report 'Our Common Future' and promoted as a common aim for the entire world, can be defined as 'a development that satisfies the needs of today without compromising the possibility of future generations to fulfill their needs.' Thus far, this concept has been considered as visionary and therefore difficult for companies to implement into concrete plans of action. However, various suggestions have been proposed, such as dematerialization, ecoefficiency and remanufacturing. However, another solution is perhaps more or less a consequence of today's prevalent trend towards a more service-oriented society, and with a focus on the value (satisfaction) that products provide their users through their functionality. The shift from a manufacturing-centered economy towards a service-centered economy have the potential to result in a reduction of the mass consumption of natural resources. Sustainable development is, in a company perspective, not only related directly to environmental issues, as in the definition above, but also in the company's capacity for sustainable market competition. The sharp and rapid increase in global raw material prices, however, is a threat to this; one way to decrease this influence is to reduce the need for raw materials.

APA, Harvard, Vancouver, ISO, and other styles

45

Smith, Clifford A. (Clifford Allen) 1972. "Simulation model used as design improvement decision tool for warehouse material flow." Thesis, Massachusetts Institute of Technology, 2005. http://hdl.handle.net/1721.1/34830.

Full text

Abstract:

Thesis (M.B.A.)--Massachusetts Institute of Technology, Sloan School of Management; and, (S.M.)--Massachusetts Institute of Technology, Dept. of Mechanical Engineering; in conjunction with the Leaders for Manufacturing Program at MIT, 2005.
Includes bibliographical references (p. 109-110).
The basis for this thesis involved a six and a half month LFM internship at Efficient Storage, Shipping, and Selection. ES3, Efficient Storage, Shipping, and Selection, is a third party logistics firm that specializes in a vendor-neutral consolidation model for the food distribution industry. ES3 receives, stores, and ships multi-vendor products through a distribution center (DC) in York, Pennsylvania. The product is moved and stored by an Automated Storage and Retrieval System (ASRS) which consists of a network of conveyors, vertical lifts, and Selection and Retrieval Machines (SRMs). The ASRS system is not performing to the designed put-away and shipping rates, thus limiting the DC's overall performance during peak operations. The warehouse operations and warehouse design teams had numerous design suggestions for improving the ASRS operations, but it was difficult to predict the enhancement or impact on performance. A simulation model for the inbound system was created to analyze the impact, prioritize, and develop new ideas for improving the system.
by Clifford A. Smith.
S.M.
M.B.A.

APA, Harvard, Vancouver, ISO, and other styles

46

Abdul, Hamid Nor Hayati. "Seismic damage avoidance design of warehouse buildings constructed using precast hollow core panels." Thesis, University of Canterbury. Civil Engineering, 2006. http://hdl.handle.net/10092/1153.

Full text

Abstract:

Precast prestressed hollow core units are commonly used in the construction of the flooring system in precast buildings. These units without transverse reinforcement bars are designed to resist seismic loading as replacement for fixed-base precast wall panels in the construction of warehouse buildings. Thus, this research seeks to investigate the seismic performance of the units constructed as a subassemblage (single wall) subjected to biaxial loading and as a superassemblage (multi-panel) subjected to quasi-static lateral loading. A design procedure for warehouse building using precast hollow core walls under Damage Avoidance Design (DAD) is proposed. In addition, a risk assessment under Performance-Based Earthquake Engineering (PBEE) is evaluated using the latest computational tool known as Incremental Dynamic Analysis (IDA). A comparative risk assessment between precast hollow core walls and fixed-base monolithic precast wall panels is also performed. Experimental results demonstrate that rocking precast hollow core walls with steelarmouring do not suffer any non-structural damage up to 2.0% drift and minor structural damage at 4.0% drift. Results revealed that the wall with unbonded fuse-bars and 50% initial prestressing of unbonded tendons performed the best compared with other types of energy dissipators. Furthermore, 12mm diameter of fuse-bar is recommended as there is no uplifting of the foundation beam during ground shaking. Hence, this type of energy dissipator is used for the construction of seismic wall panels in warehouse buildings. One of the significant findings is that the capacity reduction factor (Ã˜ ) which relates to global uncertainty of seismic performance is approximately equal to 0.6. This value can be used to estimate the 90th percentile of the structures without performing IDA. Therefore, the structural engineers are only required to compute Rapid-IDA curve along with the proposed design procedure.

APA, Harvard, Vancouver, ISO, and other styles

47

Iveroth, Axel. "Using Work Domain Analysis to Evaluate the Design of a Data Warehouse System." Thesis, Uppsala universitet, Avdelningen för visuell information och interaktion, 2019. http://urn.kb.se/resolve?urn=urn:nbn:se:uu:diva-384575.

Full text

Abstract:

Being able to perform good data analysis is a fundamental part of running any business or organization. One way of enabling data analysis is with a data warehouse system, a type of database that gathers and transforms data from multiple sources and structures it in the goal of simplifying analysis. It is commonly used to provide support in decision-making. Although a data warehouse enables data analysis, it is also relevant to consider how well the system supports analysis. This thesis is a qualitative research that aims to investigate how work domain analysis (WDA) can be used to evaluate the design of a data warehouse system. To do so, a case study at the IT company Norconsult Astando was performed. A data warehouse system was designed for an issue management system and evaluated using the abstraction hierarchy (AH) model. The research done in this thesis showed that analysis was enabled by adopting Kimball’s bottom-up approach and a star schema design with an accumulating snapshot fact table. Through evaluation of the design, it was shown that most of the design choices made for the data warehouse were captured in the AH. It was concluded that with sufficient data collection methods, WDA can be used to a large extent when evaluating a data warehouse system.

APA, Harvard, Vancouver, ISO, and other styles

48

Steffey, David William. "Layout design analysis for the storage area in a distribution center." 2009. http://etd.louisville.edu/data/UofL0472t2009.pdf.

Full text

Abstract:

Thesis (M.Eng.)--University of Louisville, 2009.
Title and description from thesis home page (viewed May 15, 2009). Department of Industrial Engineering. Vita. "May 2009." Includes bibliographical references (p. 34).

APA, Harvard, Vancouver, ISO, and other styles

49

"Automating the multidimensional design of data warehouses." Universitat Politècnica de Catalunya, 2010. http://www.tesisenxarxa.net/TDX-0528110-134628/.

Full text

APA, Harvard, Vancouver, ISO, and other styles

50

Fernandes, Luís Miguel Teixeira. "Improving Operations and Layout Design in Retail Cross-Docking Warehouses." Master's thesis, 2018. https://hdl.handle.net/10216/113719.

Full text

APA, Harvard, Vancouver, ISO, and other styles

Dissertations / Theses on the topic 'Warehouses Design'

Create a spot-on reference in APA, MLA, Chicago, Harvard, and other styles