10.Do you really know PC Software?(1)

1.C/S (Client/Server)

C/S is also called Client/Server mode. Server usually adapts high performance PC, the workstation or the small machine, and the large-scale database system, like ORACLE, SYBASE, InfORMix or SQL Server; The client side needs to install the special-purpose client side software.

Client/Server structure is software system architecture. It can fully use the superiority of both sides hardware environment, logically distribute task to client and server to achieve, reduce the spending of reduced system’s communication expenses.

C/S pattern merit: The speed of response is quick; Personalized operation contact surface; The data storage management function is more transparent; The C/S structure management information system has the strong transaction capabilities, can realize the complex operation flow.

C/S pattern shortcoming: Needs the special client side installation procedure, the distributed function is weak; The compatibility is bad; The development cost is high.

2.B/S (browser/server pattern)?

B/S (browser/server pattern) is along with Internet technology starting, is one kind of improvement to C/S structure. Under this kind of structure, software application’s service logic in realizes completely using the server end, the user performance realizes completely in the Web server, the client side only needs the browser then to carry on the handling of traffic, it is one kind of brand-new software system structure technology. This kind of structure becomes application software’s first choice architecture now.

B/S pattern merit: May inquire and browse of traffic anytime and anywhere and so on; The service expands simply convenient, through increases the homepage then to increase the server function; The maintenance and the promotion way are simple; Develops simply, sharing is strong; Cost reduction, the choice are more.

B/S pattern shortcoming: The personalized characteristic reduces; The operation is take the mouse as the most basic operating mode, unable to satisfy the request of fast operation; Page dynamic refurbishing, the speed of response reduces; unable to realize the paging to demonstrate that creates the tremendous pressure for the database visit; The function attenuates, difficulty to realize special function request that under the traditional pattern.

3.API (application programming interface)

Application programming interface is a set of function calls that provide the interface to a software package.

It is a Windows function beforehand defined to control outward appearance and behavior of Windows each part. User’s each movement can initiate one or several functions operation to tell windows what happened.

4.DLL (dynamically linked library)

A library that isn’t linked into the application code that uses it until the code is loaded into memory or the first call to a function in the library is made. DLLs are widely used on Windows and Unix workstations.

5.SQL (structured query language)

The SQL full title is the structured query language. It is a language of database inquiry and procedure programming, uses in depositing and withdrawing the data as well as the inquiry, the renewal and the management relational database system.

SQL language includes four parts:

Data defined language, for example: CREATE,DROP,ALTER sentences and so on.

Data manipulation language (DML), for example: INSERT, UPDATE, DELETE sentences and so on.

Data inquiry language, for example: SELECT sentence.

Data management language, for example: GRANT, REVOKE, COMMIT, ROLLBACK sentences and so on.

6.MYSQL

MySQL is a small relations database management system, at present MySQL is widely applied on Internet in the middle and small scale website. Because its volume is small, the speed is quick, the overall cost is low, particularly this characteristic opens sound code, many middle and small scale websites choose MySQL to take the website database in order to reduce the website overall cost.

7.SQL server

SQL Server is a relational database management system.

SQL Server 2005 were a comprehensive database platform, use integration commercial intelligence (BI) tool and provided the enterprise data management.SQL Server 2005 database engines have provided safer and reliable memory function for the relations data and the structurized data.

SQL Server 2008 is an important produce edition. It has promoted many advantages of characters and keys, make it become the most strong and comprehensive SQL Server edition until now.

8.Access????

Access is relational database management system (RDBMS) based on the Windows tabletop promoted by Microsoft Corporation, it’s one of office series software. It provides seven kinds of objects as table, inquiry, windows, report form, page, and module to use for to establish

the database system; provides many kinds of guides, generator, template, make the operation as data storage, data inquiry, contact surface design and report generation standardizations;

provides convenience for the establishment function perfect database management system, also causes the average consumer may complete the majority of data management the duty not to need to compile the code.

9.FAT32 (file allocation table32)

FAT is a data structure that contains a description of the files in a directory (name, location, permissions, etc.).

FAT32 in fact is one form which the document district table adopts, it is opposite in FAT16 says, it may save the floppy disk space greatly, it is stabler, reliable and nimble.

The biggest merit of FAT32 is that the disk size it supported may to reach 2TB (2048GB) compared with FAT16, but cannot support smaller than the 512MB district. Based on FAT32 win 2000 may support the district 32GB most greatly; but based on the FAT16 Win 2000 support’s districts is 4GB most greatly.

FAT32 used a smaller bunch, may preserve the information effective. The storage efficiency is much higher than FAT16, usually may enhance 15%.

The FAT32 may locate the root directory and use FAT backup transcription. Moreover FAT32 district start record is included a structure which includes key data, it reduce the possibility which the computer system collapses.

10.NTFS (new technology file system)

NTFS is standard file system of Windows NT, it also simultaneously applies in Windows 2000, Windows XP and Windows Vista. The main difference between this system and the old FAT filing system is that NTFS system support metadata, and might use the advanced construction of data to provide a better performance, stable and disk’s use factor.

The goal of NTFS is: provides reliability, through restore ability (event trace) and the hot localization fault-tolerant characteristic realizes; Increases a functionality platform; support POSIX demand; Eliminates the limits of FAT and HPFS.

*These are all the information collected by me personally browsing various websites.If you are concerned about more learning content, please add my LinkedIn or mail me.I will update my knowledge about this industry from time to time, hoping to help everyone.

Author:Allen He??

??

?