Systems Engineering Information Systems Software Engineering
Systems Engineering Information Systems Software Engineering
Systems Engineering Information Systems Software Engineering
computers and telecommunications) for storing, retrieving, and sending information in the
context of business or other enterprise
The systems development life cycle (SDLC), also referred to as the application development
life-cycle, is a term used in systems engineering, information systems and software
engineering to describe a process for planning, creating, testing, and deploying an
information system.
SDLC constitutes of Requirement, Design, Implementation, Verification and Maintenance
Data Intelligence or Business Intelligence is a set of techniques and tools for the
transformation of raw data into meaningful and useful information for business analysis
purposes.
Data intelligence may sometimes be mistakenly referred to as business intelligence.
Although there are some similarities between these two terms, there are also some key
differences. Data intelligence focuses on data used for future endeavors like investments.
Business intelligence, on the other hand, is the process of understanding a business process
and the data associated with that process. Business intelligence involves organizing, rather
than just gathering, data to make it useful and applicable to the business's practices.
In very simple terms the practice of examining large pre-existing databases in order to
generate new information is Data mining
A data warehouse is a subject-oriented, integrated, time-variant and non-volatile collection of
data in support of management's decision making process.
Data mining is the process of finding patterns in a given data set. These patterns can often
provide meaningful and insightful data to whoever is interested in that data. Data mining is
used today in a wide variety of contexts in fraud detection, as an aid in marketing
campaigns, and even supermarkets use it to study their consumers. Data warehousing can
be said to be the process of centralizing or aggregating data from multiple sources into one
common repository.
Data analytics (DA) is the science of examining raw data with the purpose of drawing
conclusions about that information. Data analytics is used in many industries to allow
companies and organization to make better business decisions and in the sciences to verify
or disprove existing models or theories.
Unix (all-caps UNIX for
the
trademark)
is
a
family
of multitasking, multiuser computer operating systems that derive from the original
AT&T Unix, developed in the 1970s at the Bell Labs research center by Ken
Thompson, Dennis Ritchie, and others. UNIX was one of the first operating systems to be
written in a high-level programming language, namely C. This meant that it could be installed
on virtually any computer for which a C compiler existed. This natural portability combined
with its low price made it a popular choice among universities. (It was inexpensive because
antitrust regulations prohibited Bell Labs from marketing it as a full-scale product.)
Low-level languages are designed to operate and handle the entire hardware and instructions
set architecture of a computer directly. Low-level languages are considered to be closer to
computers. In other words, their prime function is to operate, manage and manipulate the
computing hardware and components. Programs and applications written in low-level
language are directly executable on the computing hardware without any interpretation or
translation. Machine language and assembly language are popular examples of low
level languages.
High level languages are designed to be used by the human operator or the programmer.
They are referred to as "closer to humans." In other words, their programming style and
context is easier to learn and implement, and the entire code generally focuses on the
specific program to be created. High-level language doesnt require addressing hardware
constraints to a greater extent when developing a program. However, every single program
written in a high level language must be interpreted into machine language before being
executed by the computer. BASIC, C/C++ and Java are popular examples of high-level
languages.
A trademark, trade mark, or trade-mark is a recognizable sign, design or expression which
identifies products or services of a particular source from those of others.
software to support. UNIX operating systems make great high-performance servers, but for endusers, every application on each arrangement of UNIX platform requires a different set, and each
application has a different user interface. Microsoft has "the" Windows operating system; there
simply isn't one standardized UNIX operating system, or for that matter, a single standardized UNIX
GUI. One could argue and say this is a downfall for UNIX, but on the other hand, these variations
add flavor and versatility to a solid, reliable operating system.
In summary, the best way to choose between UNIX and Windows is to determine organizational
needs. If an organization uses mostly Microsoft products, such as Access, Front Page, or VBScripts,
it's probably better to stick with Windows. But, if reliability, universal compatibility, and stability are
a concern, UNIX would probably be the way to go.
Simply stated, the main difference is Windows uses a GUI (Graphical User Interface) and UNIX
does not. In Windows one uses the click of a mouse to execute a command where as in UNIX one
must type in a command. There are GUIs that can be used in a UNIX environment though very
few UNIX users will stoop that low to use one.) Before there was a Windows environment, DOS
(Disk Operating System) was used on PCs. DOS was based on and was similar, but only a poor
subset, to the UNIX system.
Differences between UNIX and WINDOWS: Unix is safe, preventing one program from
accessing memory or storage space allocated to another, and enables protection, requiring users
to have permission to perform certain functions, i.e. accessing a directory, file, or disk drive. Also,
UNIX is more secure than Windows on a network because Windows is more vulnerable than UNIX.
For example, if you leave a port open in Windows it can be easily used by a hacker to introduce a
virus in your environment.
UNIX is much better at handling multiple tasks for a single user or for multiple users than
windows. For each user, UNIX in general, and especially Sun's Solaris provides many more utilities
for manipulating files and data than windows does. For a corporate environment, Unix (especially
Solaris ) provides much more control for the administrator than windows does. Solaris, for
example, enables the administrator to mirror or stripe data across several disks to minimize risk
or optimize performance without 3rd party products. In general, for a programmer or for an
administrator, Unix provides more power and flexibility than windows. For the less sophisticated
user, Windows can often more easily be installed and configured to run on cheaper hardware to
run a desired 3rd party product. In short -- Unix is better, Windows is easier for less sophisticated
users.
shell (sh). If you use the Bourne shell (sh) for shell programming consider using bash as your
complete shell environment.
Structure
All UNIX files are integrated in a single directory structure. The file-system is arranged in a structure
like an inverted tree. The top of this tree is the root and is written as a slash /.
Directory name
/bin
/boot
/dev
/etc
/home
Typical contents
commands and programs used by all the users of the
system
files required by the boot loader
CD/DVD-ROM, floppy drives, USB devices, etc.
System configuration files
User data files
HP-UX (Hewlett-Packard)
systems of middle-tier software, enterprise resource planning (ERP) software, customer relationship
management (CRM) software and supply chain management (SCM) software.
Larry Ellison, a co-founder of Oracle, had served as Oracle's CEO throughout its history. On
September 18, 2014, it was announced that he would be stepping down (with Mark Hurd and Safra
Catz to become co-CEOs)
Oracle Database:Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational
database management system produced and marketed by Oracle Corporation.
A relational database is a digital database whose organization is based on the relational model of
data, as proposed by E.F. Codd in 1970. This model organizes data into one or more tables (or
"relations") of rows and columns, with a unique key for each row. Generally, each entity type
described in a database has its own table, the rows representing instances of that entity and the
columns representing the attribute values describing each instance. Because each row in a table
has its own unique key, rows in other tables that are related to it can be linked to it by storing the
original row's unique key as an attribute of the secondary row (where it is known as a "foreign key").
Codd showed that data relationships of arbitrary complexity can be represented using this simple
set of concepts.
What is the difference between sql and pl/sql?
SQL is a data oriented language for selecting and manipulating sets of data. PL/SQL is a
procedural language to create applications.
PL/SQL can be the application language just like Java or PHP can. PL/SQL might be the
language we use to build, format and display those screens, web pages and reports. SQL may
be the source of data for our screens, web pages and reports.
SQL is executed one statement at a time. PL/SQL is executed as a block of code.
SQL tells the database what to do (declarative), not how to do it. In contrast, PL/SQL tell the
database how to do things (procedural).
SQL is used to code queries, DML and DDL statements. PL/SQL is used to code program
blocks, triggers, functions, procedures and packages.
We can embed SQL in a PL/SQL program, but we cannot embed PL/SQL within a SQL
statement.
SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate
with a database. According to ANSI (American National Standards Institute), it is the standard
language for relational database management systems. SQL statements are used to perform tasks
such as update data on a database, or retrieve data from a database. Some common relational
database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access,
Ingres, etc.
Creativity is the capability or act of conceiving something original or unusual
Innovation is the implementation of something new.
Invention is the creation of something that has never been made before and is recognized as the
product of some unique insight.
There are following six phases in every Software development life cycle model:
Unit Testing
Integration Testing
Functional Testing
System Testing
Stress Testing
Performance Testing
Usability Testing
Acceptance Testing
Regression Testing
Beta Testing