ENTERPRISE DATABASE SYSTEMS Enterprise software- A suite of applications generally used by a large nos. of users and which handles millions of records. Distributed application – An application which is divided into parts that reside and executes on different PCseven if those are in separate locations is called distributed application. The word tire is used to describe distributed applications. Two tier application- If the job of managing a database is between two PCs, then the application is two tier application. Similarly three tier to n-tier applications. Electronic Document Management (EDM) – An enterprise software used in various large scale multiuser environment likefactories, hospitals etc. Connected architecture: In connected model we can connect any application to database and stays connected to the database system even when it is not using any database operations. For this architecture, we use Connection, Command and DataReader. Disconnected architecture: In disconnected model we connect any application to database until we call the close method. In this architecture we use DataSet and DataAdapter Knowledge Discovery - Knowledge discovery is the science of finding patterns within sets of data. This data can consist of anything from boolean values (did he go left? did he go right?), sports scores, web visit statistics, laboratory analyses, or other scientific measurement. By itself data is simply measurement transformed into numbers and statistics, but inherent in the data is a lot of knowledge that can be put to good use. Also known as data mining, knowledge discovery has enjoyed great success in many lucrative fields, including:
Government surveillance Customer relationship management Digital mapping Medical risk assessment Market analysis Educational research
Depending on how large the data field is, knowledge discovery can require an automated program or not. The largest data field out there in this day and age, and certainly the most mineable for knowledge is the Internet. Data Mining - Data Mining is an analytic process designed to explore data (usually large amounts of data typically business or market related - also known as "big data") in search of consistent patterns and/or systematic relationships between variables, and then to validate the findings by applying the detected patterns to new subsets of data. The ultimate goal of data mining is prediction - and predictive data mining is the most common type of data mining and one that has the most direct business applications. The process of data mining consists of three stages: (1) the initial exploration, (2) model building or pattern identification with validation/verification, and (3) deployment (i.e., the application of the model to new data in order to generate predictions).
Top RDBMS Enterprise E softwares : 1. Oracle O RDBM MS Oraccle Enterprisse Server, deesigned for grid g computinng, is the best RDBMS, running on multiple m plaatforms, withh the latest versionn 12c, in whiich the "c" iss for cloud computing. c In the IT induustry, Oraclee has the unsshakeable markket share in database d fielld with big corporations, c , governmennt agencies, and a mission--critical data centers runnning on Oraccle database in the Real Application A Cluster (RA AC) environm ment. 2. IB BM DB2 DB22 is the databbase manageement system m that deliverrs a flexible and cost-efffective databbase platform m to build robuust on demannd business applications. a . The DB2 Universal U Daatabase (UDB B) Enterprisee Servver Edition (E ESE) is one of the best RDBMS. R IBM M positions DB2 as the database of choice for robust, enterpprise-wide solutions hanndling high-vvolume workkloads. and optimized o too delivver industry--leading perfformance whhile loweringg costs. DB22 is used by many m big inssuance comppanies, for example, e VS SP, the leadinng vision inssurance comppany, run itss entire businness on DB22. it is definittely secured in the seconnd position. 3. Microsoft M SQ QL Server Micrrosoft SQL Server S is a co omprehensivve database software plaatform providding enterrprise-class data d manageement and inntegrated bussiness intelliigence (BI) tools. t As the foundation f of Microsoft's comprehennsive data pllatform, SQL L Server deliivers breakthhrough perfoormance for misssion-critical applications a , using in-m memory technnologies, fasster insights from f any daata to any useer in familiarr toolss like Excel, and a resilieent platform for buildingg, deploying,, and managging solutionns that span on-premises o and cloud.. c 4. SA AP Sybase ASE A SAP P Adaptive Server Enterp prise (ASE), formerly Syybase, is a hiigh-performaance, missioon-critical databbase manageement system m that gives customers an a operationaal advantagee by loweringg costs and riskss. Sybase useed to be one of the big 3 database giaants (with Oracle O and DB B2) dominatting the dataabase field, but Sybase S lost its i momentum m overtime, and eventuaally was soldd out to SAP P really cheaap. Sybase daatabase was wideely used in banking b indu ustry. 5. Teeradata Teraadata databasse is often ussed by big reetailers and telecom t enteerprises. Teradata offers somee unique feaatures: the inttelligent opttimizer to proocess queriees and filter data d to efficciently respond to any request, applyying that query power to dynamic datta without addinng columns to your tablee to accept new n data. 6. MySQL M MyS SQL. an openn source dataabase, is thee most popular database for f web-baseed business appliications, andd is moving to t enterprisee level. MySQL is the most m popular database forr interrnet systems such as e-co ommerce andd dynamic website. w Manny of the world's largest and fasteest-growing organization o ns including Facebook, Google, G Adoobe, Alcatel Lucent L and Zappos Z rely on MySQL to save timee and moneyy powering thheir high-vollume Web siites, businesss-critical systems and packkaged softwaare. MySQL is now in Oracle's O handds but still maaintains its independence.
7. FiileMaker FileM Maker was thhe #1-selling g easy-to-use database software for Windows W annd Mac OS. However, onn the rise of Microsoft Access, A FileM Make has losst its compettitive edgee in the Winddows environ nment, whicch forced FilleMaker straategically buiild strenngth on the Mac M platform m. FileMakerr, Inc., is now w an Apple subsidiary, which w may secure FileM Maker's futu ure supportedd by the strenngth of Apple products. FileMaker Server S maxim mizes s datab bases while increasing seecurity. perfoormance of shared 8. Microsoft M Acccess Micrrosoft Accesss is the most used desktop database application in Windowss. Coming withh the Microsooft Office su uite, Access is i cheap andd accessible from f most Windows W laptoops and workkstations. Allthough mainnly considerred as a deskktop databasee, Access becoomes ever poopular databaase for internnet systems, - many e-coommerce andd content manaagement sysstems is pow wered by Acccess databasee running onn the Microsoft's IIS webb server platfform.
-----------------------