Compiled Messages: ------------------------------------------------------------ Message no. 5977 Posted by Waseem Manzoor (wmanzoor) on Tuesday, January 24, 2006 12:27pm Subject: database server confusion? Hi folks I have one confusion "Is data base server use only in client/server architecture model or even in other models too" Waseem ------------------------------------------------------------ Message no. 5983[Branch from no. 5977] Posted by Krishnamurth Ashwini (kashwini) on Tuesday, January 24, 2006 1:21pm Subject: Re: database server confusion? Waseem, In my view, There are atleast three architectural options: 1. Basic Client/Server (two tier) - Client performs user interface functions; Server performs all database functions. Each side can be configured for high performance as needed. The client consolidates the results from multiple servers (when multiple servers are used in a given site). 2. Intelligent Client/Server (two tier) - Thin Client - significant server functionality and minimal client functionality. If a query requires data from multiple sites, a local server consolidates results from multiple servers and sends it to the requesting client. 3. Middleware-based architecture (three tier) - To relieve server and client of routing functionality etc., a middle tier is created. This tier can, for example, examine each db query and route it to the appropriate server. When results are retrieved from several servers, the middle tier can consolidate results and send them to the requesting client. Hope this helps, Ash ------------------------------------------------------------ Message no. 5984[Branch from no. 5977] Posted by Imran Pathan (ipathan) on Tuesday, January 24, 2006 1:59pm Subject: Re: database server confusion? Hi waseem, I found some information which you can add to Ashwini's, Besides the two tier and three tier I would like to add some more things to it like Three tier architecture with transaction processing monitor technology: The TP monitor technology is a type of message queuing, transaction scheduling, and prioritization service where the client connects to the TP monitor (middle tier) instead of the database server. Three tier with message server: Messaging is another way to implement three tier architectures. Messages are prioritized and processed asynchronously. Messages consist of headers that contain priority information, and the address and identification number. The message server connects to the relational DBMS and other data sources. Three tier with an application server: The three-tier application server architecture allocates the main body of an application to run on a shared host rather than in the user system interface client environment. ------------------------------------------------------------ Message no. 5990[Branch from no. 5977] Posted by Waseem Manzoor (wmanzoor) on Tuesday, January 24, 2006 3:30pm Subject: Re: database server confusion? Krishnamurth and Imran, I think I could not convey my question to you guyz properly. I was asking either database server apllied only in the client/server architechture or in others too means(Hierarchical, Network, Relational architechtures) Waseem ------------------------------------------------------------ Message no. 5992[Branch from no. 5990] Posted by Krishnamurth Ashwini (kashwini) on Tuesday, January 24, 2006 5:36pm Subject: Re: database server confusion? Waseem, Your Question: I was asking either database server apllied only in the client/server architechture or in others too means(Hierarchical, Network, Relational architechtures) My Answer: Well, Database is a completely new concept to me too. As far as I have read and understood, this is what I think..I hope I am not confusing you. First of all, Hierarchical, Network and Relational are three different types of 'Data Models' (logical). A data model typically represents the data requirements of an organization. You can diagrammatically show a data model with symbols and figures. Data for an organization resides in a database. Therefore, when designing a database, you first creat a data model (Just like a logical sketch).The model would represent the real-world data requirements (whether the data would be hierarchically organized - by department for example; whether fragments of data would be interconnected to provide the full functionality etc...). It would show the arrangement of data structures. On the other hand, since the building blocks, together with their arrangement, make up the overall architecture of the building...Similarly, there are lot of individual components that needs to be put together to make up an database architecture.You need .. 1.Specialized software to manage and make use of the data, 2.Hardware to store and process the data, 3.People 4.Procedures necessary to guide the storage, management and use of data. 5. Data repository,Data dictionary, DBMS Application interfaces, Users. etc... Likewise all these components together makes up the Database Architecture. The three options that I mentioned in my previous post "all involve a database server". Hierarchical, network and relational are all logical architecture variations while the three I have mentioned in my previous mail are physical architecture variations. All these models(logical models) can be implemented using the client server architecture . Just my 2 cents... If you think you have another answer for this question...please let me know. I would be more than happy to learn.:-) Ash ------------------------------------------------------------ Message no. 5993[Branch from no. 5992] Posted by Imran Pathan (ipathan) on Tuesday, January 24, 2006 5:42pm Subject: Re: database server confusion? Hi Ash, Thanx for sharing the point that Hierarchical, network and relational are all logical architecture variations while Two tier and the three tier architectures are physical architectural variations. Imran ------------------------------------------------------------ Message no. 5995[Branch from no. 5993] Posted by Muhammad Latif (mlatif) on Tuesday, January 24, 2006 6:12pm Subject: Re: database server confusion? Hello Waseem, Database server is always client/server architecture. However, I think Ash is right, because client/server can be broken into different architectures which are two tier and three tier. You can implement different types of data models on the database server e.g. hierarchical, relational, etc. I hope this helps. Arsal ------------------------------------------------------------ Message no. 5996[Branch from no. 5977] Posted by Venkat Munagala (vrmunagala) on Tuesday, January 24, 2006 8:38pm Subject: Re: database server confusion? Hi Waseem, What Ash and Arsal said is correct. Client/server architecture is further divided into Heirarchical,network and relational architectures.All these are not different and but they are from the same architecture.Client/server architecture is further divided into two tier and three tier models. ------------------------------------------------------------ Message no. 5997[Branch from no. 5990] Posted by Bikash Adhikari (badhikari) on Tuesday, January 24, 2006 10:35pm Subject: Re: database server confusion? Hi Waseem, I know that the data base server, requires at least one server to run the application. So the client/server architecture, consisting of a server and one or more clients can support the database server. I regards to the Hierarchical, Network, Relational architectures, even being different type of network design, they can be characterised as a client/server if designed accordingly to the requirement of the database system. So i do think that database server can be incorporated within these architecture. Thank you for your time. BIkash ------------------------------------------------------------ Message no. 5998[Branch from no. 5977] Posted by Antoinette Lockett (arlockett) on Wednesday, January 25, 2006 2:12am Subject: Re: database server confusion? Waseem, Client/Server components of an application execute on different computers, that communicate with each across the network. The architecutes of a databases server that support client connections are : 1. Dedicated Servers: In a dedicated server, Oracle starts a dedicated foreground server thread for each client that connects to the instance. 2. Multithreaded Server: A multithreaded server configuration is a small collection of server-side threads that, together, can efficiently support larger user population. I hope this helps Antoinette Lockett ------------------------------------------------------------ Message no. 6003[Branch from no. 5977] Posted by Phanindra Maddhi (pmaddhi) on Wednesday, January 25, 2006 8:37am Subject: Re: database server confusion? hi waseem Database server are used in different fields, Client/server architecture model is one field in it, There are many other models like 3-tire and n-tire models ------------------------------------------------------------ Message no. 6004[Branch from no. 5998] Posted by Phanindra Maddhi (pmaddhi) on Wednesday, January 25, 2006 8:47am Subject: Re: database server confusion? hi friends can we discuss the following trems What is Client-server Computing? What is a Client Process? What is a Server Process? What is a Two-Tier Architecture? What is a Three-Tier Architecture? What is Middleware? What is Cooperative Processing? What is Distributed Processing? What is an "Intranet"? I will post my answers next day....... ------------------------------------------------------------ Message no. 6005[Branch from no. 5977] Posted by Phanindra Maddhi (pmaddhi) on Wednesday, January 25, 2006 8:49am Subject: Re: database server confusion? The basic characteristics of client/server architectures are: 1) combination of a client or front-end portion that interacts with the user, and a server or back-end portion that interacts with the shared resource. The client process contains solution-specific logic and provides the interface between the user and the rest of the application system. The server process acts as a software engine that manages shared resources such as databases, printers, modems, or high powered processors. 2) the front-end task and back-end task have fundamentally different requirements for computing resources such as processor speeds, memory, disk speeds and capacities, and input/output devices. 3) the environment is typically heterogeneous and multivendor. The hardware platform and operating system of client and server are not usually the same.Client and server processes communicate through a well-defined set of standard application program interfaces (API's) and RPC's. 4) An important characteristic of client-server systems is scalability. They can be scaled horizontally or vertically. Horizontal scaling means adding or removing client workstations with only a slight performance impact. Vertical scaling means migrating to a larger and faster server machine or multiservers. ------------------------------------------------------------ Message no. 6008[Branch from no. 6004] Posted by Krishnamurth Ashwini (kashwini) on Wednesday, January 25, 2006 9:24am Subject: Re: database server confusion? Hi Phanindra, You can always refer to wikipedia.com for "definitions"....I really like them. Ash ------------------------------------------------------------ Message no. 6009[Branch from no. 6005] Posted by Rohini Shrestha (rshrestha) on Wednesday, January 25, 2006 10:28am Subject: Re: database server confusion? Hi Phanindra, One of the other charactersistics of client/server database is data recovery. The front- end i.e client can always use different application to manage database whereas the back- end i.e server can remain as a power backup for all data. And if something goes wrong we can always recover it. Thankx for sharing all other characteristics. Rohini ------------------------------------------------------------ Message no. 6010[Branch from no. 6009] Posted by Muhammad Latif (mlatif) on Wednesday, January 25, 2006 12:04pm Subject: Re: database server confusion? Phanindra, Regarding your questions, if you are looking for definitions or explanation of the terms, I can recommend a good website: http://www.webopedia.com/ If you are looking for some specific problem in any of the architectures or models, you can ask and we all would be glad to respond. Arsal ------------------------------------------------------------ Message no. 6015[Branch from no. 5977] Posted by Swarna Bangaru (sbangaru) on Wednesday, January 25, 2006 1:12pm Subject: Re: database server confusion? Hi waseem, I am not so sure what you are expecting but, According to a Oracle text Book that I refered to, databse(Oracle)server supports the following configurations: Host Based:- Users are connected directly to same computer on which database resides. Client/server:- Users access the database from their personal computer (Client) via a network, and the database sits on a separate computer (server). Distributed Processing:- Users access a database that resides on more than one computer. The database is spread across more than one machine and the users are unaware of the physical location of data they work with. Hope this Helps ------------------------------------------------------------ Message no. 6017[Branch from no. 5990] Posted by Gnaneshwar Bukka (gbukka) on Wednesday, January 25, 2006 7:29pm Subject: Re: database server confusion? Hey waseem...there is nothing to get confused......the very word database means...data storage...this is done on a head system.....database is chosen for client/server archi...thats abvious coz......data is supposed to be shared......hierarchical systems are nothing but different levels of systems with the master(server) on top......so this forms a client/server archi too.....logical......when you want to use database for networks you have to use client server architecture(if your concerned about storage and redundancy).....if not the data will not be shared, so there wouldnt be a point in maintaing a network........this is what I thought...guys let me know if I made any blunders!!!!........hey waseem if I confused you more.....then am sorry....shall try to clear it next time.......thks Regards, Gnaneshwar Bukka. ------------------------------------------------------------ Message no. 6019[Branch from no. 5977] Posted by Rohini Shrestha (rshrestha) on Wednesday, January 25, 2006 8:33pm Subject: Re: database server confusion? Hi Waseem As my understanding server is a workstation which shares its resources with other workstations. The server is used in all those models which follow client/server database management system. But for personal database managment system, you will not need a different workstation to store data. In stead of database server you can make file server in the same computer and work both as client and as server. I believe all architectures described here falls into client/server database management. Hope it will help you. and correct me if I am wrong Thank you Rohini ------------------------------------------------------------ Message no. 6022[Branch from no. 5983] Posted by Gwendolyn Mobley (gdmobley) on Thursday, January 26, 2006 12:31am Subject: Re: database server confusion? Ash, there is also the multidimentional model or the cube which is used for strategic forecasting and stat analysis. Gwen ------------------------------------------------------------ Message no. 6023[Branch from no. 6015] Posted by Gwendolyn Mobley (gdmobley) on Thursday, January 26, 2006 12:46am Subject: Re: database server confusion? Swama, great, clear descriptions..........thanks. Gwen ------------------------------------------------------------ Message no. 6025 Posted by Gwendolyn Mobley (gdmobley) on Thursday, January 26, 2006 12:55am Subject: SDS are secondary database servers the same as mirrored servers? Are we talking about a physically different server or just a partition? Gwen ------------------------------------------------------------ Message no. 6026[Branch from no. 6022] Posted by Krishnamurth Ashwini (kashwini) on Thursday, January 26, 2006 12:58am Subject: Re: database server confusion? Gwen, Thanks for the info. Ash ------------------------------------------------------------ Message no. 6029[Branch from no. 6025] Posted by Krishnamurth Ashwini (kashwini) on Thursday, January 26, 2006 1:18am Subject: Re: SDS Gwen, I found these definitions in wikipedia.. A Secondary Database Server or SDS is a database server that is kept in synchronisation with the main database so that if the main database goes offline, the secondary database server can be used instead. A Mirrored Server contains two versions of the same data. Mirroring can occur locally or remotely. Locally means that a server has a second hard drive that stores data. A remote mirror means that a remote server contains an exact duplicate of the data. The second drive is called a mirrored drive. Also I assume ... Secondary server is not used unless the primary server goes down. It is primarily used for redundancy purposes(back-up). Whereas...mirrored servers are used to balance the network traffic load. Let me know if I am wrong.. Ash ------------------------------------------------------------ Message no. 6030[Branch from no. 6029] Posted by Harold Harris (hjharris2) on Thursday, January 26, 2006 3:27am Subject: Re: SDS To add to what Ash wrote mirrored hard drives are commonly set up as a Redundant Arrays of Inexpensive Disks (RAID). RAID architectures range in number from 1 to 5. RAID 1 requires at least 2 drives and provides pretty good fault tolerance. RAID 5 is the most common architecture for multi-user server environments. HH ------------------------------------------------------------ Message no. 6032[Branch from no. 6030] Posted by Rohini Shrestha (rshrestha) on Thursday, January 26, 2006 9:47am Subject: Re: SDS One of the other use of secondary database server is to achieve a degree of load balancing when you use data replication. Some client applications can use the secondary database server in a data-replication pair for this purpose. The design of all client applications that use the secondary database server has to keep following points in mind: -Any SQL statements that attempt to modify data fail. -Locking and isolation levels are not the same as on the standard database server. - Temporary dbspaces must be used for sorting and temporary tables. Secondary database is a read-only database, however, it sometime does write in order to sort or create temproray tables. Database mirroring in Server helps you to keep a copy, or mirror, of a database in primary server. This ensures that two separate copies of the data exist at all times, providing high availability and complete data redundancy. It also increases database availability by allowing you to maintain a hot standby server that contains a copy, or mirror database, of the production database, called the principal database. If the principal database on the production server fails, the partner server can promote its database from mirror to principal. As changes occur in the principal database, the transaction log is immediately sent to the mirrored database and rolled forward to keep the two databases synchronized. Mirroring is implemented per database. Both mirrored and non-mirrored databases can coexist on the same server. The partner servers containing the principal and mirror databases ideally should reside on two different computers. Hope it helps. Rohini ------------------------------------------------------------ Message no. 6033[Branch from no. 6025] Posted by Venkat Munagala (vrmunagala) on Thursday, January 26, 2006 11:11am Subject: Re: SDS To achieve a degree of load balancing when we use data replication, some client applications use the secondary database server in a data-replication pair. Design all client applications that use the secondary database server with the following points in mind: •Any SQL statements that attempt to modify data fail. •Locking and isolation levels are not the same as on the standard database server. •Temporary dbspaces must be used for sorting and temporary tables. In database mirroring, an originating server continuously sends a database's transaction log records to a copy of the database. The originating database and server have the role of principal, and the receiving database and server have the role of mirror. The principal and mirror servers are each considered partners in the database mirroring session. A database mirroring session consists of a relationship between the partner servers when they mirror a database from one partner to another. A given partner server may have the principal role for one database and a mirror role for a different database. Rohit ------------------------------------------------------------ Message no. 6035[Branch from no. 6025] Posted by Bikash Adhikari (badhikari) on Thursday, January 26, 2006 4:26pm Subject: Re: SDS

