Web Application VS Windows Application
-
our first model is the following, after that we gonna add more entity by the time
by the way it is only the payroll model of our application
-
as far as i can see, the modern way is not to begin with modeling, isn't it??
-
@IT-ADMIN honestly, that doesn't look like it should be relational at all. This is a prime candidate for not being relational. Who suggested relational?
-
@IT-ADMIN said:
as far as i can see, the modern way is not to begin with modeling, isn't it??
No, the modern way is not to model it at all. The framework models it for you.
-
If you do your own modelling and them try to use an ORM, that causes a ton of extra work, defeats much of the purpose of the modern systems and can easily introduce performance problems.
-
why it should not be a relational DB, ??
-
all entities are related to each other,
-
@IT-ADMIN said:
why it should not be a relational DB, ??
Because relational is not the default choice. Relational is heavy weight and slow. Extra effort, extra problems. If you don't need it, it's not good for you.
Nothing in the data that you has leverages a relational system really. It's perfect as a document.
-
@IT-ADMIN said:
all entities are related to each other,
Yes, of course, but not in a way that suggests that a relational database is valuable. You have modelled the data correctly to use a relational database for it, but a relational database is incredibly inefficient here and unnecessarily strict. You aren't getting any benefits from the relationships. And as another thread covered... all data is relational. By the "rules of relationships" every CSV is relational data. That the data is "relational" is meaningless. It's that it is not useful in a relational database that matters. All databases have relationships.
-
@scottalanmiller said:
@IT-ADMIN said:
why it should not be a relational DB, ??
Because relational is not the default choice. Relational is heavy weight and slow. Extra effort, extra problems. If you don't need it, it's not good for you.
Nothing in the data that you has leverages a relational system really. It's perfect as a document.
lol, you can't be serious, how we can know a specific card to whom it belong,
i'm really in a state of lose, -
@IT-ADMIN said:
lol, you can't be serious, how we can know a specific card to whom it belong,
i'm really in a state of lose,Card meaning, like passport? Well it depends what you use. But if you use a document database like MongoDB, you would either know that it was theirs because it would be contained within their document. Or you would have a key that associates them.
You are confusing the idea of data that relates to other data and the usefulness of a relational database. They are rather different things.
-
the project is under construction, the entities will be added to this model by the time
-
Look at the post that you just wrote. The post is associated with you, right? The post and you have a relationship. Yet MangoLassi has no relational database. So clearly relationships in data are not lost by not using a relational database. You don't choose a relational database model because your data has relationships. Remember most systems should not be relational, but all data has relationships.
-
@IT-ADMIN said:
the project is under construction, the entities will be added to this model by the time
But just like the passport, you would just add them in the user's document. Your data is really ideal for a document database.
-
really i have to learn about this point, because we have learned from the time of university one type of DB, relational DB, what are you saying is the first time i hear it, i have to take some time to contemplate about this, i will check my papers and i will resume
to be continued ...
-
@IT-ADMIN said:
really i have to learn about this point, because we have learned from the time of university one type of DB, relational DB,
I've was building NoSQL systems for the Fortune 100 in the late 1980s while still in middle school. They aren't new. But the popular use of them is pretty new for the mainstream.
NoSQL has been a major topic this past decade. It's huge. It's the most basic consideration in data storage today. If you have heard of MongoDB, Cassandra, Redis, LocalDB (part of MS SQL Server), CouchDB, LayerDB, DynamoDB, MS Azure Tables, MS Azure DocumentDB, Freebase, InfinityDB, ElasticSearch, Amazon SimpleDB, Solr, Dynamo, Oracle NoSQL, Riak, BDB, Memchache, BigTable and hundreds of others... those are not relational.
NoSQL is so important that MS SQL Server, PostgreSQL, DB2, Oracle and many other traditional DRBDM offer NoSQL options under the hood, too.
-
@IT-ADMIN said:
what are you saying is the first time i hear it, i have to take some time to contemplate about this, i will check my papers and i will resume
Several of the projects in this community this past week have been non-relational. All logging projects like ELK and Graylog use NoSQL databases, for example.
-
And of course systems like Google were totally dependent on non-relational technology to make them plausible.
-
i have to admit that i'm totally ignorant about this, lol
i'm just reading about this, from the time we were at school, we know only one thing : SQL when it comes to MDBS, we never learn or heard about this NoSQL DB, but to be honest it is shameful,
-
@IT-ADMIN said:
i have to admit that i'm totally ignorant about this, lol
i'm just reading about this, from the time we were at school, we know only one thing : SQL when it comes to MDBS, we never learn or heard about this NoSQL DB, but to be honest it is shameful,
I was lucky, I skipped the college thing so had a lot more chance to learn more
For your needs, I think that very likely MongoDB will work really well. Very easy to code against, very fast.
I know that you want to do PHP, but check out Meteor.js.
