Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
-
Economics & Finance
Articles on Trending Technologies
Technical articles with clear explanations and examples
When to use LinkedList over ArrayList in Java
LinkedList should be used where modifications to a collection are frequent like addition/deletion operations. LinkedList is much faster as compare to ArrayList in such cases. In case of read-only collections or collections which are rarely modified, ArrayList is suitable.
Read MoreWhich one is faster Array or List in Java
The array is faster in case of access to an element while List is faster in case of adding/deleting an element from the collection.
Read MoreHow can we apply AUTO_INCREMENT to a column?
AUTO_INCREMENT means that the column will get the value automatically. To illustrate it we have created a table ‘employees’ as follows − mysql> Show Create Table employees\G *************************** 1. row *************************** Table: employees Create Table: CREATE TABLE `employees` ( `Id` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(35) DEFAULT NULL, PRIMARY KEY (`Id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 1 row in set (0.00 sec) From the above result set, we can see that column id is given the auto-increment option. Now, when we will insert the value in Name ...
Read MoreFunctions of Index server in SAP HANA system
Index Server is heart of SAP HANA system and is responsible for processing all SQL statements sent to HANA database. This server contains SQL/MDX Processing engine that is responsible to process and analyze data in HANA db.Index Server also contains Persistence layer for scalability and restoration of the system. In case of system failure, power failure or database corruption, Persistence layer is responsible for the restoration of HANA system to last save point.When you are running complex and large calculations, and there is a system failure Persistence layer is used to ensure that transactions are either fully executed or complete ...
Read Moreremove null value from a String array in Java
Following program creates an array with null values. Convert it a list with not-null values only and then get the array of that list.Exampleimport java.util.ArrayList; import java.util.List; public class Tester { public static void main(String[] args) { String[] array = {"I", null, "love", null, "Java" }; List values = new ArrayList(); for(String data: array) { if(data != null) { values.add(data); } } String[] target = values.toArray(new String[values.size()]); for(String data: target) { System.out.println(data + " "); } } }OutputI love Java
Read MoreWhat would be the effect on MySQL output if we have the combination of NULL and other values in the list of strings, provided as arguments in FIELD() function?
There will be a significant change in the output if we have the combination of NULL and other values in the list of strings, provided as arguments in FIELD() function. Following example will demonstrate it Example mysql> Select FIELD('good', 'Ram', 'is', 'good', 'boy'); +---------------------------------------+ | FIELD('good', 'Ram', 'is', 'good', 'boy') | +---------------------------------------+ | 3 | +---------------------------------------+ 1 row in set (0.00 sec) ...
Read MoreUsing different Engine types in SAP HANA
It will use both OLAP and Join engine. The join between the FACT and DIM will be executed in the OLAP engine and joins inside the attribute views will be executed in the JOIN engine so both the engines will be used.
Read MoreHandling failed transactions in SAP HANA system
In SAP HANA system, Session and Transaction Manager is responsible to keep track of all the executed transactions in HANA database. It includes both running transactions and closed transaction. When a transaction in HANA system is failed due to any reason, Transaction Manager informs corresponding engine to handle the error.Session Manager is responsible to manage open and closed sessions and to authorize all the transactions executed in HANA db.
Read MoreHandling user requests for applications based on HANA system
It consists of various components as mentioned above for processing of SQL statements from application users hosted on the top of HANA system.User requests via user interface/web browsers are sent to Web server hosting application which is communicated to SQL/MDX Processor in form of SQL queries. These are further segregated to different data engines in Index server according to query types.Session and Transaction Manager authorize SQL transactions and keep track of all the transactions either completed or running in the system.
Read MoreHow does the value of system variable max_allowed_packet affect the result of a string-valued function?
String-valued functions return NULL if the length of the result would be greater than the value of the max_allowed_packet system variable. Actually, max_allowed_packet is a dynamic global variable which can accept the integer type values. These values can be set for a session only. It can accept 1024 as the minimum value and 1073741824 as the maximum value. The by the default value of this system variable is 1048576.
Read More