Web Application VS Windows Application

scottalanmiller

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.

IT-ADMIN

@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,

scottalanmiller

@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.

IT-ADMIN

the project is under construction, the entities will be added to this model by the time

scottalanmiller

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.

scottalanmiller

@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.

IT-ADMIN

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 ...

scottalanmiller

@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.

scottalanmiller

@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.

scottalanmiller

And of course systems like Google were totally dependent on non-relational technology to make them plausible.

IT-ADMIN

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,

scottalanmiller

@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.

IT-ADMIN

really i feel that you are from another planet, lol
but i'm very happy that i keep learning new things everyday from you, i'm sure if you come here Scott, you will see that there is a huge difference in level, and people will not understand you, lol

scottalanmiller

@IT-ADMIN said:

really i feel that you are from another planet, lol
but i'm very happy that i keep learning new things everyday from you, i'm sure if you come here Scott, you will see that there is a huge difference in level, and people will not understand you, lol

Are you kidding, where I am no one has a computer. The store here using a mechanical cash drawer!!

IT-ADMIN

come on,,,

IT-ADMIN

i'm just reading about MangoDB
http://www.tutorialspoint.com/mongodb/mongodb_overview.htm

do you know a good documentation about this ?? or the above link is good ??

scottalanmiller

@IT-ADMIN said:

come on,,,

I am very serious.

scottalanmiller

@IT-ADMIN said:

i'm just reading about MangoDB
http://www.tutorialspoint.com/mongodb/mongodb_overview.htm

do you know a good documentation about this ?? or the above link is good ??

We are recording this conversation on MongoDB If you search for MongoDB in titles in MangoLassi, you will find that I wrote up an install guide for it last week

MongoDB's own website is pretty decent for getting you started. However, you don't need to learn the database to use it. Many frameworks, like Meteor, use it by default and everything that you need to interact with it is built in. So you can focus on programming, instead of on designing databases.

scottalanmiller

One thing that is interesting about MongoDB is that it is built with an JavaScript interface and its native language is JSON.

IT-ADMIN

sometimes i say how people like you have time to even discuss in this forum, he could be hired by big companies like google or apple, and not wasting his time with people like me