Integration of applied software packages. Integration of application packages. Libraries of standard subprograms
Integration packages є collection of a number of software products, combined into a single handy tool. Most of them include a text editor, an organizer, a spreadsheet, a DBMS, electronic mail support, a program for creating presentation graphics.
The results, taken away by the subprograms, can be combined into a residual document to replace tabular, graphic and textual material.
Integrated packages sound like a core, which ensures the possibility of close interaction between warehouses.
Butt: an integration package for writing books that will cover illustrations. Vіn vengeance:
text editor;
spelling proofreader for 80,000 lines (program for revealing spelling pardons);
the program of angry texts;
the program for molding the change and folding of the showcases;
automatic search and change of words and phrases;
secure telecommunications;
spreadsheet;
database management system;
modules of graphic design;
graphic editor;
the ability to use hundreds of different fonts toshcho.
Most popular integration packages:
Microsoft office. Whose tight professional package has gone like this necessary programs yak text editor winword , spreadsheet excel , presentation program PowerPoint , DBMS Access , zasіb pіdtrimki e-mail Mail. Moreover, all the parts of this package are put together in one whole, and the names of all the programs look the same, which is easier to master, so it is better to win.
Microsoft Works - even a simple and handy package that uses a text editor, spreadsheets and data bases, as well as telecommunication tools for connecting with other computers via telephone lines. A package of orientations for people who do not waste time to master folding products, for koristuvachiv-pochatkivtsiv, as well as for home koristuvachiv.
Merezhev software security
Merezhev software security it is recognized for the organization of a joint work of a group of koristuvachs in various computers. Allows the organization of a global file structure, global data bases available to a skin member of a group. Ensure the possibility of transferring support and work on joint projects, the possibility of sharing resources.
Functions and characteristics of meshed operating systems (OS)
(For the materials of the www-site of the Omsk State Technical University http://edu.omgtu.omskelecom.ru)
The main functions of the merging OS include:
management of directories and files;
resource management;
communication functions;
protection against unauthorized access;
safety of water resistance;
keruvannya merezhey.
Manage directories and files at the borders, they have secure access to data, which is physically distributed in other nodes of the border. Management is responsible for special assistance merezhnoy file system. The file system allows you to download files in a way to save primary files for local work current benefits. Under the hour of the exchange of files, it is necessary to secure the necessary exchange confidentiality level (data privacy).
Resource management includes servicing of requests for resources available through the link.
Communication functions secure addressing, buffering, direct selection of data flow from the distribution of the network (routing), data flow management and others.
Protection against unauthorized access- an important function that maintains the integrity of data and their confidentiality. Sobi zakhist can allow access to the main data only from the same terminals, at the time, hour, kilka times, etc. A skin care provider in a corporate environment can have their own access rights to the totality of available directories, or a list of possible ones, for example, can be blocked from changing some files.
Vіdmovostіykіst characterized by the savings in the practicality of the system under the influence of destabilizing officials. Vіdimovostіykіt rustice to learn to the server for the server of autonomy Jerell Livennya, Vidarindes of Abo Dublywanns Іnformazі in disklishkiyuch. Under the condition of sounding, you should understand the presence of two copies of these data in your system on your own disks, and also connect one to the controller. The duplication is respected by the same, that for skin discs from copies of the vicarious copy there are different controllers. It is obvious that dubbing is superior. Away from the increase in stability to the point of connection with the duplication of servers, which will help the additives of the vitrates to come into possession.
Mere management pov'yazane іz zastosuvannyam vіdpovіdnykh protokolіv adminіnnya. The software security of the management of the system is composed of managers and agents. manager The program is called, which vibrates the commands. agents are programs, roztashovani at different universities of the merezhі. Look out for the managers' teams, follow the camp of the university, collect information about the parameters of their functioning, signal about the subs, which are being monitored, fix anomalies, follow the traffic, check the protection against viruses. Agents with a sufficient world of intelligence can take part in updated information after failures, in the correction of control parameters only.
The software security of the merging OS is distributed by the nodes of the merging.Є OS kernel, vykonu more s characterized by more functions, and additional programs (services), oriented implementation of protocols in the upper levels, vykonnannya specific functions for switching servers, organization of distributions, etc. Before the software security, one can also motherboard drivers. For the skin type LOM, there are different types of boards and drivers. In the middle of the skin type LOM, there can be a variety of different boards with different characteristics of intelligence, speed, and buffer memory.
At this hour of the greatest expansion, three main borders of the OS were nabooly - UNIX, Windows NTі Novell NetWare.
OS UNIX zastosovuyut most importantly in large corporate companies, but the system is characterized by high reliability, easy scalability of the company. Unix has a number of commands and programs that support them for work in the field. Go ahead, command ftp, telnet, implement file exchange and emulation of a remote node based on protocols TCP/IP. In a different way, protocol, commands and programs uucp, rozroblenі z orientation to asynchronous modem calls on telephone lines between distant Unix nodes at corporate and territorial networks.
OS Windows NT turn on the server (Windows NT Server) that client (Windows NT Workstation) some of them themselves take care of the robot in the "client/server" mergers. Windows NT zastosovuyut zastosovuyut at the average for the scale of the merezh.
Novell NetWare OS consists of the server part and shells shell, located at the client's nodes. We give koristuvachs the opportunity to compile files, printers and other devices. To clean up the catalog service, I will spread the database of the data of the correspondents and the resources of the enterprise. Qiu OS is most likely to stagnate in small yards.
Integration of software packages - a set of a number of software products, combined into a single handy tool. Most of them include a text editor, an organizer, a spreadsheet, a DBMS, electronic mail support, a program for creating presentation graphics.
The results, taken away by the subprograms, can be combined into a residual document to replace tabular, graphic and textual material.
Integrated packages sound like a core, which ensures the possibility of close interaction between warehouses.
The professional package Microsoft Office has added such necessary programs as a Word text editor, an Excel spreadsheet, a program PowerPoint presentations, DBMS Access, zasіb podtrimki electronic mail. All parts of this package should become one whole, and call the names of all programs look the same, which is easier to master, and more common.
For example, an integration package for writing books, to avenge illustrations, vengeance:
Text editor;
Spelling proofreader for 80,000 lines (program for revealing spelling pardons);
The program of angry texts;
I will change the molding program and fold the show;
Automatic Poshuk that change of words and phrases;
secure telecommunications;
spreadsheet;
database management system;
Graphic design modules;
Graphic editor;
Possibility to each other in hundreds of different fonts.
Microsoft Works is a very simple and handy package that uses a text editor, spreadsheets and data bases, as well as telecommunication tools for connecting with other computers via telephone lines. A package of orientations for people who do not waste time to master folding products, for koristuvachiv-pochatkivtsiv, as well as for home koristuvachiv.
The integration of packages will ensure one-hour selection of a number of functional and typical packages in a particular gallery.
Integration packages are handy for koristuvachiv. The stench may have a single interface, do not interfere with the sticking of software tools, which can be entered before them, it may be enough high speed rozvyazannya tasks.
Integration packages - a set of a number of software products, combined into a single handy tool, which was intended more.
The integration package, as a rule, includes shoes, shoes and a program, so the pennies are spent on the new one for nothing.
Integration of software packages - for the number of products, the number of products is not numerous, but in the calculation plan, there is a hard part that is actively developing software(PZ).
Use an integration package for the analysis of fixed-income securities, which consists of a yield calculator, portfolio analysis tools and bond swap contracts. The program calculates the profitability of any types of valuable papers with a fixed income; Data can be collected from files or collected from portfolio analysis modules or swap contracts.
Also, there are special integration packages for the office, to which you can enter mutually software products. The main authority of the program, which is to establish the integration of the package, is the main interface of the core, which allows you to stop similar approaches when working with different package add-ons.
Within the framework of the integrated package, there is a secure connection between the data, prote with which the ability of the skin component is sounded in parallel with a special similar package.
Interface for more early programs of changing the options with different ways to exchange data and descriptions of the middle of the work, how to change the number of navichok and know how to change the modes of the package, formats of data, principles of saving and manipulating different types of data, that in the kіntsevu rakhn Today's packages (for example, Microsoft Works) have a few shortcomings: the simplicity of the interface allows you to zastosovuvat yoga without prior training for staff.
The basis of the integrated Works software package is based on the principle, which makes it easier to master and work with it, to designate its compactness and at once sufficient strength as a universal instrumental tool.
Analysis of the areas of congestion to produce, to the extent necessary, the distribution of decals of integration packages. Additional distribution of a number of integrated packages, which include the onset of a set of functions, as a matter of fact, they would be expanded in memory for an hour of work: tabular processing, graphics, file system, statistics, simple data base, machine call
Another reason is that there are a lot of potential integration packages, even though they are large, but still less. If more is quiet, to whom such packages are effectively necessary, their mother (and it will become sooner), the chances of success are less than the most important products. Slid also to protect the high price of commercial risk for the release of such a folding and expensive product.
Integration packages PPPs are called, which can be used in their own functionally different software components of the PPP of a global nature.
PSP integrations may include:
Text editor;
spreadsheet;
Graphic editor;
Communication module.
As additional modules, the integration package can include such components as a file export-import system, calculator, calendar, programming systems.
Information call between components is secured by a path of unification of formats of presentation of different data. Integration various components in single system Nada koristuvachevі neperechnі perevagi in Іnterfeysі, albeit inevitably prograє in part of the advancement could up to operational memory.
Three of the first packages are the first Framework. By far the most expanded integration package is Microsoft Office.
CASE technologies(Computer Aided Software / System Engineering) to be involved in the creation of collapsible information systems, which require collective implementation of the project, in which to take part in various factors: system analytics, project developers and programmers.
Pid CASE technology to understand the sequence of means of automating the development of an information system, which includes the methodology for analyzing the subject area, designing, programming and operating the IC.
Instrumental CASE-technologies zastosovuyutsya at all stages life cycle systems (from analysis and design to zastosuvannya and support), significantly simplifying the task.
Collective work on the project transferring the exchange of information, control over the execution of the task, revision of that version, planning, and mutual management. The foundation for the implementation of such functions is most often the main data base for the project, as you call it repository. In essence, the repository is the main information archive, where information about the processes, data and links of objects from the addendum is saved.
Modern CASE-technologies successfully win for creation of ІС different class: banks, financial corporations, large firms.
Expert systems– the whole system of knowledge processing at higher education institutions and preparation of solutions for professional experts.
Expert systems are selected for the following purposes:
Interpretations will become systems;
forecasting situations in systems;
Diagnostics of the systems;
Tsіl'ove planning;
usunennya disruption of the functioning of the system;
Management of the process of functioning; and etc.
We build the basis of expert systems base knowledge, information about a given subject area is stored in the yaku. Two main forms of representation of knowledge in the EU: facts and rules. Facts fix kіlkіsnі and yakіsnі indicators of phenomena and processes. The rules describe the svіvvіdnoshnja mіzh facts, zvlyadі logical minds, scho pov'yazuyut causes that naslіdki.
How to implement the implementation of expert systems on EOM vicorist so called shells of expert systems. Butts of shells of expert systems, zastosovuvanih ekonomiki, є: Shedl (Dialog), Expert-Ease and others.
1.6.5 PPP method-orientation. Method-oriented PPP We are concerned about the fact that in the current algorithmic basis of implementation, there is an economic-mathematical method for solving the problem. Before them one can see the PPP:
Mathematical programming (linear, dynamic, statistical, etc.);
Merezhevoy planning and management;
Theories of mass service;
Mathematical statistics.
Yak butt can be pointed statistical data processing system STATISTISA .
1.6.6 PPP problem-orientation. Problem-oriented PPP - all software products that are considered to be a task for a specific functional area.
From a wide range of problem-oriented PPPs, there are apparently groups recognized for complex automation of management functions in industrial and non-industrial areas, as well as PPP of subject areas.
Problem-oriented PPP for the industrial sphere.
Modern integration information systems owing to the acknowledgment of the low new vimog.
In the first place, the stench is not only responsible for planning with thorough methods (comprehensive planning schedule, consumption in materials, pressures), control over the work plan (inventory management, customer requests, task orders, procurement of cards and technologies), , cheruvati financial and labor resources, and zdіysnyuvati a number of "non-virgin" functions to control service maintenance, rozpodіl finished products and marketing.
In another way, the stench is not focused on the mainframe (large EOM), but on the client-server architecture, based on rich tasks, reliance on rich corestuvachiv operating systems(Type UNIX) and relational databases, developed on the basis of CASE-technologies.
Thirdly, modern building systems support different types virobnitstva; preparation "in reserve", production and preparation of a batch for a purchase, storage for a purchase, small-scale production of large-scale production, production with an uninterrupted cycle.
Variety of more complex problem-oriented PPP high (no more than 1 million dollars).
Electronic office
1.7.1 Concept of e-office
1.7.2 Microsoft Office warehouse
1.7.3 Free Office OpenOffice (Libre)
Literature: 5, p. 311-401; 6, p. 417-590; 2; 4; eight; nine.
1.7.1. Understanding the electronic office. Dosit bike kolo zavdan, virіshuvanih for Relief PEOM mozhna vіdnesti to ofіsnih: dіlovodstvo, upravlіnnya control upravlіnnya, stvorennya zvіtіv, search Search, Introduction that do updates Informácie, skladannya rozkladіv, obmіn іnformatsієyu mіzh pіdrozdіlami vіddіlіv, mіzh vіddіlami pіdpriєmstva that mіzh pіdpriєmstvami. In these tasks, you can see the following typical procedures:
Processing of input and external information (reading and revisiting on the sheet, writing letters, circulars and other documentation, as well as including little ones and diagrams);
Selecting and further analysis of data (spontaneity for songs of the period an hour for different advances depending on different selection criteria);
Taking the information that you need ( swedish access to information and search for necessary data).
Qi procedures can be developed within the framework of the electronic office.
Electronic officeis called a software and hardware complex, intended for processing documents and automating robots in control systems.
The warehouse of the electronic office includes the following hardware: EOM, which can be combined into a local area; attachment for displaying information on a paper nose (printers, plotters); make copies of documents; modem (like the computer is connected to the global network or territo- rially outside the EOM). Additionally, scanners can be included in the hardware warehouse, which are used for automatic text input. graphic information directly from the primary documents; projection equipment for presentations.
The main software products to enter the daily office:
Text editor;
spreadsheet;
Communication module (often go with the organizer).
The office software warehouse can also include: a database management system, an analysis program and a warehouse layout, a presentation program, graphic editor, the program will translate and recognize texts
Office software products are produced independently, and at the warehouse of integrated packages. The head office of the program that folds the integration package, є sleeping interface Koristuvacha, which allows you to set up your own (or similar) work with different programs of the package. Interaction of programs warehouses equal documents. Tse means that the document, creations in one appendix, can be inserted into your program and, if necessary, change it. The complexity of the interface will change to a new one. In addition, the price of a set of three and more additives, which are supported by one and the same virobnik, is significantly lower, lower total price, so you can buy them all right.
In the present hour on the market of office products in the krains of the Soviet Union (both legal and pirated) dominated by Microsoft Office by Microsoft. On the legal market of the "wild Sunset" the situation is different - the professionals have a new word about the WordPerfect editor, which is included in the Corel (formerly Borland) Office for Windows package, the famous SmartSuite package from Lotus Development.
1.7.2 Microsoft Office warehouse. The integration package of Microsoft Office has two options, which are determined by the program warehouse, which are included before the new one: Microsoft Office, called the standard edition, and Microsoft Office Professional. Today, the version of Microsoft Office 2007, 2010 has been expanded the most, although the structure of the package is filled with a significantly more recent version.
One of the most significant features this packageє those who are in the new zіbrano addenda, yakі allow you to win practical work, like a robot, related to business.
Slid to indicate that Microsoft Office has its own delimitation of the ranges of program jams. In other words, the skin appendage is hoaxed to finish a wide area professional activity Koristuvacha, but at the same time, the regions are a little overwhelmed. However, there is a real possibility of promoting the objects themselves Office programs other software package.
To Microsoft Office warehouse enter:
Basic kit
Word text processor - allows you to create and arrange text documents to select all types of formatting (font parameters, lists, columns, write thinly), create tables, little ones, formulas, diagrams, WWW-documents thinly.
Email Editor Excel spreadsheet- zastosovuetsya for vykonannya different calculations for vykoristannya exhaust device functions and formulas for carrying out statistical analysis, and also allows you to use these diagrams and graphics on the support.
Office manager Outlook - one-stop management program electronic mail, collation and management of facsimiles, a planner of contacts and contacts, a note book and a lot more.
course work
Discipline "Information systems of economics"
On the topic: "Integration packages for offices"
Zmist:
Entry
Section I Software structure
1.1 Understanding software security
1.2 Software classification
1.3 Integration packages application programs
Chapter II Integration packages for offices
2.1 Application package Microsoft software office
2.2 Additional office software
2.3 Alternative office packages
Visnovok
List of references
Entry
A set of office programs can be downloaded a lot. The stench may have different functional possibilities, but to the configuration of the computer and the qualifications of the coristuvach.
The main packages are Open Office, Microsoft Office, Star Office, Lexicon XL, Microsoft Works.
The purpose of office software packages is to provide office workers and businesses with a wide range of kits for everyday sleeping work, to automate routine operations, to help with complex business management.
Recently, integrated packages have appeared that allow you to use your own text, tabular and graphic processors, and build a data base management system. For example, Framework, Symphony. Nadal in іntegrovanіnі packages bоl add іnіnіtі vіdіmіrnoі ї graphics, manager іnformatsії, system elektronіznavannya dokumentіv, e-mail, eg Borland Office for Windows іn іnі Novell (nіnі Corell Office), Smart Suite іn іm Lotus Development (pidrozdіl IBM) аnd іnshі. In our country, the Microsoft Office package by Microsoft has become a very wide-spread integration.
The purpose of Microsoft Office is to provide tools to automate the folding and execution of documents for the majority of corporate employees - managers, accountants and other spivrobitniks of offices. Tight integration of the Windows operating system and the Microsoft Office package allows you to improve the computer's capabilities.
For more than 15 years, the Microsoft Office product has entered the software product market and, of course, having recognized the changes associated with the growing needs of the core.
In this rank, I use the following topics: "Integration packages for offices". The meta vimagala of the upcoming tasks has been set:
vichity theoretical aspects;
analyze the structure and methods of integration packages for office on the MS Office 2007 application.
For this robot, the characteristics of the stasis on the current day of integration packages for the office have been induced, and their subsequent analysis has been broken down. A specific example of office automation based on the Microsoft Office product has been introduced.
Section I Software structure
1.1 Understanding software security
By itself, the computer is impromptu vikonati zhodnoї dії. To “explain” the computer, those that are required by the Vikonati for reaching the goal, are engaged in programming (programming)1
, that is the process of creating programs, including analysis of all possible stages of development and implementation.
A set of operators, which can be presented as a single goal in a given counting system and victorious to control the behavior of the system, is called a program. Under the operator to this particular type razumієєtsya dіya, yak mozhe buti vykonana over one or dekіlkom operands for otrimannya results. Sounds like this is indicated by the symbol of the operation (command) and the change (parameters), as to set the specific values of these operations.
As a rule, for the attainment of the goal, it is necessary to implement not one, but a whole set of actions, which are in the singing sequence. The sequence of clearly defined rules is set for the end of the day, and the number of commands for the end of the set task is called the algorithm.
The existence of programs, recognized as a top priority on a computer, is called software. Software security is an invisible part of the enumeration of systems and not only the programs in a symbolic notation, but also the formation of these programs, as well as the documentation that accompanies the programs.
1.2 Software classification
All software security (PZ) can be divided into system PZ, system programming and application PZ.
System software security plays a major role through those that, without a frontal test of operational control over the robot, it is impossible to add to the robot, and without a description of the basic functions of the PC, it is impossible to follow the desired command.
Components of system software are operating systems, control and diagnostics.
Operating systems take special care of the environment of the system PZ, the oskіlki okremі programs of the operating system are repaired right after the PC is turned on. The very stink of zdіysnyuyut dialogue koristuvach that PC, keruyut computer resources. operational memory, mіscem on zvnіshnіh nіyа, іnformаtsiї), launch application programs at the robot, secure a friendly (friendly) interface for application programs.
From the beginning of zastosuvannya in computers, microprocessors and microprocessors to operating systems grew up and the middle of the rich varieties of software developers of operating systems began to take a leading position.
Until recently, on computers like the IBM PC, a number of different operating systems were installed:
MS-DOS - disk operating system by Microsoft (most popular);
PC-DOS - IBM's disk operating system;
DR-DOS - disk operating system by Digital Research (it works for an hour with Novell firmware);
UNIX - disk operating system by Bell Laboratories (working for an hour on the Internet);
Linux is one of the variants of the UNIX-type operating system.
In the rest of the world, most personal computers are used under the supervision of the Microsoft Windows operating system.
The other important component of the system software is drivers - expanding the capabilities of DOS with the management of various PC attachments (keyboard, mouse, RAM, hard disk, etc.). With their help, you can connect new attachments to the PC or modify the installed ones.
The third group of system software security is to become shell programs, which provide the best and simplest way to communicate with a PC. The most popular is The Norton Commander and its analogue that works keruvannyam Windows, - Windows Commander.
For work in a graphical mode, an operational shell is recognized - a group of hard programs that give the ability to simultaneously display a small number of programs (multiprogramming), prompting vicons on the screen, which represent a rich set of tools for displaying an image on the screen and manipulating it. The most famous Windows operating system by Microsoft. Let's close it to the next group to include GEM, GeoWorks, DesqView.
At the end, the rest of the group of the category of the category should be called to add additional programs (utilities). Before them, bring:
programs-packers that allow using special methods to "grab" files that are designated for archival storage. The most popular ones are ari.exe, rar.exe, zip.exe;
anti-virus programs, recognized for diagnostics and “excellent” programs, infected with computer viruses (AVP Kaspersky, Doctor Weber and others);
communication programs, recognized for organizing the exchange of information between computers (LapLink.exe, DeskLink.exe, FastLynx.exe, etc., which are subject to free access);
diagnostic programs that allow protesting the practicality of various PC attachments and retrieving additional information about the technical capabilities of the PC (ScanDisk, Check Disk);
optimization programs, “cashing” and dynamic disc compression, program management of memory and a signet too thin. (SmartDRV, QEMM-386).
programming systems enable movie programming and translators, and allow expansion as a system, and application software. Otzhe, in programming, stinks play the role of contributors to prevention. Fallen due to the foldability of the language of the program, it is subdivided into the language of the high and low equivalence. What is the folded language, the lower її rіven and the greater, as a rule, yogo ability.
For example, BASIC, which is the most accessible for my education, oriented towards a dialogical work, is brought up to the mov of a high level.
Assembler is considered to be a low level language, a language that reflects the architecture of the EOM, providing access to registers, specifying addressing methods, and describing operations in terms of processor commands. Mova Assembler to serve as a distribution of operating systems. The other representative of low-level mov є СІ - universal mov programming, yak mov system programming for the UNIX operating system has been broken up. In Denmark, one of the most popular mov.
Riznomanitnist mov programming viklikana great rіznomanіtnіst zavdan, scho to stand in front of the computer. So, for the conduct of scientific investigations in 1956. It was created by FORTRAN (FORmula TRANslator), for example, the 50s - MOV Algol (ALGOrithmic Language). First of all, in a way it was promoted to a broader understanding of the type of data and the principles of structural programming, becoming Pascal.
In addition, to complete a great set of specialized languages - dBase, SQL, Turbo Pascal, Prolog, Visual Basic, JavaScript, DELPHI, PHP etc.
From the hour all the movies know the changes, new versions are announced. Therefore, name the movie and then name the version number that is made up of two parts (for example, 5.1, 4.02). As the language in the new version recognizes the original changes, the first part of the first issue is changed, so there is no more about insignificant additions - a friend.
Sound the program to be written symbolically mine, close to English. The text of the program, written in a shorthand, is called an external module. Tsey text is unreasonable to the computer. For translating a output module into an object - a collection of machine commands, translators are selected. There are two types of translators: interpreters and compilers.
The interpreter ensures the command translation of the text of the program with one-hour translation into the machine code of the command. The translation procedure is accompanied by a re-verification of the correctness of the written command. As a result of the re-verification, a pardon appears, the programs are attached, and on the screen there are information about the nature of the pardon (as a computer can be identified) and the number of the row, in which the pardon is displayed. Up to a small work of an interpreter, you can save a low productivity. This is why it is explained that when the skin program is launched into a vikonannya (it is guaranteed not to avenge the annual pardons), there is a reverberation for the presence of pardons and translation into a machine code of the skin row to the text of the program.
Compiler to translate (with one-hour reverification of the correctness of the written commands) from the machine code the entire program immediately. Through war the object module is created. If necessary, a few object modules for additional special program-linkers will be combined into one advanced module. As soon as the exciting module is created, the program may be launched. Programs translated into machine code with the help of a compiler work much better, because when you start the program, it starts to change without additional rewritings and translations.
Applied Software Security to divide into three groups fallow in the area of zastosuvannya.
The first group is made up of applied programs of high recognition. Before them one can see: text editors, spreadsheet processors, DBMS too.
Text editors - programs for creating and processing texts and document programs. Isnuє dosit great translation of such programs. The skin of them may have its own advantages and disadvantages. The most popular text editor is Microsoft Word.
The spreadsheet processors handle large amounts of numerical information. The largest spreadsheet processors are: Excel, Lotus. The absolute leader is the spreadsheet processor Excel, developed by Microsoft. A tabular processor is a rectilinear table, in which the numbers, symbols (words), formulas can be moved to a rozrahunku value. More tabular processes are securely completed with rich libraries of functions for rozrachunkiv. Krіm billing a lot of programs tsієї groups allow buduvavat schedules for nayavnymi dannymi. As additional services, they often rely on the ability to record macro commands, create their own input and output forms, as well as exchange information with data bases.
Data base management systems (DBMS) are information and search systems that allow processing (entering, sorting searches, sorting, etc.) a large array of information. The butt of the simplest base is an elementary file cabinet. Folding DBMSs allow you to revise tasks, link them with the processing of a large number of information arrays, linking them together with different files. The most popular DBMS are Oracle, MS SQL, Access. Recently, dBase IV, Paradox 4, Fox Rro, Clarion Professional Developer, Clipper, RBase have been widely tagged.
Systems of business and science graphics allow you to display different graphics and diagrams on the screen. Among these systems, the most popular are Microsoft Chart, Harvard graphics, StatGraf.
To another group, specialized application programs have been seen. Before them, one can see applied programs that may be on the basis of the vision of any higher education specialists. For example, in the software market, there is a large set of accounting programs (1C, BEST, Turbo-accountant, Vitrilo toshcho.), Basic programs (moving, mathematical and others.).
Integration of application software packages with your own capabilities of text editors, spreadsheet processors and DBMS. As a rule, the interface of the skin component may look arguably similar, the same type of code is used in the same way, which makes it easier to master the entire package. The best representative of the group of software products is Microsoft Office, a product of Microsoft Corporation.
1.3 Integration of application packages
Integration packages- the whole set of software tools of different recognition with a single interface of the coristuvach, with a single vicorist of one and the same data.
The most extensive integration packages, such components:
DBMS;
text editor;
spreadsheet processor;
organizer;
sobi podtrimki electronic mail;
presentation programs;
graphic editor.
The components of the integrated packages can be isolated one by one, but the main advantages of the integration packages are shown at the current reasonable connection one by one. Koristuvachі іntegrovanіh pakіv mаyut іnіfіkovanіv іnіfіkovanіv іrіznyh komponentіv іinterfeys, tim sampechyuєєє vіdnosna vіdnosna vіdnoєєєєєєєєє ії іїnіgo іkhny osvoєnnya.
Considered rices of this class of program benefits:
fullness of information technologies for endocrinologists;
the same type of interface of the terminal box for all programs that enter the warehouse of the integrated package - the main commands in the menu, standard icons of the same and the same functions (saving on the disk, others, rechecking spelling, font design, etc.), standard operation with dialog boxes in;
global service for a software integrated package (for example, a dictionary and spelling checker for spelling, alarm clock, data converter);
ease of exchange and sending to objects created by programs of an integrated package (two methods are established: DDE - dynamic exchange of data and OLE - dynamic linking of objects); one-man transfer of objects (drag-and-drop method);
the presence of a single moving platform for the analysis of macro commands, programs of the core;
the ability to create documents that can be integrated with your own ability to use different programs that enter the warehouse of the integrated package.
Integration of packages is effective and for group work in a large number of rich coristuvachs. So, with application programs, in the same way, it is possible to send documents and data files to another person, with which the standards for transferring data from objects to objects through a network or through e-mail are supported.
The main authority of the program, which is to install the integration package, is the main interface of the core, which allows you to stop one or the other (or, similar) applications with different add-ons of the package. Interaction of programs warehouses equal documents. Tse means that the document, creations in one appendix, can be inserted into your program and, if necessary, change it. The spіlnіst іnterfаshuє vitrati navchannya koristuvachіv. In addition, the price of a set of three and more additives, which are supported by one and the same virobnik, is significantly lower, lower total price, so you can buy them all right.
Chapter II Integration packages for offices
2.1 Microsoft Office Application Suite
Microsoft Office is a package of application programs that allows you to perform various tasks. Microsoft Office sheets are closely related to each other, so often their entirety is seen as a single program.
The first riddle about the Microsoft Office package falls on the cob of the 90s of the XX century, if the first working version was released - Microsoft Office 4.2. That hour had a small set of office products for one koristuvach.
Less than 10 years later, Microsoft Office 95, Microsoft Office 97, Microsoft Office XP, Microsoft Office 03, and in the end of 2007 were released. Microsoft Corporation has announced the release of the draft version of Microsoft Office 2007.
For such a non-trivial hour, the package turned into a widely integrated system, which includes not only other basic data processors (text and spreadsheet processors, database management systems, personal information management systems and a number of others), but servers, services and programs for desktop computers. yuterіv, rozroblenі for splnoї raboty s vіrishennya wide stake business-zavdan.
Under the hour of the creation of new versions of the package, deacons and addenda were merged: for example, the Microsoft Schedule + program (rozlad) went to the warehouse of Microsoft Outlook. Some programs were turned off from the package through those that other programs took over their functions (for example, the Card File program (file cabinet)).
Traditionally, the Microsoft Office application package has a few delivery options:
standard (standard), appointments for corporate employees, the scope of interests of which expands to the basic set of tools for organizing business, collaborating, publishing and analyzing documents with organizations and the global Internet;
small business edition (small business edition) for recruitment at small businesses;
professional (professional), which has a standard version supplemented by a database management system;
special professional (professional special edition), in which the professional version is supplemented by systems for curation of websites and websites;
rozrobnik (developer), appointments for professional rozrobnikіv i mіstit krіm novnoї spetії professіynoї її ї іnstrumentarіyu і dokumentії ії ії іnstrumentarіu і dokumentії ії dlya sovlennya, provodzhennya і pіdtrimki іshenа basії Microsoft Office.
Before the warehouse of the package, there are two blocks of components - the main and additional ones.
Block of main components consists of upcoming additions:
Text processor Microsoft Word. It is a richly functional rich text editor that allows you to create documents of any level of complexity, and there is a great set of tools for editing and designing them.
The creation of a document by a text processor can be done in two ways: the creation of a "passive" document; creation of a standard document.
Rice. 1 Microsoft Word 2007
The creation of a "passive" document is used for additional text typing with yogo design (formatting). The creation of a standard document contains the basics of templates - an interactive form that will require completion.
The text processor allows the creation of tables and tabular forms, the layout of the text in the columns, the drawing, the processing of the graphic objects, the creation of documents for the serial expansion (the creation of documents), the creation of virtual documents, files.
Spreadsheet system (spreadsheet processor) Microsoft Excel. The scope of the spreadsheet processor is much wider: for example, the number of elementary calculations before the creation of accounting books, accounts, diagrams and financial models. The spreadsheet is provided with exhaustive methods for analyzing data and prompting diagrams, as well as analytical functions. To the main services of Microsoft Excel, one can add the ability to variably order information on archways and in books, on the basis of the functions of the program, to create wave functions and formulas, whether of any equal folding, to create the same three world graphics and diagrams, process information from databases in lists, analyze and expand scenarios, improve the productivity of the work for the workflow and the loading of macros.
Rice. 2 Microsoft Excel 2007
Excel distinguishes between the following types of data: numbers, text, formulas, textual formulas, text numbers. Excel itself recognizes numbers and text.
Microsoft PowerPoint presentation preparation system. It has been developed as a feature for creating slide and projection presentations, automatic demonstrations and multimedia exposures. The program allows you to make presentations on the basis of standard slide sets or to set your own fee for additional presentation aids PowerPoint and data from Word, Excel or Access. The program has a great set of slide templates. The slide can have textual information, various types of graphics and diagrams, graphic images. Animation effects when displaying information in the middle of a slide and when changing slides, make your software product an indispensable tool for preparing and conducting various presentations.
Figure 3 Microsoft PowerPoint 2007
personal information management system Microsoft Outlook - an add-on that includes the functions of an electronic recorder, a clerk, a special layout for folding, a graphic image and information, with the possibility of processing electronic mail.
Rice. 4 Microsoft Outlook 2007
database management system Microsoft Access- an addendum for working with data bases, for the help of which you can create lists of customers, collect general information about goods and other data ordering. For the convenience of mind search for information, displaying on the screen (other) the results of the search, the system presents the possibility of creating different forms, making it sound like in the master mode, and in the designer mode, depriving you of the right to independently form the name of the document on the screen when you look at it druk.
Rice. 5 Microsoft Access 2007
The Microsoft FrontPage Web Site Crawling System is a program that allows, in an interactive mode, to viconate all the necessary functions, and to create and edit web pages of a Koristuvachev, who is not known by special languages for the Internet.
floor viewing system Microsoft Publisher. The main purpose of this program is to create professionally designed publications - brochures, booklets, cards, leaflets. A lot of mastrіv (special software tools) allows you to automate the process of document execution.
system of keruvannya projects Microsoft Project. The product may be able to help you to get that information necessary for making managerial decisions, and that efficient algorithms for analysis.
system for preparation of diagrams Microsoft Visio To create a rich library of diagrams that allows you to organize (ararchy), cyclical, radial, pyramidal and other types of diagrams, whether of equal complexity.
Up to number additional supplements be seen:
interpreter for requests before foreign bases danih Microsoft Query;
drawing program - flowchart Microsoft Organization Chart;
program for creating charts Microsoft Graph;
the program for creating curly texts Microsoft WordArt;
editor of mathematical formulas Microsoft Equation;
Microsoft Office Document Imaging Text Recognition Program;
get Microsoft Draw;
geographical maps Microsoft Map;
and etc.............
Integration software packages- for a certain number of products, the number of products is not numerous, but in terms of numbering, there is a part of the production that is actively developing.
Traditional, chi pov'yazanі, іntegrirovanі є software kompleksiє є rich-functional autonomous package, yakim one goal za'єdnіnі functions ї and the feasibility of different spetsіalіzovanіh (problem-oriented) packages, sporіdnenіh sіnі technії ї kremіtsomі tsomіtsіmі okrubomі. Representatives of such programs are packages Framework, Symphony, as well as packages of the new generation "Microsoft Works", "Lotus Works".
Within the framework of the integrated package, there is a connection between denim, prote with which the ability of the skin component is sounded, similar to a similar special package.
In this hour, another initiative is being actively implemented to integrate software tools: the integration of special packages within the framework of a single resource base, the provision of mutual support for add-ons (software package) on the same level of transfer to the center. Integration at times has an objective-appeal character.
Typical and most popular packages of this type: Borland Office Windows, Lotus, SmartSute Windows, Microsoft Office. The professional editorial office of these packages has several additions: a text editor, a DBMS, a spreadsheet processor, and demo graphics programs.
Peculiarities of a new type of integration of packages and the selection of shared resources. Here you can see some of the main types of shared access to resources.
1. Koristuvannya utilities, zagalnyh vsіm program complex.
So, for example, the spell-checking utility is available from all packaged programs.
- 2. Zastosuvannya objects, yakі can be in sleepy vikoristanni number of programs
- 3. Implementation simple method transition (or launch) from one supplement to another.
- 4. Implementation of incentives on the same principles of automation of work with an additive (macromovie), which allows organizing a complex processing of information when minimum vitrates for programming, that is the programming instruction for my macro function.
The mechanism of dynamic layout of objects gives the possibility of storing information created by one application program, a document that is formed by another. Koristuvach can edit the information in the new document with the help of the product, for the help of any object of creations (when editing, the additional addendum is automatically launched). Startups addendum This program for processing the document-container displays a hybrid menu on the screen for the convenience of the work of the specialist. In addition, this mechanism allows the transfer of OLE objects from one application to another.
In this technology, the possibility of a wild variety of functional resources of programs has also been transferred: for example, the module for stimulating the graphs of a spreadsheet processor can be a variety of text editor. A small amount of technology and a reduction in the format of the graphics by the size of one side.
OpenDoc is an object-oriented system that is based on the recognized standards of the companies participating in the development. As an object model, the distribution system object model (DSOM - Distributed System Object Model) was developed by IBM for OS / 2. Transferring the mix between OLE and OpenDoc.
