Some databases store objects, relational structure of tables, hierarchies, etc. What are all these types (models)? When is the application of each one indicated (besides, of course, the developer preference)? Examples of each?
Let's say I want to model an application in .NET using EntityFramework as ORM and use one of its advantages, be "generic" for several RDBMS .
So, for example, I want my application to accept working with Firebird ,...
I want to save a set of information about movies in a database but I have a question, should I organize the genres in a column (example below).
Database: MySQL 5.6.21
Engine: innoDB
Or arrange the genres in a separate table and use...
I'm modeling a C # interface that has a property. However, I want to ensure that all classes that implement this interface keep the setter as private:
public interface IBar
{
string Id { get; private set; }
}
This code does not comp...
I do not have much knowledge in database design. I have tried to hone myself better and am looking for best practices on how to create and structure tables.
I currently create binding tables and combine the ID's of each table by turning the...
I would like a working example, as I do not quite understand this dynamic relationship of creating a type table, with a data table, a dynamic relationship, which many find confusing.
Is there a way I can assign something to a column in MySQL so that when I perform the query I select them?
SELECT filtro_1,filtro_2,filtro_3 FROM filtros
But if the table is changed (like adding a new filter, now the filtro_4...
I hypothetically have a publicação table that has, by default, the autores attributes (derived from a relationship table), titulo , edição , editora and ano . However, depending on the type of publication (...
I think this question is more about modeling analysis actually do not know if it fits into the standard questions discussed by meta.pt.stackoverflow.com . I need to make my system in a way that almost everything will have user permissions, I ma...
I would like to know how to create a .arff executable file to use in weka. I remember that I am mining text. My file is experiencing errors and I'm not getting results.
Following is a piece of the file:
@relation texto
@attribute mes...