Hi Gwen,

The question to whether the secondary database server is as same as the mirrored servers, i have found an IBM literature that combines the secondary and the primary server in a HDR (High-Availability Data Replication) pair and compairs it to a mirrored server. And as far i understood they both represent two different servers.

Clients use Secondary server only to read data but do not allow updates from client applications.
Whereas Mirror server maintains a copy of a specific dbspace on a separate disk. This mechanism protects the data in mirrored dbspaces against disk failure because the database server automatically updates data on both disks and automatically uses the other disk if one of the dbspaces fails.

The article also talks about the Advantages of Data Replication as so many of our friend have discussed, as follows:


# Clients at the site to which the data is replicated experience improved performance because those clients can access data locally rather than connecting to a remote database server over a network.

# Clients at all sites experience improved availability of replicated data. If the local copy of the replicated data is unavailable, clients can still access the remote copy of the data.

Hope this would be help to you. Thank you for your time.

BIkash

Reference: http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.admin.doc/admin622.htm

------------------------------------------------------------ Message no. 6036[Branch from no. 6004] Posted by Alex Auffenorde (aaauffenorde) on Thursday, January 26, 2006 4:27pm Subject: Re: Phanindra Maddhi's Question I will take one of the many questions you posed. "What is an Intranet" An intranet is a private network. It functions just like the internet but is created, owned, and operated by an organization or company. Intranets only allow those who have permission, that is work for the company and have user names and passwords, to gain access. They can have firewalls that are put in place so that users can only visit certain internet sites or have access to certain resources on the network, i.e. printers, other computers, databases, certian files or file types. Look at the prefixes "Intra" meaning within and "Inter" meaning between. Intranets - within corporations and Internet - between everyone. Hope this helps, Alex Auffenorde ------------------------------------------------------------ Message no. 6038 Posted by Alex Auffenorde (aaauffenorde) on Thursday, January 26, 2006 4:50pm Subject: Is it a database server or a DBMS?? Hi all, In reading your posts, I feel that some people may be confusing the DBMS functions with functions that the database server has. There were many posts the said a database server was a "database application" or "database program." A server is a computer, not a program. I interpretted the question: "What is a database server?” and “What are its roles?" as thinking that the database server and its roles should only pertain to the hardware of the server. Not to pick on anyone, but Rohini posted that a database server is defined: “server can be defined as a back-end component of a database configured to run different database software and database management techniques.” She goes on to say the roles of DBMS, that is, grants access to users, updates and deletes records.” Again, not to pick on you Rohini, but I saw a few posts this way and wanted to ask the class what they thought. When talking about a database server I think that we should talk about its capabilities and function that pertain to the hardware of the server, not the software installed on it. Alex Auffenorde ------------------------------------------------------------ Message no. 6039[Branch from no. 6038] Posted by Bikash Adhikari (badhikari) on Thursday, January 26, 2006 5:42pm Subject: Re: Is it a database server or a DBMS??

