Open Source Open Source Software

The Open software Source definition is used by the Open Source Initiative to determine whether a software license complies with open source standards. ON

The definition consists of ten open source license requirements:

1. Free distribution. This means that the license should not impose restrictions on the sale and distribution of software.
2. Available sources. Even if the software does not come with the source text, these texts should be readily available.
3. The possibility of modification. The simple ability to read source texts does not allow you to experiment with them and release modifications
4. Even if the author's source text is intact, derived programs and their source texts should be freely distributed.
5. Lack of discrimination against people and groups of people. Some countries, such as the United States, have some restrictions on software exports.

# No discrimination on the purpose of application. A free license shall permit all activities, including genetic and nuclear research, commercial applications, etc.

1. License distribution. Open Software rights must apply to all users of the program without entering into additional agreements, such as non-disclosure agreements.
2. The license should not restrict other software products. Except for banal incompatibility, the user has the right to choose what to use.
3. License must be technologically neutral. That is, the license should not require anything from the interface or technologies used in the derivative program.
4. The license must not be bound to a specific product. The rights to the program code should not depend on whether the program is part of a product. A person distributing a program in isolation from a collection or transferring part of the code to another product has the same rights as the collection gave.

Open Source Repositories

• Open Source Repositories
• National Open Source Software Repository

2023: How China is developing Open Source projects

The Ministry of Industry information technology China and (MIIT) has prepared a 5-year plan for the development of an open in software the country. This became known in early September 2023. More. here

2021: The history and main stages of the development of open source software from the origins until 2021

In 2021, the Russian authorities again drew attention to Open Source. An Open Source development strategy is being prepared. In a word, something moved, started and went. To understand where and why, you need to thoroughly understand the question - what is Open Source and what it is "eaten with." In this article , the author tried to give the most detailed, informative and reasonable answer to this complex and relevant question.

2016: Preliminary version of open source software is presented in the USA

In March 2016, the US presidential administration presented a preliminary version of the bill on the use open source software state of departments. Market participants supported the initiative.

According to a document released by the White House, American government agencies can share source code for certain projects with each other in order to increase their effectiveness and eliminate the need to develop the product again. More on this here.

2014: Open Source vs. Proprietary Software Model

Open source software has several advantages over software products delivered on a proprietary model (see Open Source Software Benefits).

In the 1990s, free software was considered exotic in the corporate environment, and Red Hat was the only notable competitor to proprietary giants led by Microsoft for a long time, but from the second half of the 2000s the situation began to change rapidly. Open source software has become mainstream for many large companies, and dozens of trusted open source software vendors have emerged that have achieved the right level of expertise and expertise to serve large and demanding corporate customers.

In 2014, there are many players who successfully compete with commercial software suppliers in a number of areas. In addition, Red Hat these are such open organizations as software ,,,,, etc Google Apache Software Novell SUSE. Acquia More and more OpenSource analogues of existing proprietary solutions are on the market. Open source communities are growing stronger and improving product quality and functionality.

As a rule, the development itself is offered free of charge, and it is commercialized through support and customization. This creates additional competition and, as a result, contributes to the development of open source software products.

In almost all industries and areas of activity, open source software can be used. Almost every proprietary software has a valid open source analogue:

• Cisco VPN – OpenVPN,
• Oracle Database – PostgreSQL,
• Microsoft Hyper-V – OpenVZ,
• MS Active Directory – Samba,
• Avaya IP Office Asterisk –and so on.)

Based on specific business objectives, you can compare the cost and timing of implementing a solution based on proprietary software and OpenSource.

2011

Indian state of Punjab abandons open source software in favor of Microsoft products

In October 2011^[1] announced that it was^[1]the Punjab state government had decided to purchase software from Microsoft, canceling the 2008 decision to install free software on 46,000 computers in 4,956 schools. 'We decided to reconsider the previous decision,' said Baldeo Purushartha, the state's school education minister.

