I've been on the periphery of dimensional data modeling for a while, while knee deep for years in traditional ERP relational models and a de-normalized data warehouse, and lots of SQL data analysis. I'm in a non big data environment.

I've never understood the purpose of (nor the mechanics) dimensional data models. Now that I read a few blogs, I can better ask my questions. Here's a good article and some pic's that helps clarify my perspective on the structure of a dimensional data model.


So,
- Am I correct that this data modeling technique is ultimately done for performance purposes ?

- So isn't this accurate: to get to the dimensional data model, the OLTP data is broken up, then ETL'd to the dimensional model, then to write reports, well, you bring it back together again ? As an outsider to dimensional data modeling, I've always said to myself, "why not just write the query against the OLTP ?" Because when I look at the dimensional data model I can't see how it's much different than a relational model. Using the example above, the fact table would be a relational table by simply storing the date of the transaction as opposed to a "date FK". Using this example, I just don't get it.

- Isn't this dimensional data model like fully normalized ? So to present this to the users, you have to write a traditional query ?

hi all,

other than Visio, any other DB  UML diagram tools you guy use to draw data modeling diagram without impacting the underlying database structure ?

Hello,

A while back, I installed an addon for World of Warcraft (WoW) which causes an audio alert to occur each time my character casts a Critical Strike. The addon is called CritSound and I downloaded it from here.

The addon works as expected but I don't like the default sound(s) -- which are human voice announcements. Instead  I'd like it to produce simple audio signals such as a bong or ding, etc. The addon does not come with alternate sound options but the author mentions how to add them in the description on the download page which I'm including here:

——————————————————————————————

plays a sound when you perform a critical hit or healing.
includes your physical damage ,spell damage, ranged damage, healing and your damage shield.
CritSound includes three mode:
1.single mode: always plays the first sound in the list.
2.sequence mode: plays the sounds in the list one by one when you perform a critical hit continually.
3.random mode: plays the sounds in the list randomly.
Use /cs or /critsound to open the controlpanel.
if you use the sequence mode, you can modify the aging time for collecting your critical hits.
you can edit CritSound.lua to delete or add sounds.
for example, in the line 5 to 11:
spell = {
            "CriticalDamage.ogg",    --first time
            "Dominating.ogg",        --second time
            "Unstoppable.ogg",        --etc.
           

…

I am using a mix of Archimate and Visio, neither of which are satisfactory. I want to be find an app that is a cross between these and AutoCAD (for layers) and PowerPoint (for animation/visualisation). A use case might be - there are 9 integrations between System A and System B which at a high level is shown as one line, click on the line and it breaks out into the 9 showing direction of data exchange with  details about what those integrations are etc. So rather like an AutoCAD drawing for a building I could see different layers and level of detail etc. TIA.

Hi

I am new to GIS but I am surprised when I find the following statement in a paper. Is thie following statements still valid or this is old. Please let me know. Thanks


While GISs provide some extensive tools for analysis of spatial data, their capabilities for spatio-temporal modelling, and hence the handling of temporal data, have been considered limited. GISs were formerly known to handle time or dynamic variations in a process poorly.  Adhering to this view,  GISs, with their standard functionality, do not explicitly allow dynamic processes to be captured and analyzed. GISs have been traditionally associated with maps, and the capabilities of a contemporary GISs represent map-related ideas of layers, projections and generalizations.

Hi All,

I have built a function that is too slow. I was wondering if anyone knew a way to speed up/ vectorize a for loop function by a factor of 5 or 10? Her name is "MakeVolumeBinIdx"

The purpose of my program is to bin my input data according to a fixed Volume size. So each row should have (almost) the same size volume .

My Input data is made of Date,Time, Price,Volume which is tick data (transaction per transaction) of a stock.
My output: Date,Time, Open,High,Low,Close,Volume (the volume should be almost equal for each candles or bins)

I have included the function's code, the program, the data set and the R files as well.
Also, I have a Hp laptop that runs on intel i7 and windows8.

Thank you in advance :)

The function I need major help with

MakeVolumeBinIdx<-function(data1.volume,volBinSize){
  ### PURPOSE: Find the indexes for a given size of volume bin, that is 
  ###            Find the indexes of the data.frame where the sum of the volume is equal
  ###             to the input volBinSize.
  ### INPUT: a vector of trades volume and the desired volume bin size
  ### OUTPUT: a vector indicating where each row belongs to which volume bin
  
  #create index
  volBin<-1
  sumVol<-0
  Volume<-data1.volume
  volBinIdx <- numeric(length(Volume))
  
  #create cutting for each volume bin
  for(i in seq_len(length(Volume))){
    sumVol<-sumVol + Volume[i]  
    if (sumVol<= volBinSize) {
      volBinIdx[i] <- volBin
    } else {
      volBinIdx[i] <-  

Select all Open in new window

…

I was wonder if someone could give me a  simple example of how to use BindableBase within a MVVM WPF project...

I need to implement an event when the DataContext is changed as I need to notify other classes that when they were initialized they they are null ?

Hi,

I am using C# and MS Access or MS SQL in my applications, and work with VS Studio 2013.

I worked before with Sybase PowerDesinger.

Now, I started my own business, and I need to find the best tool that can help me in this matter.

I found Enterprise Architect and some other tools.

Any suggestion about the best one for me.

Let's say you have module A, B, and C

Module C depends on module B and module B depends on module A.

When describing module B, I state that it's dependancy is module A. How do I describe module B's relationship to C? (the opposite of a dependancy)

Thank you for your help!

Drew

I am creating an ERD. I have 8 entities so far but I know I've got a long way to go. I think I want to split up orders and purchase orders but not sure in what way. Should I make 3 or 4 entities total out of the orders  and purchaseorders entities?

What else can I do to make this more realistic and correct?
erd.pdf

Greetings,

I have an EF application I want to deploy.  It runs fine obviously in the project directory. It has no dependencies/dlls.

However, every time I try to deploy the application I have connection issues I didn't have in Debug or Release mode on the development machine.

What is the work around here?  How exactly is this done.  Please, no articles that vaguely speak of one aspect of the issue without covering the complete solution.

Thank  you.