Year: 2020

Database design is the organization of data according to a database model. The designer determines what data must be stored and how the data elements interrelate. With this information, they can begin to fit the data to the database model. Database management system manages the data accordingly.

Database design involves classifying data and identifying interrelationships. This theoretical representation of the data is called an ontology. The ontology is the theory behind the database’s design.

A design process suggestion for Microsoft Access

(i) Determine the purpose of the database

This helps prepare for the remaining steps.

(ii) Find and organize the information required

Gather all of the types of information to record in the database, such as product name and order number.

(iii) Divide the information into tables

Divide information items into major entities or subjects, such as Products or Orders. Each subject then becomes a table.

(iv) Turn information items into columns

Decide what information needs to be stored in each table. Each item becomes a field, and is displayed as a column in the table. For example, an Employees table might include fields such as Last Name and Hire Date.

(v) Specify primary keys

Choose each table’s primary key. The primary key is a column, or a set of columns, that is used to uniquely identify each row. An example might be Product ID or Order ID.

(vi) Set up the table relationships

Look at each table and decide how the data in one table is related to the data in other tables. Add fields to tables or create new tables to clarify the relationships, as necessary.

(vii) Refine the design

Analyze the design for errors. Create tables and add a few records of sample data. Check if results come from the tables as expected. Make adjustments to the design, as needed.

(viii) Apply the normalization rules

Apply the data normalization rules to see if tables are structured correctly. Make adjustments to the tables, as needed.

Determining data to be stored

In a majority of cases, a person who is doing the design of a database is a person with expertise in the area of database design, rather than expertise in the domain from which the data to be stored is drawn e.g. financial information, biological information etc. Therefore, the data to be stored in the database must be determined in cooperation with a person who does have expertise in that domain, and who is aware of what data must be stored within the system.

This process is one which is generally considered part of requirements analysis, and requires skill on the part of the database designer to elicit the needed information from those with the domain knowledge. This is because those with the necessary domain knowledge frequently cannot express clearly what their system requirements for the database are as they are unaccustomed to thinking in terms of the discrete data elements which must be stored. Data to be stored can be determined by Requirement Specification.

Determining data relationships

Once a database designer is aware of the data which is to be stored within the database, they must then determine where dependency is within the data. Sometimes when data is changed you can be changing other data that is not visible. For example, in a list of names and addresses, assuming a situation where multiple people can have the same address, but one person cannot have more than one address, the address is dependent upon the name. When provided a name and the list the address can be uniquely determined; however, the inverse does not hold – when given an address and the list, a name cannot be uniquely determined because multiple people can reside at an address. Because an address is determined by a name, an address is considered dependent on a name.

(NOTE: A common misconception is that the relational model is so called because of the stating of relationships between data elements therein. This is not true. The relational model is so named because it is based upon the mathematical structures known as relations.)

Logically structuring data

Once the relationships and dependencies amongst the various pieces of information have been determined, it is possible to arrange the data into a logical structure which can then be mapped into the storage objects supported by the database management system. In the case of relational databases the storage objects are tables which store data in rows and columns. In an Object database the storage objects correspond directly to the objects used by the Object-oriented programming language used to write the applications that will manage and access the data. The relationships may be defined as attributes of the object classes involved or as methods that operate on the object classes.

The way this mapping is generally performed is such that each set of related data which depends upon a single object, whether real or abstract, is placed in a table. Relationships between these dependent objects is then stored as links between the various objects.

Each table may represent an implementation of either a logical object or a relationship joining one or more instances of one or more logical objects. Relationships between tables may then be stored as links connecting child tables with parents. Since complex logical relationships are themselves tables they will probably have links to more than one parent.

A relational database management system (RDBMS) is a collection of programs and capabilities that enable IT teams and others to create, update, administer and otherwise interact with a relational database. RDBMS store data in the form of tables, with most commercial relational database management systems using Structured Query Language (SQL) to access the database. However, since SQL was invented after the initial development of the relational model, it is not necessary for RDBMS use.

The RDBMS is the most popular database system among organizations across the world. It provides a dependable method of storing and retrieving large amounts of data while offering a combination of system performance and ease of implementation.

RDBMS vs. DBMS

In general, databases store sets of data that can be queried for use in other applications. A database management system supports the development, administration and use of database platforms.

An RDBMS is a type of database management system (DBMS) that stores data in a row-based table structure which connects related data elements. An RDBMS includes functions that maintain the security, accuracy, integrity and consistency of the data. This is different than the file storage used in a DBMS.

Other differences between database management systems and relational database management systems include:

