Actian Community Blogs

.NET Data Provider version 2.1.xxxx.24, where xxxx is 930, 1000, or 1010, introduced in Ingres 9.3, provided the ability to target the Multiple Data Access Servers functionality added in Ingres 9.3. A .NET Data Provider client may target a connection to multiple Data Access Servers by providing a list of ports in the IngresConnection.ConnectionString connection :
or
...

Beginning with ODBC driver version number 3.50.930.0099, the ODBC driver was enhanced to support the DBMS scrollable cursor functionality introduced in Ingres 9.2. For more information, see the Connectivity Guide.

Ingres 9.3.1 introduced a performance improvement to the ODBC driver beginning with version 3.50.xxxx.0110, where xxxx is 930, 1000, or 1010. In certain scenarios, the chatter between the ODBC driver and the DBMS was significantly reduced, resulting in performance gains...

JDBC driver version 3.8.0, introduced in Ingres 9.3, provided the ability to target the Multiple Data Access Servers functionality added in Ingres 9.3. A JDBC client may target a connection to multiple Data Access Servers by providing a list of ports in the JDBC connection URL string:

Note: {} indicate elements that are optional and may be repeated.

In addition, multiple hosts and port lists may be specified,...

Ingres 9.3 introduced a new port address calculation scheme that utilizes some of the unused bits in the 16-bit port value used in Ingres 9.2 and earlier. This increases the allowed number of Ingres Net Servers (IIGCC) and the Data Access Servers (IIGCD) using the TCP/IP protocol to a combination of 16 servers. The algorithm is structured so that:

• Net-enabled servers (IIGCC and IIGCD) can potentially have a startup count of 0–16.
• Subports within the range 8–15 map to a different range

...

Making people happy

So, the first thing to know is, data warehouse is supposed to make the end users happy. One could feel bad about being man in the middle, or even worse - the warehouse technical support, but this doesn't matter. It's the end user who has to be happy. So, happy about what? Well, if he gets answers he needs, we assume, he's happy. Nevertheless I would really like to make an opposition here. For example, "can I have some data about users that satisfy these conditions?"...