c# - Drawing Many Objects to Screen -

-

i'm working on project in need summarize substantial amount of data in form of heat map. data kept in database long possible. @ point, need store summary in matrix (possibly?) before can draw blocks heat map screen. creating windows form application c#.

let's assume heat map going summarize log file online mapping program such google maps. assign color particular address or region based on number of times request made region/address. can summarize data @ differing levels of detail. is, each block on heat map can summarize data particular address (max detail, therefore billions/millions of blocks) or can summarize requests street, city, or country (minimum detail -- few blocks each represent country). imagine millions of requests made addresses. have considered summarizing database. problem need draw many blocks screen (up billions, less). let's assume data summarized in database table stores number of hits larger regions. can draw blocks window without constructing object each region or bringing in of information db table? that's primary concern, because if did construct matrix, around 10 gb demanding request.

i'm curious know how many blocks can draw screen , best approach may (i.e. direct3d, xna). above, can see range vary substantially , expect potential billions of squares need drawn. have vertical scroll bar scroll down see other blocks.

overall, i'm wondering how might accomplish c#? creating matrix demanding request require around 10 gigabytes. there way draw screen not require substantial amount of memory (i.e. creating object each block). if have results of sql query translated directly rendered blocks on screen, ideal (i.e. not constructing objects, etc etc). need squares , property color , might need maintain number each block.

note: pretty sure how draw heat map (how zooming, scrolling, etc should appear user). clarify, i'm more concerned how implement our idea. there library or method allows draw many objects without constructing billion objects , using gigabytes of data. each block group of pixels (20x20) same color. don't believe should necessitate constructing 1 billion objects.

thanks!

if graphic heat map, agree comments image that's @ least 780 laptop screens wide impractical. if have information in sql(?) database somewhere, can fancy query partitions results buckets of widths. database should able aggregate these records 1680 (pixels wide) buckets efficiently.

furthermore, if buckets of fixed width (yielding fixed width heat-map image) pre-generate bucket numbers "addresses" in database. indexed properly, grouping fast.

if need see 1:1 image, might consider rendering section of image you're scrolled to. reduce amount of memory necessary store current view. assuming don't need view 780 screens worth of data @ 100% (especially if couple "big picture view" strategy above) you'll save on processing too.

the aggregate function "big picture view" might max, sum, avg. if these functions aren't appropriate, please explain more particular features you'd looking in heat-map.

as far drawing itself, don't need "objects" each box, need draw pixels on graphics object.


Comments

Post a Comment

Popular posts from this blog

c# - How to set Z index when using WPF DrawingContext? -

-
how set z-index drawing object when using drawingcontext.drawxxx() methods? the object drawn last have higher z index. can't change index of drawn objects. way draw in order. if using wpf (as placed tag), can use, example, canvas control. create shapes need like polyline obj = new polyline(); //... // ... set properties of obj and add them canvas uielementcollection: yourcanvasname.children.add(obj); //or yourcanvasname.children.insert(i, obj); first items of collection have higher z index. advantages in way: no need redraw on window changes, can anytime move objects , change order.
Read more

razor - Is this a bug in WebMatrix PageData? -

-
i think may have found bug in webmatrix's pagedata, not sure. concerns how pass data partial page calling page. in webmatrix documentation (tutorials, e.g. " 3 - creating consistent look ", , example code), pagedata recommended mechanism pass data between pages (e.g. content page layout page, or partial page). however have found not work other way, pass data partial page calling page. modifying or adding entries in pagedata in partial page, not seem calling page. cutting right down simplest possible example, in test page may have this: @{ pagedata["test"] = "initial entry"; } <p>before calling partial page, test value @pagedata["test"]</p> @renderpage("_testpartial.cshtml") <p>after returning calling page, test value @pagedata["test"]</p> and in _testpartial.cshtml page might have this: @{ pagedata["test"] = "modified entry"; } <p>in partial page...
Read more

visual c++ - Using relative values in array sorting ( asm ) -

-
i need sort through array , sort each individual row in array in ascending order. doesn't seem going (surprise!) keep getting hit 2 errors: a2101: cannot add 2 relocatable labels , a2026: constant expected here's sort, makes sense me, think i'm still trying implement high-lvl language techniqes assembly. there way around not being able use relative values? (the array 7 rows 9 columns, btw). mov cx, 7; cx = number of rows outer: ; outer loop walk through rows push cx mov cx, 9 mov row, cx ;rows middle: ; middle-loop walk through columns push cx sub cx, 1 ;cx = cx-1 mov column, cx ;columns inner: ;inner loop - compare , exchange column values cmp marray[row*9 + column], marray[row*9 + column+1] xchg marray[row*9 + column+1], marray[row*9 + column] ; compare , exchange values marray table inc column loop inner pop cx loop mid...
Read more