• Number of allowed users. While a DBMS can only accept one user at a time, an RDBMS can operate with multiple users.
• Hardware and software requirements. A DBMS needs less software and hardware than an RDBMS.
• Amount of data. RDBMSes can handle any amount of data, from small to large, while a DBMS can only manage small amounts.
• Database structure. In a DBMS, data is kept in a hierarchical form, whereas an RDBMS utilizes a table where the headers are used as column names and the rows contain the corresponding values.
• ACID implementation. DBMSes do not use the atomicity, consistency, isolation and durability (ACID) model for storing data. On the other hand, RDBMSes base the structure of their data on the ACID model to ensure consistency.
• Distributed databases. While an RDBMS offers complete support for distributed databases, a DBMS will not provide support.
• Types of programs managed. While an RDBMS helps manage the relationships between its incorporated tables of data, a DBMS focuses on maintaining databases that are present within the computer network and system hard disks.
• Support of database normalization. An RDBMS can be normalized, but a DBMS cannot.

Features of relational database management systems

Elements of the relational database management system that overarch the basic relational database are so intrinsic to operations that it is hard to dissociate the two in practice.

The most basic RDBMS functions are related to create, read, update and delete operations — collectively known as CRUD. They form the foundation of a well-organized system that promotes consistent treatment of data.

The RDBMS typically provides data dictionaries and metadata collections that are useful in data handling. These programmatically support well-defined data structures and relationships. Data storage management is a common capability of the RDBMS, and this has come to be defined by data objects that range from binary large object — or blob — strings to stored procedures. Data objects like this extend the scope of basic relational database operations and can be handled in a variety of ways in different RDBMS.

The most common means of data access for the RDBMS is SQL. Its main language components comprise data manipulation language and data definition language statements. Extensions are available for development efforts that pair SQL use with common programming languages, such as the Common Business-Oriented Language (COBOL), Java and .NET.

RDBMS use complex algorithms that support multiple concurrent user access to the database while maintaining data integrity. Security management, which enforces policy-based access, is yet another overlay service that the RDBMS provides for the basic database as it is used in enterprise settings.

RDBMS support the work of database administrators (DBAs) who must manage and monitor database activity. Utilities help automate data loading and database backup. RDBMS manage log files that track system performance based on selected operational parameters. This enables measurement of database usage, capacity and performance, particularly query performance. RDBMS provide graphical interfaces that help DBAs visualize database activity.

While not limited solely to the RDBMS, ACID compliance is an attribute of relational technology that has proved important in enterprise computing. These capabilities have particularly suited RDBMS for handling business transactions.

As RDBMS have matured, they have achieved increasingly higher levels of query optimization, and they have become key parts of reporting, analytics and data warehousing applications for businesses as well. RDBMS are intrinsic to operations of a variety of enterprise applications and are at the center of most master data management systems.

How RDBMS works?

As mentioned before, an RDBMS will store data in the form of a table. Each system will have varying numbers of tables with each table possessing its own unique primary key. The primary key is then used to identify each table.

Within the table are rows and columns. The rows are known as records or horizontal entities; they contain the information for the individual entry. The columns are known as vertical entities and possess information about the specific field.

Before creating these tables, the RDBMS must check the following constraints:

• Primary keys: This identifies each row in the table. One table can only contain one primary key. The key must be unique and without null values.
• Foreign keys: This is used to link two tables. The foreign key is kept in one table and refers to the primary key associated with another table.
• Not null: This ensures that every column does not have a null value, such as an empty cell.
• Check: This confirms that each entry in a column or row satisfies a precise condition and that every column holds unique data.
• Data integrity: The integrity of the data must be confirmed before the data is created.

Assuring the integrity of data includes several specific tests, including entity, domain, referential and user-defined integrity. Entity integrity confirms that the rows are not duplicated in the table. Domain integrity makes sure that data is entered into the table based on specific conditions, such as file format or range of values. Referential integrity ensures that any row that is re-linked to a different table cannot be deleted. Finally, user-defined integrity confirms that the table will satisfy all user-defined conditions.

Advantages of relational database management system

The use of an RDBMS can be beneficial to most organizations; the systematic view of raw data helps companies better understand and execute the information while enhancing the decision-making process. The use of tables to store data also improves the security of information stored in the databases. Users are able to customize access and set barriers to limit the content that is made available. This feature makes the RDBMS particularly useful to companies in which the manager decides what data is provided to employees and customers.

Furthermore, RDBMS make it easy to add new data to the system or alter existing tables while ensuring consistency with the previously available content.

Other advantages of the RDBMS include:

• Flexibility: Updating data is more efficient since the changes only need to be made in one place.
• Maintenance: Database administrators can easily maintain, control and update data in the database. Backups also become easier since automation tools included in the RDBMS automate these tasks.
• Data structure: The table format used in RDBMS is easy to understand and provides an organized and structural manner through which entries are matched by firing queries.

On the other hand, relational database management systems do not come without their disadvantages. For example, in order to implement an RDBMS, special software must be purchased. This introduces an additional cost for execution. Once the software is obtained, the setup process can be tedious since it requires millions of lines of content to be transferred into the RDBMS tables. This process may require the additional help of a programmer or a team of data entry specialists. Special attention must be paid to the data during entry to ensure sensitive information is not placed into the wrong hands.

Some other drawbacks of the RDBMS include the character limit placed on certain fields in the tables and the inability to fully understand new forms of data — such as complex numbers, designs and images.

