Un algoritm imbunătăţit de calculare a cheilor nesintetizate
Închide
Conţinutul numărului revistei
Articolul precedent
Articolul urmator
857 1
SM ISO690:2012
COTELEA, Vitalie. Un algoritm imbunătăţit de calculare a cheilor nesintetizate . In: Analele Ştiinţifice ale Academiei de Studii Economice din Moldova, 2010, nr. 8, pp. 360-367. ISSN 1857-1433.
EXPORT metadate:
Google Scholar
Crossref
CERIF

DataCite
Dublin Core
Analele Ştiinţifice ale Academiei de Studii Economice din Moldova
Numărul 8 / 2010 / ISSN 1857-1433

Un algoritm imbunătăţit de calculare a cheilor nesintetizate

Pag. 360-367

Cotelea Vitalie
 
Academia de Studii Economice din Moldova
 
 
Disponibil în IBN: 27 noiembrie 2013


Rezumat

This paper focuses on a problem that occurs in the process of database design, that is keys generation. The problem of keys determination is known to be NP-complete for relation schemes. This is why a solution might be the problem size minimization which can be done by different approaches combination. Firstly, all dependencies that do not participate in new keys generation are eliminated.Secondly, those keys that don’t participate in new keys generation are identified. Finally, is determined an order of application of functional dependencies over existent keys for new keys generation. All these processes reduce the size of the problem of searching of the unsynthesized keys and serve as base to obtain a polynomial algorithm for keys generation.