Sybase-Enterprise Data Management Full Contact Sybase Enterprise Information Unlimited Solutions Enterprise Data Management All Contact Sybase Enterprise Information Unlimited core is the integrated management capability of business and any time, anywhere. Due to the wide variety of enterprise applications and infrastructure, the demolition of enterprises, the combination makes information management difficulty. Therefore, corporate IT staff should choose the information management solution suitable for yourself according to the specific situation of enterprise applications. Sybase can be described as a base of the enterprise data management, starting from the launch of the distributed database server on the first C / S architecture, large to the data warehouse engine, small to mobile database, Sybase is binding to the user's Application mode and demand have launched a data management solution suitable for all kinds of applications, and it is deeply favored by users. Sybase data management is based on "Always Available", through reliable, safe and efficient tools, can help companies can better manage information, which can help companies from hindering productivity and efficiency traditional technologies. Liberation information. High-performance database server ASE 12.5.2 is the latest version of Sybase Database Server Adaptive Server Enterprise (ASE), which continues to maintain the previous version of key business performance and efficient calculation, in ease of use, system performance, and support new applications Aspects have been enhanced and improved, and further improves system security and Linux scalability. Cost-effective and total cost of ownership (TCO) have been the characteristics of Sybase database products. ASE 12.5.2 Improved Dynamic Cache Management, and system users can easily adjust the amount of memory for cache management without restarting the server. You can add, delete, extend the cache, and change its strategy without restart or uninterrupted, which greatly reduces the workload of the memory to respond to the continuous change of workloads, thereby reducing the cache Adjustment time, as well as the time occupied by an error in the adjustment of the cache size. In addition, Sybase provides database managers with two very useful tools, DB XRay, and DB Expert. With DBXRAY, various levels of database administrators have a reliable means that uses a simple tool to monitor server key performance. Through ASE's DB Expert option, IT professionals can analyze, predict, select, optimize and manage performance changes to ensure that task-critical business applications run at best performance. Also 猓珹 SE12.5.2 Memory support for 32-bit Linux operating systems has extended from the original 2.7GB to 64GB, increase the memory space available by ASE, reducing the number of systems accessing the disk, enhances system performance, thus making ASE becomes the first choice for commercial database on Linux platform. Real-Time Data Services ASE 12.5.2 provides the ability to connect to the message middleware to implement bidirectional transmission of the database and message queue, and new event publishing and subscription modules can help users implement real-time data services. Real-Time Data Services can help companies achieve different databases and message architecture features to make each other or customize information, allowing businesses to actively send information to message architectures or applications in a lower cost, more convenient way, eliminating due to The phenomenon of information delays caused by batch or rotation testing and system performance. Sybase Real-Time Data Services provides complete solutions for databases including Sybase ASE, IBM DB2, Microsoft SQL Server, and Oracle, which do not need to change existing application systems or custom encoding, so you have a small impact on the application. Dynamic archiving solutions how to use historical data in the business system is an important issue in system construction planning. If you depart from historical data, it will face the difficulties that you need to get and reload data in real time; if you store these rarely used historical data online, you will increase the burden of your business system, reduce its performance.
Therefore, a reasonable archiving mechanism is quite important for corporate planning. ASE 12.5.2 Supported Dynamic Archive, you can realize the smooth migration of offline data and online data, reduce the management workload of data archives, mitigate the load of the business system; at the same time, when you need, you can access history in real time. data. The current business data and historical archive data can be achieved, providing the business system with the best archiving mechanism. Data Integration Solution With the increasingly competitive, improve data access capabilities and business analysis capabilities have become more urgent. The increase in the number of users not only has a greater pressure on real-time data access, but also has higher requirements for the flexibility and reporting functions of the analysis. In numerous industries and areas, in order to make the business more flexible, it is necessary to introduce systems that can accurately predict and analyze the business, such as the fraud detection system used by financial related companies; the telecom suppliers used Billing system, supply system and sales system and claims system used by insurance companies and medical services. Sybase's Data Integration Solution (Dynamic Operational Data Store - DODS) solution can quickly alleviate the company's pressure, allowing them to securely meet the needs of growing real-time self-service analysis while maintaining its original system performance. With the Sybase Dods solution, users do not have to generate reports through the OLTP system to access critical operations, and do not worry about whether data is synchronized with new business transactions that occur at any time. The Sybase DODS solution uses a powerful replication technology that can obtain data from the operating system in almost time without interfering with the operation of the system. Copy data stored in the Sybase IQ archive database, the database is optimized for decision support, providing a query speed than traditional databases, while the required storage is 60% more than traditional RDBMS solutions ~ 80%. Replication Server Sybase another famous distributed data management product is a replication server (Replication Server 12.6), which can easily implement data movement and synchronization between enterprises. It allows DBA to quickly set data redundancy disaster backup system, synchronization with the heterogeneous database platform, such as Sybase ASE, ORACLE, IBM DB2 and Microsoft SQL Server. By moving and synchronizing with convenient data, the application can get the data required by other applications when needed. The Sybase replication server is characterized by providing transaction-based replication, maintaining transaction integrity of all replication information, ensuring that the query request can be transferred to the copy point when the access fails, and the data is provided by the copy point, which does not affect the application system itself database access. Supports two-way replication of Sybase and other database systems, which can make timely data responses, avoid data delays, improve the timely response ability of the application to transactions. In order to adapt to the needs of globalization, the less planned or non-planned downtime. Sybase can achieve disaster backup solutions by copying the server. By arbitrary network links to copy the data of the host system in real time to the off-site, ensuring system reliability / availability in the case of war, etc.. With Sybase OpenSwitch, client connections can be automatically switched to the backup server, implement the client program to the main transparency access and automatic failover transfer (Failover) caused by the master, to reduce the loss caused by non-planned downtime. Sybase disaster backup is flexible, and backup points do not need to have the same hardware device and software environment with the main system, because it is based on transaction-based replication, so the network load is small, the transmission speed is fast, safe and reliable. In practical applications of database disaster troubleshooting technology, there are many disaster backup recovery to use block replication technology to perform disk synchronous mirroring.