Furthermore, while isolated databases can be created using an RDBMS, the process requires large chunks of information to be separated from each other. Connecting these large amounts of data to form the isolated database can be very complicated.

Uses of RDBMS

Relational database management systems are frequently used in disciplines such as manufacturing, human resources and banking. The system is also useful for airlines that need to store ticket service and passenger documentation information as well as universities maintaining student databases.

Some examples of specific systems that use RDBMS include IBM, Oracle, MySQL, Microsoft SQL Server and Postgre SQL.

RDBMS product history

Many vying relational database management systems arose as news spread in the early 1970s of the relational data model. This and related methods were originally theorized by IBM researcher E.F. Codd, who proposed a database schema, or logical organization, that was not directly associated with physical organization, as was common at the time.

Codd’s work was based around a concept of data normalization, which saved file space on storage disk drives at a time when such machinery could be prohibitively expensive for businesses.

File systems and database management systems preceded what could be called the RDBMS era. Such systems ran primarily on mainframe computers. While RDBMS also ran on mainframes — IBM’s DB2 being a pointed example — much of their ascendance in the enterprise was in UNIX midrange computer deployments. The RDBMS was a linchpin in the distributed architecture of client-server computing, which connected pools of stand-alone personal computers to file and database servers.

Numerous RDBMS arose along with the use of client-server computing. Among the competitors were Oracle, Ingres, Informix, Sybase, Unify, Progress and others. Over time, three RDBMS came to dominate in commercial implementations. Oracle, IBM’s DB2 and Microsoft’s SQL Server, which was based on a design originally licensed from Sybase, found considerable favor throughout the client-server computing era, despite repeated challenges by competing technologies.

As the 20th century drew to an end, lower-cost, open source versions of RDBMS began to find use, particularly in web applications.

Eventually, as distributed computing took greater hold, and as cloud architecture became more prominently employed, RDBMS met competition in the form of No SQL systems. Such systems were often specifically designed for massive distribution and high scalability in the cloud, sometimes forgoing SQL-style full consistency for so-called eventual consistency of data. But, even in the most diverse and complex cloud systems, the need for some guaranteed data consistency requires RDBMS to appear in some way, shape or form. Moreover, versions of RDBMS have been significantly restructured for cloud parallelization and replication.

Oracle database (Oracle DB) is a relational database management system (RDBMS) from the Oracle Corporation. Originally developed in 1977 by Lawrence Ellison and other developers, Oracle DB is one of the most trusted and widely-used relational database engines.

The system is built around a relational database framework in which data objects may be directly accessed by users (or an application front end) through structured query language (SQL). Oracle is a fully scalable relational database architecture and is often used by global enterprises, which manage and process data across wide and local area networks. The Oracle database has its own network component to allow communications across networks.

Oracle DB rivals Microsoft’s SQL Server in the enterprise database market. There are other database offerings, but most of these command a tiny market share compared to Oracle DB and SQL Server. Fortunately, the structures of Oracle DB and SQL Server are quite similar, which is a benefit when learning database administration.

Oracle DB runs on most major platforms, including Windows, UNIX, Linux and Mac OS. Different software versions are available, based on requirements and budget. Oracle DB editions are hierarchically broken down as follows:

• Enterprise Edition: Offers all features, including superior performance and security, and is the most robust
• Standard Edition: Contains base functionality for users that do not require Enterprise Edition’s robust package
• Express Edition (XE): The lightweight, free and limited Windows and Linux edition
• Oracle Lite: For mobile devices

A key feature of Oracle is that its architecture is split between the logical and the physical. This structure means that for large-scale distributed computing, also known as grid computing, the data location is irrelevant and transparent to the user, allowing for a more modular physical structure that can be added to and altered without affecting the activity of the database, its data or users. The sharing of resources in this way allows for very flexible data networks whose capacity can be adjusted up or down to suit demand, without degradation of service. It also allows for a robust system to be devised as there is no single point at which a failure can bring down the database, as the networked schema of the storage resources means that any failure would be local only.

A local area network (LAN) is a collection of devices connected together in one physical location, such as a building, office, or home. A LAN can be small or large, ranging from a home network with one user to an enterprise network with thousands of users and devices in an office or school.

Regardless of size, a LAN’s single defining characteristic is that it connects devices that are in a single, limited area. In contrast, a wide area network (WAN) or metropolitan area network (MAN) covers larger geographic areas. Some WANs and MANs connect many LANs together.

A LAN comprises cables, access points, switches, routers, and other components that enable devices to connect to internal servers, web servers, and other LANs via wide area networks.

The rise of virtualization has also fueled the development of virtual LANs, which enable network administrators to logically group network nodes and partition their networks without a need for major infrastructure changes.

For example, in an office with multiple departments, such as accounting, IT support, and administration, each department’s computers could be logically connected to the same switch but segmented to behave as if they are separate.

Types of LAN

Ethernet is the most common type of LAN. Different Lan can be differentiated on the behalf of following characteristics.

