Dimensiional Model based on PTA Database Design

Rule based algorithm to convert an ER model to a dimensional model

I recently came across two white papers by Moody/Kortnik that show how to use a rule based algorithm to transform an ER model to a dimensional model. I have made the papers available on my

Difference between Logical Data Modelling & ERD

What is difference between Logical data Modelling (LDM) & ER ? Whenever we ask LDM , the customer gives ER diagram.

Operational Reporting from a Dimensional Model

Having worked with various models over the years, i'm begining to think that a multi layered data model approach is best for medium and larger corporations. (see my IM model here

Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion

I've been dimensional modelling for well over 10 years, and strongly held the opinon that only a dimensional model would work for an EDW, however i'm now begining to think that there are certain requirements that lead to a 3NF design for an 'Enterprise

Bridge tables versus massive junk dimensions

I am designing a star schema to store information on hospital stays. This is my first real star schema and things are off to a good start. My fact table is hospital stays. I have a diagnosis dimension. There are multiple diagnoses per stay. Costs are

Dimension Design with Multiple Data Sources (ORACLE and SQL Server)

Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost

Dimensional Model Vs Views as Structure for BOBJ Universe

I have a fairly complex data mart (multiple fact tables: 5 at the moment and several more coming; 4 shared dimensions across the 5 facts, 26 total dimensions and several bridge tables). I used standard best practices for building the Business Objects

selenium with database testing

Hi, Can any one tell me how to test database with selenium as i am testing java application, pls give me some links or some examples as i am new to this testing,waiting for your quick reply.

Clean Database

When I finish watching an episode of a TV Show in XBMC, I sometimes delete it from the library. It will then ask if I also want to delete the video file, which I do. However, Media Companion still picks up the nfo (which was not deleted by XBMC) and

Dimension Modeling Design challenge - Help Needed

Guys, Help me out identifying whats wrong with my model. I am able to get to the right data, but size of the fact table is arguably high and not gladly acceptable. Let me show you the picture (tip of the iceberg) Data table in transaction db is

Draf Database Ahli TLRC

Assalamualaikum WBT. Di sini aku ingin mencadangkan agar kita mempunyai database semua ahli TLRC, tak kira divisyen mana mahupun berada di luar Terengganu. Tujuan dia utk mengetahui jumlah keahlian sebenar TLRC, dan jugok memudahkan proses penganjuran

Green CoW's Gallery

Hi there...Here's some stuff I've done. Most of them are fulfilled requests. (just showing off the stuff I already had uploaded) Hopefully you'll find something nice! GC's Resource Packs Shooter ImageSet (.CFG file not included) A free imagese

RP Basketball...The Road Back To World Championship 2010

Yeng Guiao is the best to coach the next National team, I hope he will include these players: the best line-up for me: Lordy Tugade James Yap Gabe Norwood Anthony Washington Kelly Williams Jared Dillinger Jimmy Alapag Jay-jay Helterbrand Asi