Alex,

In reference to my discussion, I have put that Data management systems are the software programs that help manage database resources where as Database servers mainly refer to the computer that is specified or dedicated in running the database services.

So yes i do think that database server imply the hardware that may help reside the DBMS or the software to manage the database.

BIkash

------------------------------------------------------------ Message no. 6040[Branch from no. 6029] Posted by Gwendolyn Mobley (gdmobley) on Thursday, January 26, 2006 8:29pm Subject: Re: SDS Ash, yes you are correct with this...thanks. Gwen ------------------------------------------------------------ Message no. 6041[Branch from no. 6032] Posted by Gwendolyn Mobley (gdmobley) on Thursday, January 26, 2006 8:30pm Subject: Re: SDS Rohini, thanks for the info...it helps. Gwen ------------------------------------------------------------ Message no. 6042[Branch from no. 6035] Posted by Gwendolyn Mobley (gdmobley) on Thursday, January 26, 2006 8:33pm Subject: Re: SDS Bikash, thanks for the information and the url. This information will help in customer discussions, pro's vs con's on these 2 different approaches. I appreciate all the help and information, Gwen ------------------------------------------------------------ Message no. 6043[Branch from no. 6030] Posted by Gwendolyn Mobley (gdmobley) on Thursday, January 26, 2006 8:37pm Subject: Re: SDS Harold, many thanks for the info. Gwen ------------------------------------------------------------ Message no. 6044[Branch from no. 6040] Posted by Krishnamurth Ashwini (kashwini) on Thursday, January 26, 2006 8:43pm Subject: Re: SDS Gwen, You are most welcome:-)...By the way, are you taking any other course this semester? Ash ------------------------------------------------------------ Message no. 6046 Posted by Sagun Piya (srpiya2) on Thursday, January 26, 2006 10:10pm Subject: which version to install Guys, I am planning to install oracle 10g Release 1 (10.1.0.2) for my laptop. Will oracle 10g work for Windows XP Media Center Edition. If I Install Oracle 10g, Will I face any problem while using command because I have to refer for Oracle 9i book. Will oracle 9i book help for oracle 10g edition. Hope to hear from u guys. Sagun ------------------------------------------------------------ Message no. 6047[Branch from no. 6046] Posted by Krishnamurth Ashwini (kashwini) on Thursday, January 26, 2006 10:53pm Subject: Re: which version to install Sagun, Mine is a Windows XP professional Edition. I successfully installed Oracle10g on my Laptop. Since yours is a Media Center edition, you shouldn't have any problem installing it. You can refer to the Oracle9i text book and still work on Oracle10g. There are no much changes. Ash ------------------------------------------------------------ Message no. 6048[Branch from no. 6046] Posted by Waseem Manzoor (wmanzoor) on Friday, January 27, 2006 12:20am Subject: Re: which version to install Hi Sagun, I do not think it should be any problem to install oracle 10g on your mentioned windows. For Installation help, all the help is available on the net on oracle,s site. our book will not help regarding installation of 10g version because it is different from 9i. All queries runs the same way whatever version you will use because the SQL syntex is same. Waseem Manzoor ------------------------------------------------------------ Message no. 6049[Branch from no. 6038] Posted by Rohini Shrestha (rshrestha) on Friday, January 27, 2006 12:21am Subject: Re: Is it a database server or a DBMS?? Wow!!!!....I am amazed to see my name, Alex. Rohini ------------------------------------------------------------ Message no. 6050[Branch from no. 6047] Posted by Rohini Shrestha (rshrestha) on Friday, January 27, 2006 12:24am Subject: Re: which version to install Sagun, I, too, install 10g in my laptop. I have Windows XP Home edition and it works. Rohini ------------------------------------------------------------ Message no. 6051[Branch from no. 6047] Posted by Muhammad Latif (mlatif) on Friday, January 27, 2006 12:25am Subject: Re: which version to install Hi Sagun, There is Oracle 10g for Windows XP and it does not matter which version, you should have no problem! However, please check your specifications such as memory, processor, hard drive, etc. It might cause a problem later on such as slow speed. Best of luck. Arsal ------------------------------------------------------------ Message no. 6052[Branch from no. 6019] Posted by Muhammad Latif (mlatif) on Friday, January 27, 2006 12:32am Subject: Re: database server confusion? Swarna, Good answer. That clears Waseem's question. Arsal ------------------------------------------------------------ Message no. 6053[Branch from no. 6051] Posted by Rohini Shrestha (rshrestha) on Friday, January 27, 2006 12:33am Subject: Re: which version to install Sagun, As Arsal has mentioned, you should check memory and processor otherwise your laptop will be useless. I have got 1.86/512 bit still it is too slow.... Rohini ------------------------------------------------------------ Message no. 6054[Branch from no. 6038] Posted by Waseem Manzoor (wmanzoor) on Friday, January 27, 2006 1:32am Subject: Re: Is it a database server or a DBMS?? Hi ALex You are right, it is just a computer means it is a hardware not software, it is a computer which is dedicated to run this type of program. Waseem ------------------------------------------------------------ Message no. 6055[Branch from no. 6032] Posted by Harold Harris (hjharris2) on Friday, January 27, 2006 3:46am Subject: Re: SDS I might add to what Rohini said by adding that the two different servers may also be located in two different geographical locations via VPNs. HH ------------------------------------------------------------ Message no. 6056[Branch from no. 6036] Posted by Harold Harris (hjharris2) on Friday, January 27, 2006 4:11am Subject: Re: Phanindra Maddhi's Question To add to Alex's reply Intranets can also use private IP addresses for use within their network. These addresses are behind the firewall and are invisible to the outside. When internet access is required organizations may use Network Address Translation (NAT) to issue the user an external IP address for use on the internet. HH ------------------------------------------------------------ Message no. 6057[Branch from no. 6046] Posted by Bikash Adhikari (badhikari) on Friday, January 27, 2006 11:03am Subject: Re: which version to install Sagun, I have installed 10g version too, though my laptop has quite slowed down but the software works fine. BIkash ------------------------------------------------------------ Message no. 6058[Branch from no. 6046] Posted by Gnaneshwar Bukka (gbukka) on Friday, January 27, 2006 11:53am Subject: Re: which version to install Hi sagun, As Dr. liu said it doest matter which ever version you install, better to install the one which matches your configuration.....have fun....byee Gnaneshwar Bukka. ------------------------------------------------------------ Message no. 6059[Branch from no. 6046] Posted by Krupa Kandavalli (kkandavalli) on Friday, January 27, 2006 12:06pm Subject: Re: which version to install Hi Sagun, Oracle installed on media center edition should work fine, I have installed Oracle10g on XP pro and dint have any problems, and regarding the slow down it'll will depend on your system configuration. regarding Oracle10g,I dont think its entirely different from Oracle9i. Praneeth ------------------------------------------------------------ Message no. 6061[Branch from no. 6042] Posted by Bikash Adhikari (badhikari) on Friday, January 27, 2006 12:58pm Subject: Re: SDS It was my pleasure.... Thank you. BIkash ------------------------------------------------------------ Message no. 6062[Branch from no. 6038] Posted by Swarna Bangaru (sbangaru) on Friday, January 27, 2006 1:25pm Subject: Re: Is it a database server or a DBMS??