• Topology: The topology is the geometric arrangement of a network elements. For example, Network devices can be interconnected in a ring topology or in a bus topology or linear bus.
• Protocols: It is a guidelines for communicating data between two devices. The protocols also determine type of error and data compression.
• Media: The cable used in Lan to connect devices are twisted-pair wire, coaxial cables, or fiber optic.

Benefits of a LAN

The advantages of a LAN are the same as those for any group of devices networked together. The devices can use a single Internet connection, share files with one another, print to shared printers, and be accessed and even controlled by one another.

LANs were developed in the 1960s for use by colleges, universities, and research facilities (such as NASA), primarily to connect computers to other computers. It wasn’t until the development of Ethernet technology (1973, at Xerox PARC), its commercialization (1980), and its standardization (1983) that LANs started to be used widely.

While the benefits of having devices connected to a network have always been well understood, it wasn’t until the wide deployment of Wi-Fi technology that LANs became commonplace in nearly every type of environment. Today, not only do businesses and schools use LANs, but also restaurants, coffee shops, stores, and homes.

Wireless connectivity has also greatly expanded the types of devices that can be connected to a LAN. Now, nearly everything imaginable can be “connected,” from PCs, printers, and phones to smart TVs, stereos, speakers, lighting, thermostats, window shades, door locks, security cameras–and even coffeemakers, refrigerators, and toys.

The Evolution of LAN

As there is a tremendous use of PC or desktop computers in the office environment, it became apparent that attaching a printer or FAX machine to each and every computer is highly expensive. Further, copying files to a disk and moving from one computer to another to print the file is also time consuming. Connecting computers so that they could share a printer and share files translated into big savings.

In 1982, 10 Mbps Ethernet cards came into existence and they were very expensive. By 1988, 10 Mbps Ethernet had acceptable performance for large LANs and was still good for small installations. By 1990, large installations were beginning to see congestion. Hence, alternatives to 10 Mbps cards were becoming popular. One of these alternatives was to install a switched architecture, rather than constructing architecture with hubs.

In 1996, 10Mbps switched LANs were providing acceptable service for smaller installations. The awesome technology at this point was 100Mbps shared Ethernet. By 1998 switched 10Mbps Ethernet was common in small LANs and switched 100 Mbps Ethernet was common in large LANs. Large LANs are beginning to see limitations of 100 Mbps when everyone on the LAN starts doing video conferencing.

Now, Gigabyte Ethernet cards are available for sale. The 10 Mbps cards are not used anymore. Now-i-days 10/100, 10/100/1000 auto-sensing cards are available in the market. Everything is moving to dual mode auto-sensing technology. Even though Gigabyte Ethernet is getting more popular now-a-days, Gigabyte LANs are 10 times faster than a 100Mbps LAN. Ethernet was evolved from a protocol called ALOHA. ALOHA was mainly used in packet radio network which communicate using satellites. In brief, an earth station sends some data, as soon as the data is ready it waits for an acknowledgement (ACK). If it fails to get an ACK, it would time out and sends the same thing again. The sender keeps trying until the transmission is successful. The lesson to be learned here is that it is important to limit the number of users on a shared network medium. Traffic analysis can help determine the maximum number of users to ensure a reasonable Quality of Service (QOS).

LAN Advantages and Services

A LAN has the following advantages:

• They work on higher operating speed than WAN and MAN.
• They suit the requirements of a specific organization.
• They are easy to install and maintain.
• They exist as connected (wired) and wireless configurations.

LAN can provide the following services. They are:

(i) File-based service

Transfer of files from one node to another within the LAN area. For example, in a typical LAN used for local banking, the file containing the detailed transactions of a specific customer is transferred form sever to the client, whenever new transactions are made on behalf of the customer. It also provides efficient ways of storing and retrieving the data. When multiple copies of the same file exist, it provides necessary synchronization in updating the files. LAN also provides backup for the critical data so that safe recovery is possible when a failure occurs. It also provides data encryption facility to control the access to certain data to only selected persons.

(ii) Print services

There can be one or more printers, modems, and fax machines attached to a LAN and used by applications. A number of clients can share these devices. Print services allow many clients to safely share printers and other such devices. All modem LANs provide these services.

(iii) Application-based services

Applications run on a client may require higher computational capabilities. Servers are more powerful than the clients. In a LAN, more than one client can share the computational power of a server. Application servers are good examples for this.

(iv) Mail and message-based services

Electronic-mail is an important service used for exchanging information between people on a network. Mails can be stored or forwarded to another user. Many free mail servers are available on the Internet to provide free mail services to its clients.

(v) Database services

Storing and retrieving of data in databases is another requirement of a client to control and manipulate the data. Database servers are the most popular ones that service the need of clients.

(vi) Distributed data services

When data is distributed, it is possible for more than one client system to share the data. Though the databases appear physically distributed, there is a single logical view given by the database server. There are so many issues involved in sharing a single file by more than one client. Consistency issue is very seriously tackled when updating shared files.

(vii) Remote services

Linking a LAN with a remote computer or a mainframe is another service required. This feature is used to access remote databases available in large mainframes.

