PostgreSQL’s Transaction Model
On Databases
Databases come in many forms. The simplest definition of a database is any system of storing, organizing, and retrieving data. With this definition,...
Creating a Simple Report using BIRT
Setting up a Simple Project
The first thing we want to do when setting up our simple report project is to define what the project...
Comparing Cursor and Set Approaches in Processing Relational Data
To give you an idea about cursor, the following DECLARE statement creates a cursor (named zero_bal_crs), which gives you access to the rows of...
ADO.NET Entity Framework
Creating an Entity Data Model
You can create the ADO.NET Entity Data Model in one of the two ways:
Use the ADO.NET Entity Data Model...
Building Queries Visually in MySQL Query Browser
MySQL Query Browser, one of the open source MySQL GUI tools from MySQL AB, is used for building MySQL database queries visually. In MySQL...
Setting up the most Popular Journal Articles in your Personalized Community in Liferay Portal
Personal community is a dynamic feature of Liferay portal. By default, the personal community is a portal-wide setting that will affect all of the...
Visual MySQL Database Design in MySQL Workbench
MySQL Workbench is a visual database design tool recently released by MySQL AB. The tool is specifically for designing MySQL database.
What you build in...
Query Performance Tuning in Microsoft Analysis Services: Part 2
MDX calculation performance
Optimizing the performance of the Storage Engine is relatively straightforward: you can diagnose performance problems easily and you only have two options—partitioning...
Query Performance Tuning in Microsoft Analysis Services: Part 1
In this two-part article by Chris Webb, we will cover query performance tuning, including how to design aggregations and partitions and how to write...
Customizing Page Management in Liferay Portal 5.2 Systems Development
Customizing page management with more features
The Ext Manage Pages portlet not only clones the out of the box Manage Pages portlet, but it also...
Must Read in Mobile
Understanding the Foundation of Protocol-oriented Design
When Apple announced Swift 2 at the World Wide Developers Conference (WWDC) in 2016, they also declared that Swift was the world’s first protocol-oriented...