Hi All, A server is a computer or device on a network that manages network resources. for example a network srever is a computer that manages network traffic, print server is acomputer that manages one or more printers.

A Database server is a computer system (Computer system includes the computer, the software on the computer necessary to make the computer work) that processes database queries.

Servers are often dedicated to perform no other taskes besides their server tasks, however in some multiprocessing operating systems, a single computer can excecute several programs at once, in this case the server is refered to the particular program that is managing resources rather than the entire computer.

Swarna.

------------------------------------------------------------ Message no. 6069[Branch from no. 5977] Posted by Sagun Piya (srpiya2) on Saturday, January 28, 2006 2:45am Subject: Re: database server confusion? hey waseem, As far as I know, Data base server is used in Client server architectural design. Sagun ------------------------------------------------------------ Message no. 6071[Branch from no. 6004] Posted by Kelli Lemon (kmlemon) on Saturday, January 28, 2006 3:06am Subject: Re: database server confusion? I have never heard of the term middleware so i decided to look it up.

Middleware as defined by webopedia is:

Software that connects two otherwise separate applications. For example, there are a number of middleware products that link a database system to a Web server. This allows users to request data from the database using forms displayed on a Web browser, and it enables the Web server to return dynamic Web pages based on the user's requests and profile.

The term middleware is used to describe separate products that serve as the glue between two applications. It is, therefore, distinct from import and export features that may be built into one of the applications. Middleware is sometimes called plumbing because it connects two sides of an application and passes data between them. Common middleware categories include:

