Why creating a new MDX language instead of extending SQL?

I have a long experience with SQL, but recently began working with datawarehouse and OLAP technologies: building fact and dimension tables, that then are queried using MDX (MultiDimensional eXpressions).

Set modified date = created date or null on record creation?

I’ve been following the convention of adding created and modified columns to most of my database tables. I also have been leaving the modified column as null on record creation and only setting a value on actual modification.

How do you handle objects that need custom behavior, and need to exist as an entity in the database?

For a simple example, assume your application sends out notifications to users when various events happen. So in the database I might have the following tables:

One codebase – lots of hosted services (similar to a basecamp style service) – planning structure

We have built a service (PHP Based) for a client, and are now looking to offer it to other clients as a hosted service. For this example, think of it like a hosted forum service, where a client signs up on our site, and is given a subdomain or can use their own domain, and the code picks up the domain, checks it against a ‘master’ users table, and then loads the content as needed.

Real-Time Multi-User Gaming Platform

I’m considering developing a real-time multi-user game, and I want to gather some information about possibilities before I do some real development. I’ve thought about how best to ask the question, and for simplicity, the best way that occurred to me was to make an analogy to the field (or playground) game darebase.

Which design better when use foreign key instead of a string to store a list of id

I’m building online examination system. I have designed to table, Question and GeneralExam. The table GeneralExam contains info about the exam like name, description, duration,…

What is an appropriate way for managing a MySQL connection through C#

My question, at the bottom line, is what is the appropriate(best) way to manage our connection towards MySQL db with C#.

A little code to allow word substitution depending on user

I’m creating a demo web app in html in order for people to physically see and comment on the app prior to committing to a proper build.

Android Card Game Database for Deck Building

I am making a card game for Android where a player can choose from a selection of cards to build a deck that would contain around 60 cards. Currently, I have the entire database of cards created that the user can browse.

What is the best strategy for licensing a desktop application using a web service, when all I need to know is when people use the product?

Our company’s main application is a desktop program that is used at warehouses and written in C# and Windows Presentation Forms.