DBMS Publications Project



In this project, we had a set of questions to get the specific data from the PostgreSQL database. We used some advanced SQL operations in order to increase accuracy and performance. You can check out the SQL codes and the project description from my GitHub page.

Comments

Post a Comment

Popular posts from this blog

Computer Graphics - Depth Buffer Test

Image
Depth Buffer (Z-buffer) Test Algorithm The following algorithm is taken from  here . We start with setting the depth of each pixel to infinity. d(i, j) = infinity Initialize the color value for each pixel c(i, j) = background color for each polygon, do the following steps : for (each pixel in polygon's projection) { z (depth) of polygon at (x, y) corresponding to pixel (i, j) if (z < d(i, j)) { d(i, j) = z; c(i, j) = color; } } Example Figure  An example taken from METU CENG Slides Z-Fighting Z-fighting occurs when two planes have the same depth (have the same value in the z-axis) and z-buffer cannot decide which plane is near which one is far. Then the following situation occurs: Z-fighting in the intersection  This situation may occur also when the depth range [nearest, furthest] is scaled to [0,1]. This is range [0,1] scaling from [near=10, far=50] after projection and viewport transformations. T...
Read more