Characteristics of a LAN

A LAN can be characterized by means of hardware and software components and a set of protocols.

Hardware components of a LAN are:

1. The Server

Server is a computer that provides services to other computers (workstations or clients) on the network. The primary goal of a LAN server is data management. It stores, retrieves, and protects the data. A server also sends data to the requesters on the network and also to authorized remote users. The type and configurations needed for the server, depends mainly on the purpose for which the LAN is being constructed. Servers may be classified, based on the type of service they provide. A single server may provide a number of services also. The following are the list of servers categorized, based on the type of service.

(i) File server and disk server

A file server makes the disk storage space (in the order of several Gigabytes), to various client PCs. The file server satisfies the request for data from application programs running in client workstations. It also keeps the consistency of data when more than one client makes simultaneous data requests. In a LAN, working with a file server, all application running in a workstation may request for a file with involving the local operating system. The workstation sends its file request to the server and the server processes the request and sends the required file directly to the workstation.

(ii) Disk servers

Disk servers are similar to file servers. The difference is that, in a file server when an application running in a workstation requests for a specific file, the local operating system, running on the workstation interacts with the file server and gets the information required. In a disk server, the application can directly access the required file without the intervention of the local operating system.

(iii) Database server

These servers are a subset of the file server category. They provide access to huge databases for clients. Database information is stored in hard disk storage or CD ROM or optical disk drives. It contains the DBMS, which is more sophisticated than the basic file I/O access method. DBMS eliminates data redundancy and allows the user, transparent data distribution. The database server extracts only the relevant data and passes it to the requesting client, rather than passing the entire file like a file server.

(iv) Print server

Every LAN has one or more printers shared by all the nodes or workstations. The role of a print server is to collect the information from several workstations, store them on the disk and send it to the printer. This processing is known as print spooling. Print services become a part of the file server nowadays. In many LAN architectures, any PC on the LAN can act as a print server.

(v) Backup server

Such servers provide backup in case the main server fails. Every network must have a back up server to keep all the information safe. Periodically, these servers must be updated so that reliability can be improved.

(vi) Gateway server

A gateway server is used to provide connectivity to other networks. The GIAS (Gateway server of VSNL, India) is a gateway server, which provides connectivity to all other networks on the Internet for the Indian segment of the Internet. A gateway server also provides connectivity to dissimilar networks.

(vii) Communication server

Communication servers are more diverse than the other servers. The main functions of a communication server are linking client workstations on the LAN with mainframe computers, sharing a pool of modems among the client stations, and communicating with other LANs as well.

Examples of the most popular LAN servers are Novell Netware LAN Server, Microsoft Windows NT Server or Windows 2000, IBMOS2 Server, etc.

2. Workstations

Workstations or nodes are the clients that use the services provided by the network server. Workstations are loaded with special software to interact with the server to access the services. Examples of workstations include the Microsoft Windows NT workstation, Windows 2000 workstation, IBM workstation, Sun workstation, etc.

3. The Transmission Media for LAN

Various transmission media are used for constructing a LANs. The most popular among them are twisted pair, coaxial cable, or optical fibers. LANs operated with any such transmission media is known as wired LAN. LANs can also be constructed without a transmission media or cable. Such LANs are known as wireless LANs.

4. Communication Equipments

(i) Repeater

A repeater operates at layer-I. It has just enough intelligence to find out the layer-l incoming signals are and then send out a clean stream of signals built from scratch. Noise is eliminated from the signals in this manner. A repeater has one incoming and one outgoing line. It extends the distance that a signal may be sent over a transmission media.

(ii) Hub

A hub is a multi-port repeater. Any incoming signal is repeated on all other outgoing lines. A hub functions at layer-I.

(iii) Bridge

A bridge has more intelligence than a hub or repeater. This device separates two segments of a single LAN. A bridge operates at layer-2 by looking at the destination address in the frame header. Consulting a table, the bridge will determine if the frame needs to pass on to the other segment. Only certain frames may pass those with the correct MAC address.

(iv) Switch

A switch is a multi-port bridge. It performs its functions at layer two. It looks at MAC layer addresses just like a bridge, consults a table, and determines if a frame needs to be sent on one of the attached lines. Multiple connections can occur through a switch simultaneously as long as they don’t compete for the same line. A switch, just like a bridge, does not divide a LAN into two LANs. It merely reduces unnecessary traffic on LAN segments.

(v) Router

A router is more intelligent than bridges and switches. It functions at layer-3. At layer-2 all incoming frames are checked for errors and then they are delivered to layer-3. A layer-3 datagram has an address that permits it to be sent across internet works (interconnected networks). This requires a single global addressing scheme. The router finds the layer-3 address and consults a table that it keeps. There the router will learn which attached line to send the datagram on. A router provides facilities to the stations on the LAN, to access other networks.

A WAN is a network that uses various links – private lines, Multiprotocol Label Switching (MPLS), virtual private networks (VPNs), wireless (cellular), the Internet  to connect smaller metropolitan and campus networks in diverse locations into a single, distributed network. The sites they connect could be a few miles apart or halfway around the globe. In an enterprise, the purposes of a WAN could include connecting branch offices or even individual remote workers with headquarters or the data center, in order to share corporate resources and communications.