The Punjab Government launched the Informatization Programme for Year 6-12 students in 2004-2005. The Punjab ICT Education Department is implementing a project that organizes computer classrooms in all primary schools with necessary equipment, software and broadband connectivity to. to the Internet At the state level, the Bharat Operating System Solutions decision was widely supported. (BOSS), tested and certified Linux Foundation to work in schools, due to its financial inclusion.

According to the President of Punjab, as of 2008, the minimum cost of upgrading software with a Microsoft license - for 16,578 computers at the rate of Rs 1,375 per computer - was Rs 23 million over five years. For this reason, in September 2008, the Punjab State Government decided to purchase and install BOSS in all state primary schools and stated that from 2011, all primary school students will be trained to use BOSS. The work was completed in April 2011, including training for 6,600 teachers.

But on August 8, 2011, after a comprehensive analysis of the results of the project, the head of the Punjab Department of School Education said that "the Department of School Education will return to the use of software from Microsoft... for the education of children in the primary grades of public schools'. The cost of renewing the licenses will be about 7 million rupees, 3.77 million of which has already been allocated by the government.

Moreover, about 90,000 computers will be installed in public schools connected to the EDUASAT network, through which students will be able to watch live broadcasts from various lectures. According to preliminary calculations, the initial price of Microsoft software and licenses will be Rs. 30 million. This amount does not include the price of equipment, etc.

Earlier, in February 2011, it was decided to use BOSS to work on the EDUASAT network. But now, according to Purushart: 'In order to use the installed computers as fully as possible, on which students will master Microsoft software, we want to use Microsoft also in EDUASAT'.

Note that Punjab was the first state to actively implement Linux in schools. Currently, BOSS is still used in the Indian states of Haryana, Gujarat, Kerala and Uttar Pradesh.

Germany in 4th place in the use of open source software in the public sector

According to a 2011 study by the Georgia Institute of Technology (USA), Germany ranks fourth in the world in terms of SPO penetration in the public sector. In 2001, the Ministry of Foreign Affairs of the Federal Republic of Germany (and with it all embassies and consulates) switched to Linux. Several times, the consulting company McKinsey confirmed: the foreign ministry significantly saves using Linux, OpenOffice and Thunderbird instead of a Microsoft set of Windows, Office and Outlook. It was even said that diplomats spend less on IT than employees of any other government agency.

But the trick is that in operation conditionally free software is sometimes more expensive than certainly paid. Dinosaurs like Microsoft can perform support better and cheaper than small Linux companies. And sometimes it is more profitable to buy a license. Therefore, for example, the same German foreign ministry is returning to Microsoft software this year. Officials assessed the money as permanent problems with technical support, as well as the difficulty in mastering the SPO (many employees complained about this) and spoke in the spirit that^[2] pays the stingy twice].

2010: Vladimir Putin ordered to transfer power to free software

In December 2010, Prime Minister Vladimir Putin signed a document describing the schedule for the transition of power structures to free software (SPO). The document is called "Plan for the transition of federal authorities and federal budgetary institutions to the use of free software" and covers the period from 2011 to 2015.

Deputy Head of the Ministry of Telecom and Mass Communications Ilya Massukh told CNews that the document provides for the complete transition of federal authorities and state employees to free software. The plan takes 17 pages, you can download it here (the idea to save the document on the SPO in the.doc format belongs to the apparatus of the government of the Russian Federation).

By Q3 2011, data format specifications that will be supported by free software must be approved. By the same time, according to the plan, changes to the instructions for accounting for intangible assets will be developed. This item of the program should solve the long-standing problem of accounting for both free proprietary and free software that do not have their own value.

Testing of the basic software package in pilot institutions should begin in the second quarter of 2012. The implementation of the free software package in authorities and budgetary institutions should be completed by the third quarter of 2014.

One of the most interesting points of the plan was the mention of the national repository, which should be created by the second quarter of 2012. Deputy Minister of Communications Ilya Massukh explained that the document means "not so much the assembly repository of the Linux distribution as the application store like the App Store, but for free operating systems." The creator of the repository will be chosen either by a government decree or on a competitive basis, Ilya Massukh explained.

