Questions tagged [dimension]

In physics and mathematics, the dimension of a space or object is informally defined as the minimum number of coordinates needed to specify any point within it. In the dimensional modeling, a dimension is a table in a star schema of a data warehouse. It is collection of reference information about measurable event. Dimensions categorize and describe data facts and measures in way that support meaningful answers to business questions.

Dimension table

A dimension is a table in a Star Schema or Snowflake schema of a data warehouse. It is collection of reference information about measurable event. These events are known as facts and stored in a fact table. Dimensions categorize and describe data warehouse facts and measures in way that support meaningful answers to business questions. They form the core of dimensional modeling.

Dimensions provide the "who, what, where, when, why, and how" context surrounding a business process event. Every dimension table has a single primary(surrogate) key. The primary key is embedded as a foreign key in any associated fact table. Dimension tables are usually wide, flat denormalized for analyzing data.

Links

782 questions
3
votes
1 answer

Can the dimensions of header area of JXTaskPane be changed?

I am using JXTaskPane component. I want to know whether one can change the dimensions of the top part of the task pane i.e. the area where title of the task pane is displayed. If yes, please let me know how?
Nayan Soni
  • 1,001
  • 3
  • 12
  • 22
3
votes
1 answer

A universal algorithm for filling an array

I have a code and it works for 3 dimensions, but I want to be able to specify the number of dimensions dynamically. There is a function nchoosek, but it creates an array of non-repeating elements. This is my code for 3D: energy_band=70; count=1; for…
3
votes
2 answers

Is there a way for Java to determine the size/dimensions of the command-line console it's running in?

Possible Duplicate: Can I find the console width with Java? For example, when you run nano at the Linux command line, it automatically resizes its text formatting to fit the display dimensions, even as you change them on the fly. I know it's a…
Syndog
  • 1,531
  • 4
  • 19
  • 27
3
votes
2 answers

Joining date dimension multiple times? - Kimball's book on Data warehouse and Dimension Modeling

I'm reading Ralph Kimball's book on Data warehouse and Dimension Modeling and in chapter 6, there is this part about dimension role playing. Sometimes you discover other dates associated with each transaction, such as the requested ship date for…
3
votes
1 answer

Transaction lifecycle tracking in data warehouse

How do you store facts within which data is related? And how do you configure the measure? For example, I have a data warehouse that tracks the lifecycle of an order, which changes states - ordered, to shipped, to refunded. And for a state like…
M.R.
  • 4,737
  • 3
  • 37
  • 81
3
votes
1 answer

Adding a new dimension to an existing Data warehouse

What is the standard practice for adding a new dimension (a totally new table, not a new row to an exisiting dimension table)? Wouldn't you have to redo the entire fact table, to add a new field, and then populate it based on the surrogate key in…
M.R.
  • 4,737
  • 3
  • 37
  • 81
3
votes
1 answer

How to reorder dimensions?

I am working on precipitation data. I need to rearrange dimensions in a NetCDF file. The dimensions in my file are in (time, lat, lon) order. I need them in (lat, lon, time) order. I tried the following: ncpdq -a lat,lon,time infile.nc outfile.nc …
Chane
  • 45
  • 7
3
votes
1 answer

What is the dimension/unit of the values given by PIL image.size

from PIL import Image im = Image.open('whatever.png') width, height = im.size In the above code what are the dimensions of width and height? I mean are they in mm,inches or something else? If I refer a pixel by coordinates (x,y) then what will be…
dushyant7917
  • 574
  • 7
  • 9
3
votes
2 answers

How to double the dimension of a matrix while quartering the values?

I want to achieve this: a = np.array ([[1, 2], [2, 1]]) b = np.array ([[0.25, 0.25, 0.5, 0.5], [0.25, 0.25, 0.5, 0.5], [0.5, 0.5, 0.25, 0.25], [0.5, 0.5, 0.25, 0.25]) Mathematically they…
Marcel H.
  • 85
  • 6
3
votes
2 answers

Opencv Python resize with one constant

I want to resize my image with given one edge's new length by using cv2.resize() method. For example my image has dimension 300x400, and I want to increase my height from 400 to 500 but I should write only one edge's new size(just 500), the other…
user70
  • 597
  • 2
  • 7
  • 24
3
votes
1 answer

R stack raster data through time dimension

I would like to know how can I stack different raster datasets through time dimension in R. Concretely: I have a set of ncdf files that contain rain data per month. I want to merge these datasets through the time dimension so that I have a unique…
3
votes
2 answers

Dimensionality Reduction

I am trying to understand the different methods for dimensionality reduction in data analysis. In particular I am interested in Singular Value Decomposition (SVD) and Principle Component Analysis (PCA). Can anyone please explain there terms to a…
Jim
  • 405
  • 1
  • 4
  • 6
3
votes
2 answers

Numpy : convert 2D array to 3D array

I have a 2 dimensional array : A = numpy.array([[1, 2, 3], [4, 5, 6]]) and would like to convert it to a 3 dimensional array : B = numpy.array([[[1, 2, 3], [4, 5, 6]]]) Is there a simple way to do that ?
user8182249
  • 83
  • 2
  • 7
3
votes
3 answers

Creating 4D numpy array by repeating values from 2D numpy array

I have a 2D numpy array, say array1 with values. array1 is of dimensions 2x4. I want to create a 4D numpy array array2 with dimensions 20x20x2x4 and I wish to replicate the array array1 to get this array. That is, if array1 was [[1, 2, 3, 4], [5,…
Gautam Sreekumar
  • 536
  • 1
  • 9
  • 20
3
votes
2 answers

How can I get 3D object dimensions in ThreeJS?

I'm developing an AR application using WebRTC (webcam access), JSARToolKit (marker detection) and threeJS (3D library). I want to place 3D objects (exported from Maya using threejs maya exporter) in the center of the detected marker. This is the…
Vig
  • 143
  • 6
  • 13