------------------------------------------------------------ Message no. 6073[Branch from no. 6033] Posted by Imran Pathan (ipathan) on Saturday, January 28, 2006 6:19am Subject: Re: SDS Thank you for the information Imran ------------------------------------------------------------ Message no. 6074[Branch from no. 6046] Posted by Imran Pathan (ipathan) on Saturday, January 28, 2006 6:22am Subject: Re: which version to install Hi sagun, I have a laptop too and I too installed oracle 10g without any problem.and also the oracle 9i book is good enough to work with Imran ------------------------------------------------------------ Message no. 6076[Branch from no. 6057] Posted by Harold Harris (hjharris2) on Saturday, January 28, 2006 10:39am Subject: Re: which version to install Sagun & BiKash, I installed version 10g on my desktop and laptop. As I mentioned before the laptop is a Celeron processor. Using Gwen's tweaking technique the laptop runs better than it did prior to the install. The laptop is actually 1.2 GHz 128 MB systems with a 20 gig hard drive. I increased the virtual memory from 192 min/384 max to 512 min/1024 max. This "dog" of a laptop just became a race horse. Oracle runs just fine on both systems. Thanks again Gwen. You just saved me about $2000. HH ------------------------------------------------------------ Message no. 6077 Posted by Alex Auffenorde (aaauffenorde) on Saturday, January 28, 2006 12:44pm Subject: A Joke Hope this is humor enough for us computer people. These pop-ups are being considered for the XP upgrade - 1. Enter any 11-digit prime number to continue. 2. Press any key to continue or any other key to quit. 3. Press any key except... no, No, NO, NOT THAT ONE! 4. Bad command or file name! Go stand in the corner. 5. This will end your Windows session. Do you want to play another game? 6. Windows message: "Error saving file! Format drive now? (Y/Y)" 7. This is a message from God Gates: "Rebooting the world. Please log off." 8. To "shut down" your system, type "WIN" 9. BREAKFAST.SYS halted... Cereal port not responding. 10. COFFEE.SYS missing... Insert cup in cup holder and press any key. 11. File not found. Should I fake it? (Y/N) 12. Runtime Error 6D at 417A:32CF: Incompetent User. 13. Error reading FAT record: Try the SKINNY one? (Y/N) 14. WinErr 16547: LPT1 not found. Use backup. (PENCIL & PAPER.SYS) 15. User Error: Replace user. 16. Windows VirusScan 1.0 - "Windows found: Remove it? (Y/N)" 17. Your hard drive has been scanned and all stolen software titles have been deleted. The police are on the way. ------------------------------------------------------------ Message no. 6078[Branch from no. 6044] Posted by Gwendolyn Mobley (gdmobley) on Saturday, January 28, 2006 3:18pm Subject: Re: SDS Ash, yep I have another course this semester. I have a really heavy travel schedule for the next 2-4 months, so both my classes are internet. Gwen ------------------------------------------------------------ Message no. 6079[Branch from no. 6076] Posted by Gwendolyn Mobley (gdmobley) on Saturday, January 28, 2006 3:24pm Subject: Re: which version to install Harold, you are so very welcome and I'm always glad to save anyone some money (smile). Another bit of info I found from Oracle's tips, defrag the machine (if you haven't done this in a while). I performed a defrag on my laptop and wonders upon wonders, it processes faster. Just an FYI. As I locate more tips I'll pass them along. Gwen ------------------------------------------------------------ Message no. 6083[Branch from no. 6077] Posted by Gnaneshwar Bukka (gbukka) on Saturday, January 28, 2006 6:01pm Subject: Re: A Joke Hey Alex.....VERY good one.....gud humor.....keep sending such one's...take care...bye. Gnaneshwar Bukka. ------------------------------------------------------------ Message no. 6098[Branch from no. 6079] Posted by Harold Harris (hjharris2) on Monday, January 30, 2006 6:35am Subject: Re: which version to install Thanks Gwen, I'll defrag my hard drive immediately. :-) HH ------------------------------------------------------------ Message no. 7372[Branch from no. 6069] Posted by Abhash Bhandary (abhandary) on Tuesday, April 11, 2006 6:45pm Subject: Re: database server confusion? I think you guys have come up with the perfect awswer to Waseem's question......I too think that we surely need the client/server for any database to work properly...the server is a must to store the database...the other networks can work as well if it just has a server where we can store the database and share with the others. Abhash ------------------------------------------------------------ Message no. 7373[Branch from no. 6061] Posted by Abhash Bhandary (abhandary) on Tuesday, April 11, 2006 7:52pm Subject: Re: SDS Thankyou everyone for this great information...i didnt have much information either about the mirrored and secondary database servers....i have now gained so much information about it. Abhash ------------------------------------------------------------ Message no. 7374[Branch from no. 6083] Posted by Abhash Bhandary (abhandary) on Tuesday, April 11, 2006 7:55pm Subject: Re: A Joke good one Alex Abhash ------------------------------------------------------------ Message no. 7375[Branch from no. 6074] Posted by Abhash Bhandary (abhandary) on Tuesday, April 11, 2006 7:57pm Subject: Re: which version to install I have the same XP media edition from Dell, and i am having no problem with the 10i , so i thik you should be fine. Abhash ------------------------------------------------------------