Viewing profile — reaanb2

FCO-IM elegantly bridges the gap between data and language. Has anyone tried/compared SQL query generation based on that?

We had general-purpose graph databases before graph databases became a thing. I'm talking about relational databases. Values are the vertices, tuples are the edges, FK constraints …

[dead]

Trying to placate the gods who are busy destroying their world...

A better solution would be to move away from object-oriented domain modeling towards SQL-speaking entity-component systems.

That's a cool approach that could work well if you don't need realtime data validation such as in a UI. I would love to find a solution that allows the same validation rules to be …

I disagree. From a fact-oriented modeling perspective, relationships among entities are already well-modelled and represented in tables. There's a reason the relational model calls…

In my view, the O/R impedance mismatch derives from a number of shortcomings. Many developers view entities as containers of their attributes and involved only in binary relationsh…

See https://arxiv.org/abs/2312.00638 for one proposal to address this

In real life, insurance often doesn't pay for everything and service providers would need to support capturing both sets of info, not either one or the other. But that's beside the…

EF is limited to binary relationships: https://learn.microsoft.com/en-us/ef/core/modeling/relations... . When entities are mapped to rows and relationships to foreign key constrain…

"Object-relational mapper" is a misnomer, they should be called network data model to SQL mappers. They're not primarily for mapping between different arrangements of the same data…

If you don't pay for the product, you are the product.

> you need software to map the relations to objects If you start with a network data model perspective and build that into your system, then it follows that you'll want a network d…

Consciousness for me is tied to internal modeling of the world and oneself in it. An agent without an internal model is limited to reacting to immediate inputs, and constrained in …

How does this compare to a relational database, where hyperedges are represented by tables and vertices by values?

Systemantics by John Gall provides valuable perspectives into system effectivesness, efficiency and robustness.

A more appropriate name for ORMs would be "network data model to SQL mappers". They don't facilitate good OOP and oppose relational thinking and data management.

An OOP domain model in an information system is like trying to build a car using a roadmap instead of an engineering diagram. The value of OOP becomes clearer when used to decompos…

I've been looking for task tracking / planning software with some project management features, like the ability to decompose tasks into subtasks, estimate duration and priority and…