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
Discuss why who is database should be publicly used?
If i want to buy your domain
but i don't konw who registered this domain
So the whois public information is useful for me to connect you.
Backup is getting more and more important because we do have more and more data on our computers, that is not stored anywhere else.
Hard disk can fail, virus can strike, laptop can be stolen, natural event occur... if disaster strike, your data can simply disappear.
This data can have a sentimental value (think about baby photos) or commercial value (think about customer database, or technical documentation, or reports...)
therefore, it's very important to have a backup available in order to restore the data.
A few years ago, The Ponemon Institute, which studies business privacy practices, surveyed 43 U.S. companies across 17 industry sectors that lost data in 2008. According to the study, data losses ranged from 4,200 records to 113,000 records, and each data record lost cost $202-making the total cost between $848,400 and $22,826,000.
There are many ways to create a backup, from manual (burn a DVD once in a while) to fully automated and secure (with services that remotely backup your important folder on a secure server over the internet - such as 77backup.com)
Backup is like insurance, it's a waste of money as long as you have no troubles...
What are two method of retrieving SQL?
1.what cursor type do you use to retrieve multiple recordsets?
2.What are two methods of retrieving SQL?
Torsion is the twisting of an element from one end relative to the other; this causes deviation from its original shape.
An application is as follows:
Calculating the torsion of a member (say an I-Beam) to determine the maximum load the structure (in this case I-Beam) can handle before failure. In engineering, specifically Civil Engineering, this is extremely applicable.
NOTE: Bending moment is NOT the same as torsion.
What is the largest decimal number that can be stored ising 8 bits or 1 byte?
255 is the largest decimal number.
1 byte (8 bits) can store 256 *values* (0-255).
Triggers are an action that is performed is a condition is met within the code. In this example, "TRIG56" will perform this action: After a row is inserted into TABLEZZZ, if the row is <=50 then
insert the same row into TABLEYYY. If the condition/value is not
met, the row will not be inserted.
You can do a "BEFORE" trigger also. Triggers are code that must be compiled. You can also "disable" a trigger if you are doing an import into the tables for faster insertion. However, the inserts will have to be done into both tables because TABLEYYY will not be populated from the trigger because it is disabled. CREATE TRIGGER trig56 AFTER INSERT ON tableZZZ REFERENCING NEW AS insertedRow FOR EACH ROW WHEN (insertedRow.a <= 50) BEGIN INSERT INTO tableYYY VALUES(:insertedRow.b, :insertedRow.a); END trig56; . run;
Trigger is a statement that excute automatically as a side effect of modification to the database.
A trigger is defined for and connected to a RDBMS table. A trigger can be defined to do a particular job (typically insert audit records in another table or perform some validations) whenever the original table (on which the trigger is created) is selected or inserted, updated or deleted. A trigger is used to ensure that certain jobs are automatically done when a predefined event occurs. Both the event and the resultant action typically happen within the database.
A trigger is a set of statements that gets executed implicitly or automatically whenever any one of the following operation takes place on the table for which trigger has been created :
1. Inserting record(s) to the table
2. Deleting record(s) from the table
3. Updating the table
The operation on which trigger gets executed and the work performed at that time depends on the statements written in the trigger.
Why is mainframe computing important?
Mainframes are primarily used to store and retrieve vast amounts of data simultaneously amongst many workstations. They are typically used in the financial and banking industries, the airline industry, space agencies and universities. That is, any small to large-scale organisation that requires a data centre.
Mainframes are often thought of as being enormous computers, however the size is actually immaterial. The smallest mainframe consists of just a single cabinet housing the processors, memory, hard-drives and backup facilities, not much unlike a standard desktop computer (albeit slightly bigger). The real difference is in the number of workstations. Whereas a desktop computer independently serves just one workstation with its own discrete set of programs and data, a mainframe can simultaneously serve hundreds if not thousands of workstations with the same programs and data.
Their size is primarily dependant upon the number of workstations and the amount of data that must be served. The mainframe itself (the processor and working memory) may be housed in one or more cabinets, while the data and backup facilities are spread over several more cabinets, perhaps even in separate rooms. The processor itself may consist of several processors all working in parallel (not unlike a multi-core processor, but actually made up of several multi-core processors).
Large mainframes are often confused with supercomputers. However supercomputers are specifically designed to perform high-speed, highly-complex floating point mathematics (with many decimal places), such as predicting the weather or to simulate nuclear reactions, whereas mainframes are specifically designed for transaction processing -- moving data around and performing simple arithmetic upon the data (with relatively few decimal places).
Although their role in the workplace has been partially replaced with cloud-based computing (server farms), the need to keep sensitive data in-house rather than entrusted to an external agency means they still have a vital role in the workplace, most notably in the banking industry.
Moreover, the "gameframe" is a newer breed of mainframe that includes features not unlike that of a supercomputer. They are best described as being a hybrid of the two. As the name suggests, they are aimed at the online gaming community, however their usage could be extended to the film and video effects industries.
It is a database. The database is more than just the table, which is what some people think, but includes all those other components too.
Can you password protect an access database?
Yes, but you must follow specific procedures when opening the database you want to protect. See related links for screen shots and details about how to protect an Access 2007 database.
Of course, you always could use one of dozens of commercial applications to encrypt and password protect any file on your computer.
Basic problems and limitations of manual system?
erm... well.... :]
it costs alot (paper) maybe
many time is loss
same times the staff is writing wrong letter
loss date with out save
Can you share contacts outlook?
Of course yes. You can use some software to help you share outlook contacts with multiple computers. What I know is that, WinPST Share Outlook is quite good in this field. Maybe you can just google and check it.
Advantages Disadvantages of Management by exception?
One advantage of management by exception is the fact that managers can easily focus on remedying a problem. One disadvantage is the fact that management may miss other problems while focusing on one area.
Difference between data mining and DBMS?
A DBMS (Database Management System) is a complete system used for managing digital databases that allows storage of database content, creation/maintenance of data, search and other functionalities. On the other hand, Data Mining is a field in computer science, which deals with the extraction of previously unknown and interesting information from raw data. Usually, the data used as the input for the Data mining process is stored in databases. Users who are inclined toward statistics use Data Mining. They utilize statistical models to look for hidden patterns in data. Data miners are interested in finding useful relationships between different data elements, which is ultimately profitable for businesses.
DBMS
DBMS, sometimes just called a database manager, is a collection of computer programs that is dedicated for the management (i.e. organization, storage and retrieval) of all databases that are installed in a system (i.e. hard drive or network). There are different types of Database Management Systems existing in the world, and some of them are designed for the proper management of databases configured for specific purposes. Most popular commercial Database Management Systems are Oracle, DB2 and Microsoft Access. All these products provide means of allocation of different levels of privileges for different users, making it possible for a DBMS to be controlled centrally by a single administrator or to be allocated to several different people. There are four important elements in any Database Management System. They are the modeling language, data structures, query language and mechanism for transactions. The modeling language defines the language of each database hosted in the DBMS. Currently several popular approaches like hierarchal, network, relational and object are in practice. Data structures help organize the data such as individual records, files, fields and their definitions and objects such as visual media. Data query language maintains the security of the database by monitoring login data, access rights to different users, and protocols to add data to the system. SQL is a popular query language that is used in Relational Database Management Systems. Finally, the mechanism that allows for transactions help concurrency and multiplicity. That mechanism will make sure that the same record will not be modified by multiple users at the same time, thus keeping the data integrity in tact. Additionally, DBMS provide backup and other facilities as well.
Data Mining
Data mining is also known as Knowledge Discovery in Data (KDD). As mentioned above, it is a felid of computer science, which deals with the extraction of previously unknown and interesting information from raw data. Due to the exponential growth of data, especially in areas such as business, data mining has become very important tool to convert this large wealth of data in to business intelligence, as manual extraction of patterns has become seemingly impossible in the past few decades. For example, it is currently been used for various applications such as social network analysis, fraud detection and marketing. Data mining usually deals with following four tasks: clustering, classification, regression, and association. Clustering is identifying similar groups from unstructured data. Classification is learning rules that can be applied to new data and will typically include following steps: preprocessing of data, designing modeling, learning/feature selection and Evaluation/validation. Regression is finding functions with minimal error to model data. And association is looking for relationships between variables. Data mining is usually used to answer questions like what are the main products that might help to obtain high profit next year in Wal-Mart?
What is the difference between DBMS and Data mining?
DBMS is a full-fledged system for housing and managing a set of digital databases. However Data Mining is a technique or a concept in computer science, which deals with extracting useful and previously unknown information from raw data. Most of the times, these raw data are stored in very large databases. Therefore Data miners use the existing functionalities of DBMS to handle, manage and even preprocess raw data before and during the Data mining process. However, a DBMS system alone cannot be used to analyze data. But, some DBMS at present have inbuilt data analyzing tools or capabilities.
What is the purpose of migrating Microsoft Access to RDBMS Oracle?
You migrate to a larger scale DB for reasons such as the limitations that access may have. Access is traditionally a desktop database,but it is used in large corporations that may require control of users and other features that will and can make life so much easier. Unfortunately, Access does have its limitations and its performance begins to degrade depending for example, when you have extremely large tables, the user population increases considerably, then access time suffers. Migrating to Oracle which is very competent and has a reliable RDBMS; can hold many more tables than Access and was built to handle a large volume of traffic which is not limited to only users, but processes many many more transactions than Access can. Hope this helps.
Can you use a commit statement within a database trigger?
1. As with any other use of transactions - to ensure a collection of commands within the trigger are executed in a repeatable way in the event of failure.
2. To 'undo' the process that caused the trigger to fire. For example, the trigger might be doing some additional integrity checks and issuing a rollback to undo the initiating update/delete.
---------
AnswerCome to think of it, I have never seen a commit on triggers. Triggers as you know are a last line defense based on an action that was carried out by an insert,update or delete. Hence, since the trigger exists on the server, and is only fired if one of the above conditions are executed then it seems pointless to use a commit in the trigger. Also commit goes along nicely with transactions where you begin the transaction and if all is well then you issue a commit, else if the transaction fails, then you issue a rollback.What are examples of databases?
Point of sale Inventory system (Till)
Warehouse Inventory System
Electronic Telephone Book
Airline booking system
Hotel Booking system
What are the problems can a clinic using a file based system have?
Any database or file system must be kept up to date. The database or file system can not be used should the computer system is down, either due to a power-cut, or a virus attack, etc.
If, instead of using modern computers and networking, etc, a clinic uses an old fashioned manual card system instead, then the filing system would not be affected by power cuts or cyber-type attacks. Such a manual card system would mean that the patient details would have to be passed to the doctor physically by the receptionist, rather than the doctor viewing the network and seeing the patient's details on a computer screen placed on the doctor's desk!
It is the order that an event may happen if it is planned;
the way something is meant to be made or to happen.
