A program depends on data to be properly stored and handled. The data storage format
selected must be appropriate for what the program intends to do. Data can be stored as a file
or a database - object-oriented, relational, multidimensional. The selected data storage
format needs to consider processing efficiency to make the program as fast as possible while
maintaining reliability, security, and availability. A relational database is the most used
database. A relational database is a collection of tables, which each contains a primary key,
that can be related to each other using the primary key to tie them together. Relational
databases allow for referential integrity which allows the database to ensure that the
information is valid. Structured Query Language (SQL) is the standard language for access
the data.
NoSQL databases do not use the relational model or SQL. These can include document-
oriented databases, wide column stores, and graph databases. These databases support high
transaction rates and can store audio, video, and image files which do not fit well into a
relational structure. System, language and databases are very important when putting
together information systems. The data base is going to be where all the information that the
code is creating is going to be stored in. The language is going to be what combination of
characters are used in order to retrieve the information. Have a good understanding of
databases is good for being able to troubleshoot errors of food, and the proper way of
maneuvering around effectively. Program design and data storage design work hand in hand
to ensure efficient and effective system development. Program design can be understood as
the blueprint for a software application responsible for things such as functionalities,
algorithms and interactions. Data design is responsible for the organization and storage
needed from the software. Accessing information is important and program design has to
work around data storage design to make sure accessing information is quick. Program
design propels data storage design. The design of the program will decide the types of data
to be stored, their relationships, and access patterns. This will also sway the data storage
design decisions like the choice of database model. On the other hand data storage design
determines program design. The chosen data storage design affects the program design in
terms of data retrieval, manipulation, and storage operations. The program has to be
compatible with the chosen data storage solution efficiently.When comparing two types of
databases I think it is a good idea to consider relational databases (SQL) and NoSQL
databases. Relational databases use a structured schema to organize data into tables with
predefined relationships. They provide efficient data consistency and support powerful
querying capabilities through SQL. Relational databases are suitable for applications with
well-defined schema. An examples would be banks. NoSQL databases are designed for
handling large volumes of unstructured/semi-structured data. They offer flexible schemas
and horizontal scalability. NoSQL databases come in different types such as key-value stores
(Redis), document databases (MongoDB), etc. NoSQL databases are commonly used in
applications requiring high performance, scalability, and real-time data processing, such as
Instagram. To begin, program design and data storage design are closely related and
dependent on each other. Program design determines the structure and functionality of the
software, while data storage design determines how the data is organized and stored within
the software. The data storage design will depend on the program design due to the fact that
the design of the program will affect its size, accessibility and change how the data is kept in
the program. Because of this the data storage will be significantly impacted by the
architecture of the project. The two types of databases I will be getting into are single-file or
file database.
and multi-file or structured database. Single-file database cross-platform and can be
accessed on any machine. You would use file databases in the event of storing the username
and password, entities and attributes, contact details and product details. You would use a
structured database in scenarios where there is need to store the known structured data which
posses a finite individual or a finite application that are accessing the database.
Program design and data storage design are closely interrelated in the context of database
systems. Program design involves designing the software applications that interact with the
database, while data storage design focuses on designing the underlying structures and
mechanisms for storing and retrieving data efficiently. The relationship and dependencies
between the two can be summarized as follows:
1. Data Access and Manipulation: Program design heavily depends on the data storage
design to efficiently access and manipulate data. The structure and organization of
the database affect the design of the program's queries, transactions, and data
manipulation operations.
2. Performance: The program design and data storage design impact the performance of
the system. The efficiency of the data storage design, such as indexing strategies,
partitioning, and caching mechanisms, can influence the performance of program
operations that rely on data retrieval and updates.
3. Data Integrity and Constraints: Program design and data storage design collaborate to
enforce data integrity and constraints. The program design defines the logic and rules
for data validation and enforcement, while the data storage design implements
mechanisms like primary keys, foreign keys, and constraints to ensure consistency
and integrity.
4. Scalability: Program design and data storage design play a vital role in achieving
scalability. The program design should be scalable to handle increased user load and
changing requirements, while the data storage design should support efficient data
distribution, replication, and partitioning to scale horizontally or vertically.
Now let's compare and contrast two types of databases: relational databases and NoSQL
databases.
1. Relational Databases:
2. Relational databases store data in structured tables with predefined schemas. They
use SQL (Structured Query Language) for querying and manipulating data.
Relational databases are known for their strong data consistency, ACID (Atomicity,
Consistency, Isolation, Durability) properties, and support for complex relationships
between entities. They are suitable for applications that require data integrity,
transactional consistency, and complex queries. Examples of use cases include:
• Banking systems: Relational databases ensure the accuracy and consistency of
financial transactions, enforce constraints, and support complex queries for
generating reports and analytics.
• Enterprise resource planning (ERP) systems: Relational databases provide a
structured approach to manage various business processes, such as inventory, sales,
and human resources.
1. NoSQL Databases:
2. NoSQL databases are designed to handle unstructured and semi-structured data.
They offer flexible schemas, horizontal scalability, and high availability. NoSQL
databases do not rely on fixed table structures and support various data models like
key-value, document, columnar, and graph. They are suitable for applications that
require massive scalability, high write throughput, and schema flexibility. Examples
of use cases include:
• Social media platforms: NoSQL databases can handle high volumes of user-
generated data, such as posts, comments, and likes, with ease. They provide
horizontal scalability to accommodate millions of users.
• Internet of Things (IoT) applications: NoSQL databases can handle diverse and
unstructured data generated by IoT devices, such as sensor readings, logs, and
geospatial data, efficiently.
In summary, the choice between relational and NoSQL databases depends on factors such as
data structure, consistency requirements, scalability needs, and the nature of the application.
Relational databases are well-suited for structured data and applications that require data
integrity and complex queries. NoSQL databases excel in handling unstructured data and
providing horizontal scalability for applications with high volumes of data and varying
schemas.
Relationships and conditions are how a component uses or depends on other components.
Level 2 - Relationships and dependencies between program and information storage design
Information storage configuration is based on the program schedule. This is especially
evident in the way program organization affects the size and how it is achieved, and thus
how information storage is performed in the program. Information storage is therefore
heavily influenced by program planning.
Different information stores are created for each exceptional piece of primary information.
This shows that it is possible to adjust the program's programming schedule. One model is
the different information storage of DAS and NAS, leading to contrasting program plans.
types of information bases
There are two types of information databases -
1) Single record or document information database -
Records of this type are user names and secret phrases, items and properties, contact details,
and when deleting item details used for
2) Multi-Record or Structured Record -
This type of record is used in situations where it is necessary to store organized information
that is expected to be reached by a limited number of people or applications.
Databases and data storage are an integral part of systems development, deciding on which
database and data format to use will dictate how efficiently the system will operate. It is
important to choose the correct database when designing the system, or the user experience
might be diminished and the system will be a failure. Relational databases are the well
known and structured query language, or SQL, is used to access the data stored. Other types
of databases include, legacy database, object-oriented database, and NoSQL database, just to
name a few. They each are used in a scenario to maximize the efficiency of how the data is
accessed, and each has disadvantages and advantages, that should be taken into
consideration. For example, object-oriented is best used when supporting audio and video
data types. Netflix and other over the top streaming services can utilize this type of database,
since their systems encompass complex audio and video and many of them use object-
oriented programming. However, these type of databases can cost much more than other
types of databases, and they are not widely accepted. NoSQL databases are used with big
data. Many companies utilize this big data in order to compile data so that they can use that
data for marketing and other research. Grocery store bonus programs entice people to sign
up for their programs, so that they can collect data from the consumers so that they can track
shopping data. It is important to read privacy policies in order to know how companies use
the data that we give them access to. Program design and data storage design are not unlike
symbiotic lifeforms; as they need each other to work. The program design phase directly
affects the data storage design and vice versa because of the way it'll all work in the end.
Your end-users will use the program to access and manipulate the data [storage] when the
project is completed, so it is essential these two design phases are coordinated. The type of
data storage design will depend greatly on the type of program being developed and for what
industry/project it's being developed for. Relational databases are most common with their
management systems being terms we've heard like SQL. They tend to be used for a lot of
banking and general business management systems. There are other types of databases that
are not relational such as NoSQL as well, these generally are utilized in systems that deal
with a large volume of unstructured data and have far more flexibility. These tend to also be
a lot more scalable in design and work well in cloud computing. Program design and Data
design work closely together and need each other with the development of systems. The
logical design of the program can directly influence the design of data storage. Data storage
design provides the necessary infrastructure components to store and retrieve data required
by the program. It ensures that the data is organized and accessible based on the programs
needs. The dependencies and requirements of the program can also influence the design of
the data storage. A relational database organizes data into tables. They use a structured query
language (SQL) for manipulating and querying data. They establish relationships between
tables using keys. Thes are databases are for example My Sql and Orale. No SQL databases
or Non -relational databases are designed to handle large volumes of unstructured data. They
have flexible schema designs allowing for scalable storage and often used in cloud
computing environments. a Program design and data storage design is a big part of the design
phase in the SDLC life cycle. The program design is the layout of the program before it is
actually coded in a chosen coding language. If done correctly it'll make the life of the
program longer. The data storage design establishes the data storage format. It shows how
data is managed and stored. Multimedia database is a data base that stores multimedia such
as audio, videos, and images. This database can be used in many things. You can use it in
creating a webpage. Although there may be I have not seen any websites without images.
You could also use them in video games which contains all audio, video, and images.
Another database is the NoSQL database. This database is for storing and retrieving data.
NoSQL databases are typically faster when storing and retrieving information and are
considered more flexible. What I would use this database for is customer tracking, online
shopping, and big data. I can't cover all of what these two databases can do or are capable of
but that's the basics. Program Design models explains how your organization defines
• Value proposition: how your organization distinguishes itself from the competition a
• Products and services: what your organization offers, how those offerings work,
and why your prospects need them
• Impact: the measurable change your organization expects to make a a
• Partners and customers: who your organization seeks to collaborate with and serve
• Talent: who and how your organization recruits team members
• Resources: the tools and connections your organization needs to succeed and how
you will acquire and maintain them
• Revenue: how your organization will financially sustain and grow its efforts
Data storage Design is how data storage and handling by programs running the system
takes place.
The main steps of data storage design are to:
• Select the data storage format
• Convert the previously made logical data model into a physical data model
• Ensure that the ERDs and DFDs balance
• Design the selected data storage format to optimize its processing efficiency
