PRIORITIZATION OF DATA FROM IN-MEMORY DATABASES

1 . A computer-implemented method comprising:

determining, by a computer processor, column accesses to columns of at least one database table based on database queries accessing the at least one database table;

determining row accesses to rows of the at least one database table based on the queries;

assigning a priority to a column of a row from the at least one database table based on the determined column accesses of the column and the row accesses of the row; and

moving the column of the row from random access memory to hard disk based on the assigned priority.

2 . The method of claim 1 , wherein the at least one database table is entirely stored in random access memory until the moving of the column to the hard disk.

3 . The method of claim 1 , wherein the priority is assigned based on a frequency of the determined column accesses of the column and the row accesses of the row.

4 . A computer-implemented method comprising:

receiving a text condition entered by a user via a graphical user interface;

converting, by a computer processor, the text condition into a database query;

executing the database query to obtain results of the executed query;

identifying database records in at least one database table corresponding to the obtained results;

assigning a predetermined priority to the identified database records; and

moving the database records from random access memory to hard disk based on the assigned priority.

5 . The method of claim 4 , wherein the predetermined priority is received from the user via the graphical user interface along with the text condition.

6 . The method of claim 4 , wherein a conflict between the text condition and another text condition is resolved by comparing a timestamp of the text condition and a timestamp of the another text condition.

7 . An apparatus comprising:

a processor to:

determine column accesses to columns of at least one database table based on database queries accessing the at least one database table;

determine row accesses to rows of the at least one database table based on the queries;

assign a priority to a column of a row from the at least one database table based on the determined column accesses of the column and the row accesses of the row; and

move the column of the row from random access memory to hard disk based on the assigned priority.

8 . The apparatus of claim 7 , wherein the at least one database table is entirely stored in random access memory until the moving of the column to the hard disk.

9 . The apparatus of claim 7 , wherein the priority is assigned based on a frequency of the determined column accesses of the column and the row accesses of the row.

10 . An apparatus comprising:

a processor to:

receive a text condition entered by a user via a graphical user interface;

convert the text condition into a database query;

execute the database query to obtain results of the executed query;

identify database records in at least one database table corresponding to the obtained results;

assign a predetermined priority to the identified database records; and

move the database records from random access memory to hard disk based on the assigned priority.

11 . The apparatus of claim 10 , wherein the predetermined priority is received from the user via the graphical user interface along with the text condition.

12 . The apparatus of claim 10 , wherein a conflict between the text condition and another text condition is resolved by comparing a timestamp of the text condition and a timestamp of the another text condition.

13 . A non-transitory computer-readable medium embodied with computer-executable instructions for causing a computer to execute instructions, the computer instructions comprising:

determining, by a computer processor, column accesses to columns of at least one database table based on database queries accessing the at least one database table;

determining row accesses to rows of the at least one database table based on the queries;

assigning a priority to a column of a row from the at least one database table based on the determined column accesses of the column and the row accesses of the row; and

moving the column of the row from random access memory to hard disk based on the assigned priority.

14 . The computer-readable medium of claim 13 , wherein the at least one database table is entirely stored in random access memory until the moving of the column to the hard disk.

15 . The computer-readable medium of claim 13 , wherein the priority is assigned based on a frequency of the determined column accesses of the column and the row accesses of the row.

16 . A non-transitory computer-readable medium embodied with computer-executable instructions for causing a computer to execute instructions, the computer instructions comprising:

receiving a text condition entered by a user via a graphical user interface;

converting, by a computer processor, the text condition into a database query;

executing the database query to obtain results of the executed query;

identifying database records in at least one database table corresponding to the obtained results;

assigning a predetermined priority to the identified database records; and

moving the database records from random access memory to hard disk based on the assigned priority.

17 . The computer-readable medium of claim 16 , wherein the predetermined priority is received from the user via the graphical user interface along with the text condition.

18 . The computer-readable medium of claim 16 , wherein a conflict between the text condition and another text condition is resolved by comparing a timestamp of the text condition and a timestamp of the another text condition.

19 . A computer-implemented method comprising:

determining, by a computer processor, column accesses to columns of at least one database table based on database queries accessing the at least one database table, wherein the column accesses are determined from text of the database queries;

determining row accesses to rows of the at least one database table based on the queries, wherein the row accesses are determined from execution of the queries;

assigning a priority to a column of a row from the at least one database table based on a frequency of the determined column accesses of the column and a frequency of the row accesses of the row; and

moving the column of the row from random access memory to hard disk based on the assigned priority, wherein the at least one database table is entirely stored in random access memory until the moving of the column to the hard disk.