A computer system comprises hardware and software components, aiming to offer a powerful computational tool. These systems play a crucial role across diverse domains, aiding us in numerous tasks. The prevalence of the internet has significantly bolstered the utilization of computers for information sharing and communication. Computer systems empower us to store, process, display, and transmit information. Even in a basic modern computer system, multiple programs are typically required to carry out various functions effectively.

Showing posts with label database. Show all posts
Showing posts with label database. Show all posts

Saturday, September 18, 2021

What are the benefits of marketing information system?

Marketing information system has the following benefits:
*It helps marketing planning by gathering reliable information. It handles both internal and external data.

*The problems and opportunities are automatically spotted out. It helps effective tapping of marketing opportunities and effective defense against marketing threats.

*It helps in spotting trends and facilities on formulation of basis of assumption economic and business conditions. It tends to be future oriented.

*It helps the firm adjust its products and services to the needs and tastes of consumers. It acts as a control mechanism as customer reactions are also fed into it from market intelligence, the first sales force or marketing research.

*It provides market intelligence to the firm.

*The system can provide information on seasonal and cyclical demand patterns for planning, monitoring and control purpose.

*It helps controlling marketing activities. The report can be used to monitor and control marketing operations.

*Sharing selected operational information in order to gain advantage from superior expertise across organizational boundaries and further improve efficiency.
What are the  benefits of marketing information system?

Wednesday, January 27, 2021

Database maintenance: An ongoing process

Database operation and maintenance is an ongoing process and need to be updated continually to reflect new business transaction and other events.  It involves the following steps:
*Monitoring database performance
*Tuning and reorganizing the database whenever necessary
*Enforcing standards
*Supporting users

Database maintenance including add, delete, update, and correct the data in a database, including hyperlinked data on Web pages. Database maintenance sometimes involves changing a database design, e.g., adding new elements to existing records or adding new datasets to database, as the goals and requirements associated with applications change over time.

The database maintenance process is accomplished by transaction processing and other end user applications, with the support of the DBMS.

End users and information specialist can also employ various utilities provided by a DBMS for database maintenance.
Database maintenance: An ongoing process



Thursday, February 16, 2017

What is information retrieval?

Information retrieval (IR) is information-seeking behaviors which uses computer technology to access desired information from a database.

The term information retrieval is attributed to Calvin Mooers around 1950, and its used is associated with the explosion of scientific documentation produced during and following World War II.

Most typically, the term refers to the identification of documents from a collection on database of documents or of scientific information.

 Information may be retrieved directly through an interface or indirectly, through an intermediary (such as librarian). Retrieval is dependent upon searching within certain defined and indexed fields, such as title, author, subject etc.

Computer based information retrieval systems can largely overcome many of the limitations of manual systems. In most cases computer-based retrieval systems not only allow the user to combine several retrieval parameters, but they also provide relatively rapid results.
What is information retrieval?

Saturday, October 31, 2015

Categories of computer filing system

File systems is the mechanism used by a computer system to map the specific locations of information stored in nonvolatile storage.

File systems are classified into the following four categories:
*Disk file system: A system used for storing and recovering the files on a storage device, such as a hard disk, floppy disks, CD-ROMs that is directly or indirectly connected to a computer.

*Network file system: It is a type of file system that provides access to files on other computers on a network. The primary function of network file system is to mount directories to other computers. These directories can then be accessed as though they were local. With the advent of network file system, shared file name spaces were possible – many computers could see and access the same files at the same time.

*Database file system: Earlier file system a hierarchial management structure, but in the database file system files are identified by their characteristics, like the name, type, topic and author.

*Special purpose file system: A file system where the files are organized by software during runtime. This type of file system is used for various purposes, such as communication between computer processes or temporary file space. The system can often high-speed interconnection networks that avoid some performance problems.
Categories of computer filing system 

Sunday, September 13, 2015

In-memory database

In-memory databases do not use any file to store any kind of information, the databases and their logs are stored entirely in the main memory. So, the database operations are superfast. When the application closes an in-memory database, the database is eliminated from the main memory.

In-memory database management systems have the potential to reduce the execution time of complex operational analytical queries to the order of seconds while executing business transaction in parallel.

Since in-memory database utilize the server’s main memory as primary storage location, the size, cost and access speed provided by main memory components are vitally important.

With the help of data compression, today’s standard server systems comprise sufficiently large main memory volumes to accommodate the entire operation data of all companies.

Main memory, as the primary storage location is, nevertheless, becoming increasingly attractive as a result of the decreasing cost/size ratio.

The In-Memory Database (IMDB) technology has proven to have major capabilities for analyzing big enterprise and medical data, e.g., to identify relevant patient data and to protect markets from injecting pharmaceutical counterfeits.
In memory database

Saturday, June 27, 2015

The advantages of single database in organization

One of the reasons that organization were so slow to respond in the past was that they simply did not have a clear view of what was happening within their company.

The data was inconsistent due to different definitions, cut-off dates and measurement criteria. Data often partitioned into several disjointed systems, with each system having its own collection of files.

Large businesses (and countries) have been traditionally less efficient than smaller organizations due to the cost of coordination and the increase in bureaucracy to deal with large amounts of information. Delegation of authority to compensate for this factor has led to lack of control, lower efficiency and fragmentation of business.

The solution is a single, logical, and central database. When all the data for the various systems is stored in a single database, it gives everybody in the organization access to the same data at the same time. Many organizations are now bringing together all their separate systems to achieve this singular view.

Most data items are stored in only one file, which greatly reduces duplicate data. The data various users can be combined and shared among authorized users, allowing all users access to a greater pool of data.

