{"id":6664,"date":"2022-03-18T12:41:16","date_gmt":"2022-03-18T12:41:16","guid":{"rendered":"http:\/\/itdconsulting.com\/sybase-iq-y-sybase-ea-server\/"},"modified":"2022-06-13T12:23:52","modified_gmt":"2022-06-13T17:23:52","slug":"sybase-iq-y-sybase-ea-server","status":"publish","type":"page","link":"https:\/\/itdconsulting.com\/en\/base-de-datos\/sybase\/sybase-iq-y-sybase-ea-server\/","title":{"rendered":"Sybase IQ y Sybase EA Server"},"content":{"rendered":"<p>Sybase IQ is a highly optimized database engine for business intelligence, developed by the company Sybase, now called SAP Sybase IQ due to SAP's acquisition of Sybase.<\/p>\n<p>Specifically designed to deliver faster results in mission-critical analytical business intelligence solutions, data warehousing, and reporting, Sybase IQ combines speed and agility with a low total cost of ownership, enabling companies to conduct data analysis and reporting that was previously unthinkable, impractical, or expensive. The latest version of SAP Sybase IQ is 16.<\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"size-full wp-image-6657 aligncenter\" src=\"https:\/\/itdconsulting.com\/wp-content\/uploads\/2022\/03\/Logo-SAP-Sybase-IQ.png\" alt=\"\" width=\"449\" height=\"225\" \/><\/p>\n<p><strong>What are the main features?<\/strong><\/p>\n<ul>\n<li>Speed \u2013 Queries up to 100 times faster than a traditional database management system (DBMS).<\/li>\n<li>Lower total cost of ownership \u2013 Uses sophisticated compression algorithms that reduce storage volume by up to 70 percent compared to a traditional DBMS.<\/li>\n<li>Ease of use \u2013 Easier to maintain than traditional enterprise data warehouse applications; does not require intensive tuning.<\/li>\n<li>Scalability \u2013 Offers nearly linear scalability for users and data, accommodating large volumes of users and data. It also supports multiplexing, especially in GNU\/Linux environments where CPU-level scalability may be limited.<\/li>\n<li>Flexibility \u2013 Sybase IQ comes packaged in different editions, depending on the organization\u2019s query processing needs.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>Supported Platforms<\/strong><\/p>\n<p>Sybase IQ supports the following operating systems:<\/p>\n<ul>\n<li>HP-UX<\/li>\n<li>Microsoft Windows<\/li>\n<li>AIX<\/li>\n<li>Solaris<\/li>\n<li>GNU\/Linux<\/li>\n<li>UNIX<\/li>\n<li><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong>What is this server about?<\/strong><\/p>\n<p>Sybase IQ is a high-performance decision support server specifically designed for data storage. This cross-platform product runs on several popular platforms including Unix, Linux, and Windows.<\/p>\n<p>Sybase IQ is part of the Adaptive Server\u00ae family, which includes Adaptive Server Enterprise for business transactions and mixed workload environments, as well as SQL Anywhere, a smaller version of Adaptive Server often used for mobile and occasionally connected computing.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Sybase Database Architecture<\/strong><\/p>\n<p>The Sybase database architecture provides a common code base for Sybase IQ and SQL Anywhere, with data warehouses optimized for workload. It uses the IQ warehouse for data storage. These products share a common command syntax and user interface, facilitating application development and user access.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Quick Access to Multiple Data Sources<\/strong><\/p>\n<p>Sybase IQ can integrate data from various sources, not only IQ databases but also other databases from the Adaptive Server family, as well as non-Sybase databases and flat files. It can import this data into its IQ database, allowing it to leverage IQ's fast access capabilities. It can also query other databases directly, using the remote data access capabilities of Sybase IQ.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Data Storage and Sybase IQ<\/strong><\/p>\n<p>Data warehouses are collections of data designed to enable business analysts to analyze information. They are usually distinct from production databases to avoid disrupting daily operations. Data warehouses are often used as repositories upon which decision support systems (DSS) can be built. A decision support system is a software application designed to allow an organization to analyze data to support business decision-making.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Capabilities of Sybase IQ<\/strong><\/p>\n<p>All of Sybase IQ's capabilities are designed to facilitate DSS applications. A unique indexing system accelerates data analysis. Query optimization provides quick answers, even when the results include thousands or millions of rows of data. Simultaneous data access for multiple querying users and the ability to update the database without interrupting query processing provide the 24\/7 access users expect.<\/p>\n<p>Sybase IQ multiplex is a highly scalable shared disk grid technology that allows simultaneous data loads and queries across independent data processing nodes connected to a shared data source. For details and syntax, see Using Sybase IQ Multiplex.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>How does Sybase IQ make connections? <\/strong><\/p>\n<p>To establish a connection with Sybase IQ, the client application performs the following steps:<\/p>\n<p>&nbsp;<\/p>\n<ol>\n<li>Locate the interface library. The client application must locate the ODBC driver or the Embedded SQL interface library.<\/li>\n<li>Gather a list of connection parameters. Since connection parameters can be provided in various places, such as data sources, a connection string assembled by the application, and an environment variable, Sybase IQ assembles the parameters into a single list.<\/li>\n<li>Locate a server. Using the connection parameters, Sybase IQ locates a database server on its machine or on a network.<\/li>\n<li>Locate the database. Once it locates the server, Sybase IQ finds the database to which it is connecting.<\/li>\n<li>The following sections describe each of these steps in detail.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><strong>Next steps in the connection<\/strong><\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>Locating the interface library<\/strong><\/p>\n<p>The client application makes a call to one of Sybase IQ's interface libraries. Generally, the location of this DLL or shared library is transparent to the user. Here we describe how the library is found in case of issues.<\/p>\n<p><strong>\u00a0<\/strong><\/p>\n<p><strong>Locating the ODBC driver<\/strong><\/p>\n<p>For ODBC, the interface library is also known as the ODBC driver. An ODBC client application calls the ODBC driver manager, and the driver manager locates the Sybase IQ driver.<\/p>\n<p>The ODBC driver manager searches the data source supplied in the odbc.ini file or registry to locate the driver. The ODBC manager completes the current location of the driver based on the registry entries for the driver that were established when the IQ client software was installed.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Locating the Embedded SQL interface library<\/strong><\/p>\n<p>Embedded SQL applications call the interface library by name. The name of the Sybase IQ Embedded SQL interface library is as follows:<\/p>\n<ul>\n<li>Windows: dblib11.dll<\/li>\n<li>UNIX: libdblib11 with an operating system-specific extension.<\/li>\n<\/ul>\n<p>The locations searched depend on the operating system:<\/p>\n<p>In Windows, the client application searches for files in the current directory, in the system path, and in the Windows and Windows\\system directories.<\/p>\n<p>In UNIX, the client application searches for files in the system path and the user's library path.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>When the library is found<\/strong><\/p>\n<p>Once the interface library is located, the client application passes a connection string to it. The interface library uses the connection string to assemble a list of connection parameters, which it uses to establish a connection with a server.<\/p>\n<h3><strong>Sybase EA Server<\/strong><\/h3>\n<h3><strong><img decoding=\"async\" class=\"size-full wp-image-6668 aligncenter\" src=\"https:\/\/itdconsulting.com\/wp-content\/uploads\/2022\/03\/Inicio-de-sesion-a-un-servidor-de-Sybase-EAServer.jpg\" alt=\"\" width=\"642\" height=\"276\" \/><\/strong><\/h3>\n<p><strong>\u00bfQu\u00e9 es EA Server?<\/strong><\/p>\n<p>EAServer es un servidor de aplicaciones desarrollado por la empresa Sybase, el cual incluye un conjunto integrado de herramientas que se usan para crear y ejecutar aplicaciones Web con soporte a altos niveles de tr\u00e1fico, contenido din\u00e1mico y procesamiento intensivo de transacciones en l\u00ednea.<\/p>\n<p>EAServer brinda la infraestructura necesaria para ejecutar aplicaciones distribuidas basadas en componentes, residiendo en la capa media de una arquitectura multi-capa, entre la aplicaci\u00f3n cliente y la base de datos remota.<\/p>\n<p>EAServer permite la gesti\u00f3n eficiente de sesiones cliente, seguridad, \u00abhilos\u00bb o \u00abthreads\u00bb, conexiones a la base de datos y flujo de transacciones, sin requerir conocimiento especializado por parte del desarrollador.<\/p>\n<p>Las m\u00e1s recientes versiones de EAServer son la 5.5 y la 6.1.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>\u00bfCu\u00e1les son sus principales caracter\u00edsticas?<\/strong><\/p>\n<p>EAServer incluye las siguientes caracter\u00edsticas:<\/p>\n<ul>\n<li>Un motor de ejecuci\u00f3n escalable, \u00abmulti-hilos\u00bb, e independiente de la plataforma<\/li>\n<li>Soporte de \u00abstubs\u00bb y \u00abproxys\u00bb para los principales modelos de componentes, incluyendo JavaBeans, PowerBuilder, Java, ActiveX, y C\/C++<\/li>\n<li>Soporte a HTML din\u00e1mico usando Servlets Java y Java Server Pages (JSP)<\/li>\n<li>Soporte a la plataforma de desarrollo Java 2 Enterprise Edition (J2EE)<\/li>\n<li>Administraci\u00f3n gr\u00e1fica a trav\u00e9s de Sybase Central, que incluye gesti\u00f3n de componentes, seguridad, monitoreo de transacciones, etc.<\/li>\n<li>Estrecha integraci\u00f3n con el ambiente de desarrollo de PowerBuilder<\/li>\n<li>Gesti\u00f3n transparente de sesiones cliente y ciclo de vida de componentes<\/li>\n<li>Cach\u00e9 de conexiones a bases de datos<\/li>\n<li>Servicios est\u00e1ndar de resoluci\u00f3n de nombres<\/li>\n<li>Gesti\u00f3n de transacciones que simplifica el dise\u00f1o y la implementaci\u00f3n de las transacciones de una aplicaci\u00f3n<\/li>\n<li>Uso simplificado de datos y recursos compartidos<\/li>\n<li>Soporte a conjuntos de resultados (\u00abresult-sets\u00bb) que permiten la recuperaci\u00f3n eficiente de datos tabulares en las aplicaciones cliente<\/li>\n<li>Seguridad declarativa y basada en roles que restringe las conexiones cliente y los componentes que pueden ser invocados por una sesi\u00f3n cliente espec\u00edfica<\/li>\n<li>Soporte a mensajer\u00eda y procesamiento asincr\u00f3nicos<\/li>\n<li>\u00abRedirector Plugin\u00bb para servidores web, el cual redirige los requerimientos del cliente directamente al Servidor web<\/li>\n<li>Soporte a m\u00faltiples protocolos de red, incluidos IIOP, TDS (Tabular Data Stream de Sybase), HTTP y SSL<\/li>\n<\/ul>\n<p>&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>Sybase IQ es un motor de bases de datos altamente optimizado para inteligencia empresarial, desarrollado por la empresa Sybase, llamado ahora Sap Sybase IQ debido a la compra de la empresa Sybase por parte de Sap. Dise\u00f1ado espec\u00edficamente para entregar resultados m\u00e1s r\u00e1pidos en soluciones de inteligencia empresarial anal\u00edtica de misi\u00f3n cr\u00edtica, almacenes de datos [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":480,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_theme","meta":{"footnotes":""},"class_list":["post-6664","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/itdconsulting.com\/en\/wp-json\/wp\/v2\/pages\/6664","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/itdconsulting.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/itdconsulting.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/itdconsulting.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/itdconsulting.com\/en\/wp-json\/wp\/v2\/comments?post=6664"}],"version-history":[{"count":1,"href":"https:\/\/itdconsulting.com\/en\/wp-json\/wp\/v2\/pages\/6664\/revisions"}],"predecessor-version":[{"id":7289,"href":"https:\/\/itdconsulting.com\/en\/wp-json\/wp\/v2\/pages\/6664\/revisions\/7289"}],"up":[{"embeddable":true,"href":"https:\/\/itdconsulting.com\/en\/wp-json\/wp\/v2\/pages\/480"}],"wp:attachment":[{"href":"https:\/\/itdconsulting.com\/en\/wp-json\/wp\/v2\/media?parent=6664"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}