Stack Overflow
Stack Overflow

Questions tagged [physical-design]

25 questions
10
votes
10 answers

Alternative to forward declarations when you don't want to #include

I usually, almost without thinking anymore, use forward declarations so that I won't have to include headers. Something along this example: //----------------------- // foo.h //----------------------- class foo { foo(); …
sharkin
  • 12,162
  • 24
  • 86
  • 122
6
votes
3 answers

How does the `primary key` keyword relate to clustered indexes in SQL Server?

How does the PRIMARY KEY keyword relate to clustered indexes in SQL Server? (Some people seem to want to answer this question instead of a different question I asked, so I am giving them a better place to do so.)
bbadour
  • 616
  • 1
  • 4
  • 19
3
votes
1 answer

Refactoring tools for namespaces and physical project structure

When I hack around, some code tend to get much bigger than originally planned. As this happens I usually introduce/collapse/merge namespaces, move files between them, move folders etc etc. Sometimes, if I don't have a clear picture of the end…
simendsjo
  • 4,739
  • 2
  • 25
  • 53
3
votes
1 answer

Oracle's Bitmap Index in SQL Server

I've been successfully using bitmap indexes for years in Oracle environment. Now I'm working on a data warehouse project which will be hosted on SQL Server 2005. So far, I was unable to find an answer for bitmap like indexes in SQL Server. Any…
mevdiven
  • 1,902
  • 2
  • 17
  • 33
2
votes
2 answers

Structure of a Multi-column index in SQL server

Where can I find a good representation of the of how data is stored in pages and how the B tree is constructed for a multi-column index (specifically for SQL server, but not necessarily)? I'm referring to something like what you see in…
Ninjutshu
  • 53
  • 5
2
votes
0 answers

How to store skip lists on disk?

How do you store a skip list on disk? How do you arrange the nodes to take advantage of file system pages? Do you use a file for each page, one file for everything, or something else? The linked question mentions disk pointers - how do they…
johnfitzpatrick
  • 21
  • 3
2
votes
1 answer

teradata data block size and table size calculations

Been using this formula as a std for TB size calculation , as part of Cap. Planning effort . We are on TD 14 ( rc * ( rsz / ( blocksize -38) ) * blocksize ) + ( SQL (sel Hashamp()+1 ; ) * 1024 ) rsz : row size , rc : count ( * )…
user1874594
  • 2,277
  • 1
  • 25
  • 49
2
votes
3 answers

How can I create a model in Powerdesigner which can generate create script for different database?

I just want to create the model once, and then use it in any kind of database, without the need to modify the model. What I should do with the data type ? I found there is numeric and other kind of data types. What does that correspond to in mysql…
MemoryLeak
  • 7,322
  • 23
  • 90
  • 133
1
vote
3 answers

Should static database data be in its own Filegroup?

I'm creating a new DB and have a bunch of static data that won't change. If it does, it will be a manual process AND it will happen very rarely. This data is a mix of varchars and Geographies. I'm guessing it could be around 100K or so in total,…
Pure.Krome
  • 84,693
  • 113
  • 396
  • 647
1
vote
1 answer

Supertype/subtype Notation for ERD

This is more of a notation and 'proper procedure' type of question than anything. Please see below an image of a few relations in my Enhanced ERD logical model. A patient can be an OUTPATIENT or a RESIDENT, but there are no attributes which are…
RazelofHyrulez
  • 35
  • 7
1
vote
1 answer

Bluetooth 5 PHY layers (for all 4 modes)

I am researching Bluetooth 5 for work and I cannot find anywhere the PHY layer of the different bluetooth modes (LE 1M (legacy Bluetooth 4), LE 2M (Double the Speed), LE Coded scheme 2 (2 x Range) & scheme 8 (4 x Range). I know that LE 1M is IEEE…
standard_user937
  • 11
  • 1
1
vote
0 answers

showing description in powerdesigner

I have a physical data model in powerdesigner and want to show description for every fact and dimension and their attributes in the model. Following the powerdesigner add comment column in physical data answer, I have a column shows the description…
programmer21
  • 173
  • 11
1
vote
1 answer

How to build a relationship between multiple sub-entities and a list attribute?

The model of the (PHP & MySQL based) application I'm currently working on contains a inheritance similar to the one described here. Simplified for the purpose of this question the classes structure can look like this: To map this to the database…
automatix
  • 14,018
  • 26
  • 105
  • 230
1
vote
1 answer

Converting a logical model to a physical model. Trouble understanding ERD

I am working with an ERD. It is supposedly a logical model and I am to make a physical model from it. I should be formatting in UML and our DBMS is PostgreSQL. Some of my research (http://www.1keydata.com/datawarehousing/data-modeling-levels.html …
Captain Stack
  • 3,572
  • 5
  • 31
  • 56
0
votes
0 answers

Entity-Attribute Data Models (like MS Common Data Model) for Industrial Automation and Manufacturing domains

Are there other (well curated!) Entity-Attribute Data Models like Microsoft Common Data Model or Common Information Model that can help me accelerate application development for Industrial Automation, Industrial, Automotive, Machinery domains.There…
Rohit Raj
  • 1
1
2