Comprehensive description of the audit of the Caché (Cache) database

1 , what is Caché (Cache) Database

Caché (Cache) is a post-relational database that provides access to data in three ways: Object access,SQL access, and direct access to multidimensional data arrays. And three access methods can access the same data concurrently.

Caché (Cache)using the multidimensional data engine, the process of object data from disk to memory is completed very quickly, and data is read and written to and from the disk very quickly. Efficient access to the multidimensional data model makesCaché (Cache)ideal for transaction processing applications that frequently update small amounts of data becauseCaché (Cache)By organizing the data into an N -dimensional array, it is easy to search, lock, and update the data required by the exchange. The application and database engine does not take time to access multiple tables, nor does it need to lock all relevant data pages for searching data. Because of its performance dozens of times times faster than traditional Oracle databases, domestic healthcare systems are increasingly being usedCaché (Cache)database, such as Shenzhen Nanshan Hospital, Beijing Maternal and Child Hospital, Qinhuangdao Shi first People's Hospital.

2 , Access Caché (Cache) What are the tools

forCaché (Cache)provides three ways to access,Caché (Cache)Comes with access tools:Portal,terminal , and studio, where you can manipulateCaché (Cache)the M language, you can also manipulate SQL statements ; By using a tool such as Winsql , you can access the SQL statementCaché (Cache)database ;

3 , how to do the cache database Audit

First, we need to audit client operations caché (Cache) m language,

second, second, need to audit to studio the various types of operations, programmers generally use studio development caché (Cache)

third, need to audit to operations caché (Cache) terminal , portal , winsql et

IV, need to audit to Operation caché (Cache)   the principal information of the database, such as the user name, ip address, real mac address, computer name, and operating system user name

4 , now which database audit system manufacturers can better audit Caché (Cache) Database

currently, in the database audit factory, onlyAng Kai Technologythe database audit system can be fully audited toCaché (Cache)database, other manufacturers currently do not support theCaché (Cache)database Audit, Ang Kai Technology's database audit system toCaché (Cache)One of the cases of database audit: such as Shenzhen Nanshan Hospital, customer connection number is large, reliability, availability and so on are required high, Ang Kai Database audit system can be better satisfied.

650) this.width=650; "src=" http://img2.ph.126.net/q2T3nymWJwHh3r5jAFwB5w==/6630570786445717193.jpg "style=" border : 0px;margin:0px 10px;float:none; "alt=" 6630570786445717193.jpg "/>

Comprehensive description of the audit of the Caché (Cache) database