Questions tagged [physical-design]

25 questions
0
votes
1 answer

Sourcing proc tcl leads to an error Options -guard_band or -target_utilization is not allowed for gas-station Voltage Area. (NDMUI-415)

While sourcing the tcl script in ICC2_shell `proc vol_area_creation {pd_name blockage_name gb_region} { set bbox [get_attribute [get_placement_blockage $blockage_name] bbox] set llxn [expr [lindex $bbox {0 0}] + $gb_region] set llyn…
0
votes
0 answers

How to change this from (Tile order - Row major) to (Tile order - column major). Cell order-row major will stay the same

enter image description here that's the problem here. I am new to this and I don't know how to do it.
0
votes
1 answer

How many rows can fit in a datafile in PostgreSQL?

I have a table with one column in a tablespace in PostgreSQL. This resulted in 3 data files as seen in the image below. To test where the data stores, I added one row with only one value in my table, and the datafile '49565' went from 0kb to 8kb. I…
Sara Cobos
  • 11
  • 1
0
votes
1 answer

Frictionless pendulum using Rope resource from AS3 Fisix engine

I'm developping a gameplay concept using AS3 Fisix engine in which I need for a pendulum to be frictionless. The idea is to define the head and tail positions (using the Fisix's Rope resource) by mouse clicking and dragging in the screen and let the…
rdonatoiop
  • 1,185
  • 1
  • 14
  • 28
0
votes
1 answer

Generate Erwin with Microstrategy 9+

I'm working on documentation of my reporting project and I need to include a graphic of the physical model. I know that there's a way to generate an erwin from Microstrategy with the entire model tables and their relations, but I'm a newbie and I…
Mariela
  • 134
  • 2
  • 13
0
votes
1 answer

Virtual server and Physical storage for SQL Server

We are migrating server from P2V but my server team is asking if we need an virtual server with physical storage drives. What's the benefit of having a virtual server and physical drive for SQL Server? Never heard of this setup
Raja
  • 58
  • 1
  • 1
  • 6
0
votes
2 answers

Oracle partitioning and local Indexex (12c)

I have a table created which is partitioned by year and I have the below two local non unique indexes created on the table idx1 : (year, wk, pd, sku) idx2 : (sku, str ) My undersatnding is that idx2 is redundant and and you could just create one…
sria
  • 35
  • 2
  • 10
0
votes
0 answers

In SQL Server would misc pages be pushed out when an object grows within a mixed extent?

In SQL Server 2008-2012, objects (including tables) are first put in a mixed extent. An extent can accommodate up to 8 pages and accommodates more than one type of page (meaning: pages from more than one object). Say ExtentA has pages from objects…
LearnByReading
  • 1,813
  • 4
  • 21
  • 43
0
votes
0 answers

physical model data types

I'm trying to convert a logical model to a physical model and I saw an example here http://www.1keydata.com/datawarehousing/data-modeling-levels.html which doesn't have null or not null. Next to the data types, does null or not null need to be in a…
Ris
  • 1,892
  • 9
  • 26
  • 43
-1
votes
1 answer

Create MongoDB document without values

I have a basic question about creating a physical schema of a collection in MongoDB. Can I create a MongoDB document without values. At this point I just know the keys and some data types. But I do not have the values. Is it possible to create a…
Aurobindo
  • 11
  • 5
1
2