Jump to content

Calling Sql Server Guys ----Analysis Service Database


mastercheif

Recommended Posts

Analysis serevice database ante yeminit ? Idi manam database ga attach chesi add chesukovaccha ?

 

db extenstion .database ani undhi, like ETLTEST.database

Link to comment
Share on other sites

datawarehouse database adi................ 

 

db engine lo database.(OLTP DB)............

 

analaysis serivce conect ayaka.. akkada datawarehouse database(OLAP DB) 

 

 

difference between OLTP and OLAP neku telusukunta.. if not, google lo chudu. then u wil get a idea.. 

Link to comment
Share on other sites

datawarehouse database adi................ 

 

db engine lo database.(OLTP DB)............

 

analaysis serivce conect ayaka.. akkada datawarehouse database(OLAP DB) 

 

 

difference between OLTP and OLAP neku telusukunta.. if not, google lo chudu. then u wil get a idea.. 

ardam kaledu bro... please brief it more 

Link to comment
Share on other sites

Analysis service database is nothing but a OLAP Cube which is tied to its own facts and dimensions man...

 

manam regular relational database ni ela aitey SQL Query use chesi query chestaamo , Analysis services database ni MDX use chesi query chestaam...

 

Relational Engine use chestaam regular databases ki in the same way we use analysis services engine to use this database.

Relational database .MDF (Master Data File) lo store avutundi where as Analysis Services Database .Database format lo save avutundi man...

 

Based on its storage engine type (MOLAP, HOLAP, ROLAP)  data is defined in either Cache / direct database level man...

Link to comment
Share on other sites

×
×
  • Create New...