One of the oldest SPO repositories in Russia, Sisyphus, is owned by the developer of the distribution of the same name, Alt Linux. According to its general director Alexei Smirnov, who is familiar with the plan for the transition of authorities to the SPO, this is not about giving Sisyphus the status of national, but about making the most of it. In 2010, Sisyphus turned 10 years old, the number of packages in it exceeds 10 thousand.

The All-Russian State Information Center (OGIC, ogic.ru), which had a chance to become a single Russian portal of public services, is mentioned in the text of the document as the technological basis for creating a federal repository. However, in early 2009, the project was transferred from the FSAU Voskhod Research Institute to Rostelecom, and a new version of the All-Russian website of public services in December 2009 was launched at gosuslugi.ru.

The history of the document on the transition of the authorities to free software has been going on since 2007, when the Ministry of Information and Communications began to develop the "Concept for the Development and Use of Free Software in the Russian Federation," which was published in the spring of 2008. However, the resignation of Minister Leonid Reiman and the appointment of Igor Shchegolev to his post soon led to a revision of the concept.

Despite this, in the spring of 2008, a few days before the transfer of power to Dmitry Medvedev, Vladimir Putin, while still the president of Russia, mentioned the migration plan for the federal institutions in the list of his instructions to the government, thus setting this task to himself.

Signed by Putin and published on the government website, the current text of the order was submitted to the Ministry of Communications for approval by the government in November 2010.

2008: Russian President Medvedev's project to introduce open source software in schools and the public sector

By the decisions of the government and President of the Russian Federation Dmitry Medvedev, domestic open source software in 2008 was to be implemented in all schools of the Russian Federation and installed in all state and budgetary organizations to ensure national security in the IT field.

At the time, Russian President Dmitry Medvedev said:

... "If we now sit completely on the needle of foreign software and" lay down "for many years, then we will not get off with it. And we will develop contrary to world trends. At the same time, it is also impossible to announce that tomorrow we will transfer all computers in schools (and potentially this is a much more serious network of computers) to open source programs with a free license, because there are docking problems, there are technological problems. That is, there is no complete readiness here either. What should I do?

We propose to follow a compromise path, and this path has now begun to be implemented. Purchase a license package of basic programs for three years (meaning primarily operating systems, archivers, offices, editors, Photoshops - in general, everything that is usually used by users, including in schools), but at the same time not to stop, but to work on a domestic package of open access programs (and now we will talk about it in more detail), so that later, ultimately in three years (if it turns out earlier - even better),

To create such an optimal model in which schools and, potentially, all state institutions will be able to choose what they need: either continue to use commercial products at their own expense, and not at the expense of federal funds, or switch to an already absolutely adapted, acceptable system for them, based on open access, on open code.... "

Project "Penguin" - project of introduction of Technologies Linux and Open ON to schools and universities Russia in 2009-2010. funded by FAO, the Federal Agency of the Russian Federation Formations. According to the Penguin project contract, three stages must be completed:

1. Revision of textbooks and methodological support
2. Develop technical support and Internet portals.
3. Educating 60,000 teachers on Linux and Open Source technology

1. The development of basic computer science textbooks for universities and schools on the basis of open software in accordance with state standards and the requirements of the Unified State Exam in computer science and ICT was carried out in 2008-09. 2. The development of Internet support with basic computer science textbooks and basic Open Source packages for Winduz and Linux was carried out in 2005-2009. 3. Pilot courses for informatics teachers and teachers of schools Technologies Linux and Open Software were conducted and worked out in 2005-2007. together with Moscow pedagogical universities of Moscow State Pedagogical University and Moscow State Pedagogical University with the support of UNESCO, IBM Corporation and Linux Center.

Open software packages for schools are designed to install programs in schools and home computers with Windows and Linux operating systems. Linux Live-CD is designed to run on open source software on Windows home computers without installing Linux on the computer.

Open Programming Systems:

