KR20020003143A - B2Builder Automated Implementation/Intergration and S/W Maintenance of B2B System , Automated Processing of Various XML Document - Google Patents

Abstract

PURPOSE: A B2B solution automatic generation application using Java is provided to increase the convenience of a user by easily and rapidly constructing a development of an e-business system in order for enterprises to rapidly and conveniently construct a B2B system. CONSTITUTION: A program is automatically generated which is used in processing an XML(Extended Markup Language) document which is an essential part for executing an office automation in a field related to e-business. An interface with a related standard system and a related document are automatically generated. Therefore, businesses can deal with processing an electronic commerce document rapidly. The businesses rapidly and easily and construct a development of an e-business system in order to B2B system according that the businesses extend e-business through B2B solution automated generation application.

Description

B2Brender Automated Implementation / Intergration and S / W Maintenance of B2B System, Automated Processing of Various XML Document}

Currently, many companies in Korea are active in e-business. The characteristics of these firms have often expanded from 1997 to 2000, or emerged as start-ups. In other words, these companies emerged in support of the government's information and telecommunications industry development plan.

These firms are more likely to act as SI or web-content businesses or as vendors or educational institutes of overseas firms, rather than e-business.

Few companies have their own e-business products, and only a few of them have specialized solution brands in the XML / EDI field.

E-business companies have been involved in solutions based primarily on XML and JAVA, especially in the XML sector. In addition, the areas that companies want to specialize are divided into four categories: electronic publishing, DTD related, XML Editor Tool development, Mobile related, and EDI / EC related.

Among companies that are related to e-business and operate based on JAVA or XML, they tend to refocus on basic technologies such as XML Search Engine and XML DB development, and develop solutions that apply JAVA to automatic generation tools such as B2Builder. Only a few companies are willing or able to specialize.

Among the companies classified as application solution development, the most basic development in the already developed fields such as Connector, Integration Server, and Messaging Server was mainly focused on creative development rather than creative development. In this respect, the present invention is independent and the only development tool in the country.

In foreign countries, the e-business related industry that combines XML and Java is active. Although the US is led by the world, the domestic e-business-related IT industry is moving more actively with government encouragement than any other region.

However, even in foreign countries, few companies have developed their own application development tools. Messaging Server, all based on existing systems. The focus is on solutions such as Search Engine and Translator.

There is no company that develops the same technology as the present invention, which is an automatic e-business application generation tool. The company that has similar tools is Microsoft's Biztalk, but in the case of Biztalk, the application platform is Windows. It is limited to the operating system and does not automatically generate applications based on JAVA. Others, such as IBM, have tools that function similarly to the present invention, but the present invention is a more advanced form.

According to the present invention, the B2B solution (JAVA-based) automatic generation application using JAVA enables companies to quickly and easily build a B2B system according to the e-business expansion, and thus, system development can be built very easily and quickly. It was developed to simplify.

It aims to develop a program that automatically processes XML documents, interface with the standard system to be linked, and automatically generate related documents.

1 is a structural diagram showing a method of implementing the present invention.

2 is a system configuration diagram of the present invention

3 is a process for converting * .XSD, which is an INPUT XML Schema file, into * .XDB, which is a format of the present invention.

4 is a structural diagram showing a process of converting a Sample purchaseOrder.xsd file into an XDB file.

5 is a final source generation diagram of the present invention

As mentioned above, the program is developed to automatically generate the program for XML document processing, which is a key part for realizing the business automation in e-business related fields such as B2B and B2G, and to automatically generate the interface and related documents with the linked standard system. To aim.

In this way, it is possible to quickly cope with the processing of e-commerce documents in B2B, B2G, etc., and secure the competitiveness of e-business system development and operation by achieving excellent quality and innovative cost reduction.

<Reference Drawing 2>

As shown in Figure 2, the main functions of the present invention can be classified into four categories.

1) Parsing with XML Schema (Standard) document B2Builder's Format

2) Edit XML (B2Builder's Format) document

3) Create Java & Data Base Source

4) Other auxiliary functions

1) Parsing with XML Schema (Standard) document B2Builder's Format

This feature imports an XML Schema file into INPUT. XML Schema represents the structure of a document and is based on the W3C standard. Also, the content of XML Schema will conform to the ebXML standard. In other words, it can accept e-commerce standard documents defined by ebXML.

The input XML Schema document is converted into B2Builder's Format by B2Builder, and the format of the initial XML Schema document is changed, but there is no big change in the content. The converted document becomes the basic data of the process in the future. The XML Instance will be entered into the DataBase and vice versa.

The process so far is shown in <Figure 3>.

