Efficient handling of bi-directional data

1. A method for standardized layout transformations of bi-directional (BIDI) data exchanged between legacy and modern systems, the method comprising:

responsive to a determination that data requested in a client request is BIDI data, initiating, by the one or more computer processors, a layout transformation of the data requested at a single point within a database server;

determining, by the one or more computer processors, a plurality of data from a connection string of the client request, wherein the plurality of data indicates a type of bi-directional data transformation, and wherein the type of bi-directional data transformation may be a transformation of visual data to logical data and logical data to visual data;

responsive to the plurality of data from the connection string indicating data being returned to the client application from a database, converting, by the one or more computer processors, visual data to logical data at the single point within the database server;

returning, by the one or more computer processors, transformed BIDI data to a client application; and

inserting, by the one or more computer processors, the transformed BIDI data into a database.

2. The method of claim 1 , further comprising:

determining, by the one or more computer processors, an operating system of a client application through one or more code pages utilized by the client application, where the one or more code pages indicate which modern operating system the client application leverages.

3. The method of claim 1 , further comprising:

determining, by the one or more computer processors, whether the data requested in the client request is BIDI data;

identifying, by the one or more computer processors, the data requested; and

determining, by the one or more computer processors, whether the data requested exhibits one or more bi-directional properties that indicate BIDI data.

4. The method of claim 3 , wherein determining whether the data requested exhibits one or more bi-directional properties that indicate BIDI data, further comprises:

determining, by the one or more computer processors, the data requested is BIDI data where the data requested exhibits layout properties indicative of BIDI data; and

determining, by the one or more computer processors, the data requested is not BIDI data where the data requested does not exhibit layout properties indicative of BIDI data.

5. The method of claim 1 , wherein initiating the layout transformation of the data requested at a single point within a database server, further comprises:

determining, by the one or more computer processors, a plurality of data from a connection string of the client request, where the plurality of data indicates a type of bi-directional data transformation; and

responsive to the plurality of data from the connection string indicating data being returned to the client application from a database, converting, by the one or more computer processors, visual data to logical data within the database server.

6. The method of claim 5 , further comprises:

responsive to the plurality of data from the connection string indicating data being inserted into the database from the client application, converting, by the one or more computer processors, logical data to visual data within the database server.

7. The method of claim 6 , further comprises:

inserting, by the one or more computer processors, the transformed BIDI data into a database.

8. A computer program product for standardized layout transformations of BIDI data exchanged between legacy and modern systems, the computer program product comprising:

one or more computer readable storage media and program instructions stored on the one or more computer readable storage media, the program instructions comprising:

responsive to a determination that data requested in a client request is BIDI data, program instructions to initiate a layout transformation of the data requested at a single point within a database server;

program instructions to determine a plurality of data from a connection string of the client request, wherein the plurality of data indicates a type of bi-directional data transformation, and wherein the type of bi-directional data transformation may be a transformation of visual data to logical data and logical data to visual data;

responsive to the plurality of data from the connection string indicating data being returned to the client application from a database, program instructions to convert visual data to logical data at the single point within the database server;

program instructions to return transformed BIDI data to a client application; and

program instructions to insert the transformed BIDI data into a database.

9. The computer program product of claim 8 , further comprises:

program instructions to determine an operating system of a client application through one or more code pages utilized by the client application, where the one or more code pages indicate which modern operating system the client application leverages.

10. The computer program product of claim 8 , further comprises:

program instructions to determine whether the data requested in the client request is BIDI data;

program instructions to identify the data requested; and

program instructions to determine whether the data requested exhibits one or more bi-directional properties that indicate BIDI data.

11. The computer program product of claim 10 , wherein program instructions to determine whether the data requested exhibits one or more bi-directional properties that indicate BIDI data, further comprise:

program instructions to determine the data requested is BIDI data where the data requested exhibits layout properties indicative of BIDI data; and

program instructions to determine the data requested is not BIDI data where the data requested does not exhibit layout properties indicative of BIDI data.

12. The computer program product of claim 8 , wherein program instructions to initiate the layout transformation of the requested data at a single point within a database server, further comprise:

program instructions to determine a plurality of data from a connection string of the client request, where the plurality of data indicates a type of bi-directional data transformation; and

responsive to the plurality of data from the connection string indicating data being returned to the client application from a database, program instructions to convert visual data to logical data within the database server.

13. The computer program product of claim 12 , further comprising:

responsive to the plurality of data from the connection string indicating data being inserted into the database from the client application, program instructions to convert logical data to visual data within the database server.

14. The computer program product of claim 13 , further comprising:

program instructions to insert transformed BIDI data into a database.

15. A computer system for standardized layout transformations of BIDI data exchanged between legacy and modern systems, the computer system comprising:

one or more computer processors;

one or more computer readable storage media;

program instructions stored on at least one of the one or more computer readable storage media for execution by at least one of the one or more computer processors, the program instructions comprising:

responsive to a determination that data requested in a client request is BIDI data, program instructions to initiate a layout transformation of the data requested at a single point within a database server;

program instructions to determine a plurality of data from a connection string of the client request, wherein the plurality of data indicates a type of bi-directional data transformation, and wherein the type of bi-directional data transformation may be a transformation of visual data to logical data and logical data to visual data;

responsive to the plurality of data from the connection string indicating data being returned to the client application from a database, program instructions to convert visual data to logical data at the single point within the database server;

program instructions to return transformed BIDI data to a client application; and

program instructions to insert the transformed BIDI data into a database.

16. The computer system of claim 15 , further comprising:

program instructions to determine an operating system of a client application through one or more code pages utilized by the client application, where the one or more code pages indicate which modern operating system the client application leverages.

17. The computer system of claim 15 , further comprising:

program instructions to determine whether the data requested in the client request is BIDI data;

program instructions to identify the data requested; and

program instructions to determine whether the data requested exhibits one or more bi-directional properties that indicate BIDI data.

18. The computer system of claim 17 , wherein program instructions to determine whether the data requested exhibits one or more bi-directional properties that indicate BIDI data, further comprise:

program instructions to determine the data requested is BIDI data where the data requested exhibits layout properties indicative of BIDI data; and

program instructions to determine the data requested is not BIDI data where the data requested does not exhibit layout properties indicative of BIDI data.

19. The computer system of claim 15 , wherein program instructions to initiate the layout transformation of the requested data at a single point within a database server, further comprise:

program instructions to determine a plurality of data from a connection string of the client request, where the plurality of data indicates a type of bi-directional data transformation; and

responsive to the plurality of data from the connection string indicating data being returned to the client application from a database, program instructions to convert visual data to logical data within the database server.

20. The computer system of claim 19 , further comprising:

responsive to the plurality of data from the connection string indicating data being inserted into the database from the client application, program instructions to convert logical data to visual data within the database server.