1. FreePascal 2.0.4 - Free Pascal Compiler and Object Pascal - Lazarus or KDevelop is recommended as IDE.
2. Eclipse - Open suite of open source programming systems to develop modular cross-platform applications.
3. Gambas - free programming system 2) VISUAL BASIC IDE for creating programs based on Qt, GTK, OpenGL, SDL and CGI WEB

The minimum Open Source Software package for schools includes open source software programs:

1. XFCE graphics environment;
2. Abiword Quick Text Editor;
3. Gnumeric spreadsheet editor.

Minimum Open Source Software Package:

1. Office suite: "'OpenOffice.org 2.3;
2. Web browser: Firefox 2.0;
3. Email: Claws Mail;
4. Image Editor: Gimp 2.4;
5. and more than 1000 programs that allow you to solve a wide range of problems.

Additional disc Contains programs for schools and other educational institutions:

1. Bluefish Web Page Editor;
2. Programming languages ​ ​ pascal (Free Pascal and Lazarus), basic (gambas), logo (KTurtle);
3. Systems of mathematical calculations (Maxima and Scilab);
4. ClamAV antivirus and Squid caching server, PostgreSQL DBMS

Optimized for computer installation and operation from 128 to 256 MB of memory and a processor from PI 233 MHz.

Linux Live-CD is designed to run on open source software on Windows home computers without installing Linux on the computer.

Linux Live CD is optimized to work with a CD for installing Linux on a computer from 128 to 256 MB of memory and a processor from PI 233 MHz. Work sessions are supported that allow you to save settings and documents in your home folder between reboots.

The option with the lowest hardware requirements provides acceptable performance even on systems with 128 MB of memory.

Includes XFCE graphics environment; This distribution includes the easy and fast Abiword text editor and the Gnumeric spreadsheet editing program.

In addition, the first disk contains:

1. Office suite: OpenOffice.org 2.3;
2. Web browser: Firefox 2.0;
3. Email: Claws Mail;
4. Working with images: Gimp 2.4;
5. and more than 1000 programs that allow you to solve a wide range of problems.

School Server - a server operating system with wide functionality, fully configurable through the web interface through which the components are managed.

Composition:

1. web applications to help you organize the educational process:
2. Moodle - remote and interactive training system, contains examples of courses;
3. Mediawiki - a system for organizing a "knowledge base" using Wiki technology;

to organize a local network:

1. DHCP and DNS servers;
2. Squid proxy server (with support for access statistics output);
3. firewall;
4. Manage network interfaces.
5. Exact time server.
6. file servers:
7. Samba server (to organize access to directories available using the Samba protocol);
8. FTP server;
9. Interface for creating local repository mirrors.
10. The CUPS print server.
11. MySQL (for Moodle and Mediawiki);
12. web server Apache2;
13. interface for updating the system (including setting up updates).
14. backup;
15. account management (the ability to import accounts from the 1C system: Chronograph);
16. Email server with support for virus and spam controls.

By the decisions of the Government of the Russian Federation, domestic open source software in 2008 and 2009 was sent to all schools of the Russian Federation and will be installed in all state and budgetary organizations to ensure national security in the field of IT.

2007: Textbooks for universities and schools with data on open source software in Russia

In 2007, the first computer science textbooks for universities and schools for teaching computer science were released in accordance with state education standards with free open and commercial closed software on Windows and Linux.

Computer science textbooks can Kaymina be used to prepare for the exam and entrance exams in computer science to universities based on Open Source Software in Windows and Linux.

2007: Open source software is recommended for use in Russian schools

The use of Open Software and Linux Technologies in schools and universities in Moscow began in 2005-2006. after the holding of schools-seminars "Linux Technologies and Open Software" in conjunction with the IBM a nd UNESCO Corporation on the basis of Moscow State Pedagogical University.

In 2007 by decisions of the Government of the Russian Federation, basic Open Source packages were recommended for implementation in all schools of Russia and use for teaching informatics and information technologies in all computer science rooms of all schools of the Russian Federation.

