Questions tagged as 'modelagem'

4
answers

What is the best way to represent an Address?

By modeling addresses in an application, I naively followed the standard form when representing in the DB (ie separate tables for country , status strong city , neighborhood etc - joins everywhere), and in the user interface (html) I p...
asked by 19.12.2013 / 01:04
4
answers

Type of the CPF or CNPJ field in the VARCHAR or INT database?

What type of CPF or CNPJ field in database VARCHAR or INT ? I've seen some posts suggesting to use INT to optimize performance in JOIN and filters. If you have 0 on the left, you can only complete it according...
asked by 22.01.2015 / 14:51
3
answers

What is the definition of the term coupling?

What is the meaning of the terms high / low coupling in object-oriented systems development or oriented programming to Objects (OOP) ?     
asked by 31.03.2014 / 15:10
7
answers

Agile methodologies - a single programmer

I've heard a lot about agile methodologies and I really liked the idea. Of course from what I have seen, the client needs to cooperate, but it seems to me that for my own projects (that is, whose idea is mine and not a client) these methodologie...
asked by 29.04.2014 / 13:40
1
answer

Alternatives to the (anti) standard Entity-Attribute-Value

I'm working on two systems that have a common characteristic: entities whose attributes are dynamic (ie can not be "hard-coded"), need to be queried in search operations (result filtering) , but are otherwise decoupled from the rest of the syste...
asked by 12.05.2014 / 08:25
2
answers

How to solve special situations of an unnatural value for a domain?

The question has a slightly more conceptual bias, so I'm going to use a simple generic example. There are cases where some column may be in special situation, this is because an information: is not available, is invalid at some point,...
asked by 11.09.2014 / 15:42
1
answer

What is the cardinality between a request and the services included in it?

I have class Solicitacao and class Servicos . After insertion into the database I want to retrieve in a query all the services associated with that request. For example, on one screen I insert the request and several services. Wh...
asked by 14.08.2015 / 16:18
2
answers

When and in which columns should you use indexes?

Reading an article that has nothing to do with database I came across the information that using indexes can bring great improvements to the performance of the database . I have two doubts about this: When should indexes be created and i...
asked by 22.07.2015 / 19:04
3
answers

When is the recommended use of composite primary key?

   A simple key is associated with a single value, or field, of the record. A compound key corresponds to the combination of two or more keys, and may be necessary to eliminate ambiguity, forming a unique identifier. ( Wikipedia ) Let's...
asked by 15.05.2014 / 14:21
1
answer

Inheritance in relational database

One of the great challenges in developing object-oriented software is to abstract the data from its object base in order to better manipulate it, nowadays the available ORM frameworks facilitate this abstraction a lot, the problem is when we begi...
asked by 06.10.2014 / 22:40