Progress 4GL

The PROGRESS database management system is capable to solve information problems of corporate scale (powerful computers running UNIX or AS/400 OS, hundreds of gigabytes of the distributed data, thousands of users, etc.), but thanks to reasonable demands to computing resources and flexible price policy is widely used also for creation of the information systems "client/server" of scale divisions (local networks with the Windows 2003 Windows 2000 servers and even autonomous it is system to a basis of personal computers (Windows XP).

Along with the standard set of opportunities characteristic of all DBMS of a corporate class:

• SQL language,
• triggers,
• transactions (including distributed with two-phase commit),
• automatic recovery after any failures,
• support of different operating systems,
• support of multiprocessor architectures,
• multithreading,
• protection against unauthorized access
• etc.,

PROGRESS DBMS has unique features also nearby, for example:

• the developed dictionary of data (as much as difficult rules of ensuring integrity, data view formats by default, etc.);
• blocking at the level of records;
• possibility of not blocking access of applications "only for reading";
• possibility of index navigation on selection up and down (for fast moving to the end of long selection it is not required to read out all selection);
• case-insensitive indexes (search in the index without a letter case is possible);
• word-by-word indexation (allows to perform instant search of words and phrases in arrays of the unstructured text);
• packaging of indexes (reduces their size by 2-3 times and, therefore, increases access rate);
• full functional compatibility of databases of all levels (from Personal to Enterprise);
• correct work with any national alphabets, codings (including

two-byte) and sortings; starting with version 9 also UNICODE poderzhivatsya;

• reasonable demands to computing resources (is 2-3 times lower, than Oracle with other things being equal).

Despite so broad functionality and rich opportunities of configuring, PROGRESS DBMS it is simple in installation and operation thanks to best values of default arguments and existence of the self-configured means (like asynchronous write processes on a disk). In most cases administration of the database does not even require the selected established post.

Development tools of PROGRESS.

Language of fourth generation PROGRESS 4GL proved as the highly effective building tool of the professional distributed applications of corporate scale from beginning to end. It has a number of unique advantages before similar development tools:

• language includes equally developed means of manipulation with data, descriptions

business logic and the user interface that allows to create completely the finished applications from the graphical interface to database triggers on one language. It allows to lower training costs of developers considerably and to accelerate application development;

Language 4GL, starting with version 10 it carries the name ABL supports development as graphic: Windows 2000, Windows XP, Windows Vista, and character UNIX terminal, Windows NT console of user interfaces and also the procedures which do not have the user interface at all (business logic, database triggers); to version 10 Progress without being a "canonical" object-oriented language, such as C ++ or Java, PROGRESS 4GL nevertheless allows to create so the nazyvayemyebusiness-components of the high level or SmartObjects encapsulating data members, objects of the user interface and logic their processings (methods).

PROGRESS SmartObjects can include other SmartObjects, process and generate events and also communicate that allows to collect from them difficult multiwindow applications. Starting with version 10 in it it is implemented full support of OOP. As subjects of Windows applications can be used also the ActiveX components that does possibilities of creation graphical interface almost boundless; applications in the PROGRESS language 4GL can work as with local (architecture of "single user" and "host-terminal"), and with remote (architecture "client-server") databases of PROGRESS, and also to interact with applications of PROGRESS on remote computers with the help technologies of the AppServer application server (multi-tier architecture "client-server"); WebClient allows to organize access through Web to procedures, written in language 4GL that considerably expands the accessibility through HTTP protocol.

Development tools of PROGRESS allow to address also databases of the third firms directly (Oracle, DB2/400) or via the ODBC interface. The applications written in other languages (Java, C, C ++, Visual Basic, Delphi and other) can not only address databases of PROGRESS via interfaces ODBC/JDBC but also to call the procedures written in the PROGRESS 4GL language through the ActiveX and Java RMI interfaces that allows to integrate easily databases and the PROGRESS applications in the existing heterogeneous information systems and also combine different technologies when developing new applications. Meeting the requirements of ANSI SQL92 standard, the PROGRESS DBMS server can be used with any ODBC-and JDBC compatible development tools and applications, but for achievement of maximum efficiency and access to everything to range of unique opportunities of the server (in particular, navigation access to data and word-by-word indexation) are recommended to use development tools PROGRESS.

Support of the technologies described above allows to integrate DBMS successfully Progress with different other applications, for example with Microsoft Office, using the last for submission of final reports.

A set of means of visual programming ProVISION allows to create difficult multiwindow PROGRESS-applications, without removing a hand from a mouse and without having any ideas of the PROGRESS 4GL language. A principal component of ProVISION - AppBuilder - allows how to create new business applications by the choice of components from "palettes" and placements them in the working AppBuilder field. These components represent not just screen primitives, but sets of the triggers and methods connected with them that allows to build not just beautiful interfaces, but full-function applications.

Besides, it allows, to develop the text application, focused on operation in the environment of UNIX, has a possibility of start the developed application in a console window and its step-by-step debugging with the help graphic debugger of PROGRESS Debugger.

ProVISION includes also means of a visual partitsionirovaniye of difficult applications, allowing to define dynamically where these or those should be performed parts of business logic of the application - on the client or on the server.

The development tool of Internet-applications of WebSpeed allows to use The web browser as the user interface to applications of on-line transaction processings. The business logic of applications is written in the PROGRESS 4GL language, the user interface is under construction in the form of HTML pages, or created with the help of any HTML-editor, or dynamically generated PROGRESS

• procedures.

In use on the client place only normal Internet-browser is necessary, through which the user works with a Progress-application without knowing at all and without thinking of its existence.

Brief summary of features of Progress DBMS.

The maintained architecture of DBMS: · desktop · client/server · host terminal · Internet/Intranet

Network protocols - any.

The interface integration tools with others, not Progress, applications: · HDC · DDE · ODBC · JDBC · DLL · Gateway · Socket · ANSI SQL92 · XML · OLE, COM, ActivX · Java RMI · Case Bridges

Support of integrity: · Blocking of records · Built-in transaction mechanisms · transactions with two-phase commit · triggers · differentiation of access rights at several levels · use of means for collecting of statistics

Possibilities of administration: · light scalability imperceptible for the user · multistage backup · journalizing of transactions · before-imaging и after-imaging · roll-back recovery и roll-forward recovery · automatic recovery after any failures

Support of all modern techniques of programming: · Modular and procedural · Event · Object-oriented (OOP) · Component-oriented

Support of hardware platforms: · Windows XP/2000/2003/Vista · SCO UnixWare, SCO OpenServer · Sun Solaris Intel & Sparc · IBM AIX · HP-UX · Linux Intel · Compaq Tru64 · DG/UX Intel

Work in heterogeneous network of very difficult configuration is possible. Applications, developed on Progress, can work without rewriting on more than 160 hardware-software platforms.

Support of codings of national languages · Windows - 1251, · KOI-8, · ISO 8859-5 · ISO 866. · UNICODE

Characteristics and restrictions of Progress DBMS

• The fields of placement for database 1,000
• Tables in base 32,000
• Entries in table 2,109
• Maximum size of files of journalizing 32 Tb
• Indexes in base 32,000
• Water in table 32,000
• Polzovateley 10 000
• Simultaneous transactions 10,000
• Buffer pool of 500.000 blocks of 4 Gbytes
• transactions per minute 600,000 (IBM RS/6000)
• The maximum amount of record is 32 KB
• Maximum size of field of placement 16 Tb
• Maximum size of the table 16 Tb
• DB maximum size 80 Petabyte (1015)

Examples of the real systems:

Australian Cellular Phone Network (Australian cellular telephone network) · Size of the main segment of a DB of 200 GB (general set more than 1 TB). · In the main segment 2 hosts of the table, 500 million records everyone. · Growth of a DB more than 1 million records a day. · More than 10 million transactions a day.

Medical systems

• SwissCare®-Systems of the Swiss company DataSwiss Solutions AG

http://www.dataswiss.com/

ERP and MRP systems for the average and small markets of Russia:

• Symix SyteLine http://www.frontstep.ru/
• QAD MFG/Pro http://www.qad.ru/
• Solagem Enterprise
• Nikos software NS2000

Banking systems:

• CSBI Banker of http://www.csbi.ru/
• Large-scale integrated circuit Biscuit of http://www.bis.ru/

Trade:

• IBS IBS Trade House http://www.ibs.ru/
• IBS IBS-GAS
• FIT Gesto http://www.fit.ru/

Corporations the using Progress.

Transnational.

Users are 60% of the companies from the list of Fortune 100 (the largest international corporations).

PepsiCoMarsDaewoo, Coca-ColaMariott (hotels)Gillette, Johnson & JohnsonBlack & DeckerLucent Technologies, Lockheed MartinColgate-PalmoliveHeineken, Mercedes-BenzFord Motor CompanyBritish Petroleum, AT&TRockwellMazda Motor Corporation, DanonUnited TechnologiesMcDonnell-Douglas, Glaxo WellcomeSonyKrupp, HeinzSun СНГVolvo, Volkswagen,

The Russian

Trade: Krestovsky department store, Maxidom (St. Petersburg), East and Bosco Di Ciliedgi, KOPEYKA supermarket chain, Arguments and facts (ARIA and kioskovy network), House of Books (St. Petersburg),

Banking sector: BISBANK Gagarinsky, Bank Caspian, Arkoyevrotrastbank, Vneshtorgbank, Northern Kaznakamchatbusinessbank, Russian Agricultural Bank, Rosselkhozbank, Grankombank, Slavic Bank, Avtobank, Uralvneshtorgbank, Avtogradbank, Gutabank, Russian Standard, TexaKaBank, Bank St. Petersburg, Lateko Banka, AVTOBANK-NIKOYL, Baltoneksimbank, Tallinn Business BankaA/S Pirma Banka,

Information and communications

Telecommunications: GTsRT of Ostankino, Lucent Technologies

Express mail: TNT

Publishing houses: Burda It is fashionable, Arguments and the facts

and many others....