1998: Basic packages of open source software for schools in Russia developed

The background of the basic packages of programs on informatics, their development, implementation and distribution in schools in Russia and the CIS countries began in the late 1990s, when the basic packages of programs were developed for domestic personal computers BC, Corvette and UKNC and distributed in the form of Open and Free software for schools.

All secondary schools in Russia in 2008-2009. received basic packages of licensed commercial and free open source software for teaching computer literacy, the basics of computer science and new information technologies with Windows and Linux operating systems.

In four regions of Russia in 2008-2009. launched work on the implementation and use in secondary schools of basic software packages for computer science and computer engineering rooms and began training teachers and computer science teachers of open source software technology in Windows and Linux environments.

According to the Information Security Doctrine of Russia, training in computer literacy and computer science should be accompanied by legal education in training in protecting information in computers, protecting against computer viruses, porn sites and ensuring information security in local and global computer networks based on free open source software.

Products developed according to the open source software model

Linux Operating System

Linux, GNU/Linux is the common name for UNIX-like operating systems based on the kernel of the same name and libraries and system programs collected for it, developed as part of the GNU project. Linux can be freely installed and used on personal computers, servers and supercomputers along with free open source software packages.

Unlike most other operating systems, GNU/Linux does not have a single "official" configuration. Instead, GNU/Linux comes in a large number of so-called distributions, in which GNU programs are connected to the Linux kernel and other programs.

The most famous GNU/Linux distributions are Slackware, Debian GNU/Linux, Red Hat, Fedora, Mandriva, SuSE, Gentoo, Ubuntu. Of the distributions of Russian developers, the most famous [source is not specified for 33 days] ALT Linux and ASPLinux.

60% of servers in the world use the Linux operating system, which has high reliability and security in operation. Tens of thousands of computer viruses for Windows cannot spread and multiply on computers running the Linux operating system.

Open Office - office suite

Open Office can be freely installed and used not only on personal computers running Linux, but also on computers running Windows. At the same time, documents and files prepared in the MS Office office package can be read and processed in the Open Office package.

The composition of the Open Office Open Office Suite:

1. OpenOffice.org Writer - Writer text editor with rich capabilities for creating letters, books, reports, newsletters, brochures and other documents, compatible with MS Office.
2. OpenOffice.org Calc - Calc spreadsheets have advanced analysis, charting, and decision-making capabilities expected from high-quality spreadsheets, compatible with MS Office.
3. OpenOffice.org Impress - Impress Presentation Editor provides all general media presentation tools such as special effects, animation, and drawing tools. Compatible with the Microsoft PowerPoint file format, and can also save your work in numerous graphics formats, including Macromedia Flash (SWF).
4. OpenOffice.org Base - The Base database provides tools for working with databases within a simple interface. It can create and edit forms, reports, queries, tables, views, and relationships so that the management of a linked database is much the same as other popular database applications. Base enables HSQLDB as its default relational database engine. It can also use dBASE, Microsoft Access, MySQL, or Oracle, or any ODBC or JDBC compatible database.
5. Open Office Draw is a vector graphics editor called Draw that lets you do everything from simple diagrams or flowcharts to 3D artwork. Draw can import graphics from many common formats and save them in more than 20 formats, including PNG, HTML, PDF, and Flash.
6. Gimp is a Gimp bitmap graphic editor, a program for creating and processing bitmap graphics. Vector graphics are partially supported.

Writer Open Text Editor

OpenOffice.org Writer is a word processor and visual hypertext editor that is part of the OpenOffice.org and is free software (released under the LGPL license).

Writer is similar to Microsoft Word and the functionality of these editors is approximately equal. Provides the user with up-to-date tools for typing, editing, and formatting documents.

Along with the usual interface and functionality:

• creating and editing paragraphs of text and pages,
• adding sections and headers and footers
• inserting images and multimedia objects
• preview and print documents
• recording changes and reviewing texts,
• automatic registration of the table of contents, indexes and footnotes,
• adding macros and controls
• working with tables
• spell checking and more,