The single database helps create an environment in which end users have better access to compare and better-managed data. Such access makes it  possible for end users to respond quickly to changes in their environment.

A single source of data gives the organization the ability to combine information across all business operations. Whereas managers used to receive a separate printed monthly report from each system, they can now obtain daily, or even hourly, electronic reports that give a single view of what matters, as it happens, across their entire organization.

Organizations that use database typically have security setting to define who can access, add, modify and delete the data in a database.

Chief executive can access a single dynamic report on screen to monitor their critical success factors and key performance indicators, such as sales, leads, liquidity, staffing or inventory levels.

These interactive reports allow the user, not just to monitor everything that is important to the company, but also to investigate variances and get immediate answers within a few mouse clicks.

In single database, when users modify data in the database, they make changes to one file instead of multiple files. Thus, the database approach increases the data’s integrity by reducing the possibility of introducing inconsistencies.

The availability of global information systems enables companies to maintain a functional structure on a large scale, which is more efficient, rather than creating multiple business units with complicated communication cycles.
The advantages of single database in organization

Wednesday, April 1, 2015

SQL (Structured Query Language)

SQL, the abbreviation for Structured Query Language, is a a standard computer lingo that was initially elaborated by IBM for querying, changing and determining relational databank, utilizing Declarative programming.

There are many graphical tools that have made the task of developing applications that use SQL easier. Most of these tools, however, are available in the high-end databases.

IBM developed SQL in 1970, which means it’s been around for over 45 years. Its original name was SEQUEL.  SEQUEL stands for Structured English Query Language. It was developed by Donald D. Chamberlain and Raymond F. Boyce.

SQL is widely implemented by many companies in the industry and almost all major relational database management systems support SQL.

There are four sub-languages that make the SQL:
*Data Query Language (DQL) operations
*Data Definition Language (DDL)
*Data Control Language (DCL)
*Data Manipulation Language (DML)

SQL goes hand-in-hand with the relational model because the result of an SQL query is a table (also called, a result set). Thus, a new permanent table can be created in a relational database simply by storing the result set of a query.
SQL (Structured Query Language)

Saturday, February 14, 2015

Single database for a large organization

Large organizations manage lots of data. One common reason that large solutions may comprise different database and applications is that each serves a specific purpose.

A better alternative to a file processing system is an integrated database approach. In this environment all data belonging to an organization is stored in a single database. Most organizations can benefit by having their data integrated into a single database.

A single source of data gives the organization the ability to combine information across all business operations. Whereas managers used to receive a separate printed monthly report from each system, they can now obtain daily, or even hourly, electronic reports that give a single view of what matters, as it happens, across their entire organization.

The data in the database is available to a large number of users who can access the data simultaneously and create reports and manipulate the data given proper authorization and rights. In a large organization it is not uncommon for the two people to be working on the same data simultaneously.

Chief executive can access a single dynamic report on screen to monitor their critical success factors and key performance indicators, such as sales, leads, liquidity, staffing, or inventory levels.

These interactive reports allow the user, not just to monitor everything that is important to the company, but also to investigate variances and get immediate answers within a few mouse clicks.

Since all the related data exists in a single database, there is a minimal need of data duplication. The duplication is needed to maintain relationships between various data items.
Single database for a large organization

Tuesday, October 21, 2014

Database interrogation

Database interrogation is an access the data in a database to display information in a variety of formats.  Information retrieval and database querying share the same goal of providing a user with information he is asking for.

End users can searching, selectively retrieve and display information and produce forms, generating reports and other documents, including Web pages.

Searching a database involves having a database management system locate those records in database that contain information of interest to a user.

The system will respond by searching the active dataset for all those records that meet the search criteria specified in that request.
Database interrogation

Sunday, October 12, 2014

Database development

Database is defined as a self-describing collection of data that represents a model of an information domain.

The database development is a major project that an organization may undertake. There are many issues that must be addressed before the project commences.

It is define and organize the content, relationship and structure of the data needed to build a database, including any hyperlinks to data on Web pages.

A well designed database is based on a good understanding of the business process. The first step in the development of a database is to identify business and goals to be achieved by the new database.

Several methods can help the database designers to collect the needed information.  This including interviews with key players and examine the company’s documents.

Many internal and external factors must be considered during the development lifecycle, including but not limited to historical and future information requirement, the diversity of the data consumer community, organizational integration requirements, security, cost, value, ownership performance, interface issues and data integrity.

Once the database is constructed, before the newly developed database can be used in the business process, it needs to be tested to see if the database is able to meet all the requirements.
Database development 

Friday, October 3, 2014

Database Management system

A database is a well-organized collection of data that are related in a meaningful way, which can be accessed in different logical orders.

Some commonly used databases are: address book, library catalogue, telephone directory and stock list.

The computer program used to manage and query a database is known as a database management system. Database management system is a collection of database and DBMS utilities which are used to develop applications to satisfy the requirements of user by application developers under the supervision of database administrator. Database management system is software that is helpful in maintaining and utilizing a database.

The main objective of database management systems are data availability, data integrity, data security and data independence.

Database management systems must facilitate the major functions including:
*Defining of database schema
*Manipulation of database
*Sharing of database
*Protection of database
*Database recovery
Database Management system

The Most Popular Posts

  • The evolution of business intelligence (BI) tools reflects the broader progress of computing technology and data management. In the 1970s and 1980s, early ...
  • Watermelons are quintessential summer crops, prized for their refreshing, red, juicy, and crisp flesh. Producing high-quality melons requires careful handl...
  • Selenium, an essential trace element, plays a crucial role in various bodily functions, including antioxidant defense and thyroid hormone metabolism. Plant...