《数据库优化服务》由会员分享，可在线阅读，更多相关《数据库优化服务（6页珍藏版）》请在金锄头文库上搜索。
1、Database Systems Journal vol.I,no.2/2010 55Database Optimizing Services Adrian GHENCEA1,Immo GIEGER2 1University Titu Maiorescu Bucharest,Romania 2Bodenstedt-Wilhelmschule Peine,Deutschland Almost every organization has at its centre a database.The database provides support for conducting different
2、activities,whether it is production,sales and marketing or internal operations.Every day,a database is accessed for help in strategic decisions.The satisfaction therefore of such needs is entailed with a high quality security and availability.Those needs can be realised using a DBMS(Database Managem
3、ent System)which is,in fact,software for a database.Technically speaking,it is software which uses a standard method of cataloguing,recovery,and running different data queries.DBMS manages the input data,organizes it,and provides ways of modifying or extracting the data by its users or other program
4、s.Managing the database is an operation that requires periodical updates,optimizing and monitoring.Keywords:database,database management system(DBMS),indexing,optimizing,cost for optimized databases.Introduction The purpose of the document is to present representative notions about basic optimizing
5、for databases,using mathematical estimation for costs in different types of queries,a review of the level of attained performances,and the effects of different physical access structures in specific query examples.The target group should be familiar with SQL and basic concepts in relational database
6、s.This way,execution strategies for complex queries can be made,allowing the use of knowledge for obtaining information at a lower cost.A database goes through a series of transformations until its final use,starting with data modelling,database designing and development,and ending with its maintena
7、nce and optimization.2.Database modelling Data modelling The data model is more focused on the data that is required and the way in which those should be organised and less on the operations that will be made on the data.The data modelling stages involve the structure,the integrity,the manipulation
8、and the query.There are multiple assets regarding this,such as:1.Defining the way in which the data should be organised(hierarchical network,relational and object-focused).This provides a definition of rules that restrict what instances of the defined structure are allowed/premises.2.Offers a data u
9、pdating protocol.3.Offers a method for data queries.A simple structure of data communication which is easily understandable by the final user is the actual result of data modelling.Customized databases/Database developmentThe databases are developed and customized to answer the demands of the custom
10、er.The importance of custom databases is major because through them the commercialization of the products of services directly to the target customer becomes possible.The quality of a database is maintained through regular updates.1 名师资料总结-精品资料欢迎下载-名师精心整理-第 1 页，共 6 页 -56 Database Optimizing Services
11、Database designing If databases have any of the following problems:malfunction,insecure or inaccurate data or the database has degraded and lost its flexibility,then that is the moment for a new database.Therefore,the types of specific data and the storage mechanisms have to be defined in order to e
12、nsure the integrity of the data through rules and mechanisms of correctly applying the operational principles.All databases should be constructed in regard to the specifications of the customers,including its user interface and functionality.Using the data by including them into a website is possibl
13、e.Data mining Data mining is the science of extracting useful information from larger datasets and databases.Every organization wants its business and undergoing processes optimized for the best productivity.The business processes that require optimization include Customer Relationship Management(CR
14、M),Quality Control,Prices and Delivery System etc.Data Mining is a data exploiting discipline which underlines the errors in those processes,using sophisticated algorithms.Data Mining is done on processed data and includes the analysis and determination of the mistakes.Database Migration Database Mi
15、gration represents the transfer(or migration)of basic database schemes and data into the database management,such as Oracle,IBM DB2,MS-SQL Server,MySQL etc.There is a database migration system which allows the reliability and integrity of the data.The migration from one database platform can be diff
16、icult and time consuming because of the differences between the standards.However,quick migration of the data between different databases that ensures the integrity of the data is possible,without the loss of any data.Ensuring the access to the data and its protection is essential,especially when large quantities of data or important applications are being moved between systems.The security,availability and reliability of the data can be assured through providing experience in the projecting and