The concept of applying styles is a wonderful solution that makes it easier to create and format documents. Working with styles is supported in all components of the office suite, but it is in OpenOffice.org Writer that it is most fully implemented.

Five groups of styles: paragraphs, characters, pages, sidebooks and lists - provide the user with many opportunities for easy formatting of documents. The Styles and Formatting panel allows you to manage styles by modifying existing styles and creating new styles. And the more complex the document, the more often you have to change it, the more obvious the advantage of styling becomes.

Another tool, the Navigator, provides quick navigation through the document by selecting headers, footnotes, takeoffs, or other objects as reference points.

As with other components, there are many add-ons (extensions) for Writer that improve the basic functionality of the component or provide additional functions, such as grammar checking or publishing to MediaWiki.

Writer supports a large number of formats for importing and exporting files, including saving to PDF and importing docx. And sending a file by email is done at the click of a button.

Calc open spreadsheets

OpenOffice.org Calc is a spreadsheet application. With its help, you can analyze the input data, deal with calculations, predict, summarize data from different sheets and tables, build diagrams and graphs.

Calc is an up-to-date and business-critical spreadsheet OpenOffice.org component. A favorite tool for accountants and managers to create reporting.

Step-by-step input of formulas into spreadsheet cells using the wizard facilitates the formation of complex and nested formulas, demonstrates the descriptions of each parameter and the final result at any stage of input.

Conditional formatting and cell styles allow you to organize the finished data, and PivotTables and graphs show the results.

More than two dozen file import and export formats, including text import functions, allow you to operate with almost any data. You can also use a special tool to import data from other sources, such as databases, or you can create an updatable range so that the imported data is always up to date.

Links between different spreadsheets and joint data editing (starting with OpenOffice.org 3.0) are supported.

Various settings are available for printing finished sheets on the printer: scale, fields, headers and footers. And the built-in spelling check, as in a text editor, will improve the quality of the finished report.

Draw Open Vector Graphics Editor

OpenOffice.org Draw - a vector graphic editor, comparable in functionality to CorelDRAW, is included in the OpenOffice.org.

The Draw Vector Graphics Editor is a drawing tool that uses vector graphics. It contains a number of services that allow you to quickly create all kinds of drawings. Vector graphics allow you to save and display images as vectors (two dots and a line) rather than as a set of pixels (dots on the screen). Vector graphics make it easier to save and scale images.

the Draw graphics editor is perfectly integrated into the OpenOffice.org system, which makes it very easy to exchange drawings between any modules of the system. For example, if you create a drawing in Draw, you can easily use it in a Writer document by copying and pasting. You can also work with graphics directly in Writer and Impress modules using a subset of features and tools from Draw.

The package includes fully functional "connectors" between shapes that can use a variety of line styles and allow drawing drawings, such as block diagrams.

The need for a vector editor in the office suite is beyond doubt. The scope of such an editor is quite wide: from the simplest drawings and announcements to diagrams, diagrams and drawings.

In addition to your own objects, you can insert diagrams, formulas, and other elements created in other components into pictures OpenOffice.org. Draw also supports the export of raster images of most formats, both common and special.

Draw has all the necessary tools inherent in vector editors:

• Trunks, dimension lines, tables.
• Working with text and text effects;
• Change color fill, shadow, transparency;
• Place, snap, and manage objects using slides, layers, and guides;
• Various operations on objects are supported: addition subtraction, grouping and transformation of shapes;
• Drawing three-dimensional objects;
• Drawing using graphic primitives, Bezier curves;
• Effects: lighting, morphing and duplication;

In addition to your own objects, you can insert diagrams, formulas, and other elements created in other components into pictures OpenOffice.org. Draw also supports the export of raster images of most formats, both common and special.

Using the Gallery (object store) allows you to organize existing images, and supporting text styles saves time when making the same type of objects.

The finished drawing or drawing can be printed on a printer or exported to a bitmap image or, for example, to PDF.

The maximum drawing size in Draw is 300x300 cm.

