Code Monkey @tushroy - Tumblr Blog

Multidimensional database and star schema

Dimensional modeling (DM) names a set of techniques and concepts used in data warehouse design. It is considered to be different from entity-relationship modeling (ER) and doesn’t necessarily involve a relational database. Dimensional modeling is a design technique for databases intended to support end-user queries in a data warehouse. It is oriented around understandability and performance.

A…

View On WordPress

#OLAP

Writing better SQL in context of a programmer

Often developers / programmers mix object-oriented thinking with imperative thinking depending on their levels of skill, dogma and mood. But when programmers write SQL, everything changes. SQL is a declarative language that is closer to natural language and has nothing to do with either object-oriented or imperative thinking. It is very easy to express something as a SQL query like we do in…

View On WordPress

#sql

Dynamic Code Integration with .NET System.CodeDom

If we are building some sort of script executor/runner or SQL code executor we may need to have some dynamic code along with static codes. Such as if we have an SQL script executor which executes SQL from reading SQL script from a file (which may be serialized or can be read as a normal file), we may need dynamic data along with static data. For example consider the following SQL.

"SELECT userid…

View On WordPress

ল্যামডা এক্সপ্রেশন সহজ পাঠ

ল্যামডা এস্প্রেশনকে অনেক সময় এননিমাস ফাংশন এর সাথে তুলনা করা হয় যদিও ল্যামডা এক্সপ্রেশন হল এমন ফাংশন যার কোন আইডেন্টিফায়ার নেই। এগুলো ইনলাইন অথবা সিঙ্গেল লাইন ফাংশন হয়ে থাকে। সি শার্পে => অপারেটর ল্যামডা এক্সপ্রেশনে ব্যাবহার করা হয়ে থাকে। এই => অপারেটর ল্যামডা এক্সপ্রেশন এর প্যারামিটার আর স্টেটমেন্ট বডিকে পৃথক করে। একটা ল্যামডা এক্সপ্রেশন সাধারনত নিচের ফরম্যাট এর হয় (ইনপুট প্যারামিটার) => { ফাংশন…

View On WordPress

#C #csharp #lamdba experssion

"Porodeshi Megh jao re fire Boli o amar porodeshi re... " Tune & Lyric- Kazi Nazrul Islam Vocal & Music- Miftah Zaman

#SoundCloud #Miftah Zaman #Nazrul Song

Variables in android strings.xml

Variables can be used in the strings defined in strings.xml using the c programming like printf ’%d’ syntax. This is because getString (int resId, Object… formatArgs) passes the string through Formatter. First define a string in the strings.xml file (usually res/values/strings.xml).

[xml] <string name="unread_messages">You have %d unread messages.</string> [/xml]

This string has a variable %dth…

View On WordPress

#android #strings #xml

Discover extras from android intent

If you are catching some unknown intent in your activity, there is simple way to discover which extras are available with the following codes. [java] Bundle extras = getIntent().getExtras(); Set<String> ks = extras.keySet(); Iterator<String> iterator = ks.iterator(); while (iterator.hasNext()) { Log.d("KEY", iterator.next()); } [/java]

View On WordPress

#android #intent

Phone's last known location using LocationManager (android)

Phone’s last known location using LocationManager (android)

This is a fast code to get the last known location of the phone. If there is no exact gps-information it falls back to the network-based location info. This code is using LocationManager.

[java] private double[] getGPS() { LocationManager lm = (LocationManager) getSystemService(Context.LOCATION_SERVICE); List providers = lm.getProviders(true);

/* Loop over the array backwards, and if you get an…

View On WordPress

Double back press exit android app

Sometimes it is required to block accidental back press on android app. The following code snippet helps to block accidental back press, It also helps to exit the app by double back pressing. Get back press work only at second press and notify user to press again to exit use the following snippet of codes. [java] private static long back_pressed; @Override public void onBackPressed(){ if…

View On WordPress

#android #code snippet

#eclipse #java

জানি দেখা হবে...

Android NDK Development with Genymotion Emulator

Genymotion / AndroVMis an android emulator built on x86 and Virtualbox. So it’s performance is way better than the Android default SDK Emulator. However in their latest update they’ve removed both ARM Translation and Google Play Apps. The removal of ARM…

View Post

#fast emulator #genymotion #NDK

Birthday wish in Java style - a java sound example

The Java Sound API can be used for controlling audio playback, audio capture, MIDI synthesis, and basic MIDI sequencing. The following example shows how to use Java MIDI synthesizer in its simplest form.

[java] import javax.sound.midi.*;

public class…

View Post

#java #jfugue #midi