A wide area network (WAN) is a network that exists over a large-scale geographical area. A WAN connects different smaller networks, including local area networks (LANs) and metro area networks (MANs). This ensures that computers and users in one location can communicate with computers and users in other locations. WAN implementation can be done either with the help of the public transmission system or a private network.

A WAN connects more than one LAN and is used for larger geographical areas. WANs are similar to a banking system, where hundreds of branches in different cities are connected with each other in order to share their official data.

A WAN works in a similar fashion to a LAN, just on a larger scale. Typically, TCP/IP is the protocol used for a WAN in combination with devices such as routers, switches, firewalls and modems.

WAN architecture

Initially, WANs were built with meshed webs of private lines bought from telecommunications carriers, but WAN architectures have advanced to include packet-switched services such as frame relay and ATM as well as MPLS. With these services, a single connection to a site can be connected to many others via switching within service-provider networks. For certain types of traffic, the Internet can also be woven into the mix to provide less expensive WAN connections.

History of WANs

WANs have been around since the early days of computing networks. The first examples of WANs included circuit-switched telephone lines, but advances in technologies now include wireless transmissions and fiber-optic transmissions. Data can also be moved via leased lines, or even via satellite transmission.

As technologies changed, so did transmission rates. The early days of 2400 bps modems evolved to 40 Gbps and 100 Gbps connectivity today. These speed increases have allowed more devices to connect to networks, witnessed by the explosion of computers, phones, tablets and smaller Internet of Things devices.

In addition, speed improvements have allowed applications to utilize larger amounts of bandwidth that can travel across WANs at super-high speed. This has allowed enterprises to implement applications such as videoconferencing and large-file data backup. Nobody would have considered conducting a videoconference across a 28K bps modem, but now workers can sit in a cubicle and participate in a global company meeting via video.

Many WAN links are supplied via carrier services in which customers’ traffic rides over facilities shared by other customers. Customers can also buy dedicated links that nail up circuits point-to-point and are used for just one customer’s traffic. These are typically used for top-priority traffic or delay-sensitive applications that have high-bandwidth needs such as videoconferencing.

Connections between WAN sites may be protected by virtual private networking (VPN) technology that overlays security functions including authentication, encryption, confidentiality and non-repudiation.

WAN Management and optimization

Because data transmission is still reliant on the rules of physics, the greater the distance between two devices, the longer it will take for data to travel between them. The greater the distance, the greater the delay. Network congestion and dropped packets can also introduce performance problems.

Some of this can be addressed using WAN optimization, which makes data transmissions more efficient. This is important because WAN links can be expensive, so technologies have sprung up that reduce the amount of traffic crossing WAN links and ensure that it arrives efficiently. These optimization methods include abbreviating redundant data (known as deduplication), compression, and caching (putting frequently used data closer to the end user).

Traffic can be shaped, giving some applications (such as VoIP) a higher priority over other, less urgent traffic (such as email), which in turn helps improve the overall WAN performance. This can be formalized into quality of service settings that define classes of traffic by the priority each class receives relative to others, the type of WAN connection that each traffic type will travel, and the bandwidth that each receives.

Data communications (DC) is the process of using computing and communication technologies to transfer data from one place to another, and vice versa. It enables the movement of electronic or digital data between two or more nodes, regardless of geographical location, technological medium or data contents.

Data communications incorporates several techniques and technologies with the primary objective of enabling any form of electronic communication. These technologies include telecommunications, computer networking and radio/satellite communication. Data communication usually requires existence of a transportation or communication medium between the nodes wanting to communicate with each other, such as copper wire, fiber optic cables or wireless signals.

For example, a common example of data communications is a computer connected to the Internet via a Wi-Fi connection, which uses a wireless medium to send and receive data from one or more remote servers.

Some devices/technologies used in data communications are known as data communication equipment (DCE) and data terminal equipment (DTE). DCE is used at the sending node, and DTE is used at the receiving node.

Components of Data Communication System

A Communication system has following components:

1. Message

It is the information or data to be communicated. It can consist of text, numbers, pictures, sound or video or any combination of these.

2. Sender

It is the device/computer that generates and sends that message.

3. Receiver

It is the device or computer that receives the message. The location of receiver computer is generally different from the sender computer. The distance between sender and receiver depends upon the types of network used in between.

4. Medium

It is the channel or physical path through which the message is carried from sender to the receiver. The medium can be wired like twisted pair wire, coaxial cable, fiber-optic cable or wireless like laser, radio waves, and microwaves.

5. Protocol

It is a set of rules that govern the communication between the devices. Both sender and receiver follow same protocols to communicate with each other.

The effectiveness depends on four fundamental characteristics of data communications

• Delivery: The data must be deliver in correct order with correct destination.
• Accuracy: The data must be deliver accurately.
• Timeliness: The data must be deliver in a timely manner.late delivered Data useless.
• Jitter: It is the uneven delay in the packet arrival time that cause uneven quality.

