Illustrates the applications of ASA
Illustrates the applications of ASA?
Expert
ASA seems to have many of niches. This is generally good at OLTP and can be used like a basis for a common database project. Certainly examples are there of implementations supporting 100 or many more users.
A main area for ASA databases is with applications which need to distribute the database along with the application as a common storage area for internal components, other than the database is not a main part of the deliverable. Therefore, Sybase themselves have done it with the IQ Meta data storage. Previous to release 11 of IQ, the Meta data was stored within an ASE database. Here, with IQ 12, the Meta data has moved to being stored within ASA. It makes the installation of IQ in production environments very simpler.
ASA has good ODBC support that makes it very attractive to tools oriented in the direction of ODBC.
Describe briefly the difference between identifier and attributes?
Give brief introduction of the term ‘Service Broker components’?
In Sybase illustrates the term Table Partitioning?
Assume when a session fails subsequent to loading of 10,000 records in to target. How can we load the records from 10001 the record when we run session next time?
Explain about Server Job and Parallel Jobs?
When two relational tables is connected to SQ Trans, what are the probable errors it will be thrown?
Briefly describe the fundamental stages of Data Warehousing?
Consider a MOVIE database in which data is recorded about the movie industry. The data requirements are summarized as follows: ¦ Each movie is identified by title and year of release. Each movie has a length in minutes. Each has a production company, and each is classified under one or more genre
Explain the following term: a) OLAP b) OLTP
Explain the standard folders?
18,76,764
1959717 Asked
3,689
Active Tutors
1419333
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!