2. Reduce data redundancy to improve data consistency and completeness.
3. Provide data and application independence, thus reducing the development and maintenance costs of applications.
What is the relationship between PDM technology and database technology? Product data management is based on database.
The basic database is the foundation of all data management.
Without him, everything is empty talk.
I'll tell you the difference between network technology, database technology and PC technology in my own words, and I won't post anything for you.
Network technology: generally speaking, it is the things needed for network implementation, such as network protocols, network equipment, software and other technical knowledge needed for network interoperability and normal implementation, which is a large scope.
Database technology: The main purpose is to effectively manage and access a large number of data resources. Database technology mainly studies how to store, use and manage data. A large part of it is used to manage data.
PC technology: It is also a big concept. Hardware, software, hardware, software, physical connection, network interconnection, etc. It is within the scope of PC technology for normal PC execution.
In fact, these three technologies are inseparable. If you want to learn, you will inevitably come into contact with the other two aspects of knowledge, but I will tell you the difference. If you want to know more, there is a lot of relevant knowledge on the internet, so just read more.
How to say database technology in English?
Database technology is abbreviated as data.
[Example] This paper briefly introduces the design idea and method of comprehensive test system software integrating modern database technology.
This paper introduces a new method of software design of comprehensive test system based on database technology.
Characteristics and advantages of developing database technology with Visual C# 1 What database should I look at first? If it is Microsoft's own sql server, it certainly has advantages.
In addition, you can ask whether it is easier or easier to develop a database programming tool. I think so. Platform.
Application and Development of Database Technology Database technology is an important part of modern information science and technology and the core of computer data processing and information management system. Database technology studies and solves the problems of effectively organizing and storing a large amount of data in the process of computer information processing, reducing the redundancy of data storage, realizing the enjoyment of data, ensuring the safety of data, and efficiently retrieving and processing data in the database system.
With the development of computer technology and network communication technology, database technology has become an important technical means and software technology to organize and manage a large amount of data in the information society, and it is the foundation of network information management system. This chapter mainly introduces the application and development of database technology, the basic concept of relational model and the design theory and method of relational database, which is the basis of learning and mastering modern database technology.
1. 1 Development and application of database technology
From the late 1960s to the present, database technology has developed for more than 30 years. In the course of more than 30 years, people have made brilliant achievements in the theoretical research and system development of database technology, and began to deeply study the new generation database system. Database system has become an important part of modern computer system.
1. 1. 1 database technology and IT
Information technology (IT) is one of the most frequently used terms nowadays. With the wide application of computer technology in industry, agriculture and daily life, it has been regarded by more and more individuals and enterprises as one of the signs to catch up with the world trend. Database technology is an important support of information technology. Without database technology, people will be at a loss in the vast information world.
Database technology is an important branch of computer science. Since the mid-1950s, computer applications have expanded from scientific research departments to enterprise management and * * * administrative departments, and people have higher and higher requirements for data processing. 1968, the world's first commercialized information management system IMS was born. Since then, database technology has developed rapidly. Today, with the increasing acceptance of the Internet, Inter has fully amplified the importance of database technology, knowledge and skills. Nowadays, database has become one of the main software tools for information management, office automation, computer-aided design and other applications, helping people to deal with all kinds of information.
Application and characteristics of 1. 1.2 database technology
Database was originally used as the basis for large-scale transaction processing by large companies or institutions. Later, with the popularity of personal computers, database technology was transplanted to PC for single-user personal database applications. Then, because the PC is networked in the workgroup, the database technology is transplanted to the workgroup level. Now, databases are widely used in the Internet and intranet.
In the mid-1960s, database technology was used to solve the problem of file processing system. At that time, the database processing technology was still very fragile, and it was often impossible to submit applications. The birth of relational model in 1970s provided a standard method for database experts to construct and process databases, and promoted the development and application of relational databases. 1979, Ashton-Tate company introduced the microcomputer product dBase, and called it the relational database management system. Since then, database technology has been transplanted to personal computers. From the mid-1980s to the late 1980s, end users began to use local area network technology to connect independent computers into a network, and terminals shared databases, thus forming a new multi-user data processing mode, called client/server database structure. Now, database technology is being combined with Internet technology to publish database data on intranet, departmental LAN and even the Internet.
1. 1.3 development history of database technology
Data model is the core and foundation of database technology. Therefore, the development and evolution of data model should be the main basis and symbol for the division of development stages of database system. From the evolution of data model, database technology has gone through three stages from the beginning to now: the first generation is a networked and hierarchical database system, the second generation is a relational database system, and the third generation is a database system with object-oriented data model as its main feature. The mutual penetration and organic combination of database technology, network communication technology, artificial intelligence technology, object-oriented programming technology and parallel computing technology has become an important feature of the development of contemporary database technology.
1. The first generation database system
The first generation database system is a hierarchical network database system developed in 1970s. The typical representative of hierarchical database system is the hierarchical database management system IMS developed by IBM in 1969. In the late 1960s and early 1970s, DBTG (Database Task Force), a subsidiary of Coda Syl (Data System Language Conference), put forward several reports, which were called DBTG reports. DBTG report defines and establishes many concepts, methods and technologies of grid database system, and is a typical representative of grid database system. Under the guidance of DBTG ideas and methods, the realization technology of database system has matured, and many commercial database systems have been developed, all of which are based on hierarchical model and network model.
It can be said that hierarchical database is the pioneer of database system, while mesh database is the founder of database concept, method and technology.
2. The second generation database system
The second generation database system is a relational database system. 1970 Edgar F. Codd, a researcher in San Jose Research Laboratory of IBM, published a paper entitled "Relational Model of Large Databases", put forward a relational data model, established relational database methods and relational database theories, and laid a theoretical foundation for relational database technology. Edgar F. Codd was awarded the ACM Turing Award in 198 1 in recognition of his outstanding contribution to the research of relational databases.
The 1970s was the era of theoretical research and prototype development of relational databases, with typical representatives being System R developed by IBM San Jose Research Laboratory and Ingres developed by Berkeley University. A large number of theoretical achievements and practical experience finally make relational database move from laboratory to society. Therefore, people called the 1970s the database age. In the 1980s, almost all newly developed systems were relational, among which many commercial relational database management systems with excellent performance appeared, such as DB2, Ingres, Oracle, Informix and Sybase. With the application of these commercial database systems, database technology is more and more widely used in enterprise management, information retrieval, decision-making and other aspects, and has become the basic technology to realize and optimize information systems.
3. The third generation database system
Since 1980s, the great commercial success of database technology has greatly increased the demand for database technology in other fields. These new fields have opened up a new world for the application of database, and put forward some new requirements for data management in the application, which has promoted the research and development of database technology.
1990, the high-level DBMS functional committee issued the declaration of the third generation database system, and put forward three basic characteristics that the third generation database management system should have:
L should support data management, object management and knowledge management.
L must maintain or inherit the technology of the second generation database system.
I have to be open to other systems.
Object-oriented data model is one of the main characteristics of the third generation database system; The organic combination of database technology and multidisciplinary technology is also an important feature of the third generation database technology. Distributed database, parallel database, engineering database, deductive database, knowledge base, multimedia database and fuzzy database are all examples.
1. 1.4 database system access technology
At present, the mainstream standard interfaces for accessing database servers mainly include ODBC, OLE DB and ADO. These three interfaces are briefly introduced below.
1. Open Database Connection (ODBC)
Open Database Connectivity (ODBC) is a database access standard defined by Microsoft. ODBC applications can not only access the data stored in the local computer desktop database, but also access the databases on heterogeneous platforms, such as those built by SQL Server, Oracle, Informix or DB2.
ODBC is an important application programming interface (API) for accessing databases. Based on standard SQL statements, the core of ODBC is SQL statements. Therefore, in order to access the database server through ODBC, the database server must support SQL statements.
ODBC calls a set of standard functions (ODBC API) to access the database, but programmers can easily develop client/server applications based on ODBC without knowing these ODBC APIs. This is because of many popular programming languages, such as Visual Basic, PowerBuilder and Visual C++. , provides a code layer that encapsulates various ODBC standard functions, and developers can directly use these standard functions.
ODBC has achieved great success and greatly simplified the development of some databases. However, it also has serious shortcomings, so Microsoft developed OLE DB.
2.OLE DB
OLE DB is a database system-level programming interface provided by Microsoft, and it is the basis of Microsoft's database access. OLE DB is actually an implementation of Microsoft OLE object standard. The OLE DB object itself is a COM (Component Object Model) object and supports all necessary interfaces of the object.
Generally speaking, OLE DB provides two ways to access the database: one is to access the database server supporting SQL language through ODBC driver; The other is to access the interface directly through the original OLE DB. Because ODBC is only suitable for databases that support SQL language, its application scope is too narrow. At present, Microsoft is gradually replacing ODBC with OLE DB.
Because OLE DB is an object-oriented interface, it is especially suitable for object-oriented languages. However, many database application developers use scripting languages such as VBScript and JScript to develop programs, so Microsoft defines ADO based on OLE DB objects.
3. Dynamic Data Object (ADO)
Active Data Object (ADO) is a simple object model, which can be used by developers to process any OLE DB data and can be called by scripting languages or high-level languages. ADO provides an application-level programming interface for the database, and programmers who use almost any language can use the functions of OLE DB by using ADO. Microsoft claims that ADO will replace other data access methods, so ADO is very important for any database application that uses Microsoft products.
1. 1.5 programming technology of network database system
In today's era of Internet prevalence, the combination of database and Web technology is profoundly changing network applications. With the support of database, it will be easy to expand the function of packaging web pages, design interactive pages, build a powerful background management system, update websites and maintain websites. With the deepening of network application, Web database technology will show its important position more and more. The following briefly introduces the related technologies of Web database development.
1. Universal Gateway Interface Programming
Universal Gateway Interface (CGI) is a communication standard. Its task is to accept the client's request, identify and process it, generate an HTML file and retransmit it to the client. The programming of this communication process is called CGI programming. CGI can be executed on various platforms, with powerful functions, and can be programmed in various languages, such as Visual Basic, Visual C++, Tcl, Perl, AppletScript, etc. And CGI programs written in Perl language are more common. But CGI also has its fatal weakness, which is slow speed and poor security.
2. Dynamic Server Page (ASP)
Active Server Pages (ASP) is a technology introduced by Microsoft to replace CGI, and it is a truly simple and powerful server programming technology. ASP is actually a server-side script execution environment developed by Microsoft, through which dynamic, interactive and efficient Web server applications can be established. Programs written in ASP are all executed on the server side. After the program is executed, the execution result is returned to the client browser, which not only reduces the burden of the client browser, but also greatly improves the interaction speed, and also avoids the leakage of ASP program source code and improves the security of the program.
3.Java server page (JSP)
Java Server Pages (JSP) is a Web application development technology released by Sun Company. Once launched, it has aroused widespread concern. JSP technology provides a unique development environment for building highly dynamic Web applications, which can be applied to most server products in the market.
JSP uses Java language to write server-side programs. When the client sends a request to the server, the JSP source program is compiled into a Servlet and executed by the Java virtual machine. This compilation operation only happens when the JSP page is requested for the first time. Therefore, JSP programs can provide faster interaction speed and excellent security and cross-platform performance.
How to learn reading and self-study through database technology? Understand your goals first, and then read relevant books selectively to cooperate with actual combat:
Understand the history of the database;
Understand the type of database;
Reading, actual combat;
How this thing was drawn in a few words is not clear. I suggest you buy a book on database basics, or study directly at Baidu.
Realizing the connection between database technology and other technologies will be a development trend of database technology.
Database technology information management: what do you want?