Database Programming

Data accessed refers to the act of retrieving, viewing, or using data stored in a database or other electronic storage system. This can involve running queries, performing searches, or simply viewing the content of a file or database record. Accessing data is a fundamental part of using and analyzing information in various digital platforms.

The objective of databse is to categorise Information and to hide them as for example amazon's database keeps the info if everybody who has ever used it so be sure not to show the mainframe but there is another bit to a database. The table, this can be shown freely and contains smart ads to help your needs. Like the recommended part of amazon takes the information from their database and shows it as a table in the form of a webpage

A hash table is where data storage for a key-value pair is done by generating an index using a hash function.

Open Hashing (aka Separate chaining) is simpler to implement, and more efficient for large records or sparse tables.

Closed Hashing (aka Open Addressing) is more complex but can be more efficient, especially for small data records.

• Database management systems are intricately developed.
• Database systems are complex, difficult, and time-consuming to design
• Management complexity.
• Frequent upgrade/replacement cycles.
• At risk from the attack of viruses and hackers
• Initial training required for all programmers and users

An electronic database is a structured collection of data that is stored and accessed electronically. It allows for efficient storage, retrieval, and manipulation of data, typically organized in tables with relationships between them. Electronic databases are widely used in various fields to store and manage vast amounts of information.

A hash table is where data storage for a key-value pair is done by generating an index using a hash function.

Open Hashing (aka Separate chaining) is simpler to implement, and more efficient for large records or sparse tables.

Closed Hashing (aka Open Addressing) is more complex but can be more efficient, especially for small data records.

In file processing system a permanent system file is created for every new object. Application softwares are used to manipulate these files. SO characteristics (Some of them became its drawbacks) of file processing system are:-

1)Data redundancy and inconsistency

2)Difficulty in accessing data

3)Data isolation ie. data is in different formats and files.

In database system these issues where addressed, by data abstraction.

In DBMS, data is stored using 3 levels of abstraction

1)Physical Level : How data is stored

2)Conceptual level : What data is stored, relationship between data

3)View Level : What is visible to different users.

A database is nothing but simply a collection of records. The data can be stored all at a same place or can be distributed in different systems . When data is stored in different places that is distributed it is called distributed database.

A database is normally stored in one place. That could be a physical location, like a particular office. A distributed database is one database that has different parts of it stored in different places. This is often for security and safety purposes. To a user, they still see all of the data they need on their screen, so they don't even realise that it is stored in different locations.

the ability to modify the structure or schema of one level without affecting the other level is call data independence it is of two type

physical data independence

logical data independence

In File System, files are used to store data while, collections of databases are utilized for the storage of data in DBMS. Although File System and DBMS are two ways of managing data, DBMS clearly has many advantages over File Systems. Typically when using a File System, most tasks such as storage, retrieval and search are done manually and it is quite tedious whereas a DBMS will provide automated methods to complete these tasks. Because of this reason, using a File System will lead to problems like data integrity, data inconsistency and data security, but these problems could be avoided by using a DBMS. Unlike File System, DBMS are efficient because reading line by line is not required and certain control mechanisms are in place.

Logical data independence is considered more difficult than physical data independence because it involves changes to the conceptual schema and external schema, which are more closely tied to the way data is organized and viewed in the application. Physical data independence, on the other hand, deals with changes to the internal schema, which is more abstract and can be modified with less impact on the overall system.

A data dictionary is a repository that contains definitions of data processes, data flows, data stores, and data elements used in an organization. It helps to provide a common understanding of data terminologies and structures within a dataset or system. Data dictionaries are often used to maintain consistency and clarity in data management and analysis processes.

A database is useful because it provides a centralized system for storing, managing, and retrieving data efficiently. It helps maintain data integrity, enables data sharing among multiple users, enhances data security through access control, and supports complex queries and analysis.

-data redundancy:which reduce the redundancy-repetition of data

-security-it provides security for various levels

-data sharing-it allows multiple users to access and share the data

becomes easier in dbms

-data concurrency:it allow multiple users to acess the same data

simultaniously

Data diddling is a form of cyber attack where a person with unauthorized access to a computer system alters data for personal gain or to cause harm. It can involve changing data values, deleting records, or inserting false information without the knowledge of the system owner. Data diddling can have serious consequences for businesses and individuals, compromising data integrity and leading to financial loss or reputational damage.

A relational database management system (RDBMS) is a type of DBMS that stores data in a structured format using tables with rows and columns, and enforces relationships between data. A DBMS, on the other hand, is a broader term that encompasses various systems for managing databases, including relational, object-oriented, and NoSQL databases. In summary, an RDBMS is a specific type of DBMS that organizes data in a relational model.

A flat-table database is one that uses a single table to store all relevant data.

By contrast, a relational database uses several tables to store relevant data, and then establishes 'relations' between them using unique identifiers ... such as primary keys and foreign keys.

Flat-table databases are ok if the data is not too complex or repetitive.

Relational databases are good when the data is complex and repetative.

For example: Keeping track of a personal music CD collection - if one is lazy - can simply be done in a flat-table database table (or a spread sheet). It can also be done in a relational database by creating a few tables and relating them. One table can be artist (with a primary key), another table can be album (relates to a single artist primary key), and a third can be a record label table (which can relate to many artist primary keys).

This is a very high-level view of the differences. I .

Hierarchical diffusion is a pattern of diffusion where information or ideas spread from higher levels of authority to lower levels, often following established pathways of communication or power. This type of diffusion involves the step-by-step spread of innovation or influence from one group or individual to another in a specific order.

Purpose of database users with an abstract view of the data that is system hides certain details of how the data are stored and maintained.

It gives an architecture is to separate the user applications and the physical database.

Some key attributes of information quality include accuracy (information is correct and free from errors), completeness (information is comprehensive and includes all relevant details), relevancy (information is pertinent to the needs of the user), and timeliness (information is up-to-date and provided in a timely manner).

The objectives of a management information system are to provide relevant and timely information to support decision-making, improve operational efficiency, enhance productivity, and facilitate strategic planning within an organization. The system aims to collect, process, store, and distribute information to help managers at all levels make informed decisions that align with organizational goals.

A flat file is a simple file containing data without any structured format, while a Database Management System (DBMS) is a software system that manages databases by organizing, storing, and retrieving data. A DBMS allows for more organized and efficient data management, supports relationships between data, and provides features like security and data integrity that are not available with flat files.

XML schema is used to define the structure, content, and data types within an XML document. It helps enforce rules for validating data in XML files, ensuring that they conform to a specific format. By using XML schema, developers can establish standards for data exchange and communication between different systems.