Projeto/Reprojeto de bancos de dados relacionais : a ferramenta DB-Tool.

Detalhes bibliográficos
Autor(a) principal: Ferreira, Anderson Almeida
Data de Publicação: 1997
Outros Autores: Laender, Alberto Henrique Frade, Silva, Altigran Soares da
Tipo de documento: Artigo de conferência
Idioma: por
Título da fonte: Repositório Institucional da UFOP
Texto Completo: http://www.repositorio.ufop.br/handle/123456789/1733
Resumo: This paper describes a tool that supp orts the design and redesign of relational databases The tool produces optimized relational representations of entity relationship ER schemas and is implemented using Informix as its target database management system DBMS The tool operates in two phases In the first phase it receives as input an ER schema and generates a list of commands to implement the corresponding Informix schema In the second phase it receives a list of redesign commands specifying changes to the ER schema and generates a redesign plan to reestructure the database accordingly An example illustrates the use of the tool.
id UFOP_31e9e3a141958c89e3fcd6d6bfe0ef45
oai_identifier_str oai:localhost:123456789/1733
network_acronym_str UFOP
network_name_str Repositório Institucional da UFOP
repository_id_str 3233
spelling Ferreira, Anderson AlmeidaLaender, Alberto Henrique FradeSilva, Altigran Soares da2012-10-22T20:56:53Z2012-10-22T20:56:53Z1997FERREIRA, A. A.; LAENDER, A. H. F.; SILVA, A. S. da. Projeto/Reprojeto de bancos de dados relacionais : a ferramenta DB-Tool. In. XII Simpósio Brasileiro de Banco de Dados. 1997. Fortaleza. Anais... Fortaleza: Simpósio Brasileiro de Banco de Dados, 1997. Disponível em: <http://www.decom.ufop.br/anderson/sbbd97.pdf>:. Acesso em: 22 out. 2012.http://www.repositorio.ufop.br/handle/123456789/1733This paper describes a tool that supp orts the design and redesign of relational databases The tool produces optimized relational representations of entity relationship ER schemas and is implemented using Informix as its target database management system DBMS The tool operates in two phases In the first phase it receives as input an ER schema and generates a list of commands to implement the corresponding Informix schema In the second phase it receives a list of redesign commands specifying changes to the ER schema and generates a redesign plan to reestructure the database accordingly An example illustrates the use of the tool.Projeto/Reprojeto de bancos de dados relacionais : a ferramenta DB-Tool.info:eu-repo/semantics/publishedVersioninfo:eu-repo/semantics/conferenceObjectporreponame:Repositório Institucional da UFOPinstname:Universidade Federal de Ouro Preto (UFOP)instacron:UFOPinfo:eu-repo/semantics/openAccessLICENSElicense.txtlicense.txttext/plain; charset=utf-81748http://www.repositorio.ufop.br/bitstream/123456789/1733/5/license.txt8a4605be74aa9ea9d79846c1fba20a33MD55ORIGINALEVENTO_ProjetoReprojetoBancos.pdfEVENTO_ProjetoReprojetoBancos.pdfapplication/pdf236085http://www.repositorio.ufop.br/bitstream/123456789/1733/1/EVENTO_ProjetoReprojetoBancos.pdf019914064ba785d6a0860eb062126654MD51123456789/17332019-03-13 10:59:08.712oai:localhost:123456789/1733Tk9URTogUExBQ0UgWU9VUiBPV04gTElDRU5TRSBIRVJFClRoaXMgc2FtcGxlIGxpY2Vuc2UgaXMgcHJvdmlkZWQgZm9yIGluZm9ybWF0aW9uYWwgcHVycG9zZXMgb25seS4KCk5PTi1FWENMVVNJVkUgRElTVFJJQlVUSU9OIExJQ0VOU0UKCkJ5IHNpZ25pbmcgYW5kIHN1Ym1pdHRpbmcgdGhpcyBsaWNlbnNlLCB5b3UgKHRoZSBhdXRob3Iocykgb3IgY29weXJpZ2h0Cm93bmVyKSBncmFudHMgdG8gRFNwYWNlIFVuaXZlcnNpdHkgKERTVSkgdGhlIG5vbi1leGNsdXNpdmUgcmlnaHQgdG8gcmVwcm9kdWNlLAp0cmFuc2xhdGUgKGFzIGRlZmluZWQgYmVsb3cpLCBhbmQvb3IgZGlzdHJpYnV0ZSB5b3VyIHN1Ym1pc3Npb24gKGluY2x1ZGluZwp0aGUgYWJzdHJhY3QpIHdvcmxkd2lkZSBpbiBwcmludCBhbmQgZWxlY3Ryb25pYyBmb3JtYXQgYW5kIGluIGFueSBtZWRpdW0sCmluY2x1ZGluZyBidXQgbm90IGxpbWl0ZWQgdG8gYXVkaW8gb3IgdmlkZW8uCgpZb3UgYWdyZWUgdGhhdCBEU1UgbWF5LCB3aXRob3V0IGNoYW5naW5nIHRoZSBjb250ZW50LCB0cmFuc2xhdGUgdGhlCnN1Ym1pc3Npb24gdG8gYW55IG1lZGl1bSBvciBmb3JtYXQgZm9yIHRoZSBwdXJwb3NlIG9mIHByZXNlcnZhdGlvbi4KCllvdSBhbHNvIGFncmVlIHRoYXQgRFNVIG1heSBrZWVwIG1vcmUgdGhhbiBvbmUgY29weSBvZiB0aGlzIHN1Ym1pc3Npb24gZm9yCnB1cnBvc2VzIG9mIHNlY3VyaXR5LCBiYWNrLXVwIGFuZCBwcmVzZXJ2YXRpb24uCgpZb3UgcmVwcmVzZW50IHRoYXQgdGhlIHN1Ym1pc3Npb24gaXMgeW91ciBvcmlnaW5hbCB3b3JrLCBhbmQgdGhhdCB5b3UgaGF2ZQp0aGUgcmlnaHQgdG8gZ3JhbnQgdGhlIHJpZ2h0cyBjb250YWluZWQgaW4gdGhpcyBsaWNlbnNlLiBZb3UgYWxzbyByZXByZXNlbnQKdGhhdCB5b3VyIHN1Ym1pc3Npb24gZG9lcyBub3QsIHRvIHRoZSBiZXN0IG9mIHlvdXIga25vd2xlZGdlLCBpbmZyaW5nZSB1cG9uCmFueW9uZSdzIGNvcHlyaWdodC4KCklmIHRoZSBzdWJtaXNzaW9uIGNvbnRhaW5zIG1hdGVyaWFsIGZvciB3aGljaCB5b3UgZG8gbm90IGhvbGQgY29weXJpZ2h0LAp5b3UgcmVwcmVzZW50IHRoYXQgeW91IGhhdmUgb2J0YWluZWQgdGhlIHVucmVzdHJpY3RlZCBwZXJtaXNzaW9uIG9mIHRoZQpjb3B5cmlnaHQgb3duZXIgdG8gZ3JhbnQgRFNVIHRoZSByaWdodHMgcmVxdWlyZWQgYnkgdGhpcyBsaWNlbnNlLCBhbmQgdGhhdApzdWNoIHRoaXJkLXBhcnR5IG93bmVkIG1hdGVyaWFsIGlzIGNsZWFybHkgaWRlbnRpZmllZCBhbmQgYWNrbm93bGVkZ2VkCndpdGhpbiB0aGUgdGV4dCBvciBjb250ZW50IG9mIHRoZSBzdWJtaXNzaW9uLgoKSUYgVEhFIFNVQk1JU1NJT04gSVMgQkFTRUQgVVBPTiBXT1JLIFRIQVQgSEFTIEJFRU4gU1BPTlNPUkVEIE9SIFNVUFBPUlRFRApCWSBBTiBBR0VOQ1kgT1IgT1JHQU5JWkFUSU9OIE9USEVSIFRIQU4gRFNVLCBZT1UgUkVQUkVTRU5UIFRIQVQgWU9VIEhBVkUKRlVMRklMTEVEIEFOWSBSSUdIVCBPRiBSRVZJRVcgT1IgT1RIRVIgT0JMSUdBVElPTlMgUkVRVUlSRUQgQlkgU1VDSApDT05UUkFDVCBPUiBBR1JFRU1FTlQuCgpEU1Ugd2lsbCBjbGVhcmx5IGlkZW50aWZ5IHlvdXIgbmFtZShzKSBhcyB0aGUgYXV0aG9yKHMpIG9yIG93bmVyKHMpIG9mIHRoZQpzdWJtaXNzaW9uLCBhbmQgd2lsbCBub3QgbWFrZSBhbnkgYWx0ZXJhdGlvbiwgb3RoZXIgdGhhbiBhcyBhbGxvd2VkIGJ5IHRoaXMKbGljZW5zZSwgdG8geW91ciBzdWJtaXNzaW9uLgo=Repositório InstitucionalPUBhttp://www.repositorio.ufop.br/oai/requestrepositorio@ufop.edu.bropendoar:32332019-03-13T14:59:08Repositório Institucional da UFOP - Universidade Federal de Ouro Preto (UFOP)false
dc.title.pt_BR.fl_str_mv Projeto/Reprojeto de bancos de dados relacionais : a ferramenta DB-Tool.
title Projeto/Reprojeto de bancos de dados relacionais : a ferramenta DB-Tool.
spellingShingle Projeto/Reprojeto de bancos de dados relacionais : a ferramenta DB-Tool.
Ferreira, Anderson Almeida
title_short Projeto/Reprojeto de bancos de dados relacionais : a ferramenta DB-Tool.
title_full Projeto/Reprojeto de bancos de dados relacionais : a ferramenta DB-Tool.
title_fullStr Projeto/Reprojeto de bancos de dados relacionais : a ferramenta DB-Tool.
title_full_unstemmed Projeto/Reprojeto de bancos de dados relacionais : a ferramenta DB-Tool.
title_sort Projeto/Reprojeto de bancos de dados relacionais : a ferramenta DB-Tool.
author Ferreira, Anderson Almeida
author_facet Ferreira, Anderson Almeida
Laender, Alberto Henrique Frade
Silva, Altigran Soares da
author_role author
author2 Laender, Alberto Henrique Frade
Silva, Altigran Soares da
author2_role author
author
dc.contributor.author.fl_str_mv Ferreira, Anderson Almeida
Laender, Alberto Henrique Frade
Silva, Altigran Soares da
description This paper describes a tool that supp orts the design and redesign of relational databases The tool produces optimized relational representations of entity relationship ER schemas and is implemented using Informix as its target database management system DBMS The tool operates in two phases In the first phase it receives as input an ER schema and generates a list of commands to implement the corresponding Informix schema In the second phase it receives a list of redesign commands specifying changes to the ER schema and generates a redesign plan to reestructure the database accordingly An example illustrates the use of the tool.
publishDate 1997
dc.date.issued.fl_str_mv 1997
dc.date.accessioned.fl_str_mv 2012-10-22T20:56:53Z
dc.date.available.fl_str_mv 2012-10-22T20:56:53Z
dc.type.status.fl_str_mv info:eu-repo/semantics/publishedVersion
dc.type.driver.fl_str_mv info:eu-repo/semantics/conferenceObject
format conferenceObject
status_str publishedVersion
dc.identifier.citation.fl_str_mv FERREIRA, A. A.; LAENDER, A. H. F.; SILVA, A. S. da. Projeto/Reprojeto de bancos de dados relacionais : a ferramenta DB-Tool. In. XII Simpósio Brasileiro de Banco de Dados. 1997. Fortaleza. Anais... Fortaleza: Simpósio Brasileiro de Banco de Dados, 1997. Disponível em: <http://www.decom.ufop.br/anderson/sbbd97.pdf>:. Acesso em: 22 out. 2012.
dc.identifier.uri.fl_str_mv http://www.repositorio.ufop.br/handle/123456789/1733
identifier_str_mv FERREIRA, A. A.; LAENDER, A. H. F.; SILVA, A. S. da. Projeto/Reprojeto de bancos de dados relacionais : a ferramenta DB-Tool. In. XII Simpósio Brasileiro de Banco de Dados. 1997. Fortaleza. Anais... Fortaleza: Simpósio Brasileiro de Banco de Dados, 1997. Disponível em: <http://www.decom.ufop.br/anderson/sbbd97.pdf>:. Acesso em: 22 out. 2012.
url http://www.repositorio.ufop.br/handle/123456789/1733
dc.language.iso.fl_str_mv por
language por
dc.rights.driver.fl_str_mv info:eu-repo/semantics/openAccess
eu_rights_str_mv openAccess
dc.source.none.fl_str_mv reponame:Repositório Institucional da UFOP
instname:Universidade Federal de Ouro Preto (UFOP)
instacron:UFOP
instname_str Universidade Federal de Ouro Preto (UFOP)
instacron_str UFOP
institution UFOP
reponame_str Repositório Institucional da UFOP
collection Repositório Institucional da UFOP
bitstream.url.fl_str_mv http://www.repositorio.ufop.br/bitstream/123456789/1733/5/license.txt
http://www.repositorio.ufop.br/bitstream/123456789/1733/1/EVENTO_ProjetoReprojetoBancos.pdf
bitstream.checksum.fl_str_mv 8a4605be74aa9ea9d79846c1fba20a33
019914064ba785d6a0860eb062126654
bitstream.checksumAlgorithm.fl_str_mv MD5
MD5
repository.name.fl_str_mv Repositório Institucional da UFOP - Universidade Federal de Ouro Preto (UFOP)
repository.mail.fl_str_mv repositorio@ufop.edu.br
_version_ 1801685734037389312