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
One major problem in databases is concurrency. Concurrency problems arise when multiple processes try to update or insert data into a database table at the same time. Such concurrent updates can cause data to become corrupt.
Locking is a strategy that is used to prevent such concurrent updates to data.
When a database system modifies data in one of its tables it first acquires a lock. When a table is locked, only the process the acquired the lock is allowed to modify the data in the table. Other processes will have to wait until the lock is released before they can make their changes. Now, this is a simple representation of how locking works. In reality databases can use different locking strategies.
Depending on the database system, locks can be acquired on entire tables (table-level locking) or on individual rows (row-level locking).
How Armstrong rules are complete or sound in dbms?
Armstrong rules are complete or sound in dbms by clarifying the types of situations which need to be achieved and done.
Where can you get Sybase Training?
Sybase Training is currently being offered by SybaseTeamat reasonable charges.
You may email Training@SybaseTeam.Com for more details.
SybaseTeam offers below mentioned courses
- Sybase ASE DBA
- Sybase SQL Developer
- Sybase Performance Tuning
- Sybase Replication server DBA
- Sybase IQ DBA
- Sybase IQ Developer
- Sybase Unwired Platform ( SUP ) Administration
- Sybase Unwired Platform ( SUP ) Mobile Application Development
- Unix Basics
- Unix advanced Shell Scripting
- Perl Programming
- SEd,AWK programming
SybaseTeam - Sybase Technical support,Consulting, Training and Placement
HTTP Header attack
What is the relation between access and database?
Access is no security
Database has security
limited data can store in access
we can specify the size and file growth. we can store n number of data's
only primary key can specify in access.
but in database we can specify primary key as well foreign keys and other keys.
What are the reasons for the continued growth of online Transaction processing?
The reason behind OTP is that it is time efficicent.After OTP log file will be generated and which can be used 4 easily data recovery in case of system crash.example of OTP is ATM ,chek clearing system used in bank.
Placid04
BIHAR ,INDIA
How might the police use a database?
so they can track people down and find out their contact details.
hope this helped :)
- sajida
Which tool is used to create a query object?
a computer, a keyboard, oh and you might need a brain too
How would you respond appropraiately to problems with database tables?
check data:spell check, format,accuraacy,consistency.
dml processor process the dml statements such as select,update,delete etc that are passed by the application programmer into a computer program that perform specified task by programmer such as delete a table etc.
How to improve bookshop manual system?
To improve a bookshop manual system, consider digitizing records for easier access and organization, implementing a barcode system for tracking inventory accurately, and utilizing a customer relationship management (CRM) software to track customer preferences and purchasing habits. Additionally, conducting regular audits to ensure accuracy and updating the system based on customer feedback can help improve efficiency.
What is the importance of management information systems?
Management Information Systems are important because they provide information that supports operations, management and decision-making functions in an organization.
Where to use database approach?
ADVANTAGES
- Provide very efficient "High-speed" retrieval
- Simplicity
The network model is conceptually simple and easy to design.
- Ability to handle more relationship types
The network model can handle the one-to-many and many-to-many relationships.
- Ease of data access
In the network database terminology, a relationship is a set. Each set comprises of two types of records.- an owner record and a member record, In a network model an application can access an owner record and all the member records within a set.
- Data Integrity
In a network model, no member can exist without an owner. A user must therefore first define the owner record and then the member record. This ensures the integrity.
- Data Independence
The network model draws a clear line of demarcation between programs and the complex physical storage details. The application programs work independently of the data. Any changes made in the data characteristics do not affect the application program.
DISADVANTAGES
- System complexity
In a network model, data are accessed one record at a time. This males it essential for the database designers, administrators, and programmers to be familiar with the internal data structures to gain access to the data. Therefore, a user friendly database management system cannot be created using the network model
- Lack of Structural independence.
Making structural modifications to the database is very difficult in the network database model as the data access method is navigational. Any changes made to the database structure require the application programs to be modified before they can access data. Though the network model achieves data independence, it still fails to achieve structural independence.
Read more: The_advantages_and_disadvantages_of_database_network_model
What is online payment management system?
Online payment management system is usually a software that automates the management of online transactions (payments.) So instead of dealing manually with Paypal or banks if payments went through and confirming it to customers, certain software (like Blue Snap) do all these in a matter of seconds. In addition, it also sends a confirmation email to merchants that payment has been made. The software also automates currency conversion, depending on its feature.
What is generalization in database?
Generalization means to categorize some things in to a general category . In database also generalization means the same. Consider an example like Car and Motorcycle can be categorized in to one general category VEHICLE .
Having one database streamlines data management, reduces redundancy, and ensures consistency across the organization. It simplifies data access and retrieval, enabling users to work from a single source of truth, which enhances collaboration and decision-making. Additionally, maintaining one database can lower operational costs and improve data security by minimizing the complexity of managing multiple systems.
What criteria are important in choosing a file organization?
file volatility, file activity, file size, file queries, data currency
What are the advantages of mysql database management system?
The fact that it is free is its biggest advantage over programs like oracle. Its also easy to use and very well trustworthy. Its great for small businesses that dont plan to generate alot of traffic
