0
Database Programming
Databases are collections of tables that maintain and display information, often collaboratively; this information can be used for interaction with an application or gaining general knowledge. Questions about database engines and modifying or using them belong in this category.
8,803 Questions
What is the Role of database administration?
Following are the roles of a DBA.
1) Secures data
2) Configures and maintains user profile
3) Assigns previleges for access
4) Maintain database statistics and plans expansions in hardware and software
5) Continuous system development
What are the five main features of databases?
1- Compactness - where there is no need for the old paper files that has a big size.
2- Speed - Because of the computer can restore the stored Data Base and upgrading it very fast than the normal human manual hand can do.
3- Less drudgery - Because the computer do every thing for you.
4- Currency - The more specific you can have when you asking for a Data Base information.
5- Simplicity - An easy way to collect, access-connects, and display information.
6- Stability - To prevent unnecessary loss of data.
7- Security - To protect against unauthorized access to private data.
What are the advantages of a manual?
There are many great advantages to using a manual juicer, the greatest is how cheap they are in comparison to the electrically operated machines. Due to not requiring an electrical output they can be used anywhere and can be taken when travelling somewhere. They are easier to clean as there are no wires to contend with. An excellent advantage to a manual juicer is that due to not using high powered speed settings like an electric machine the enzymes and nutrients in the fruits are preserved allowing the juice to maintain its vitamins and minerals.
Why is data the most important asset an organization?
Without data, an organization loses its record of transactions and or its ability to deliver value to its customers. The organizations network require protection and a secure infrastructure sevices.
source: Information Security page 40 chapter 2
record data mean to write down your data.
Data is the result of an experiment.
It is useful to record data for farther use.
There are three types of SQL:
1. Cognos SQL
2. Native SQL
3. Pass-through SQL
Cognos SQL
Framework Manager generates Cognos SQL in a more efficient manner in order to keep its functionality. It is common for Cognos SQL to be translated into Native SQL before being transmitted to the database for processing. Some actions or functions may not be supported by the database in some instances. Only a portion of the Cognos SQL is transmitted to the database in these situations. As a result, the database handles part of the query and the Cognos server handles the rest.
Advantages:
-
Has the ability to include metadata from many sources.
-
Reduce the number of database constraints
-
Interact more effectively with Cognos applications.
Disadvantages:
You cannot use non standard SQL.
Native SQL
Databases such as Oracle, SQL Server, and DB2 all support SQL. Using Native SQL in a model query subject with many data sources is not possible.
Advantages:
-
All relevant query subjects are optimized for performance.
-
You can utilize SQL that is specific to the database you are using.
Disadvantages:
-
You cannot use SQL that the data source does not support for sub queries.
-
The query subject may not be compatible with different database types.
Pass-through SQL
Allows the usage of Native SQL without regard to the limitations imposed on subqueries by the data source. Subqueries are not processed in Pass-Through SQL query subjects. It is instead supplied directly to the data source that generates query results for each subject.
It is important to keep in mind that pass-through SQL is delivered straight to the data source rather than being optimized by the Framework Manager, therefore performance will be lower than with the other query options.
Using curly brackets around your SQL statement in a Tabular SQL object causes that SQL statement to be passed through to the database. Cognos has not validated this SQL, so take that into consideration.
Step1: Create a Tabular SQL object. Write a statement surrounded with { }.
Actual:
SELECT * FROM ORDER HEADER
Pass-Through:
{SELECT * FROM ORDER HEADER}
Advantages:
- You can use any SQL supported by the database.
Disadvantages:
- Framework manager does not have the ability to automatically optimize performance. In some cases, the SQL won't function with another data source.
What are the benefits of redundancy?
Redundancy insurance cover is an income protection policy that pays you monthly benefits if you are to become involuntarily unemployed. Redundancy cover is suitable for anyone between the ages of 18 and 64.
What separates the physical aspects of data storage from the logical aspects of data representation?
A schema separates the physical aspect of data storagefrom the logical aspects of data representation.
What is database and how is using in C?
A database is a type of application that stores information in tables, which are made of columns and rows, such that certain terms can be fed to it and related information fed back out. C can be used to make a database, but inside the database, c can't be used: in generally a set of specifications called "SQL" and "ansi SQL" are used to describe how to get the data back out of the database.
How can you get the line breaks to work when you retrieve data from MySQL to PHP?
In most raw (not formatted) text, such as the text in a simple HTML input element, new lines are denoted by a special "newline" character (commonly referred to as \n). When the text reaches this character, it pulls the text following it to the next line.
For example, the string "hello\nworld" would actually appear as:
hello
world
When you submit and retrieve text data in MySQL, it preserves these newline characters as they were originally entered. When you print them onto an HTML page, you may notice that newline characters do not seem to "work" as you could expect them to. The previous string would actually appear as "helloworld", instead of being broken up into two lines.
This is because the string is printed into the HTML source code as "hello\nworld". Browsers are supposed to ignore most whitespace and newlines, which would give us the resulting "helloworld".
In HTML, new lines are created with the
element. When pulling raw text data from MySQL, you will probably want to replace any occurrences of newline characters (which is the raw text's way of creating new lines) with the
element (which is HTML's).
A function exists which easily makes the replacements. It is the nl2br() function, which (simply put) accepts one string as an argument (the text data to replace newline characters) and returns a string (the text data with \n replaced as
).
Example:
$string_taken_from_mysql = 'hello \n\n hello';
echo nl2br($string_taken_from_mysql);
?>
Outputs:
hello
hello
What are some basic database functions that a spreadsheet cannot perform?
A spreadsheet is a computer application that simulates a paper accounting worksheet. It displays data in a two-dimensional matrix or grid consisting of rows and columns. Each column is a field, which used to define and store data and each row is a record, which is a connected set of one or more fields that describes an object such as person. While a spreadsheet allows for the creation of multiple tables, it does not support even the most basic database functionality such as support for self-documentation through metadata, enforcement of data types or domains to ensure consistency of data within a column, defined relationships among tables, or constraints to ensure consistency of data across related tables.
What is the advantages of using computer over typewriter?
you can do way more with a computer then a typewriter. u have apps and internet there is way more 2 do.
If you are just talking about writing a document. Then you can delete mistakes on a computer much faster than a typewriter. Also you can type faster on a computer keyboard than on a typewriter.
Database application programming interface for C plus plus?
This IDE is easy to use and created specifically for C and C++. SQLAPI++ is a C++ library for accessing various SQL databases (essentially a set of header files) (Oracle, SQL Server, DB2, Sybase, Informix, InterBase, SQLBase, MySQL, PostgreSQL, SQLite, SQL Anywhere and ODBC). It is simple to use and implement.
To learn more about data science please visit- Learnbay.co
Well, that depends. The complete data on a customer is called a 360-degree view.
What does each column in database represent?
Each column in a database table represents an attribute reg. the data that is held in that table. For ex:
Table Employee can contain employee number, name, age, date of joining etc. Each of these items would be stored as individual columns in the Employee table.
sort
A record database is all the information dealing with one particular subject.
