Re: Informix evaluation

Posted in 1997

Topics: Performance & Tuning, Installation, Setup & Upgrades, Stored Procedures & SPL, Security, Permissions & Auditing, Triggers, Constraints & Referential Integrity

=?ISO-8859-1?Q?H=E9ctor_Alfredo_Garc=EDa_Jim=E9nez?= — 2 Jan 1997 17:18:36 GMT — source: Informix-list mailing list archive (1991-1998)

Este es un mensaje con m'ltiples partes en formato MIME. ------=_NextPart_000_01BBF89D.89C0F9E0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit Naushi Hussain <hussain@alliedsignal.com> escribi' en art'culo <32B9D4FD.375E@alliedsignal.com>... We are doing an eval. of some high end DBMSs for a MPPS applications. If someone could help me define these terms ( a line each) and why would they be necessary to consider in evaluating a DBMS. ' Async I/O ' Virtual Processor ' Dynamic Shared Memory ' 64 Bit support ' Share nothing implementation ' Function Ship VS Data ship ' Parallel execution of functions like DML, utilities ' Intelligent Data Partitioning ' log based application ' sync - 2 phase commit ' centralized console ' Security ' Roles ' Audits ' Dynamic allocation ' Multiple datatype support ' blobs ' Year 2000 compliance ' Robust procedural language ' Triggers & stored procedures ' extended SQL ' Performance Management ' advanced indexing ' cost based optimizer I could help you with some of the terms: Async I/O This capability refers that you can write and read at the same time. As you might expect this cannot be done in the same disk, but if the information of one table or database has been stored along different disks, the RDBMS can perform asyncronic I/O via different disks on the same table. Virtual Processor In order to use all the physical processors you have installed in your computer, there has be a way in which you can command the tasks that everyone of them must perform. The RDBMS has an implementation of processing that decides what task should be performed by every processor, but the instructions don't go right to the processor, it uses the VP instead that plans and sends the commands to the processor in order to coordinate the effort and achieve the results of the query. 64 Bit Support Let's put it this way. Think of a road that has 64 ways to communicate its beginning to its end. It's faster than a 32 bit "ways" road, and more efficient also. This allows the optimal use of some of the new computers in the market, that have been designed to offer this 64 bit support in order to have much more processing power, more memory management and faster applications. Blob This acronym means "Binary Large OBject" and it's nothing but a type of data that lets you store up to 2 MB of information in one field for each register. You can store images, photos, documents, HTML pages and so on. Intelligent Data Partitioning Some RDBMS have the chance of storing data of the same table in different disks, you can specify the rules for storing data on specific disks, so when new data arrives it can be spread through, and later information retrieval will be faster. Year 2000 Compliance The Date field contains an structure optimal for storing dates for the year 2000 and over, instead of some other RDBMS that just support dates up to 1999. Robust procedural language Beyond SQL capabilities some RDBMS provide the developers a procedural language that can be used to perform more complex manipulation on the data. So you can program whatever you want and modify/alter the data in a more proper way than usual. Triggers & stored procedures There are two instances of the use of the procedural language. Triggers: When you affect the data contained in a table, the resulting event (Update, Insert, Delete) can "trigger" (activate) one program to perform some specific task. Let's think that if you modify the code of one customer this change must also be done in the invoices table, so you program the change and create a trigger that's going to be run when you Update the customer table. Store Procedures These are generally the base of the triggers, they're programs stored within the Database and are accesible by anyone and can be incorporated and erased at anytime. Generally a trigger executes a stored procedure to simplify its creation. Extended SQL Some RDBMS extends the set of SQL instructions to give more power to the queries or to perform something on the data that without the extension would be very difficult or impossible. Cost based optimizer Before you submit one query an evaluation of the cost of the query is done, so the RDBMS knows an accurate way to perform the query, it can create some temporary tables, create some temporary indexes, guide through an index and so on. I hope I could have helped you in some way. H'ctor Alfredo Garc'a Jim'nez hgarcia@telmex.net ------=_NextPart_000_01BBF89D.89C0F9E0 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable <html><head></head><BODY bgcolor=3D"#C0C0C0">Naushi Hussain = <hussain@alliedsignal.com> escribi=F3 en art=EDculo = <32B9D4FD.375E@alliedsignal.com>... We are doing an = eval. of some high end DBMSs for a MPPS applications. If someone = could help me define these terms ( a line each) and why would they = be necessary to consider in evaluating a DBMS. =B7 Async = I/O =B7 Virtual Processor =B7 Dynamic Shared Memory =B7 64 Bit = support =B7 Share nothing implementation =B7 Function Ship VS Data = ship =B7 Parallel execution of functions like DML, utilities =B7 = Intelligent Data Partitioning =B7 log based application =B7 sync - = 2 phase commit =B7 centralized console =B7 Security 	=B7 = Roles 	=B7 Audits 	=B7 Dynamic allocation =B7 = Multiple datatype support 	=B7 blobs =B7 Year 2000 = compliance =B7 Robust procedural language 	=B7 Triggers & = stored procedures 	=B7 extended SQL =B7 Performance = Management 	=B7 advanced indexing 	=B7 cost based = optimizer I could = help you with some of the terms: Async I/O This capability refers that you can = write and read at the same time. As you might expect this cannot be done = in the same disk, but if the information of one table or database has = been stored along different disks, the RDBMS can perform asyncronic I/O = via different disks on the same table. Virtual Processor In order to use all the physical processors you have = installed in your computer, there has be a way in which you can command = the tasks that everyone of them must perform. The RDBMS has an = implementation of processing that decides what task should be performed = by every processor, but the instructions don't go right to the = processor, it uses the VP instead that plans and sends the commands to = the processor in order to coordinate the effort and achieve the results = of the query. 64 Bit Suppo

Related threads

Glossary

shared memory