As shown in Figure 3, B2Builder converts * .XSD, an INPUT XML Schema file, to * .XDB, a B2Builder's Format. The important point here is that XSD file which is INPUT XML Schema is XML document format, and converted XDB file is XML document format.

The process of converting from XSD to XDB file is divided into two parts.

First, the initial XSD file is less readable and has a complicated structure, so it is easy to read and changes to a tree structure.

Second, the XSD file represents the document structure. The XSD file is changed according to the DataBase structure so that the document can be saved and retrieved. It adds and transforms elements necessary for RDBMS such as table name, primary key, field name and type required for DataBase.

〈Reference-Drawing 4〉

The above corresponds to 〈Figure-4〉 Translate structure diagram.

<Figure 4> is a structural diagram showing the process of converting Sample purchaseOrder.xsd file into XDB file.

As you can see from the figure, it is a way to arrange the initial coarse and complicated XSD file into Tree structure and add the contents of Table and Field necessary for RDBMS to this structure.

The initial XSD file is an object-oriented concept of XML. Each tag references or inherits another tag, so the document structure is distracted and complicated after parsing. Clean up these XSD files and delete unnecessary tags.

After that, XDB file is created by automatically processing table name, table relation, field name, filed type, field length, default value, null or not, primary key, foreign key, etc. necessary for RDBMS.

The converted XDB file is used as a basic data for generating Java and SQL statements with complete modification after further modification.

2) Edit XML (B2Builder's Format) document

After converting XSD file to XDB file above, each user can modify as they want. XDB file is also XML document type, so it is free to add and modify input after parsing. Like most editors, B2Builder provides an Editing GUI environment.

Edit work is classified as Node change, Node add, Node delete and the modified contents can be saved for later maintenance or source analysis. The documentation work done here is not as liberal or delicate as a specialized XML document editor, but it can be fully performed for future maintenance or analysis.

Auxiliary functions of B2Builder include SQL Manager, document-by-project progress, and other XML document viewers.

SQL Manager has a DATA Base management function that can connect to the DATA Base to perform table creation and record input inquiry and modification. There are management tools for each DATA Base, but the development process can be simplified by carrying out the project in one place.

Document management allows you to batch process documents you want to work on in one window. This also gives you the convenience of project processing and the convenience of processing multiple documents in one place.

XML document

Node Modification: Node modification can not change elements or attributes without restriction according to the basic concept of XML. You have no choice but to modify it to meet the W3C standard. Each Element and Attribute cannot be changed beyond the XML Schema basic Tag name or Attribute contents. The changed contents affect the schema of the database and the existing contents are changed to the modified contents of Node.

Node addition: Like Node modification, this cannot be departed from the standard, and is divided into element addition and attribute addition. You can also add a tree node that is a table. As with modifications, the entered node results in the creation of tables and fields.

Deleting Node: It is free to delete existing Node.

Document Storage: This allows you to save and re-apply and apply the content for later maintenance or system analysis.

In fact, the above means that the user can add or delete tables, change the characteristics of the field, or insert a new field.

3) Create Java & Data Base Source

After modifying and saving the XDB file, you can generate the source code immediately.

Occasionally, no modification is necessary. Source code is classified into Java Code and SQL statement. Java is divided into Enterprise Java Bean (EJB) and Java Bean. SQL statement is divided into Table Create and Stored Procedure.

If this is expressed in picture, it is like <Figure-5>.

In Figure 5, the final files created are * .java and * sql files. Java files are divided into EJB and Java Beans, of which EJB corresponds to Session Bean.

EJB consists of Session bean's Home object, Remote object, implementation Bean object, Table Item object, and Exception object. Here, one EJB is created for each table, which plays the role of component of Java Bean and EJB Client. EJB plays a role of querying record input, modification and deletion of each table.

Java Bean serves as a bridge between JSP (Java Server Page) or Servlet and EJB. It also contains some JSP or Servlet code, which makes the JSP and Servlet code simpler and more readable.

The EJB Client acts as a connection between the XML document and the Database outside the system. In other words, it creates the outgoing XML document from the data base, and conversely plays the role of inputting the external XML document into the data base. As mentioned earlier, this is possible because there is an XDB file.

XML Instance is an XML document created by EJB Client at RunTime. It actually corresponds to the content of the document going out or coming in from the outside.

The Java files created here are created to apply to each Web Application Server. In other words, generate Java source code for Weblogic, J2EE, and WebSphere.

SQL is classified into table create statement and stored procedure. Table Create generates script statements for each database, and Stored Prodedure generates scripts or Java files for the database.

