Re: Possible bridges between OO programming proponents and relational model

Cimode ha escrito:

One of the main current flaws of current SQL DBMS systems is their
incapability to implement the multidimensionality of relvars.

This does not make any sense, the dimension of a relvar is the number
of attributes.

The main
reason seems to be the lack of independence between the physical layer
and logical layer the represent the data. In several DBMS tuples are
right away on disk projections imposing that all tables are considered
bidimensional.

The only way to do this is to force all logical tables to have two
attributes.

In fact, it should not be the case because a
bidimensional RTable is only a *representation* of some entity. An
interesting analogy that may help communication, is Rubi's Cube (3
dimensional): looking at one face of the cube it's only one possible
representation of the cube (being the relvar)

I suppose that you know how to represent a cube with a table.

some insight (flamers please refrain) onto how OO mechanism may help
separate the logical operation (in memory) from physical layer...

Are you suggesting that the memory is less physical than the disk?


Regards
Alfredo

.

Relevant Pages

  • Re: Strange processing error.
    ... I've a sneaking suspicion that this may be down to memory, ... Analysis Services previously (especially when trying to share a box w/ a SQL ... There are around 7-10 dimension connected / measure group. ... cube Analysis Services Execute DDL Task ...
    (microsoft.public.sqlserver.olap)
  • Re: Possible bridges between OO programming proponents and relational model
    ... relvar, just a possible representation of a relvar. ... implemented SQL DBMS Tables are bidimensional. ... I said that a face of a cube is ... This does not make any sense, the dimension of a relvar is the number ...
    (comp.databases.theory)
  • MOLAP
    ... if I create a MOLAP partition all the aggregates and fact data is loaded ... into memory. ... Is that cube then fully functional when I remove the dimension ...
    (microsoft.public.sqlserver.olap)
  • Re: Analysis Manager Operations extremely slow
    ... both RDBMS SMO and Analysis Services ... testing domain authentication. ... cube editor slowness if connecting to Oracle. ... Gender dimension to "M" and still browse the Sales cube. ...
    (microsoft.public.sqlserver.olap)
  • Re: Automatic MOLAP questions
    ... there is a lock when the polling query is evaluated. ... when you execute a polling query, the result of the query and the previous datetime can be used to do an incremental processing. ... so an incremental process only add content in a cube and can't update the cube. ... SSAS will not try to process the dimension. ...
    (microsoft.public.sqlserver.olap)