BookmarkSubscribeRSS Feed
twocanbazza
Quartz | Level 8

Hi.

So We have been proposed a Dimensional modeled Data Warehouse, and I was wondering if anyone is using SAS WRS to access Star schema's and what the perfomance was like, and any tips and tricks were out there to handle this.

Cheers

Barry

2 REPLIES 2
LinusH
Tourmaline | Level 20

It's very hard to give general suggestion on optimization. But nevertheless, I'll try.

The Base and SPDE engines gives reasonable performance, even if they do not offer specific star schema optimization. SPD Server and other 3rd party databases do.

Historically, by placing an information map on top of a star schema really downgraded performance. In later versions they have improved - you need to test on your data to make sure if it will work for you.

Star schemes a very good as input to OLAP cubes. They offer when well configured very good performance, and can be accessed directly by WRS.

Good luck!

Data never sleeps
FrankBoekamp
Calcite | Level 5

If you use MS SQL Server for your data storage you could try experimenting using Column Store Indexes in SQL Server 2012...

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 1100 views
  • 3 likes
  • 3 in conversation