Oracle is a script and DB2 is Java Code. The table create statement executes immediately to create the table, and the stored procedure is used to modify the record input to the table in the EJB.

4) Other auxiliary functions

Auxiliary functions of B2Builder include SQL Manager, document-by-project progress, and other XML document viewers.

SQL Manager is a database management function that allows users to connect to the database and modify the table creation and record input queries. There is a management tool for each database, but to simplify the development process by carrying out the project in one place.

Document-specific management allows you to batch process documents you want to work in in one window. This is also to facilitate project progress and to provide user convenience by processing multiple documents in one place.

The XML document viewer can view the documents required for the project progress.

Use of the present invention

Given the growth rate of the US e-business market, experts predict that the growth rate of the domestic e-business market will increase rapidly in the future.

In other words, the e-business market, which was previously considered the exclusive property of large corporations or logistics companies, can be used as a factor to promote and enter the e-business market as a whole by the present invention, which is an automatic generation tool of this e-business application. Can be.

B2G in government infrastructure demanded enormous cost and large development period. However, the present invention not only significantly reduces the time and cost, but also can be expected to have a great effect in future maintenance, and can be utilized as a key role means for leading the construction of logistics infrastructure at the national level.

It can be used in the e-business market as a tool to reduce the cost and maintenance burden of small businesses.

It can reduce not only the time and cost of developing e-business solutions, but also the additional cost of maintenance and repair, thus ensuring the fairness and transparency of transactions as well as innovation of the national logistics backbone network by entering into the B2B market of large companies and SMEs. Will receive.

Overseas certification of the technology will enable the technical standardization of the e-business solution market in the future, and the construction of a large consortium will increase the influence on the global market.

Easy future scalability with XML documents

The nature of XML documents makes it easy to extend the exchange of electronic documents between companies.

Application of the present invention

Establish a procurement work system for all government agencies, including government procurement and defense procurement

All B2G fields including national tax, customs, local taxes, etc. All B2G sectors E-commerce among domestic companies, including purchase, logistics, distribution, textiles, and trade among foreign companies, and other e-business related systems .

The present invention was made to meet the needs of companies that want to build a B2B system quickly and easily according to the expansion of e-business, and by using the present invention, B2B system development that only a large company can build can be built and maintained very quickly and easily Maintenance is also easy. In addition, it is designed to comply with XML, which will become the standard of documents in the future, so that documents can be exchanged freely between companies.

1) Expected Effect of Technology Development

Innovative Enterprise Application Integration (EAI)

Effective EAI for S / W Integration in Various Operating Environments

Suitable for integrated operation with various existing solutions for building B2B system

B2B system development automation and maintenance innovation

XML processing automation by GUI

XML Tree View and Table View Support

Automatic generation of program source code and table structure with simple GUI operation

Free GUI work including Cut & Paste, Drag & Drop

Maximize productivity in building and maintaining e-business systems

Simplify development process

Automatically build e-business system by importing standard XML documents

Handle EJBs, JavaBeans, SQL, XML documents, and more in one integrated environment

Code generation automatically eliminates the possibility of errors and systematic code management

Efficient e-business system development

Automate the manual development process to shorten innovative development timelines

Automatic generation of session bean (EJB), automatic generation of Java bean

Automatic generation of XML document processing code

Automatic creation of related document of generated program

DB table schema and interface automatic creation

Automatic creation of DB Table Schema from XML Schema

Automatic creation of stored procedures for fast DB interface

Automatic creation of user's desired table structure Easy and easy maintenance

Source Rebuild Function

Change all source codes with just one click when changing XML standard schema

Significantly reduce maintenance costs with easy source code changes

Uniform source structure makes other programmers more readable

Standard XML / EDI Support

Standard XML Schema support such as W3C, ebXML, etc.

Forrester Research in the US predicts that e-commerce will be around $ 1.3 trillion by 2003. In addition, statistics showed that about 75% of Korean companies are willing to switch to e-business, a method of buying and selling via the Internet. In this market expansion, the development of auto-generation tools for e-business applications can be expected to have significant effects in terms of cost and time savings not only for the system currently being deployed but also for the e-business system to be built in the future. .

In addition, for the successful realization of eBusiness business such as eMarketplace, eProcurement, EBPP, B2B Integration, e-CRM, development solutions built on the Internet and XML will have many ripple effects in the domestic market as well as the global market.

Claims (3)

B2B solution (JAVA-based) using JAVA Automatically generate XML document processing program and interface with standard system and related document automatically Method for automatically generating a program for processing XML documents in claim 1 How to automatically generate the interface and related documents with the linked standard system