A protocol performs the following functions:

1. Data sequencing

It refers to breaking a long message into smaller packets of fixed size. Data sequencing rules define the method of numbering packets to detect loss or duplication of packets, and to correctly identify packets, which belong to same message.

2. Data routing

Data routing defines the most efficient path between the source and destination.

3. Data formatting

Data formatting rules define which group of bits or characters within packet constitute data, control, addressing, or other information.

4. Flow control

A communication protocol also prevents a fast sender from overwhelming a slow receiver. It ensures resource sharing and protection against traffic congestion by regulating the flow of data on communication lines.

5. Error control

These rules are designed to detect errors in messages and to ensure transmission of correct messages. The most common method is to retransmit erroneous message block. In such a case, a block having error is discarded by the receiver and is retransmitted by the sender.

6. Precedence and order of transmission

These rules ensure that all the nodes get a chance to use the communication lines and other resources of the network based on the priorities assigned to them.

7. Connection establishment and termination

These rules define how connections are established, maintained and terminated when two nodes of a network want to communicate with each other.

8. Data security

Providing data security and privacy is also built into most communication software packages. It prevents access of data by unauthorized users.

9. Log information

Several communication software are designed to develop log information, which consists of all jobs and data communications tasks that have taken place. Such information may be used for charging the users of the network based on their usage of the network resources.

We all know the invaluable worth of computers in our daily lives and our work. But did you know computers are also essential to an organization’s decision making? There are computer software and systems that help businesses analyze data in a scientific way to ease the decision-making process.

Like MIS, Accounting Information System (AIS) is also a computer-based system, which an organization uses to take important financial decisions. An AIS will collect, process, analyze and store financial data of a company. And when called upon it will retrieve and report such data to its users, namely accountants, consultants, financial officers CFO, auditors, government tax authorities etc.

There are three basic objectives of an AIS, which are:

• It helps an organization fulfill its statutory obligations of preparing and publishing certain accounting statements and information
• It analyses financial data and provides reliable and accurate financial information to the users of the AIS
• Protects a firms accounting data from breach or theft (which can be a significant problem)

Components of Accounting Information System

An AIS, like most computer systems, consists of six basic components.

• People: These are the users of the AIS. Internal users include accountants and other financial officers o the company. Then there are also users outside the organization, that can be given access to the AIS. Some such external users are auditors, consultants, tax authorities etc.
• Procedures: These are the procedures the system follows to collect and process data. The database for such a process can be internal (like employee names, sales figures) or external databases (like customer orders, tax slabs etc). The feeding of the data can be both manual as well as automated.
• Data: An AIS mainly deals with all kinds of financial and commercial data. Any data that is pertinent to the accounting of the firm will be input data for an AIS. Care must be taken that the data entered is accurate and complete. Examples of such data include invoices, orders, payroll, bills etc.
• Software: AIS software performs all the functions of storing, processing, analyzing, retrieving financial data of a company. The software can be generalized software that is available in the market (Tally, Oracle etc) or can be specialized software created specifically for a particular company and it’s accounting needs. Some of this software has an inbuilt internal control and audit options. They even help in tax management.
• Hardware: Like any other information system, AIS will also require some hardware components. these can include computers, laptops, servers, printers, scanners, secondary storage hardware etc.

Financial Management Information Systems (FMIS) support the automation and integration of public financial management processes including budget formulation, execution (e.g. commitment control, cash/debt management, treasury operations), accounting, and reporting. FMIS solutions can significantly improve the efficiency and equity of government operations, and offer a great potential for increasing participation, transparency and accountability. Whenever FMIS and other PFM information systems (for example, e-procurement, payroll, debt management) are linked with a central data warehouse (DW) to record and report all daily financial transactions, offering reliable consolidated platforms can be referred to as integrated FMIS (or IFMIS). The World Bank is a leading provider of financing and technical assistance for FMIS development.

No marketing activity can be carried out in isolation, know when we say it doesn’t work in isolation that means there are various forces could be external or internal, controllable or uncontrollable which are working on it. Thus to know which forces are acting on it and its impact the marketer needs to gathering the data through its own resources which in terms of marketing we can say he is trying to gather the market information or form a marketing information system.

This collection of information is a continuous process that gathers data from a variety of sources synthesizes it and sends it to those responsible for meeting the market places needs. The effectiveness of marketing decision is proved if it has a strong information system offering the firm a Competitive advantage. Marketing Information should not be approached in an infrequent manner. If research is done this way, a firm could face these risks:

• Opportunities may be missed.
• There may be a lack of awareness of environmental changes and competitors’ actions.
• Data collection may be difficult to analyze over several time periods.
• Marketing plans and decisions may not be properly reviewed.
• Data collection may be disjointed.
• Previous studies may not be stored in an easy to use format.
• Time lags may result if a new study is required.
• Actions may be reactionary rather than anticipatory.

The total information needs of the marketing department can be specified and satisfied via need of internal management of marketing intelligence network, which contains three components and advantages.