As of version 3.0 OpenOffice.org, Draw supports not only exporting, but also importing PDFs (you need to install a special OpenOffice.org extension).

Base Open Relational Database

Base is an open relational database that allows you to create, edit, and process table data.

Users are provided with a fairly large set of data processing tools and tables: editors of forms, queries, reports, database tables. With their help, you can analyze the input data, deal with calculations, predict, summarize data from different sheets and tables, build diagrams and graphs.

The query editor allows you to create almost the entire range of SQL queries to databases for sampling, changing, adding data. Subqueries and queries with parameters are supported. The visual part of the editor will make it easier for a novice user to design queries.

The form editor allows you to use almost any standard database content management tool. It provides controls for text, numeric, binary fields, lists, drop-down lists, tables, buttons, calendar, and other items.

tool for working with external data sources plus the built-in HSQLDB DBMS. With Base, you can add, delete, edit database records: MySQL, HSQLDB (usually supplied with OpenOffice.org), PostgreSQL, DB2, Oracle.

It is also possible to work with DBF, MS Access tables, address books, text files, as well as spreadsheets created in the OpenOffice.org Calc or MS Excel.

External data sources are accessed using ODBC, JDBC, SDBC, and other technologies. The complete list of supported technologies and data sources depends on the operating system used.

More complex data management and processing is performed using macros and OOBasic programming language tools.

The Table Editor helps you create and manage tables in the built-in HSQLDB database, as well as with some possible restrictions on other databases.

Base has a built-in report wizard with basic functions for creating reports or tables or queries. But there is a better reporting tool - Sun Report Builder. This tool allows you to create reports of almost any complexity. It supports grouping, execution of built-in user functions, conditional formatting. SRB results in a Writer or Calc document that can be printed or edited later.

You can create data sources using Base. For example, by organizing a connection to an external database in Base and filtering the necessary data with a SQL query, you can work with this data in OOo Calc.

Open Source Benefits

White Paper: Open Source Benefits

Open Source Security

2023: How Hackers Use Open Source Software to Hack Banks' IT Systems

On July 21, 2023, Checkmarx announced a new cybercriminal scheme targeting the banking sector. We are talking about attacks on the supply chain of open source software.

The analysis suggests that in February and April 2023, attackers downloaded packets with malicious scripts to npm, an open source software platform. In one of the attacks, hackers posted several infected packages with embedded scripts that identified the victim's operating system. Depending on whether it was Windows, Linux, or macOS, certain encrypted files in the package were decoded. These files were then used to download malicious code to the target computer.

The attackers who downloaded the packages created a fake page on LinkedIn (the social network was blocked on the territory of the Russian Federation for violating the rules for storing personal data of Russian users), on which they posed as employees of one of the banks. Initially, Checkmarx researchers thought that the bank could conduct penetration testing, but the financial institution reported that they were not aware of the downloaded packages. Hackers have also created custom control and control centers for each target.

In another incident, cybercriminals injected malicious code into a bank login page. Payload analysis showed that attackers identified a unique element identifier in the HTML code of the login page and developed special code to secretly intercept confidential data and then transmit it to a remote server. The malicious packages were removed after they were discovered by researchers, but Checkmarx believes attacks on the banking sector's software supply chain will continue to gain momentum.^[3]

2022

Open source software components may contain vulnerabilities. How do I improve code security?

The growing risks and widespread use of open source code software development in require composition analysis (software SCA) to ensure application security. Service leaders safety should broaden the scope of SCA tools to include detection, malicious code operational risks and risks, according to supply chains in. Gartner Gartner analysts have prepared the MarketGuide for Software Composition Analysis report, which helps you understand the functionality of the SCA class - Software Composition Analysis - ON and choose the right tool for yourself. The company's experts Web Control (WEB Control DC) specifically reviewed TAdviser this document. Read more here. [1]

The number of hacker attacks on Open Source projects soared by 700%

On September 27, 2022, a study was published, according to which over the past three years, the number of cyber attacks on open source projects/repositories (Open Source) increased by 700%.