1. Continuous monitoring is the procedure by which the changing environment is regularly viewed.
2. Marketing research is used to obtain information on particular marketing issues.
3. Data warehousing involves the retention of all types of relevant company records, as well as the information collected through continuous monitoring and marketing research that is kept by the organization.

Depending on a firm’s resources and the complexity of its needs, a marketing intelligence network may or may not be fully computerized. The ingredients for a good MIS are consistency, completeness, and orderliness. Marketing plans should be implemented on the basis of information obtained from the intelligence network.

Marketing Information System offers many advantages

• Organized data collection
• A broad perspective
• The storage of important data
• An avoidance of crises
• Coordinated marketing plans
• Speed in obtaining sufficient information to make decisions
• Data amassed and kept over several time periods
• The ability to do a cost-benefit analysis

The disadvantages of a Marketing information system are high initial time and labor costs and the complexity of setting up an information system. Marketers often complain that they lack enough marketing information or the right kind, or have too much of the wrong kind.

The solution is an effective marketing information system

The information needed by marketing managers comes from three main sources:

1. Internal company information

E.g. sales, orders, customer profiles, stocks, customer service reports etc.

2. Marketing intelligence

This can be information gathered from many sources, including suppliers, customers, and distributors. Marketing intelligence is a catchall term to include all the everyday information about developments in the market that helps a business prepare and adjust its marketing plans. It is possible to buy intelligence information from outside suppliers (e.g. IDC, ORG, MARG) who set up data gathering systems to support commercial intelligence products that can be profitably sold to all players in a market.

3. Market Research

Management cannot always wait for information to arrive in bits and pieces from internal sources. Also, sources of market intelligence cannot always be relied upon to provide relevant or up-to-date information (particularly for smaller or niche market segments). In such circumstances, businesses often need to undertake specific studies to support their marketing strategy this is market research.

Management information system helps production to performs an integrating role with in the production system of any organization. Management of activities/operations in a production system is concerned with decision making related to different components of the system so as to accomplish the desired output.

These decisions can be divided as periodic-decisions viz. selection, design and updating of resources, transformation process and methods, and continual decisions about day-to-day operation and control of various activities/operations in the system. These decisions can also be divided in planning, implementation and control categories.

Production information system is a network to generate necessary information and process it to make various decisions related to some production system. It consists of communication channels and information processing centres collecting information from its sources of origin, storing, updating, collating and processing it and then supplying the processed information to the various users of the system.

A production information system can be viewed as an independent group of sub-systems each related to its successor, each performing a different function though yet united with others for achievement of the overall objective. It interacts with both its internal and external environments.

The components of the system can be described as:

1. Long Term Planning

This implies planning the conversion system specifying the sequence of operations, capacity of the system, plant location and its layout aspects. The decisions derived have long term impact and are difficult to undo once implemented. Information for taking such decisions is compiled periodically for determination of appropriate product mix.

2. Annual Production Plan

These are meant to plan the use of transformation process. These plans are drawn from sales programmes by optimizing inventory-carrying costs, costs on labour with hiring and firing of personnel etc. These plans are revised periodically.

3. Inventory Control

It is generally expressed in terms of money and number of units produced. It deals with preparation of master inventory and production schedules.

4. Production Scheduling

These decisions are to determine: what to make, when to make, how to make, how much time is required to make it, production plan, bill of materials and operations sheets providing the necessary information for the preparation of production schedules.

5. Dispatching

Time standards are formulated through operation/route sheets supplied by planning and engineering departments. Cost standards are calculated through cost cards and job tickets and the quality standards are prescribed by design & engineering sections.

Characteristics of Production Information System

1. It should always be tailored to the need of a particular organization. It can never be specific or general.
2. The involvement of top management in the formulation of production information system is essential.
3. Data base should be wide.
4. It must be flexible and should be supplied timely.
5. Data should be capable of easy interpretation & presentation.
6. The cost of procuring the information must not over-ride the relative advantage accrued.

In production system most of the information needs are in the area of:

(i) Production, Planning and Control

(ii) Materials management viz. purchase, stores and inventory Control etc. with an objective to optimize production by identifying the variances so that these could be closely monitored.

MacNeice has subdivided these records into three types:-

1. Records of Basic Information

• Blue Prints
• Bill of materials
• Time value of fundamental operations
• Production routing

2. Records showing what is available

• Raw material records
• Work in process
• Semi-processed stock
• Finished goods stock
• Information about tools, jigs, fixtures, gauges and personnel available
• Machinery and equipment details

3. Historical Records

• Records of production
• Records of waste and reject
• Records of machine performance
• Records of sales
• Records of absenteeism

The nature of these records can vary for different type of plants and production systems as well as according to the situation and needs of the management. In a small organization the preparation and maintenance of these records is the job of shop floor.

But it becomes an important function in medium and large scale organizations having separate section for collection and preservation of such records. Usually this Work is done by dispatchers who continually observe the actual implementation and compare it with the programme previously intimated.