Cybercriminals seek to exploit the shortcomings of Open Source ecosystems and continue to attack organizations through open source repositories. They inject malware-infected ON components that spread across the network and end up in applications that businesses and consumers rely on. The repository of Firewall Sonatype, which conducted the study, identified more than 55 thousand published packages in Open Source repositories as malicious in 2022 and almost 95 thousand packages over the past three years.

Almost every modern business relies on open source software. Clearly, the trend of using Open Source repositories as an entry point for malicious attacks is not slowing down, making timely detection of known and unknown security vulnerabilities more important than ever, said Brian Fox, CTO of Sonatype. Finding and eliminating malicious components before they appear on the system is a fundamental factor in risk prevention and should be part of every conversation about protecting software supply chains.

The scale of malware distribution from open repositories is so large that it is not possible to detect and prevent each attack in real time. And even if the malicious component is not used in the final product, it does not correct the situation, since the very fact of downloading such software to the developer's PC/server can already have consequences.^[4]

2020: Microsoft, Google and IBM set up an organization to protect open source software from viruses

In early August 2020, Microsoft, Google, Red Hat, IBM and several other technology companies launched  the Open Source Security Foundation (OpenSSF), whose participants will deal with open source software security issues. This alliance was created under the wing of the Linux Foundation. Read more here.

Free Software

Main article: Free Software Foundation (FSF)

Literature and textbooks

1. V. Kostromin, "Linux for the user," ed. "BHV-Petersburg," 2002
2. Beluntsov V. Self-teacher of the Linux user. M., DESS-KOM, 2003.
3. "OpenOffice.org. Theory and practice. " Binom Publishing House, ALT Linux Library Series. Authors I. Khakhaev, V. Mashkov, and others. Moscow, 2008.

Computer science textbooks:

1. Kaymin V.A. Informatics. Textbook for students. M.INFRA-M, 1999-2009.
2. Kaymin V.A. Informatics. Textbook for schoolchildren. M., Prospect, 2009.
3. Kaymin V.A. Informatics. Exam manual. M., RIOR, 2008.
4. V.A. Kaymin, Kasaev B.S. Informatics: workshop on computers, M. INFRA-M, 2000-2003.
5. * V.A. Kaymin, S.V. Kaymin, etc. Basic software package for IBM PC. M., HIGHER ATTESTATION COMMISSION, 1984.

1. Kaymin V.A. Informatics. Textbook for students. M., Infra-M, M.,2006-2010.
2. Kaymin V.A. Informatics. Allowance for applicants. M., Prospect. 2007-2010.
3. Kaymin V.A. Informatics. Exam manual. M., RIOR, 206-2008.

Internet sources

• UNESCO: Linux and Open Source

• Project "Penguin" - introduction of Linux Technologies in Russian schools

• comments The government has allocated 130 million rubles for the development of Linux

• Supercomputing technologies

• GPL General Public License

• Linux and Open Source Technologies

• Migrating to Linux from Windows

• Open Source School Package

• CITKIT: Defining Open Source

• Informatics in Schools and Universities
• ARMADA: Open Source Software for Schools
• UNESCO: Free Software for Schools
• ARMADA: Methodical Support for Open Source Software
• State Bodies Transition Plan to Open Software
• Mandriva Open Source Project
• Kostromin V.V. Linux for users
• Software for Linux
• Electronic office in Linux
• Linux Technology and Open Source in Education

• Open Office Suite
• Open Office Documentation
• Open Office Open Guide
• Open Office Tutorial
• StarOffice Guide

• Writer Open Text Editor
• To users about the Writer text editor
• Open Editor for Writer Students
• StarOfice Writer text editor
• Calc open spreadsheets
• Calc Table Guide
• StarOffice Calc Spreadsheets
• Draw Open Graphics Editor
• Draw Guide
• StarOffice Draw Guide
• Impress Presentation Editor

• Open Base Databases
• StarOffice Base Database Guide

Notes